Step 1:
First you have to do a clean installation of phpBB 2.0.6, because my scripts will alter only some of the tables (phpbb_categories, phpbb_forums, phpbb_users, phpbb_groups, phpbb_user_group, phpbb_posts, phpbb_posts_text and phpbb_topics);

Step 2:
Empty these tables:
-phpbb_categories
-phpbb_forums
-phpbb_groups
-phpbb_user_group
-phpbb_posts
-phpbb_posts_text
-phpbb_topics

Don't delete them, only empty :).

Delete from phpbb_users all entries EXCEPT the first one (Anonymous user). You can use this sql query (if Anonymous user has -1 for user_id):

DELETE from phpbb_users where user_id > -1

(yes, I can empty these tables myself but maybe somebody will not read these instructions before running scripts)

Step 3:
Now you have to make proper changes in config.php file (database name, username, password, table's names).

Step 4:
Run:
-members.php
-categories.php
-forums.php
-posts.php (RUN THIS BEFORE RUNNING topics.php)
-topics.php

Step 5:
Somebody must be administrator :) so you have to change the 'user_level' field from 'phpbb_users' table. Default value is 0. Change it into 1 and that user will be administrator.

Step 6:
In the last versions of Snitz most likely the passwords are encrypted and my convertor can't decrypt them and encrypt in phpbb style (the encryption function is not reversible). So, if you experience this problem (can't logon) just use password recovery function and you'll get a new one. Advise all your users to do the same :).

Step 7:
Logon as administrator and run Resync on all forums (from Configuration Panel, Forum Admin then Management).

Step 8:
Actually, that's all!

You will notice that the topics are not sorted in the right order, more precisely, the topics with no replies will be on top. To fix this you have to modify viewforum.php and replace this line:

ORDER BY t.topic_type DESC, t.topic_last_post_id DESC

with:

ORDER BY t.topic_type DESC, p2.post_time DESC

If you want to convert from an Access database (.mdb) you can:
- use MySQL ODBC driver to convert it to a MySQL database or
- use a program called AccessDump to convert a .mdb file into a sql dump file.

You can send me bugs or questions at raluca@musaloiu.com.

Raluca Musaloiu-E.
March 24, 2006

last update: March 24, 2006 (version 1.7)