For some reason it stopped working for me at all. I did work on the same version and server before, but not anymore. Is it possible something is blocking it?

tried to click your https://vborg.vbsupport.ru/external/2012/03/7.gif for your good advice but it denied me the option, so thanks for solving my issue! :)

thanks for add

Got this running fine on vb 3.8.5 with a custom style.

I added this line to my Navbar template in order to get it to show up as it wasn't showing up automatically:
Then to get it working on vBAdvanced home page I added the following to the Portal Output Global Variables section in the Main Settings option under the vBa CMPS settings page.
It's working perfectly. With no noticeable increase in server load....yet *touchwood* :p

if u have a database with a prefix, the query isn't working

current version :

SELECT COUNT(*) AS posts, post.threadid, thread.forumid FROM " . TABLE_PREFIX . "post LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid) WHERE post.visible = '1' $cybanp_exclforums AND post.dateline >= " . $db->escape_string($vbulletin->userinfo['lastvisit']) . " GROUP BY post.threadid

correct version :

SELECT COUNT(*) AS posts, post.threadid, thread.forumid FROM " . TABLE_PREFIX . "post as post LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid) WHERE post.visible = '1' $cybanp_exclforums AND post.dateline >= " . $db->escape_string($vbulletin->userinfo['lastvisit']) . " GROUP BY post.threadid

otherwise the result will always be 0
thanks for correcting this !

It makes it working, but it makes my forum very slow and opens a lot processes in mysql :(