[Scotty2k]

Hi,
i tried to make a latest Thread Box like this one which you can see in my attachment.. you can check it out on www.msvfans.com.

There is only one problem for me.. how can i read the Forumname for a Thread to show it in my Latest Thread Box.

Must be somewhere here, but i don?t know how to do it

PHP Code:

$getthreads = $DB_site->query(" 
        ## GET LATEST THREADS ## 
        SELECT thread.* 
        ".iif(($vbindex['options'] & VBI_SUBTHREADS) AND $bbuserinfo['userid'], ', NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed')." 
        FROM ".TABLE_PREFIX."thread AS thread 
        LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') 
        ".iif(($vbindex['options'] & VBI_SUBTHREADS) AND $bbuserinfo['userid'], " 
        LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = $bbuserinfo[userid])" 
        )." 
        $previewjoin 
        WHERE open = '1' 
        AND thread.open <> 10 
        AND forumid NOT IN (".iif(is_numeric($vbindex[newsfid]), "$vbindex[newsfid],").implode(',', $limitfids).") 
        AND thread.visible = '1' 
        AND deletionlog.primaryid IS NULL 
        $globalignore 
        $ignorelist 
        ORDER BY lastpost 
        DESC LIMIT $vbindex[maxlthreads]"); 


Could someone give me a hint how to change the query to get the forumname