Statistics Modifications - vB Weekly Stats [Archive]

Jd19

11-20-2006, 10:00 PM

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 (https://vborg.vbsupport.ru/member.php?u=147554) - 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-projects/1514-project-vb-weekly-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

Jd19

11-20-2006, 10:27 PM

Reserved

FleaBag

11-20-2006, 11:06 PM

Very nice! Nominated for MOTM. :) Thanks.

Jd19

11-20-2006, 11:31 PM

Thank you!

bada_bing

11-20-2006, 11:33 PM

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

ninjamaster

11-21-2006, 12:34 AM

thanks for this 1:)

Floris

11-21-2006, 02:44 AM

Nice little hack to bring the stats to the end user! :) Keep up the good work.

projectego

11-21-2006, 03:25 AM

Awesome! Thanks. ;)

Hornstar

11-21-2006, 03:48 AM

Very nice addition, however is there a way to set which usergroups can view this.

Thanks.

Zia

11-21-2006, 08:28 AM

its really nice...

but can u add few more options here
its just showing a numerical summury page

like :
* Latest Poll n vote stats -
* Higtes Replied & hightes hited thread -
* Registerd user's name for the week -

Html coded..
Like a community news letter...
It would be very nice

thnx

TheBlackPoet

11-21-2006, 11:06 AM

i have been hoping that someone would write this hack.... and here it is... not to sound unappreciative, but Zia's idea sound like a great enhancement to an already great hack that i am voting for MOTM...

Jd19

11-21-2006, 12:08 PM

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

I think this will work fine in 3.5.3 although I have not tested. I will create a test system tonight and see if it does. If I remember correctly, the database changed from 3.5.3 to 3.6.x (changing the users table to user).

Very nice addition, however is there a way to set which usergroups can view this.

Thanks.

Yes, if you go to your admin-cp and general settings and then select Weekly Stats Alert System you can change which groups view it. Separate these by comma delimited ids (EX: 1,6,10).

its really nice...

but can u add few more options here
its just showing a numerical summury page

like :
* Latest Poll n vote stats -
* Higtes Replied & hightes hited thread -
* Registerd user's name for the week -

Html coded..
Like a community news letter...
It would be very nice

thnx

Thanks for the suggestion! I'll add these in the next release which will probably be this week. I'm also going to change the display which I am not very happy with, its a bit hard to read.

I've added these to my todo list at
http://forum.codecall.net/community-projects/1514-project-vb-weekly-stats.html#post8426

Please keep any more suggestions coming! I'll be more than happy to add them.

Canis Firebrand

11-21-2006, 12:16 PM

Jd19

11-21-2006, 12:23 PM

Very nice and great suggestions so far.

I'm not sure what this one stat is tracking though as the wording isn't anything I can find at first glance.

Number of Activity This Week

Also, you have the webpage title hard coded. You might want to make it use the vb phrasing so that the individual forum title will be in there instead of CodeCall Programming Forum - Weekly Stats.

Make it be vb[title] - Weekly Stats.

Or whatever vb phrasing gets you the title of the forum.

The number of activity so far is the amount of users that have visited this week total. I should reword that. Thanks for the tip.

Ahh, the title slipped my mind! I completely forgot about it. I've added these items to my todo list. Thank you!

Canis Firebrand

11-21-2006, 12:24 PM

Thanks.. Looking forward to the updates. This is exactly what some of the users at my site have been wanting.

Zia

11-21-2006, 01:06 PM

helo Jd19..
pretty impressive ur prompt action..

I just thinking it as a new modified version of Commbull (Community Bulletin) (https://vborg.vbsupport.ru/showthread.php?t=127870&highlight=combull+community)

that thing isnt working working for vb3.6.3..

I trust all of the vb3.6.3 user will be gratefull to u..if it comes with all the new feature :)

sure i will vote it for MOTM :)

Thnx Man.

rasun

11-21-2006, 05:42 PM

Nice one, *klick install* ;)

Thank You

Jd19

11-21-2006, 05:51 PM

Thanks guys! I just released an Update which you all might want to download. The Display and Email looks a lot better now and has some of the features you guys requested.

ninjamaster

11-21-2006, 06:32 PM

thanks for the update :)

Hornstar

11-22-2006, 05:26 AM

Request: Number of Registrations This Week:

when you click view, if it could also have the amount of posts they have next to their name.

However I'm thinking there could be a problem with showing over a thousand peoples names down the page.

What would be the best solution for this? maybe showing them down in columns? or showing a max of 300 per table or something.

thanks.

Jd19

11-22-2006, 12:34 PM

Hmm, that is a good suggestion. I didn't link about large amounts of registrations (as mine only gets about 10 a day) but those who get 100s a day added up for a week would make quite a long list.

I'll probably have to limit the amount shown and then make it a configuration field.

UncoderMom

11-23-2006, 06:16 AM

lol 3.6.4?

God I love this place!

Great addition! Thanks!

Kadi

11-24-2006, 10:56 AM

Great!!! I've been waiting for something like this. :)

A few questions:

Will it work on 3.6.4?
Can I change which day and time it is sent?

Thanks

Jd19

11-24-2006, 01:32 PM

Not sure, is 3.6.4 out? If it is, I'll test it and see.

You can change the Cron job to change which day the email is sent. It is called CCWeeklyStats.

There is a bug, the installer doesn't put the title in the Scheduled task, so, when you edit it make sure you put a title in or it will not let you save.

Zia

11-25-2006, 02:23 AM

Hello JD19,
congrats to be a coder at vb.org :)

Man- Got lots of request to u around this stats mod..
:) thanks allready u have implimetd some..

Do u planning to release a Full Featured News Letter System...?
or u will modify it as that..

Some Request
******************
- Show Last (X) Announcement(s) from particulr forum ID or name.
- Showing Top (X) no. of clickable thread
- SHowing Latest (X) no. poll - klikable
- Top (X) new thread.
- Adding Ibpro arcade intigration- Show Newly installed Game Name/Qty.
- Total Thread & Total Post count & Total Registerd Users count.

***********************
And competeable with vb3.6.4 ?

Thnx

krazycivik

11-26-2006, 10:35 PM

ive installed this hack but when i type in the domain forums etc all i get is a white page. have i dont somthing wrong? ive set everything up the way you said. 3.6.2 or it dosent work with this version? thanx

Jd19

11-26-2006, 11:21 PM

Zia, still haven't tested with 3.6.4. Thanks for your suggestions, I will consider them.

Krazycivik, I haven't tried it on that version so I don't know but it should work fine as it doesn't change anything and only reads the database. The screen that goes white is the weeklystats.php page? Have you tried running the cron job and seeing if the email gets sent?

krazycivik

11-27-2006, 03:16 AM

nop.. ok im on cron but i dont know what else to do im new with this thanx would appreciate if you could explain..

Cheers,

Greek Wizard

11-27-2006, 06:50 AM

Seems to be working frin on 3.6.4.

manual cron worked, will have to wait a week for auto cron, but it should be fine.

installed.

Jd19

11-27-2006, 11:44 AM

Auto Cron jobs reports 0 for everything. I'll be updating today with a fix and some other changes.

Greek, thanks for testing!

Krazy, once inside of scheduled tasks find CCWeeklyStats and click run now.

You may have to go into vBulletin Settings and selected Weekly Stats then change the users that are being emailed.

krazycivik

11-27-2006, 12:51 PM

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

11-27-2006, 09:26 PM

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

11-28-2006, 12:22 AM

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

klaush

11-28-2006, 09:36 AM

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

11-28-2006, 03:14 PM

ogameclub

11-28-2006, 05:29 PM

It runs in 3.6.4 very well. :D

:D Turkish weeklystats.php is uploaded. :rolleyes:

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

Jd19

11-28-2006, 05:38 PM

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

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

krazycivik

11-29-2006, 04:24 AM

awsome got it working awsome hack thanx

klaush

11-29-2006, 04:40 AM

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

12-03-2006, 01:41 PM

If anyone using this would be so kind as to post your URL in this thread HERE (http://forum.codecall.net/community-projects/1621-sites-using.html) it would be greatly appreciated.

Greek Wizard

12-04-2006, 02:55 AM

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

12-04-2006, 03:01 AM

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

12-06-2006, 02:41 PM

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

Omranic

12-08-2006, 03:58 PM

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

12-11-2006, 02:00 PM

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

12-12-2006, 03:02 PM

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

12-12-2006, 03:21 PM

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

DementedMindz

12-12-2006, 03:24 PM

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

12-13-2006, 03:25 AM

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

12-13-2006, 09:43 PM

French language ;)

Translator: Sofia

The dman

12-13-2006, 11:46 PM

Installed

Thank you for this great hack.:)

farooqaaa

12-14-2006, 02:39 AM

Easily, HackOfTheMonth :)

Installed - Added to my forum. Good job!

DementedMindz

12-15-2006, 10:17 PM

Jd19 any word when the corrections will be made and released?

DementedMindz

12-16-2006, 12:26 AM

I have almost every error fixed except I still cant get it to show up for microstats and one other error in $from == "" because it has no value there for the form. I tried to change it and get a db error. other then that if that I cleaned the whole html code up.

Total666

12-16-2006, 07:29 PM

Dumb question ? Sorry - so to let the members view the stats I should just make a link in the forum to http://www.XXXXXX.tv/forums/weeklystats.php , thnaks

neolab

12-16-2006, 07:59 PM

French language ;)

Translator: Sofia

Bonjour

Dommage que la traduction porte que sur le panel d'administration, car le template comporte toujours toutes phrases en anglais :-(

Jd19

12-23-2006, 08:22 PM

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? :)

The tables being backwards or just that you translated it?

Jd19 any word when the corrections will be made and released?

I'll try to get all of the errors fixed soon. I have some time to work on it and for some reason I stopped getting emails when people reply to this thread...

Jd19

12-23-2006, 08:24 PM

Dumb question ? Sorry - so to let the members view the stats I should just make a link in the forum to http://www.XXXXXX.tv/forums/weeklystats.php , thnaks

Yes but you have to allow their groups to view it. By default, they should be able to view it already.

Cybershaolin

12-26-2006, 01:21 PM

Stats page works but email page give me weird results:

This is what I get in my email:

Content-type: text/html; charset=iso-8859-1
From: myemail@myforum.com
Message-Id: <somenumbers here@myserver>
Date: Mon, 25 Dec 2006 1442 -0500 (EST)

<HTML>
<HEAD>
<TITLE>Weekly Stats</TITLE>
<script type="text/javascript">

</script>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<table border="0" width="100%" BGCOLOR="#465786" border=1>
<tr><td><font color="#FFFFFF"><center>Current Week Stats - 0 Days Total</center></FONT></td></tr></table>
<table cellpadding="1" cellspacing="1" border="0" width="100%">
<TR BGCOLOR="#6e7a9a">
<td colspan="2">
<font color="#FFFFFF">Threads/Posts</font>
</td>
</tr>
<tr>
<td>
Number of <strong>Threads</strong> This Week:
</td><td>
0
</td>
</tr>
<tr BGCOLOR="#efefef">
<td>
Number of <strong>Posts</strong> This Week:
</td><td>
0
</td>
</tr>
<tr>
<td>
Most <strong>Viewed Thread</strong> Created This Week:
</td><td>

Jd19

12-26-2006, 02:17 PM

It is showing you the HTML as ASCII. Do you have an HTML capable viewer?

Bolas

12-26-2006, 02:34 PM

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

12-26-2006, 03:50 PM

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

12-26-2006, 09:08 PM

Bolas

12-26-2006, 09:29 PM

dina

12-28-2006, 07:56 PM

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

01-02-2007, 02:56 AM

great

storpappa

01-11-2007, 03:19 PM

Bolas thanks for the changes - great mod made better

Cybershaolin

01-11-2007, 04:39 PM

--> 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. :confused:

Distance

01-15-2007, 08:00 PM

Thanks!

Kanustep

01-16-2007, 12:31 PM

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.

skoenig

01-18-2007, 05:56 AM

Great mod. Very very useful for our moderators and myself.

FYI The most recent version does seem to cause all vB emails sent to be treated as HTML emails or to have all their carriage returs remapped...resulting in :

Dear skoenig, You are subscribed to the thread "Bluetooth Pairing Problems" by ReneeRoberts, there have been 1 post(s) to this thread, the last poster was Jackskid. http://domainurl.com These following posts were made to the thread: ************ Treo headset pairing http://domainurl.com /1989-bluetooth-pairing-problems-post8488.html#post8488 Posted by: Jackskid On: 01-17-2007 10:07 AM I had pairing problems with my Treo Headset also. This worked for me. Go to prefs>hands-free> then check always route call to hands-free. ---Quote (Originally by ReneeRoberts)--- It seems my original Palm Treo Bluetooth Headset won't stay properly.

~ Steph

FireFish

01-18-2007, 11:04 PM

I just needed to uninstall this mod because it seemed that it was affecting my vB automated e-mails. They were lacking line breaks; once I disabled this mod, all was back to normal.

mack324

01-19-2007, 09:18 PM

AHHHHHHHHHHHHHHHHHHHHHHHHHH

uploaded, when i try to get to forum i get

Fatal error: Cannot use string offset as an array in /home/*******/public_html/global.php(356) : eval()'d code on line 321

cupra

01-19-2007, 09:51 PM

thx, good one - installd!

criscokid

01-21-2007, 10:08 AM

FYI The most recent version does seem to cause all vB emails sent to be treated as HTML emails or to have all their carriage returs remapped.
Read the thread for this mod I was looking forward to installing it... until I got to news that the latest version is causing problems with emails. Hopefully this'll get sorted soon... looking forward to installing.

skoenig

01-22-2007, 04:09 AM

It's a great mod and well worth the effort. Just got a little buglet that I'm sure will get ironed out soon...

~ Steph

TheWhite

01-23-2007, 04:55 AM

Serious BUG found i'm using VB 364 and while having version 140 installed i had NO problems with my general forum emails, in the last few days since i updated to version 150 all my forum email was being crunched or parsed for some reason after days and nights of uninstalling every single hack and backstepping anything that i might of altered i found out that the 150 update is causing this so i put back the 140 verion and everything is working at 100% can the author please look into it and comment about this???

Regards

stomph

01-23-2007, 10:22 PM

This hack also garbled my standard emails that vb sends.

I traced it down to the plugin called 'replace Content-Type with text/html in headers'. If I understand correctly, it simply replaces 'text/plain' in all email-headers with 'text/html'. However, the content of the standard emails from vb are not HTML and so there is no formatting to apply and everything is just one line!

I deactivated the plugin.. and badabing: Emails are formatted correctly again as plaintext.
I ran the weekly cronjob and the Statusmail displayed correctly as text/html in my mailclient (kmail)??
I don't quite understand why.. maybe kmail checks for html-tags. Although it does say 'text/html' in the header.. however, it seems to work! :)

Exitilus

01-24-2007, 07:43 PM

The fix for this is to Disable the only plugin that this Mod creates.

Realize that the e-mail will come showing all HTML so it won't be parsed.

skoenig

01-24-2007, 07:50 PM

Fixed in v1.5
This is not an official fix and may not work for you. This is a general purpose fix for all HTML emails sent through Vb and has been tested on vB v3.6.2 with PHP 5xx

1. Go to the Plugin Manager
2. Search down to Product: Weekly Stats
3. Click: replace Content-Type with text/html in headers
4. Replace contents with:

if (stristr($message,'<HTML>')){
$headers = str_replace('text/plain','text/html',$headers);
}

Explanation
This patch searches the message body for <HTML>. If it finds it it then replaces the content type with the content type for HTML emails. It's not bullet proof and can be fooled but for most people it should work fine.

If you want a bullet proof solution specifically for Weekly Stats the following should work:

if (stristr($subject,'SUBJECT OF YOUR WEEKLY STATS EMAIL HERE')){
$headers = str_replace('text/plain','text/html',$headers);
}

This can be made more efficient using the stripos() function to return as soon as the fist occurrence of the string in etiher case is found.

I've also modded the original install with the primary general purpose fix above for those who want it.

This is not endorsed nor approved by the original authors but here for those who may need it. All the other usual disclaimers apply.

~ Steph
forum.treonauts.com

TheWhite

01-25-2007, 04:22 PM

ok guys thanks

Jd19

02-05-2007, 12:23 PM

Sorry for not fixing this bug sooner or responding to this thread at all. As I said, I rarely check this forum.

Fixed in v1.5
This is not an official fix and may not work for you. This is a general purpose fix for all HTML emails sent through Vb and has been tested on vB v3.6.2 with PHP 5xx

1. Go to the Plugin Manager
2. Search down to Product: Weekly Stats
3. Click: replace Content-Type with text/html in headers
4. Replace contents with:

if (stristr($message,'<HTML>')){
$headers = str_replace('text/plain','text/html',$headers);
}

Explanation
This patch searches the message body for <HTML>. If it finds it it then replaces the content type with the content type for HTML emails. It's not bullet proof and can be fooled but for most people it should work fine.

If you want a bullet proof solution specifically for Weekly Stats the following should work:

if (stristr($subject,'SUBJECT OF YOUR WEEKLY STATS EMAIL HERE')){
$headers = str_replace('text/plain','text/html',$headers);
}

This can be made more efficient using the stripos() function to return as soon as the fist occurrence of the string in etiher case is found.

I've also modded the original install with the primary general purpose fix above for those who want it.

This is not endorsed nor approved by the original authors but here for those who may need it. All the other usual disclaimers apply.

~ Steph
forum.treonauts.com

Thanks for the update. I'm going to rename this to version 1.6 and release it and credit the update to you. If you are interested you can join the official project on my forum and I'll add you as an modifier here.

kushal

02-05-2007, 01:51 PM

Is there a way that it sends email to all the members of the forum board?

skoenig

02-06-2007, 06:44 AM

@Jordan

Thanks for the offer. I'd love to help out but I got RealLife(tm) commitments that sadly get in the way of the fun stuff. I'll gladly help out when and if I can just can't guarantee anything... Put me as a mod here if you'd like and I'll check in every now and then at the very least increase coverage a bit.

I'll check your forum too...

~ Steph

rjmjr69

02-07-2007, 04:13 AM

So all and all is this now running on 3.6.4 ok? No more buggie's? I've been watching this thread and it seems as though allot of the issues are worked out anyone care to chime in on it?

Nathan2006

02-14-2007, 10:47 AM

One word Jd19

WOW! :D

Love this thank you

Install

PinkDaisy

02-14-2007, 02:30 PM

Installed!! My members love this!

perfphysio

02-15-2007, 04:55 PM

This is working OK on my board but when i run the scheduled task manually from within admin I get the following message, Warning: mail(): SMTP server response: 503 5.5.2 Need Rcpt command. in \includes\cron\weeklystats.php on line 320

Any ideas?

daddygrim

02-28-2007, 12:21 PM

i installed it...it's working!!!

|Jordan|

03-20-2007, 01:30 AM

When i enter my username in the "users to email" field and run the task, i get the following error:

Fatal error: Call to a member function on a non-object in /home/*******/public_html/includes/class_mail.php(261) : eval()'d code on line 7

When i leave the "users to emai" field blank or the default "Administrator" the task doesnt report any errors, but the email doesnt get sent to me.

daddygrim

03-20-2007, 02:07 AM

mine isn't sending out anything.

Sjakie

04-06-2007, 07:05 PM

Is it possible to exclude a forum from displaying on the stats page? Because moderator topics are shown on this page also, but obviously cannot be seen by registered user when the link is clicked.

4number8

04-06-2007, 08:06 PM

It would be great to be able to send this to all registered users, instead of just the one's we have to add in the options.

adwade

04-14-2007, 07:25 PM

When i leave the "users to emai" field ... default "Administrator" the task doesnt report any errors, but the email doesnt get sent to me.

Ditto. :( I'd installed this sometime ago and forgot about it. Re-tripped acoss this thread and went back to look at it. Sure enough, the default 'Adminstrator' was in there. :mad: Not having a user named 'Adminstrator' it's been doing nothing all-this-time.

Revised 'Adminstrator' to my username, went into Scheduled Task Manager and did a run-now, and Wha-La! :D Sent a report out just fine!

Suggestion: Remove 'Adminstrator' from the field by default as you release the MOD.

My only question at first was, "Does it want a user number -or- a username?" Other than that, it was pretty straightforward. It's just having 'Adminstrator' in that blank makes people assume that it's OK.(ie.. ready to run)

LadyHoney

04-14-2007, 09:10 PM

I love this .. i put the link under Quick Links and its accessible to me and members at any time. dont have to wait for emails ..

Jd19

04-17-2007, 11:55 AM

Is it possible to exclude a forum from displaying on the stats page? Because moderator topics are shown on this page also, but obviously cannot be seen by registered user when the link is clicked.

I'll be implementing this in the next version. This is a large bug I think and an oversight by me. Thanks for pointing it out.

It would be great to be able to send this to all registered users, instead of just the one's we have to add in the options.

I don't know, this would be more like spam. If other people want to use this I'll add the feature though.

Ditto. :( I'd installed this sometime ago and forgot about it. Re-tripped acoss this thread and went back to look at it. Sure enough, the default 'Adminstrator' was in there. :mad: Not having a user named 'Adminstrator' it's been doing nothing all-this-time.

Revised 'Adminstrator' to my username, went into Scheduled Task Manager and did a run-now, and Wha-La! :D Sent a report out just fine!

Suggestion: Remove 'Adminstrator' from the field by default as you release the MOD.

My only question at first was, "Does it want a user number -or- a username?" Other than that, it was pretty straightforward. It's just having 'Adminstrator' in that blank makes people assume that it's OK.(ie.. ready to run)

I'll make it more clear what needs to be added and remove "Administrator" as the default.

Mrdby

04-17-2007, 07:14 PM

Thanks!!!

Sjakie

04-17-2007, 08:25 PM

How to upgrade? Overwrite all or just the xml file?

Mrdby

04-17-2007, 09:10 PM

How to upgrade? Overwrite all or just the xml file?

yep:p :p

Sjakie

04-18-2007, 08:59 PM

Witch one is it? All, or just the XML

itsblack

04-22-2007, 02:39 AM

Hi, I got these errors, anyone can help?
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

05-04-2007, 01:40 PM

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

05-04-2007, 04:23 PM

Thank You This lookin awesome

z0diac

05-12-2007, 12:04 PM

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

05-12-2007, 12:19 PM

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

05-31-2007, 07:21 AM

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

YabbaDabba

06-09-2007, 11:25 PM

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

:confused: 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:

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

YabbaDabba

06-09-2007, 11:28 PM

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