Statistics Modifications - Dream's Forum Statistics

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/...statistics.php
http://www.torreiravirtual.net/fairplay/statistics.php

[voter]

Originally Posted by Dream

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 )

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