Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Forum Counter v2.1 Details »»
vB Forum Counter v2.1
Version: 1.00, by AnhTuanCool AnhTuanCool is offline
Developer Last Online: Sep 2006 Show Printable Version Email this Page

Version: 3.0.3 Rating:
Released: 09-28-2004 Last Update: Never Installs: 25
 
No support by the author.

vB Forum Counter

Version: 2.1
vBulletin Version: 3.0.3 (should work with 3.0.0)
Developed by AnhTuanCool
Install difficulty Level: Pretty short


Brief of Description:
vB Forum Counter add an option to have Forum views column on FORUMHOME display forum counter.

Feature:
  • Feature can be turn on/off
  • Option to update intermediately or after an hour
  • Forum counter makes a new column on FORUMHOME
  • Reset Forum Views
Updated:
For vb Advanced users (attachment)
Updated from version 1:
Fix bugs - conflict between table in database
The function update after one hour not really works
Update to version 2.1:
Add Reset feature

Screenshot:
In attachments...

Install:
Attachment also

Don't forget to click install if you use this hack INSTALL

If you got any problem or questions, just post it right here, I'm willing to help

Note: If you have problem with sql error in vb Advanced CMPS, then check out the txt file in attachment below, show how to fix it
There is no uninstall script so if you want to update then just see the updating instruction.

Enjoy!

Show Your Support

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

Comments
  #32  
Old 02-18-2005, 09:44 PM
okc okc is offline
 
Join Date: Sep 2004
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bitg
Since I installed this hack, I get a database error.
_________________________________
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT forum.title AS forumtitle, thread.threadid, thread.title, thread.dateline,
thread.lastpost, pollid, open, thread.replycount, postusername, postuserid,
thread.lastposter, thread.dateline, views
FROM forum AS forum
INNER JOIN thread AS thread USING(forumid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE FIND_IN_SET('16', forum.parentlist) AND
thread.lastpost > 1096689607 AND
thread.visible = 1 AND
deletionlog.primaryid IS NULL

mysql error: Column: 'views' in field list is ambiguous

mysql error number: 1052
getting exact same error - any thoughts?
Reply With Quote
  #33  
Old 02-18-2005, 10:37 PM
okc okc is offline
 
Join Date: Sep 2004
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nevermind update fixed it
Reply With Quote
  #34  
Old 02-24-2005, 09:21 AM
venomx's Avatar
venomx venomx is offline
 
Join Date: Apr 2002
Location: Pennsylvania USA
Posts: 441
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For vbadvance cmps shouldnt
Code:
else
{
	// or doing it once an hour
	$DB_site->shutdown_query("
		INSERT INTO " . TABLE_PREFIX . "views (forumid)
		VALUES (" . intval($foruminfo['forumid']) . ')'
also change to
Code:
else
{
	// or doing it once an hour
	$DB_site->shutdown_query("
		INSERT INTO " . TABLE_PREFIX . "view (forumid)
		VALUES (" . intval($foruminfo['forumid']) . ')'
?
Reply With Quote
  #35  
Old 03-24-2005, 11:11 PM
okc okc is offline
 
Join Date: Sep 2004
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Has anyone updgraded to 3.07 with this hack? I just upgraded to vb 3.07 & can't get the views column to appear - it just doesn't show up - do you know what I could check?
Reply With Quote
  #36  
Old 04-15-2005, 03:58 AM
okc okc is offline
 
Join Date: Sep 2004
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

for anyone using 3.07, I also had to go into includes/functions_diget.php & remove the , views after thread.lastposter, thread.dateline
Reply With Quote
  #37  
Old 04-15-2005, 06:51 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The error you got before means that the 'views' column exist in more then 1 table used in the query. If you don't tell MySQL from which table you want to use that column, it won't have a clue what you are look for.

Solution:
Change 'views' into 'thread.views'

(Assuming that you are looking for the view count on the threads.)
Reply With Quote
  #38  
Old 04-22-2005, 04:23 AM
eXtremeTim eXtremeTim is offline
 
Join Date: Jun 2002
Location: eXtremewebtech.com
Posts: 1,201
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great hack. Would be nice to have a combined install file and not just the upgrade version. I would release the combined version I made but I made changes to it.
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 01:53 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.04664 seconds
  • Memory Usage 2,281KB
  • Queries Executed 22 (?)
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
  • (2)bbcode_code
  • (1)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
  • (2)pagenav_pagelink
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (7)postbit
  • (8)postbit_onlinestatus
  • (8)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