php批量激活ucenter中的用户到Discuz x2.5论坛应用中

最新推荐文章于 2015-07-03 11:45:31 发布

生死由命

最新推荐文章于 2015-07-03 11:45:31 发布

阅读量922

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/liujinsuoabc/article/details/9666949

版权

php 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

<?php
	$dbserver ='127.0.0.1'; //此处改成数据库服务器地址
	$dbuser ='root';//此处写数据库用户名
	//$dbpwd ='REVpuVrDHFVFNtzX';//数据库密码
	$dbpwd ='123456';//数据库密码
	$dbname ='tea_group';//数据库名称
	$charset ='utf8';//此处写字符集gbk或者utf8
	$uc_pre ='ucenter.uc_';//UC表前缀
	$dx_pre ='tea_group.tea_';//Discuz! X2表前缀
	//此行开始向下不要改动
	set_time_limit(0); //0为无限制
	$connect=mysql_connect($dbserver,$dbuser,$dbpwd) or die("无法连接数据库");
	//@mysql_select_db($dbname,$connect);
	mysql_query("set names $charset");
	$query = mysql_query("SELECT * FROM {$uc_pre}members  WHERE  uid not in(select uid from {$dx_pre}common_member) limit 5",$connect);
	while($user = mysql_fetch_array($query)) {
		$password=$user['password'];
		$flag=true;
		$sql2 = array();
		mysql_query('begin');
		$sql = " replace INTO  {$dx_pre}common_member (uid,username,password,adminid,groupid,regdate,email) VALUES ('$user[uid]', '$user[username]', '$password','0','10','$user[regdate]','$user[email]') ";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		$sql = " replace INTO  {$dx_pre}common_member_field_forum (uid,medals,sightml,groupterms,groups) VALUES ('$user[uid]','','','','')";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		$sql = " replace INTO  {$dx_pre}common_member_field_home (uid,spacecss,blockposition,recentnote,spacenote,privacy,feedfriend,acceptemail,magicgift,stickblogs) VALUES ('$user[uid]','','','','','','','','','')";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		$sql = " replace INTO  {$dx_pre}common_member_count (uid) VALUES ('$user[uid]')";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		$sql = " replace INTO  {$dx_pre}common_member_profile (uid,bio,interest,field1,field2,field3,field4,field5,field6,field7,field8) VALUES ('$user[uid]','','','','','','','','','','')";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		$sql = " replace INTO  {$dx_pre}common_member_status (uid) VALUES ('$user[uid]')";
		$rzt1=mysql_query($sql);
		if($rzt1===false){
			$flag=false;
			$sql2[] = $sql;
		}
		if($flag==true){
			mysql_query('commit');
			echo "$user[uid]插入成功<br/>";
		}else{
			foreach($sql2 as $k=>$v){
				echo $v.'<br>';
			}
			exit("$user[uid]插入失败<br/>");
		}
		
	}
	echo "<br/>已从UC批量导入激活成功<br/>";
?>