Remove forum from $newposts search

[dreck]

Remove forum from $newposts search.

In the welcomeback module on my CMPS page I want to exclude my RSS forums from the "$newposts" next to the "New posts:"

I am using:

$vbulletin->GPC['exclude'] .= '78,79,81,83,84,85';
and the hook: search_getnew_start

This seems to work great to remove the forums from the actual search. But doesn't help in changing the value next to the "New posts:"

Any ideas?


Thanks dreck

[dreck]

I think I found the query, but am not sure how I can exclude the forums?


// New posts
if ($mod_options['portal_welcome_newposts'])
{
if (strlen($vbulletin->session->vars['newposts']) > 0 AND !$vbulletin->options['threadmarking'])
{
$newposts = number_format($vbulletin->session->vars['newposts']);
}
else
{
$getnewposts = $db->query_first("
SELECT COUNT(*) AS count
FROM " . TABLE_PREFIX . "post AS post
" . iif($vbulletin->options['threadmarking'], 'LEFT JOIN ' . TABLE_PREFIX . 'threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = ' . $vbulletin->userinfo['userid'] . ')') . "
WHERE dateline >= " . $vbulletin->userinfo['lastvisit'] . iif($vbulletin->options['threadmarking'], ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)')
);
$db->query_write("UPDATE " . TABLE_PREFIX . "session SET newposts = '$getnewposts[count]' WHERE userid = '" . $vbulletin->userinfo['userid'] . "'");
$newposts = vb_number_format($getnewposts['count']);
}
}