[Logikos]

I got this to work on the forumhome page of vbulletin.

In 'forums/index.php'
Find

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 


Add Above:

PHP Code:

        $threadcount = $DB_site->query_first("
                SELECT COUNT(*) AS count
                FROM " . TABLE_PREFIX . "moderation
                WHERE type='thread'"
        ); 


Now add '$threadcount[count]' (with out quotes) to your forumhome template and it will display the number of new threads that need to be moderated.