<?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]
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 ('".sed_sql_prep("','", $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");

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

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

$plugin_body .= '</table>';
}

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.setup.php
Version=802
Updated=2005-dec-12
Type=Plugin
Author=Neocrome
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=archives
Name=Archives
Description=Displays old news topics
Version=1.0
Date=2005-oct-10
Author=Neocrome
Copyright=
Notes=
SQL=
[END_SED_EXTPLUGIN]

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

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

?>

<?PHP

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

[BEGIN_SED]
File=plugins/archives/lang/archives.tr.lang.php
Version=802
Updated=2005-dec-12
Type=
Author=Neocrome
Description=
[END_SED]

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

$L['plu_title'] = "News archives";
$L['plu_bydate'] = "By date";
$L['plu_bycategory'] = "By category";
$L['plu_bytitle'] = "All Headlines";

?>

<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

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

[BEGIN_SED_EXTPLUGIN]
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>";



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

$sql = sed_sql_query("SELECT DISTINCT page_cat FROM $db_pages WHERE 1 ORDER BY page_cat");

while ($row = sed_sql_fetcharray($sql))
{
$sql1 = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE

page_cat='".$row['page_cat']."'");

$plugin_body .= "&nbsp; <a

href=\"list.php?c=".$row['page_cat']."&amp;n=all\">".$sed_cat[$row['page_cat']]['tpath']."</a>

(".sed_sql_result($sql1,0,"COUNT(*)").")<br />";
}

$sql = sed_sql_query("SELECT page_id, page_title, page_date FROM $db_pages
WHERE page_date<'".$sys['now_offset']."'
AND page_state=0
AND page_cat IN ('".implode("','", $sed_cat)."')
ORDER BY page_date DESC");

}


?>

<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/extended/archives/archives.setup.php
Version=802
Updated=2005-dec-12
Type=Plugin
Author=Neocrome
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=archives
Name=Archives
Description=Displays old news topics
Version=1.0
Date=2005-oct-10
Author=Neocrome
Copyright=
Notes=
SQL=

Auth_guests=R
Lock_guests=A
Auth_members=R
Lock_members=A
[END_SED_EXTPLUGIN]

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

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

?>

<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/archives/lang/archives.tr.lang.php
Version=802
Updated=2005-dec-12
Type=
Author=Neocrome
Description=
[END_SED]

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

$L['plu_title'] = "News archives";
$L['plu_bycategory'] = "By category";


?>