[Release vB2.0] PM Stats 1.0

PM Stats 1.1 Hack | 28.05.2001-22:10 CET

What does it do:
This Hacks show some stats for your PM's, which includes:

Version 1.0

• It show per page all users who stores PM's in the database, sort by users with the most PM's.
  It shows: total PM's, new PM's and unread PM's
• Total PM's in database
• How many Users with at least one PM are in db
• Users PM average
• it highlight users who stores more then 90% of the current PM quota, so you can find those users fast.

Updated Version 1.1

• link to userprofile for direct edit (this one was requested)
• delete all PM's of one user (this one was requested)
• the last part is a little big tricky to explain: you can know see the Last Visit, Last Activity, Last Post of an user in different colors. What is it good for? Lets say you can easy see if an user is inactive and you can delete his PM's to keep your database clean. If there need to explain more, take a look at the screenshot or ask me and I'll try to explain it more.

I found this very usefull so I can trackdown which user stores how many PM's and how to set the PM quota. This idea is only usefull for those of us, who had some server limitation and like to find ways to keep the diskquota of the database small.

For version: vBulletin 2.0.0 (should work with RC2 and RC3, but for odler versions the CSS is missing).

Files needed: pmstats.php

Files to edit: pmstats.php

Templates to create/edit: none

Instructions are in pmstats.php file.

Screenshot http://www.studenten-city.de/stf/pmstats.jpg

FEEDBACK WANTED! Likes/dislikes/modification requests all gladly accepted.

[zarkov]

the lastactivity, lostpost & lastvisit date & times are colour coded Green for less than a week, Blue for 1 - 2 weeks old, and red for any date older that 14 days.

[zarkov]

Ive come up with this to stop the date problem
In pmstats.php

Find

PHP Code:

$lastpost = strftime("%d-%m-%y<br>%H:%M:%S", "$user[lastpost]"); 


and replace with

PHP Code:

if ($user[lastpost]==0){
$lastpost = "Never Posted";
} else {
$lastpost = strftime("%d-%m-%y<br>%H:%M:%S", "$user[lastpost]");
} 


All it does it looks for a dateline of 0 (no date) and sets $lastpost to Never Posted instead of the date.

[ibeblunt]

If the originator of this hack is reading this, how about a hack to be able to delete all PM's over a certain amount of days? Like delete PM's over [x] days old.

Warning: Division by zero in C:\HTTPD\upload\admin\pmstats.php on line 59

can anyone tell me why??

[the_sisko]

You don't have any PM's on the board, so you got this error. I need to add a if command for fixing this one...

Originally posted by The_Sisko
You don't have any PM's on the board, so you got this error. I need to add a if command for fixing this one...

But i do!! I got 122 Pm's in the database, 19 users with at least one

[the_sisko]

Did you installed this other stats hack you shows how many active user there are? This hacks adds a variable $limit to the boards, which I'm using too! You need to change then $limit in pmstats (all of it) to something else: e.g. $limit_pm

Originally posted by The_Sisko
Did you installed this other stats hack you shows how many active user there are? This hacks adds a variable $limit to the boards, which I'm using too! You need to change then $limit in pmstats (all of it) to something else: e.g. $limit_pm

Yes it helped Thank's a lot

[pwr_sneak]

Hi,

i just installed this hack on my Board for the first time an tried to access the stats. I was wondering why it didn't show up, checked my server and saw one HTTP-Process using 150 Megs of RAM....

After restarting Apache i took a look at the script ;(
There are lots of MYSQL Queries returning huge unused arrays.

I like this hack, but i have to rewrite it for my board for better performance. If this still doesn't work i will create daily static HTML Pages containing the PMStats output.

BTW my Board at http://www.amihotornot.de has 30000 Users with 270000 stored messages.

If someone is interested in the fast version of this hack, please let me know.

sneak

Always, you bet!

Anytime someone can increase performance and better something I'm all ears (and fingers and eyes)!

=-)