[ADD-ON] Improved PM Folderview PM Totals

You MUST have the original hack installed first - Created By Kreftt
https://vborg.vbsupport.ru/showthrea...threadid=36764


-----

UPDATED : Ok everything should work now, both in private.php and private2.php. I have updated it to work with both files so if you downloaded it before please go through the file again and check you have got all of it.

What does it do?
- Displays total PM's In :
-- Inbox
-- Sent Items Folder
-- Custom Folders

Next Up...
-- Message Tracking (Display total read/unread)

Screencap
See Above Thread, Post #20

Working Demo
http://www.darkangeluk.com/forums/

All credit goes to Kreftt for creating the hack in the first place!

[Tigga]

Well just incase anyone else is having the problem with the custom folders total not showing, I figured out what was wrong.

Open private.php and find:

PHP Code:

eval("\$folderboxeshack .= \"".gettemplate("priv_showfolders_folderbit_hack",1,0)."\";"); 


Right above that add:

PHP Code:

$msginfolder = $DB_site->query_first("SELECT COUNT(*) AS foldermsgtotal FROM privatemessage
 WHERE userid=$bbuserinfo[userid] AND folderid=$folder[folderid]");
$foldermsgtotal = $msginfolder[foldermsgtotal]; 


Then you can look for another instance of the code above that you just added (near the bottom of the file) and remove it. Works great now.

[Dynamic One]

Thanks for this noce looking addon m8.

[Bison]

Installed!

Adds a very professional look to the private message folder count!

[Esdee]

Thanks PlurPlanet, I was looking for that.
Great add-on BTW. Now the hack truly is perfect

[jjj0923]

has anyone tacked the Message Tracking Count yet???

[T?Pau]

I did the Message Tracking.
It shows the unread/read PM

Just open both private.php and private2.php and find

PHP Code:

/////////////////////////////////////////////////////////////////////////////////////hack///////////////////////////////////////////////////////////////////
//// -- Begin PM Folder Totals
// Messages Inbox
$msgin_inbox = $DB_site->query_first("SELECT COUNT(*) AS inbox_msgtotal FROM privatemessage WHERE userid=$bbuserinfo[userid] AND folderid='0'");
$inbox_msgtotal = $msgin_inbox[inbox_msgtotal];
//      
// Messages Sent
$msgin_sent = $DB_site->query_first("SELECT COUNT(*) AS sent_msgtotal FROM privatemessage WHERE userid=$bbuserinfo[userid] AND folderid='-1'");
$sent_msgtotal = $msgin_sent[sent_msgtotal]; 


Below that add:

PHP Code:

//Message Tracking
$msgin_track = $DB_site->query_first("SELECT COUNT(*) AS track_msgtotal FROM privatemessage WHERE fromuserid=$bbuserinfo[userid] AND receipt='1'");
$track_msgtotal = $msgin_track[track_msgtotal];

$msgin_trackread = $DB_site->query_first("SELECT COUNT(*) AS track_msgtotalread FROM privatemessage WHERE fromuserid=$bbuserinfo[userid] AND receipt='2'");
$track_msgtotalread = $msgin_trackread[track_msgtotalread]; 


And in your privfolder and privsend Templates find :

<td bgcolor="#13486D" width="100%"><normalfont><a href="private2.php?s=$session[sessionhash]">Message Tracking</a></font></td>

and replace it with

<td bgcolor="#13486D" width="100%"><normalfont><a href="private2.php?s=$session[sessionhash]">Message Tracking</a>($track_msgtotal / $track_msgtotalread)</font></td>

Works on my 2.2.7

[Boofo]

Work excellent of version 2.2.9, also. Thanks!

Is there a way of including the queries in the code above it to knock two more queries off of the page?

[PixelFx]

hey guys, just wanted to say great hack, I got it working with vbulletin v2.3.0, works great, I also added matts addon, with a few changes, to match colors, but otherwise everything installed perfectly.

Example image:


thanks for all your hard work guys

[FleaBag]

Thanks for the extra code additions everyone, makes a difference to DragonNinja running on 2.3.0.

[ImportPassion]

And in your privfolder and privsend Templates find :

should read

And in your privfolder and privsent Templates find :