コード例 #1
0
ファイル: pm.inc.php プロジェクト: DeannaG65/BeehiveForum
function pm_process_result(mysqli_result $result, $message_count)
{
    $message_array = array();
    while (($pm_data = $result->fetch_assoc()) !== null) {
        if (!isset($pm_data['FROM_LOGON'])) {
            $pm_data['FROM_LOGON'] = gettext("Unknown user");
        }
        if (!isset($pm_data['FROM_NICKNAME'])) {
            $pm_data['FROM_NICKNAME'] = "";
        }
        $message_array[$pm_data['MID']] = array('CREATED' => $pm_data['CREATED'], 'FROM_UID' => $pm_data['FROM_UID'], 'FROM_LOGON' => $pm_data['FROM_LOGON'], 'FROM_NICKNAME' => $pm_data['FROM_NICKNAME'], 'MID' => $pm_data['MID'], 'RECIPIENTS' => array(), 'REPLY_TO_MID' => $pm_data['REPLY_TO_MID'], 'SUBJECT' => $pm_data['SUBJECT'], 'TYPE' => $pm_data['TYPE']);
    }
    pms_get_recipients($message_array);
    pms_have_attachments($message_array);
    return array('message_count' => $message_count, 'message_array' => $message_array);
}
コード例 #2
0
ファイル: pm.inc.php プロジェクト: richstokoe/BeehiveForum
function pm_fetch_search_results($sort_by = 'CREATED', $sort_dir = 'DESC', $page = 1, $limit = 10)
{
    if (!($db = db::get())) {
        return false;
    }
    $sort_by_array = array('PM.SUBJECT', 'TYPE', 'PM.FROM_UID', 'PM.TO_UID', 'CREATED');
    $sort_dir_array = array('ASC', 'DESC');
    if (!is_numeric($page) || $page < 1) {
        $page = 1;
    }
    if (!is_numeric($limit)) {
        $limit = 10;
    }
    $limit = abs($limit);
    $offset = calculate_page_offset($page, $limit);
    if (!in_array($sort_by, $sort_by_array)) {
        $sort_by = 'CREATED';
    }
    if (!in_array($sort_dir, $sort_dir_array)) {
        $sort_dir = 'DESC';
    }
    if (($uid = session::get_value('UID')) === false) {
        return false;
    }
    $message_array = array();
    $sql = "SELECT SQL_CALC_FOUND_ROWS PM_SEARCH_RESULTS.MID, PM_SEARCH_RESULTS.TYPE, ";
    $sql .= "PM_SEARCH_RESULTS.FROM_UID, PM_SEARCH_RESULTS.TO_UID, PM_SEARCH_RESULTS.RECIPIENTS, ";
    $sql .= "PM_SEARCH_RESULTS.SUBJECT, UNIX_TIMESTAMP(PM_SEARCH_RESULTS.CREATED) AS CREATED, ";
    $sql .= "FUSER.LOGON AS FLOGON, FUSER.NICKNAME AS FNICK, ";
    $sql .= "TUSER.LOGON AS TLOGON, TUSER.NICKNAME AS TNICK FROM PM_SEARCH_RESULTS ";
    $sql .= "LEFT JOIN PM ON (PM.MID = PM_SEARCH_RESULTS.MID) ";
    $sql .= "LEFT JOIN USER FUSER ON (PM_SEARCH_RESULTS.FROM_UID = FUSER.UID) ";
    $sql .= "LEFT JOIN USER TUSER ON (PM_SEARCH_RESULTS.TO_UID = TUSER.UID) ";
    $sql .= "WHERE PM_SEARCH_RESULTS.UID = '{$uid}' AND PM.MID IS NOT NULL ";
    $sql .= "ORDER BY {$sort_by} {$sort_dir} LIMIT {$offset}, {$limit}";
    if (!($result = $db->query($sql))) {
        return false;
    }
    $sql = "SELECT FOUND_ROWS() AS ROW_COUNT";
    if (!($result_count = $db->query($sql))) {
        return false;
    }
    list($message_count) = $result_count->fetch_row();
    if ($result->num_rows == 0 && $message_count > 0 && $page > 1) {
        return pm_fetch_search_results($sort_by, $sort_dir, $page - 1, $limit);
    }
    while ($pm_data = $result->fetch_assoc()) {
        if (isset($pm_data['FLOGON']) && isset($pm_data['PFNICK'])) {
            if (!is_null($pm_data['PFNICK']) && strlen($pm_data['PFNICK']) > 0) {
                $pm_data['FNICK'] = $pm_data['PFNICK'];
            }
        }
        if (isset($pm_data['TLOGON']) && isset($pm_data['PTNICK'])) {
            if (!is_null($pm_data['PTNICK']) && strlen($pm_data['PTNICK']) > 0) {
                $pm_data['TNICK'] = $pm_data['PTNICK'];
            }
        }
        if (!isset($pm_data['FLOGON'])) {
            $pm_data['FLOGON'] = gettext("Unknown user");
        }
        if (!isset($pm_data['FNICK'])) {
            $pm_data['FNICK'] = "";
        }
        if (!isset($pm_data['TLOGON'])) {
            $pm_data['TLOGON'] = gettext("Unknown user");
        }
        if (!isset($pm_data['TNICK'])) {
            $pm_data['TNICK'] = "";
        }
        $message_array[$pm_data['MID']] = $pm_data;
    }
    pms_have_attachments($message_array);
    return array('message_count' => $message_count, 'message_array' => $message_array);
}