PM Statistics bar in thread view

This hack was requested by SgtSling.

This is a very simple hack that displays the PM statistics of a user in the thread view screen.
It requires no template modifications because it appends itself on to $post[posts].

Here is how to implement this hack.

In showthread.php look for the following code:

PHP Code:

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

  if ($postdone[$post[postid]]) {
    $counter--;
    continue;
  } else {
    $postdone[$post[postid]]=1;
  }
  $postbits .= getpostbit($post);
} 


And replace it with the following:

PHP Code:

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

  if ($postdone[$post[postid]]) {
    $counter--;
    continue;
  } else {
    $postdone[$post[postid]]=1;
  }

  $pmcount=$DB_site->query_first("select count(*) as msgs from privatemessage where userid = $post[userid]");
  $pmratio = 100 * $pmcount[msgs] / $pmquota;
  if($pmratio > 100) {
    $pmratio = 100;
  }
  $pmstats = "<p><font face=\"verdana\" size=\"1\">PM Stats:</font><br>";
    $pmstats = "$pmstats<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"80%\" bordercolor=\"#000000\" bordercolorlight=\"#000000\" bordercolordark=\"#000000\"><tr><td bgcolor=\"#b5b5b5\"><img src=\"images/polls/bar3.gif\" width=\"$pmratio%\" height=\"9\"></td></tr></table>";
  $pmstats = "$pmstats\n$pmcount[msgs]/$pmquota";
  $post[posts]="$post[posts]$pmstats";

  $postbits .= getpostbit($post);
} 


Click on the following link for a screenshot of this hack: http://www.ls1.com/forums/showthread...hreadid=110647

[Zzed]

Originally posted by Boofo
Can this be made to work with private messages in the privmsg template?

Also, I want that spoiler vbcode, can I have it? Please?

Yes it can. You just need to modify the query string to do that. Feel free to PM or Email me if you need help with that.

And the link for the spoiler tag is in Post #7 of this thread.

[joeboo]

oh ho.. daddy likes this hack i will install it soon

[Zzed]

If you are interested inseeing the PM stats in the private message view screen do the make the following changes.

In private.php:
Look for the following code:

PHP Code:

eval("dooutput(\"".gettemplate("privmsg")."\");"); 


Change it to the following:

PHP Code:

  $pmcount=$DB_site->query_first("select count(*) as msgs from privatemessage where userid = $fromuserinfo[userid]");
  $pmratio = 100 * $pmcount[msgs] / $pmquota;
  if($pmratio > 100) {
    $pmratio = 100;
  }
  $pmstats = "<p><font face=\"verdana\" size=\"1\">PM Stats:</font><br>";
  $pmstats = "$pmstats<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"80%\" bordercolor=\"#000000\" bordercolorlight=\"#000000\" bordercolordark=\"#000000\"><tr><td bgcolor=\"#b5b5b5\"><img src=\"images/polls/bar3.gif\" width=\"$pmratio%\" height=\"9\"></td></tr></table>";
  $pmstats = "$pmstats\n$pmcount[msgs]/$pmquota";
  $fromuserinfo[posts]="$fromuserinfo[posts]$pmstats";

  eval("dooutput(\"".gettemplate("privmsg")."\");"); 


[Donkeyballz]

Hey,

This looks good, I'm gonna install it

[Boofo]

Is there a way to have it only show up for Admins and Supermods? Great job, by the way! Works execellent.

Anything on the other that we talked about?

[Zzed]

Here is the supermod/admin version

PHP Code:

if(($bbuserinfo[usergroupid]==5) OR ($bbuserinfo[usergroupid]==6)) {
  $pmcount=$DB_site->query_first("select count(*) as msgs from privatemessage where userid = $fromuserinfo[userid]");
  $pmratio = 100 * $pmcount[msgs] / $pmquota;
  if($pmratio > 100) {
    $pmratio = 100;
  }
  $pmstats = "<p><font face=\"verdana\" size=\"1\">PM Stats:</font><br>";
  $pmstats = "$pmstats<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"80%\" bordercolor=\"#000000\" bordercolorlight=\"#000000\" bordercolordark=\"#000000\"><tr><td bgcolor=\"#b5b5b5\"><img src=\"images/polls/bar3.gif\" width=\"$pmratio%\" height=\"9\"></td></tr></table>";
  $pmstats = "$pmstats\n$pmcount[msgs]/$pmquota";
  $fromuserinfo[posts]="$fromuserinfo[posts]$pmstats";
}
  eval("dooutput(\"".gettemplate("privmsg")."\");"); 


[NexDog]

Um, sorry if I'm missing the boat but what stats is it reading? How many PMs someone has received or what excatly?

[Zzed]

It is the total number of PM's a user has in their inbox and sent items folder.

[Boofo]

Thank you very much! Works great!

BTW: Will this count messages that they have in another folder? Like if they create a folder and move messages to it?

[Zzed]

You're very welcome.

It counts all the messages that belong to a particular userid.