Miscellaneous Hacks - Threads Started by User in Postbit & Profile

First of all this is a fixed version of Threads Started by User in Postbit and Profile for 3.5.4 by Boofo. I would like to thanks to Boofo for giving me the permission of releasing this.

Originally Posted by Boofo

Go for it, if it is totally tested and working

As this product is the original work of Boofo. So I’m going to use his description as well. All I did is fixed one error related to DB query & remove the MySQL version check as vBulletin 3.6.x already requires MySQL 4.3.3.

Description:
This product counts the threads started by a user and displays it in the postbit and the profile. It will also display the threads per day in the profile. The thread count is automatically updated hourly via cron job. New threads are added to the count in real time. No extra queries are run in the postbit or profile when getting the thread count, only when the cron job runs. This product has been tested on a live board with over 15,000 users and 40,000 threads and ran unnoticeably in the background in 0.3 seconds during the cron job update. This product only counts valid threads (not moderated or soft-deleted threads).

Live Demo:
Golpo Community Forum

Install Instruction:

• Import the product-thread_count_7272
• Edit the "postbit" & "MEMBERINFO" Template.

Update Instruction:

• Import the product-thread_count_7272. Don't forget to allow overwrite!

Screenshots & template edit instructions are included in zip file.

[Chester87]

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]

Yeah I would like to know that also

[momo2]

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]

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]

Originally Posted by Andyucs

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]

Try uninstall then reinstall the hack.

[Mystery Man]

Originally Posted by Mudvayne

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]

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

[DiverTree]

Originally Posted by Mudvayne

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]

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:

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