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

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