[ManuelW]

Originally Posted by pet0etie

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