阿川的博客

UC用户批量导入DZ X1.5

作者：阿川 发布时间：November 23, 2011 分类：网站应用 点击：758

<?php
    $dbserver ='localhost'; //此处改成数据库服务器地址
    $dbuser ='root';//此处写数据库用户名
    $dbpwd ='';//数据库密码
    $dbname ='';//数据库名称
    $charset ='gbk';//此处写字符集gbk或者utf8
 
    //此行开始向下不要改动
    $connect=mysql_connect($dbserver,$dbuser,$dbpwd) or die("无法连接数据库");
    @mysql_select_db($dbname,$connect);
    mysql_query("set names $charset");
    $query = mysql_query("SELECT * FROM `pre_ucenter_members` 
WHERE `uid` not in(select `uid` from `pre_common_member`) ",$connect);
    while($user = mysql_fetch_array($query)) {$password=$user[password];
    mysql_query(" replace INTO pre_common_member (uid,username,password,adminid,
groupid,regdate,email) VALUES ('$user[uid]',
 '$user[username]', '$password','0','10','$user[regdate]','$user[email]') ");
 
    mysql_query(" replace INTO pre_common_member_field_forum (uid) VALUES ('$user[uid]')");
    mysql_query(" replace INTO pre_common_member_field_home (uid) VALUES ('$user[uid]')");
    }
    echo "finished";
    ?>

标签: discuz, uc