The Arcive of Official vBulletin Modifications Site.

Thread Count · **Released**: 01-15-2005

This is a small hack that will add a thread count to the postbit, but it makes it avaible to any varible that gets the whole user table, such as $bbuserinfo and $userinfo.

Included is an update function that will allow you to update the threads counts for any reason.

Shouldn't take more than 5 min to install

It was tested on two dev boards, there shouldn't be any issues.

Thanks to Matt and Chris Padfield

xmitchx · #12 01-17-2005, 03:10 AM

I wont be using this as I have no need to but if I may suggest something:

Quote:

Included is an update function that will allow you to update the threads counts for any reason.

Im not sure if thats what im about to suggest, but I suggest having a "resync thread counts" option so that the thread counts are accurate.

Boofo · #13 01-17-2005, 03:47 AM

Quote:

Originally Posted by Zachery

Sorta suprised no one has done it before

Then you haven't checked my profile. I did this quite a while ago.

Boofo · #14 01-17-2005, 03:49 AM

Quote:

Originally Posted by Mike Gaidin

It was, but I don't think it was released here. I had requested it.

Mike, how soon we forget.

alsfeena · #15 01-17-2005, 06:29 AM

It didnt work with me!!
The forum and threads are working properly but no changes only showing the posts count...?
I did it as in the instruction file and finally i upgraded whole counts of my forum

lasto · #16 01-17-2005, 09:52 AM

wots the load on this or additional queries ?

TCattitude · #17 01-17-2005, 10:52 AM

Quote:

Originally Posted by Boofo

Then you haven't checked my profile. I did this quite a while ago.

I was looking for this for a weeks ago, and... nothing (in hacks, betas and also the requests fortums)

Thanks GeekyDesigns, great mini hack

Zachery · #18 01-17-2005, 11:38 AM

Quote:

Originally Posted by Boofo

Mike, how soon we forget.

Yea I saw bob but your way can be insanely intensive unless i totaly missed how you were storing the data instead of calling it on every page view.

Snatch · #19 01-17-2005, 11:56 AM

if i get to this URL Referer: http://www.celebritymarkt.de/admincp...do=threadcount i get this error.

Code:

Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage: SELECT userid FROM user ORDER BY userid DESC LIMIT -1000, 1000
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 '-1000, 1000' at line 1

mysql error number: 1064

Datum: 17.01.2005 14:54:53
Skript: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount&perpage=1000&page=2
Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount
Benutzername: Snatch
IP-Adresse:

Zachery · #20 01-17-2005, 12:20 PM

Quote:

Originally Posted by Snatch

if i get to this URL Referer: http://www.celebritymarkt.de/admincp...do=threadcount i get this error.

Code:

Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage: SELECT userid FROM user ORDER BY userid DESC LIMIT -1000, 1000
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 '-1000, 1000' at line 1

mysql error number: 1064

Datum: 17.01.2005 14:54:53
Skript: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount&perpage=1000&page=2
Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount
Benutzername: Snatch
IP-Adresse:

1064 is generaly dealing with memory, what version of MySQL are you running ?

BarHopper · #21 01-17-2005, 02:29 PM

/me installed

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04754 seconds Memory Usage 2,310KB Queries Executed 26 (?)
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 (6)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 (3)pagenav_pagelink (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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!