Eyga.net (EN)
  • Home
  • Vzorčna stran
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

qTranslate to Multisite migrator

28. 5. 2016/in Nerazvrščeno/by Domen

.

0 0 Domen Domen2016-05-28 12:28:542022-07-01 12:53:20qTranslate to Multisite migrator

How to make phpBB forum read-only

26. 1. 2016/in Code snippets/by Domen

PhpBB forum has an option to disable the forum. In that case no forums and topics are shown.
But what if we want to make the forum read-only. So that anyone can read it and nobody can change the date.

The solution is to give to the account, which phpBB uses to connect to the database, only SELECT permissions.
But that way you will get errors, because the application wants to write session data, etc. into the database.
So these permission changes must be executed for forum to be fully read-only.

Create new account ‘read_only’ and make phpBB use it for connecting to database in file ‘config.php’.
And then execute this code:

GRANT SELECT ON `phpbb_db`.* TO 'read_only'@'localhost';
GRANT INSERT, UPDATE, DELETE ON `phpbb_sessions` TO 'read_only'@'localhost';
GRANT INSERT, UPDATE, DELETE ON `phpbb_sessions_keys` TO 'read_only'@'localhost';
GRANT UPDATE (`config_value`) ON `phpbb_config` TO 'read_only'@'localhost';
GRANT UPDATE (`topic_views`, `topic_last_view_time`) ON `phpbb_topics` TO 'read_only'@'localhost';
GRANT UPDATE (`mark_time`) ON `phpbb_topics_track` TO 'read_only'@'localhost';
GRANT UPDATE (`download_count`) ON `phpbb_attachments` TO 'read_only'@'localhost';
-- Admin
GRANT INSERT, DELETE ON `phpbb_login_attempts` TO 'read_only'@'localhost';
GRANT UPDATE ON `phpbb_users` TO 'read_only'@'localhost';
GRANT INSERT ON `phpbb_log` TO 'read_only'@'localhost';
-- Plugin: Advertisement Management
GRANT UPDATE (`ad_views`, `ad_clicks`) ON `phpbb_ads` TO 'read_only'@'localhost';
-- Plugin: phpBB SEO
GRANT UPDATE (`topic_url`) ON `phpbb_topics` TO 'read_only'@'localhost';
0 0 Domen Domen2016-01-26 19:56:142022-07-01 12:53:20How to make phpBB forum read-only
Search Search

Recent Posts

  • qTranslate to Multisite migrator
  • How to make phpBB forum read-only

Recent Comments

    Archives

    • May 2016
    • January 2016

    Categories

    • Code snippets
    • Nerazvrščeno

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Interesting links

    Here are some interesting links for you! Enjoy your stay :)

    Pages

    • Vzorčna stran

    Categories

    • Code snippets
    • Nerazvrščeno

    Archive

    • May 2016
    • January 2016
    © Copyright - Eyga.net (EN) - Enfold Theme by Kriesi
    Scroll to top Scroll to top Scroll to top