phpBB.de

Code: Alles auswählen

//USER
INSERT INTO phpbb_users (user_id,username,username_clean,user_password,user_type,group_id,user_email,user_regdate,user_posts,user_lastvisit,user_ip) (select userID,username,username,password,'0','2',email,registrationDate,posts,lastActivityTime,registrationIpAddress from wcf1_user natural join wbb1_1_user where wcf1_user.userID>'2');

//USERGROUP
INSERT INTO phpbb_user_group
(group_id,user_id,group_leader,user_pending)
(select group_id, user_id,'0','0' from phpbb_users where user_id>2);

//FOREN
INSERT INTO phpbb_forums
(forum_id,parent_id,forum_name,forum_desc,forum_last_post_id)
(select boardID,parentID,title,description from wbb1_1_board);

//POSTS
INSERT INTO phpbb_posts
(post_id,topic_id,poster_id,post_username,post_time,post_subject,post_text,poster_ip)
(select postID,threadID,userID,username,time,subject,message,ipAddress from wbb1_1_post);

//THREADS TOPICS
INSERT INTO phpbb_topics
(topic_id,forum_id,topic_title,topic_replies,topic_views,topic_first_poster_name,topic_last_poster_name,topic_first_post_id,topic_last_poster_id,topic_last_post_time)
(select threadID,boardID,topic,replies,views,username,lastPoster,userID,lastPosterID,lastPostTime from wbb1_1_thread);