function DoMerge()
{
$this->CheckAdminPrivs('ucenter');
$start = max(0,(int) $this->Get['start']);
$limit = 500;
$ucenter = ConfigHandler::get('ucenter');
if(!$ucenter['enable'] || !$this->Get['confirm'] || 'mysql' != $ucenter['uc_connect'])
{
$this->Messager("你的配置不正确，或者已经进行过用户数据整合了",null);
}
include_once(ROOT_PATH.'./api/uc_api_db.php');
$db = new JSG_UC_API_DB();
$db->connect($this->Config['db_host'],$this->Config['db_user'],$this->Config['db_pass'],$this->Config['db_name'],$this->Config['charset'],$this->Config['db_persist'],$this->Config['db_table_prefix']);
$query = $db->query("select * from ".TABLE_PREFIX."system_members where ucuid=0 limit {$limit}");
if($db->num_rows($query) < 1)
{
$this->Messager("用户数据合并成功",null);
}
$uc_db = new JSG_UC_API_DB();
$uc_db->connect($ucenter['uc_db_host'],$ucenter['uc_db_user'],$ucenter['uc_db_password'],$ucenter['uc_db_name'],$ucenter['uc_db_charset'],1,$ucenter['uc_db_table_prefix']);
while ($data = $db->fetch_array($query))
{
$ucuid = -1;
$salt = rand(100000, 999999);
$password = md5($data['password'].$salt);
$data['username'] = addslashes($data['username']);
$uc_user = $uc_db->fetch_first("SELECT * FROM {$ucenter['uc_db_table_prefix']}members WHERE username='******'"); if(!$uc_user) {
$uc_db->query("INSERT LOW_PRIORITY INTO {$ucenter['uc_db_table_prefix']}members SET username='******', password='******',email='$data[email]', regip='$data[regip]', regdate='$data[regdate]', salt='$salt'", 'SILENT');
$ucuid = $uc_db->insert_id();
$uc_db->query("INSERT LOW_PRIORITY INTO {$ucenter['uc_db_table_prefix']}memberfields SET uid='$ucuid'",'SILENT');
}
else
{
if($uc_user['password'] == md5($data['password'].$uc_user['salt'])) {
$ucuid = $uc_user['uid'];
}
else {
$uc_db->query("REPLACE INTO {$ucenter['uc_db_table_prefix']}mergemembers SET appid='".UC_APPID."', username='******'", 'SILENT');
}
}
$db->query("update ".TABLE_PREFIX."system_members set ucuid={$ucuid} where uid={$data['uid']}");
}
$next = ($start + $limit);
$this->Messager("[{$start}-{$next}]正在进行用户数据的合并中，请稍候……",'admin.php?mod=ucenter&code=merge&confirm=1&start='.$next);
}
function DoMerge()
{
$start = max(0, (int) $this->Get['start']);
$limit = 500;
$ucenter = jconf::get('ucenter');
if (!$ucenter['enable'] || !$this->Get['confirm'] || 'mysql' != $ucenter['uc_connect']) {
$this->Messager("你的配置不正确，或者已经进行过用户数据整合了", 'admin.php?mod=ucenter&code=ucenter');
}
include_once ROOT_PATH . './api/uc_api_db.php';
$db = new JSG_UC_API_DB();
$db->connect($this->Config['db_host'], $this->Config['db_user'], $this->Config['db_pass'], $this->Config['db_name'], $this->Config['charset'], $this->Config['db_persist'], $this->Config['db_table_prefix']);
if (!$start) {
if (get_param('new_merge')) {
$db->query("update " . TABLE_PREFIX . "members set `ucuid`=0 where `ucuid`!=0");
} else {
$db->query("update " . TABLE_PREFIX . "members set `ucuid`=0 where `ucuid`<0");
}
}
$query = $db->query("select * from " . TABLE_PREFIX . "members where ucuid=0 limit {$limit}");
if ($db->num_rows($query) < 1) {
$this->Messager("用户数据合并成功", 'admin.php?mod=ucenter&code=ucenter');
}
$uc_db = new JSG_UC_API_DB();
$uc_db->connect($ucenter['uc_db_host'], $ucenter['uc_db_user'], $ucenter['uc_db_password'], $ucenter['uc_db_name'], $ucenter['uc_db_charset'], 0, $ucenter['uc_db_table_prefix']);
while (false != ($data = $db->fetch_array($query))) {
$ucuid = -1;
$db->query("update `" . TABLE_PREFIX . "members` set `ucuid`='{$ucuid}' where `uid`='{$data['uid']}'");
if ($data['salt']) {
$salt = $data['salt'];
$password = $data['password'];
} else {
$salt = rand(100000, 999999);
$password = md5($data['password'] . $salt);
}
$data['username'] = addslashes($data['username']);
$data['nickname'] = addslashes($data['nickname']);
$uc_user = $uc_db->fetch_first("SELECT * FROM {$ucenter['uc_db_table_prefix']}members WHERE username='******'nickname']}'");
if (!$uc_user) {
$uc_db->query("INSERT LOW_PRIORITY INTO {$ucenter['uc_db_table_prefix']}members SET username='******'nickname']}', `password`='{$password}',email='{$data['email']}', regip='{$data['regip']}', regdate='{$data['regdate']}', salt='{$salt}'", 'SILENT');
$ucuid = $uc_db->insert_id();
$uc_db->query("INSERT LOW_PRIORITY INTO {$ucenter['uc_db_table_prefix']}memberfields SET uid='{$ucuid}'", 'SILENT');
} else {
$ucuid = $uc_user['uid'];
}
$db->query("update `" . TABLE_PREFIX . "members` set `ucuid`='{$ucuid}' where `uid`='{$data['uid']}'");
}
$db->close();
$uc_db->close();
$next = $start + $limit;
$this->Messager("[{$start}-{$next}]正在进行用户数据的合并中，请稍候……", 'admin.php?mod=ucenter&code=merge&confirm=1&start=' . $next);
}