Dream's Forum Statistics

[Dream]

Warning: This add-on is not good for big forums, it calculates all the info on the fly.

This will add a page with statistics to your forum.

Forum Statistics
- Newest Members
- Posts per day (last x days)
- Posts per month (last x months)
- Forum open since
- Average posts per day overall
- Average threads per day overall
- Average replies per thread overall
- Active members percentage
- Oldest thread

Top Posters
- last year
- this year
- last month
- this month
- last 24 hours
- last 7 days
- last 30
- overall

Threads
- most viewed
- most replied
- top rated
- most replied in the last X days (choose X in the options, default is 10).

Polls
- Most voted
- Latest polls

Users
- Top Thread Starters
- Top Reputation
- Top Referrers
- Top Posts Per Day Average
- Users with most attachments
- Most viewed/downloaded attachments
- Latest attachments

Thank You Hack
- Most Thanked Users
- Who Thanked Most
- Most Thanked Posts

Attachments Statistics
- Statistics for each attachment extension
- Most viewed/downloaded attachments for each extension
- Latest attachments for each extension
- Total attachments and downloads for each extension and overall
- Average downloads per attachment

Most Active Forums
- Last year
- This year
- Last month
- This month
- Last 30 days
- Last 7 days
- Last 24 hours
- Overall

Age Statistics
- Oldest/youngest members
- How many members on each age range

Custom Profile Fields Statistics
- Percentage of each option chosen by your members

Registration Statistics
- Daily registrations
- Monthly registrations

Statistics for each forum
Choose the forum you want to view statistics from. Only forums people have permission to see are shown.

Options in the Admin Control Panel
You can exclude forums/usergroups/users from the statistics, disable the attachments statistics page and set other options.

Administrators Only Option
You can set the statistics to be shown only to administrators.

Installation
You just need to import a product and upload a few files (statistics.php and statsmod/ folder). There are options in the Admin Control Panel, the modification is fully phrased and a few templates are added. An optional navbar template edit is needed to supply a link to statistics.php.

New Poll Bar Images
You have the option to use a new set of poll bar images that comes with this mod as your default poll bar images.

Please leave the url to your statistics.php in this thread for me to use as a live demo if you can.

Live Demos:
http://www.s10planet.com/forum/statistics.php
http://www.yaxleyvillage.com/statistics.php
http://jpicforum.info/statistics.php
http://www.vbulletin-ressources.com/forum/statistics.php
http://www.torreiravirtual.net/fairplay/statistics.php

[Tom_S]

It don't work:

Invalid SQL:

SELECT userid, username, threads, usergroupid
FROM vb_user
WHERE threads > 0
ORDER BY threads DESC LIMIT 10;

MySQL Error : Unknown column 'threads' in 'field list'
Error Number : 1054

[projectego]

Thanks! However, a screenshot or demo link wouldn't hurt... ;)

[Wulfnoth]

I got this error:


Invalid SQL:
SHOW COLUMNS FROM user LIKE 'post_thanks_thanked_times';

MySQL-Fehler : Table '1_historik-forum.user' doesn't exist
Fehler-Nr. : 1146
Datum : Thursday, March 1st 2007 @ 06:21:59 PM
Skript : http://www.historik-forum.org/forum/statistics.php
Referrer :
IP-Adresse : censored
Benutzername : censored
Klassenname : vB_Database

[Tom_S]

I don't think this was tested. The author was online when I posted first and there is no response. I assume he will respond to this thread but until then I will be passing on this mod.

[Dream]

Ok, please try again.

And let me know if any errors occur.

[Wulfnoth]

I've made a screen. Looks very nice!

[Dream]

Thanks Wulfnoth :)

If you got a live demo and can share please drop the link in this thread.

[Tom_S]

Nope...Reinstall didn't work

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT userid, username, threads, usergroupid
FROM vb_user
WHERE threads > 0
ORDER BY threads DESC LIMIT 10;

[Dream]

I don't know why you don't have a threads field in the user table sorry. Thanks for trying the mod though.

[Tom_S]

No problemo but I will bet if I had that issue I won't be the only one. It does look sweet though from the screen capture in Wulfnoth's post.

[Tom_S]

I have two different setups of 3.6.4 both on different servers to include a test 3.6.4. It does that on all of them.

[Dream]

Thanks, maybe it's some other mod I have here that added that field. We'll see.

[dizzy100]

I don't know why you don't have a threads field in the user table sorry. Thanks for trying the mod though.

Doesn't work for me either on 3.6.4, exactly the same error.

Removing

$list = array();
$results = $db->query_read("
SELECT userid, username, threads, usergroupid
FROM " . TABLE_PREFIX . "user
WHERE threads > 0
ORDER BY threads DESC LIMIT $howmany");
while ( $entry = $db->fetch_array($results) ) {
$list[] = $entry;
}

From statistics.php allows the module to work (apart from thread starters of course)

[aveon]

i cant get it working same how getin the same error like other friends

hep please

[Dream]

I updated the code, added a check for the existence of the field threads, if it doesn't exist it won't run the code and won't show that category. All should be working now.

[UncoderMom]

Is there a way to add the top thanked and top thanker's?

[Dream]

It's already there :)

[Dream]

Updated again, the threads field was from another mod, I changed the query so it won't use that field anymore, and the category will show.

[Tom_S]

You got it that time. Nice clean install. Works great. ;)

[Dream]

We are post brothers now, with our souls linked for all eternity =:O

[Tom_S]

Problem. When you click any of the links they take you outside of the board to the root directory of the website...well in my case it does.

Post Bruddas! Cool! ;)

[Tom_S]

Fixed. In statistics.php find:
function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]./member.php?u=$user[userid]\">$name</a>";

Where it has /member.php you need to change it to ./member.php and the next two after..

You know what I mean?

[Dream]

Fixing now.

Can you still PM me your statistics.php address?

[Tom_S]

Cool...that means you knew what I meant....I was doing that quick because I had something going on. I was going to just paste the whole thing but didn't think that was a good idea.

[Dream]

Sorry, actually I don't think I understood. Your $vboptions[bburl] shouldn't end with a trailing slash, and it should be the address of your forum.

[Tom_S]

Okay...You have this:
function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]/member.php?u=$user[userid]\">$name</a>";
}

It needs to be this:
function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]./member.php?u=$user[userid]\">$name</a>";
}

Same thing with the function statistics_make_thread_link & the function statistics_make_post_link

[Dream]

Ok I got that, I didn't understand why its needed. Sorry but that would make

http://www.domain.com./member.php

[Tom_S]

Don't know what to tell ya but that is what it took to make it work on mine. Other wise if I clicked any link I got a 404 error. Let's say I was clicking a user link
(example) this is user anonymous and the link would be http://mysite.com/member.php?u=2 now after I did the edit that same link shows as http://mysite.com/forum/member.php?u=2 which then works.

[Tom_S]

No matter...I am calling it a day. That is what made it work for me so if anyone else has the same issue that will work for them. If not and the clean install works then that is the kewlest also ;)

[Dream]

On the General vBulletin Options, theres a forum URL option. Check if you have

http://mysite.com

or

http://mysite.com/forum

there, the latter would be the correct one.

[aveon]

i re installed it but still no seem to be workin anyways ill wait for anothervrsioon of this hack i guess

[Tom_S]

On the General vBulletin Options, theres a forum URL option. Check if you have

http://mysite.com

or

http://mysite.com/forum

there, the latter would be the correct one.

Nope. That isn't it. Mine is set correctly.

[Dream]

Aveon, what's happening?

Tom S, maybe time will tell us what is happening. Hey man click install! :P

If you have any ideas for new statistics let me know in this thread. They are fairly easy to add if the database query is simple.

[Tom_S]

Working fine now with the new updates ;)

[Dream]

Aveon, download again, now it should work.

[Dream]

Updated, added Top Posters this month, this year and on the last 7 days.

Let me know if you think its slow.

[UncoderMom]

It's already there :)


I love you! :D


*installed*

[Tom_S]

Updated, added Top Posters this month, this year and on the last 7 days.

Let me know if you think its slow.

You updated again?

[Tom_S]

Nice...You should put rows 1, 3, and 4 on the same row though. It would tidy it up. It would for me anyway ;)

[aveon]

yea now its wkin and looks good but i didnt like the design of the template chck the attchmen file for screen shot...

[Dream]

The statistics are divided in categories, they wouldn't make sense if I grouped those statistics in the same table.

[Tom_S]

The categories would speak for themselves by the header name of each table. I am talking about doing it like this:

[Dream]

Uhm in my taste it wouldnt look better like that.

I can make you a version like that when I have some time.

[Dream]

Updated, added more statistics (forum open since, threads and posts per day and oldest thread).

See if you like it more now, I removed the tables stretching all the way to the end.

Don't forget to re-import the product xml.

[Gizmo5h1t3]

yep, excellent addition, works a treat except for the uncached templates.... Uncached templates: STATISTICS_MISCBIT (4)
Uncached templates: STATISTICS_MISC_TABLE (1)

and the layout could be a lot better, as mentioned above, make it use the whole width of the page, rathewr than just down the left side...but a crackin hack nonetheless.

[Dream]

Updated, added posts per day each day.

Also added the templates to the cache.

If you want the tables to use the whole width of the page, change width = ''; for width = ' width="100%"'; in statistics.php

[Tom_S]

Sorry my brother. I went with this hack instead:
https://vborg.vbsupport.ru/showthread.php?t=122986
I like yours but it just don't have those options for sleekness. I know you can do that though and better ;)

[Dream]

No problem :)

That mod may slow down your forum home if you have a busy forum, that's one of the reasons I made this mod.

[Gizmo5h1t3]

Updated, added posts per day each day.

Also added the templates to the cache.

If you want the tables to use the whole width of the page, change width = ''; for width = ' width="100%"'; in statistics.php

worked a treat that, thanks.

[Dream]

No problem

Updated, added average replies per thread, users with most attachments and most viewed/downloaded attachments

[Dream]

Updated, added top posters last year and last month, latest attachments, top rated threads, most replied threads in the last 10 days and user posts per day ratio.

Kids don't forget to turn off unregistered from rating threads ;(

[Opus4]

I decided to install & check this out, compared to Top Posters. Since there are more stats to display, this page takes longer to load.

I noticed that there isn't support to limit which usergroups are included/excluded for some of the stats, so I added "AND usergroupid IN (2,5,6,7)" to some of the WHERE lines in statistics.php in order to prevent listing banned users & so on.

[Dream]

I'll add an option for that in the next version.

[albahrain]

I've installed it on my forum and it's really looks nice and helpful but the case is when i click on any of the resaults links it directs me to the thread but without the forum folder as follow:
instead of http://www.mywebsite.com/forum/thread or member number and info
it go's to http://www.mywebsite.com/thread or member number or info.

so the messing here is the forum folder.

could you please guide me throw correcting this.

thanks in advance.

[Opus4]

That's another comment I was going to make this morning... :)

In statistics.php, I removed all the $vboptions[bburl]/ parts of the links it creates. I don't know why that change worked, but the links worked for me after that.

[Dream]

Thanks Opus4 :)

Updated, I removed all unnecessary $vboptions[bburl]/ and added an $exclude_usergroups option in statistics.php, where you can put the user group IDs you don't want included in the statistics.

Let me know if you have problems with this version.

[Opus4]

This works for me, thanks. :)

If you want another suggestion... for the Posts Per Day list, can it be limited to members who have been around X number of days? It shows a high rate for someone who just signed up within the past couple of hours and has posted just a couple times.

Speaking of the PPD list, is it possible to show the total posts after the user's name?

The only other thing I'm curious about is how much of a load this puts on the forum server. I don't plan to load the stats page that often anyway, but I just wonder because of the time it takes to gather all the info that gets displayed.

[albahrain]

Thanks Man,

It's working perfect now.

[Dream]

Opus, yes I can put a day limit in PPD, good idea for people that have a high number of posting new members. I've been seeing weird stats in mine too. I'll put in a 1 day limit just so it won't show weird stats, but you will be able to change that in the script.

I'll squeeze the total messages in it too.

I don't have any server load statistics to tell you, but you can use vBMicroStats (https://vborg.vbsupport.ru/showthread.php?t=140449) to check yours out. This isn't the kind of page that is used often, so it having a higher use of queries should be fine.

(it's actually loading fast for the amount of stuff it does in my opinion)

[Dream]

Updated, added total posts in Posts Per Day, and made settings for the mod in the vBulletin Options in the AdminCP.

Don't forget to put your private forum IDs in the "Exclude Forum IDs" setting!

[Opus4]

Updated, added total posts in Posts Per Day, and made settings for the mod in the vBulletin Options in the AdminCP.Thanks -- the Posts Per Day works much better and the CP settings make changes easier.

I can't think of any other useful suggestions for now... :)

[akulion]

oh so good

thanks

[Dream]

Updated, added Who's Online support, and also added Active members percentage.

[akulion]

thanks

lol mine is terrible!!!
Active members percentage
10.33% (154 active members, 1491 total)

[Dream]

Mine is 21% :P

But I deleted some old members with 0 posts.

[akulion]

its good u made this mod

i am an old SMF user and they have stats of all kinds built in.
so when i switched over i was missing those

thanks again for this, it really makes forum management a bit more fun

[Dream]

Glad you liked it :)

[Dream]

Updated, added Posts Per Month, and fixed so it gets the information with the right GMT settings.

[Dream]

Version 2.0!

You can now choose the forum you want to show statistics from! Users see only the forums they have permission to see.

Attachment statistics page added, with detailed statistics on attachments for each forum.

If you are upgrading, remove your private forums from the exclude forums list, because they aren't needed anymore! This mod is now smart enough to let you see the forums you have permission to see, and hide them from users that don't have permission to see them.

A special thanks to the vBulletin.org coders community that was very nice and helped me with questions while developing this version.

Let me know how this works out for you.

[Dream]

Updated, added poll statistics.

[Dream]

Updated, added missing phrases. ("Posts" and "Rate")

No one told me they weren't showing! ;/

[henners]

Any way to have something like "most active forums", based on posts, for past 24 hours, past week, past month, maybe year etc... Would be really useful to understand which of my forums are getting the most use and which could be possibly deleted :)

[Dream]

Sure, I'll add that in the next version.

But, you have to click install then ;)

[Yours Truly]

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT (sum(tr.vote) DIV count(tr.threadid)) AS rate, sum(tr.vote) AS total, count(tr.threadid) AS votes, t.threadid, t.title
FROM threadrate AS tr
LEFT JOIN thread AS t ON (tr.threadid = t.threadid)
WHERE t.visible = 1 AND t.forumid IN (2, 11, 20, 4, 34, 5, 6, 35, 7, 8, 10, 22, 12, 44, 17, 43, 15, 16, 19, 37, 38, 39, 40, 41, 42, 32, 36)
GROUP BY tr.threadid
HAVING votes > 1
ORDER BY rate DESC, votes DESC LIMIT 10;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DIV count(tr.threadid)) AS rate, sum(tr.vote) AS total, count(t
Error Number : 1064
Date : Thursday, April 12th 2007 @ 12:53:28 PM
Script : http://www.beernweed.com/forums/statistics.php
Referrer : http://www.beernweed.com/forums/index.php
IP Address : 81.77.74.63
Username : Yours Truly
Classname : vb_database

Ideas?

[Dream]

What MySQL version are you using?

[sebbo]

I would like to allow this feature only to one usergroup. Could that be possible? So that all usergroups would be in those statistics but only one usergroup could see this mod.

[Dream]

I'll add that in the next version.

[Dream]

Updated, removed Top Refereers when the list is empty, and added Can't View Statistics option.

Yours Truly: try this version and let me know if it works

henners: I had to release this update, I'll work on the Most Active Forums next

[Dream]

Updated, added Forum Activity page, which can be disabled in the options. Also added option for minimum ratings a thread must have to show in Top Rated.

henners, let me know if this is what you wanted

Next Version: Age Statistics

[henners]

looks good to me, but i'm getting a blank page (apparantly loading, but doing nothing) whenever I go to the statistics.php page. Uploaded php doc and imported product fine, no usergroups blocked at all, just not loading.

am i doing something wrong?

[Dream]

Can you PM me your forum address?

[Yours Truly]

Can you PM me your forum address?
Is this made for PHP 5+?

[Dream]

No. Did you try the new version?

[Yours Truly]

No i will give that a quick spin :)

[Yours Truly]

Works now cheers :)

[Dream]

Updated, forum activity page was showing private forums for users that don't have permission to see them.

[henners]

Is this made for PHP 5+?

Hmm. We use php 5 here, would that cause a problem?

[Yours Truly]

Hmm. We use php 5 here, would that cause a problem?
No it's fine :) He made an update for it so it will work fine with yours :)

[Dream]

This should work with both PHP 4 and 5.

[Dream]

Updated, added age statistics. It shows your oldest/youngest members, the percentage of age groups in your forum and the average age. The age groups to show are totally configurable in the Admin Control Panel:

Single age, ex: 13
Age range, ex: 14-20
Older than, ex: 80+
Youger than, ex: 13-

Also added a new set of poll bar images you can use instead of the default ones. Just upload the polls/ content to your style images/polls/ folder.

[FreshFroot]

Thanks dream, very nice update. I was also wondering, how we could place this say on the forum home? I also liked the forumhome stats hacks we've had here, like top 5 stats or similar to cybs stats hack. Can we use say the variables you used in the php file on the forumhome template to bring up top5 for certain categories "top 5 posters".."5 latest new members" etc..

[Dream]

Sorry I don't plan to add this to forum home. This would be another mod. If anyone wants to use code from this to do that be my guest.

[FreshFroot]

hmm if I have time I might try it out.. otherwise I have to install another stats hack just for the forums.

Thanks for the reply Dream.

[Slave]

Wonderful hack :) ... thank you.

One thing, maybe a bug. When you enter a forum ID into the "Exclude Forum IDs" setting, the forum disappears from the forum activity page but doesn't disappear from the dropdown menu within the display options.

Something that could be fixed? Thanks :)

[Dream]

I may have missed it, I'll take a look at it.

[Slave]

Thanks :) .. Any chance you could also add an option for showing v3Arcade stats?

To get an idea of what could be shown take a look at ..

http://www.v3arcade.com/forums/showthread.php?t=1265

[Dream]

That could be a lot of work, and I'd have to add for both v3Arcade and ibproarcade. Also I would have to worry about updates being made to those add-ons. But I'll think about it for a later version.

Which arcade system do you use?

[Slave]

v3Arcade .. sorry I updated my post above when I remembered there was more than one arcade :)

[romanticyao]

thanx for the update

[voter]

Uhm in my taste it wouldnt look better like that.

I can make you a version like that when I have some time.
Responses to Cyb'S stats shows, that it is better to make a possibility, that admins define which tabales comes in which colum or rows.

Hundred people hundred tastes, put some options for making the own design/order.

[Dream]

Yes but now this mod is a little too big to do that, sorry. Maybe someday.

[Dream]

Updated, added link to show age statistics for active members only.

Fixed bug that was showing forum from excluded forums list in the select box.

Fixed the link to thanked posts that was changed in the last Post Thank You Hack update.

[Slave]

Hi Dream,

Any chance you could move the dropdown options to the top of the page? (yeah I know it's easy to edit the template but it would be nice not to have to do it every time you bring out a new release :p)

[Dream]

I'll add that option in the next release :)

I don't think you need to edit the template again though, the template didn't change.

[Slave]

ahh .. cool .. thanks :)

[maroceve]

Here is what i get when i try and get age stats :

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT SUM( Y - SUBSTRING(birthday, 7) ) / COUNT(*) AS average
FROM user
WHERE birthday != '' AND birthday_search NOT LIKE '0000-%';

MySQL Error : Unknown column 'Y' in 'field list'
Error Number : 1054
Date : Friday, April 20th 2007 @ 04:47:06 PM
Script : http://www.maroceve.com/forums/statistics.php
Referrer : http://www.maroceve.com/forums/statistics.php
IP Address : 81.192.184.75
Username : Ez
Classname : vb_database

[Dream]

Your vbdate() function is not working for some reason. Did you change any code related to that?

You could make a test and change all vbdate( for date( in statistics.php and see if it works

[maroceve]

I i dunno, the only stuff that is related to dates etc is vbevent forums that i have installed....or can you think of any majour addon that is not compatible with ur hack ?

[Dream]

Try using this as your statistics.php (rename it) and let me know if it works

I don't know of any mods that don't work with this one. Any mod that disabled vbdate() for some reason would affect this mod though.

[NeRilkA]

Hi Dream i just came to talk about my errors and with this file everything works great now !!

thanks a lot and great hack :)

[NeRilkA]

oh just a little thing

Active members percentage 0% ( active members, 2138 total)

They may be not enough active but 0% ;)

[Dream]

Thank you :)

I saw your forum, there are some bugs in the statistics there :/

In the file you got, I just changed the function vbdate for date. I'm not sure why your vbdate function is not working, all your forum dates shouldn't be working then.

Your active members problem could be related to the vBTrends mod.

The "Forum open since" isn't working either, seems to be a problem related to vbdate too.

Can you check your forum's includes/functions.php and see if you have a "function vbdate" on it?

[NeRilkA]

yes i have a function vbdate on it

with the old file the dates was d-m H/hi etc

for active members i thought it could be the problem but i wasn't sure

[rjmjr69]

Nice worked the first time very easy to install. One thing though is this a normal amount of queries for this? I'm sorta thrown back by the amount

Page generated in 0.18370 seconds with 52 queries [Server Loads: 1.51 1.37 : 1.33]

[Dream]

NeRilkA: Try using the attached statistics.php file

rjmjr69: yeah :/ the front page is big and has a lot of statistics, I may be separating it into pages in a later version

[NeRilkA]

i put your file, but the % are still there

[NeRilkA]

it does the same with the dates in email notification for example, is it because it's french date ? (may be stupid question lol)

[Dream]

Try this one

Yes dates with locale are different

For this mod's options, you should use this format

http://www.php.net/manual/en/function.date.php

[NeRilkA]

it works ! great thanks a lot

[Dream]

No problem :) the active members problem is most likely a problem with vBTrends.

[rjmjr69]

NeRilkA: Try using the attached statistics.php file

rjmjr69: yeah :/ the front page is big and has a lot of statistics, I may be separating it into pages in a later version


Actually now that i think of it. I like having them only run on one page. As long as it does not add to any of the other areas I'm good with the way it is. Thank you works great

[Dream]

No problem :) glad you liked it

[Dream]

Updated, added user profile statistics, or custom profile field statistics.

Added total disk space and average filesize in attachments stats page.

Added option to show stats navigation on top.

To upgrade read upgrade.txt, there are new files.

If you have problems with dates showing something like "d-m" you need to change your day/month/time stats options using the format in this page

http://www.php.net/manual/en/function.strftime.php

[rjmjr69]

I love this addition its great. I do not mind the queries for they are only when you call for the stats so no biggie it does not slow the site down any. Anyway I've come across an error or bug.....

https://vborg.vbsupport.ru/external/2007/04/8.jpg

What can I do to get that to show correctly. He should be listed as the Youngest


Woops found another I enabled the Profiles option and I get this error at the top of the page and nothing is displayed.

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 9

I do not mean to be a pest with all these issues but best you know about them right?
Well when viewing any of the statistics pages the Welcome Box has an image icon but no image I can click the icon and set view image it refresh's the page and all is well. Normally it will say Good Afternoon Rjmjr69. Its a hack I have installed. But when viewing the statistics page it only has the icon and Afternoon no GOOD? If you need a link to the mod let me know. But its called GoodMoring/Afternoon/Evening images hack Also all the font colors in the shout box and usergroup colors are wrong until a refresh?
Thanks


Another request can you make it so certain categories wont appear? Like Last Year my site is not even 2 month's old yet so its empty there and its at the top. And could it be worked to allow custom placement of the box's/categories?

[henners]

When you run the .php for the first time, does it do some thinking first or does it work straight away?

The only reason I ask is that i've installed twice and on both occasions it seems something has gone crazy when I try and load the stats page, CPU loads hits 100%, apache crashes etc... This is probably an issue with our (dedicated) server, but I have no control over that, and each time this happens I get services restarted within a minute or so (so the forum stays up!) Should I be brave and let whatever is happening continue, or is this not normal ;)

Cheers, I don't have much time atm but I really like your mod!

[Slave]

Wonderful thanks for the update :)

One thing, I seem to have lost the dropdown menus?!

I reverted my STATISTICS template as I'd played with it to put the dropdown menu at the top. Since then they have disappeared. Any ideas?

http://www.yaxleyvillage.com/statistics.php

[Slave]

hmm .. I reuploaded the .php file and all is well .. ?!?

Just seen that the User Profile page is blank .. what is it meant to be showing?

[NeRilkA]

For me the page Profil works fine but the SQL error for birthday came back

Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT SUM( Y - SUBSTRING(birthday, 7) ) / COUNT(*) AS average
FROM user
WHERE birthday != '' AND birthday_search NOT LIKE '0000-%';
MySQL Error : Unknown column 'Y' in 'field list'
Error Number : 1054
Date : Saturday, April 21st 2007 @ 05:50:13 PM
Script : http://www.vbulletin-ressources.com/forum/statistics.php
Referrer : http://www.vbulletin-ressources.com/forum/statistics.php
IP Address : 172.184.77.234
Username : NeRilkA
Classname : vB_Database

I put the date in the right format but these errors came back too :Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1184

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1180

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1176

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1177

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1167

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1274

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1512

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1519

The statistiques for Last Year don't show up like Last Month, Post per Day and Post per month

[hurik]

hi,

very nice mod but i have a suggestion (i hope nobody has suggest this before, i was to lazy too read the whole thread! :) ):
i would make an cron job which calculate the whole stats every hour and save it somewhere in the database and when an user look at the stats it only load the result and this would HIGHLY reduce the server loads.

my board has 800 k post, 20 k user and when 500 user are in the boards it take:
"Page generated in 187.23493004 seconds (0.05% PHP - 99.95% MySQL) with 41 queries" and i have an server with:
CPU: Dual-Core AMD Prozessor - Opteron? 1218
RAM: 4 GB
HD: RAID1 2 x 400 GB

ant thats only when i look at the stats. when i would make it open for all it would kill my server ...

hurik

i hope every body understand my bad english ...

[Dream]

rjmjr69, if you only have one member with birthday in your forum, it will show him as youngest and oldest of your forum.

I'm gonna look into this problem in the foreach.

About your welcome box, I can take a look into your forum, but you will need to enable statistics for guests for me to view it. Do you have a link of the mod for me to take a look at it?

About disabling single statistics, I may do this in the future, but I'm not sure how, this mod has many statistics and making an option for each one in the Statistics options would make the options be too big.

edit: don't worry you are not being a pest :)

[Dream]

hmm .. I reuploaded the .php file and all is well .. ?!?

Just seen that the User Profile page is blank .. what is it meant to be showing?

I'm glad it seems to be working now, right? You just needed to revert your template and reupload the files.

The User Profile page will only show info if you have Custom Profile Fields, like "what do you like most: cats / dogs". It will show how many people chose what.

If you don't have any custom profile fields set in your board you are safe to disable the User Profile Page in the options.

[joker2040]

Installed! You can view my demo at http://www.s10planet.com/forum/statistics.php

[Dream]

Thanks joker, can I use that as a live demo? :)

[Dream]

For me the page Profil works fine but the SQL error for birthday came back



I put the date in the right format but these errors came back too :

The statistiques for Last Year don't show up like Last Month, Post per Day and Post per month

Nerilka, how do you set up your vBulletin date formats? Did you try to set this mod's formats exactly the way you made your vBulletin date formats?

If you did and you can't make this work, I'll change this mod to force using of the date() format instead of the locale format. (like the version I made before that you used)

[joker2040]

Thanks joker, can I use that as a live demo? :)

Yes... Thanks again for this great mod!!!

[Dream]

Thank you :) looking good!

[Dream]

hi,

very nice mod but i have a suggestion (i hope nobody has suggest this before, i was to lazy too read the whole thread! :) ):
i would make an cron job which calculate the whole stats every hour and save it somewhere in the database and when an user look at the stats it only load the result and this would HIGHLY reduce the server loads.

my board has 800 k post, 20 k user and when 500 user are in the boards it take:
"Page generated in 187.23493004 seconds (0.05% PHP - 99.95% MySQL) with 41 queries" and i have an server with:
CPU: Dual-Core AMD Prozessor - Opteron? 1218
RAM: 4 GB
HD: RAID1 2 x 400 GB

ant thats only when i look at the stats. when i would make it open for all it would kill my server ...

hurik

i hope every body understand my bad english ...

Hurik, I'm sorry to hear that, you are the first owner of a bigger board that lets me know how this mod went.

This mod shows a lot of statistics, I wouldn't know how to cache them all.

I'm thinking of breaking the general statistics in pages, like Top Posters page, Thread Statistics page etc, I think that would help you to run this better. Let me know what you think and what pages with statistics you would like to see.

Oh and I understood you just fine ;)

[Dream]

When you run the .php for the first time, does it do some thinking first or does it work straight away?

The only reason I ask is that i've installed twice and on both occasions it seems something has gone crazy when I try and load the stats page, CPU loads hits 100%, apache crashes etc... This is probably an issue with our (dedicated) server, but I have no control over that, and each time this happens I get services restarted within a minute or so (so the forum stays up!) Should I be brave and let whatever is happening continue, or is this not normal ;)

Cheers, I don't have much time atm but I really like your mod!
Henners, sorry about that, as I said in my last post I'll do a version of this mod that doesn't show all statistics in one page, that should let you run this mod.

[Dream]

Updated, I broke all statistics into pages. This version should be easier on the server.

It's loading a lot faster now.

Nerilka, I think I fixed your problem with dates. Use this (http://www.php.net/manual/en/function.date.php) format for the options now.

[lighter]

When using the latest version, i view user profile but get

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 9

[rjmjr69]

My users are required to enter their birthdate to join so all have it.

[Slave]

I'm glad it seems to be working now, right? You just needed to revert your template and reupload the files.

The User Profile page will only show info if you have Custom Profile Fields, like "what do you like most: cats / dogs". It will show how many people chose what.

If you don't have any custom profile fields set in your board you are safe to disable the User Profile Page in the options.
Yes, working now :)

Thanks for the explanation of the user profiles bit, I won't need to use that as I have no custom stuff.

I've just updated to the latest version and all is well

www.yaxleyvillage.com/statistics.php

.. happy for you to use it as a demo if you'd like :)

[NeRilkA]

Everything works perfectly !! Thansk a lot Dream :)

[Dream]

My users are required to enter their birthdate to join so all have it.
If people choose to hide age it won't show in youngest/oldest, but they will show in age groups.

[Dream]

Updated, version 3.0

Fixed foreach bug.

Fixed bug with Posts Per Day.

Fixed bug that was showing active members stats when active members are disabled.

[Darat]

Really nice addition, thanks for making it available. I'm like hurik e.g. a fairly large active board so I'm only letting admins use this.

[henners]

Updated, I broke all statistics into pages. This version should be easier on the server.

It's loading a lot faster now.

Nerilka, I think I fixed your problem with dates. Use this (http://www.php.net/manual/en/function.date.php) format for the options now.

woo, it's still a bit slow here but so so glad it works :)

[Opus4]

I like the fact that the stats are now broken down into separate pages.

Now that this has been done... it might be worth considering consolidating a few of the pages. For example: the thread starters and posts per day items on the Users page could go with the Top Posters page, while the Attachments stats on the Users page seems like a good fit for the Attachments page. Those are the only ones I thought about, though. :)

[Dream]

I'm finishing adding Registration Statistics to this :)

Note how my registrations went up after adding the Welcome Headers mod

[Dream]

Updated, version 3.1

Added Registration Statistics :)

Let me know what you think of it.

[PoetJA-1975]

Excellent - Works wonderfully http://jpicforum.info/statistics.php
Thanx for the sharing ;)

Jacquii.

[Slave]

Updated, version 3.1

Added Registration Statistics :)

Let me know what you think of it.
Super :)

Update now installed .. thanks

[Dream]

I like the fact that the stats are now broken down into separate pages.

Now that this has been done... it might be worth considering consolidating a few of the pages. For example: the thread starters and posts per day items on the Users page could go with the Top Posters page, while the Attachments stats on the Users page seems like a good fit for the Attachments page. Those are the only ones I thought about, though. :)
That's interesting, although I have to think about the style, how would they look with the tables stretching all the way to the right, would look weird. Also some people could be interested in disabling only the Top Posters info.

[NeRilkA]

it's great !!! everything works fine !! thanks a lot Dream :)

[Dream]

You are welcome :)

I fixed the active members problem, did you see it?

[NeRilkA]

Yes i saw ;) thanks !

http://www.vbulletin-ressources.com/forum/statistics.php

[Dream]

ok cool

Can I use that link as a live demo?

ps: I liked your old avatar better :P j/k

ps2: I saw you didn't translate some phrases, some phrases begin with dreamstatistics_, hope that helps (my mistake)

[NeRilkA]

Yes of course you can !! :)

about my old avatar, thanks ;) but I received a mp from an admin saying to me that it "was not suitable for vbulletin.org." :p so I obeyed

[NeRilkA]

ps2: I saw you didn't translate some phrases, some phrases begin with dreamstatistics_, hope that helps (my mistake)

Thanks but i'm sorry i can't see where i forgot some phrases ?

here is the french translation by the way ;)

[Dream]

"Age" in the select box. That's the only one I saw.

[NeRilkA]

No it's ok in french ;) it's the same word ^^ thanks anyway

[Dream]

100 installs! :D

[NeRilkA]

Bravo Dream ;)

[nureeves]

Hey .. just wondering,
how to show statistics zero poster per month ? :)

[Dream]

Hello, zero poster per month? What do you mean, can you elaborate?

[BWJ]

Thank you for listening.... :) (http://www.vbulletin.com/forum/showthread.php?p=1338193#post1338193)

I have installed your superhack and it looks really really nice. I will examine and comment it further when I have more time (may be several days will go) - but already one suggestion:

In the user profile statistics: Make the number of votes clicable - so when you click you will see who "voted". This would make a great difference... and then the fun will really begin for the members - of any forum board with custom profil fields... Nice work Dream... ! :up:

I send you a PM with a link to my forum with 161 (I think) different custom field categories... So you can see you program tested to its outmost... :D

There you will also see a bug:

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 43
Warning: Division by zero in /statsmod/statistics_user_profile.php on line 60

[PoetJA-1975]

100 installs! :D

Congrats - It's a wonderful addition to JPiC - My Members love being able to see the Forum Stats... Question - Any plans to ever include top refererring websites in the future? That would be AWESOME!

Again - thanx for providing such a lovely modification ;)

JAcquii.

[cfish]

Fantastic product. Thank you very much! Works a treat and excellent range of options. *Installed*

[pcg]

My only request is member visits per day. I think it's be good, as we base ad rates based on member visits per day. I see this in the CP, but would be great to mak public

[Dream]

I send you a PM with a link to my forum with 161 (I think) different custom field categories... So you can see you program tested to its outmost... :D

There you will also see a bug:

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 43
Warning: Division by zero in /statsmod/statistics_user_profile.php on line 60

I'm gonna look into this, thanks for reporting it.

[Miki_29]

Warning: Division by zero in /statsmod/statistics_user_profile.php on line 60
I've had the same problem on statistics_registration.php...

Just change:
$percent = ($counter['count'] / $total_counter) * 100;

By:
If ($total_counter > 0){
$percent = ($counter['count'] / $total_counter) * 100;
}


Hope it helps...

By the way, here's the link for my statistics page, translated to Portuguese:
Fairplay Forum (http://www.torreiravirtual.net/fairplay/statistics.php)

[Aimee1969]

installed thank you ;)

[BWJ]

I've had the same problem on statistics_registration.php...

Just change:
$percent = ($counter['count'] / $total_counter) * 100;

By:
If ($total_counter > 0){
$percent = ($counter['count'] / $total_counter) * 100;
}


Hope it helps...

By the way, here's the link for my statistics page, translated to Portuguese:
Fairplay Forum (http://www.torreiravirtual.net/fairplay/statistics.php)


Sorry to ask. I could not find this code to replace: In which file?

[Miki_29]

Sorry to ask. I could not find this code to replace: In which file?

The file you mentioned:
/statsmod/statistics_user_profile.php on line 60

[BWJ]

The file you mentioned:
/statsmod/statistics_user_profile.php on line 60

Sorry for my very stupid question...! :o I naturally searched for it - but for some reason didn't find it.

Anyway it helped with the "line 60" error.

Now there are two left:

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 43
and
Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 32

Both errors also existed before. I didn't see the "line 32" in the first place due to the many error lines.

[Miki_29]

Now there are two left:

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 43
and
Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 32

Both errors also existed before. I didn't see the "line 32" in the first place due to the many error lines.

I'm afraid I can't help you with that one... I don't know much of programing on php, I go on self learning, by trying... :o And it's hard to try to fix a problem I don't have :p


By the way, sorry if there are gramar errors on my english (hope there aren't many :rolleyes:)

[jerseyda6]

hmmmmmmmm

[Dream]

BWJ, just disable warnings in your PHP configuration and you are done :D

[txspaderz]

Great Hack!

Suggestion: Could you add an option to the drop down menu to show ALL the Statistics on the page at once? I would love that, as I'm the only user that checks this page, so Server load isn't a problem.

Much Thanks again!

[Dream]

That's how it used to work :/ but I think about it.

[BWJ]

BWJ, just disable warnings in your PHP configuration and you are done :D

That sounds easy. But I am a newbie - and never tried anything like this before.

1) I guess you altering the php.ini file... right?

2) Can I make a custom php.ini file in the directory statsmod - so I don't have to change the default one? or should i make one in public_html (root)?

3) Is it this code I should use= display_errors = Off?

I know you cannot help every kid across the street to the school - but I am really lost here - and I really would love to use your "little" superhack without these error messages.... :p

[Dream]

BWJ, sorry but I don't know much of php configuration. You could try asking over the server configuration forum, there someone may be able to help you.

I wouldn't disable errors though, just warnings, I know there's a setting for that because my php is set to not display warnings, and all has been fine for years.

[DarkRyda]

very nice mod, does any one have the older version. Like all the statistics in one page?

Thanks in advanced...

[BWJ]

BWJ, sorry but I don't know much of php configuration. You could try asking over the server configuration forum, there someone may be able to help you.

I wouldn't disable errors though, just warnings, I know there's a setting for that because my php is set to not display warnings, and all has been fine for years.

Thank you. If I find a solution I will post the answer here. Until then - if any expert should come around this thread, he should be very welcome to suggest a solution... :)

[Dream]

This mod is great just for the registration statistics, I'm very proud of it :)

Sorry DarkRyda, I don't have it. And sorry I don't have time to support two kinds of statistics products.

BWJ, you could try asking in the Server Configuration forum here in the vB.org forum for how to change the configuration to ignore warnings. PHP for Linux comes disabled by default I think.

[BWJ]

I tried with a php.ini f?le and setting the display_errrors = Off (I could not find any warnings on/off) . It didn't work but as said I probably had made some stupid error - as I have never tried such thing before...

But anyway.... I found the solution to the before mentioned errors/warnings :D And the solution - simply make at least one entry for each user field..... Thats all... :p

But may be the script could take into account that zero entries actually is a possibility?

[child_abadan200]

Thanks

[Dream]

Ok BWJ, I took pity on you :D I'll fix the script.

You are welcome child abadan.

[sybakaos]

I like it and installed the hack. Is it possible for you to include a thread prefix to a thread name's and add custom stats fields?

For example, I have some custom counters. They're called field5, field6 etc. It would be nice to have the option to include those. Much like the thanks addon.

[BWJ]

Ok BWJ, I took pity on you :D I'll fix the script.

Great! :)

[Dark_Sirius]

How often does this mod update its stats tables? In other words, will it update the page each time someone requests the stats.php? If so, how does this impact server processor load? The first few times I used the mod it hung while it was gathering info. Is this a one time thing or what?

[Dream]

It calculates the info each time statistics.php is called. If you have a big forum, sorry you shouldn't use this mod :P

Or you could have it set only for admins, not for the general public to use.

[Dark_Sirius]

It calculates the info each time statistics.php is called. If you have a big forum, sorry you shouldn't use this mod :P

Or you could have it set only for admins, not for the general public to use.

That's what I figured and what I did.

[provedel]

There a way to show the total number of posts deleted by our mods???

Like this:

http://img166.imageshack.us/img166/181/sshot4al8.jpg

[misuse]

I like it and installed the hack. Is it possible for you to include a thread prefix to a thread name's and add custom stats fields?

For example, I have some custom counters. They're called field5, field6 etc. It would be nice to have the option to include those. Much like the thanks addon.


I too am looking for something like this. I need more statistics for my website.
The age stats are perfect on the product already! Thanks Dream.

[NaughtyStud]

Very nice mod and thank you. Clicks Install ;)

[Dream]

gogo almost 200 installs :D

the best statistics mod around, should have 1000 installs!

[tomzx]

Dream, you've done a nice job putting that up. Here's a little modification I'd like to see:

If you go to the age statistics, your system seems to only work of people have accepted to reveal their birthday information (date, month, year) but it will not show those who have accepted to show their age (not birthday).

If you could make it so it would also show those who accepted to reveal their age, that would be great :)

[Dream]

Wasn't supposed to be like that.

Can you tell if its just on the oldest/youngest listing or in the age groups as well? I'm pretty sure everyone with a birthday, even hidden, shows in age groups.

[tomzx]

You're correct I suppose. What I was actually asking was the oldest/youngest listing.

[Dream]

Ok I'll take a look at everything, thanks for the heads up.

[Moscardini]

Hi,

I've installed this, love it, nice work, however since I installed it our forums have slowed right down to a snails pace. I've unticked all the options to just so the generla settings now and the speed is ok again.

Any advice?

www.footballforums.net

[Dream]

Sorry this mod is heavy on big forums. You can restrict it only for admins.

[fox3nova]

I had use Extra Profile Fields Page (https://vborg.vbsupport.ru/showthread.php?t=123253) mod.
Does anyone can let the statistics_user_profile display the Extra Profile Fields statistic ?

[NaughtyStud]

Hello Dream, I just wanted to ask if I missed something in my fresh install of this mod.I recently decided to use my forum on a different website and close the other one down.I love your mod, so it was one of the first ones I installed again.

My problem is that after I installed it, I got the Statistics Page.I just don't have the Statistics block on my index page like I did before.Did I leave something out when I installed it again.Thanks ;)

[glorify]

Great stuff. Installed :)

[Dream]

NaughtyStud, maybe you had Cyb's statistics installed? This mod doesn't add anything to the forumhome.

[NaughtyStud]

Oh o.k, sorry about that.I guess I had both installed over at the other one.lol.I still love this one to though. ;)

Edit: I didn't see anything else in my products over there.I guess I have a ghost Mod..haha

[bada_bing]

Wow this looks great anyone know if this will work on VB 3.5.x ?

[PixelFx]

thanks for making such an awesome hack dream :D

[lasto]

neat hack and works fine on 3.6.8

[Zaiaku]

Very nice mod. Is there anyway to set the display for all the stats on one page as in the first demo link?

[Dream]

Very nice mod. Is there anyway to set the display for all the stats on one page as in the first demo link?
No sorry, that version was too heavy on the server.

[Duvernoy]

thanx

[ninjashoes]

hmm I like the registrations thing

[stonner]

i have installed it and it's great!

I just noticed a mistake. The top poster this month is not right. It shows 64 posts for the first place, but this user hast a total number of posts of 37. see attachment

How can I fix this?

thank you

[Dream]

It counts number of threads started as well.

[stonner]

but this user has not started any threads.

[Dream]

hmm, do you have any forums where posts aren't counted?

[stonner]

no, i dont..

[Dream]

any moderated threads?

[stonner]

no...

[Dream]

hmmm O_o

soft deleted threads?

[stonner]

noope...

[Dream]

this pulls from the database posts that are visible=1

not sure why it doesn't match your user's posts...

can you recount his posts?

[stonner]

your count was right.

there was one forum, that didn't count for number of posts.

sorry, perfect hack!

[Dream]

it would be if it didn't count those posts...

thanks

[control1110]

I have a forum that I have excluded from the stats but yet the oldest thread is still listed in that forum

[TrikkeTalk]

Hi,

Works great Dream. Just keep up the good work! Thanks.

[admolot]

Brilliant mod. Is there anyway to set the display for 'forum activity' to show forums with 0 posts?

[chris.williams]

The description states that you can set this so that only administrators can see the stats. How do you do this?

[Merrillizer]

Installed. Real nice. Thanks!

http://www.marshmarauders.org/forums/statistics.php

[Dream]

The description states that you can set this so that only administrators can see the stats. How do you do this?
In the options you can set that

vBulletin Options >> Statistics Options

[Dream]

Brilliant mod. Is there anyway to set the display for 'forum activity' to show forums with 0 posts?

I don't think so, I think they were left out willingly. Don't remember, it has been a while.

[hnjco]

I moved my forum to new server and then upgrade this mod and now getting this error when i click to view.

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vbull_post
WHERE visible = 1;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Wednesday, October 10th 2007 @ 06:23:48 PM
Script : http://www.geopakistani.com/forums/statistics.php
Referrer : http://www.geopakistani.com/forums/index.php?
IP Address : *********
Username : *****
Classname : vB_Database

[Nickbe]

If you are an admin and want it so only you can see the statistics link on the navbar ad this code to the navbar template as opposed to the code shown in the text file. (add in the same location)

<if condition="is_member_of($vbulletin->userinfo, 6)"><td class="vbmenu_control"><a href="statistics.php$session[sessionurl_q]">$vbphrase[statistics_statistics]</a></td></if>


If you want it so only the admin and mods can see use this code:

<if condition="is_member_of($vbulletin->userinfo, 6, 7)"><td class="vbmenu_control"><a href="statistics.php$session[sessionurl_q]">$vbphrase[statistics_statistics]</a></td></if>


This works with the default settings for mod and admin usergroup ID's. If you want to add additional usergroup id's just edit this part of the code

($vbulletin->userinfo, 6, 7)


Just add the user group id's in this format 6, 7, 2, 3, 4

I figured I would write this since I myself used this code so only I could see statistics on the navbar. I did not want my members seeing them but I still wanted easy access through the navbar.

Note: I know you can restrict certain usergroups from viewing the statistics page itself but I though it would be annoying as a normal member to see statistics link in the navbar but be restricted from viewing the page.

[sduckie2k5]

Installed, everything seems to work but I get this error when viewing registrations although, it shows the stats for it as well. Heres the error and it appears at the top of the page:

Warning: Division by zero in \ statsmod \ statistics_registrations.php on line 57

any suggestions? Thanks

[Dream]

This mod has some bugs depending of what info you are missing on your forums.

This mod is now "Re-usable Code", meaning anyone can modify it and release his own version. I encourage someone doing that as I'm not updating this anymore for the time being.

[Konstantinos]

the average is wrong cause it sais 60 while i have an old average age stats which shows 33 . i think it caclulates people who have emplty birthday , and how do i make stats like this http://www.s10planet.com/forum/statistics.php meaning having not so many drop down menus. also in profile stats it doesnt display the N/A (there few people who have the mandatory custom fields unset cause they dont visit the forum before all fields became mandatory) + it doesnt display the percentages order from highest to lowest but with the order of the fields instead

[murrtex]

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

what will we do?

[doogie1775]

As always, another fantastic Mod from Dream - Thank you!

[Dream]

You are welcome, glad you liked it :)

Sorry murrtex, this mod has some bugs depending whether you have some missing information. Right now I don't have time to fix it, sorry.

[nureeves]

I got same problem with Murtex. And all monthly registration value is zero.

c'mon Dream .. this is such wonderful mod,
i thought you should fix it immeadiately, to maki it perfect :D !!!

GBU

[hilfe-forum]

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

what will we do?


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

to

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


(in File statsmod/statistics_registrations.php )

[doogie1775]

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

to

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


(in File statsmod/statistics_registrations.php )

I ended up having the same problem as murrtex, but the obove fixed the error - thank you!

However, I am showing zero for the monthly registration stats? Any idea why?

Thnx!

[control1110]

Why does this error occur? I am having the same issue it was working fine before

[JohnnieOO]

Yep, same error for me (worked fine before)
Warning: Division by zero in /statsmod/statistics_registrations.php on line 105

I have a very small board and this error occured, I THINK, right after I deleted a spammer. Since then, I get this error. The dailey registrations appear OK, but the monthly registrations are all zero.

Johnnie

[yoyoyoyo]

so this statistics mod doesn't load a user's browser with any cookies, right?

also - in viewing some of the example sites it seems that the monthly registration stats are faulty, since it shows recent registrations, but the monthly stats show none.

Also wondering if there is any way to limit the countries of registered users to only those that are really registered, so the list isn't filled with a bunch of zeroes? for instance, if I have no users from Zimbabwe registered, can the list be fixed to not display that country?

[fury]

Can anyone suggest some table indexes for me to add to make this stuff go faster? I notice a long loading time on my board, and anticipate if the statistics page ever gets crawled by a search engine spider, my server will be brought to its knees... I could just declare statistics.php in robots.txt but I think I'd rather just make the stats faster to begin with.