phpBB.de

Code: Alles auswählen

    $inputbox = mysql_num_rows(mysql_query("SELECT * FROM `havo_privmsgs` WHERE `privmsgs_to_userid` = '".$userdata['user_id']."' AND (`privmsgs_type` = '0' OR `privmsgs_type` = '5')"));
    $outputbox = mysql_num_rows(mysql_query("SELECT * FROM `havo_privmsgs` WHERE `privmsgs_from_userid` = '".$userdata['user_id']."' AND (`privmsgs_type` = '0' OR `privmsgs_type` = '5')"));
    $archivbox = mysql_num_rows(mysql_query("SELECT * FROM `havo_privmsgs` WHERE `privmsgs_from_userid` = '".$userdata['user_id']."' AND `privmsgs_type` = '4'"));
    $inputboxnew = mysql_num_rows(mysql_query("SELECT * FROM `havo_privmsgs` WHERE `privmsgs_to_userid` = '".$userdata['user_id']."' AND `privmsgs_type` = '1'"));

Code: Alles auswählen

SELECT COUNT(*) AS count
    FROM phpbb_privmsgs
    WHERE privmsgs_type IN (0, 1, 5)
        AND privmsgs_to_userid = x

Code: Alles auswählen

SELECT COUNT(*) AS count
    FROM phpbb_privmsgs
    WHERE privmsgs_type = 2
        AND privmsgs_from_userid = x

Code: Alles auswählen

SELECT COUNT(*) AS count
    FROM phpbb_privmsgs
    WHERE privmsgs_type IN (1, 5)
        AND privmsgs_from_userid = x

Code: Alles auswählen

SELECT COUNT(*) AS count
    FROM phpbb_privmsgs
    WHERE (privmsgs_type = 3 AND privmsgs_to_userid = x) OR
        (privmsgs_type = 4 AND privmsgs_from_userid = x

Code: Alles auswählen

COUNT (privmsgs_id)