[dieselpowered]

Originally Posted by KirbyDE

*** Untested ***

To make this work with the welcome module of CMPS:

In welcomeblock.php
FIND

PHP Code:

$getnewposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline >= " . $vbulletin->userinfo['lastvisit']); 


REPLACE that with

PHP Code:

$getnewposts = $db->query_first("
    SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid=post.threadid)
    WHERE post.dateline >= " . $vbulletin->userinfo['lastvisit'] . "
        AND thread.forumid NOT IN (0," . $vbulletin->userinfo['excludeforumsgnp'] . ")
"); 


(The query might need some optimization though)

Ya that did not work my friend:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT COUNT(*) AS count FROM vb3_post
LEFT JOIN vb3_thread AS thread ON (thread.threadid=post.threadid)
WHERE post.dateline >= 1128974249
AND thread.forumid NOT IN (0,);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
Error Number : 1064
Date : Monday, October 10th 2005 @ 04:44:28 PM
Script : http://www.weapondepot.com/
Referrer :
IP Address : XXX.XX.XX.XX
Username : XXXXXXXX
Classname : vb_database