<?php
/*
+ ----------------------------------------------------------------------------+
      e107 website system News Archive Page
|     By: Bryan "d3bruts1d" McDaniel (http://www.d3bruts1d.com)
|
|     ---------------------------------------------
|     e107:
|     ŠSteve Dunstan 2001-2002
|     http://e107.org
|     jalist@e107.org
|
|     Released under the terms and conditions of the
|     GNU General Public License (http://gnu.org).
|     ---------------------------------------------
|
|     
|     $Revision: 2.0
|     $Date: 2007/05/03 6:56:33 EST
|     $Author: d3bruts1d
|     $Note: As of v2.0 all archive variations have been combined together.
+----------------------------------------------------------------------------+
*/


require_once("class2.php");
require_once(e_HANDLER."news_class.php");
require_once(HEADERF);

//---------------------------------------------------------------------------------------------------------------------\\

//-----------------------------------------------------------------------------------------------------
// User Settings For News Archive
//-----------------------------------------------------------------------------------------------------
		// Number of news items to show per archive page. Default = 50 items.
		// Not recommended to put this value above 100. 
		$limitno		= "50"; 
		
		// TRUE or FALSE to enable ability to display news archive per category.	
		$enablecat		= TRUE;		
		
		// Configuration Item to change the way the News Archive is rendered
		// A = Plain Old News Archive. Simply Displays a list of all items.
		// B = Similar to A - Provides a separator between months. Based on svartis' feedback.
		// C = Similar to A - Provides News + posted info on same line. Based on AndyP's feedback.
		// D = Combine B & C and this is what you get. Based on AndyP's feedback
		$archversion	= "B";
		
		// Configuration Item to change the way the Next / Previous section is rendered
		// A = Displays each page number and links... 1, 2, 3, 4, 5, ....
		// B = Displays a dropdown box with values for each page.
		$npversion		= "B";
//-----------------------------------------------------------------------------------------------------

$nobody_regexp = "'(^|,)(".str_replace(",", "|", e_UC_NOBODY).")(,|$)'";

	//----------------------------------------------------------------
	// This section used to find page # and news category from URL
	//----------------------------------------------------------------
	if(e_QUERY){
			$tmp 			= explode(".", e_QUERY);
			$action 		= $tmp[0];
			$sub_action 	= $tmp[1];
			$action2 		= $tmp[2];
			$sub_action2 	= $tmp[3];
	}
	
	
	if($action === "cat"){
		$dog	= intval($sub_action);
		$catdog	= ".cat.".$dog;	
	} elseif ($action2 === "cat"){
		$dog	= intval($sub_action2);
		$catdog	= ".cat.".$dog;
	} else {
		$dog	= NULL;
	}
	
	if($action === "page"){
		$pageno		= intval($sub_action);
	} elseif ($action2 === "page"){
		$pageno		= intval($sub_action2);
	} else {
		$pageno		= 1;
	}
	

	
	//----------------------------------------------------------------

$limitst	=  $limitno * $pageno;  //   2 x 50 = 100 ||  3 x 50 = 150
$limitst	=  $limitst - $limitno; // 100 - 50 = 50 || 150 - 50 = 100

$nav		= '';


// Get the name of the news category
if ($enablecat === TRUE && !is_null($dog) && $dog != 0)	{
	$gen = new convert;
	$sql->db_Select("news_category", "category_name", "category_id='".$dog."'");
	$dogname = $sql->db_Fetch();
}

// Total number of news items in database.
if($enablecat === TRUE && !is_null($dog)){
	$news_total = $sql -> db_Count("news", "(*)", "WHERE news_class REGEXP '".e_CLASS_REGEXP."' AND NOT (news_class REGEXP ".$nobody_regexp.") AND news_start < ".time()." AND (news_end=0 || news_end>".time().") AND news_category='".$dog."'" );
} else {
	$news_total = $sql -> db_Count("news", "(*)", "WHERE news_class REGEXP '".e_CLASS_REGEXP."' AND NOT (news_class REGEXP ".$nobody_regexp.") AND news_start < ".time()." AND (news_end=0 || news_end>".time().")");
}

$page_total = ceil($news_total / $limitno);    	// Divides the total number of news items by our limit and rounds the number
												// UP (3.11 = 4 or 5.99 = 6) to give us how many total pages will be needed. 
//---------------------------------------------------------------------------------------------------------------------\\

$lnx_sql = new db;
if($enablecat === TRUE && !is_null($dog)){
	$lnx_sql -> db_Select("news","news_id,news_title,news_datestamp,news_category", "WHERE news_class REGEXP '".e_CLASS_REGEXP."' AND NOT (news_class REGEXP ".$nobody_regexp.") AND news_start < ".time()." AND (news_end=0 || news_end>".time().") AND news_category='".$dog."' ORDER BY news_datestamp DESC LIMIT $limitst,$limitno","none");
} else {
	$lnx_sql -> db_Select("news","news_id,news_title,news_datestamp", "WHERE news_class REGEXP '".e_CLASS_REGEXP."' AND NOT (news_class REGEXP ".$nobody_regexp.") AND news_start < ".time()." AND (news_end=0 || news_end>".time().") ORDER BY news_datestamp DESC LIMIT $limitst,$limitno","none");
}

if($archversion === "A"){
	// Start Version A
	while (list($news_id, $news_title, $news_datestamp,) = $lnx_sql -> db_Fetch())
	{
		$gen = new convert;
		$news_datestamp = $gen->convert_date($news_datestamp, "long");
		
		$arctext .="
		<img src=\"".THEME."images/bullet2.gif\" alt=\"bullet\" />
		<a href=\"".e_BASE."news.php?item.".$news_id."\" style=\"font-weight:bold;\">".$news_title."</a>
		<div class=\"smalltext\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Posted: ".$news_datestamp."</div>";
	}
	// End Version A
} elseif($archversion === "B"){
	// Start Version B
	while (list($news_id, $news_title, $news_datestamp,) = $lnx_sql -> db_Fetch())
	{
		$monthyear			= date("F-Y", $news_datestamp);
		$monthyear_header	= date("F Y", $news_datestamp);
		
			if(isset($lastmonyear)){
				if($lastmonyear == $monthyear){
						$spacer = "";
					} else {
						$spacer = "<br /><span style=\"font-weight:bold;\">".$monthyear_header."</span><br />";
					} // End if
			} else {
				$spacer = "<span style=\"font-weight:bold;\">".$monthyear_header."</span><BR />";
			} // End if
		
		$gen = new convert;
		$news_datestamp = $gen->convert_date($news_datestamp, "long");
		
		$arctext .= $spacer."
			<img src='".THEME."images/bullet2.gif' alt='bullet' />
			<a href=\"".e_BASE."news.php?item.".$news_id."\" style=\"font-weight:bold;\">".$news_title."</a>
			<div class='smalltext'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Posted: ".$news_datestamp."</div>";
		
		$lastmonyear	= $monthyear;
	} 
	// End Version B
} elseif($archversion === "C"){
	// Start Version C
	$arctext	= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
		<tr>
			<td colspan=\"2\" style=\"font-weight:bold;\">News Article</a></td>
			<td style=\"font-weight:bold;\">Posted</td>
		</tr>";
		
	while (list($news_id, $news_title, $news_datestamp,) = $lnx_sql -> db_Fetch())
	{
		$gen = new convert;
		$news_datestamp = $gen->convert_date($news_datestamp, "long");
		
		$arctext .="
			<tr>
				<td width=\"15\"><img src='".THEME."images/bullet2.gif' alt='bullet' /></td>
				<td><a href=\"".e_BASE."news.php?item.".$news_id."\" style=\"font-weight:bold;\">".$news_title."</a></td>
				<td><div class='smalltext'>".$news_datestamp."</div></td>
			</tr>";
	}
	
	$arctext .="</table>";
	//End Version C
} elseif($archversion === "D"){
	//Start Version D
	$arctext	= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
	
	while (list($news_id, $news_title, $news_datestamp,) = $lnx_sql -> db_Fetch())
	{
		$monthyear			= date("F-Y", $news_datestamp);
		$monthyear_header	= date("F Y", $news_datestamp);
		
			if(isset($lastmonyear)){
				if($lastmonyear == $monthyear){
						$spacer = "";
					} else {
						$spacer = "
								<tr>
									<td colspan=\"3\">&nbsp;</td>
								</tr>
								<tr>
									<td colspan=\"3\">&nbsp;</td>
								</tr>
								<tr>
									<td colspan=\"3\" style=\"text-align:center; font-weight:bold; text-decoration:underline\">".$monthyear_header."</td>
								</tr>
								<tr>
									<td colspan=\"2\" class=\"smalltext\" style=\"font-weight:bold;\">News Article</a></td>
									<td class=\"smalltext\" style=\"font-weight:bold;\">Posted</td>
								</tr>";
					} // End if
			} else {
				$spacer = "
							<tr>
								<td colspan=\"3\" style=\"text-align:center; font-weight:bold; text-decoration:underline\">".$monthyear_header."</td>
							</tr> 
							<tr>
								<td colspan=\"2\" style=\"font-weight:bold;\">News Article</a></td>
								<td style=\"font-weight:bold;\">Posted</td>
							</tr>";
			} // End if
		
		$gen = new convert;
		$news_datestamp = $gen->convert_date($news_datestamp, "long");
		
		$arctext .= $spacer."
			<tr>
				<td width=\"15\"><img src='".THEME."images/bullet2.gif' alt='bullet' /></td>
				<td><a href=\"".e_BASE."news.php?item.".$news_id."\" style=\"font-weight:bold;\">".$news_title."</a></td>
				<td><div class='smalltext'>".$news_datestamp."</div></td>
			</tr>";
		
		$lastmonyear	= $monthyear;
	
	} // End While
	
	$arctext .="</table>";
	//End Version D
} else {
	die("Error in News Archive configuration. Please contact an administrator.");
}

$archtot	.="<span style=\"font-weight:bold;\">Total number of news items:</span> ".$news_total."<br /><br />";

// Creates the "News Archive" table	
if($enablecat === TRUE && !is_null($dog)){
	$ns -> tablerender("News Archive (Category: ".$dogname['0'].")", "".$archtot."".$arctext.""); 
} else {
	$ns -> tablerender("News Archive", "".$archtot."".$arctext."");
}

//---------------------------------------------------------------------------------------------------------------------\\

if($npversion === "A"){
	// Start Version A
	
	for($page = 1; $page <= $page_total; $page++)
	{
	   if ($page == $pageno)
	   {
		  $nav .= " [<u>$page</u>] "; // Current page. No need to link to it.
	   }
	   else
	   {
		  $nav .= " <a href=\"".e_BASE."?page.".$page.$catdog."\" title=\"Page ".$page."\">".$page."</a> ";
	   } 
	}
	
	$completenav	= "<div class=\"smalltext\" align=\"right\">Go to page".$nav."</div>";
	
	// End Version A
} elseif($npversion === "B"){
	// Start Version B
	
	$pagenopo	= $pageno+1;
	$pagenomo	= $pageno-1;
	
	$nav	= "<div class=\"nextprev\">Go to page&nbsp;&nbsp;&nbsp;";
	
	if($pageno >> 1){
		$nav .= "<a class=\"tbox npbutton\" style=\"text-decoration:none\" href=\"".e_BASE."?page.".$pagenomo.$catdog."\">&nbsp;&nbsp;&lt;&lt;&nbsp;&nbsp;</a>&nbsp;&nbsp;";
	}
	
	$nav	.= "<select class=\"tbox npdropdown\" name=\"pageSelect\" onchange=\"location.href=this.options[selectedIndex].value\">";
	
	for($page = 1; $page <= $page_total; $page++)
	{
	   if ($page == $pageno)
	   {
	   		$nav .= "<option value=\"".e_BASE."?page.".$page.$catdog."\" selected=\"selected\">".$page."</option>";
	   }
	   else
	   {
			$nav .= "<option value=\"".e_BASE."?page.".$page.$catdog."\">".$page."</option>";
	   } 
	}

	$nav	.= "</select>&nbsp;&nbsp;";
	
	if($pageno === 1){
		$nav .= "<a class=\"tbox npbutton\" style=\"text-decoration:none\" href=\"".e_BASE."?page.2".$catdog."\">&nbsp;&nbsp;&gt;&gt;&nbsp;&nbsp;</a>";
	} elseif($pageno != 1 && $pageno != $page_total){
		$nav .= "<a class=\"tbox npbutton\" style=\"text-decoration:none\" href=\"".e_BASE."?page.".$pagenopo.$catdog."\">&nbsp;&nbsp;&gt;&gt;&nbsp;&nbsp;</a>";
	}


	$nav .= "</div>";
	
	$completenav	=  $nav;
	
	// End Version B
} else {
	die("An error occured while generating the news archive. Please contact an administrator.");
}


$ns -> tablerender("More News", $completenav); // Creates the "Go To Page" table


//---------------------------------------------------------------------------------------------------------------------\\


require_once(FOOTERF);
?>