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?

Can you PM me your forum address?

Is this made for PHP 5+?

No. Did you try the new version?

No i will give that a quick spin :)

Works now cheers :)

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

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

This should work with both PHP 4 and 5.

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.

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

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.

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.

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

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

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

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?

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

thanx for the update

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.

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

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.

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)

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.

ahh .. cool .. thanks :)

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

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

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 ?

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.

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

thanks a lot and great hack :)

oh just a little thing

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

They may be not enough active but 0% ;)

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?

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

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]

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

i put your file, but the % are still there

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

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

it works ! great thanks a lot