批量激活ucenter中的用户到dzx2.5中

导入用户数据,结果发现无法激活.
参考论坛网友的代码,发一下改写的批量激活命令

1. <?php
   
2. $dbserver ='localhost'; //此处改成数据库服务器地址
   
3. $dbuser ='root';//此处写数据库用户名
   
4. $dbpwd ='1234';//数据库密码
   
5. $dbname ='disucz';//数据库名称
   
6. $charset ='gbk';//此处写字符集gbk或者utf8
   
7. $uc_pre ='pre_ucenter_';//UC表前缀
   
8. $dx_pre ='pre_';//Discuz! X2表前缀
   
9. //此行开始向下不要改动
   
10. set_time_limit(0); //0为无限制
    
11. $connect=mysql_connect($dbserver,$dbuser,$dbpwd) or die("无法连接数据库");
    
12. @mysql_select_db($dbname,$connect);
    
13. mysql_query("set names $charset");
    
14. $query = mysql_query("SELECT * FROM `{$uc_pre}members`  WHERE  `uid` not in(select `uid` from `{$dx_pre}common_member`) ",$connect);
    
15. while($user = mysql_fetch_array($query)) {
    
16. $password=$user[password];   
    
17. mysql_query(" 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]') ");
    
18. mysql_query(" replace INTO  `{$dx_pre}common_member_field_forum` (uid) VALUES ('$user[uid]')");
    
19. mysql_query(" replace INTO  `{$dx_pre}common_member_field_home` (uid) VALUES ('$user[uid]')");
    
20. mysql_query(" replace INTO  `{$dx_pre}common_member_count` (uid) VALUES ('$user[uid]')");
    
21. mysql_query(" replace INTO  `{$dx_pre}common_member_profile` (uid) VALUES ('$user[uid]')");
    
22. mysql_query(" replace INTO  `{$dx_pre}common_member_status` (uid) VALUES ('$user[uid]')");
    
23. }
    
24. echo "已从UC批量导入激活成功";
    
25. ?>

复制代码

将代码保存为一个PHP文件,上传至服务器,直接运行即可.

发错位置了