Miscellany

<?$limit		= (int)$_REQUEST['limit'];$subpage		= (int)$_REQUEST['subpage'];	if((!$limit)  || (is_numeric($limit) == false) || ($limit < 5) || ($limit > 50)) {     $limit = 7; //default } if((!$subpage) || (is_numeric($subpage) == false) || ($subpage < 0) || ($subpage > $total_items)) {      $subpage = 1; //default } $p = '';if(isset($_REQUEST['year'])) {	$query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC";	$rs = $db->GetAll($query) or die("Error in query:  " . $query . $db->ErrorMsg());		if(count($rs) == 0) {		// paranoid		$p .= '<p>We are sorry but we found no news items that you requested.</p>';	} else {		// count($rs) > 0		$total_items = count($rs);     	$total_pages 	= ceil($total_items / $limit);		$set_limit 		= ((int)$subpage * (int)$limit) - (int)$limit;				$p .= '<div id="news">'."\r\n";		$p .= '		<div id="newsLatest">'."\r\n";		$p .= '			<h1>News Archive</h1>'."\r\n";		$p .= '		</div> '."\r\n";        $p .= '		<div id="search_return">'."\r\n";		$p .= '			<p>'.$set_limit.'There are <span>' . $total_items . '</span> news item(s) matching your criteria.</p>'."\r\n";		$p .= '		</div>'."\r\n";		$p .= ' 	<div class="basic" id="newsItem">'."\r\n";		if((isset($set_limit)) && (isset($limit)) && ($set_limit > 0)) {			$query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC LIMIT $set_limit, $limit";			} else {			$query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC LIMIT 0, $limit";			}		$newrs = $db->GetAll($query) or die("Error in query:  " . $query . $db->ErrorMsg());				for($x = 0; $x < count($newrs); $x++) {			$month = array('01'=>'January','02'=>'Febuary','03'=>'March','04'=>'April','05'=>'May','06'=>'June','07'=>'July','08'=>'August','09'=>'September','10'=>'October','11'=>'November','12'=>'December');            			$date = explode(" ", $newrs[$x]['date']); $date = explode("-", $date['0']); $i = $date['1'];  $month = substr($month[$i], 0, 3);			$y .= ' 	<a>' . $month . ' ' . $date['0'] . '<span>'. $newrs[$x]['title'] .'</span><span class="right">view more...</span></a>'."\r\n";			$y .= ' 	<div class="newsFeed">'."\r\n";			$news = explode("\r\n", $newrs[$x]['news']);						for($i = 0; $i < count($news); $i++) {				if(empty($news[$i])) {					$y .= '';				} else {					$y .= '		<p>'.$news[$i].'</p>'."\r\n";				}			}			$y .= ' 		<div class="newsImages">'."\r\n";			if($newrs[$x]['img'] != NULL) { $y .= ' 			<img src="./image.php?path=' . $newrs[$x]['img'] . '&amp;resize=true&amp;type=height&amp;value=135"  alt="' . $newrs[$x]['imgText'] . '" class="lightbox" />'."\r\n"; }			if($newrs[$x]['img2'] != NULL) { $y .= ' 			<img src="./image.php?path=' . $newrs[$x]['img2'] . '&amp;resize=true&amp;type=height&amp;value=135"  alt="' . $newrs[$x]['img2Text'] . '" class="lightbox" />'."\r\n"; }			$y .= '			</div>'."\r\n";			$y .= ' 	</div>'."\r\n";		  				}		$p .= $y;		$p .= '		</div>'."\r\n";		$p .= '	</div>'."\r\n";		// show page links		if(count($rs) > $limit) {		$p .= '<div id="pagination">'."\r\n";		$prev_page = $subpage - 1;		if($prev_page >= 1) { 			  $p .= '<span><<</span> <a href="./?page='.$_REQUEST['page'].'&amp;year='.$_REQUEST['year'].'&amp;subpage='.$prev_page.'"><span>Prev.</span></a>'."\r\n"; 			} 				for($a = 1; $a <= $total_pages; $a++) {			   if($a == $page) {				 	$p .= '<span>'.$a.'</span>&nbsp;|&nbsp;'; //no link				 } else {				 	$p .= '<a href="./?page='.$_REQUEST['page'].'&amp;year='.$_REQUEST['year'].'&amp;subpage='.$a.'">'.$a.'</a>&nbsp;|&nbsp;';				 } 			} 				$next_page = $page + 1;				if($next_page <= $total_pages) {			  $p .= '<a href="./?page='.$_REQUEST['page'].'&amp;year='.$_REQUEST['year'].'&amp;subpage='.$next_page.'"><span>Next</span></a> <span>>></span>'."\r\n";			}		$p .= '</div>'."\r\n";		}		// show pages		/*$p .= '<div class="pages">'."\r\n";		$p .= '	<p>Page <span>' . $current_page . '</span> of ' . $total_pages . '</p>'."\r\n";		$pge = 1;		$next=0;		while ($pge <= $total_pages and $total_pages > 1)			{			$link = '<a href="?page=news&amp;year='.$_GET['year'].'&amp;from_news=' . $next . '">' . $pge . '</a>';			if ($pge < $total_pages)				{				$link .= '&nbsp;|&nbsp;';				}			$p .= $link;			$pge++;			$next += ($limit);			}*/						echo $p; 		}	} else {	$query = "SELECT * FROM news n, user u WHERE n.uID = u.uID ORDER BY n.nID DESC LIMIT 0, 7";	$rs = $db->GetAll($query) or die("Error in query:  " . $query . $db->ErrorMsg());		?>	<div id="news">		<div id="newsLatest">			<h1>Latest News</h1>		</div> 		<div class="basic" id="newsItem">		<?		$month = array('01'=>'January','02'=>'Febuary','03'=>'March','04'=>'April','05'=>'May','06'=>'June','07'=>'July','08'=>'August','09'=>'September','10'=>'October','11'=>'November','12'=>'December');				for($x = 0;$x <= count($rs) - 1; $x++) {		?>			<a><? $date = explode(" ", $rs[$x]['date']); $date = explode("-", $date['0']); $i = $date['1']; echo substr($month[$i], 0, 3) .' '.$date['0'];?><span> <?=$rs[$x]['title'];?></span><span class="right">view more...</span></a>			<div class="newsFeed">				<?				$news = explode("\r\n", $rs[$x]['news']);				$p = '';				for($i = 0; $i < count($news); $i++) {					if(empty($news[$i])) {						$p .= '';					} else {						$p .= '<p>'.$news[$i].'</p>'."\r\n";						}					}				echo $p;				?>				<div class="newsImages">				<?				if($rs[$x]['img'] != NULL) { echo '<img src="./image.php?path=' . $rs[$x]['img'] . '&amp;resize=true&amp;type=height&amp;value=135"  alt="' . $rs[$x]['imgText'] . '" class="lightbox" />'."\r\n"; }				if($rs[$x]['img2'] != NULL) { echo '<img src="./image.php?path=' . $rs[$x]['img2'] . '&amp;resize=true&amp;type=height&amp;value=135"  alt="' . $rs[$x]['img2Text'] . '" class="lightbox" />'."\r\n"; }				 ?>				 </div>			</div>		<?		}		?>		</div>	</div><?	}?>