vb.org Archive - Number of threads in user profile

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Number of threads in user profile (https://vborg.vbsupport.ru/showthread.php?t=99530)

neutek

01-26-2006 11:43 PM

thanks man :) i like it

Detomah

01-27-2006 06:13 AM

Thanks. :)

Installed and working fine. :)

Thumbs up from me. :up:

Snake

01-27-2006 09:34 AM

Quote:

Originally Posted by Michelle

Nice idea! I'll look into it :)

My guess would be no... :disappointed:

HostileAdam

07-02-2006 12:46 AM

Installed. Thanks

futuredood

07-09-2006 04:26 AM

I installed this hack.. and keep receiving this errore-mail. I'm pretty sure it's from this hack b/c of all the "thread" mentions in it. Everything's running smooth, thought it'd be nice that it was bug free.. please advise.

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064

Lea Verou

07-09-2006 01:02 PM

My hack does not perform such a query.

Veer	12-06-2006 07:35 AM

will work for 3.6?

s0b	12-12-2006 11:18 PM

Quote:

Originally Posted by Pehchaan (Post 1133042)

will work for 3.6?

works great in 3.6.4 :)

All times are GMT. The time now is 08:06 PM.

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01041 seconds Memory Usage 1,728KB 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)post_thanks_navbar_search (1)printthread (8)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
Messages: