CMS Made Simple Forums

CheckForumPermission('default'))
return $this->FrontEndDisplayMessage($id, $params, $returnid, $this->Lang('forum_access'));

$this->CurrentPath = $this->GetCurrentPath();
$this->ModulePath = $this->GetModulePath();

// added by NaN to show username of last post in forums list
$feusers = $this->GetModuleInstance('FrontEndUsers');

$arr_url = array();
if(isset($params['lang'])) $arr_url['lang'] = $params['lang'];
$arr_url['property_feu'] = (isset($params['property_feu'])) ? $params['property_feu'] : '';
$arr_url['prev_link'] = 'default';



$sql = "SELECT f.*, COUNT(t.id) as topic_count FROM ".
cms_db_prefix()."module_forum_forums f LEFT JOIN ".cms_db_prefix()."module_forum_topics t ON f.id = t.forum_id
GROUP BY f.id
ORDER BY position, f.name";
$dbresult =& $db->Execute($sql);

$items=array();
while($dbresult && $row = $dbresult->FetchRow())
{
$onerow = new stdClass;
$onerow->id = $row['id'];
$onerow->name = (empty($row['name'])) ? '?' : cms_htmlentities($row['name']);
$onerow->description = cms_htmlentities($row['description']);
$onerow->topic_count = $row['topic_count'];

$arr_localurl = array('action'=>'forum', 'fid'=>$onerow->id);
$prettyurl = $this->CurrentPath.'/forum/forum/'.$row['id'].'/1/'.$returnid;
$onerow->name_link = $this->CreateLink($id, 'forum', $returnid, $onerow->name, array_merge($arr_url,$arr_localurl), '', false, false, '', false, $prettyurl);

// Added by NaN to show last post of current forum in forumslist
$query = "SELECT topic_id,subject,user_id,posted FROM ".cms_db_prefix()."module_forum_posts AS posts
LEFT JOIN ".cms_db_prefix()."module_forum_topics AS topics
ON topics.id=posts.topic_id
LEFT JOIN ".cms_db_prefix()."module_forum_forums AS forums
ON forums.id=topics.id WHERE forum_id=". $row['id'] ."
ORDER BY posted DESC LIMIT 1";
$dbresult2 =& $db->Execute($query);
if($dbresult2 && $row2 = $dbresult2->FetchRow())
{
$arr_url['tid'] = $row2['topic_id'];
$onerow->subject = $row2['subject'];
$onerow->username = $this->lang('guest_user_name');
if($feusers)
{
$username = $feusers->GetUserName($row2['user_id']);
if($username!='')
$onerow->username = $username;
}
$onerow->subject_link = $this->CreateLink($id, 'topic', $returnid, $onerow->subject, array_merge($arr_url,$arr_localurl), '', false, false, '', false, $prettyurl);
$onerow->post_date = $this->FormatDate($row2['posted']);
}
// ---

$items[] = $onerow;
}

$this->smarty->assign('itemcount', count($items));
$this->smarty->assign_by_ref('items', $items);
$this->smarty->assign('last_post_label', $this->Lang('topic_last_post_label'));
$this->smarty->assign('forum_name_label', $this->Lang('forum_name_label'));
$this->smarty->assign('forum_topic_count_label', $this->Lang('forum_topic_count_label'));
$this->smarty->assign('forum_icon', 'ModulePath.'/images/forum.png" alt="'.$this->Lang('forum').'" title="'.$this->Lang('forum').'" width="22" height="22" />');

echo $this->ProcessTemplate('index.tpl');
?>

{if $itemcount > 0}





 
{$forum_name_label}
{$forum_topic_count_label}
{$last_post_label}



{foreach from=$items item=entry}
{cycle values="forum_alternate1,forum_alternate2" assign="alt_bgcolor"}

{$forum_icon}
{$entry->name_link}
{$entry->description}
{$entry->topic_count}
{$entry->post_date}
by {$entry->username}
in {$entry->subject_link}

{/foreach}


{/if}