vb.org Archive - Miscellaneous Hacks - Threads Started by User in Postbit and Profile

Page 5 of 11

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

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

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - Threads Started by User in Postbit and Profile (https://vborg.vbsupport.ru/showthread.php?t=115136)

rmxs	05-14-2006 03:46 PM

Also made the posts and threads counts in the postbit clickable search links like in the profile.

Here no changes...i install the new one byt its look the same..

Boofo

05-14-2006 04:02 PM

Quote:

Originally Posted by rmxs

Also made the posts and threads counts in the postbit clickable search links like in the profile.

Here no changes...i install the new one byt its look the same..

Then you're not looking close enough. ;)

Click on the post count or thread count in the postbit.

EDIT: I forgot to add you need to redo the template edit in the postbit to get the clickable links. Sorry about that.

Snake

05-14-2006 04:35 PM

Thanks for the nice little update, sir! :)

Boofo

05-14-2006 04:36 PM

Any time, my friend, any time. ;)

rmxs	05-14-2006 04:39 PM

EDIT: I forgot to add you need to redo the template edit in the postbit to get the clickable links. Sorry about that.

Ohhhh and the other stuff that i have edit i have make one code there 1meter LONG :)

Can you post what i must change there?i make by hand.

Boofo

05-14-2006 04:40 PM

The change is in the text file in the zip you downloaded. ;)

evofile

05-14-2006 09:14 PM

look at the mySQL error that i'm getting!

Code:

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

        );

Boofo

05-15-2006 05:04 AM

What error? That's the query.

Stop	05-15-2006 11:35 AM

Charming.Thanks for the update.

evofile

05-15-2006 06:51 PM

Quote:

Originally Posted by Boofo

What error? That's the query.

oops sorry i forgot to paste the error here is the error:

Code:

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

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

Page 5 of 11

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01136 seconds Memory Usage 1,732KB 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 (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: