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

[Greek Wizard]

This is a nice hack, but I have a problem with it.

When you get the e-mail, it lists the new users on the bottom.

When you click on one of them, I assume their profile is supposed to load up, but insteasd you get an error:

vBulletin Message
This user has not registered and therefore does not have a profile to view.

The problem IMO is that the link goes to:

http://www.xxxxxxxx.com/forums/member.php?find=lastposter&f=4701

When it should be:

http://www.xxxxxxxx.com/forums/member.php?u=4701

lastposter&f=4701 would be the last post on Forum ID 4701, not user 4701

Anyways, I am sure it's an easy fix, I have not had a chance to look at it and see what needs to be changed, but I thought you should know.

[Greek Wizard]

Like i said, I naver had a chance to look.. but I knew it was easy to fix:

Open includes\cron\weeklystats.php

Find:

// Create a user list from $getregs
while ($reg = $vbulletin->db->fetch_array($getregs)) {
	$user_display .= " <A HREF=\"" . 
		$forum_url . 
		"/member.php?find=lastposter&f=" . $reg['userid'] . 
		"\">" . $reg['username'] . "</A> | ";
}

Replace with:

// Create a user list from $getregs
while ($reg = $vbulletin->db->fetch_array($getregs)) {
	$user_display .= " <A HREF=\"" . 
		$forum_url . 
		"/member.php?u=" . $reg['userid'] . 
		"\">" . $reg['username'] . "</A> | ";
}

Not tested, but should work

[Jd19]

Thanks, I'll include this in the next update!

[Omranic]

nice work

I have a problem with it: Style Replacement Variables are proccessed so some style features (customized style) doesn't appear & make the page disturbed.

Suggession: it's not hard to make this hack depends totally on templates & not to include designing code within prog. code, also it's will be nicer if it becomes fully phrased, also make the hack depends on forum encoding when sending mails, finally you can use vbmail instead of php mail function to get advannce of its features.

we can help any where.
note: don't forget the first problem.

thanks

[Jd19]

UPDATED Version: Fixed Link for above problem

SolidSnake, Please post a link to your stats so I can see what you mean about the template. I'm assuming the vbmail function doesn't support HTML so I've used my own. Does it? I started with the intention of using the template in the email but disregarded it for several reasons. I particularly like the way it looks right now without a lot of extra information to look at.

[DementedMindz]

very nice mod would be nice to see the html removed from the php file and the html code cleaned up a bit This page is not Valid XHTML 1.0 Transitional! Failed validation, 202 errors :surprised: im cleaning my php file up now of alot of the errors but there is alot. also mods like microstats dont work with this well

also is you look at the html code you have

<title>CodeCall Programming Forum - Weekly Stats</title>

that needs to be changed also

[Jd19]

How are you testing the HTML and I will correct the code? What is microstats???

[DementedMindz]

Originally Posted by Jd19

How are you testing the HTML and I will correct the code? What is microstats???

you can check all your html code on this page

http://validator.w3.org/

I have removed alot of errors so far im down to Failed validation, 32 errors so its not to bad so far. as for microstats its right here

https://vborg.vbsupport.ru/showthread.php?t=116027

[Omranic]

Jd19
Have a look here: http://www.phpkd.com/vb/index.php
& then have a look here: http://www.phpkd.com/vb/weeklystats.php

Understand me?

[Allan]

French language

Translator: Sofia