Forum Home Enhancements - Total Threads Made by User

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

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>

[Prorockz]

how can i add like you did at profile?

[exel]

Originally Posted by yarmaa

Not working.
Empty fields, where it should be a number of threads.

Does your database have a prefix?

Originally Posted by Prorockz

how can i add like you did at profile?

You want to add it to the user profile page or postibit?

Mine shows in my sidebar.

[Prorockz]

not working from my side.
my DB don't use any prefixes.
and also i want to show it to postbit like yours and in uper than profile