<?PHP

/* ====================
[BEGIN_SED]
File=plugins/newlatestposts/newlatestposts.php
Version=**
Updated=
Type=Plugin
Author=***
Description=***
[END_SED]

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

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

$plimit = "10";   // 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 AND s.fs_id !=30 AND s.fs_id !=25 ORDER by t.ft_updated DESC LIMIT $plimit");

$newlatestposts = "<table border='0' width='100%' cellspacing='0' cellpadding='1' align='center'>";
$newlatestposts .= "<tr><td><strong>Konu</strong></td><td><strong>Mesajlar</strong></td><td><strong>Okunma</strong></td><td><strong>Son G?nderen</strong></td><td><strong>Tarih</strong></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;baslik=".sed_filtetr(str_replacei($row['ft_title']))."&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> ";

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

$newlatestposts .="<td>&nbsp;(" .$row["ft_postcount"]. ") </td>";
$newlatestposts .="<td>&nbsp;(" .$row["ft_viewcount"]. ")</td>";
$newlatestposts .= "<td>".sed_build_user($row['ft_lastposterid'], $row['ft_lastpostername'])."</td>"; 
$newlatestposts .= "<td>&nbsp; ".date($cfg['formatmonthdayhourmin'], $row['ft_updated'] + $usr['timezone'] * 3600)."</td></tr>";

}
}

if($ii==0){
$newlatestposts .= "<tr><td colspan=\"5\"><center>Son Forum Mesajlar?n? G?rebilmek ??in Giri? Yap?n?z..</center></td></tr>";
}

$newlatestposts .= "</table>";

$t-> assign(array(
"PLUGIN_NEWLATEST_POSTS" => $newlatestposts,
));

?>

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