= ".$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----------------------------------------------*/ ?>

Local Events Guide

".$item['e_title'].""; echo "

Posted by ".$item['e_name'].". Event Ref: ".$item['e_ref']."
"; echo "Starts at ".date("g:ia \o\\n l jS F Y", $item['e_startstamp'])."
"; echo "Ends at ".date("g:ia \o\\n l jS F Y", $item['e_endstamp'])."

"; echo "

"; if (!empty($item['e_pic_data'])) echo "\"".$item['e_title']."\""; echo nl2br($item['e_description']); echo "

"; echo "

Back to events guide

"; } elseif (isset($events)) { if ($event = DB_get_array($events)) { echo "
    "; do { echo "
  • ".$event['e_title']."
    Posted by ".$event['e_name'].", starts at ".date("g:ia \o\\n l jS F Y", $event['e_startstamp'])."
     
  • "; } while ($event = DB_get_array($events)); echo "
"; /* ------- Page Buttons ------- */ $newerPage = $currentPage - 1; $olderPage = $currentPage + 1; 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 "

Post an event

"; } LIB_contentTableBottom(); ?>