<?PHP

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/sonsayfalar/sonsayfalar.php
Version=102+ (110 - 120 - 121)
Updated=2007-may-09
Type=Plugin
Author=Dvdbil
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=sonsayfalar
Part=main
File=sonsayfalar
Hooks=index.tags
Tags=index.tpl:{INDEX_DOKUMANLAR},{INDEX_DOSYALAR}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]

==================== */

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

if (!$dokumanlar)
{
$sql = sed_sql_query("SELECT page_id, page_alias, page_ownerid, page_title, page_date, page_author, page_count FROM $db_pages WHERE page_state=0 AND page_file=0 ORDER by ".$cfg["plugin"]["sonsayfalar"]["dokumanorder"]." DESC LIMIT ".$cfg["plugin"]["sonsayfalar"]["dokumanlimit"]."");

$dokumanlar = "<h4>Son Eklenen Dökümanlar</h4>";
$dokumanlar .= "<table class=\"cells\"><tr>";
$dokumanlar .= "<td class=\"coltop\">Döküman Adı</td>";
$dokumanlar .= "<td class=\"coltop\">Eklenme Tarihi</td>";
$dokumanlar .= "<td class=\"coltop\">Hit</td>";
$dokumanlar .= "<td class=\"coltop\">Gönderen</td></tr>";

while ($row = sed_sql_fetcharray($sql))
{
$sqluser = sed_sql_query("SELECT user_id, user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."' LIMIT 1");
$rowuser = sed_sql_fetcharray($sqluser);
$row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
$dokumanlar .= "<tr><td><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /> <a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), $cfg["plugin"]["sonsayfalar"]["dokumanbaslik"]))."</a></td>";
$dokumanlar .= "<td>".date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."</a></td>";
$dokumanlar .= "<td style=\"text-align:center;\">".$row['page_count']."</td>";
$dokumanlar .= "<td style=\"text-align:center;\">".sed_build_user($rowuser['user_id'], sed_cc(stripslashes($rowuser['user_name'])))."</td></tr>";
}
$dokumanlar .= "</table>";

sed_cache_store('dokumanlar', $dokumanlar, $cfg["plugin"]["sonsayfalar"]["dokumancache"]);
}

if (!$dosyalar)
{
$sql = sed_sql_query("SELECT page_id, page_alias, page_ownerid, page_title, page_date, page_author, page_count FROM $db_pages WHERE page_state=0 AND page_file=1 ORDER by ".$cfg["plugin"]["sonsayfalar"]["dosyaorder"]." DESC LIMIT ".$cfg["plugin"]["sonsayfalar"]["dosyalimit"]."");

$dosyalar = "<h4>Son Eklenen Dosyalar</h4>";
$dosyalar .= "<table class=\"cells\"><tr>";
$dosyalar .= "<td class=\"coltop\">Dosya Adı</td>";
$dosyalar .= "<td class=\"coltop\">İnidirilme</td>";
$dosyalar .= "<td class=\"coltop\">Eklenme Tarihi</td>";
$dosyalar .= "<td class=\"coltop\">Gönderen</td></tr>";

while ($row = sed_sql_fetcharray($sql))
{
$sqluser = sed_sql_query("SELECT user_id, user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."' LIMIT 1");
$rowuser = sed_sql_fetcharray($sqluser);
$row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
$dosyalar .= "<tr><td><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /> <a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), $cfg["plugin"]["sonsayfalar"]["dosyabaslik"]))."</a></td>";
$dosyalar .= "<td style=\"text-align:center;\">".$row['page_count']."</td>";
$dosyalar .= "<td>".date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."</a></td>";
$dosyalar .= "<td style=\"text-align:center;\">".sed_build_user($rowuser['user_id'], sed_cc(stripslashes($rowuser['user_name'])))."</td></tr>";
}
$dosyalar .= "</table>";

sed_cache_store('dosyalar', $dosyalar, $cfg["plugin"]["sonsayfalar"]["dosyacache"]);
}

$sql = sed_sql_query("SELECT page_id, page_alias, page_ownerid, page_title, page_date, page_author, page_count FROM $db_pages WHERE page_state=0 AND page_cat='mp3' ORDER by page_date DESC");

$mp3ler = "<h4>Son Eklenen Dosyalar</h4>";
$mp3ler .= "<table class=\"cells\"><tr>";
$mp3ler .= "<td class=\"coltop\">Dosya Adı</td>";
$mp3ler .= "<td class=\"coltop\">İnidirilme</td>";
$mp3ler .= "<td class=\"coltop\">Eklenme Tarihi</td>";
$mp3ler .= "<td class=\"coltop\">Gönderen</td></tr>";

while ($row = sed_sql_fetcharray($sql))
{
$sqluser = sed_sql_query("SELECT user_id, user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."' LIMIT 1");
$rowuser = sed_sql_fetcharray($sqluser);
$row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
$mp3ler .= "<tr><td><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /> <a href=\"page.php?id=".$row['page_id']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), $cfg["plugin"]["sonsayfalar"]["dosyabaslik"]))."</a></td>";
$mp3ler .= "<td style=\"text-align:center;\">".$row['page_count']."</td>";
$mp3ler .= "<td>".date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."</a></td>";
$mp3ler .= "<td style=\"text-align:center;\">".sed_build_user($rowuser['user_id'], sed_cc(stripslashes($rowuser['user_name'])))."</td></tr>";
}
$mp3ler .= "</table>";

$t->assign(array(
"INDEX_DOKUMANLAR" => $dokumanlar,
"INDEX_DOSYALAR" => $dosyalar,
"INDEX_MP3LER" => $mp3ler,
));
?>