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

[Bolas]

Me too.
I'm receiving mail throught GMAIL. -.-'



I see U are using

mail($email_to, $vbulletin->options['weasub'], $message, $headers);

to send mail. I think that are available some vb method to do that.



--------------------------------------
some minutes later...

Yes, it's available a function that uses rights methods.

function vbmail($toemail, $subject, $message, $notsubscription = false, $from = '', $uheaders = '', $username = '')

But I dunno if it correctly manages HTML format. I'm testing it.

[Bolas]

Ok, pay attention here.

I patched it using:

- vb method to send mail
- hooks change on-the-fly the Content-Type

Attached U will find:

new /includes/cron/weeklystats.php
new product-weeklystats.xml

@Jd19: U are free to use this patch on your next version

[Total666]

Originally Posted by Bolas

Ok, pay attention here.

I patched it using:

- vb method to send mail
- hooks change on-the-fly the Content-Type

Attached U will find:

new /includes/cron/weeklystats.php
new product-weeklystats.xml


@Jd19: U are free to use this patch on your next version

I tried this and I get a blank screen on the weeklystats.php .. Total

[Bolas]

--> Put it in the CRON directory, not in the root of your forum.

I just patched the cron and the product itself (adding a simple plugin in it) to use the text/html as Content-Type.

If U got blank screen it's because you overwritten the front-end file in your root.

So:
1) re-install my product patched
2) upload again original files released by Jd19
3) overwrite my weeklystats.php in ROOT/includes/cron/

[dina]

I just noticed that it pulls out information from hidden forums as well (even if the user group cannot view the forum).
Can you add something to exclude forums as well as user groups?

For example, if you have a hidden moderation forum and there are more replied to a thread in that forum than any other forum on the board, the title of that topic will appear in the statistic. Which can be a bit embarrassing if you're discussing something that's not meant to be of public knowledge.

[TheWhite]

great

[storpappa]

Bolas thanks for the changes - great mod made better

[Cybershaolin]

Originally Posted by Bolas

--> Put it in the CRON directory, not in the root of your forum.

I just patched the cron and the product itself (adding a simple plugin in it) to use the text/html as Content-Type.

If U got blank screen it's because you overwritten the front-end file in your root.

So:
1) re-install my product patched
2) upload again original files released by Jd19
3) overwrite my weeklystats.php in ROOT/includes/cron/

Hmmm I'd like to give it a try but I'm confused. You're saying to put the files in the CRON directory but you also say to re-upload the original files from Jd19!! This is where I'm lost.

I have the version made by Jd19 and as I said, I have a problem with the emails sent.

One of his files (weeklystats.php) is in the root so if I re-upload his files according to him, it should go in the root. But on your side your file goes in the CRON... Do we keep both files?

Anyhow, what are the correct steps for those who had the original hack? Should I remove the hack first and just use your files after? I am completely lost with the steps given.

[Distance]

Thanks!

[Kanustep]

The update cause my subscription e-mail confused, they are now like this:

Caro member, the user respondeu ao T?pico subscrito por si com o t?tulo - Thread title - no f?rum de ForumDOMAIN. Este t?pico est? localizado em: http://www.domainurl.com Esta ? a mensagem: *************** Message*************** Este t?pico poder? ter mais respostas, mas para as receber necessita de visitar o f?rum. Atentamente, ******~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Para remover a subscri??o deste t?pico visite a p?gina: http://www.domainurl.com Para remover a subscri??o de todos os t?picos, visite: http://www.domainurl.com

This is confused to read, but is how it appears on my e-mails, after I disable WeeklyStats the e-mail are full formated with paragraphs and etc.