Well, I'll post the code I use on one of my mods to put in an extra line in the Notifications box and you can change it for your own needs.
location - notifications_list
PHP Code:
if ($vbulletin->userinfo['ttdtrader_s'] >= '1') {
// add notification
$notifications['threadattention'] = array(
'phrase' => 'Threads Needing Attention',
'link' => 'verifythreads.php?' . $vbulletin->session->vars['sessionurl'] . 'do=list',
'order' => 12
);
.... my query to get the count ....
$vbulletin->userinfo['threadattention'] = intval($holdquery['count']);
}
You can, of course, use a phrase where it says 'phrase' up there, but I didn't for this. It was just a quick plugin I just wanted to work at the time. One of these days I'll fix it.