= ".$timeNow." OR e_endstamp >= ".$timeNow.")"; $sql .=" ORDER BY e_startstamp"; if ($rows != FALSE) $sql .=" LIMIT"; if ($offset != FALSE) $sql .= " ".$offset.","; if ($rows != FALSE) $sql .= " ".$rows; return DB_query($sql); } if (isset($item)) unset($item); $timeNow = LIB_UTILS_universal_time(); // Work out page stuff if (!isset($page)) $page = 1; if ($page < 1) $page = 1; $currentPage = $page; $entriesPerPage = 20; $countTotalEntries = DB_num_rows(getAllEvents($timeNow)); $countTotalPages = ceil($countTotalEntries / $entriesPerPage); $currentPageOffset = $entriesPerPage * ($currentPage - 1); if (isset($PATH_INFO)) { $url_array = explode("/", $PATH_INFO); if (isset($url_array[1])) { $url_ref = urldecode($url_array[1]); $sql = "SELECT * FROM br_event WHERE e_ref = ".$url_ref." AND e_active = 1"; $result = DB_query($sql); if (DB_is_one_row($result)) { $item = DB_get_array($result); $title = $item['e_title']; } else { $title = "Event not found"; } } else { $title = "URL Error"; $events = getAllEvents($timeNow, $entriesPerPage); } } else { $title = "Events Guide"; $events = getAllEvents($timeNow, $entriesPerPage, $currentPageOffset); } /* -------------------------------------------------------------------------------------------------- */ $metadata = array ( "title" => 'Brocton Online - '.$title, "keywords" => '', "description" => '', "author" => 'Dan Durrans (dan@durrans.com)' ); require(BR_DOCROOT.'_includes/header.php'); /*--------------------------------------Page Begins Here----------------------------------------------*/ ?>
|
".$item['e_title']."";
echo " Posted by ".$item['e_name'].". Event Ref: ".$item['e_ref']." ";
if (!empty($item['e_pic_data'])) echo "
";
if ($currentPage > 1) {
echo "Newest";
echo " ~ ";
echo "Newer";
} else {
echo "Newest";
echo " ~ ";
echo "Newer";
}
echo " ~ ";
if ($currentPage < $countTotalPages) {
echo "Older";
echo " ~ ";
echo "Oldest";
} else {
echo "Older";
echo " ~ ";
echo "Oldest";
}
echo " ";
} elseif ((DB_num_rows($events) < 1) && ($countTotalEntries > 0)) {
echo "You have tried to get to a page that doesn't exist. "; echo "Please click here to go back to the start of the events guide "; } else { echo "It looks like no one has added any events to the website. Prehaps you could be the first! "; } echo ""; } LIB_contentTableBottom(); ?> |