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

[krazycivik]

this is what i get

CCWeeklyStats Email

Warning: mail(): SMTP server response: 503 Bad sequence of commands. You must specify the recipients of a message before you can send it in \includes\cron\weeklystats.php on line 327
Message has been sent to ....
Message has been sent to zep@torontonissan.ca....

Done

ok so i messed with some things and i got this now

CCWeeklyStats Email
Email alerts not enabled

Done

im lost

[Jd19]

Verified: This works fine on 3.6.4

krazycivik, you have a space before the username or the username is spelled wrong.

Second Error: You turned off the email alert system. It is the first option in the Weekly Stats Setting.

[krazycivik]

awsome got it working amazing hack man. great stuff..

[klaush]

Originally Posted by bada_bing

Ok and the trivial question isssssssssssssss.. Will this work with 3.5.3 ?

Nope! Just tested it...

It would be nice to have a working version for 3.5.x.

Possible?

[Jd19]

I could get it to work for 3.5.3 very easily but the problem is I don't have access to that version right now. I know that the table names changed from version 3.5.x to 3.6.x

Example:
users CHANGED TO user

Anyone got a test system, version 3.5.x that I could work with?

[ogameclub]

It runs in 3.6.4 very well.

Turkish weeklystats.php is uploaded.

Demo: http://www.ogameclub.com/v1/weeklystats.php

[Jd19]

<font color="Red">UPDATE RELEASED</font>

I've just released an Update! Please download the new update for enhanced features!

[krazycivik]

awsome got it working awsome hack thanx

[klaush]

Originally Posted by Jd19

I could get it to work for 3.5.3 very easily but the problem is I don't have access to that version right now. I know that the table names changed from version 3.5.x to 3.6.x

Example:
users CHANGED TO user

Anyone got a test system, version 3.5.x that I could work with?

Sorry, no test system...

But here we go:

Invalid SQL:
DELETE FROM vb3_cron WHERE varname LIKE '%CCWeeklyStats%';

MySQL-Fehler : Unknown column 'varname' in 'where clause'
Fehler-Nr. : 1054

[Jd19]

If anyone using this would be so kind as to post your URL in this thread HERE it would be greatly appreciated.