<?php 
# redirect.php
#

/* included files: */
require_once("include/site_constants.php");
require_once("include/standard_functions.php");
require_once("include/db_mysql.php");

/**********************************************************************************/
/********************************** Initialising **********************************/
/**********************************************************************************/

/* Create database object */
$db = new DB_Spencer_Class(array(PRIMARY_DB_HOST, PRIMARY_DB_USER, PRIMARY_DB_PASSWORD, PRIMARY_DB_DATABASE, 0, 0));
$db->query("SET NAMES 'utf8'");

$error_occured = false;
$redirect_url = "";

/* Get standard "GET" variables */
if (!$redirect_type = @mysql_real_escape_string($_GET['redirect_type'])) {
	$error_occured = true;
}
if (!$redirect_id = (INT) @mysql_real_escape_string($_GET['redirect_id'])) {
	$error_occured = true;
}


if(!$error_occured) {
	switch ($redirect_type) {
		case 'banner':

			$sql_banner = "Select banner_link_url From tbl_banner Where banner_link_url != '' AND banner_id='" . $redirect_id . "'";

			$db->query($sql_banner, "banner");

			if($db->db_num_rows("banner") == 1) {
				$array_banner_info = $db->row("banner");

				$redirect_url = $array_banner_info["banner_link_url"];

				$sql_update_banner = "Update tbl_banner Set banner_hits=banner_hits+1 Where banner_id='" . $redirect_id . "'";

				//$db->query($sql_update_banner);
			} else {
				$error_occured = true;
			}

			break;


		case 'link' :
			$sql_link = "Select link_url From tbl_links Where link_url != '' AND link_id='" . $redirect_id . "'";

			$db->query($sql_link, "link");

			if($db->db_num_rows("link") == 1) {
				$array_link_info = $db->row("link");

				$redirect_url = $array_link_info["link_url"];

				$sql_update_link = "Update tbl_links Set link_hits=link_hits+1 Where link_id='" . $redirect_id . "'";

				//$db->query($sql_update_link);
			} else {
				$error_occured = true;
			}

			break;


		case 'trip_report' :
			if (!$trip_report_version = @$_GET['trip_report_version']) { $trip_report_version = 'html';}

			$sql_link = "Select report_directory, report_url_" . $trip_report_version . " As report_url From tbl_trip_reports Where report_id='" . $redirect_id . "'";

			$db->query($sql_link, "link");

			if($db->db_num_rows("link") == 1) {
				$array_link_info = $db->row("link");

				$redirect_url = $array_link_info["report_directory"] . $array_link_info["report_url"];

				$sql_update_link = "Update tbl_trip_reports Set report_hits=report_hits+1 Where report_id='" . $redirect_id . "'";

				//$db->query($sql_update_link);
			} else {
				$error_occured = true;
			}

			break;
	} // End switch
} // End if(!$error_occured)


/******************************************************************************************/
/***************************************** REDIRECT ****************************************/
/******************************************************************************************/
	$db->db_close();

if(!$error_occured) {
	header("Location: " . $redirect_url);
	exit;
}

?>