古道风
中级会员
 
UID 72485
精华
0
积分 372
帖子 305
金钱 372 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2006-4-28
来自 郑州
状态 离线
|
[广告]: Enom域名自助付费 自助注册 自助PUSH 主流域名COM等一律57.99元年
转换用户资料代码
if($action == "user") {
if(!$start) {
$start = 0;
mysql_query("DELETE FROM $PW"."members");
mysql_query("DELETE FROM $PW"."memberdata");
}
$end = $start + $percount;
$goon = 0;
echo"<font color=\"red\"><b>正在进行由PhpBB2到phpwind的数据转换第1步(共6步)</b></font><br><br>\n";
echo"现在转换用户";
echo"现在开始转换用户 从 $start 到 $end 的用户资料.<br>";
$query = mysql_query("SELECT * FROM $tablepre"."hyjbxx LIMIT $start, $percount");
while($user = mysql_fetch_array($query)) {
require_once('./data/bbscache/level.php');
$groupid=-1;
arsort($lneed);
$memberid=array_pop(array_flip($lneed));
reset($lneed);
foreach($lneed as $key=>$lowneed){
if($nums>=$lowneed){
$memberid=$key;
break;
}
}
$money=$user['user_mpost'];//初始金钱数
$rvrc=10; //初始威望（积分）
$sign_test= convert($user['user_sig']);
$sign_test==$user['user_sig']?$ifconvert=1 ifconvert=2;
if(strpos($user['avatar'],'http')!==false){
$userface="|".$user['avatar']."||";
} elseif($user['avatar']){
//$userface = substr(strrchr($user['avatar'],'/'),1)."|||";
$userface = "";
} else{
$userface='';
} if($user[user_id]>0){
$result=mysql_query("INSERT INTO $PW"."members (uid,username, password, email,publicmail, groupid, memberid,icon, gender, regdate, signature, introduce, oicq, icq, site, location,honor,bday, receivemail, signchange) VALUES ('$user[user_id]','".strreplace($user['username'])."', '$user[user_password]', '".strreplace($user['user_email'])."', '1', '$groupid','$memberid', '$userface', '".strreplace($user['gender'])."', '".strreplace($user['user_regdate'])."', '".strreplace($user['user_sig'])."','', '', '$user[icq]', '".strreplace($user['user_website'])."', '".strreplace($user['user_from'])."','','', '0', '$ifconvert')") or die(mysql_error());
mysql_query("INSERT INTO $PW"."memberdata (uid, postnum, rvrc, money, lastvisit, thisvisit,onlineip) VALUES ('$user[user_id]','$user[user_posts]', '$rvrc', '$money', '', '', '')") or die(mysql_error());
}
$goon++;
}
| 
菜鸟～～～ |
|
