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];
}
$lastsummary = removecode(trim($pmsarr['message']), 150);
$lastmessage = array('lastauthorid' => $pmsarr['msgfromid'], 'lastauthor' => $pmsarr['msgfrom'], 'lastsummary' => $lastsummary);
$lastmessage = addslashes(serialize($lastmessage));
$db->query("UPDATE " . UC_DBTABLEPRE . "pm_lists SET lastmessage='{$lastmessage}' WHERE plid='{$data['plid']}'");
