Warning: implode(): Bad arguments. in c:\program files\easyphp1-8\www\plugins\archives\archives.php on line 51
siteadı.com
2008-03-22 14:33
Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE news_minlevel<='99' AND news_date<'1206189190' AND n

<?PHP

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

[BEGIN_SED]
File=plugins/archives/archives.php
Version=801
Updated=2005-oct-10
Type=Plugin
Author=Neocrome
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Auth_guests=R
Lock_guests=W12345A
Auth_members=R
Lock_members=12345
Code=archives
Part=main
File=archives
Hooks=standalone
Tags=
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]

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

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

$month = sed_import('month','G','INT');
$year = sed_import('year','G','INT');

if (empty($month) || empty($year))
{
$plugin_title = "<a href=\"plug.php?e=archives\">".$L['plu_title']."</a>";

$table = array();
$prevyear = '';

$plugin_body = '<h4>'.$L['plu_bydate'].' :</h4>';

$sql = sed_sql_query("SELECT news_date FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date<'".$sys['now_offset']."'
AND news_state=0
[red]AND news_cat IN ('".implode("','", $sed_catacc)."')[/red]
ORDER BY news_date DESC");

while ($row = sed_sql_fetcharray($sql))
{
$now = $row['news_date'] + $usr['timezone'] * 3600;
$year = date('Y', $now);
$month_str = date('F', $now);
$month_str = ereg_replace($month_str, $L[$month_str], $month_str);

$month = date('n', $now);

if ($prevyear!=$year)
{
$plugin_body .= "<p>".$year."</p>";
$prevyear = $year;
}

if (!$table[$year][$month])
{
$table[$year][$month]++;
$plugin_body .= "&nbsp; <a href=\"plug.php?e=archives&amp;year=".$year."&amp;month=".$month."\">".$month_str."</a><br />";
}
}

$plugin_body .= '<h4>'.$L['plu_bycategory'].' :</h4>';

$sql = sed_sql_query("SELECT DISTINCT news_cat FROM $db_news WHERE 1 ORDER BY news_cat");

while ($row = sed_sql_fetcharray($sql))
{
$sql1 = sed_sql_query("SELECT COUNT(*) FROM $db_news WHERE news_cat='".$row['news_cat']."'");

$plugin_body .= "&nbsp; <a href=\"index.php?c=".$row['news_cat']."&amp;m=all\">".$sed_cat[$row['news_cat']]['tpath']."</a> (".sed_result($sql1,0,"COUNT(*)").")<br />";
}

$sql = sed_sql_query("SELECT news_id, news_title, news_date FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date<'".$sys['now_offset']."'
AND news_state=0
AND news_cat IN ('".implode("','", $sed_catacc)."')
ORDER BY news_date DESC");
elseif ($month>0 && $month<13 && $year>1980 && $year<2010)

{
$month_str = date("F", sed_mktime(0, 0, 0, $month, 1, $year));
$month_str = ereg_replace($month_str, $L[$month_str], $month_str);

$plugin_title = "<a href=\"plug.php?e=archives\">".$L['plu_title']."</a> ".$cfg['separator']." <a href=\"plug.php?e=archives&amp;year=".$year."&amp;month=".$month."\">".$month_str." ".$year."</a>";

$start = sed_mktime(0, 0, 0, $month, 1, $year);
$end = sed_mktime(23, 59, 59, $month, 31, $year);

$sql = sed_sql_query("SELECT news_id, news_title, news_cat, news_date
FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date>='$start'
AND news_date<='$end'
AND news_state=0
AND news_cat IN ('".implode("','", $sed_catacc)."')
ORDER BY news_date DESC");

while ($row = sed_sql_fetcharray($sql))
{
$plugin_body .= date($cfg['dateformat'], $row['news_date'] + $usr['timezone'] * 3600);
$plugin_body .= " : <a href=\"index.php?m=single&amp;id=".$row['news_id']."\">";
$plugin_body .= stripslashes($row['news_title'])."</a><br />";
}
}
?>

<?PHP

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

[BEGIN_SED]
File=plugins/archives/archives.php
Version=801
Updated=2005-oct-10
Type=Plugin
Author=Neocrome
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Auth_guests=R
Lock_guests=W12345A
Auth_members=R
Lock_members=12345
Code=archives
Part=main
File=archives
Hooks=standalone
Tags=
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]

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

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

$month = sed_import('month','G','INT');
$year = sed_import('year','G','INT');

if (empty($month) || empty($year))
{
$plugin_title = "<a href=\"plug.php?e=archives\">".$L['plu_title']."</a>";

$table = array();
$prevyear = '';

$plugin_body = '<h4>'.$L['plu_bydate'].' :</h4>';

$sql = sed_sql_query("SELECT news_date FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date<'".$sys['now_offset']."'
AND news_state=0
AND news_cat IN ('".implode("','", $sed_catacc)."')
ORDER BY news_date DESC");

while ($row = sed_sql_fetcharray($sql))
{
$now = $row['news_date'] + $usr['timezone'] * 3600;
$year = date('Y', $now);
$month_str = date('F', $now);
$month_str = ereg_replace($month_str, $L[$month_str], $month_str);

$month = date('n', $now);

if ($prevyear!=$year)
{
$plugin_body .= "<p>".$year."</p>";
$prevyear = $year;
}

if (!$table[$year][$month])
{
$table[$year][$month]++;
$plugin_body .= "&nbsp; <a href=\"plug.php?e=archives&amp;year=".$year."&amp;month=".$month."\">".$month_str."</a><br />";
}
}

$plugin_body .= '<h4>'.$L['plu_bycategory'].' :</h4>';

$sql = sed_sql_query("SELECT DISTINCT news_cat FROM $db_news WHERE 1 ORDER BY news_cat");

while ($row = sed_sql_fetcharray($sql))
{
$sql1 = sed_sql_query("SELECT COUNT(*) FROM $db_news WHERE news_cat='".$row['news_cat']."'");

$plugin_body .= "&nbsp; <a href=\"index.php?c=".$row['news_cat']."&amp;m=all\">".$sed_cat[$row['news_cat']]['tpath']."</a> (".sed_result($sql1,0,"COUNT(*)").")<br />";
}

$sql = sed_sql_query("SELECT news_id, news_title, news_date FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date<'".$sys['now_offset']."'
AND news_state=0
AND news_cat IN ('".implode("','", $sed_catacc)."')
ORDER BY news_date DESC");
elseif ($month>0 && $month<13 && $year>1980 && $year<2010)

{
$month_str = date("F", sed_mktime(0, 0, 0, $month, 1, $year));
$month_str = ereg_replace($month_str, $L[$month_str], $month_str);

$plugin_title = "<a href=\"plug.php?e=archives\">".$L['plu_title']."</a> ".$cfg['separator']." <a href=\"plug.php?e=archives&amp;year=".$year."&amp;month=".$month."\">".$month_str." ".$year."</a>";

$start = sed_mktime(0, 0, 0, $month, 1, $year);
$end = sed_mktime(23, 59, 59, $month, 31, $year);

$sql = sed_sql_query("SELECT news_id, news_title, news_cat, news_date
FROM $db_news
WHERE news_minlevel<='".$usr['level']."'
AND news_date>='$start'
AND news_date<='$end'
AND news_state=0
AND news_cat IN ('".implode("','", $sed_catacc)."')
ORDER BY news_date DESC");

while ($row = sed_sql_fetcharray($sql))
{
$plugin_body .= date($cfg['dateformat'], $row['news_date'] + $usr['timezone'] * 3600);
$plugin_body .= " : <a href=\"index.php?m=single&amp;id=".$row['news_id']."\">";
$plugin_body .= stripslashes($row['news_title'])."</a><br />";
}
}
?>