vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Statistics Modifications - Dream's Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=140812)

Dream 02-28-2007 10:00 PM

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 03-01-2007 02:17 PM

It don't work:

Quote:

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 03-01-2007 03:04 PM

Thanks! However, a screenshot or demo link wouldn't hurt... ;)

Wulfnoth 03-01-2007 03:23 PM

I got this error:

Quote:

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 03-01-2007 03:33 PM

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 03-01-2007 04:10 PM

Ok, please try again.

And let me know if any errors occur.

Wulfnoth 03-01-2007 04:46 PM

I've made a screen. Looks very nice!

Dream 03-01-2007 04:50 PM

Thanks Wulfnoth :)

If you got a live demo and can share please drop the link in this thread.

Tom_S 03-01-2007 05:19 PM

Nope...Reinstall didn't work

Quote:

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 03-01-2007 05:21 PM

I don't know why you don't have a threads field in the user table sorry. Thanks for trying the mod though.


All times are GMT. The time now is 09:20 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01492 seconds
  • Memory Usage 1,738KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete