Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard

Reply
 
Thread Tools
Simple Forum Usage Statistics Details »»
Simple Forum Usage Statistics
Version: 1.07, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.5.x Rating:
Released: 04-21-2006 Last Update: 05-14-2006 Installs: 37
 
No support by the author.

This modification is no longer available or supported.

This is a little custom hack originally written for Jilly.

This adds an option to the forum tools dropdown menu to display three counts for the forum (and sub forums if you click on the link) - Number of New Posts, Number of New Threads and Number of Unique Posters - all for a preset time limit (in days). The days and usergroups allowed to use it this function are defined in the ACP.

Unzip the xml file and import it into vbulletin via the product manager, then set the options (in the vb options > forum display options). 7 Days and usergroups 5,6 & 7 are the defaults.


History:

v1.01 : First Private Release.
v1.02 : Minor changes, no update necessary.
v1.03 : Permissions added.
v1.04 : Forum Tools Link Automated.
v1.05 : First Public Release.
v1.06 : Fixed missing table prefixes on joins.
v1.07 : Fixed more table prefix errors.

Show Your Support

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

Comments
  #2  
Old 04-22-2006, 04:12 PM
Mr Chad's Avatar
Mr Chad Mr Chad is offline
 
Join Date: Jul 2005
Posts: 911
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks pretty good, Installin.
Reply With Quote
  #3  
Old 04-22-2006, 04:31 PM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Mhhhh:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM vb3_post AS post
LEFT JOIN thread on post.threadid = thread.threadid
WHERE post.dateline > 1145122278 AND thread.forumid IN (32);

MySQL-Fehler : Table 'usr_web2_3.thread' doesn't exist

---

Thanks!:-)
Reply With Quote
  #4  
Old 04-22-2006, 04:51 PM
XanTrax XanTrax is offline
 
Join Date: Aug 2005
Posts: 75
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Need to include table prefix in the code.
Reply With Quote
  #5  
Old 04-22-2006, 05:12 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oops, a table prefix missing on the joins - 1.06 uploaded to fix it.
Reply With Quote
  #6  
Old 04-22-2006, 05:45 PM
topsoftware topsoftware is offline
 
Join Date: Dec 2005
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

where is the link
Reply With Quote
  #7  
Old 04-22-2006, 05:54 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

As it says ;

Quote:
This adds an option to the forum tools dropdown menu
Reply With Quote
  #8  
Old 04-22-2006, 06:12 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice idea.

Are you planning on adding any other statistics to this?
Reply With Quote
  #9  
Old 04-22-2006, 06:12 PM
Atakan KOC's Avatar
Atakan KOC Atakan KOC is offline
 
Join Date: Feb 2006
Location: Istanbul
Posts: 710
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice. Thanks
Reply With Quote
  #10  
Old 04-22-2006, 06:29 PM
Ziki's Avatar
Ziki Ziki is offline
 
Join Date: Nov 2005
Posts: 2,704
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM forumziki_post AS post
LEFT JOIN forumziki_thread on post.threadid = thread.threadid
WHERE post.dateline > 1145129031 AND thread.forumid IN (2);

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Saturday, April 22nd 2006 @ 03:23:51 PM
Script : http://www.xxxxxxxxxx.com/forums/mis...forumstats&f=2
Referrer : http://www.xxxxxxx.com/forums/forumdisplay.php?f=2
IP Address : XXXXXXX
Username : ZIKI-SET
Classname : vb_database
Reply With Quote
Reply

Thread Tools

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 06:31 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.07638 seconds
  • Memory Usage 2,284KB
  • Queries Executed 23 (?)
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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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