The Prohacker
Mon 5th Aug '02, 3:59pm
Invalid SQL:
### PRIVATE MESSAGES COUNTERS QUERY ###
SELECT COUNT(*) AS pmtotal,
SUM(IF(messageread = 0 AND folderid = 0, 1, 0)) AS pmunread,
SUM(IF(dateline > 1028569464 AND messageread = 0 AND folderid = 0, 1, 0)) AS pmnew
FROM privatemessage
WHERE userid = 82 fromuserid NOT IN (74)
From: http://beta.vbulletin.com/vb3/member.php?&do=getinfo&userid=74
Hmm is someone working on the pm system???? :D
Ewwww just noticed, its the entire damn board :D
### PRIVATE MESSAGES COUNTERS QUERY ###
SELECT COUNT(*) AS pmtotal,
SUM(IF(messageread = 0 AND folderid = 0, 1, 0)) AS pmunread,
SUM(IF(dateline > 1028569464 AND messageread = 0 AND folderid = 0, 1, 0)) AS pmnew
FROM privatemessage
WHERE userid = 82 fromuserid NOT IN (74)
From: http://beta.vbulletin.com/vb3/member.php?&do=getinfo&userid=74
Hmm is someone working on the pm system???? :D
Ewwww just noticed, its the entire damn board :D