A. Identify the MySQL database associated with your phpBB installation

1. Using a text editor (eg. Filezilla, Netfirms File Manager) connect to your Netfirms account
2. Download the following file /www/install_dir/nfphpbb/config.php (where install_dir is the name of the folder that you installed your phpBB forum)
3. Locate the line where it states "$dbname =". The name listed after this is the database name your phpBB uses.
4. Note the database name.

B. To correct your Start Date for your phpBB:

1. Log into your Netfirms Member Area at https://controlpanel.netfirms.com/
2. Click the Site Tools
3. Click Database Manager
4. Click the Admin for the database that you identified above.
5. Click on phpbb_users
<tbl_properties_structure.php?lang=en-iso-8859-1&server=1&db=d60262060&table=phpbb_users>
6. Click Browse
7. Click Edit button for the Username, you wish to edit
8. Open a new web browser window and visit the web site,
http://krijnen.com/time.php.
9. Select the desired time from the options available.
10. Click the Calculate button.
11. Copy the number displayed as the result.
12. Paste the number as the value for the user_regdate field
13. Click Go

The Join Start Date, should be updated now.