Posteingang:
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