"; include("news/archive/path.php3"); include("$absolutepath/includes/connect.php3"); include("$absolutepath/includes/class.FastTemplate.php3"); include("$absolutepath/includes/printnewsitem.php3"); include("$absolutepath/includes/striphtml.php3"); if($cat != "") { $catquery = "select category from categories where autonumber = '$cat'"; $catresult = mysql_query($catquery); $category = mysql_result($catresult,0,"category"); $where = "WHERE category = '$category'"; echo "

Only displaying ".$category." related news. Click here to display all news.

"; } if($skip != "" && $skip > 0) { $limit = $skip . "," . $itemsshown; $recentlink = "<< Recent news |"; } else { $skip = "0"; $limit = $itemsshown; } $recentskip = $skip; $skip = $skip + $itemsshown; $newsquery = "SELECT * FROM news $where ORDER BY date DESC LIMIT $limit"; $newsresult = mysql_query($newsquery); $number = mysql_num_rows($newsresult); $date = mysql_result($newsresult,$i,"date"); $datequery="select DATE_FORMAT('$date','%b.%e.%Y') as dateme"; $dateresult = MYSQL_QUERY($datequery); $dateformat = mysql_result($dateresult,0,"dateme"); $date2 = mysql_result($newsresult,$g,"date"); $datequery2 ="select DATE_FORMAT('$date','%l:%i %p') as dateme"; $dateresult2 = MYSQL_QUERY($datequery2); $dateformat2 = mysql_result($dateresult2,0,"dateme"); for ($i = 0; $i < $number; $i++) { $updater = stripslashes(mysql_result($newsresult,$i,"news_updater")); $followup = stripslashes(mysql_result($newsresult,$i,"followup")); $news_subject = stripslashes(mysql_result($newsresult,$i,"news_subject")); $news_item = stripslashes(mysql_result($newsresult,$i,"news_item")); $news_item = str_replace("style=\"color: #E7DFE1;\"","style=\"color: #003366;\"",$news_item); $date = mysql_result($newsresult,$i,"date"); $datequery="select DATE_FORMAT('$date','%b.%e.%Y') as dateme"; $dateresult = MYSQL_QUERY($datequery); $dateformat = mysql_result($dateresult,0,"dateme"); $date2 = mysql_result($newsresult,$i,"date"); $datequery2="select DATE_FORMAT('$date','%l:%i %p') as dateme"; $dateresult2 = MYSQL_QUERY($datequery2); $dateformat2 = mysql_result($dateresult2,0,"dateme"); $category = mysql_result($newsresult,$i,"category"); $thread_id = mysql_result($newsresult,$i,"thread_id"); $newsupdateautonumber = stripslashes(mysql_result($newsresult,$i,"autonumber")); $autonumber = $newsupdateautonumber; printnewsitem($updater,$news_subject,$news_item,$dateformat,$dateformat2,$followup,$autonumber,1,$category,$thread_id); } if($number == "15") { echo "

".$recentlink." Older news >>

"; } } else { echo "