<?PHP

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

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

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

$plimit = "5";   // 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 =25 ORDER by t.ft_updated DESC LIMIT $plimit");

$songarbagetopics = "<table border='0' width='100%' cellspacing='0' cellpadding='1' align='center'>";
$songarbagetopics .= "<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> ";

$songarbagetopics .= "<tr><td> &nbsp;";
$songarbagetopics .= $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>";

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

}
}

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

$songarbagetopics .= "</table>";

$t-> assign(array(
"PLUGIN_SONGARBAGE_POSTS" => $songarbagetopics,
));

?>

<?PHP

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

[BEGIN_SED_EXTPLUGIN]
Code=songarbagetopics
Name=Son garbage topic
Description=
Version=100
Date=2006-mar-10
Author=***
Copyright=
Notes=
SQL=
Auth_guests=R
Lock_guests=W12345A
Auth_members=R
Lock_members=W12345A
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

?>