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]

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]

Originally Posted by 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?

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]

Originally Posted by NeRilkA

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]

Originally Posted by Dream

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

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

[Dream]

Thank you looking good!

[Dream]

Originally Posted by 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 ...

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]

Originally Posted by 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!

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 format for the options now.