phpBB3 Installation

1. Download phbBB
http://www.phpbb.com/downloads/?sid=d8daf7d9885ef06e9549b46a26a37455
2. untar phpBB-3.0.2.tar.bz2
3. Installation Quick Quide:
http://www.phpbb.com/support/documentation/
http://www.phpbb.com/support/documentation/3.0/
4. Create a database called:
phpbb
5. grant to give the username and remove the brackets
5.1. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON phpbb.* TO @localhost IDENTIFIED BY 'user password here';
5.2.FLUSH PRIVILEGES;
6. /localhost/phpBB3/ or /local/phpBB3/install/index.php
7. Website Installation follow the procedure
8. Change the permissions on config.php to be writable by all (666 or -rw-rw-rw- within your FTP Client)
http://www.phpbb.com/support/documents.php?mode=install&version=3#quickinstall
10. To create a forum login in as admin
11. Click Adminstration Control Panel (center below the forum)

II. Adding Ads to phpBB3
http://www.phpbb.com/kb/article/advertisements-in-phpbb3/

III. Stop Spam
Update 2006-08-22: The fake users keep coming. So I came up with a cron job that runs this query once per day. It will remove inactive PHPBB users older than 48 hours. This gives time for the new users to properly activate.

DELETE FROM phpbb_users WHERE user_active=0 AND user_id>0 AND FROM_UNIXTIME(user_regdate)
The user_id>0 part is to avoid deleting the Anonymous user, which has a user ID of -1 on my installation.

http://boonedocks.net/mike/archives/124-PHPBB-Fake-Members.html

IV. Delete User:
open php my admin and you can run this query:

DELETE FROM phpbb_users WHERE user_id !=2

http://www.webmaster-talk.com/php-forum/64968-phpbb-forum-delete-all-users.html