[vBulletin] Total Threads Made by User

[Exel]

Product: vBulletin
Hook Location: global_start
Title: Total Threads Made by User
Execution Order: 5
Plugin PHP Code:

$querythread = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "thread WHERE postuserid = " . $vbulletin->userinfo['userid'] . " AND visible = '1'");
// Brought to you by Exel from Elite-Source.com
$totalthread = vb_number_format($querythread['count']); 

Template code (Add it wherever you want it to show):

<b>Threads:</b> <a href="search.php?do=process&showposts=0&starteronly=1&exactname=1&searchuser=$bbuserinfo[username]">$totalthread</a>

Exel Reviewed by Exel on 3rd May 2012. [vBulletin] Total Threads Made by User http://i.imgur.com/rT7H6.png Product: vBulletin Hook Location: global_start Title: Total Threads Made by User Execution Order: 5 Plugin PHP Code: $querythread = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "thread WHERE postuserid = " . $vbulletin->userinfo . " AND visible = '1'"); // Brought to you by Exel from Elite-Source.com $totalthread = vb_number_format($querythread); Rating: 5