Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Dream's Forum Statistics Details »»
Dream's Forum Statistics
Version: 3.2, by Dream Dream is offline
Developer Last Online: Sep 2010 Show Printable Version Email this Page

Category: Statistics Modifications - Version: 3.6.8 Rating:
Released: 02-28-2007 Last Update: 12-03-2007 Installs: 300
Uses Plugins Template Edits
Re-useable Code Additional Files Translations  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #122  
Old 04-20-2007, 11:13 PM
Dream's Avatar
Dream Dream is offline
 
Join Date: Oct 2001
Posts: 2,251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No problem the active members problem is most likely a problem with vBTrends.
Reply With Quote
  #123  
Old 04-20-2007, 11:15 PM
rjmjr69's Avatar
rjmjr69 rjmjr69 is offline
 
Join Date: Jan 2007
Location: Southie
Posts: 876
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dream View Post
NeRilkA: Try using the attached statistics.php file

rjmjr69: yeah :/ the front page is big and has a lot of statistics, I may be separating it into pages in a later version

Actually now that i think of it. I like having them only run on one page. As long as it does not add to any of the other areas I'm good with the way it is. Thank you works great
Reply With Quote
  #124  
Old 04-20-2007, 11:18 PM
Dream's Avatar
Dream Dream is offline
 
Join Date: Oct 2001
Posts: 2,251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No problem glad you liked it
Reply With Quote
  #125  
Old 04-21-2007, 05:48 AM
Dream's Avatar
Dream Dream is offline
 
Join Date: Oct 2001
Posts: 2,251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Updated, added user profile statistics, or custom profile field statistics.

Added total disk space and average filesize in attachments stats page.

Added option to show stats navigation on top.

To upgrade read upgrade.txt, there are new files.

If you have problems with dates showing something like "d-m" you need to change your day/month/time stats options using the format in this page

http://www.php.net/manual/en/function.strftime.php
Reply With Quote
  #126  
Old 04-21-2007, 06:43 AM
rjmjr69's Avatar
rjmjr69 rjmjr69 is offline
 
Join Date: Jan 2007
Location: Southie
Posts: 876
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I love this addition its great. I do not mind the queries for they are only when you call for the stats so no biggie it does not slow the site down any. Anyway I've come across an error or bug.....



What can I do to get that to show correctly. He should be listed as the Youngest


Woops found another I enabled the Profiles option and I get this error at the top of the page and nothing is displayed.

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 9

I do not mean to be a pest with all these issues but best you know about them right?
Well when viewing any of the statistics pages the Welcome Box has an image icon but no image I can click the icon and set view image it refresh's the page and all is well. Normally it will say Good Afternoon Rjmjr69. Its a hack I have installed. But when viewing the statistics page it only has the icon and Afternoon no GOOD? If you need a link to the mod let me know. But its called GoodMoring/Afternoon/Evening images hack Also all the font colors in the shout box and usergroup colors are wrong until a refresh?
Thanks


Another request can you make it so certain categories wont appear? Like Last Year my site is not even 2 month's old yet so its empty there and its at the top. And could it be worked to allow custom placement of the box's/categories?
Reply With Quote
  #127  
Old 04-21-2007, 10:58 AM
henners henners is offline
 
Join Date: Feb 2005
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #128  
Old 04-21-2007, 12:57 PM
Slave's Avatar
Slave Slave is offline
 
Join Date: Nov 2001
Posts: 439
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wonderful thanks for the update

One thing, I seem to have lost the dropdown menus?!

I reverted my STATISTICS template as I'd played with it to put the dropdown menu at the top. Since then they have disappeared. Any ideas?

http://www.yaxleyvillage.com/statistics.php
Reply With Quote
  #129  
Old 04-21-2007, 01:01 PM
Slave's Avatar
Slave Slave is offline
 
Join Date: Nov 2001
Posts: 439
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #130  
Old 04-21-2007, 02:52 PM
NeRilkA's Avatar
NeRilkA NeRilkA is offline
 
Join Date: Jun 2002
Location: South of France
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For me the page Profil works fine but the SQL error for birthday came back

Quote:
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 : Saturday, April 21st 2007 @ 05:50:13 PM
Script : http://www.vbulletin-ressources.com/...statistics.php
Referrer : http://www.vbulletin-ressources.com/...statistics.php
IP Address : 172.184.77.234
Username : NeRilkA
Classname : vB_Database
I put the date in the right format but these errors came back too :
Quote:
Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1184

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1180

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1176

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1177

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1167

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1274

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1512

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1519
The statistiques for Last Year don't show up like Last Month, Post per Day and Post per month
Reply With Quote
  #131  
Old 04-21-2007, 04:39 PM
hurik hurik is offline
 
Join Date: Aug 2005
Location: Konstanz (Germany)
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ...
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07575 seconds
  • Memory Usage 2,320KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete