PHP ucserver_db::fetch_array Examples

Example #1

File: upgrade_1.5.2_1.6.0.php Project: v998/discuzx-en

    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];
            }
            $lastsummary = removecode(trim($pmsarr['message']), 150);