Die letzen Beiträge?! - Druckversion

PHP-Code:

$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, ".$mybb->settings['portal_showdiscussionsnum']
);

PHP-Code:

$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|%' AND t.fid IN (x,y,z)
    ORDER BY t.lastpost DESC
    LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
);

PHP-Code:

// Latest forum discussions from an subforum
 // Which fid you want to show; only give one number

if($mybb->settings['portal_showdiscussions'] != "no" && $mybb->settings['portal_showdiscussionsnum'])
{
         $altbg = "trow1";
    $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|%' AND t.fid IN (10,12,9,7,41)
    ORDER BY t.lastpost DESC
    LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
);
    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']) > 40)
                {
                        $thread['subject'] = my_substr($thread['subject'], 0, 75) . "...";
                }
                $thread['subject'] = htmlspecialchars_uni($thread['subject']);
                $thread['threadlink'] = get_thread_link($thread['tid']);
                if(!is_array($forum_cache))
                {
                    cache_forums();
                }
                $latestthreads['forum'] = htmlspecialchars_uni($forum_cache[$thread['fid']]['name']);
                $threadstarter = build_profile_link($thread['username'], $thread['uid']);
        eval("\$threadlist .= \"".$templates->get("portal_latestthreadssub_thread")."\";");
        $altbg = alt_trow();
    }
    if($threadlist)
    { // show the table only if there are threads
        eval("\$latestthreadssub = \"".$templates->get("portal_latestthreadssub")."\";");
    }
}

Code:

if($threadlist)

    { // show the table only if there are threads

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

    }

}

Code:

<html>

<head>

<title>{$mybb->settings['bbname']}</title>

{$headerinclude}

</head>

<body>

{$header}

<table width="100%" cellspacing="0" cellpadding="{$theme['tablespace']}" border="0" align="center">

<tr><td valign="top" width="200">

{$welcome}

{$pms}

{$search}

{$stats}

{$whosonline}

{$latestthreads}

</td>

<td>&nbsp;</td>

<td valign="top">

{$announcements}

</td>

</tr>

</table>

{$footer}

</body>

</html>