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>

[LouiseWilson]

at the moment its blank and i've re checked the code I've entered

[exel]

Where are you trying to show it?
Does your forum database have a prefix?

[Boofo]

Ouch! That is gonna add a query for every page as well as every post on the page of a thread.

[Xp.Warrior]

Brother Tell Us Step By Step I Cannot Understand

[exel]

Originally Posted by Boofo

Ouch! That is gonna add a query for every page as well as every post on the page of a thread.

Yeah, hence 'global.'

Least you're able to add it wherever you want.

[exel]

Originally Posted by the-rulez

Brother Tell Us Step By Step I Cannot Understand

Admin Control Panel > Plugins & Products > Add New Plugin

[Boofo]

Originally Posted by exel

Yeah, hence 'global.'

Least you're able to add it wherever you want.

Yes, but the disadvantages far out way that advantage.

[exel]

Originally Posted by Boofo

Yes, but the disadvantages far out way that advantage.

Indeed, sorry, didn't mean to sound like an +++++++ or anything, but still, most users are normal, don't really care/know users, so meh.

[yarmaa]

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