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