Mysql> update user set Create_routine_priv='Y',Alter_routine_priv='Y',Show_db_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y' where User='phpbb' įor more on MySQL use and administration see the YoLinux MySQL tutorial. Mysql> update user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_user_priv='Y',Event_priv='Y',Trigger_priv='Y',Create_tablespace_priv='Y' where User='phpbb' Mysql> GRANT SELECT,INSERT,UPDATE,DELETE on phpbb.* to identified by 'phpbb' Mysql> SET PASSWORD FOR = PASSWORD('supersecretpassword') Mysql> GRANT ALL PRIVILEGES ON phpbb.* TO IDENTIFIED BY 'supersecretpassword' In MySQL, generate a new database (eg phpbb), generate a new MySQL user for that database: MySQL "Safe Mode": If turned on, database connection functions that specify default values will use those values in place of any user-supplied arguments. This tutorial includes details on installing a social plugin which can be configured to use one of many "social logins" including Facebook. PhpBB has some SPAM mitigation techniques but none is more effective than using a social login where the social platform performs the vetting of users. Within hours of installing a forum you will start to get hundreds of SPAM posts. ![]() One of the primary problems encountered in running a web forum is SPAM from those seeking to use your platform for the generation of back-links for SEO purposes. PhpBB supports many themes for various design interfaces and user presentations including one detailed here to support responsive web design. Mobile support is now more important than ever and using a "responsive" web design which allows a site to conform to the user platform using CSS crafted to alter the web page based on the platform (desktop, tablet or smart phone). One of the favored forum software platforms by both by users and by number of instalations is is PhpBB, an Open Source, PHP based forum that this tutorial seeks to detail its installation and configuration. They usually have a hierarchical organization of forums and sub-forums, each with threads of discussion or topics.įorums typically have "moderators" who interface with users of a forum or sub-forum and "administrators" with privileges to manage the technical details of the site.įorum features include emoticon symbol support, polls, direct forum member communication, display of forum stats, user profiles, media support (videos, images, etc), word censoring, bot detection, etc. But again, this all within the realm of update tweaks and fixes - not re-writing - which seems to imply starting over with all your extensions.Forums or message boards have been around as a medium for discussion and posting information since the dawn of the Internet. At worst, phpBB 4.0 could get a total style overhaul which would mean some style changes to your extension's style template files. Perhaps also the chance to take advantage of some of the newer features introduced within phpBB or any of its frameworks. What can be expected, eventually, is some code updates depending on the extension and what it uses. For me as of my last experiment, all my personal as well as all official phpBB extension work as-is in the current development build of 4.0 without needing any code changed. ![]() ![]() What I don't like is the fact that I have wasted several thousand hours creating extensions that will not work with phpBB4 and that this fact is summarily dismissed as being a case that all extensions will need to be re-writtenĪs of right now, most extensions shouldn't need to be "re-written" for 4.0.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |