include("auth_user.php"); ?> if(!isset($_GET['site'])) { exit(); } if(!is_numeric($_GET['site'])){ exit(); } $site = $_GET['site']; if(!isset($_GET['cod'])){ header('Location: 404.html'); exit(); } function rus2translit($string) { $converter = array( 'а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ё' => 'e', 'ж' => 'zh', 'з' => 'z', 'и' => 'i', 'й' => 'y', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'c', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sch', 'ь' => '', 'ы' => 'y', 'ъ' => '', 'э' => 'e', 'ю' => 'yu', 'я' => 'ya', 'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ё' => 'E', 'Ж' => 'Zh', 'З' => 'Z', 'И' => 'I', 'Й' => 'Y', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O', 'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'H', 'Ц' => 'C', 'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Sch', 'Ь' => '', 'Ы' => 'Y', 'Ъ' => '', 'Э' => 'E', 'Ю' => 'Yu', 'Я' => 'Ya', ' ' => '-' ); return strtr($string, $converter); } $cod = preg_replace("/[^0-9]/", '', $_GET['cod']); include("db.php"); $exchange = 1; if($exRatesBy){ $exchange = $exRatesBy; } $dsn = "mysql:host=$hostname;dbname=mhjsufhs_ersag;charset=utf8"; $opt = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ); $pdo = new PDO($dsn, "mhjsufhs_ersag", $password, $opt); $rat= $level_rat[$level_typ]; $rate = $level_rat[$level_typ]; /* $stmt = $pdo->prepare("SELECT * FROM exchange ORDER by dat DESC LIMIT 1"); $stmt->execute(); $result = $stmt->fetchAll(); $rat = $result[0]['rat']; if(!isset($result[0]['dat']) || $result[0]['dat']!=date('Ymd')){ $arrContextOptions=array( "http" => array( "method" => "GET", "header" => "Content-Type: application/xml; charset=utf-8;\r\n". "Connection: close\r\n", "ignore_errors" => true, "timeout" => (float)30.0, "content" => $strRequestXML, ), "ssl"=>array( "allow_self_signed"=>true, "verify_peer"=>false, "verify_peer_name"=>false, ), ); $json = file_get_contents('https://bank.gov.ua/NBUStatService/v1/statdirectory/exchange?valcode=TRY&json', false, stream_context_create($arrContextOptions)); $obj = json_decode($json); $rate = $obj[0]->rate; $rat = $rate; if(isset($rate)) { $stmt = $pdo->prepare("INSERT INTO exchange VALUES ('".date('Ymd')."','$rate')"); $stmt->execute(); } } */ $stmt = $pdo->prepare("SELECT * FROM site$site WHERE cod=? LIMIT 1"); $stmt->execute(array($cod)); $result = $stmt->fetchAll(); $info = $result[0]; $brend_nom = json_decode($info['section2'])[0]; $stmt = $pdo->prepare("SELECT * FROM site".$site."_subsections WHERE nom=? AND sec=? LIMIT 1"); $stmt->execute(array($brend_nom,2)); $result = $stmt->fetchAll(); $category = $result[0]['ru']; $category_nom = $result[0]['nom']; if($lang==1){ $category = $result[0]['ru_ru']; } $photos_list = explode(",", $info['photos']); $photo_html = ""; foreach ($photos_list as $photo_nom){ $photo_html.="
"; } $photo_big = "|
/*if($geo!=15){ echo ' Получите со скидкой ';
echo 'от 20% до 47% Цена по каталогу без скидки : '.(round($info[$price_typ]*100)/100).' '.$price_sign.' ';
echo "";
} else */if($geo==1){
echo 'Получите со скидкой ';
echo 'от 20% до 47% Цена по каталогу ERSAG без скидки : '.(round($info[$price_typ]*100)/100).' '.$price_sign.' ';
echo "";
} else {
echo ''.(round(($info[$price_typ])*100*$exchange)/100).' '.$price_sign.' ';
echo ' Цена после регистрации : ';
echo ' '.(round(($info[$price_typ])*0.8*100*$exchange)/100).' '.$price_sign.' ';
echo "";
}
?>
|
echo $description; ?>