require_once("in/func.php"); require_once("in/au/authClass.php"); $auth = new Authenticate(); $URI = explode("/",$_SERVER['REQUEST_URI']); $action = $URI[2]; if(!$action) $action = 'view'; $link_id = $URI[3]; if($action == 'go-to') { if(!$link_id) { redirect("/links/view"); } else { $q = "SELECT * FROM link WHERE id = '$link_id' LIMIT 1"; $q = validateQuery($q); $DB->base_Query($q); $row = $DB->base_Fetch_Array(); extract($row); $strikes = ($strikes) ? ($strikes + 1) : 1; $q = "UPDATE link SET strikes = '$strikes' WHERE id = '$link_id' LIMIT 1"; $q = validateQuery($q); $DB->base_Query($q); redirect(db_clean($url)); exit; } } elseif($action == 'view') { $q = "SELECT distinct lg.name, lg.id FROM link_group lg, link l WHERE l.link_group_id = lg.id AND l.active = '1'"; $q = validateQuery($q); $DB->base_Query($q); $LINKS = array(); while( $row = $DB->base_Fetch_Array() ) { array_push( $LINKS, $row ); } } commonHeader("Fly Fishing Links, Tips, and Resources",1); ?>
| leftNav($auth->isLoggedIn()); ?> |
|
||||||