[creedmaniac]

Originally Posted by .Tim

I didn't want to do the file edit, so I made it a plugin and it works perfectly. Here it is for anyone else who wants to try it. It works perfect on my test board and my live board. No claims it'll work anywhere else but it should. (note: it just replaces the need to edit the file, you still need to do the template edit)
Hope this is useful for someone.

i used your plugin...so i'm thinking this error is from that...




Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT pmtext.pmtextid, pmtext.fromusername, pmtext.fromuserid, pmtext.dateline, pm.pmid, user.userid, user.usergroupid,
COUNT(pmtext.fromuserid) AS fromusertotal FROM vbpmtext AS pmtext
LEFT JOIN vbpm AS pm USING(pmtextid)
LEFT JOIN vbuser ON (user.userid=pmtext.fromuserid)
WHERE pm.userid = 1 AND messageread = 0
GROUP BY pmtext.fromusername ORDER BY user.usergroupid ASC;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109
Date : Friday, April 28th 2006 @ 03:33:48 PM
Script : http:///home/private.php
Referrer : http:///home/private.php?do=newpm
IP Address : 5656565656
Username : Creed
Classname : vb_database