竹貓星球

代碼: 選擇全部

Snitz v3.1 -> phpBB2 rc1
-----------------------

Requirements:
- Snitz 3.1 MySQL database
- phpBB2 rc1 MySQL database
- 15 free minutes

How to import
-------------

Step 1:
First you have to do a clean installation of phpBB2 rc1, 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).

(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
-topics.php (RUN THIS BEFORE RUNNING posts.php)
-posts.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:
Actually, that's all!

Notes
-----

If you want to convert from an Access database (.mdb) you can use MySQL ODBC driver to convert it into a MySQL database.

Contact
-------

You can send me bugs or questions at ralucam@rol.ro or ralucam@mail.com.

Raluca Musaloiu-E.
12 february 2002