<?PHP
/* ====================
Land Down Under - Website engine
Copyright (C) 2003 Neocrome
http://ldu.neocrome.net

[BEGIN_SED]
File=newmesaj.php
Version=170
Updated=2005-dec-12
Type=Core
Author=Neocrome
Description=Forums loader
[END_SED]

==================== */
define('SED_CODE', TRUE);
define('SED_FORUMS', TRUE);
$location = 'Forums';
$z = 'forums';

require('system/functions.php');
require('datas/config.php');
require('system/common.php');
require('system/header.php');
// ==================================
sed_dieifdisabled($cfg['disableforums']);
$topics_default = 50;
$dates = sed_import("since","P","INT");
if(empty($dates))
{
$dates  = sed_import("since","G","INT");
}
if(empty($dates))
{
$dates = 172800;
}
$date = $usr['lastvisit'] - $dates;
if($isguest == TRUE)
{
$date =  $sys['now_offset'] - $dates;
}
if ($usr['id'] >0)
{
$sqltmp = sed_sql_query("SELECT p.fp_id, t.ft_title, t.ft_id, t.ft_updated, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title
FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s
WHERE fp_posterid!='".$usr['id']."'
AND fp_updated>'$date'
AND p.fp_topicid=t.ft_id
AND p.fp_sectionid=s.fs_id
GROUP BY t.ft_id
ORDER BY s.fs_category ASC, s.fs_order ASC, s.fs_title ASC, t.ft_updated DESC
LIMIT $topics_default ");
echo "<table class=\"main\">";
if (sed_sql_numrows($sqltmp)==0)
{
echo " &nbsp; &nbsp; <br><br> &nbsp; &nbsp; <b> Siteden Son ??k???n?zdan, ?u Zamana Kadar Yeni
Yaz?lan Mesaj Bulunmamaktad?r.</b><br><br><br><br><br><br><br><br>&nbsp; &nbsp; <b>&nbsp; &nbsp; <a href='forums.php'>Forumlara Geri D?n < </b></a><br><br><br>";
}
else
{
echo "&nbsp; &nbsp;  <b>Forum'da Yeni Mesajlar var !</b>* &nbsp; &nbsp;    Siteye son giri?leriniz g?z?n?nde bulundurularak yeni mesajlar hesaplan?r.     &nbsp; &nbsp;    <b>Maksimum 50 Son Mesaj G?r?nt?lenir !</b>* </center>";
echo "<tr>";
echo "<td class=\"coltop\">Ba?l?k</td>";
echo "<td class=\"coltop\">G?nderen</td>";
echo "<td class=\"coltop\">Tarih</td></tr>";
while ($row = sed_sql_fetcharray($sqltmp))
{
echo "<td> <b><a href=\"forums.php?m=posts&amp;q=".$row["ft_id"]."&n=last#bottom\" title='".$row['fs_title']." - ".$row['ft_title']."'> ".sed_cutstring(stripslashes($row["ft_title"]),48)."</a></b></td>";
echo "<td>&nbsp; Son G?nderen ".$row['ft_lastpostername'] = sed_build_user($row['ft_lastposterid'], sed_cc($row['ft_lastpostername']));"</td>";
echo "<td>&nbsp; ".@date($cfg['formatyearmonthday'],$row["ft_updated"]+$stimezone*3600)."</td></tr>";
}
echo "</table>";
}
       }
else
{
if ($usr['id'] <1){
echo "&nbsp;Bunun i?in yetkili degilsiniz..<b><br> L?tfen Giri? Yap?n?z..<br><br>";
}
}
require('system/footer.php');
?>