//-----------------------------------------------------------------------------------------------------------------
$srv=explode("/",$_SERVER['REQUEST_URI']);$coucc=$srv[1]; $lasturi=array_slice($srv, -1)[0]; //// ZMENIT na [1]
if($coucc=='' || strlen($coucc)<>2) {$LANG='en'; $cesta='';$tab='en';} else {$LANG=$coucc; $cesta=$coucc.'/'; $tab=$coucc;}
if($LANG=='en')$tab='';
$start = microtime(true);
//----------automatic lang----------------------------------------------------------------------
if($_SERVER['REQUEST_URI']=='/' && Detect_bot()<>'true') {
if($_SESSION["lang"]=='' && $_COOKIE[cookie_lang]=='') { $LA = GetLocalLang(); if($LA<>'') $LANG = $LA; $_SESSION["lang"] = $LANG; setcookie("cookie_lang",$LANG,time()+(3600*24*365),'/'); if($LANG<>'en') header("Location:/".$LANG."/"); }
//else { if($LANG<>$_SESSION["lang"]) { header("Location:".$cvhfj); } }
//if($_SESSION["lang"]<>'' && $_SESSION["lang"]<>'en' && $_SESSION["lang"]<>'/' ) header("Location:/".$_SESSION["lang"]."/");
if($_COOKIE[cookie_lang]<>'' && $_COOKIE[cookie_lang]<>'en') header("Location:/".$_COOKIE[cookie_lang]."/");
}
else { $_SESSION["lang"] = $LANG; setcookie("cookie_lang",$LANG,time()+(3600*24*365),'/'); } //echo $LANG.' '.$_SESSION["lang"];
if($LANG=='cn')$LANG='zh';
//----------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------
$dateakt=date('Y-m-d G:i:s');
$webname='Medicinous ČR'; $weburl='https://www.medicinous.com';
//$COUNTRY='GB';
$xa=GetLocalCountry($_GET[iddc],""); $xa=explode(':',$xa); $COUNTRY=$xa[0]; $CONTINENT=$xa[1];
if($_GET[country]<>'') { $COUNTRY=$_GET[country];$CONTINENT=$_GET[continent]; } //$COUNTRY="CZ"; $CONTINENT=1;
$urk=$_SERVER[REQUEST_URI];
$COUNTRY='CZ';
//----------------------------------------------------------------------------------------------
//----------------covid data---------------------------------------------------
$arrayvyrez=array(); $arrayvyrezx=array(); $arr_base_cov=array();
$sl0=$mysqli->query("select detail,js from `regions` where country_code='$COUNTRY' AND city_code='' "); $rl0=mysqli_fetch_array($sl0);
if($rl0[detail]==1 && $_GET[area]==2) { $amchartdata=$rl0[js]; $country_code="subdivision_code"; $subdivision_test=1; } else { $amchartdata="worldLow"; $country_code="country_code"; $subdivision_test=0; }
$sl=$mysqli->query("select * from `regions` where web='$CONTINENT' AND city_code='' "); while($r=mysqli_fetch_array($sl)) { if(strlen($r[country_code])==2) $arrayvyrezx[]=$r[country_code]; }
$arrayvyrez = array_diff($arrayvyrezx, array("RU","IN"));
$arrayvyrezx = implode("','",$arrayvyrezx);
$selco1=$mysqli->query("select * from `cov_actual` where country_code IN ('".$arrayvyrezx."') and country_code<>'$COUNTRY' order by total_cases desc limit 0,10");
while($rco1=mysqli_fetch_array($selco1)) { if(strlen($rco1[country_code])==2) $arr_base_cov[]=$rco1[country_code]; }
//if ($CONTINENT==1) $arr_base_cov=array('FR','IT','HU');
//-----------------------------------------------------------------------------
//$rand=rand(10,10000);
setcookie("foo", "1", time() + (10 * 30 * 24 * 60 * 60),'/');
//setcookie("ran", $rand, time() + (10 * 30 * 24 * 60 * 60),'/');
if($_COOKIE[iqt]<>'') $r=$mysqli->query("select * from `Users` where `user_id`='$_COOKIE[cookie_user]' and `password`<>'' and `Fuid`='' and active='1' ");
else $r=$mysqli->query("select * from `Users` where `user_id`='$_COOKIE[cookie_user]' and `Fuid`='$_COOKIE[FBID]' and `password`='' and active='1' ");
$us=mysqli_fetch_array($r);
//==============SEO============================================================
//globalni search
if($_GET[titlex]<>''){
$gettitxxx = $mysqli->real_escape_string(strip_tags($_REQUEST[titlex]));
$gettitxxx = trim(preg_replace('/\s+/',' ', $gettitxxx));
$gettitxxx=strip_tags($gettitxxx);
$tqptp0=$mysqli->query("select * from hledani where `lang`='$LANG' and `text`='$gettitxxx' "); $rowtqptp=mysqli_fetch_array($tqptp0); $datehgjkp=date("n",strtotime($rowtqptp[datum])); if($rowtqptp[datum]<>'') $dbolwov = Part("month_".$datehgjkp,$LANG,"","").' '.date("Y",strtotime($rowtqptp[datum])).' |';
$TitleX=strtoupper($_GET[titlex]).' | '.$webname; //'.$dbolwov.'
$DescriptionX=Part("seo_description_down1",$LANG,"","").' '.ucwords($_GET[titlex]).'. '.Part("seo_description_down2",$LANG,"","").' '.$_GET[titlex].', '.Part("seo_description_down3",$LANG,"","").' '.ucwords($_GET[titlex]).'. '.Part("seo_description_down4",$LANG,"","").' '.ucwords($_GET[titlex]).'. ';
$KeywordX=str_replace(" ",",",$_GET[titlex]);
}
//search pro lekarny
if($_GET[titlex1]<>'' && $_GET[searchx]==1){
$gettitxxx = $mysqli->real_escape_string(strip_tags($_REQUEST[titlex]));
$gettitxxx = trim(preg_replace('/\s+/',' ', $gettitxxx));
$gettitxxx=strip_tags($gettitxxx);
if($_GET[id_category]=='deal') $tabub=" hledani_pharma_akce "; else $tabub=" hledani_pharma ";
$tqptp=$mysqli->query("select * from $tabub where `lang`='$LANG' and `text`='$gettitxxx' "); $rowtqptp=mysqli_fetch_array($tqptp); $datehgjkp=date("n",strtotime($rowtqptp[datum])); if($rowtqptp[datum]<>'') $dbolwov = Part("month_".$datehgjkp,$LANG,"","").' '.date("Y",strtotime($rowtqptp[datum])).' |';
if($rowtqptp[price]<>0) $pbolwov=Part("from_note",$LANG,"","").' '.$rowtqptp[price].CalCurr($rowtqptp[currency],$LANG,$COUNTRY,'').' ';
if($_GET[id_category]=='deal') $dbolwov=Part("deal_note",$LANG,"",""); else $dbolwov=$dbolwov;
$TitleX=strtoupper($_GET[titlex]).' '.$pbolwov.'| '.$webname; //'.$dbolwov.'
$DescriptionX=ucwords($_GET[titlex]).' - '.Part("seo_desc_pharmad",$LANG,"","");
$KeywordX=str_replace(" ",",",$_GET[titlex]);
}
if($_GET[id_category]<>'' && $_GET[id_category]<>'deal'){
$getcatxx = $mysqli->real_escape_string($_GET[id_category]);
$seo=$mysqli->query("select * from `pharmacies_category` where `id_category`='$getcatxx' "); $seorow=mysqli_fetch_array($seo);
if($seorow[lang]==$LANG) { $TitleX=strtoupper($seorow[title]); $DescriptionX=$TitleX.' - '.Part("home_box3_text_lekarny",$LANG,"",""); $KeywordX=str_replace(" ",",",$seorow[title]).' '.$seorow[keywords]; } else { $TitleX=$seorow[title_en]; $DescriptionX=$TitleX.' - '.Part("home_box3_text_lekarny",$LANG,"",""); $KeywordX=str_replace(" ",",",$seorow[title_en]).' '.$seorow[keywords_en]; }
$TitleX=$TitleX.' | '.$webname;
}
if($_GET[id_shop]<>''){
$getshopxx = $mysqliS->real_escape_string($_GET[id_shop]);
$seo=$mysqliS->query("select * from `pharmacies_products_cz` where `id_pharma`='$getshopxx' "); $seorow=mysqli_fetch_array($seo);
if($seorow[lang]==$LANG) { $TitleX=strtoupper($seorow[title]); $DescriptionX=$TitleX.' - '.urlencode($seorow[description]); $KeywordX=str_replace(" ",",",$seorow[title]).' '.$seorow[keywords]; }
else { $TitleX=$seorow[title]; $DescriptionX=$TitleX.' - '.urlencode($seorow[description]); $KeywordX=str_replace(" ",",",$seorow[title_en]).' '.$seorow[keywords_en]; }
$TitleX=$TitleX.' | '.$webname;
}
if($_GET[blog_id]<>''){
$getshopxx = $mysqli->real_escape_string($_GET[blog_id]);
$seo=$mysqli->query("select * from blog where `ukaz`='1' and id_stranky='$getshopxx' "); $seorow=mysqli_fetch_array($seo);
if($seorow[lang]==$LANG) { if($seorow[title]<>'') $tttx=$seorow[title]; else $tttx=$seorow[nadpis]; $TitleX=$tttx; if($seorow[description]<>'') $descx=$seorow[description]; else $descx=strip_tags(substr($seorow[text],0,400)); $DescriptionX=$TitleX.' - '.$descx; $KeywordX=str_replace(" ",",",$seorow[title]).' '.$seorow[keywords]; }
$TitleX=$TitleX.' | '.$webname;
$titpic=1; //pokud nechci pouzit pro sdileni na fb zakladni obrazek, ale chci aby si ho fb na strance nasel sam
$titpicx="https://".$_SERVER['HTTP_HOST']."/data/pictures/blog/".$seorow[id_stranky].".jpg";
}
if($_GET[id]<>''){
$getiddd = $mysqli->real_escape_string($_GET[id]);
if($_GET[ZOBRAZ]==1){
$seotypec=2;
}
else{
$seotypec=1; $seotypet = Part("seo_text_interakce",$LANG,"","").' ';
}
$seo=$mysqli->query("select * from `history` where `drugs_ids`='$getiddd' and `type`='$seotypec' and `lang`='$LANG' limit 0,1 "); $seorow=mysqli_fetch_array($seo);
$TitleX=substr($seorow[title],strpos($seorow[title],":")+1); $TitleX=trim($TitleX); if($TitleX=='') $TitleX = Part("seo_title_compare",$LANG,"","");
$tx=explode("&",$TitleX); $txx=array();
foreach ($tx as $value) { $zxx=explode(" ",trim($value)); $txx[]=$zxx[0]; }
$TitleX=implode(" & ",$txx);
$TitleX=substr($TitleX,0,60); $TitleX=strtoupper($TitleX).' | '.$seotypet.$webname;
$DescriptionX=strip_tags(str_replace("
"," ",$seorow[description])); $DescriptionX=substr(trim($DescriptionX),0,180).'...';
$keywc=strip_tags(str_replace("
"," ",$seorow[drugs_titles])); $keywc = str_replace(array('(', ')'), array('', ''), $keywc); //$keywc = preg_replace('~\b[a-z]{1,2}\b\~', '', $keywc);
$KeywordX=str_replace(" ",",",$keywc);
}
if($_GET[id_alternative]<>''){
$getalttt = $mysqli->real_escape_string($_GET[id_alternative]);
$tqptp=$mysqli->query("select * from `list` where `id_drugs`='$getalttt' "); $rowtqptp=mysqli_fetch_array($tqptp); //$datehgjkp=date("n"); $dbolwov = Part("month_".$datehgjkp,$LANG,"","").' '.date("Y").'';
$TitleX=strtoupper($rowtqptp[title_full]).' - '.Part("seo_title_alternativy",$LANG,"","");
$DescriptionX=Part("seo_description_down1",$LANG,"","").' '.ucwords($_GET[titlex]).'. '.Part("seo_description_down2",$LANG,"","").' '.$_GET[titlex].', '.Part("seo_description_down3",$LANG,"","").' '.ucwords($_GET[titlex]).'. '.Part("seo_description_down4",$LANG,"","").' '.ucwords($_GET[titlex]).'. ';
$KeywordX=str_replace(" ",",",$_GET[titlex]);
}
if(strpos($_SERVER['REQUEST_URI'],'/pharma.php') !== false){
$TitleX=Part("pharma_nadpis",$LANG,"","");
$DescriptionX=Part("home_box3_text_lekarny",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if(strpos($_SERVER['REQUEST_URI'],'/int.php') !== false){
$TitleX=Part("int_nadpis",$LANG,"","");
$DescriptionX=Part("home_box2_text_porovnani",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if(strpos($_SERVER['REQUEST_URI'],'/sfx.php') !== false){
$TitleX=Part("sfx_nadpis",$LANG,"","");
$DescriptionX=Part("home_box2_text_porovnani",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if(strpos($_SERVER['REQUEST_URI'],'/variant.php') !== false){
$TitleX=Part("variant_nadpis",$LANG,"","");
$DescriptionX=Part("home_box1_text",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if(strpos($_SERVER['REQUEST_URI'],'/list.php') !== false){
$TitleX=Part("seo_list_nadpis",$LANG,"","");
$DescriptionX=Part("seo_list_desc",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if($_GET[idlist]<>''){
$getalttt = $mysqli->real_escape_string($_GET[idlist]);
$tqptp=$mysqli->query("select redirect,title,forma,obsah,vydej,id_drugs from `list` where `id_drugs`='$getalttt' "); $rowtqptp=mysqli_fetch_array($tqptp);
$rowtqptp[title]=strtoupper($rowtqptp[title]); $redirect=$rowtqptp[redirect];
if($redirect<>'') {
$redirect_value=explode("|",$redirect); echo 'kkk'.$redirect_value[0];
$server_url=$_SERVER['REQUEST_URI'];
$server_url=str_replace($rowtqptp[id_drugs],$redirect_value[0],$server_url);
header("Location: $server_url", true, 301);
exit();
}
$TitleX=PartReplace("seo_title_druginfo",$LANG,"","","xanax",$rowtqptp[title]);
if($_GET[val]==Part("link_sfx",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("side_effects",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_interactions",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("seo_text_interakce",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_davkovani",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_davkovani",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_ceny",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_menu_ceny",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_leaflet",$LANG,"","")) { $TitleX=$rowtqptp[title].' '.Part("list_leaflet",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_leaflet_souhrn",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.$rowtqptp[forma].' '.Part("list_leaflet",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_reviews",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_menu_hodnoceni",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_diskuse",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_menu_diskuse",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_dostup_strucne",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("seo_bez_predpisu",$LANG,"","").($rowtqptp[vydej]=='R' ? '?' : ''); $titleadd=$rowtqptp[title].' '.Part("drug_sell",$LANG,"",""); }
if($_GET[val]==Part("link_reviews",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_menu_hodnoceni",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_diskuse",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_menu_diskuse",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_int_short",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("seo_title_interakceshort",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_sfx_strucne",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("seo_text_sfx",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_alt_strucne",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_alter_souhrn",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_indik_strucne",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("list_indikace_souhrn",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_recenze_drug",$LANG,"","")){ $TitleX=$rowtqptp[title].' '.Part("seo_title_recenzedrug",$LANG,"",""); $titleadd=''; }
if($_GET[val]==Part("link_alcohol_strucne",$LANG,"","")){ $TitleX=$rowtqptp[title].' a '.Part("link_alcohol_strucne",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='spc'){ $TitleX=$rowtqptp[title].' a '.Part("title_spc",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='inf'){ $TitleX=$rowtqptp[title].' '.$rowtqptp[obsah].' '.$rowtqptp[forma]; $titleadd=''; }
if($_GET[infospc]=='info'){
if($_GET[val]=='obs') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_obs",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='for') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_for",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='dos') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_dos",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='con') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_con",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='int') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_int",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='ind') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_ind",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='prg') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_prg",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='kid') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_kid",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='war') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_war",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='car') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_car",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='sfx') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_sfx",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='ove') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_ove",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='dyn') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_dyn",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='kin') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_kin",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='saf') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_saf",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='far') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_far",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='oba') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_oba",$LANG,"",""); $titleadd=''; }
if($_GET[val]=='pkg') { $TitleX=$rowtqptp[title].' '.Part("title_spc_extr_pkg",$LANG,"",""); $titleadd=''; }
}
$DescriptionX=$rowtqptp[title].' '.Part("seo_list_desc_base",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
if($titleadd<>'') $TitleX=$TitleX.' | '.$titleadd; else $TitleX=$TitleX.' | '.$webname;
}
if($_GET[area]<>''){
if($_GET[area]==0 && $_GET[type]==0) $nadpismap=ucfirst(Part("covid_menu_data_world",$LANG,"",""));
if($_GET[area]==1 && $_GET[type]==0) $nadpismap=ucfirst(Part("covid_data",$LANG,"","")).' '.LangRegion($LANG,$CONTINENT,"","");
if($_GET[area]==0 && $_GET[type]==1) $nadpismap=ucfirst(Part("covid_map_world",$LANG,"",""));
if($_GET[area]==1 && $_GET[type]==1) $nadpismap=ucfirst(Part("covid_map",$LANG,"","")).' '.LangRegion($LANG,$CONTINENT,"","");
if($_GET[area]==2 && $_GET[type]==1) { $nadpismap=LangCoV($LANG,$COUNTRY,'',$row[country]); $nadpismap1=' - '.Part("covid_data",$LANG,"","").','.Part("covid_map",$LANG,"",""); }
$TitleX=Part("covid_title",$LANG,"","").' - '.$nadpismap.$nadpismap1;
$DescriptionX=Part("covid_title",$LANG,"","");
$KeywordX=str_replace(" ",",",$TitleX);
$TitleX=$TitleX.' | '.$webname;
}
if($DescriptionX == '') $DescriptionX = Part("footer_main_text",$LANG,"","");
if($TitleX == '') { $TitleX = Part("seo_title_global",$LANG,"",""); $KeywordX=str_replace(" ",",",$TitleX); }
//=============================================================================
$ax = $mysqli->query("select num from help_tab where `source`='1' "); $ax=mysqli_fetch_array($ax); //lekarna
$bx = $mysqli->query("select num from help_tab where `source`='4' "); $bx=mysqli_fetch_array($bx); //benu
$dx = $mysqli->query("select num from help_tab where `source`='3' "); $dx=mysqli_fetch_array($dx); //drmax
$jx = $mysqli->query("select num from help_tab where `source`='2' "); $jx=mysqli_fetch_array($jx); //pilulka
$fx = $mysqli->query("select num from help_tab where `source`='5' "); $fx=mysqli_fetch_array($fx); //pilulka
$ox = $mysqli->query("select num from help_tab where `title`='akcniraj-akce' "); $ox=mysqli_fetch_array($ox); //all akcniraj
$tok = $mysqli->query("select val1,val2 from help_tab where `item`='total' "); $ok=mysqli_fetch_array($tok); //all akcniraj
?>
Stačí ONLINE rezervovat a vyzvednout, nebo objednat s doručením A UŠETŘIT