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

Page 3 of 10

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

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

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

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

Chester87

07-22-2007 12:40 PM

Wondering if this hack could be modified so it will only count the threads in a particularly forum.

So it wil count like this

Posts: 2540
Threads in imageforum: 12
Threads in tekstforum: 45

How can i change this a little bit so i can make it do this??

Techno05

08-23-2007 06:11 PM

Yeah I would like to know that also

momo2

09-06-2007 04:39 AM

Installed, how can I get have it line up in one single line, so I can save space ??

Thread 2000 Posts 3000
instead of
Thread 2000
Posts 2000

momo2

09-06-2007 05:24 AM

never mind i added ur alternative, and it's all fixed, this is the best mod i have seen i have a very busy forum and, i can simply click on anyone and see all their posts or threads..

Thanks..

Mystery Man

10-10-2007 02:09 PM

Quote:

Originally Posted by Andyucs (Post 1287755)

i get this when the cron runs

PHP Code:


		
			
Database error in vBulletin 3.6.7:



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 

Error Number : 1064

Date         : Tuesday, July 10th 2007 @ 07:37:11 PM

Script       :

I'm receiving the exact same error and I've tried re uploading the xml and also made sure it was overwriteable but to no avail. I'm running 3.6.8 anybody else having this issue or better yet a way to fix it?

Mudvayne

10-10-2007 02:44 PM

Try uninstall then reinstall the hack.

Mystery Man

10-10-2007 03:36 PM

Quote:

Originally Posted by Mudvayne (Post 1356925)

Try uninstall then reinstall the hack.

Already did twice, but nothing seems to work, im quite sure ive done everything correctly. any chance this is not compatible with 3.6.8?

Mudvayne

10-14-2007 04:24 AM

I'm not using 3.6.8 yet. I will test & confirm you ASAP.

DiverTree

10-14-2007 11:39 AM

Quote:

Originally Posted by Mudvayne (Post 1359497)

I'm not using 3.6.8 yet. I will test & confirm you ASAP.

seems to work fine for me. ive got it installed on a 3.6.8, as per instructions. :)

AWJunkies

10-16-2007 08:08 PM

It shows 0 threads for me not sure what is up. DO I need to wait for it to do its cron job?

forced the corn and this is what happens:

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE allwheeljunkies_user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS thread
LEFT JOIN allwheeljunkies_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 allwheeljunkies_thread AS threa
Error Number : 1064
Date : Tuesday, October 16th 2007 @ 05:12:46 PM
Script : http://allwheeljunkies.com/admincp/c...ncron&cronid=7
Referrer : http://allwheeljunkies.com/admincp/c....php?do=modify
IP Address : 66.75.231.222
Username : AWJunkies
Classname : vb_database

All times are GMT. The time now is 10:17 AM.

Page 3 of 10

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01750 seconds Memory Usage 1,749KB 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 (1)bbcode_php_printable (4)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: