");
//echo("manhattan web site: ".$_SERVER['QUERY_STRING']. "
");
$_GET['url'] = str_replace('url=','',$_SERVER['QUERY_STRING']);
//echo("manhattan web site: ".$_GET['url']. "
");
//die();
//
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
if (is_bot(urldecode($_SERVER['HTTP_USER_AGENT'])) == 1)
{
die('');
};
$dummy = 0;
$redirect_url = "";
$only_by_location = "true";
$ip_not_found = "false";
$search_for_barcode = "false";
$old_search_string = "false";
// Check if Barcode Search was called
$posw = strpos($_GET['url'],"barcode/");
if ($posw !== false)
{
$search_for_barcode = "true";
//echo "yes";
}
else
{
// Do nothing
}
// Check if old search was called
$posw = strpos($_GET['url'],"search&q=");
if ($posw !== false)
{
$old_search_string = "true";
}
else
{
// echo "kkk";
}
//echo $search_for_barcode;
$con2=mysqli_connect("localhost", "atlasconn", "atlasasks7164", "ic_intracom");
/* change character set to utf8 */
if (!mysqli_set_charset($con2, "utf8")) {
// printf("Error loading character set utf8: %s\n", mysqli_error($con));
// exit();
} else {
// printf("Current character set: %s\n", mysqli_character_set_name($con));
}
$sql2=sprintf("SELECT country_code, country_name, region_name, city_name, zip_code FROM ip2location_db11 WHERE ip_from <= INET_ATON('%s') ORDER BY ip_from DESC LIMIT 1", $_SERVER["REMOTE_ADDR"] );
if ($result2=mysqli_query($con2,$sql2))
{
// echo $sql2."
";
$row2=mysqli_fetch_assoc($result2);
$rowcount2=mysqli_num_rows($result2);
//printf("Result set has ".$rowcount2." rows.\n");
if ($rowcount2 > 0 )
{
//echo $row2['country_code']."
";
switch (ucwords(strtolower($row2['country_name'])))
{
// ----US Spanish
case "Argentina";
$region = "ar";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Bahamas";
$region = "bs";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Bolivia";
$region = "bo";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Brazil";
$region = "br";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Cayman Islands";
$region = "ky";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Colombia";
$region = "co";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Costa Rica";
$region = "cr";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Dominican Republic";
$region = "do";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Ecuador";
$region = "ec";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "El Salvador";
$region = "sv";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Guatemala";
$region = "gt";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Haiti";
$region = "ht";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Honduras";
$region = "hn";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Martinique";
$region = "mq";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Nicaragua";
$region = "ni";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Panama";
$region = "pa";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Paraguay";
$region = "py";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Peru";
$region = "pe";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Puerto Rico";
$region = "pr";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Venezuela";
$region = "ve";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Chile";
$region = "cl";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "Uruguay";
$region = "ur";
$country_store_code = "us_es";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_es";
$redirect_url_search = "https://manhattanproducts.us/";
break;
// -----------------------------------------------------------------------------------
case "Germany";
$region = "de";
$country_store_code = "de_de";
$redirect_url = "https://manhattanproducts.de/";
$redirect_url_search = "https://manhattanproducts.de/";
break;
case "Austria";
$region = "at";
$country_store_code = "de_de";
$redirect_url = "https://manhattanproducts.de/";
$redirect_url_search = "https://manhattanproducts.de/";
break;
case "Switzerland";
$region = "eu";
$country_store_code = "de_de";
$redirect_url = "https://manhattanproducts.de/";
$redirect_url_search = "https://manhattanproducts.de/";
break;
// -----------------------------------------------------------------------------------
case "Australia";
$region = "au";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Belgium";
$region = "BE";
$country_store_code = "eu_en";
$redirect_url = "https://fr.manhattanproducts.eu";
$redirect_url_search = "https://fr.manhattanproducts.eu/";
break;
case "China";
$region = "CN";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Poland";
$region = "pl";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Spain";
$region = "ES";
$country_store_code = "eu_en";
$redirect_url = "https://es.manhattanproducts.eu";
$redirect_url_search = "https://es.manhattanproducts.eu/";
break;
case "Turkey";
$region = "TR";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Slovakia";
$region = "SK";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Croatia";
$region = "HR";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Serbia";
$region = "RS";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Russia";
$region = "ru";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Portugal";
$region = "PT";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Belarus";
$region = "BY";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Bosnia and Herzegovina";
$region = "BA";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Bulgaria";
$region = "BG";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Cameroon";
$region = "CM";
$country_store_code = "eu_en";
$redirect_url = "https://fr.manhattanproducts.eu";
$redirect_url_search = "https://fr.manhattanproducts.eu/";
break;
case "Congo";
$region = "CG";
$country_store_code = "eu_en";
$redirect_url = "https://fr.manhattanproducts.eu";
$redirect_url_search = "https://fr.manhattanproducts.eu/";
break;
case "Cyprus";
$region = "CY";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Czech Republic";
$region = "CZ";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Denmark";
$region = "DK";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Egypt";
$region = "EG";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Estonia";
$region = "EE";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Finland";
$region = "FI";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "France";
$region = "FR";
$country_store_code = "eu_en";
$redirect_url = "https://fr.manhattanproducts.eu";
$redirect_url_search = "https://fr.manhattanproducts.eu/";
break;
case "Greece";
$region = "GR";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Hungary";
$region = "HU";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Iceland";
$region = "IS";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "India";
$region = "IN";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Iran";
$region = "IR";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Liechtenstein";
$region = "LI";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.de";
$redirect_url_search = "https://manhattanproducts.de/";
break;
case "Lithuania";
$region = "LT";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Luxembourg";
$region = "LU";
$country_store_code = "eu_en";
$redirect_url = "https://fr.manhattanproducts.eu";
$redirect_url_search = "https://fr.manhattanproducts.eu/";
break;
case "Morocco";
$region = "MA";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Mozambique";
$region = "MZ";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Netherlands";
$region = "NL";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Nigeria";
$region = "NG";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Portugal";
$region = "PT";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Pakistan";
$region = "PK";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Romania";
$region = "RO";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Saudi Arabia";
$region = "SA";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Singapore";
$region = "SG";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Slovenia";
$region = "SI";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "South Africa";
$region = "ZA";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Sweden";
$region = "SE";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Syria";
$region = "SY";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Uganda";
$region = "UG";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "United Arab Emirates";
$region = "AE";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Uzbekistan";
$region = "UZ";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "Italy";
$region = "eu";
$country_store_code = "eu_en";
$redirect_url = "https://it.manhattanproducts.eu/";
$redirect_url_search = "https://it.manhattanproducts.eu/";
break;
case "Netherlands";
$region = "eu";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
case "United Kingdom";
$region = "uk";
$country_store_code = "eu_en";
$redirect_url = "https://manhattanproducts.eu/";
$redirect_url_search = "https://manhattanproducts.eu/";
break;
// --------------------------------------------------------------------------
case "Mexico";
$region = "mx";
$country_store_code = "mx_es";
$redirect_url = "https://manhattanproducts.mx";
$redirect_url_search = "https://manhattanproducts.mx/";
break;
// --------------------------------------------------------------------------
case "Canada";
$region = "ca";
$country_store_code = "us_en";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_en";
$redirect_url_search = "https://manhattanproducts.us/";
break;
case "United States";
$region = "us";
$country_store_code = "us_en";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_en";
$redirect_url_search = "https://manhattanproducts.us/";
break;
// --------------------------------------------------------------------------
default:
$country_store_code = "us_en";
$redirect_url = "https://manhattanproducts.us/?___store=manhattan_us_en";
$redirect_url_search = "https://manhattanproducts.us/";
}
}
else
{
$ip_not_found = "true";
}
mysqli_free_result($result2);
mysqli_close($con2);
}
//if ($_SERVER["REMOTE_ADDR"] == '75.114.76.194')
//{
// $region = "de";
// $country_store_code = "de_de";
// $redirect_url = "https://manhattanproducts.de/";
// $redirect_url_search = "https://manhattanproducts.de/";
//}
if (($search_for_barcode == "false") and ($old_search_string == "false"))
{
//
if ($_GET['url'] <> "")
{
// 1. Find URL match in table
$mysqli = new mysqli("localhost", "aschlieck", "asks7164", "ic_intracom");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$con=mysqli_connect("localhost", "aschlieck", "asks7164", "ic_intracom");
/* change character set to utf8 */
if (!mysqli_set_charset($con, "utf8")) {
// printf("Error loading character set utf8: %s\n", mysqli_error($con));
// exit();
} else {
// printf("Current character set: %s\n", mysqli_character_set_name($con));
}
// Check connection
if (mysqli_connect_errno())
{
//echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="select 'Type', barcode, old_url_key, new_url_key, country_code_new from url_rewrites_mh
WHERE old_url_key = '".$_GET['url']."'";
//echo $sql."
";
if ($result=mysqli_query($con,$sql))
{
$rowcount=mysqli_num_rows($result);
$row=mysqli_fetch_assoc($result);
//printf("Result set has ".$rowcount." rows.\n");
if ($rowcount > 0 )
{
if ($rowcount == 1)
{
// Unique hit, no need for further checks
$redirect_url = $row['new_url_key'];
}
if ($rowcount > 1)
{
$sql="select 'Type', barcode, old_url_key, new_url_key, country_code_new from url_rewrites_mh
WHERE old_url_key = '".$_GET['url']."' AND country_code_new like '".substr($country_store_code,0,2)."%'";
//echo $sql."
";
if ($result=mysqli_query($con,$sql))
{
$rowcount=mysqli_num_rows($result);
$row=mysqli_fetch_assoc($result);
if ($rowcount > 0)
{
$redirect_url = $row['new_url_key'];
}
}
}
}
else
{
$only_by_location = "true";
}
// Free result set
mysqli_free_result($result);
mysqli_close($con);
}
}
else
{
$only_by_location = "true";
}
}
else
{
// echo "hi";
if ($search_for_barcode == "true")
{
$redirect_url = "https://support.manhattanproducts.com/search?q=".str_replace("barcode/","",$_GET['url']);
}
else if ($old_search_string == "true")
{
if ($country_store_code == "mx_es")
{
$redirect_url = $redirect_url_search."catalogsearch/result/?support=1&q=".str_replace("search?q=","",$_GET['url'])."";
}
else
{
$redirect_url = $redirect_url_search."search?q=".str_replace("search?q=","",$_GET['url'])."&type=product";
$redirect_url = str_replace("q=search&","",$redirect_url);
}
}
}
// Writing Log File for Redirect
$con2=mysqli_connect("localhost", "atlasconn", "atlasasks7164", "ic_intracom");
if (!isset($_SERVER['HTTP_REFERER']))
{
$_SERVER['HTTP_REFERER'] = "";
}
$insertSQL = sprintf("INSERT INTO url_rewrites_log_mh
(id, ClientIp, ClientType, ClientCountry, ReferrerUrl, UrlRequested, UrlRedirected, RequestTime)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($dummy, "int"),
GetSQLValueString($_SERVER['REMOTE_ADDR'], "text"),
GetSQLValueString($_SERVER['HTTP_USER_AGENT'] , "text"),
GetSQLValueString($region, "text"),
GetSQLValueString($_SERVER['HTTP_REFERER'], "text"),
GetSQLValueString($_GET['url'], "text"),
GetSQLValueString($redirect_url, "text"),
GetSQLValueString(date('Y-m-d H:i:s') , "date"));
// echo $insertSQL."";
if ($result=mysqli_query($con2,$insertSQL))
{
}
$anything_found = 'yes';
// Free result set
// echo "URL ".$redirect_url;
// Permanent 301 Redirect via PHP
header("HTTP/1.1 301 Moved Permanently");
header("Location: ".$redirect_url);
exit();
?>