هذا السكربت دمج المنتدىمع المجلة لنعطيه حقة من النقاش

مشاركةبواسطة **almjed** » الخميس إبريل 15, 2004 6:03 pm

??? ???? ?????? ??????
?????? ?????? ?? ????? ????? ?????? ??? ??? ??????? ???? ??? ???? ??????? ?????? ???? ?? ???? ?????? ???????? ??? ???? ???? ????? ?? ??? ??????? ?? ?????? ?? ???? ????? ??? ?? ?????? ???? ??? ?? ??????? ??? ????? ?? ???? ???? ?? ????? ?????? http://www.coffee4arab.com/phpbb2/viewtopic.php?t=5806 ???? ?? ?????? ?? ???? ??? ??????? ??? ??????? ???? ??? ???? ???? ??? ??? ??? ???? ??????? ??????? ???? ????? ?????? ???????? ... ??? ?????

كود: تحديد الكل

   
<?php 

// ??? ???????? ???????!!! 

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"; 


// ?? ???? ?????? ??? !!! 


//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(); 
?>

????? ????????? :

- ???? ??? ???????? ??? ????? ??? ???? ??? config.php ( ?????? ?? ???? ??? ???????? ?? ??? ????? :phpbbnuke.php ) ???? ??? ????? ???? :
http://www.yoursite.com/phpbbnuke.php

- ??? ?? ???? ??????? ??????? ?? ?????? ???? ?? ???? ???? ???? ???????? ???????? ??? ???? ????? ?????

????? ?? ?? ???????

???? ??? 8O

?? ?????? ??????

???? ??? ??? ???? ??? ?? ??????? ??? ?? ??? ???? ???? ????? ????

- ??? ?? ???? ??????? ??????? ?? ?????? ???? ?? ???? ???? ???? ???????? ???????? ??? ???? ????? ?????

????? ?? ??? ????? ?????

مشاركةبواسطة **almjed** » الأحد مايو 02, 2004 9:00 am

?????? ??????? ???? ???? ????? ????? ?? ?????? ??? ??????? ??? ?? ?????? ?????? ??? ???? ?????? 8O

مشاركةبواسطة **almjed** » الجمعة مايو 07, 2004 6:33 pm

?????? ???? ??? ????? ?? ?????? ????? ????? ???? ????? ???? ???

??? ????
??? ??????? ????? ??? ?????? ???????5.5 phpnuke5.5 ???????? vb2.2.2
=========================
?????? ???? :
??? ?? ???? ????? ?????? ?????? ???????? ?? ????? ?????? ????? . ???? ??? ???? ??????? ??????? ????? ??? ????? ???????
???? ??? ???? ?? ???? ????? ?????? ??? ?? ????? ??????? ???? nuke_users ?????? ??? ????? ????? ????? ????? ?????? ?? ???? ????? ???????? ???????? phpmyadmin ???? ?????? ?????? ?????? ?? ?????? ???? ??? ????? ????? ????? ???
INSERT INTO nuke_users VALUES (1
???? ??? ???? ????? ????? 1 ????? ?????? ???? ????? ?? ??? ??? ??? ??? ????? ??? ????? ??????? ???? ??? ???? ???????? ???? 100 ??? ???? ????? ????? ????? ?????? ???? ??? ???? ?????? ?? ?????? ????? ?????? 101 ????? ???????? ??? ????? ???????
==========================
????? ??????? :
1- ???? ???? ????? transfer_vb_users.php ??? ???? ?????? .
2- ???? ?????? ??? ????????? ??? ????? ??????? ??? :
register.php
member.php
admin/user.php
?????????? ?????? ?????? :
???? ?????? ??? register.php ????? ?? ?????? ???????

--------------------------------------------------------------------------------

$DB_site->query("INSERT INTO user
(userid,username,password,email,".$newstylefield."parentemail,coppauser,
homepage,icq,aim,yahoo,signature,adminemail,showem

ail,invisible,usertitle
,joindate,cookieuser,daysprune,lastvisit,lastactiv

ity,usergroupid,timezoneof
fset,email???ification,receivepm,emailonpm,options

,birthday,maxposts,start
ofweek,ipaddress,pmpopup,referrerid,nosessionhash,

avatarid) VALUES
(NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5
($password))."','".addslashes(htmlspecialchars
($email))."',".$newstyleval."'".addslashes(htmlspecialchars
($parentemail))."','$coppauser','".addslashes(htmlspecialchars
($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes
(htmlspecialchars($aim))."','".addslashes(htmlspecialchars
($yahoo))."','".addslashes
($signature)."','$adminemail','$showemail','$invisible','".addslashes
($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time
()."','".time()."','$newusergroupid','".addslashes
($timezoneoffset)." ','$email???ification','$receivepm','$emailonpm','

$options'
,'".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes
($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes
($testreferrerid['userid'])."','$nosessionhash','$avatarid')");
$userid=$DB_site->insert_id();

--------------------------------------------------------------------------------

??? ????? ?????? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("INSERT INTO nuke_users
(uid,uname,pass,email,url,user_icq,user_aim,user_y

im) VALUES
('$userid','".addslashes(htmlspecialchars($username))."','".addslashes(md5
($password))."','".addslashes(htmlspecialchars($email))."','".addslashes
(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars
($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes
(htmlspecialchars($yahoo))."')");

--------------------------------------------------------------------------------

============================
???? ?????? ??? member.php ????? ?? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE user SET password='".addslashes
(md5($newpassword))."' WHERE userid=$userinfo[userid]");

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE nuke_users SET pass='".addslashes
(md5($newpassword))."' WHERE uid=$userinfo[userid]");

--------------------------------------------------------------------------------

?? ???? ?? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE user SET birthday='".addslashes
($birthday)."',signature='".addslashes($signature)."',customtitle='".intval
($customtitle)."',usertitle='".addslashes($customtext)."',email='".addslashes
(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars
($parentemail))."',coppauser='$coppauser',homepage='".addslashes
(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars
($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes
(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]'
WHERE userid='$bbuserinfo[userid]'");

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE nuke_users SET email='".addslashes
(htmlspecialchars($email))."',url='".addslashes(htmlspecialchars
($homepage))."',user_icq='".addslashes(htmlspecialchars
($icq))."',user_aim='".addslashes(htmlspecialchars
($aim))."',user_yim='".addslashes(htmlspecialchars($yahoo))."' WHERE
uid='$bbuserinfo[userid]'");

--------------------------------------------------------------------------------

??? ??? ????? ???? ?? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE user SET password='".addslashes
(md5($newpassword))."',usergroupid='$bbuserinfo[usergroupid]' WHERE
userid='$bbuserinfo[userid]'");

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE nuke_users SET pass='".addslashes
(md5($newpassword))."' WHERE uid='$bbuserinfo[userid]'");

--------------------------------------------------------------------------------

???? ???? ?????? ??? user.php ??????? ?? ???? admin
admin/user.php
???? ?????? ?? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("INSERT INTO user
(userid,usergroupid,username,password,email,stylei

d,parentemail,coppaus
er,homepage,icq,aim,yahoo,signature,adminemail,sho

wemail,invisible,usert
itle,customtitle,joindate,cookieuser,daysprune,las

tvisit,lastactivity,lastpost,p
osts,timezoneoffset,email???ification,receivepm,em

ailonpm,ipaddress,pmpo
pup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes
(htmlspecialchars($ausername))."','".addslashes(md5
($apassword))."','".addslashes(htmlspecialchars
($email))."','$userstyleid','".addslashes(htmlspecialchars
($parentemail))."','$coppauser','".addslashes(htmlspecialchars
($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes
(htmlspecialchars($aim))."','".addslashes(htmlspecialchars
($yahoo))."','".addslashes
($signature)."','$adminemail','$showemail','$invisible','".addslashes
($usertitle)." ','$customtitle',$joindate,'$cookieuser','$dayspru

ne',$lastvisit,$l
astactivity,$lastpost,'$posts','$timezoneoffset','

$email???ification','$receive
pm','$emailonpm','".addslashes
($aipaddress)."','$pmpopup','$options','$birthday')");
$userid=$DB_site->insert_id();

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("INSERT INTO nuke_users
(uid,uname,pass,email,url,user_icq,user_aim,user_y

im) VALUES
('$userid','".addslashes(htmlspecialchars($ausername))."','".addslashes
(md5($apassword))."','".addslashes(htmlspecialchars
($email))."','".addslashes(htmlspecialchars($homepage))."','".addslashes
(htmlspecialchars($icq))."','".addslashes(htmlspecialchars
($aim))."','".addslashes(htmlspecialchars($yahoo))."')");

--------------------------------------------------------------------------------

?? ???? ?????? ?? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE user SET
birthday='$birthday',options='$options',usergroupi

d='$usergroupid',usernam
e='".addslashes(htmlspecialchars
($ausername))."'$pwdinclude,email='".addslashes(htmlspecialchars
($email))."',styleid='$userstyleid',parentemail='".addslashes
(htmlspecialchars
($parentemail))."',coppauser=$coppauser,homepage='".addslashes
(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars
($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes
(htmlspecialchars($yahoo))."',signature='".addslashes
($signature)." ',adminemail=$adminemail,showemail=$showemail,invi

sible=$
invisible,usertitle='".addslashes
($usertitle)." ',customtitle=$customtitle,joindate=$joindate,cook

ieuser=$coo
kieuser,nosessionhash=$nosessionhash,daysprune='$d

aysprune',lastvisit=
$lastvisit,lastactivity=$lastactivity,lastpost=$la

stpost,posts='$posts',timezon
eoffset='$timezoneoffset',email???ification=$email

???ification,receivepm='$r
eceivepm',emailonpm='$emailonpm',ipaddress='".addslashes
($aipaddress)."',pmpopup=IF(pmpopup=2 AND
$pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("UPDATE nuke_users SET uname='".addslashes
(htmlspecialchars($ausername))."'$pwdinclude_nuke,email='".addslashes
(htmlspecialchars($email))."',url='".addslashes(htmlspecialchars
($homepage))."',user_icq='".addslashes(htmlspecialchars
($icq))."',user_aim='".addslashes(htmlspecialchars
($aim))."',user_yim='".addslashes(htmlspecialchars($yahoo))."' WHERE
uid=$userid");

--------------------------------------------------------------------------------

????? ????? ???? ?? ????? ??????

--------------------------------------------------------------------------------

if ($HTTP_POST_VARS['action']=="kill") {

$user=$DB_site->query_first("SELECT username FROM user WHERE
userid='$userid'");
$DB_site->query("UPDATE post SET username='".addslashes($user
[username])."',userid=0 WHERE userid='$userid'");
$DB_site->query("DELETE FROM user WHERE userid='$userid'");

--------------------------------------------------------------------------------

???? ???? ????? ??????

--------------------------------------------------------------------------------

$DB_site->query("DELETE FROM nuke_users WHERE
uid='$userid'");

--------------------------------------------------------------------------------

==========================
??? ???????? ?? ??? ??????? ?????? ??? ???? ??????? ??? ??????? ???? ???????? ????? transfer_vb_users.php ?? ???? ?????? ????? ?? ???? ??? ???? ?????? ???? ???????? ?? ????? ????? ???? ????? .
=========================
???? ???? ??? index.php ??? ???? Your_Account
modules/Your_Account/index.php
???? ????? ?? ????? ??? ????? ??? ??? ???? ?????? ???? vb ???? ??? ???? ??? ????? ??? ?????? ????? ????? ???? vb ??? ??? ???? ?????? .
========================
??????? ??????? ?? ??? ??? ???? ??????? ?? ???? ?????? ?????? ????? ??? :
admin/case/case.users.php
admin/modules/users.php
???? ???? ??????? ??? ???? ????????
=====================
???? ????? ?? : http://www.webz4u.com

??????
??????

?????? : ??? ????? ?? ???? ?????? ??

?? ????? ????? ????? ???????

http://www.3rb.cc

?????? ????? ????? ???? ????? ???????

?????? ??????? ??? ????????? ???????

??? ????? ?????? ??????? ?? ??????? ?????? ?? ??????? vb3 ?? ?????? ??????? 7.3 ??? ?????? ?????

?? ???? ??? ????? ???? ???????? ???

???? ?????? كتب:???? ??? ??? ???? ??? ?? ??????? ??? ?? ??? ???? ???? ????? ????

- ??? ?? ???? ??????? ??????? ?? ?????? ???? ?? ???? ???? ???? ???????? ???????? ??? ???? ????? ?????
????? ?? ??? ????? ?????

????? ?? ??????? ????? ?? ??????? ????? ?? ?????? ?????....

???? ??????? ???? ???? ????

????? ???? كتب:?????? ????? ????? ???? ????? ???????

?????? ??????? ??? ????????? ???????

??? ????? ?????? ??????? ?? ??????? ?????? ?? ??????? vb3 ?? ?????? ??????? 7.3 ??? ?????? ?????

?? ???? ??? ????? ???? ???????? ???

??? ?????? ??? ??? ??? PHPBB ???? ???????? VB

???? ????? ??? ????? ...... ??????:roll:

???? ???? ?? ?? ???? ?????? ....

??? ?????? almjed ????? ??????? ??? ????? ?????? ????? ????????? ?? ??????.

??? ?????? ????? ???? ????

??? ?????? almjed ????? ??????? ??? ????? ?????? ????? ????????? ?? ??????.

?? ????? ??? ????? ???? ????? ?? ??????? ??????? ???? ??? ???? ????? ????? ??????? ???? ???? ??? ??? ?????? ?????? ?????? ???? ???? ??? 8O

مشاركةبواسطة **TuPaC** » الجمعة يناير 21, 2005 12:54 am

??? ?? ?? ??????? ??

?????? ??????? ???????

??? ??? ????? ????? ???? ??????? ?? ?????? (??? ???????)
???? ??? ?? ????? ?? ?? ??????? ??? ???? ??? ???? ??????? ???? ????
---------------
??? ???? ??? ?? ??????? (??? ????? 1022 ) ???? ?????? ?? ??????? ???? ????? ???? ??? ???? ?? ??? ????????? ???? ???? ???? ?????? ????? ???? ???????? ???? ??????? ?????????? ????
------------------
??????? ???? ??? ??????? ???????? ??? ???? ??????? ???? ??????? ????? ??? ??? ??? ?? ?????? ??? ??????? ?? ???????
??? ????? ??? ????? ???? ????? ???? ????? ?? ??? ???

???? ????? ??????? ???? ???? ??????? ??? ?? ?????
??? ???? ???? ??????? ??? ???? phpbb3
??? ????? ???????? ?????

??????? ????? ??? ????? ???? ???? ???? ?????? ?? ??? ???? ???? ????
?? ??????? ??? ?? ??? ???? ?????? ???????
???? ??? ????? ????? ?? ?????? ???????? ???? ??? ??????? ?? ?????? ??????

??? abdul1406

????? ?? ???? ??? ??? ??????? ????

??? ???? ?????

??? ????????? ????? ?? ?????? ????? ??? ????? ??? ?? abdul1406 ??? ??????? ??????? ??? ?????:mrgreen:

هذا السكربت دمج المنتدىمع المجلة لنعطيه حقة من النقاش

??? ??????? ??? ????????? ?????? ?????? ??? ?? ??????

الموجودون الآن