} else {
@touch($lock_file);
echo "<font style='font-size:20px;'>The upgrade is completed</font>.<br>Original short message form (" . UC_DBTABLEPRE . "pms Table) No longer in use, we recommend that you test the function of short message and data is no problem, delete the table.<br>Will advanced/uc_client The file overwrite your uc_client Client.";
}
showfooter();
} elseif ($action == 'pmstats') {
showheader();
echo "<h4>Processing Other short message data</h4>";
$db = new ucserver_db();
$db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET);
$total = getgpc('total');
$start = getgpc('start') ? getgpc('start') : 0;
$limit = 1000;
$next = 0;
if (!$total) {
$total = $db->result_first("SELECT MAX(plid) FROM " . UC_DBTABLEPRE . "pm_lists");
}
if ($total) {
$query = $db->query("SELECT * FROM " . UC_DBTABLEPRE . "pm_lists WHERE plid>'{$start}' ORDER BY plid LIMIT {$limit}");
while ($data = $db->fetch_array($query)) {
$next = $data['plid'];
$users = explode('_', $data['min_max']);
$pmsarr = $db->fetch_first("SELECT * FROM " . UC_DBTABLEPRE . "pms WHERE msgfromid IN ('{$users['0']}','{$users['1']}') AND msgtoid IN ('{$users['0']}', '{$users['1']}') ORDER BY dateline DESC LIMIT 1");
$pmsarr['msgfrom'] = addslashes($pmsarr['msgfrom']);
$pmsarr['subject'] = addslashes($pmsarr['subject']);
$pmsarr['message'] = addslashes($pmsarr['message']);
if ($pmsarr['subject'] && strcmp($pmsarr['subject'], $pmsarr['message'])) {
$pmsarr['message'] = $pmsarr['subject'] . "\r\n" . $pmsarr['message'];
}
if ($users[0] == $data['authorid']) {
$touid = $users[1];
header("Location: upgrade_1.0.0_1.5.0.php?action=pm&forward=".urlencode($forward));
} elseif($action == 'pm') {
showheader();
echo "<h4>处理短消息数据</h4>";
$db = new ucserver_db();
$db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET);
$total = getgpc('total');
$start = intval(getgpc('start'));
$limit = 1000;
if(!$total) {
$total = $db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."pms WHERE related=0");
}
if(!$total || $total <= $start) {
$db->query("REPLACE INTO ".UC_DBTABLEPRE."settings (k, v) VALUES('version', '1.5.0')");//note 记录数据库版本
@touch($lock_file);
if($forward) {
echo "<br /><br /><br /><a href=\"$forward\">浏览器会自动跳转页面，无需人工干预。除非当您的浏览器长时间没有自动跳转时，请点击这里</a>";
echo "<script>setTimeout(\"redirect('$forward');\", 1250);</script>";
} else {
echo "升级完成。";
}
} else {
$query = $db->query("SELECT * FROM ".UC_DBTABLEPRE."pms WHERE related=0 LIMIT $start, $limit");
while($data = $db->fetch_array($query)) {
$data['msgfrom'] = addslashes($data['msgfrom']);