Statistics Modifications - vB Weekly Stats

Title
vB Weekly Stats - Display and email weekly forum stats

Version: 1.7

Description
A plugin that will display and email weekly statistics for the vBulletin forum software. The project was spurred from a project that a fellow forum member was working on which got me thinking about a better way to monitor what was going on. This allows me to keep up with statistics very easily and monitor the progression my forum is making.

Language: PHP

Tested System: CodeCall.net

License
GNU although a link back to http://www.codecall.net would be nice for anyone using.

Todo List/Bugs

• Make XHTML compliant

Change Log

Version 1.6 - 17

• If the CRON script is executed after 12:00 you no longer get zero filled values.
• You can now exclude forums from showing (Options)
• Username has been clarified in options (bolded) so that no one is confused. The default username "Administrator" has been removed and set to blank.

Version 1.5 - 1.6 by skoenig - Thank you!

• Fixed major bug in Email Plugin - All emails sent from forum now function correctly.

Version 1.4 - 1.5 by Bolas - Thank you!

• Now Uses vB method to send email
• Hooks change on-the-fly the Content-Type

Version 1.3 - 1.4

• Corrected Link in newly registered members display

Version 1.2 - 1.3

• Added Previous Week and 2 Weeks Ago to weekly display.
• Removed User Requests, requests are removed after they are completed so the actual number is always 0 (unless you never complete them).
• Modified cron job to run 15 minutes before 12:00 which will prevent the email being filled with 0 values.
• Added post number to newly registered users this week (in brackets beside name).
• Aligned newly registered users in a table to conserve space.

Version 1.1 - 1.2
-- Changes by TkTech

• (None) tags instead of mis-drecting links when no threads found

Version 1.0 - 1.1

• Added all registered users names for week using Javascript.
• Changed Display, grouped common seciotns
• Added Most Replied and viewed thread created this week.
• Fixed Title - CodeCall isn't hard coded any longer
• Changed wording of Activity Number

Notes
This software is in the version control system of CodeCall.net. If you would like to contribute, please join this forum and become a member. All suggests are greatly welcome!

Install (after you unzip)
1. Upload all files in the upload directory to the root of your forum directory (where index.php is).

2. Login to the admin control panel

3. Goto Plugins & Products and click on Manage Products

4. Click on Add/Import Product

5. Browse to the directory of Weekly Stats and Select Weekly-Stats.xml

6. Click Import

7. Setup the product in vBulletin Options

8. Thats it, your done! You can access the stats at http://www.youdomain.com/forum/weeklystats.php

The cron job is scheduled to run every Sunday at 11:59 which will deliever stats to your email
account.

Support
Support will be given at http://forum.codecall.net/community-...kly-stats.html only. New releases will appear there first before they are updated here. Create a post at this URL for installation problems, bugs or suggestions. I will not be checking this thread very often.

Demo
http://forum.codecall.net/weeklystats.php

[itsblack]

Hi, I got these errors, anyone can help?

PHP Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 84

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 95

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 106

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 146

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 158

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 169

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 180

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 189

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 199

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 208 


meanwhile there are also no results to display except "Most Viewed Thread" and "Most Replied To Thread".

[z0diac]

I've never upgraded a plugin/product before, just done fresh installs.

Do I need to remove the old one through the Product/Plugin menu in vB?
Or just re-install using the Product/Plug menu?
Or I just copy over the old script files with the new ones?

Sorry for the newbie question but I don't want to mess up my current config.

[iorkara]

Thank You This lookin awesome

[z0diac]

DOes anyone know how to do an upgrade??? I"ve never done one before. Do I re-install using the vB installer? Do I just copy over the files in the o/s ?? Do I uninstall and re-install?? Anyone???

[Mrdby]

Originally Posted by z0diac

DOes anyone know how to do an upgrade??? I"ve never done one before. Do I re-install using the vB installer? Do I just copy over the files in the o/s ?? Do I uninstall and re-install?? Anyone???

this hack? just over write it.

[Hornstar]

This has come along nicely. finally installed it today. nice.

[YabbaDabba]

PROBLEMS

1 - Stats Table Title Bar

This Week: Current Week Stats - 5 Days Total
Last Week: Current Week Stats - 11 Days Total
2 Weeks Ago: Current Week Stats - 11 Days Total

Shouldn't it be something like:

This Week: Current Week - 5 Days Total
Last Week: Last Week - 7 Days Total
2 Weeks Ago: 2 Weeks Ago - 7 Days Total

I see the same issue on your own site. If a basic number is wrong, the confidence in the reported stats rapidly approaches zero.

2 - Bad Stats

I do not understand the numbers that are being reported at all.
We consistently have about 30K posts per week.

For example, in ACP > Statistics I see post counts for the last 3 weeks of:
Week 22 (June 2007) 27296 (partial)
Week 21 (June 2007) 28326
Week 20 (May 2007) 29352

However, your numbers for the same period are:
26835
25114
83889 (yeah, 83K. Is this a 3 week Cumulative Total?)

Similarly for threads, ACP reports:
Week 22 (June 2007) 1523
Week 21 (June 2007) 1516
Week 20 (May 2007) 1629

And your numbers are:
1442
1275
4417 (again, maybe a 3 week cumulative total?)

So there are really 2 issues here:

1. Your numbers for "Two Weeks Ago" are just plain wrong
2. Your numbers don't match vB reports

[YabbaDabba]

SUGGESTED CLEANUPS

1 - Stat Description Cleanup

Number of Threads This Week:
Number of Posts This Week:
Most Viewed Thread Created This Week:
Most Replied To Thread Created This Week:
Number of Registrations This Week:
Number of Bans This Week:
Number of Infractions This Week:
Number of User Promotions This Week:
Number of Active Users This Week: <== based on how I'm interpreting your query
Number of Attachments Uploaded This Week:
Number of Private Messages This Week:
Number of Poll Votes This Week:

Your descriptions and bolding are very inconsistent. The purpose of the report is to convey information, not confusion.


2 - Period
You use "Current Week" much too casually. Sometimes you mean last week, sometimes you mean this week.

It would be so much more useful if you actually spelled out the start/stop dates instead of saying "current week".

Weekly Stats - June 4 thru June 10
Weekly Stats - May 28 thru June 3

This should be done in BOTH the e-mail and the php display page.


3 - User Registrations Expansion Link

Need to add a mouseover effect so it doesn't look like a dead link.

Supporting a standard vB expand/contract graphic would help too.


4 - Phrase Lib Support

Desperately needed

[YabbaDabba]

SUGGESTED FEATURE

Let the admin define the reporting period in the admin control panel.
The current Monday thru Sunday period is not very standard.

[thenewuser]

Useful for marketing, thanks, installed!