/nuke/modules/Stories_Archive/index.php

<?php



/************************************************************************/

/* PHP-NUKE: Web Portal System                                          */

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

/*                                                                      */

/* Copyright (c) 2005 by Francisco Burzi                                */

/* http://phpnuke.org                                                   */

/*                                                                      */

/* This program is free software. You can redistribute it and/or modify */

/* it under the terms of the GNU General Public License as published by */

/* the Free Software Foundation; either version 2 of the License.       */

/************************************************************************/



if (!defined('MODULE_FILE')) {

	die ("You can't access this file directly...");

}



require_once("mainfile.php");

$module_name = basename(dirname(__FILE__));

get_lang($module_name);



function select_month() {

	global $prefix, $user_prefix, $db, $module_name;

	include("header.php");

	title(""._STORIESARCHIVE."");

	OpenTable();

	echo "<center><font class=\"content\">"._SELECTMONTH2VIEW."</font><br><br></center><br><br>";

	$result = $db->sql_query("SELECT time from ".$prefix."_stories order by time DESC");

	echo "<ul>";

	while($row = $db->sql_fetchrow($result)) {

		$time = $row['time'];

		ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $getdate);

		if ($getdate[2] == "01") { $month = _JANUARY; } elseif ($getdate[2] == "02") { $month = _FEBRUARY; } elseif ($getdate[2] == "03") { $month = _MARCH; } elseif ($getdate[2] == "04") { $month = _APRIL; } elseif ($getdate[2] == "05") { $month = _MAY; } elseif ($getdate[2] == "06") { $month = _JUNE; } elseif ($getdate[2] == "07") { $month = _JULY; } elseif ($getdate[2] == "08") { $month = _AUGUST; } elseif ($getdate[2] == "09") { $month = _SEPTEMBER; } elseif ($getdate[2] == "10") { $month = _OCTOBER; } elseif ($getdate[2] == "11") { $month = _NOVEMBER; } elseif ($getdate[2] == "12") { $month = _DECEMBER; }

		if ($month != $thismonth) {

			$year = $getdate[1];

			echo "<li><a href=\"modules.php?name=$module_name&amp;sa=show_month&amp;year=$year&amp;month=$getdate[2]&amp;month_l=$month\">$month, $year</a>";

			$thismonth = $month;

		}

	}

	echo "</ul>"

	."<br><br><br><center>"

	."<form action=\"modules.php?name=Search\" method=\"post\">"

	."<input type=\"text\" name=\"query\" size=\"30\">&nbsp;"

	."<input type=\"submit\" value=\""._SEARCH."\">"

	."</form><br><br>"

	."[ <a href=\"modules.php?name=$module_name&amp;sa=show_all\">"._SHOWALLSTORIES."</a> ]</center>";

	CloseTable();

	include("footer.php");

}



function show_month($year, $month, $month_l) {

	global $prefix, $user_prefix, $db, $bgcolor1, $bgcolor2, $user, $cookie, $sitename, $multilingual, $language, $module_name, $articlecomm;

	$year = intval($year);

	$month = htmlentities($month);

	$month_l = htmlentities($month_l);

	include("header.php");

	title(""._STORIESARCHIVE."");

	title("$sitename: $month_l $year");

	$r_options = "";

	if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }

	if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }

	if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }

	OpenTable();

	echo "<table border=\"0\" width=\"100%\"><tr>"

	."<td bgcolor=\"$bgcolor2\" align=\"left\"><b>"._ARTICLES."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._COMMENTS."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._READS."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._USCORE."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._DATE."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._ACTIONS."</b></td></tr>";

	$result = $db->sql_query("SELECT sid, catid, title, time, comments, counter, topic, alanguage, score, ratings from ".$prefix."_stories WHERE time >= '$year-$month-01 00:00:00' AND time <= '$year-$month-31 23:59:59' order by sid DESC");

	while ($row = $db->sql_fetchrow($result)) {

		$sid = intval($row['sid']);

		$catid = intval($row['catid']);

		$title = stripslashes(check_html($row['title'], "nohtml"));

		$time = $row['time'];

		$comments = stripslashes($row['comments']);

		$counter = intval($row['counter']);

		$topic = intval($row['topic']);

		$alanguage = $row['alanguage'];

		$score = intval($row['score']);

		$ratings = intval($row['ratings']);

		$time = explode(" ", $time);

		$actions = "<a href=\"modules.php?name=News&amp;file=print&amp;sid=$sid\"><img src=\"images/print.gif\" border=0 alt=\""._PRINTER."\" title=\""._PRINTER."\" width=\"16\" height=\"11\"></a>&nbsp;<a href=\"modules.php?name=News&amp;file=friend&amp;op=FriendSend&amp;sid=$sid\"><img src=\"images/friend.gif\" border=0 alt=\""._FRIEND."\" title=\""._FRIEND."\" width=\"16\" height=\"11\"></a>";

		if ($score != 0) {

			$rated = substr($score / $ratings, 0, 4);

		} else {

			$rated = 0;

		}

		if ($catid == 0) {

			$title = "<a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">$title</a>";

		} elseif ($catid != 0) {

			$row_res = $db->sql_fetchrow($db->sql_query("SELECT title from ".$prefix."_stories_cat where catid='$catid'"));

			$cat_title = $row_res['title'];

			$title = "<a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid\"><i>$cat_title</i></a>: <a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">$title</a>";

		}

		if ($multilingual == 1) {

			if ($alanguage == "") {

				$alanguage = $language;

			}

			$alt_language = ucfirst($alanguage);

			$lang_img = "<img src=\"images/language/flag-$alanguage.png\" border=\"0\" hspace=\"2\" alt=\"$alt_language\" title=\"$alt_language\">";

		} else {

			$lang_img = "<strong><big><b>&middot;</b></big></strong>";

		}

		if ($articlecomm == 0) {

			$comments = 0;

		}

		echo "<tr>"

		."<td bgcolor=\"$bgcolor1\" align=\"left\">$lang_img $title</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$comments</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$counter</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$rated</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$time[0]</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$actions</td></tr>";

	}

	echo "</table>"

	."<br><br><br><hr size=\"1\" noshade>"

	."<font class=\"content\">"._SELECTMONTH2VIEW."</font><br>";

	$result2 = $db->sql_query("SELECT time from ".$prefix."_stories order by time DESC");

	echo "<ul>";

	while($row2 = $db->sql_fetchrow($result2)) {

		$time = $row2['time'];

		ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $getdate);

		if ($getdate[2] == "01") { $month = _JANUARY; } elseif ($getdate[2] == "02") { $month = _FEBRUARY; } elseif ($getdate[2] == "03") { $month = _MARCH; } elseif ($getdate[2] == "04") { $month = _APRIL; } elseif ($getdate[2] == "05") { $month = _MAY; } elseif ($getdate[2] == "06") { $month = _JUNE; } elseif ($getdate[2] == "07") { $month = _JULY; } elseif ($getdate[2] == "08") { $month = _AUGUST; } elseif ($getdate[2] == "09") { $month = _SEPTEMBER; } elseif ($getdate[2] == "10") { $month = _OCTOBER; } elseif ($getdate[2] == "11") { $month = _NOVEMBER; } elseif ($getdate[2] == "12") { $month = _DECEMBER; }

		if ($month != $thismonth) {

			$year = $getdate[1];

			echo "<li><a href=\"modules.php?name=$module_name&amp;sa=show_month&amp;year=$year&amp;month=$getdate[2]&amp;month_l=$month\">$month, $year</a>";

			$thismonth = $month;

		}

	}

	echo "</ul><br><br><center>"

	."<form action=\"modules.php?name=Search\" method=\"post\">"

	."<input type=\"text\" name=\"query\" size=\"30\">&nbsp;"

	."<input type=\"submit\" value=\""._SEARCH."\">"

	."</form>"

	."[ <a href=\"modules.php?name=$module_name\">"._ARCHIVESINDEX."</a> | <a href=\"modules.php?name=$module_name&amp;sa=show_all\">"._SHOWALLSTORIES."</a> ]</center>";

	CloseTable();

	include("footer.php");

}



function show_all($min) {

	global $prefix, $user_prefix, $db, $bgcolor1, $bgcolor2, $user, $cookie, $sitename, $multilingual, $language, $module_name;

	if (!isset($min)) {

		$min = 0;

	}

	$max = 250;

	include("header.php");

	title(""._STORIESARCHIVE."");

	title("$sitename: "._ALLSTORIESARCH."");

	if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }

	if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }

	if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }

	OpenTable();

	echo "<table border=\"0\" width=\"100%\"><tr>"

	."<td bgcolor=\"$bgcolor2\" align=\"left\"><b>"._ARTICLES."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._COMMENTS."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._READS."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._USCORE."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._DATE."</b></td>"

	."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>"._ACTIONS."</b></td></tr>";

	$result = $db->sql_query("SELECT sid, catid, title, time, comments, counter, topic, alanguage, score, ratings from ".$prefix."_stories order by sid DESC limit $min,$max");

	$numrows = $db->sql_numrows($db->sql_query("select * from ".$prefix."_stories"));

	while($row = $db->sql_fetchrow($result)) {

		$sid = intval($row['sid']);

		$catid = intval($row['catid']);

		$title = stripslashes(check_html($row['title'], "nohtml"));

		$time = $row['time'];

		$comments = stripslashes($row['comments']);

		$counter = intval($row['counter']);

		$topic = intval($row['topic']);

		$alanguage = $row['alanguage'];

		$score = intval($row['score']);

		$ratings = intval($row['ratings']);

		$time = explode(" ", $time);

		$actions = "<a href=\"modules.php?name=News&amp;file=print&amp;sid=$sid\"><img src=\"images/print.gif\" border=0 alt=\""._PRINTER."\" title=\""._PRINTER."\" width=\"15\" height=\"11\"></a>&nbsp;<a href=\"modules.php?name=News&amp;file=friend&amp;op=FriendSend&amp;sid=$sid\"><img src=\"images/friend.gif\" border=0 alt=\""._FRIEND."\" title=\""._FRIEND."\" width=\"15\" height=\"11\"></a>";

		if ($score != 0) {

			$rated = substr($score / $ratings, 0, 4);

		} else {

			$rated = 0;

		}

		if ($catid == 0) {

			$title = "<a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">$title</a>";

		} elseif ($catid != 0) {

			$row_res = $db->sql_fetchrow($db->sql_query("SELECT title from ".$prefix."_stories_cat where catid='$catid'"));

			$cat_title = stripslashes($row_res['title']);

			$title = "<a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid\"><i>$cat_title</i></a>: <a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">$title</a>";

		}

		if ($multilingual == 1) {

			if ($alanguage == "") {

				$alanguage = $language;

			}

			$alt_language = ucfirst($alanguage);

			$lang_img = "<img src=\"images/language/flag-$alanguage.png\" border=\"0\" hspace=\"2\" alt=\"$alt_language\" title=\"$alt_language\">";

		} else {

			$lang_img = "<strong><big><b>&middot;</b></big></strong>";

		}

		echo "<tr>"

		."<td bgcolor=\"$bgcolor1\" align=\"left\">$lang_img $title</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$comments</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$counter</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$rated</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$time[0]</td>"

		."<td bgcolor=\"$bgcolor1\" align=\"center\">$actions</td></tr>";

	}

	echo "</table>"

	."<br><br><br>";

	if (($numrows > 250) AND ($min == 0)) {

		$min = $min+250;

		$a++;

		echo "<center>[ <a href=\"modules.php?name=$module_name&amp;sa=show_all&amp;min=$min\">"._NEXTPAGE."</a> ]</center><br>";

	}

	if (($numrows > 250) AND ($min >= 250) AND ($a != 1)) {

		$pmin = $min-250;

		$min = $min+250;

		$a++;

		echo "<center>[ <a href=\"modules.php?name=$module_name&amp;sa=show_all&amp;min=$pmin\">"._PREVIOUSPAGE."</a> | <a href=\"modules.php?name=$module_name&amp;sa=show_all&amp;min=$min\">"._NEXTPAGE."</a> ]</center><br>";

	}

	if (($numrows <= 250) AND ($a != 1) AND ($min != 0)) {

		$pmin = $min-250;

		echo "<center>[ <a href=\"modules.php?name=$module_name&amp;sa=show_all&amp;min=$pmin\">"._PREVIOUSPAGE."</a> ]</center><br>";

	}

	echo "<hr size=\"1\" noshade>"

	."<font class=\"content\">"._SELECTMONTH2VIEW."</font><br>";

	$result2 = $db->sql_query("SELECT time from ".$prefix."_stories order by time DESC");

	echo "<ul>";

	while($row2 = $db->sql_fetchrow($result2)) {

		$time = $row2['time'];

		ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $getdate);

		if ($getdate[2] == "01") { $month = _JANUARY; } elseif ($getdate[2] == "02") { $month = _FEBRUARY; } elseif ($getdate[2] == "03") { $month = _MARCH; } elseif ($getdate[2] == "04") { $month = _APRIL; } elseif ($getdate[2] == "05") { $month = _MAY; } elseif ($getdate[2] == "06") { $month = _JUNE; } elseif ($getdate[2] == "07") { $month = _JULY; } elseif ($getdate[2] == "08") { $month = _AUGUST; } elseif ($getdate[2] == "09") { $month = _SEPTEMBER; } elseif ($getdate[2] == "10") { $month = _OCTOBER; } elseif ($getdate[2] == "11") { $month = _NOVEMBER; } elseif ($getdate[2] == "12") { $month = _DECEMBER; }

		if ($month != $thismonth) {

			$year = $getdate[1];

			echo "<li><a href=\"modules.php?name=$module_name&amp;sa=show_month&amp;year=$year&amp;month=$getdate[2]&amp;month_l=$month\">$month, $year</a>";

			$thismonth = $month;

		}

	}

	echo "</ul><br><br><center>"

	."<form action=\"modules.php?name=Search\" method=\"post\">"

	."<input type=\"text\" name=\"query\" size=\"30\">&nbsp;"

	."<input type=\"submit\" value=\""._SEARCH."\">"

	."</form>"

	."[ <a href=\"modules.php?name=$module_name\">Stories Archive Index</a> ]</center>";

	CloseTable();

	include("footer.php");

}





switch($sa) {



	case "show_all":

	show_all($min);

	break;



	case "show_month":

	show_month($year, $month, $month_l);

	break;



	default:

	select_month();

	break;



}



?>