PHPBoost CMS

-- Ajout des membres 
DELETE FROM `phpbb_users` WHERE user_type = 2;
INSERT INTO `phpboost_member` (`user_id`, `login`, `password`, `level`, `user_groups`, `user_lang`, `user_theme`, `user_mail`, `user_show_mail`, `user_editor`, `user_timezone`, `timestamp`, `user_avatar`, `user_msg`, `user_local`, `user_msn`, `user_yahoo`, `user_web`, `user_occupation`, `user_hobbies`, `user_desc`, `user_sex`, `user_born`, `user_sign`, `user_pm`, `user_warning`, `user_readonly`, `last_connect`, `test_connect`, `activ_pass`, `new_pass`, `user_ban`, `user_aprob`) SELECT user_id, username, user_password, CASE WHEN user_type = 3 THEN 2 ELSE 0 END, '', 'french', '', user_email, 0, 'bbcode', CAST(user_timezone AS SIGNED), user_regdate, user_avatar, user_posts, user_from, user_msnm, user_yim, user_website, user_occ, user_interests, '', 0, 0, user_sig, 0, 0, 0, 0, 0, '', '', 0, 1 FROM `phpbb_users`;

-- Ajout des catégories 
INSERT INTO `phpboost_forum_cats` (`id`, `id_left`, `id_right`, `level`, `name`, `subname`, `nbr_topic`, `nbr_msg`, `last_topic_id`, `status`, `aprob`, `auth`, `url`) SELECT forum_id, left_id, right_id, CASE WHEN SUBSTR(forum_parents, 3, 1) = '' THEN 0 ELSE CAST(SUBSTR(forum_parents, 3, 1) AS SIGNED) END, forum_name, forum_desc, forum_topics, forum_posts, (SELECT phpbb_posts.topic_id FROM `phpbb_posts` WHERE phpbb_posts.post_id = phpbb_forums.forum_last_post_id), 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;s:2:"r2";i:7;}', forum_link FROM `phpbb_forums`;