|
Just completed my manual/hack migration from phpBB 2.0.22 to ccboard 1.1 I've got an incomplete set of raw SQL scripts that those of you with more database experience could use to help you get started with the move. The big missing piece is with the migration of users. If you have a completely clean install into ccboard/joomla, then it will make the move easier, as you can use the existing phpBB user ids and leave all the relationships as is. You will also have to manually update the user/group relationship tables in Joomla (jos_core_acl_aro & jos_core_acl_groups_aro_map)....I didn't include those scripts, since what I did likely won't work for your situation.I've also ignored attachments, since I didn't have any to move...so you'll have to add that yourself... Provided as-is... Good luck SELECT
A.user_id,
A.username,
A.username,
A.user_email,
A.user_password,
'Registered',
0,
0,
18,
FROM_UNIXTIME(A.user_regdate),
FROM_UNIXTIME(A.user_lastvisit),
'',
''
FROM
phpbb_users A # SELECT
A.user_id,
NULL,
NULL,
A.user_sig,
NULL,
0,
A.user_posts,
NULL,
user_website,
user_icq,
user_aim,
user_msnm,
user_yim,
NULL,
NULL,
NULL,
0,
0,
0,
0,
0
FROM
phpbb_users A # SELECT
cat_id,cat_title,cat_order
FROM
phpbb_categories # SELECT A.forum_id,A.forum_name,A.forum_desc, A.cat_id,A.forum_topics,A.forum_posts,
B.poster_id,B.post_time,
A.forum_last_post_id,1,0,0,18,23,NULL,A.forum_order,0,0,
C.username
FROM
phpbb_forums A,
phpbb_posts B,
phpbb_users C
WHERE
A.forum_last_post_id = B.Post_ID
AND B.Poster_ID = C.User_ID
# SELECT
A.topic_id,
A.forum_id,
A.topic_title,
A.topic_replies,
A.topic_views,
A.topic_time,
A.topic_poster,
B.post_time,
A.topic_last_post_id,
B.poster_id as last_poster ,
A.topic_first_post_id,
A.topic_type,
0,
NULL,
0,
0,
C2.username as poster_username,
C1.username as last_poster_username,
NULL
FROM
phpbb_topics A,
phpbb_posts B,
phpbb_users C1,
phpbb_users C2
WHERE
A.topic_last_post_id = B.post_id
AND B.poster_id = C1.user_id
AND A.topic_poster = C2.user_id
#
SELECT A.post_id,A.topic_id,A.forum_id, B.post_subject,B.post_text,
A.poster_id,A.post_time,A.poster_ip, 0, 0, A.post_edit_time, NULL,
C.username
FROM
phpbb_posts A,
phpbb_posts_text B,
phpbb_users C
WHERE
A.post_id = B.post_id
AND A.poster_id = C.user_id |
Community 
