yea now its wkin and looks good but i didnt like the design of the template chck the attchmen file for screen shot...

The statistics are divided in categories, they wouldn't make sense if I grouped those statistics in the same table.

The categories would speak for themselves by the header name of each table. I am talking about doing it like this:

Uhm in my taste it wouldnt look better like that.

I can make you a version like that when I have some time.

Updated, added more statistics (forum open since, threads and posts per day and oldest thread).

See if you like it more now, I removed the tables stretching all the way to the end.

Don't forget to re-import the product xml.

yep, excellent addition, works a treat except for the uncached templates.... and the layout could be a lot better, as mentioned above, make it use the whole width of the page, rathewr than just down the left side...but a crackin hack nonetheless.

Updated, added posts per day each day.

Also added the templates to the cache.

If you want the tables to use the whole width of the page, change width = ''; for width = ' width="100%"'; in statistics.php

Sorry my brother. I went with this hack instead:
https://vborg.vbsupport.ru/showthread.php?t=122986
I like yours but it just don't have those options for sleekness. I know you can do that though and better ;)

No problem :)

That mod may slow down your forum home if you have a busy forum, that's one of the reasons I made this mod.

worked a treat that, thanks.

No problem

Updated, added average replies per thread, users with most attachments and most viewed/downloaded attachments

Updated, added top posters last year and last month, latest attachments, top rated threads, most replied threads in the last 10 days and user posts per day ratio.

Kids don't forget to turn off unregistered from rating threads ;(

I decided to install & check this out, compared to Top Posters. Since there are more stats to display, this page takes longer to load.

I noticed that there isn't support to limit which usergroups are included/excluded for some of the stats, so I added "AND usergroupid IN (2,5,6,7)" to some of the WHERE lines in statistics.php in order to prevent listing banned users & so on.

I'll add an option for that in the next version.

I've installed it on my forum and it's really looks nice and helpful but the case is when i click on any of the resaults links it directs me to the thread but without the forum folder as follow:
instead of http://www.mywebsite.com/forum/thread or member number and info
it go's to http://www.mywebsite.com/thread or member number or info.

so the messing here is the forum folder.

could you please guide me throw correcting this.

thanks in advance.

That's another comment I was going to make this morning... :)

In statistics.php, I removed all the $vboptions[bburl]/ parts of the links it creates. I don't know why that change worked, but the links worked for me after that.

Thanks Opus4 :)

Updated, I removed all unnecessary $vboptions[bburl]/ and added an $exclude_usergroups option in statistics.php, where you can put the user group IDs you don't want included in the statistics.

Let me know if you have problems with this version.

This works for me, thanks. :)

If you want another suggestion... for the Posts Per Day list, can it be limited to members who have been around X number of days? It shows a high rate for someone who just signed up within the past couple of hours and has posted just a couple times.

Speaking of the PPD list, is it possible to show the total posts after the user's name?

The only other thing I'm curious about is how much of a load this puts on the forum server. I don't plan to load the stats page that often anyway, but I just wonder because of the time it takes to gather all the info that gets displayed.

Thanks Man,

It's working perfect now.

Opus, yes I can put a day limit in PPD, good idea for people that have a high number of posting new members. I've been seeing weird stats in mine too. I'll put in a 1 day limit just so it won't show weird stats, but you will be able to change that in the script.

I'll squeeze the total messages in it too.

I don't have any server load statistics to tell you, but you can use vBMicroStats to check yours out. This isn't the kind of page that is used often, so it having a higher use of queries should be fine.

(it's actually loading fast for the amount of stuff it does in my opinion)

Updated, added total posts in Posts Per Day, and made settings for the mod in the vBulletin Options in the AdminCP.

Don't forget to put your private forum IDs in the "Exclude Forum IDs" setting!

Thanks -- the Posts Per Day works much better and the CP settings make changes easier.

I can't think of any other useful suggestions for now... :)

oh so good

thanks

Updated, added Who's Online support, and also added Active members percentage.

thanks

lol mine is terrible!!!
Active members percentage
10.33% (154 active members, 1491 total)

Mine is 21% :P

But I deleted some old members with 0 posts.

its good u made this mod

i am an old SMF user and they have stats of all kinds built in.
so when i switched over i was missing those

thanks again for this, it really makes forum management a bit more fun

Glad you liked it :)

Updated, added Posts Per Month, and fixed so it gets the information with the right GMT settings.

Version 2.0!

You can now choose the forum you want to show statistics from! Users see only the forums they have permission to see.

Attachment statistics page added, with detailed statistics on attachments for each forum.

If you are upgrading, remove your private forums from the exclude forums list, because they aren't needed anymore! This mod is now smart enough to let you see the forums you have permission to see, and hide them from users that don't have permission to see them.

A special thanks to the vBulletin.org coders community that was very nice and helped me with questions while developing this version.

Let me know how this works out for you.

Updated, added poll statistics.

Updated, added missing phrases. ("Posts" and "Rate")

No one told me they weren't showing! ;/

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

Sure, I'll add that in the next version.

But, you have to click install then ;)

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?

What MySQL version are you using?

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.

I'll add that in the next version.

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

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