Blink PM icon with userinfo

Blink PM icon with userinfo

---------------------
Installation

- easy
- queries 0/1 (details below)
- file edits 1
- template edits 1

Reason for this hack:
I find the PM system lacked some additional information on the navbar the 0 X Unread, Total X isn't enough, as i wanted to know who sent the PM and how many they sent.

How it works:
When you get a PM the "Private Messages: x Unread, Total x." disappears and is replaced with a little blinking icon, if the user that sent the PM is a mod the icon will blink a teal color, if its a normal user, it will blink yellow. along with this you can view who sent the message, and if multiple people sent you PMs it will show their names.. If they sent you more than one, it will tell you that too. It will also take you directly to the PM without having to go to your inbox first.. After you've read all your PMs (or you dont have any) the "Private Messages: x Unread, Total x." returns to normal.

Queries: i know a lot of people are worried when it comes to adding hacks (especially me) because of additional queries.. this hack is sort of different. It only executes 1 query IF the user has unread PMs.. if they have no new PMs then 0 queries.

I've included two blinking gifs, you can use your own, put them in your images misc directory.

Read the txt file for installtion which takes 30 seconds.
I plan to expand this addons, but depends how many find it usefull, so click install plz.

[Floris]

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

[Sebastian]

Originally Posted by floris

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..

[Kahoona]

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

[Sebastian]

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

[kall]

Originally Posted by Kahoona

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

And the attachment won't download!

[Kahoona]

It still does not work lol.

[yoyoyoyo]

Originally Posted by Sebastian

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

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

[Sebastian]

Originally Posted by yoyoyoyo

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?

[yinyang]

most excellent.

installed in 1 minute and works like a charm.

[MrNase]

Originally Posted by yinyang

most excellent.

installed in 1 minute and works like a charm.

Same for me, thank you for that hack