// Newest threads
function overview_newest_threads($overview_unviewwhere)
{
global $mybb, $settings, $db, $templates, $theme, $lang, $trow;
// Exclude unviewable forums => has to be done again due to changed mysql query
$overview_unviewwhere = "";
$overview_unviewable = get_unviewable_forums();
if($overview_unviewable)
{
$overview_unviewwhere = "AND t.fid NOT IN ({$overview_unviewable})";
}
// Hintergrund festlegen
$trow = alt_trow();
$table_heading = $lang->overview_newest_threads;
$column1_heading = $lang->overview_topic;
$column2_heading = "Forumname"; //$lang->overview_author;
$column3_heading = $lang->overview_replies;
// Fetch data
$query = $db->query("SELECT t.subject, t.username, t.uid, t.tid, t.replies, t.icon, t.prefix, t.fid, f.name
FROM ".TABLE_PREFIX."threads t
LEFT JOIN ".TABLE_PREFIX."forums f ON (t.fid = f.fid)
WHERE visible = '1' {$overview_unviewwhere} AND closed NOT LIKE 'moved|%'
ORDER BY dateline DESC
LIMIT 0,{$settings['overview_max']};");
// Print data
while ($threads = $db->fetch_array($query))
{
$val1 = overview_parsesubject($threads['subject'], $threads['icon'], $threads['prefix'], $threads['tid']);
//$val2 = overview_parseuser($threads['uid'], $threads['username']);
$val2 = overview_parsesubject($threads['name']);
$val3 = "<a href=\"javascript:MyBB.whoPosted({$threads['tid']});\">{$threads['replies']}</a>";
eval("\$table_content .= \"".$templates->get("overview_3_columns_row")."\";");
}
eval("\$output = \"".$templates->get("overview_3_columns")."\";");
return $output;
}
