<?php


$conn=mysql_connect('YDAWBH119', 'promic_kms_user', '49Iodd&3kd)3sWq!p');
mysql_select_db('promic_kms');

$url = $_SERVER['HTTP_X_ORIGINAL_URL'];

//$url = str_replace('brochure/','',$url);
//$url = substr($url, 1);

if($_SERVER['REMOTE_ADDR'] != '84.246.3.230') {
	$datum_in = date("Y-m-d");
	$tijd_in = date("H:i:s");


	function checkInput($variable)
	{
		$variable = htmlentities(addslashes(trim($variable)));
		$variable = mysql_real_escape_string($variable);
		return $variable;
	}


	$q_account = sprintf("INSERT INTO kms_qr_stats (name, date, timestamp) VALUES ('%s', '%s', '%s')", checkInput($url), $datum_in, $tijd_in);
	$r_account = mysql_query($q_account);
}



if($url =="/brochure/pop-ups/magnetic-options"){
    $yurl = "https://www.youtube.com/embed/GyZRehRtrWs?rel=0&autoplay=1&start=120&end=140";
    header ('HTTP/1.1 301 Moved Permanently');
    header("Location: ".$yurl);
    exit;
}

if($url =="/brochure/lighting/wall-light-options"){
    $yurl = "/";
    header ('HTTP/1.1 301 Moved Permanently');
    header("Location: ".$yurl);
    exit;
}

$url .= ".php";

/*

$link_array = array(
    'pop-ups/magnetic' => 'GyZRehRtrWs',
    'pop-ups/fabric' => 'EZz32bG7THk',
    'pop-ups/fabric-premium-straight' => 'hCgisTo4ra0',
    'pop-ups/fabric-premium-curved' => 'knLhgeduTSY',
    'zipper-walls/curved' => '2OzfMjYbHlc',
    'zipper-walls/straight' => 'j16-lUb6Ois',
    'zipper-walls/arch' => 't3hwVzZIuH0',
    'roll-banners/budget' => '7At6QTcB5Nc',
    'roll-banners/next' => 'equKLk0VyJE',
    'roll-banners/plus' => 'OfFtz2qupLM',
    'roll-banners/basic' => 'AFspXDOeyms',
    'roll-banners/traingle' => 'GIpI-NCL6vQ',
    'roll-banners/evolution' => '7GkwpuWcioc',
    'roll-banners/massive' => 'y8Ui1_eip7s',
    'roll-banners/premium' => 'JcO7aCPteEQ',
    'roll-banners/deluxe' => 'YumJhcxyxJY',
    'roll-banners/twin' => 'P5rnaBTybGs',
    'roll-banners/double' => 'x5GrGP8_r14',
    'roll-banners/extreme' => 'sYG5kR0Peqo',
    'roll-banners/mini' => 'mQHxJkslZug',
    'l-x-banners/quick' => '0kZIxQ00ZY8',
    'l-x-banners/telescopic' => 'tkkBZC8wD0I',
    'l-x-banners/budget' => 'rxaAq4CF8Sc',
    'l-x-banners/premium' => 'HgkSlJ5kpSY',
    'lighting/bannerlight-35-watt' => 'XJHqMj5xgCs',
    'lighting/bannerlight-50-watt' => 'apVAKMTJYwI',
    'lighting/banner-led' => 'GX1KPc-F-8I',
    'lighting/wall-led-50' => '9RQUgehPG7E',
    'counters/promotional' => '1595-mjaL1Q',
    'counters/professional' => 'GVwhNZbw0Hw',
    'counters/fabric' => 'JzCSvV7-MrY',
    'brochure-holders/magnetic' => 'u_NSbcRcm3o',
    'brochure-holders/budget' => 'XhjcLKWFdOU',
    'brochure-holders/easy' => '0RuZrkzeX0k',
    'brochure-holders/zigzag' => 'LBzXIqfPOrg',
    'brochure-holders/deluxe' => 'p7uK5XXsHJg',
    'brochure-holders/posterstand' => 'zMj3dRYxDHw',
    'specials/panelbase-aluminium' => 'E855t1z2rKM',
    'specials/light-tower' => 'bxrwzeWis5A',
    'outdoor/streetboard' => 'YksuOOR56LQ',
    'outdoor/banner' => '3X10NFYB99s',
    'flags/alu-wind' => 'bfZWbnaHXt4',
    'flags/alu-drop' => '6z3JjGrahg4',
    'flags/alu-square' => 'UD9tnPrbGdU',
    'flags/fibre-wind-drop' => 'bwffxN6KseA',
    'flag/flagpole-415' => '3BMMgjcAhj0',
    'flag/flagpole-540' => 'h4h4QigzhWMU',
    'lighting/wall-led-116' => 'yEMFxhJoESs',
    'lighting/wall-light-150' => 'x-rcji5AVQY',
    'flags/flagpole-415' => '3BMMgjcAhj0',
    'flags/flagpole-540' => '4h4QigzhWMU',
    'flags/ground-drill' => 'uY66U0gmc2Q',
    'flags/ground-pin' => 'Q2OdQ1bBA8o',
    'flags/cross-base' => 'r0MVgy-Jw7c',
    'flags/car-foot' => 'xY6qpVIUD2I',
    'flags/steelplate-6' => 'gc13xUvTPco',
    'flags/steelplate-12' => 'gc13xUvTPco',
    'flags/watertank' => '-D-_BCLo0wM',
    'roll-banners/triangle' => 'GIpI-NCL6vQ',
    'flags/fiber-wind-drop' => 'bwffxN6KseA',
    'cases/hardcase' => 'hy_AaNM4eWk',
    'cases/trolleycase' => 'KMxALi9_8mA',
    'cases/soft-trolley' => '-ngvqDAIalc',
    'cases/transporttrolley' => 'mQ2WGBBq0gE',
    'cases/transport-trolley' => 'mQ2WGBBq0gE'
);

if(!isset($link_array[$url])){
    header ('HTTP/1.1 301 Moved Permanently');
    header("Location: /");
    exit;
}


$yurl = "https://www.youtube.com/embed/".$link_array[$url]."?rel=0&autoplay=1";

*/
if (file_exists($url)) {
	header ('HTTP/1.1 301 Moved Permanently');
	header("Location: ". $url);
} else {
	echo "The file $filename does not exist";
}


exit;