<?PHP

/* ====================
Land Down Under - Website engine
Copyright Kaan
http://www.ntka.org

[BEGIN_SED]
File=plugins/latestposts/latestposts.php
Version=2
Updated=
Type=Plugin
Author=| Kaan | www.ntka.org Yazar bilinmiyor..
Description=Ana Sayfada Son Forum Konulari
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=latestposts
Part=main
File=latestposts
Hooks=index.tags
Tags=index.tpl:{PLUGIN_latestposts}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */

if ( !defined('SED_CODE') ) { die("Hacking attempt."); }

$plimit = "20";   // define number of rows you want to see...

$sql = sed_sql_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, t.ft_postcount, t.ft_viewcount, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id AND t.ft_movedto=0 AND t.ft_mode=0 ORDER by t.ft_updated DESC LIMIT $plimit");

$latestposts = "<table border='1' width='100%' cellspacing='0' bordercolor='000000' cellpadding='0' align='center'>";
$latestposts .= "<tr><td>Konu</td><td>Mesajlar</td><td>Okunma</td><td>Son Gönderen</td><td>Tarih</td></tr>";

$ii=0;
while ($row = sed_sql_fetcharray($sql)){
if (sed_auth('forums', $row['fs_id'], 'R')){

$ii++;
$img = ($usr['id']>0 && $row['ft_updated']>$usr['lastvisit']) ? "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."&amp;n=unread#unread\"><img src=\"skins/$skin/img/system/arrow-unread.gif\" alt=\"\" /></a>" : "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\"><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /></a> ";

$latestposts .= "<tr><td> &nbsp;";
$latestposts .= $img." <a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\">".sed_cc(sed_cutstring(stripslashes($row['ft_title']),38))."</a></td>";

$latestposts .="<td>&nbsp;(" .$row["ft_postcount"]. ") </td>";
$latestposts .="<td>&nbsp;(" .$row["ft_viewcount"]. ")</td>";
$latestposts .= "<td>&nbsp;<a href='users.php?m=details&amp;id=".$row["ft_lastposterid"]."'>".$row["ft_lastpostername"]."</a></td>";$latestposts .= "<td>&nbsp; ".date($cfg['formatmonthdayhourmin'], $row['ft_updated'] + $usr['timezone'] * 3600)."</td></tr>";

}
}

if($ii==0){
$latestposts .= "<tr><td colspan=\"5\"><center><font color='red'>Son Forum Konularini Görmek için Giris Yapiniz</font></center></td></tr>";
}

$latestposts .= "</table>";

$t-> assign(array(
"PLUGIN_latestposts" => $latestposts,
));