[Taurine]

Code I tried:

PHP Code:


                {
            $getnewapps = $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 forumid = 38 AND dateline >= " . $vbulletin->userinfo['lastvisit'] .
                    iif($vbulletin->options['threadmarking'],
                        ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)') . "
                    AND visible = 1
            ");

            if (!$vbulletin->options['threadmarking'])
            {
                $db->query_write("UPDATE " . TABLE_PREFIX . "session SET newposts = '$getnewapps[count]' WHERE userid = " . $vbulletin->userinfo['userid']);
            }

            $newapps = vb_number_format($getnewapps['count']);
        } 


Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(*) AS count
FROM imperialpost AS post

WHERE forumid = 38 AND dateline >= 1228313329
AND visible = 1;

MySQL Error : Unknown column 'forumid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, December 3rd 2008 @ 07:42:31 PM
Error Date : Wednesday, December 3rd 2008 @ 07:42:31 PM
Script : http://www.fooguild.com/
Referrer : http://www.fooguild.com/forums/forumdisplay.php?f=38
IP Address : ...............
Username : ...................
Classname : vB_Database
MySQL Version : 5.0.51a-community-log