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 04-12-2007 02:31 AM

Updated, added poll statistics.

Dream 04-12-2007 07:04 AM

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

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

henners 04-12-2007 09:45 AM

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

Dream 04-12-2007 06:34 PM

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

But, you have to click install then ;)

Yours Truly 04-12-2007 06:55 PM

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?

Dream 04-12-2007 09:36 PM

What MySQL version are you using?

sebbo 04-12-2007 09:59 PM

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.

Dream 04-13-2007 12:00 AM

I'll add that in the next version.

Dream 04-13-2007 04:49 AM

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

Dream 04-13-2007 01:17 PM

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


All times are GMT. The time now is 01:07 PM.

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.01386 seconds
  • Memory Usage 1,734KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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