phpBB.de

Code: Alles auswählen

Could not query private message information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(pm.privmsgs_id) as inbox_count FROM phpbb_pri

SELECT * FROM ( SELECT COUNT(pm.privmsgs_id) as inbox_count FROM phpbb_privmsgs AS pm WHERE pm.privmsgs_to_userid = 2 AND ( pm.privmsgs_type = 1 OR pm.privmsgs_type = 0 OR privmsgs_type = 5 ) ) AS inbox, ( SELECT COUNT(pm.privmsgs_id) as outbox_count FROM phpbb_privmsgs AS pm WHERE pm.privmsgs_from_userid = 2 AND ( pm.privmsgs_type = 1 OR privmsgs_type = 5 ) ) AS outbox, ( SELECT COUNT(pm.privmsgs_id) as sentbox_count FROM phpbb_privmsgs AS pm WHERE pm.privmsgs_from_userid = 2 AND ( pm.privmsgs_type = 2 ) ) AS sentbox, ( SELECT COUNT(pm.privmsgs_id) as savebox_count FROM phpbb_privmsgs AS pm WHERE ( pm.privmsgs_from_userid = 2 AND pm.privmsgs_type = 4 ) OR ( pm.privmsgs_to_userid = 2 AND pm.privmsgs_type = 3 ) ) AS savebox

Line : 171
File : privmsg.php

Code: Alles auswählen

-----[ OPEN ]-----------------------------------------
#
privmsg.php

#
#-----[ FIND ]-----------------------------------------
#
// ----------
// Start main
//

#
#-----[ BEFORE, ADD ]-----------------------------------
#
// +Override PM Limits
$folder_count_sql = "SELECT * FROM
(
    SELECT COUNT(pm.privmsgs_id) as inbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_to_userid = {$userdata['user_id']}
        AND (
            pm.privmsgs_type = " . PRIVMSGS_NEW_MAIL . "
            OR pm.privmsgs_type = " . PRIVMSGS_READ_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . "
        )
) AS inbox,
(
    SELECT COUNT(pm.privmsgs_id) as outbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_from_userid = {$userdata['user_id']}
        AND ( pm.privmsgs_type = " . PRIVMSGS_NEW_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )
) AS outbox,
(
    SELECT COUNT(pm.privmsgs_id) as sentbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_from_userid = {$userdata['user_id']}
        AND ( pm.privmsgs_type = " . PRIVMSGS_SENT_MAIL . " )
) AS sentbox,
(
    SELECT COUNT(pm.privmsgs_id) as savebox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE (
        pm.privmsgs_from_userid = {$userdata['user_id']}
        AND pm.privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . "
    ) OR (
        pm.privmsgs_to_userid = {$userdata['user_id']}
        AND pm.privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . "
    )
) AS savebox";

if ( !($result = $db->sql_query($folder_count_sql)) )
{
    message_die(GENERAL_ERROR, 'Could not query private message information', '', __LINE__, __FILE__, $folder_count_sql);
}

$folder_counts = $db->sql_fetchrow($result);

$template->assign_vars(array(
    'INBOX_TOTAL' => $folder_counts['inbox_count'],
    'SAVEBOX_TOTAL' => $folder_counts['savebox_count'],
    'SENTBOX_TOTAL' => $folder_counts['sentbox_count'],
    'OUTBOX_TOTAL' => $folder_counts['outbox_count'])
);
// -Override PM Limits

Code: Alles auswählen

// +Override PM Limits
$folder_count_sql = "SELECT * FROM
(
    SELECT COUNT(pm.privmsgs_id) as inbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_to_userid = {$userdata['user_id']}
        AND (
            pm.privmsgs_type = " . PRIVMSGS_NEW_MAIL . "
            OR pm.privmsgs_type = " . PRIVMSGS_READ_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . "
        )
) AS inbox,
(
    SELECT COUNT(pm.privmsgs_id) as outbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_from_userid = {$userdata['user_id']}
        AND ( pm.privmsgs_type = " . PRIVMSGS_NEW_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )
) AS outbox,
(
    SELECT COUNT(pm.privmsgs_id) as sentbox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE pm.privmsgs_from_userid = {$userdata['user_id']}
        AND ( pm.privmsgs_type = " . PRIVMSGS_SENT_MAIL . " )
) AS sentbox,
(
    SELECT COUNT(pm.privmsgs_id) as savebox_count
    FROM " . PRIVMSGS_TABLE . " AS pm
    WHERE (
        pm.privmsgs_from_userid = {$userdata['user_id']}
        AND pm.privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . "
    ) OR (
        pm.privmsgs_to_userid = {$userdata['user_id']}
        AND pm.privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . "
    )
) AS savebox";

if ( !($result = $db->sql_query($folder_count_sql)) )
{
    message_die(GENERAL_ERROR, 'Could not query private message information', '', __LINE__, __FILE__, $folder_count_sql);
}

$folder_counts = $db->sql_fetchrow($result);

$template->assign_vars(array(
    'INBOX_TOTAL' => $folder_counts['inbox_count'],
    'SAVEBOX_TOTAL' => $folder_counts['savebox_count'],
    'SENTBOX_TOTAL' => $folder_counts['sentbox_count'],
    'OUTBOX_TOTAL' => $folder_counts['outbox_count'])
);
// -Override PM Limits
// ----------
// Start main
//