// var_dump($_SESSION);die;

$page=$actual_link = "https://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

if($page=='https://toolsmyne.com/index' ){
    header("Location:https://toolsmyne.com/");
}
if($page=='https://toolsmyne.com/view/Bosch-Professional-GSB-10-RE-Corded-Electric-Drill-Tool-Set-10mm-Blue-500W-with-100-Piece-Accessory-Kit'){
     header("Location:https://toolsmyne.com/view/Bosch-GSB-10-RE-Corded-Electric-Drill-Tool-Set-10mm-Blue-500W-with-100-Piece-Accessory-Kit");
}

$_SESSION['city'] = 10;
require_once "admin/includes/config.php";
$sql_set = $con->query("select * from settings where entry_id  = 1");
$res_set = $sql_set->fetch(PDO::FETCH_OBJ);
$sql_ship = $con->query("select * from shipping_details where entry_id  = 1");
$res_ship = $sql_ship->fetch(PDO::FETCH_OBJ);

 if(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on')   
         $url = "https://";   
    else  
         $url = "http://";   
    // Append the host(domain name, ip) to the URL.   
    $url.= $_SERVER['HTTP_HOST'];   
    
    // Append the requested resource location to the URL   
    $url.= $_SERVER['REQUEST_URI'];   

$page = basename($_SERVER['SCRIPT_NAME']);

if (isset($_POST['change_city'])) {
    $_SESSION['city'] = $_POST['change_city'];
    unset($_SESSION['sid']);
}

if (isset($_POST['change_language'])) {
    $_SESSION['language'] = $_POST['change_language'];
    if ($_POST['change_language'] == 0) {
        $language_title = 'English';
    } else {
        $language = $con->query("select * from languages where entry_id = " . $_POST['change_language']);
        $language = $language->fetch(PDO::FETCH_OBJ);
        $language_title = $language->language;
    }
}


if (isset($_SESSION['city']) && $_SESSION['city'] != '') {
    $session_city = $_SESSION['city'];
} else {
    $ip_address = $_SERVER['REMOTE_ADDR'];

    /* Get user ip address details with geoplugin.net */
    $geopluginURL = '//www.geoplugin.net/php.gp?ip=' . $ip_address;
    $addrDetailsArr = unserialize(file_get_contents($geopluginURL));

    /* Get City name by return array */
    $city = $addrDetailsArr['geoplugin_city'];

    /* Get Country name by return array */
    $country = $addrDetailsArr['geoplugin_countryName'];

    /* Comment out these line to see all the posible details */
    /* echo '<pre>';
      print_r($addrDetailsArr);
      die(); */

    if (!$city) {
        $city = 'CHOUTUPPAL';
    }
    $city = strtolower($city);
    $sqlc = $con->query("select * from `cities` where LOWER(`city`) = '$city'");
    if ($sqlc->rowCount() > 0) {
        $resc = $sqlc->fetch(PDO::FETCH_OBJ);
        $_SESSION['city'] = $resc->entry_id;
//echo "<script>document.location.href='$actual_link'</script>";
    } else {
        $_SESSION['city'] = '10';
//echo "<script>document.location.href='$actual_link'</script>";
    }
}

if (!isset($_SESSION['language']) || $_SESSION['language'] == '') {
    $_SESSION['language'] = 0;
    $language_title = "English";
} else {
    if ($_SESSION['language'] == 0) {
        $language_title = 'English';
    } else {
        $language = $con->query("select * from languages where entry_id = " . $_SESSION['language']);
        $language = $language->fetch(PDO::FETCH_OBJ);
        $language_title = $language->language;
    }
}
$uid=$_SESSION['uid'];
// $chk_cart=$con->query("SELECT * FROM cart WHERE user_link='$uid' AND confirmed_status='pending'");
// if($chk_cart->rowcount() >0){
//     $ch=$chk_cart->fetch(PDO::FETCH_OBJ);
    
//     $_SESSION['sid'] = $ch->sid;
    
//     $ch_o=$con->query("SELECT * FROM orders WHERE sid='$ch->sid'");
//     $ch_o_v=$ch_o->rowCount();
//     if($ch_o_v > 0){
//         $con->query("DELETE FROM orders WHERE sid='$sid'");
//     }
    
// }else{
if (!isset($_SESSION['sid']) || $_SESSION['sid'] == '') {
    $_SESSION['sid'] = getsid();
}
// }
//print_r($_SESSION['sid']);die();
function getsid($length = 10, $level = 2) {

    list($usec, $sec) = explode(' ', microtime());
    srand((float) $sec + ((float) $usec * 100000));

    $validchars[1] = "0123456789abcdfghjkmnpqrstvwxyz";
    $validchars[2] = "0123456789abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
    $validchars[3] = "0123456789_!@#$%&*()-=+/abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_!@#$%&*()-=+/";

    $password = "";
    $counter = 0;

    while ($counter < $length) {
        $actChar = substr($validchars[$level], rand(0, strlen($validchars[$level]) - 1), 1);

        // All character must be different
        if (!strstr($password, $actChar)) {
            $password .= $actChar;
            $counter++;
        }
    }

    return $password;
}

$current_city = $_SESSION['city'];

$page = basename($_SERVER['SCRIPT_NAME']);


$page_url = "https://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
// print_r($page_url);
$seo=$con->query("select * from `page_seo` where `url` = '$page_url' order by entry_id desc");
$res_seo = $seo->fetch(PDO::FETCH_OBJ);



?>
<!DOCTYPE html>
<html lang=en>
    <head>
        <meta charset=utf-8>
        <meta name="viewport" content="width=device-width">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name=viewport content="width=device-width, initial-scale=1.0, user-scalable=no">

             <title> </title>
            <meta name="description" content="" />
            <meta name="keywords" content="" />
            <meta property="og:title" content="" />
            <meta property="og:description" content="" />
            <meta property="og:url" content="" />
            
            
            
                 <link rel="canonical" href="">
        <base href="