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

Page 2 of 3

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

Boofo

05-15-2006 07:26 PM

You need to post the whole error. I can't tell much with what you have there.

evofile

05-15-2006 10:05 PM

Code:



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

Date : Monday, May 15th 2006 @ 09:41:36 PM

Script : http://forum.evofile.com/cron.php?&rand=694578

Referrer : http://www.evofile.com/

IP Address : 69.86.205.252

Username : Unregistered

Classname : vb_database

Boofo

05-16-2006 12:54 AM

Quote:

Originally Posted by evofile

Code:



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

Date : Monday, May 15th 2006 @ 09:41:36 PM

Script : http://forum.evofile.com/cron.php?&rand=694578

Referrer : http://www.evofile.com/

IP Address : 69.86.205.252

Username : Unregistered

Classname : vb_database

What version of MySQL are you running on the server?

evofile

05-16-2006 02:24 AM

Quote:

Originally Posted by Boofo

What version of MySQL are you running on the server?

4.0.24

Boofo

05-16-2006 02:37 AM

Hang in there, we're looking at it now. ;)

Oblivion Knight

06-14-2006 10:09 AM

Yup, I'm getting the same error but with vBulletin 3.6.0 Beta 2..

It might have been doing it before the upgrade, but I've only just re-added an email address to receive database error messages (they do my head in!).. Running MySQL 4.0.27-standard.

Boofo

06-14-2006 10:22 AM

Quote:

Originally Posted by Oblivion Knight

I thought 3.6 took a higher MySQL version that that.

Oblivion Knight

06-14-2006 10:29 AM

Quote:

Originally Posted by Boofo

I thought 3.6 took a higher MySQL version that that.

From vbulletin.com:
vBulletin 3.6 now requires PHP 4.3.3 or later and MySQL 4.0.16 or later.

:)

Boofo

06-14-2006 10:38 AM

I'm using 4.1.11 and this hack works fine with that. I have a fix for it for older versions somewhere.

Freesteyelz

06-15-2006 06:59 AM

Genius! Thank you guys! *Clicked Install*

futuredood

06-17-2006 01:54 AM

hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

Boofo

06-17-2006 05:05 AM

Quote:

Originally Posted by futuredood

hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

Nope, can't give you any instructions, sorry. ;)

That's because it uses a hook and does it all automatically. ;)

futuredood

06-17-2006 05:26 AM

haha great! what i did was i uploaded it, and only put the code in my memberinfo template (i only want it to show up in the profile).

is that the reason it's not working for me? i didn't want it to show up in the postbit templates. if it hasn't been updating, maybe it has to be with my server settings.

Boofo

06-17-2006 05:50 AM

Make sure the threads it isn't counting aren't in forums where you have the postcount turned off. It will update new threads immediately and adjust it when the cron runs.

futuredood

06-17-2006 06:22 AM

ah, i caught the problem. i posted a new thread and it counted fine, but old threads aren't counted. i tried running some maintenance scripts, like updating post counts but that didn't do the trick. was their a step i missed?

Boofo

06-17-2006 06:58 PM

All the threads that the member has started are counted when you first install the hack and when the cron runs.

futuredood

06-20-2006 12:31 AM

hm didn't seem to work when i reinstalled and overwrote the original file. it's ok though since i'm installing this on a new forum.

Tyegurl

06-26-2006 01:00 AM

darn i need mysql 4.0.4...:(

futuredood

06-26-2006 11:17 AM

threads seem to be counted correctly, but this error is e-mailed to me about once a night. i read someone else received this error too.. it'd be nice to know that everything was running smooth, though.:

Database error in vBulletin 3.5.4:

Quote:

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

barca4ever

07-13-2006 10:08 PM

I have a user has posted 2 threads, so he's thread's count is 2 which is correct, But when I soft-deleted his 2 threads, his thread's count still showing 2 !!!

Arngrim

07-15-2006 08:30 AM

Great MOD Boofo. I've been looking for this for a while, and after entering about ten different types of criteria and searching through a dozen pages of the Search engine...I finally found it. Though I use MySQL 4.0.27-standard. Will this be a problem in the future? It seems to be working fine for me... Cheers.

*Installed*

Edit: Aye, seems I am also receiving that E-mail that a few Users above have mentioned. The Hack works fine, though it hasn't updated my correct Thread Count, if it was supposed to do that (i.e. be retroactive). I could probably just create a bunch of 'test' topics, and then erase them, so that I bring the count to its correct level... Anyhow, here's the error in case it differs in any area:

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
Date : Saturday, July 15th 2006 @ 06:50:22 AM
Script : http://www.address-omitted/forums/cron.php?&rand=826012
Referrer : http://www.address-omitted/forums/usercp.php
IP Address : omitted
Username : Unregistered
Classname : vb_database

Oblivion Knight

07-25-2006 05:45 PM

Just to let you know, I had to remove this block of code in the product for it to install on 3.6.0 RC2:

Code:

$version = explode('.', mysql_get_server_info($db->connection_write));

if ($idx = strpos($version[2], '-'))

{

        $version[2] = substr($version[2], 0, $idx);

}

if ($version[0] < 4 OR ($version[0] == 4 AND $version[2] < 4))

{

        print_cp_message('This Hack requires at least mySQL 4.0.4');

}

Otherwise it spat out an error, whining about an invalid MySQL resource with mysql_get_server_info.

serhat_kk

07-30-2006 02:55 AM

Thanks Boofo but i've a problem

Threads: 1200
Posts: 1,800

how do i add "," to Threads???
thanks...:)

music legend

09-03-2006 04:07 AM

is this mod coming out for 3.6?

Valter

09-06-2006 12:03 AM

Doesn't work properly with 3.6.

I have the same problems as Arngrim and Oblivion Knight reported.

tazB.ca

09-06-2006 10:33 PM

I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...

NetRover

09-09-2006 06:22 PM

Quote:

Originally Posted by tazB.ca

I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...

Me too, exactly. Would like my users to be able to find their thread without having to ask the team. I'm not interested in the count and would like to be able to turn it off.

Snake

09-09-2006 07:52 PM

Weird. It's working just fine on my forums.

snowlion

09-12-2006 01:33 AM

Quote:

Originally Posted by Snake

Weird. It's working just fine on my forums.

can you post your customized for this hack to work with 3.6.0

Snake

09-12-2006 12:45 PM

Quote:

Originally Posted by snowlion

can you post your customized for this hack to work with 3.6.0

Look in the previous page, the post by Oblivion. That should do it. ;)

All times are GMT. The time now is 04:58 AM.

Page 2 of 3

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01294 seconds Memory Usage 1,829KB 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 (5)bbcode_code_printable (12)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 (40)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: