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

[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