Dream's Forum Statistics

[Dream]

My monthly registrations are also 0s for some reason... it was working until this month.

[Carlos2]

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Anybody knows whats the problem when i try to see registrations statistics?

[control1110]

I happened on the first of this month thats all I know it worked fine before that

[Carlos2]

Cange:
$percent = ($total_users / $monthly_total) * 100;

to

If ($monthly_total > 0){
$percent = ($total_users / $monthly_total) * 100;
}


(in File statsmod/statistics_registrations.php )The same as doogie, the error doesnt appear now but all the month statistics are in 0, an also are 0 if you try to look them in admin panel :(

[Carlos2]

I also dissable the product, and the registraitions of last months are dissapeared...

This is a very bad thing :(

[Carlos2]

Today is working propertly again. Very strangeeeeee.

[max8028]

where would I import the statistics.php if i am using domainnames as my host.

I really need help on this one.

I am getting this error:

Warning: include(statsmod/statistics_general_stats.php) [function.include]: failed to open stream: No such file or directory in /statistics.php on line 203

Warning: include() [function.include]: Failed opening 'statsmod/statistics_general_stats.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /statistics.php on line 203

What Now?

[Dream]

Did you upload the directory statsmod/ ?

[max8028]

working thanks ! Looks good too

[centralss]

registration stats get this error at top of page. Shows no stats for the rest of the months of the year. Does show the stats for the current month. Any ideas?

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

[TeknoSounds]

ditto on that one ^^

[Audentio]

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

I got that when I clicked on Registrations.

Other than this error, its a great mod.

EDIT: After re-reading the thread I see that I am not the only one with this problem XD.

[Elenna]

Quick fix for the above, edit the /statsmod/statistics_registrations.php

Change line 105
$percent = ($total_users / $monthly_total) * 100;

to

if (empty($monthly_total)) { $percent = 0; } else { $percent = ($total_users / $monthly_total) * 100; }

[TeknoSounds]

sweet thanks Elenna :)

tho...continued with another error on line 110... replaced the daily and monthly percentage lines. Daily shows up fine now, but monthly doesn't display anything at all...its all 0's.

ideas?

[Elenna]

Not sure on that, sorry :( My board is new, so my should all have 0 in Monthly. lol

That was a quick fix that worked for me, so if someone else can edit it to work for them, good:)

[Artes_Marciales]

Great!! :)

[doogie1775]

Now I don't have any registration stats for some reason. However, if I go into the AdminCP, they are all there for daily and monthly as well? Otherwise, a great MOD - but would love to get the registration stats working correctly.

[murrtex]

thanks hilfe-forum

[expatdirectory]

Works a dream - installed without probs here (http://forums.theexpatdirectory.com/statistics.php)

Would be nice to know the strings used for content in each statistic i.e new member or top posters over past week etc.

This could then be placed into a left/right column as interest for users. Just a thought.

Clicked Install

[TomasDR]

I found the problem with Monthly registrations stats.

The section in statistics.php that computes the year(s) is incorrect:
// calc year to get registrations from
$year = $today['year'];
if ($howmany > $today['month']) {
$year--;
}
$year = $year - floor(($howmany - $today['month']) / 12);

// calc month since to get registrarions from
$month = $today['month'] - ($howmany - 1);
if ($month < 1) {
$month = 12 + ($month % 12);
}


The statement on line 1293 is incorrect.

$year = $year - floor(($howmany - $today['month']) / 12);

As mentioned in other posts this just started happening. It's because the default results number is 10 & November is the 11th month. What happens is if the results # is lower then the current month the PHP function "floor" rounds down but it's rounding down a negative number and then when you subtract a negative # you are adding, so it's getting registration stats for the year 2008!

$year = $year - floor(($howmany - $today['month']) / 12)
$year = $year - floor((10 - 11) / 12)
$year = $year - floor((-1) / 12)
$year = $year - floor(-0.0833)
$year = $year - -1
$year = 2007 - -1
$year = 2008

A simple fix is to use the "intval" function rather then "floor", which just returns the integer which is what was being attempted with the "floor" function and when the result is (-0.0833) it will return 0 which will work.

// calc year to get registrations from
$year = $today['year'];
if ($howmany > $today['month']) {
$year--;
}
$year = $year - intval(($howmany - $today['month']) / 12);

// calc month since to get registrarions from
$month = $today['month'] - ($howmany - 1);
if ($month < 1) {
$month = 12 + ($month % 12);
}

[TeknoSounds]

works great ty muchly!!!

[Merrillizer]

Thanks you TomasDR for the fix! I had just noticed a few minutes ago that I was getting that error when looking at registrations. I edited my statistics.php as you stated and it's back to normal. :D

[croportal]

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

[TeknoSounds]

croportal, please see the posts on the previous page, theres a fix

[TomasDR]

I sent Dream a PM and I am awaiting his reply. He states his code is all reusable now but I wanted to offer him some additions I made first otherwise I will be uploading an add-on to the statistics add-on.

I added:

The Post Groan Hack (https://vborg.vbsupport.ru/showthread.php?t=129975) (which compliments the Thank You hack)
Who has read a thread (https://vborg.vbsupport.ru/showthread.php?t=122594) (which I feel gives a better rating for thread views, then just the vBulletin view #)
VB Image Hosting (https://vborg.vbsupport.ru/showthread.php?t=123481) (a stats page similar to attachments showing: top uploaders, recent files, total files, total size, avg filesize)Of course each add-on is turned off by default.

I would be open to adding other popular add-ons.

[JohnnieOO]

OK, I am a complete idiot, how do I make the changes suggested by ThomasDR?

Johnnie

[nureeves]

So, just update the mod !!
I can't edit php file myself .. hehe

GBU All !!

[tekguru]

Sounds good Thomas - can't wait!

[doogie1775]

I found the problem with Monthly registrations stats.

The section in statistics.php that computes the year(s) is incorrect:
// calc year to get registrations from
$year = $today['year'];
if ($howmany > $today['month']) {
$year--;
}
$year = $year - floor(($howmany - $today['month']) / 12);

// calc month since to get registrarions from
$month = $today['month'] - ($howmany - 1);
if ($month < 1) {
$month = 12 + ($month % 12);
}


The statement on line 1293 is incorrect.

$year = $year - floor(($howmany - $today['month']) / 12);

As mentioned in other posts this just started happening. It's because the default results number is 10 & November is the 11th month. What happens is if the results # is lower then the current month the PHP function "floor" rounds down but it's rounding down a negative number and then when you subtract a negative # you are adding, so it's getting registration stats for the year 2008!

$year = $year - floor(($howmany - $today['month']) / 12)
$year = $year - floor((10 - 11) / 12)
$year = $year - floor((-1) / 12)
$year = $year - floor(-0.0833)
$year = $year - -1
$year = 2007 - -1
$year = 2008

A simple fix is to use the "intval" function rather then "floor", which just returns the integer which is what was being attempted with the "floor" function and when the result is (-0.0833) it will return 0 which will work.

// calc year to get registrations from
$year = $today['year'];
if ($howmany > $today['month']) {
$year--;
}
$year = $year - intval(($howmany - $today['month']) / 12);

// calc month since to get registrarions from
$month = $today['month'] - ($howmany - 1);
if ($month < 1) {
$month = 12 + ($month % 12);
}


This worked perfectly!!!! Thanks a MILLION Tomas :)

[rwoscott]

This worked perfectly!!!! Thanks a MILLION Tomas :)What he said TomasDR.

Thanks, such a simple fix in the end.

[Dream]

I updated the mod with TomasDR fix, and put a thanks notice for him on statistics.php.

Also I gave him permission to take this mod, modify it and release his own. I just won't add his addons by default because I won't be able to support them.

[Elenna]

Thanks, Dream and TomasDR!

To upgrade, do we need to replace all files, or just the statistics.php? And reimport, or no?

[Dream]

just statistics.php

[Saviour]

Dream...

I prefer this mod over another I was using...simply becuase it doesn't intrude on any of the forum pages...it has its own page...very nice feature.

Since you have incorporated the "Thank You" stats in this mod...it would only seem fair that you include the "Groan" stats as well from this mod: https://vborg.vbsupport.ru/showthread.php?t=129975

Hope to hear back from you soon on this one, Dream...

[Dream]

Tomas seems to have working code for the Groan hack, I won't add it because I wouldn't use it, sorry.

[Saviour]

So how do I get this code to use in your mod?

[Dream]

I don't have it, your best bet is to send Tomas a PM.

[loonytune15]

Thanks for the update, look forward to seeing the new mod...

[fishlore]

Thanks for the update! Just installed and monthly registrations are working again. Thank you.

[pyd]

What group will I find the phrases in, in the Phrase-manager?

[Dream]

global, they begin with statistics_ and some with dreamstatistics_

[pyd]

global, they begin with statistics_ and some with dreamstatistics_

Found it :)
Just finished translating it all into swedish.
Just waiting for some of my users to check the translation out...

Btw. Thanks for a great mod!

[Dream]

no problem, glad you like it.

[nureeves]

I have replaced all file with updated one
but it doesnt change anything ... my monthly registrations still going zero :(

do i miss something?
btw, i use vb 3.6.4

[Dream]

you just need to update statistics.php

[TomasDR]

I have posted my version here:
https://vborg.vbsupport.ru/showthread.php?t=164479

Thank you again to Dream's hard work.

[Carlos2]

Thanks for update ;)

[rwoscott]

I found another issue with the registration stats. Not a major drama.

If you select Results = 23 , you get 23 months.

If you select Results = 25 , you get 25 months.

Correct so far.

However, if you select 24 months, you get 36 months,
If you select 36 months you get 48 months.
If you select 48 months you get 60 months. I see a pattern here
The additional 12 months have a date of 01/01/1970.
(see attached).

I assume this is related to December being the 12th month.

Any ideas?

[Dream]

Try asking Tomas about this on his new mod thread

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

I haven't got the time to work on this right now, sorry.

[TomasDR]

I found another issue with the registration stats. Not a major drama.

If you select Results = 23 , you get 23 months.

If you select Results = 25 , you get 25 months.

Correct so far.

However, if you select 24 months, you get 36 months,
If you select 36 months you get 48 months.
If you select 48 months you get 60 months. I see a pattern here
The additional 12 months have a date of 01/01/1970.
(see attached).

I assume this is related to December being the 12th month.

Any ideas?

I will look into it, BTW did you try 24 or 36 when it was November?

[rwoscott]

I will look into it, BTW did you try 24 or 36 when it was November?

Possibly, but I don't remember. Sorry.

[SuperD]

Thanks for the mod but where exactly to upload the statistics.php and statsmod/ folder ?

[rwoscott]

Thanks for the mod but where exactly to upload the statistics.php and statsmod/ folder ?

statistics.php => forum/statistics.php
statsmod/ folder => forum/statsmod/

Ie. upload both to your forum directory.

[SuperD]

Thanks

[WhatChaMissin]

Works great
*clicks install

[TomasDR]

Possibly, but I don't remember. Sorry.

I took a look at the functions and did the math but it all looks good. I will continue looking but it might be next month, so I can see if a different month does the same.

[rwoscott]

I took a look at the functions and did the math but it all looks good. I will continue looking but it might be next month, so I can see if a different month does the same.

Cool, thanks mate.

[rwoscott]

I found another issue with the registration stats. Not a major drama.

If you select Results = 23 , you get 23 months.

If you select Results = 25 , you get 25 months.

Correct so far.

However, if you select 24 months, you get 36 months,
If you select 36 months you get 48 months.
If you select 48 months you get 60 months. I see a pattern here
The additional 12 months have a date of 01/01/1970.
(see attached).

I assume this is related to December being the 12th month.

Any ideas?

I'm no php expert, but I did the following to fix this error.

In statistics.php replace
$year = $year - intval(($howmany - $today['month']) / 12);
With
$year = $year - intval(($howmany - $today['month'] - 1) / 12);

I've tested it for this month and it seems fine.

I've run through it on paper and I think it should work for other months. (fingers crossed) :up:

[rokked]

great addon, thanks a lot for this
have it running over at
http://forums.rokked.com/statistics.php?forum=0&stats=topposters&show=10

[blastup]

i saw the http://www.s10planet.com/forum/statistics.php in your demo

but your mod is different from that? is there a way to change into that? with all the things displayed? let me know asap thanks

[TCE Killa]

Great hack, only thing is everytime I click Statistics now, a 404 error comes up, so I move the statistics.php to my actual rout directory and an even bigger error comes up saying error on line 46 statistics.php.... Atleast with the other error, the page isn't found until I get assistance, thanks. I have uploaded the forum folder and all of its contents to my rout directory and imported the product and changed the optional settings, just an error - page not found when I actually click the statistics link. Any help would be highly appreciated, thanks.

[TCE Killa]

Lol nevermind, I managed it, great hack.

[rwoscott]

I'm no php expert, but I did the following to fix this error.

In statistics.php replace
$year = $year - intval(($howmany - $today['month']) / 12);
With
$year = $year - intval(($howmany - $today['month'] - 1) / 12);

I've tested it for this month and it seems fine.

I've run through it on paper and I think it should work for other months. (fingers crossed) :up:
I've checked this month and all seems to be OK with the above fix.

[Elenna]

I'm not sure that the Exclude Usergroup ID thing is working for me.

We have 115 registered users. I have excluded 6 usergroup IDs from Statistics.

In the User listing (General Statistics) removes the users properly; however, other statistics (user profiles, age) is not taking the excluded groups into account, and is displaying statistics for all of my 115 members.

[Dream]

In some places I believe the exclude usergroup is not taken into account because of design decisions, but I can't remember now (it's been 1 year).

Anyone test this on 3.7?

[Nynaeve]

Love the hack, but I ran into this problem after installing it. Here's the error message I get from the statistics.php page:

Warning: main(statsmod/statistics_general_stats.php) [function.main]: failed to open stream: No such file or directory in /statistics.php on line 206

Warning: main() [function.include]: Failed opening 'statsmod/statistics_general_stats.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /statistics.php on line 206


And I can't figure out what I did wrong. Any ideas/clues/suggestions?

[Dream]

Did you upload the statsmod directory?

[Yuuko_Kitaiko]

I'm a second admin on the same forum, so I'm doing most of the uploading. The statsmod directory...all the files in the statsmod folder are uploaded to our server, as well as the statistics.php file. Was there anything else in there, becuase I didn't see anything.

I'm thinking it might be a problem with how they were uploaded, but if it's the lack of this file, then that would make it worlds easier, I suppose.

[Dream]

The error is that statistics.php is not finding the files in statsmod/

Where did you upload both?

[Yuuko_Kitaiko]

Edited all that because it's not worth looking at now. Yeah, the directory was the problem, and I got that all sorted out. Thank you so much for your help. This is a whole first time thing with working on vBulletin for me, so I'm a bit out of sorts with it.

Anyway, thanks again.

[futuredood]

How do you get it to show all the stats at once like this site, rather than having to select it from the drop down?

http://www.s10planet.com/forum/statistics.php

[Dream]

thats an old version that I dont have anymore.

[Peejay]

Just installed, great stuff to satisfy all the 'stato's out there, love it.

Here's our working version http://clubaristo.net/forums/statistics.php

Feel free to add it to your list of live demo's.

Many thanks.
PJ

[RedGTiVR6]

Anyone test this on 3.7?


bump?

I'd like to know as well.

[Dream]

This seems to be working fine on 3.7, no errors so far.

[DiverTree]

This seems to be working fine on 3.7, no errors so far.
workin fine for me too ... 3.7.0. thanks :)

[Dream]

Yeah it's working for me too. Maybe some day I'll update it to add Blog and Profile stats. Right now I'm really busy with other projects of mine.

[DiverTree]

Yeah it's working for me too. Maybe some day I'll update it to add Blog and Profile stats. Right now I'm really busy with other projects of mine.that would be cool, but i dont even have those features right now. im off to update my spider list ;)

[RedTrinity]

I would really appreciate any help with this error...

Warning: Division by zero in [path]/includes/functions.php(5501) : eval()'d code on line 102

Just installed for the first time on 3.7 :confused:

[paulnis]

Any chance of upgrading t his to 3.7?

[Sgt Pepper]

wow u guys r having alot of trouble with this......i installed first go and got it easy......Dream added very simple rules....cant see how u wud get it wrong

[rwoscott]

I would really appreciate any help with this error...



Just installed for the first time on 3.7 :confused:

Try this fix (https://vborg.vbsupport.ru/showpost.php?p=1388706&postcount=270)

[Elenna]

In some places I believe the exclude usergroup is not taken into account because of design decisions, but I can't remember now (it's been 1 year).


If I wanted to modify it to properly exclude the excluded user groups, where might I do that? And am I allowed to, if I don't release the changes?

[Dream]

If I wanted to modify it to properly exclude the excluded user groups, where might I do that? And am I allowed to, if I don't release the changes?
Not sure sorry, haven't looked at the code for a while now, and yes you can modify it at your hearts content.

[SVTCobraLTD]

You say not to use it on a big forum. What do you classify as a big forum?

[voter]

You say not to use it on a big forum. What do you classify as a big forum?
I have trouble, as of my forum got big in sense of amount of users and search bots 100-200 surfing forum at same time, which makes my CPU crazy especially from a lot of queries

SELECT count(*) AS 'PostsThisMonth'
FROM vbpost
WHERE YEAR(FROM_UNIXTIME(dateline)) = YEAR(NOW())
AND MONTH(FROM_UNIXTIME(dateline)) = MONTH(NOW())

This is really too cpu intensive mode.

Dearm I really didn't understood why still a lot of mentioned queries are runing, even if I disable access of guests and bots to statistic.

[akee]

Maybe do you upgrade it to vb4?

[Dream]

Sorry, but it's not likely. Very few people installed this mod, and it's not even used that often in my own forums.

But anyone is allowed to update this script to 4.0 if they want.

[Art Andrews]

That is a shame because this is one of the best and cleanest little plugins that we use. :(

[Dream]

I think Val's advanced forum statistics has most of the statistics of this mod, I'm using that one now.

[acast]

I think Val's advanced forum statistics has most of the statistics of this mod, I'm using that one now.Well, that's not so true, i think this plugin was the best plugin of vbulletin stats ever.