Snitz to Phpbb2 Convertor
This convertor was initially written for Snitz v3.1 -> phpBB2 RC1 conversion, but later it was upgraded and now it works for Snitz v3.4.03 to phpBB 2.0.6 conversion.
[Update]: Starting with version 1.7, the convertor is compatible with phpbb 2.0.19. For earlier versions of phpBB use earlier versions of the convertor.
How to import:
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)
The last problem:
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
ORDER BY t.topic_type DESC, p2.post_time DESC
If you want to convert from an Access database (.mdb) you can:
You can send me bugs or questions at firstname.lastname@example.org.
last update: March 24, 2006 (version 1.7)