Comanchero
Full Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Ковертер переносит базу юзеров, постов и т.д. из форума phpBB 2.* в phpNuke 6.*/7. Лично проверенно на нюке 6,9 и 7 и форуме phpBB 2.06. Перенес ВСЁ! Глюков пока не обнаружено. Заслуги не мои а ребят с указанного в скрипте сайта. НЕ ЗАБЫВАЕМ СОХРАНИТЬ БАЗУ НЮКИ И ФОРУМА ПЕРЕД НАЧАЛОМ ОПЕРАЦИИ!!!!!!!! Правила пользования: копируем скрипт, создаем текстовый файл, обзываем например phpbb2phpnuke.php, вставляем туда скрипт, в начале скрипта изменяем строчки под этим пунктом "//phpBB2 variables" в соответствии с конфигом имеющегося у нас форума phpBB2, кладём файл в корень нюки туда где у нас лежит config.php и запускаем через браузер. 10 секунд шуршания и всё! В браузере видим открывшуюся страничку с информацией о пхп в случае удачи. В случае неудачи белая пустая страничка. НЕ ЗАБЫВАЕМ СОХРАНИТЬ БАЗУ НЮКИ И ФОРУМА ПЕРЕД НАЧАЛОМ ОПЕРАЦИИ!!!!!!!! Успехов! Цитата: ******************************** <?php /******************************* * phpBB2 to BB2Nuke (c) 2003 Andareed * Fixed June 2003 UKForums - http://www.ruleit.co.uk/nuke * * This converter is released under the GNU GPL license * * You will need to manually edit/update your config table *********************************/ // MODIFY THE ENTRIES BELOW TO YOU DATABASE!!! set_time_limit(0); include ("config.php"); //phpBB2 variables $p_user="phpbb database uname"; $p_pass="phpbb database pass"; $p_db="phpbb database name"; $p_host="localhost"; $p_prefix="phpbb"; // DO NOT MODIFY ANYTHING BELOW !!! //PHP-Nuke Variables from config.php $n_user="$dbuname"; $n_pass="$dbpass"; $n_db="$dbname"; $n_host="$dbhost"; $n_prefix="$prefix"; //connect to db's $p_con=mysql_connect($p_host,$p_user,$p_pass); $n_con=mysql_connect($n_host,$n_user,$n_pass); error_reporting(E_ALL); // DELETE OLD TABLE DATA mysql_select_db($n_db,$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbauth_access",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbbanlist",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbcategories",$n_con) or mysql_error(); //mysql_query("DELETE FROM {$n_prefix}_bbconfig",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbdisallow",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbforum_prune",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbforums",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbgroups",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbposts",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbposts_text",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs_text",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbranks",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbsearch_results",$n_con) or mysql_error(); //mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordlist",$n_con) or mysql_error(); //mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordmatch",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbsessions",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbsmilies",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbthemes",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbthemes_name",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbtopics",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbtopics_watch",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbuser_group",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_users",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbvote_desc",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbvote_results",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbvote_voters",$n_con) or mysql_error(); mysql_query("DELETE FROM {$n_prefix}_bbwords",$n_con) or mysql_error(); // START EXPORTING/IMPORTING global $row,$result,$count; mysql_select_db($p_db,$p_con); // phpbb_auth_access mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_auth_access",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbauth_access SET group_id='{$row['group_id']}', forum_id='{$row['forum_id']}', auth_view='{$row['auth_view']}', auth_read='{$row['auth_read']}', auth_post='{$row['auth_post']}', auth_reply='{$row['auth_reply']}', auth_edit='{$row['auth_edit']}', auth_delete='{$row['auth_delete']}', auth_sticky='{$row['auth_sticky']}', auth_announce='{$row['auth_announce']}', auth_vote='{$row['auth_vote']}', auth_pollcreate='{$row['auth_pollcreate']}', auth_attachments='{$row['auth_attachments']}', auth_mod='{$row['auth_mod']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_banlist mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_banlist",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_banlist SET ban_id='{$row['ban_id']}', ban_userid='{$row['ban_userid']}', ban_ip='{$row['ban_ip']}', ban_email='{$row['ban_email']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_categories mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_categories",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbcategories SET cat_id='{$row['cat_id']}', cat_title='{$row['cat_title']}', cat_order='{$row['cat_order']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_config /*mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_config",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbconfig SET config_name='{$row['config_name']}', config_value='{$row['config_value']}' ",$n_con) or mysql_error(); } mysql_free_result($result);*/ // phpbb_disallow mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_disallow",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbdisallow SET disallow_id='{$row['disallow_id']}', disallow_username='{$row['disallow_username']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_forum_prune // FIXED BY UKFORUMS mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_forum_prune",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbforum_prune SET prune_id='{$row['prune_id']}', forum_id='{$row['forum_id']}', prune_days='{$row['prune_days']}', prune_freq='{$row['prune_freq']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_forums mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_forums",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbforums SET forum_id='{$row['forum_id']}', cat_id='{$row['cat_id']}', forum_name='{$row['forum_name']}', forum_desc='{$row['forum_desc']}', forum_status='{$row['forum_status']}', forum_order='{$row['forum_order']}', forum_posts='{$row['forum_posts']}', forum_topics='{$row['forum_topics']}', forum_last_post_id='{$row['forum_last_post_id']}', prune_next='{$row['prune_next']}', prune_enable='{$row['prune_enable']}', auth_view='{$row['auth_view']}', auth_read='{$row['auth_read']}', auth_post='{$row['auth_post']}', auth_reply='{$row['auth_reply']}', auth_edit='{$row['auth_edit']}', auth_delete='{$row['auth_delete']}', auth_sticky='{$row['auth_sticky']}', auth_announce='{$row['auth_announce']}', auth_vote='{$row['auth_vote']}', auth_pollcreate ='{$row['auth_pollcreate']}', auth_attachments ='{$row['auth_attachments']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_groups mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_groups",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbgroups SET group_id='{$row['group_id']}', group_type='{$row['group_type']}', group_name='{$row['group_name']}', group_description='{$row['group_description']}', group_moderator='{$row['group_moderator']}', group_single_user='{$row['group_single_user']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_posts mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_posts",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbposts SET post_id='{$row['post_id']}', topic_id='{$row['topic_id']}', forum_id='{$row['forum_id']}', poster_id='{$row['poster_id']}', post_time='{$row['post_time']}', poster_ip='{$row['poster_ip']}', post_username='{$row['post_username']}', enable_bbcode='{$row['enable_bbcode']}', enable_html='{$row['enable_html']}', enable_smilies='{$row['enable_smilies']}', enable_sig='{$row['enable_sig']}', post_edit_time='{$row['post_edit_time']}', post_edit_count='{$row['post_edit_count']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_posts_text mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_posts_text",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbposts_text SET post_id='{$row['post_id']}', bbcode_uid='{$row['bbcode_uid']}', post_subject='{$row['post_subject']}', post_text='{$row['post_text']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_privmsgs mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_privmsgs",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs SET privmsgs_id='{$row['privmsgs_id']}', privmsgs_type='{$row['privmsgs_type']}', privmsgs_subject='{$row['privmsgs_subject']}', privmsgs_from_userid='{$row['privmsgs_from_userid']}', privmsgs_to_userid='{$row['privmsgs_to_userid']}', privmsgs_date='{$row['privmsgs_date']}', privmsgs_ip='{$row['privmsgs_ip']}', privmsgs_enable_bbcode='{$row['privmsgs_enable_bbcode']}', privmsgs_enable_html='{$row['privmsgs_enable_html']}', privmsgs_enable_smilies='{$row['privmsgs_enable_smilies']}', privmsgs_attach_sig='{$row['privmsgs_attach_sig']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_privmsgs_text mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_privmsgs_text",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs_text SET privmsgs_text_id='{$row['privmsgs_text_id']}', privmsgs_bbcode_uid='{$row['privmsgs_bbcode_uid']}', privmsgs_text='{$row['privmsgs_text']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_ranks mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_ranks",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbranks SET rank_id='{$row['rank_id']}', rank_title='{$row['rank_title']}', rank_min='{$row['rank_min']}', rank_special='{$row['rank_special']}', rank_image='{$row['rank_image']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_search_results mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_search_results",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbsearch_results SET search_id='{$row['search_id']}', session_id='{$row['session_id']}', search_array='{$row['search_array']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_search_wordlist /*mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_search_wordlist",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordlist SET word_text='{$row['word_text']}', word_id='{$row['word_id']}', word_common='{$row['word_common']}' ",$n_con) or mysql_error(); } mysql_free_result($result);*/ // phpbb_search_wordmatch /*mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_search_wordmatch",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordmatch SET post_id='{$row['post_id']}', word_id='{$row['word_id']}', title_match='{$row['title_match']}' ",$n_con) or mysql_error(); } mysql_free_result($result);*/ // phpbb_sessions mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_sessions",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbsessions SET session_id='{$row['session_id']}', session_user_id='{$row['session_user_id']}', session_start='{$row['session_start']}', session_time='{$row['session_time']}', session_ip='{$row['session_ip']}', session_page='{$row['session_page']}', session_logged_in='{$row['session_logged_in']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_smilies mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_smilies",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbsmilies SET smilies_id='{$row['smilies_id']}', code='{$row['code']}', smile_url='{$row['smile_url']}', emoticon='{$row['emoticon']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_themes mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_themes",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbthemes SET themes_id='{$row['themes_id']}', template_name='{$row['template_name']}', style_name='{$row['style_name']}', head_stylesheet='{$row['head_stylesheet']}', body_background='{$row['body_background']}', body_bgcolor='{$row['body_bgcolor']}', body_text='{$row['body_text']}', body_link='{$row['body_link']}', body_vlink='{$row['body_vlink']}', body_alink='{$row['body_alink']}', body_hlink='{$row['body_hlink']}', tr_color1='{$row['tr_color1']}', tr_color2='{$row['tr_color2']}', tr_color3='{$row['tr_color3']}', tr_class1='{$row['tr_class1']}', tr_class2='{$row['tr_class2']}', tr_class3='{$row['tr_class3']}', th_color1='{$row['th_color1']}', th_color2='{$row['th_color2']}', th_color3='{$row['th_color3']}', th_class1='{$row['th_class1']}', th_class2='{$row['th_class2']}', th_class3='{$row['th_class3']}', td_color1='{$row['td_color1']}', td_color2='{$row['td_color2']}', td_color3='{$row['td_color3']}', td_class1='{$row['td_class1']}', td_class2='{$row['td_class2']}', td_class3='{$row['td_class3']}', fontface1='{$row['fontface1']}', fontface2='{$row['fontface2']}', fontface3='{$row['fontface3']}', fontsize1='{$row['fontsize1']}', fontsize2='{$row['fontsize2']}', fontsize3='{$row['fontsize3']}', fontcolor1='{$row['fontcolor1']}', fontcolor2='{$row['fontcolor2']}', fontcolor3='{$row['fontcolor3']}', span_class1='{$row['span_class1']}', span_class2='{$row['span_class2']}', span_class3='{$row['span_class3']}', img_size_poll='{$row['img_size_poll']}', img_size_privmsg='{$row['img_size_privmsg']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_themes_name mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_themes_name",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbthemes_name SET themes_id='{$row['themes_id']}', tr_color1_name='{$row['tr_color1_name']}', tr_color2_name='{$row['tr_color2_name']}', tr_color3_name='{$row['tr_color3_name']}', tr_class1_name='{$row['tr_class1_name']}', tr_class2_name='{$row['tr_class2_name']}', tr_class3_name='{$row['tr_class3_name']}', th_color1_name='{$row['th_color1_name']}', th_color2_name='{$row['th_color2_name']}', th_color3_name='{$row['th_color3_name']}', th_class1_name='{$row['th_class1_name']}', th_class2_name='{$row['th_class2_name']}', th_class3_name='{$row['th_class3_name']}', td_color1_name='{$row['td_color1_name']}', td_color2_name='{$row['td_color2_name']}', td_color3_name='{$row['td_color3_name']}', td_class1_name='{$row['td_class1_name']}', td_class2_name='{$row['td_class2_name']}', td_class3_name='{$row['td_class3_name']}', fontface1_name='{$row['fontface1_name']}', fontface2_name='{$row['fontface2_name']}', fontface3_name='{$row['fontface3_name']}', fontsize1_name='{$row['fontsize1_name']}', fontsize2_name='{$row['fontsize2_name']}', fontsize3_name='{$row['fontsize3_name']}', fontcolor1_name='{$row['fontcolor1_name']}', fontcolor2_name='{$row['fontcolor2_name']}', fontcolor3_name='{$row['fontcolor3_name']}', span_class1_name='{$row['span_class1_name']}', span_class2_name='{$row['span_class2_name']}', span_class3_name='{$row['span_class3_name']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_topics mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_topics",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbtopics SET topic_id='{$row['topic_id']}', forum_id='{$row['forum_id']}', topic_title='{$row['topic_title']}', topic_poster='{$row['topic_poster']}', topic_time='{$row['topic_time']}', topic_views='{$row['topic_views']}', topic_replies='{$row['topic_replies']}', topic_status='{$row['topic_status']}', topic_vote='{$row['topic_vote']}', topic_type='{$row['topic_type']}', topic_first_post_id='{$row['topic_first_post_id']}', topic_last_post_id='{$row['topic_last_post_id']}', topic_moved_id='{$row['topic_moved_id']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_topics_watch mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_topics_watch",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbtopics_watch SET topic_id='{$row['topic_id']}', user_id='{$row['user_id']}', notify_status='{$row['notify_status']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_user_group mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_user_group",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbuser_group SET group_id='{$row['group_id']}', user_id='{$row['user_id']}', user_pending='{$row['user_pending']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_users //FIXED BY UKFORUMS mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_users",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); $row['user_regdate'] = date("M j, Y", $row['user_regdate']); mysql_query("INSERT INTO {$n_prefix}_users SET user_id='{$row['user_id']}', user_active='{$row['user_active']}', name='{$row['username']}', username='{$row['username']}', user_password='{$row['user_password']}', user_session_time='{$row['user_session_time']}', user_session_page='{$row['user_session_page']}', user_lastvisit='{$row['user_lastvisit']}', user_regdate='{$row['user_regdate']}', user_level='{$row['user_level']}', user_posts='{$row['user_posts']}', user_timezone='{$row['user_timezone']}', user_style='{$row['user_style']}', user_lang='{$row['user_lang']}', user_dateformat='{$row['user_dateformat']}', user_new_privmsg='{$row['user_new_privmsg']}', user_unread_privmsg='{$row['user_unread_privmsg']}', user_last_privmsg='{$row['user_last_privmsg']}', user_emailtime='{$row['user_emailtime']}', user_viewemail='{$row['user_viewemail']}', user_attachsig='{$row['user_attachsig']}', user_allowhtml='{$row['user_allowhtml']}', user_allowbbcode='{$row['user_allowbbcode']}', user_allowsmile='{$row['user_allowsmile']}', user_allowavatar='{$row['user_allowavatar']}', user_allow_pm='{$row['user_allow_pm']}', user_allow_viewonline='{$row['user_allow_viewonline']}', user_notify='{$row['user_notify']}', user_notify_pm='{$row['user_notify_pm']}', user_popup_pm='{$row['user_popup_pm']}', user_rank='{$row['user_rank']}', user_avatar='{$row['user_avatar']}', user_avatar_type='{$row['user_avatar_type']}', user_email='{$row['user_email']}', user_icq='{$row['user_icq']}', user_website='{$row['user_website']}', user_from='{$row['user_from']}', user_sig='{$row['user_sig']}', user_sig_bbcode_uid='{$row['user_sig_bbcode_uid']}', user_aim='{$row['user_aim']}', user_yim='{$row['user_yim']}', user_msnm='{$row['user_msnm']}', user_occ='{$row['user_occ']}', user_interests='{$row['user_interests']}', user_actkey='{$row['user_actkey']}', user_newpasswd='{$row['user_newpasswd']}' ",$n_con) or mysql_error(); } mysql_free_result($result); // phpbb_vote_desc mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_vote_desc",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con) or mysql_error(); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbvote_desc SET vote_id='{$row['vote_id']}', topic_id='{$row['topic_id']}', vote_text='{$row['vote_text']}', vote_start='{$row['vote_start']}', vote_length='{$row['vote_length']}' ",$n_con); } mysql_free_result($result); // phpbb_vote_results mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_vote_results",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbvote_results SET vote_id='{$row['vote_id']}', vote_option_id='{$row['vote_option_id']}', vote_option_text='{$row['vote_option_text']}', vote_result='{$row['vote_result']}' ",$n_con); } mysql_free_result($result); // phpbb_vote_voters mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_vote_voters",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbvote_voters SET vote_id='{$row['vote_id']}', vote_user_id='{$row['vote_user_id']}', vote_user_ip='{$row['vote_user_ip']}' ",$n_con); } mysql_free_result($result); // phpbb_words mysql_select_db($p_db,$p_con); $result=mysql_query("SELECT * FROM {$p_prefix}_words",$p_con); $count=mysql_num_fields($result); mysql_select_db($n_db,$n_con); while($row=mysql_fetch_array($result)) { fixQuotes(); mysql_query("INSERT INTO {$n_prefix}_bbwords SET word_id='{$row['word_id']}', word='{$row['word']}', replacement='{$row['replacement']}' ",$n_con); } mysql_free_result($result); function fixQuotes() { global $row,$result,$count; for($i=0;$i<$count;$i++) { $field=mysql_field_name($result,$i); $row[$field]=str_replace("'","\'",$row[$i]); } } phpinfo(); ?> ****************************************** |
| Всего записей: 425 | Зарегистр. 16-01-2002 | Отправлено: 13:08 08-01-2004 | Исправлено: Antuan, 14:40 08-01-2004 |
|