Last posts since last visit!

[BBR-APBT]

AdminCP --> Plugins & Products --> Add New Plugin

Product: vBulletin
Hook Location: global_start
Title: New post on top of forums
Plugin PHP Code:

$newposts = $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)'));
$newposts = vb_number_format($newposts['count']);

Plugin is Active: yes


Then put this where ever you want it in a template:

$vbphrase[new_posts] since your last visit: <a href="search.php?$session[sessionurl]do=getnew">$newposts</a>

I put mine at the very end of navbar. This should work on 3.7 and 3.8.