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

[ibeblunt]

I would be.

My site has over 60,000 users with 414680 posts. It's crazy these days.

Steven

[JackG]

Total PM's in database 2331

Users with at least one PM 441

Users PM average ~5

------------------------
Above is my stats. question, are these based on 'un read' messages?

Any chance of a search option ?

[the_sisko]

I know, there are many querys but I couldn't think of it to make it better at this time. I'm getting better and better maybe I should try to remake it, but the problem is to get all PM of a user in a group....I 'll take a look at it.

I have:
~1100 Members
~80000 post
~2000 PM's

so it works. I'am on my own server (PIII 800, 128MB..)

[JackG]

Good job on it The_Sisko, if you have time, you may want to add some features. It's a quality usefull hack.

[ShadowTech]

I am now getting an error after having to swap databases the forum was running on.
<<
Warning: Division by zero in c:\inetpub\wwwroot\vB\admin\pmstats.php on line 59
>>

I read higher that you said it's because there are no posts.. which I don't see that as the problem considering the pmstats.php file is listing the total PMs under that error as :
Total PM's in database 5440
Users with at least one PM 300
Users PM average ~18

I don't know what is causing this.. I redownloaded the pmstats file from this thread and reuploaded it trying to fix it.. but it still gets the error.. worked perfectly before the DB swap.

[Sinclair]

Originally posted by The_Sisko
...
I have:
~80000 post
...

90000 Posts!

Sinclair