You can do this using template conditionals, no need to hack code.

then do it, i'd like to see you accomplish this.
sure you can use a conditional to blink an image, but there is no way you are going to be able to get the users, the ids to the PM, the unique PM count, etc..

I get this SQL Error:

Database error in vBulletin 3.0.3:

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

mysql error: Table 'andy.pmtext' doesn't exist

mysql error number: 1146

@ Kahoona: redownload the zip. i forgot to add TABLE_PREFIX to the query.

And the attachment won't download!

It still does not work lol.

Huh? It installed earlier for me fine and works great. Should I re-edit the hack with the newly updated code?

no you dont have to.
all i did was change:

FROM pmtext

to:

FROM " . TABLE_PREFIX . "pmtext

TABLE_PREFIX is only needed if you add a prefix on your tables when you installed vb, otherwise its not needed.

Kahoona, do your tables have a prefix or not?

most excellent.

installed in 1 minute and works like a charm.

Same for me, thank you for that hack :)