} 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]; } else { $touid = $users[0]; }
require dirname(__FILE__).'/data/config.inc.php'; require dirname(__FILE__).'/lib/db.class.php'; $db = new ucserver_db(); $db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET, UC_DBCONNECT, UC_DBTABLEPRE); $nomatch = true; $applist = $db->fetch_all("SELECT appid, name FROM ".UC_DBTABLEPRE."applications"); $table_columns = loadtable('notelist'); foreach($applist as $app) { $appid = $app['appid']; if(empty($appid)) continue; if(!isset($table_columns['app'.$appid])) { $nomatch = false; if($db->query("ALTER TABLE ".UC_DBTABLEPRE."notelist ADD COLUMN app$appid tinyint NOT NULL")) { echo "补充notelist表字段成功: $appid <br />"; } else { echo "补充notelist表字段失败,请刷新重试<br />"; } } } if($nomatch) { echo '没有需要补充的字段<br />'; } if(!unlink(__FILE__)) { echo '请立即登陆服务器删除此文件<br />'; }
$db->query("UPDATE " . UC_DBTABLEPRE . "applications SET authkey='{$authkey}' WHERE appid='{$appid}'"); } header("Location: upgrade_1.0.0_1.5.0.php?action=pm&forward=" . urlencode($forward)); } elseif ($action == 'pm') { showheader(); echo "<h4>Short message data processing</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 Record database version @touch($lock_file); if ($forward) { echo "<br /><br /><br /><a href=\"{$forward}\">Browser will automatically redirected, without human intervention. Unless a long time when your browser does not support frames, please click here</a>"; echo "<script>setTimeout(\"redirect('{$forward}');\", 1250);</script>"; } else { echo "The upgrade is completed."; } } 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']); $data['subject'] = addslashes($data['subject']); $data['message'] = addslashes($data['message']); $db->query("REPLACE INTO " . UC_DBTABLEPRE . "pms SET msgfrom='{$data['msgfrom']}',\r\n\t\t\t\tmsgfromid='{$data['msgfromid']}',msgtoid='{$data['msgtoid']}',folder='{$data['folder']}',new='{$data['new']}',subject='{$data['subject']}',\r\n\t\t\t\tdateline='{$data['dateline']}',message='{$data['message']}',delstatus='{$data['delstatus']}',related='" . time() . "'", 'SILENT');
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']); $data['subject'] = addslashes($data['subject']); $data['message'] = addslashes($data['message']); $db->query("REPLACE INTO ".UC_DBTABLEPRE."pms SET msgfrom='$data[msgfrom]', msgfromid='$data[msgfromid]',msgtoid='$data[msgtoid]',folder='$data[folder]',new='$data[new]',subject='$data[subject]',
showheader(); echo "<h4>处理短消息其它数据</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]; } else { $touid = $users[0]; }