Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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#######
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement