In place of your plugin, you could create a plugin using hook notifications_list and code like:
Code:
$sql = mysql_query("select count(*) from songrequests where req_status <= 1");
$row = mysql_fetch_row($sql);
if($row)
{
if ($row[0] == 1) {
$msg = "There is $row[0] Song Request Waiting";
} elseif ($row[0] > 1) {
$msg = "There are $row[0] Song Requests Waiting";
}
$notifications['countsr'] = array(
'phrase' => $msg,
'link' => 'SongRequests.php',
'order' => 20
);
$vbulletin->userinfo['countsr'] = $row[0];
}