<? require_once('Connections/intracomdb.php'); 
//die();
 //returns 1 if the user agent is a bot
function is_bot($user_agent)
{
  //if no user agent is supplied then assume it's a bot
  if($user_agent == "")
    return 1;

  //array of bot strings to check for
  $bot_strings = Array(  "google",     "bot",
            "yahoo",     "spider", "Yahoo", "Bot", 
            "archiver",   "curl", "Sleuth", "Windows-Live", "ePochta", 
            "python",     "nambu", "URL Validator","Crawler", 
            "twitt",     "perl", "PF:INET", "Google", 
            "sphere",     "PEAR", "ScoutJet", "ipla",
            "java",     "wordpress", "Ocelli",
            "search",     "msn", "youdao", "http_load",
            "radian",     "crawl", "ColdFusion", "EMail Exractor", 
            "yandex",     "eventbox", "phpMyFAQ Link Checker",
            "monitor",   "mechanize", "HTMLParser/1.6",
            "B-O-T",   "boitho", "TalkTalk",
            "Cerberian",   "Charlotte", "Covario",
            "Find",   "htdig",
            "ichiro",   "larbin",
            "link",   "walk",
            "fetch",   "lwp-trivial",
            "mabontland",   "media",
            "morning",   "msn",
            "Nutch",   "MVAClient",
            "oegp",   "Pompos",
            "PycURL",   "SBIder",
            "Scrubby",   "SearchSight", "CamontSpider",
            "semanticdiscovery",   "ShopWiki",
            "StackRamblerStackRambler",   "TeomaTeoma",
            "TinEye",   "updatedupdated", "PostRank",
            "voyager",   "Vortex", "GetRight", "gvfs",
            "webcollage",   "Websquash", "Pathtraq",
            "yacy",   "Slurp", "panscient",
            "facebookexternal", "vbseo", "winhttp", "pirst", "PHP/SMF",
			"DAP", "fuck", "parser", "Microsoft URL Control",
			"Jakarta", "Java", "Microsoft Office Existence Discovery",
			"Mozzler", "Proxy", "Python", "Twingly Recon", "Twitterrific", 
			"WinHttp", "xerka", "www.clamav.net", "Yandex", "Rambler", "Mail.Ru", "aport",
			"Wget", "12345", "gonzo", "suchen", "Facebook", "VB Project", "W3C", "WordPress", "WebCorp", "Spider",
			"buzzzy.com", "ClamAV", "DailyPerfect", "FDM", "MJ12"
          );
  foreach($bot_strings as $bot)
  {
    if(strpos($user_agent,$bot) !== false)
    { return 1; }
  }
  
  return 0;
}

if (!isset($_GET['url']))
{
	$_GET['url'] = ""; 
}
$_GET['url'] = str_replace('url=','',$_SERVER['QUERY_STRING']);
//echo("intellnet web site: ".$_GET['url']." <br>");
//die();
//
if (is_bot(urldecode($_SERVER['HTTP_USER_AGENT'])) == 1) 
{
	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;
}

$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";
	}
else
	{
	// Do nothing
	}

// Check if old search was called
$posw = strpos($_GET['url'],"search&q=");
if ($posw !== false) 
	{
	$old_search_string = "true";
	}
else
	{
	// Do nothing
	}


//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."<br>";

  $row2=mysqli_fetch_assoc($result2);
  $rowcount2=mysqli_num_rows($result2);
  //printf("Result set has ".$rowcount2." rows.\n");
  
  if ($rowcount2 > 0 )
  {
	//echo  $row2['country_code']."<br>";
	switch (ucwords(strtolower($row2['country_name'])))
	{
	// China - New in May 2022
	case "China";
	$region = "CN";		$country_store_code = "cn_cn";
	$redirect_url = "http://www.intellinet.com.cn";
	$redirect_url_search = "http://www.intellinet.com.cn/search.php?key=";break;
			
	// ----US Spanish
	case "Argentina";
		$region = "ar";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Bahamas";
		$region = "bs";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Bolivia";
		$region = "bo";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Brazil";
		$region = "br";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Cayman Islands";
		$region = "ky";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Colombia";
		$region = "co";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Costa Rica";
		$region = "cr";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Dominican Republic";
		$region = "do";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Ecuador";
		$region = "ec";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "El Salvador";
		$region = "sv";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Guatemala";
		$region = "gt";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Haiti";
		$region = "ht";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Honduras";
		$region = "hn";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Martinique";
		$region = "mq";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Nicaragua";
		$region = "ni";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Panama";
		$region = "pa";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Paraguay";
		$region = "py";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Peru";
		$region = "pe";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Puerto Rico";
		$region = "pr";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Venezuela";
		$region = "ve";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Chile";
		$region = "cl";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "Uruguay";
		$region = "ur";		$country_store_code = "us_es";
		$redirect_url = "https://intellinetsolutions.com/?___store=intellinet_us_es";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
// -----------------------------------------------------------------------------------
	case "Germany";
		$region = "de";
		$country_store_code = "de_de";
		$redirect_url = "https://intellinetnetwork.de";
		$redirect_url_search = "https://intellinetnetwork.de";
		break;
	case "Austria";
		$region = "at";
		$country_store_code = "de_de";
		$redirect_url = "https://intellinetnetwork.de";
		$redirect_url_search = "https://intellinetnetwork.de";
		break;
	case "Switzerland";
		$region = "eu";
		$country_store_code = "de_de";
		$redirect_url = "https://intellinetnetwork.de";
		$redirect_url_search = "https://intellinetnetwork.de";
		break;
// -----------------------------------------------------------------------------------
	case "Australia";
		$region = "au";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Belgium";
		$region = "BE";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;

	case "Poland";
		$region = "pl";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_pl";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Spain";
		$region = "ES";		$country_store_code = "eu_en";
		$redirect_url = "https://es.intellinetnetwork.eu";
                                $redirect_url_search = "https://es.intellinetnetwork.eu";break;
	case "Turkey";
		$region = "TR";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Slovakia";
		$region = "SK";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Croatia";
		$region = "HR";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Serbia";
		$region = "RS";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Russia";
		$region = "ru";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Portugal";
		$region = "PT";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Belarus";
		$region = "BY";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Bosnia and Herzegovina";
		$region = "BA";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Bulgaria";
		$region = "BG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Cameroon";
		$region = "CM";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Congo";
		$region = "CG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Cyprus";
		$region = "CY";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Czech Republic";
		$region = "CZ";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Denmark";
		$region = "DK";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Egypt";
		$region = "EG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Estonia";
		$region = "EE";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Finland";
		$region = "FI";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Tunisia";
		$region = "TN";		$country_store_code = "eu_fr";
		$redirect_url = "https://fr.intellinetnetwork.eu";
                                $redirect_url_search = "https://fr.intellinetnetwork";break;
    case "France";
		$region = "FR";		$country_store_code = "eu_fr";
		$redirect_url = "https://fr.intellinetnetwork.eu";
                                $redirect_url_search = "https://fr.intellinetnetwork";break;
	case "Greece";
		$region = "GR";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Hungary";
		$region = "HU";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Iceland";
		$region = "IS";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "India";
		$region = "IN";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Iran";
		$region = "IR";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
		$redirect_url_search = "https://intellinetnetwork.eu";
		break;
	case "Liechtenstein";
		$region = "LI";
		$country_store_code = "de_de";
		$redirect_url = "https://intellinetnetwork.de";
		$redirect_url_search = "https://intellinetnetwork.de";
		break;
	case "Lithuania";
		$region = "LT";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Luxembourg";
		$region = "LU";		$country_store_code = "eu_en";
		$redirect_url = "https://fr.intellinetnetwork.eu";
                                $redirect_url_search = "https://fr.intellinetnetwork.eu";break;
	case "Morocco";
		$region = "MA";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Mozambique";
		$region = "MZ";
		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.de";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
		$redirect_url_search = "https://intellinetnetwork.eu";
		break;

	case "Netherlands";
		$region = "NL";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
        $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Nigeria";
		$region = "NG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Portugal";
		$region = "PT";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Pakistan";
		$region = "PK";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Romania";
		$region = "RO";
		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Saudi Arabia";
		$region = "SA";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Singapore";
		$region = "SG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Slovenia";
		$region = "SI";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "South Africa";
		$region = "ZA";
		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Sweden";
		$region = "SE";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Syria";
		$region = "SY";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Uganda";
		$region = "UG";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "United Arab Emirates";
		$region = "AE";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Uzbekistan";
		$region = "UZ";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "Italy";
		$region = "eu";
		$country_store_code = "eu_en";
		$redirect_url = "https://it.intellinetnetwork.eu";
		$redirect_url_search = "https://it.intellinetnetwork.eu";
		break;
	case "Netherlands";
		$region = "eu";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
	case "United Kingdom";
		$region = "uk";		$country_store_code = "eu_en";
		$redirect_url = "https://intellinetnetwork.eu/?___store=intellinet_eu_en";
                                $redirect_url_search = "https://intellinetnetwork.eu";break;
// --------------------------------------------------------------------------
	case "Mexico";
		$region = "mx";
		$country_store_code = "mx_es";
		$redirect_url = "https://intellinetsolutions.mx";
		$redirect_url_search = "https://intellinetsolutions.mx";
		break;
// --------------------------------------------------------------------------
	case "Canada";
		$region = "ca";
		$country_store_code = "us_en";
		$redirect_url = "https://intellinetsolutions.com";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
	case "United States";
		$region = "us";
		$country_store_code = "us_en";
		$redirect_url = "https://intellinetsolutions.com";
		$redirect_url_search = "https://intellinetsolutions.com";
		break;
// --------------------------------------------------------------------------
	default:
		$country_store_code = "us_en";
		$redirect_url = "https://intellinetsolutions.com";
		$redirect_url_search = "https://intellinetsolutions.com";
	}
	  
  }
  else
  {
	$ip_not_found = "true";  
  }

  mysqli_free_result($result2);
  mysqli_close($con2);
  }


if (($search_for_barcode == "false") && ($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($con))
	  {
	  //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
	WHERE old_url_key = '".$_GET['url']."'";
	//echo $sql."<br>";
	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
	WHERE old_url_key = '".$_GET['url']."' AND country_code_new like '".substr($country_store_code,0,2)."%'";
	//echo $sql."<br>";
	
			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

{
	if ($search_for_barcode == "true")
	{
		$redirect_url = "https://support.intellinet-network.com/search?q=".str_replace("barcode/","",$_GET['url']);
	}
	else if ($old_search_string == "true")
	
	{
        
		if ($country_store_code == "de_de")
		{
			$redirect_url = $redirect_url_search."/search?q=".str_replace("search?q=","",$_GET['url'])."&type=product";
			$redirect_url = str_replace("q=search&","",$redirect_url);
		} 
		else if ($country_store_code == "us_es")
		{
			$redirect_url = $redirect_url_search."/catalogsearch/result/?support=1&q=".str_replace("search?q=","",$_GET['url'])."&___store=intellinet_us_es";		
		}
		else
		{
			$redirect_url = $redirect_url_search."/catalogsearch/result/?support=1&q=".str_replace("search?q=","",$_GET['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 
		(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."<p>";
				 if ($result=mysqli_query($con2,$insertSQL))
					  {
					  }
							 $anything_found = 'yes';
				 

  // Free result set
//  echo "URL ".$redirect_url;
//die($redirect_url);

// Permanent 301 Redirect via PHP
 header("HTTP/1.1 301 Moved Permanently");
 header("Location: ".$redirect_url);


 exit();
?>