<?php
include 'config/settings.inc.php';
$psConn = new mysqli(_DB_SERVER_, _DB_USER_, _DB_PASSWD_, _DB_NAME_) or die("Database connection error.");
$adminConn = new mysqli('localhost', 'med_admin', 'r#d^f[MI]6Xk', 'med_admin') or die("Database connection error.");

if(is_numeric($_GET['productID'])){
	$pid = intval($_GET['productID']);
	$result = $adminConn->query("SELECT sku FROM urls WHERE id = $pid LIMIT 1");
	if($result && ($sku = $result->fetch_array(MYSQLI_ASSOC)) && isset($sku['sku'])){
		$sku = $sku['sku'];
		$result = $psConn->query('SELECT id_product FROM '._DB_PREFIX_.'product WHERE reference = "' . $sku . '" LIMIT 1');
		if($result && ($prod = $result->fetch_array(MYSQLI_ASSOC)) && isset($prod['id_product'])){
			header("HTTP/1.1 301 Moved Permanently");
			header("Location: http://www.medsourceusa.com/redirect/" . $prod['id_product'] . "-redirect");
			exit();
		}else exit('3');
	}else exit('2');
}else exit('1');

header("Location: /");