Miscellaneous Hacks - Threads Started by User in Postbit and Profile

vB3.5.4 Threads Started by User in Postbit and Profile
Version 1.0.1
(By Andreas, Boofo, Hambil and Paul M.)

What does this product do?
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).

NOTE: This Hack requires at least mySQL 4.0.4

Version Information:
Version 1.0.0 --Initial release
Version 1.0.1 --No longer counts threads in forums that have the "Count Posts Made in this Forum Towards User Post Counts" option set to No. Also made the posts and threads counts in the postbit clickable search links like in the profile.

NOTE: You must redo the postbit template edit to get the clickable links.

Credits:
Thanks goes out to Andreas for the original version of this product. Thanks also goes out to Paul M for coming up with the way to update the thread count without adding a query to every post, and to Hambil for coming up with the way to not count threads in forums where the "Count Posts Made in this Forum Towards User Post Counts" option is set to No. Thanks guys!

Details
---------
1 Product XML (4 Plugins, 2 Phrases)

[Arngrim]

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:

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]

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:

$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]

Thanks Boofo but i've a problem

Threads: 1200
Posts: 1,800

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

[music legend]

is this mod coming out for 3.6?

[Valter]

Doesn't work properly with 3.6.

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

[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...

[NetRover]

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]

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

[snowlion]

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]

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.