<?php



#######letzten 10 Themen#######

// get forums user cannot view

$unviewable = get_unviewable_forums(true);

if($unviewable)

{

        $unviewwhere = " AND fid NOT IN ($unviewable)";

}



        $altbg = alt_trow();

        $threadlist = '';

        $query = $db->query("

                SELECT t.*, u.username

                FROM ".TABLE_PREFIX."threads t

                LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)

                WHERE 1=1 $unviewwhere AND t.visible='1' AND t.closed NOT LIKE 'moved|%'

                ORDER BY t.lastpost DESC

                LIMIT 0, 10"

        );

        while($thread = $db->fetch_array($query))

        {

                $lastpostdate = my_date($mybb->settings['dateformat'], $thread['lastpost']);

                $lastposttime = my_date($mybb->settings['timeformat'], $thread['lastpost']);

                // Don't link to guest's profiles (they have no profile).

                if($thread['lastposteruid'] == 0)

                {

                        $lastposterlink = $thread['lastposter'];

                }

                else

                {

                        $lastposterlink = build_profile_link($thread['lastposter'], $thread['lastposteruid']);

                }

                if(my_strlen($thread['subject']) > 25)

                {

                        $thread['subject'] = my_substr($thread['subject'], 0, 25) . "...";

                }

                $thread['subject'] = htmlspecialchars_uni($thread['subject']);

                $thread['threadlink'] = get_thread_link($thread['tid']);

                $thread['lastpostlink'] = get_thread_link($thread['tid'], 0, "lastpost");

                eval("\$threadlist .= \"".$templates->get("portal_latestthreads_thread")."\";");

                $altbg = alt_trow();

        }

        if($threadlist)

        {

                // Show the table only if there are threads

                eval("\$latestthreads = \"".$templates->get("portal_latestthreads")."\";");

        }

        echo $latestthreads;

#######letzten 10 Themen ENDE#######

?>