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)

[Oblivion Knight]

Awesome, very nice work guys..

Installed.

[Boofo]

Thank you, sir, Enjoy!

[davidw]

As requested on posting my information, here's an sql error I've received.

Database error in vBulletin 3.5.4: 
  
 Invalid SQL: 
 CREATE TEMPORARY TABLE vb_userthreads (userid INT(10) UNSIGNED NOT NULL DEFAULT '0', 
 threads INT(10) UNSIGNED NOT NULL DEFAULT '0'); 
  
 MySQL Error  : Access denied for user 'xxxxx'@'localhost' to database 
 'xxxxxxx_xxx_-_xxxxxxx' 
 Error Number : 1044 
 Date         : Tuesday, May 9th 2006 @ 03:59:20 PM

I'm using PHP 4.3.9 and MySQL 4.1.10a

[davidw]

Fixed it - had to add "create temporary table" privileges/permissions to MySQL - then FLUSH the priviledges/permissions.

[Boofo]

Glad you got it sorted, sir.

I figured it was a permissions thing for MySQL. Nice to be right every now and then.

[Snake]

Awesome! Finally, you have made this hack for the vB v3.5.x series. Thanks a ton Boofo!

[tormodg]

Very nice, thank you.

*installs

[Boofo]

Originally Posted by The Free Bird

Thanks Boofo

You're welcome and you are going to miss a very important update in the next day or two.

[TCattitude]

A question:
What is the difference of this mod with this one:
https://vborg.vbsupport.ru/showthrea...ght=post+count
...from Andreas. Obviously, without taking care of the point you write about, Boofo, in the post #4 of that thread. Hm?.

[Boofo]

Originally Posted by TCattitude

A question:
What is the difference of this mod with this one:
https://vborg.vbsupport.ru/showthrea...ght=post+count
...from Andreas. Obviously, without taking care of the point you write about, Boofo, in the post #4 of that thread. Hm?.

This is just an expansion of that with the added things from the first post here, which now account for moderated and deleted threads.