$blacklist = array(
'199.48.164.106',
'185.35.151.59',
'185.213.20.143',
'5.62.58.98',
'199.115.89.252'
);
if(in_array($_SERVER['REMOTE_ADDR'], $blacklist)) exit;
$settings['db_host'] = 'mysql01';
$settings['db_name'] = 'db_ceteris';
$settings['db_user'] = 'usr_ceteris';
$settings['db_pass'] = 'uOGdwUgwAWExv';
$settings['db_table_name'] = 'taox_ceteris_';
$_ADMIN_PASSWD='ceteris182';
$_ADMIN_USER='admceteris';
$_ADMIN_EMAIL='info@sbohempevnalinko.cz';
// $_ADMIN_EMAIL='admin@aerohosting.cz';
$_url_adresa_webu='http://www.sbohempevnalinko.cz/';
$url_adresa_admina='http://www.sbohempevnalinko.cz/admin/';
$_title='Ceteris s.r.o.';
$_server_name='Ceteris s.r.o.';
$_SYSTEM_MODUL=array(// nazev _GET include
array('Mapa stránek','mapa=0','_include/mapa.php'),
array('Zboí v akci','zobraz_akce=1','_include/kategorie.php'),
array('Archiv anket','archiv-anket=1','_include/archiv-anket.php'),
array('Ceník mezinárodního volání','cenik-mezinarvol=0','_include/cenik-mezinarvol.php'),
array('','formular=0','_include/formular.php')
);
if(!mysql_connect($settings['db_host'],$settings['db_user'], $settings['db_pass']))
{
echo "Chyba při komunikaci s databází
";
}else{
@mysql_select_db($settings['db_name']) or die( "Unable to select database");
}
//mysql_query("SET CHARACTER SET cp1250");
?>
function dateToMSIE_2($datum)
{
$datum_a=Explode(' ',$datum);
$date_tmp=Explode('-',$datum_a[0]);
return trim(date("d.m.Y",Mktime(0,0,0,$date_tmp[1],$date_tmp[2],$date_tmp[0])).' '.$datum_a[1]);
}
function date_vetsi_o($datum,$o_co)
{// o_co o kolik dní
$date_tmp=Explode('-',$datum);
return date("Y-m-d",Mktime(0,0,0,$date_tmp[1],$date_tmp[2],$date_tmp[0])+($o_co*24*3600));
}
function odstran_uvozovky_zk($text){
if($text[0]=='"')$text=substr($text,1,strlen($text));
if($text[strlen($text)-1]=='"')$text=substr($text,0,strlen($text)-1);
return trim(addslashes($text));
}
function dateToDB($date){
$date = StrTr($date, ",", ".");
$date_tmp=Explode('.',$date);
if(strlen($date_tmp[0])==0)$date_tmp[0]=date("j");
if(strlen($date_tmp[1])==0)$date_tmp[1]=date("m");
if(strlen($date_tmp[2])==0)$date_tmp[2]=date("Y");
if(@checkdate($date_tmp[1],$date_tmp[0],$date_tmp[2])){
$date_formated=$date_tmp[2]."-".$date_tmp[1]."-".$date_tmp[0];
}else{
$date_formated=false;
}
return $date_formated;
}
function delka_data($datum){
$date = StrTr($date, ",", ".");
$date_tmp=Explode('-',$datum);
return Mktime(0,0,0,$date_tmp[1],$date_tmp[2],$date_tmp[0]);
}
function alert($str,$adresa){
$text="";
return $text;
}
function make_file_name($str){
return ereg_replace("[^a-z0-9]","-",urldecode(strtolower(strtr($str,"áčďéěížňóřúůýÁČĎÉĚÍźŇÓŘÚŮÝ","acdeeilnorstuuyzACDEEILNORSTUUYZ"))));
}
function udelej_anketu(){
global $_POST;
global $_COOKIE; // $HTTP_COOKIE_VARS;
global $_url_adresa_webu;
$_POST['anketa']+=0;
if($_POST['anketa']>0){
$vysledek=Mysql_query("select * from anketa where zapnuta_anketa='A' and id='".$_POST['anketa']."'") or die(mysql_error());
if(mysql_num_rows($vysledek)==1){
$hod='';
switch($_POST['hodnoceni_ankety']){
case 'A': { $hod=@mysql_result($vysledek,0,'odp_a'); break;}
case 'B': { $hod=@mysql_result($vysledek,0,'odp_b'); break;}
case 'C': { $hod=@mysql_result($vysledek,0,'odp_c'); break;}
case 'D': { $hod=@mysql_result($vysledek,0,'odp_d'); break;}
case 'E': { $hod=@mysql_result($vysledek,0,'odp_e'); break;}
case 'F': { $hod=@mysql_result($vysledek,0,'odp_f'); break;}
}
/// tady by mohl ybyt kontrola na IP tak je zde jen coocies
if($_COOKIE['anketa']!=$_POST['anketa']){
$_COOKIE['anketa']=$_POST['anketa'];
if(getenv("HTTP_CLIENT_IP")) $ip = getenv("HTTP_CLIENT_IP"); else $ip = getenv("REMOTE_ADDR");
$pc=GetHostByAddr($ip);
$_POST['razitko']+=0;
$vysledek=mysql_query("select * from anketa_hodnoceni where anketa_id='".$_POST['anketa']."' and casove_razitko='".$_POST['razitko']."'");
if(mysql_num_rows($vysledek)==0)
mysql_query("insert into anketa_hodnoceni values('','".$_POST['anketa']."','".$hod."','".date("Y-m-d H:i:s")."','".$ip."','".$pc."','".$_POST['razitko']."')")or die(mysql_error());
}
}
}
$count_all=0;
$vysledek=Mysql_query("select * from anketa where zapnuta_anketa='A' limit 1") or die(mysql_error());
while($zaznam=mysql_fetch_array($vysledek)){
if($_COOKIE['anketa']==$zaznam['id'])$hodnoceno=true; else $hodnoceno=false;
$vysledek_od=mysql_query("select odpoved from anketa_hodnoceni where anketa_id='".$zaznam['id']."' and odpoved<>''")or die(mysql_error());
while($zaznam_od=mysql_fetch_array($vysledek_od)){
$pole[$zaznam_od['odpoved']]++;
}
$count_all=mysql_num_rows($vysledek_od);
?>
}
}
function text_pod_menu($kde,$lan){
global $settings;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."text_pod_menu where kde='".$kde."'");
return str_replace(""",'"',str_replace("\\","",@mysql_result($vysledek,0,'text_'.$lan)));
}
function seo_rubriky($id){
global $settings,$seo_link;
$vysledek=Mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."' order by poradi") or die(mysql_error());
return @mysql_result($vysledek,0,$seo_link);
}
function make_galerie_image($picc,$width,$hight,$obrazek_min,$nor=true,$copy=false){
$pole=explode('/',$obrazek_min);
// php > 5.00 ---
$new_file="";
if(count($pole)>0) for($i=0;$iimagesy($im)){
$new_width=$rec_width;
$new_height= ($rec_width/imagesx($im))*imagesy($im);
}else{
$new_height = $hight;
$new_width =($hight/imagesy($im))*imagesx($im);
}
$im_res = imagecreatetruecolor($new_width, $new_height);
@imagecopyresampled($im_res, $im, 0,0,0,0, $new_width,$new_height, imagesx($im), imagesy($im));
//imagecopyresized($im_res, $im, 0,0,0,0, $new_width,$new_height, imagesx($im), imagesy($im));
$soubor=explode(chr(47),str_replace('\\',chr(47),$obrazek_min));
$soubor=$soubor[count($soubor)-1];
if(substr($soubor,0,3)=='max'){
$vodotisk=imagecreatefrompng('../../vodotisk.png');
@imagecopy($im_res,$vodotisk,round($new_width)-200-10,round($new_height)-50-30,0,0,150,20);
}
if($exp=='jpg'||$exp=='jpeg') imagejpeg($im_res,$obrazek_min, 90);
if($exp=='png') imagepng($im_res,$obrazek_min);
if($exp=='gif') imagegif($im_res,$obrazek_min);
imagedestroy($im);
imagedestroy($im_res);
}else{
if(imagesx($im)>imagesy($im)){
$new_width=$rec_width;
$new_height= ($rec_width/imagesx($im))*imagesy($im);
}else{
$new_height = $hight;
$new_width =($hight/imagesy($im))*imagesx($im);
}
$im_res = imagecreatetruecolor($new_width, $new_height);
@imagecopyresampled($im_res, $im, 0,0,0,0, $new_width,$new_height, imagesx($im), imagesy($im));
imagedestroy($im);
$im_res2 = imagecreatetruecolor($rec_width,$rec_height);
$color = ImageColorAllocate($im_res2,255,255,255);
imagefilledrectangle($im_res2,0,0,$rec_width,$rec_height,$color);
$delta_x=round(($rec_width-$new_width)/2);
$delta_y=round(($rec_height-$new_height)/2);
@imagecopy($im_res2,$im_res,$delta_x,$delta_y,0,0,$new_width,$new_height);
if($exp=='jpg'||$exp=='jpeg') imagejpeg($im_res2,$obrazek_min, 90);
if($exp=='png') imagepng($im_res2,$obrazek_min);
if($exp=='gif') imagegif($im_res2,$obrazek_min);
imagedestroy($im_res);
imagedestroy($im_res2);
}
}
function odstran_znaky_expo($ss){
return stripslashes(str_replace(array(chr(13),chr(59),"\n",';'),'',strip_tags($ss)));
}
function vypsani_kategorii($id_posledni,$pocet_odskoku,$id_select,$no){
global $settings;
global $id_r;
global $odskoku;
$vysledek=Mysql_query("select * from ".$settings['db_table_name']."rubriky where rodic_id='".$id_posledni."' order by poradi") or die(mysql_error());
while($zaznam=mysql_fetch_array($vysledek)){
//global $id_select;
if($no!=$zaznam[id]){
if($zaznam[id]==$id_select){
echo '';
}else{
echo '';
}
$odskoku++;
vypsani_kategorii($zaznam[id],$odskoku,$id_select,$no);
$odskoku--;
}
} //$odskoku=0;
}
function udelej_selec_box_kategorii($id,$id_select,$no){?>
}
function nazev_rubiky($id,$lan){
global $settings;
$vysledek=Mysql_query("select * from ".$settings['db_table_name']."rubriky where rodic_id='0' and id='".$id."' order by poradi") or die(mysql_error());
return @mysql_result($vysledek,0,'nazev_'.$lan);
}
function udelej_selec_box_kategorii_2($id,$id_select,$no){
global $settings;?>
}
$seo_odkaz='link_CZ';
function mezery($pocet){
$mezery='';
for($i=0;$i<$pocet;$i++)$mezery=$mezery.' ';
return $mezery;}
$_seo_odkaz=$seo_odkaz;
function zjisti_jmeno_prohlizece(){
global $_SERVER;
global $settings;
$http_user_agent = strtolower($_SERVER['HTTP_USER_AGENT']);
$query = mysql_query("SELECT nazev_browsru FROM ".$settings['db_table_name']."pristup_uzivatelu_jmena_browseru WHERE '$http_user_agent' REGEXP reg_fx ORDER BY id LIMIT 0,1");
if ($result = mysql_fetch_array($query))
$browser = $result['nazev_browsru'];
else
$browser = 'Neznámý browser';
return $browser;
}
function zjisti_hledane_slova(){
global $_SERVER;
global $settings;
$searchtext='';
$referer = 2; // predpokladame prechod v ramci serveru
if(isset($_SERVER['HTTP_REFERER'])) {
$escape = array ('%u010C', '%u010E', '%u011A', '%u0147', '%u0158', '%u0160', '%u0164', '%u016E', '%u017D', '%u010D', '%u010F', '%u011B', '%u0148', '%u0159', '%u0161', '%u0165', '%u016F', '%u017E', '%u0105', '%u013E');
$unescape = array ('Č', 'Ď', 'Ě', 'Ň', 'Ř', '', '', 'Ů', '', 'č', 'ď', 'ě', 'ň', 'ř', '', '', 'ů', '', '', '');
$http_referer = str_replace($escape, $unescape, urldecode(addslashes($_SERVER['HTTP_REFERER'])) );
$http_referer = strtolower(AutoCzech($http_referer, 'win'));
if ($http_referer == '') { // prime volani
$referer = 1;
} elseif (eregi(no_Referer, $http_referer)) { // prechod v ramci serveru
$referer = 2;
} else {
$url= parse_url($http_referer);
$explode = explode('.', $url['host']); // rozdeli adresu serveru na jednotlive casti
$host_domain = $explode[count($explode) - 2] . '.' . $explode[count($explode) - 1]; // domena 2. urovne
$query = mysql_query("SELECT * FROM ".$settings['db_table_name']."pristup_uzivatelu_vyhledavace WHERE server = '$host_domain'")or die(mysql_error());
if($result = mysql_fetch_array($query)) {
// zjistime pouzitou frazi - pres parametr, ktery vyhledavac pouziva
$variables = explode('&', $url['query']);
for($i = 0;$i < count($variables);$i++) {
$explode = explode('=', $variables[$i]);
if($explode[0] == $result['variable']) {
$searchtext = $explode[1].'--'.$host_domain; // fraze pouzita pri vyhledavani
break;
}
}
}
}}
return $searchtext;
}
function pocitadlo_rubrik($typ_stranky,$rubrika,$referer){
if($typ_stranky>0&&$rubrika>0){
$file=@fopen("zakazane_ip_pro_pocitadlo.txt",'r');
$data="";
if($file!=false){
while(!feof($file)){
$data.=@fgetc($file);;
}
@fclose($file);
}
$data=explode("\n",strtolower($data));
global $settings;
if(getenv("HTTP_CLIENT_IP")) $ip = getenv("HTTP_CLIENT_IP"); else $ip = getenv("REMOTE_ADDR");
$pc=GetHostByAddr($ip);
$pc_2=explode('.',$pc);
$pc_2=$pc[count($pc)-2].'.'.$pc[count($pc)-1];
if(!in_array(strtolower($ip),$data)&&!in_array(strtolower($pc),$data)&&!in_array(strtolower($pc_2),$data)){
$datum_cas=date("Y-m-j H:i:s");
$datum=date("Y-m-d");
$vysledek=mysql_query("select * from ".$settings['db_table_name']."pristup_uzivatelu where id_rubriky='".$rubrika."' and typ_stranek='".$typ_stranky."' and ip='".$ip."' and datum>'".$datum."'")or die(mysql_error());
if(mysql_num_rows($vysledek)>0){
mysql_query("update ".$settings['db_table_name']."pristup_uzivatelu set pocet=pocet+1, datum='".$datum_cas."',id_rubriky='".$rubrika."', typ_stranek='".$typ_stranky."' where ip='".@mysql_result($vysledek,0,'id')."'")or die(mysql_error());
}else{
$jmeno_browsru=zjisti_jmeno_prohlizece();
$find_server=zjisti_hledane_slova();
$prom=explode('--',$find_server);
$jmeno_serveru=$prom[1];
$hledane_slova=$prom[0];
mysql_query("insert into ".$settings['db_table_name']."pristup_uzivatelu values('','".$typ_stranky."','".$rubrika."','1','".$datum_cas."','".$referer."','".$ip."','".$pc."','".$jmeno_browsru."','".$hledane_slova."','".$jmeno_serveru."')")or die(mysql_error());
}
}
}}
function jmeno_mesice($mesic){
switch($mesic){
case 1:{ return 'Leden'; break;}
case 2:{ return 'Únor'; break;}
case 3:{ return 'Březen'; break;}
case 4:{ return 'Duben'; break;}
case 5:{ return 'Květen'; break;}
case 6:{ return 'Červen'; break;}
case 7:{ return 'Červenec'; break;}
case 8:{ return 'Srpen'; break;}
case 9:{ return 'Září'; break;}
case 10:{ return 'Říjen'; break;}
case 11:{ return 'Listopad'; break;}
case 12:{ return 'Prosinec'; break;}
}
}
function jmeno_uzivatele_sekce($id){
global $settings;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."uz_sekce_uzivatele where id='".$id."'")or die(mysql_error());
if(mysql_num_rows($vysledek)==1)
return @mysql_result($vysledek,0,'jmeno_uzivatele');
else
return 'Admin';
}
function dodelej_nuly($cislo){
if(strlen($cislo)<2) return '0'.$cislo; else return $cislo;
}
function datetomsie_time($date){
$cas = explode(' ',$date);
return $cas[1];
}
function jde_o_email($email){
$e= "^[_a-zA-Z0-9\.\-]+@[_a-zA-Z0-9\.\-]+\.[a-zA-Z]{2,4}$";
If(ereg($e,$email))return true; else return false;
}
function jde_o_psc($psc){
$psc = str_replace(" ","",$psc);
$e= "[0-9]{5}$";
If(ereg($e,$psc))return true; else return false;
}
function is_phone($phone)
{
return ereg("^\+[0-9]{9,12}", $phone);
}
function CZMail($to, $subjc, $text, $froma){
$headers ="From: $froma\nReply-To: $froma\n";
$headers.="MIME-Version: 1.0\nContent-Type: text/plain; charset=\"windows-1250\"\nContent-Transfer-Encoding: 8bit\n";
return @Mail($to, $subjc, $text, $headers);
}
function codeToEncoding($code)
{
switch ($code){
case 'iso': return 'ISO-8859-2';
case 'win': return 'CP1250';
case 'asc': return 'ISO-8859-1';
case 'utf': return 'UTF-8';
}
return $code;
}
function AutoCzech($str, $code)
{
$win = array ('Á','Č','Ď','É','Ě','Í','Ň','Ó','Ř','','','Ú','Ů','Ý','','á','č','ď','é','ě','í','ň','ó','ř','','','ú','ů','ý','');
$iso = array ('Á','Č','Ď','É','Ě','Í','Ň','Ó','Ř','Š','Ť','Ú','Ů','Ý','Ž','á','č','ď','é','ě','í','ň','ó','ř','š','ť','ú','ů','ý','ž');
$utf = array("\xc3\x81", "\xc3\x88", "\xc3\x8f", "\xc3\x89", "\xc3\x83", "\xc3\x8d", "\xc3\x92", "\xc3\x93", "\xc3\x98", "\xc5\xa0", "\xc2\x8d", "\xc3\x9a", "\xc3\x99", "\xc3\x9d", "\xc5\xbd","\xc3\xa1", "\xc3\xa8", "\xc3\xaf", "\xc3\xa9", "\xc3\xac", "\xc3\xad", "\xc3\xb2", "\xc3\xb3", "\xc3\xb8", "\xc5\xa1", "\xc2\x9d", "\xc3\xba", "\xc3\xb9", "\xc3\xbd", "\xc5\xbe");
// pocty
$_win=0;
$_iso=0;
$_utf=0;
// spocitam pocet vyskytu v retezci
for ($i = 0; $i < 30; $i++){
$_win+=substr_count($str,$win[$i]);
$_iso+=substr_count($str,$iso[$i]);
$_utf+=substr_count($str,$utf[$i]);
}
// nejvyssi vyskyt
if ($_utf>0) return iconv('UTF-8',codeToEncoding($code),$str);
if ($_iso>=$_win && $_iso>0) return iconv('ISO-8859-2',codeToEncoding($code),$str);
if ($_win>=$_iso && $_win>0) return iconv('CP1250',codeToEncoding($code),$str);
return $str;
//return iconv('UTF-8',codeToEncoding($code),$str);
}
function udelej_ikonku_k_souboru($file,$nazev){
global $_url_adresa_webu;
$file=strtolower($file);
$ext=explode('.',$file);
$ext=$ext[1];
$s='';
switch($ext){
case 'doc': {$s=$_url_adresa_webu.'data/img/wrd.gif'; break;}
case 'pdf': {$s=$_url_adresa_webu.'data/img/acrobat.gif'; break;}
}
if($s=='')return $nazev; else return '
';
}
//------------------------------------------------------------
function jde_o_jmeno_adresare($str) {
return eregi("^([a-z0-9_-]*)$",$str);
}
if($lan=='CZ'||$lan=='')$seo_link=$seo_odkaz; else $seo_link='seo_odkaz_'.$lan;
function zjisti_zda_je_adresar_volny_($_jde_o,$id,$adresar,$lan){
$id+=0;
global $settings,$_url_adresa_webu,$seo_odkaz;
if($adresar!=''){
if($_jde_o==1){ //- rubriky
$vysledek_a=mysql_query("select id from ".$settings['db_table_name']."rubriky where id<>'".$id."' and ".$seo_link."='".$adresar."' ");
$vysledek_b=mysql_query("select id from ".$settings['db_table_name']."SHOP_ZBOZI where ".$seo_link."='".$adresar."' ");
$vysledek_c=mysql_query("select id from ".$settings['db_table_name']."clanky where ".$seo_link."='".$adresar."' ");
// $vysledek_d=mysql_query("select id from ".$settings['db_table_name']."informace where ".$seo_link."='".$adresar."' ");
}
if($_jde_o==2){
$vysledek_a=mysql_query("select id from ".$settings['db_table_name']."rubriky where ".$seo_link."='".$adresar."' ");
$vysledek_c=mysql_query("select id from ".$settings['db_table_name']."SHOP_ZBOZI where id<>'".$id."' and ".$seo_link."='".$adresar."' ");
$vysledek_b=mysql_query("select id from ".$settings['db_table_name']."clanky where ".$seo_link."='".$adresar."' ");
// $vysledek_d=mysql_query("select id from ".$settings['db_table_name']."informace where ".$seo_link."='".$adresar."' ");
}
if($_jde_o==3){
$vysledek_a=mysql_query("select id from ".$settings['db_table_name']."rubriky where ".$seo_link."='".$adresar."' ");
$vysledek_c=mysql_query("select id from ".$settings['db_table_name']."SHOP_ZBOZI where ".$seo_link."='".$adresar."' ");
$vysledek_b=mysql_query("select id from ".$settings['db_table_name']."clanky where id<>'".$id."' and ".$seo_link."='".$adresar."' ");
// $vysledek_d=mysql_query("select id from ".$settings['db_table_name']."informace where ".$seo_link."='".$adresar."' ");
}
if($_jde_o==4){
$vysledek_a=mysql_query("select id from ".$settings['db_table_name']."rubriky where ".$seo_link."='".$adresar."' ");
$vysledek_b=mysql_query("select id from ".$settings['db_table_name']."SHOP_ZBOZI where ".$seo_link."='".$adresar."' ");
$vysledek_c=mysql_query("select id from ".$settings['db_table_name']."clanky where ".$seo_link."='".$adresar."' ");
// $vysledek_d=mysql_query("select id from ".$settings['db_table_name']."informace where id<>'".$id."' and ".$seo_link."='".$adresar."' ");
}
if(@mysql_num_rows($vysledek_a)==0&&@mysql_num_rows($vysledek_b)==0&&@mysql_num_rows($vysledek_c)==0)return true; else return false;
}else{ return true;}
}
function jmeno_vyrobce($id){
global $settings,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_VYROBCE where id = '".$id."'")or die(mysql_error());
if(mysql_num_rows($vysledek)==1){
return @mysql_result($vysledek,0,'nazev_'.$lan);
}else{
return '';
}
}
function stav_skladu($id){
global $settings,$lan;
switch ($id){
case 1:{ return t__sklad_neni; break; }
case 2:{ return t__sklad_je; break; }
case 3:{ return t__sklad_bude; break; }
case 4:{ return t__sklad_dalsi1; break; }
}}
function logo_vyrobce($id){
global $settings,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_VYROBCE where id = '".$id."'")or die(mysql_error());
if(mysql_num_rows($vysledek)==1){
return @mysql_result($vysledek,0,'logo');
}else{
return '';
}
}
function jmeno_zbozi($id,$data=0){
global $settings,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
$text= $zaznam['nazev_'.$lan];
}
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI_DETAIL_CENY where id='".$data."'");
while($zaznam=mysql_fetch_array($vysledek)){
$text.=' - '.$zaznam['popis_ceny'];
}
return $text;
}
function url_zbozi($id){
global $settings,$lan,$_url_adresa_webu,$seo_link;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam[$seo_link]!='')$url=$_url_adresa_webu.$zaznam[$seo_link].'/';
else
$url=$_url_adresa_webu.'?zbozi='.$zaznam['id'];
return $url;
}
}
function obrazek_zbozi($id){
global $settings,$lan,$_url_adresa_webu;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
return $_url_adresa_webu.$zaznam['obrazek_min'];
}
}
function cena_zbozi($id){
global $settings,$lan,$_SESSION;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($_SESSION['vip_zakaznik']==1){
$cena_s_dph=$zaznam['vip_cena'];
}else
if($zaznam['akce_cena']<>0){
$cena_s_dph=$zaznam['akce_cena'];
}else{
$cena_s_dph=$zaznam['cena'];
}
}
return $cena_s_dph;
}
function cena_zbozi_det($id){
global $settings,$lan,$_SESSION;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI_DETAIL_CENY where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($_SESSION['vip_zakaznik']==1){
$cena_s_dph=$zaznam['vip_cena'];
}else
if($zaznam['akce_cena']<>0){
$cena_s_dph=$zaznam['akce_cena'];
}else{
$cena_s_dph=$zaznam['cena'];
}
}
return $cena_s_dph;
}
function cena_zbozi___bez_dph($id){
global $settings,$lan,$_SESSION;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($_SESSION['vip_zakaznik']==1){
$cena=$zaznam['vip_cena_bez_dph'];
}else
if($zaznam['akce_cena_bez_dph']<>0){
$cena=$zaznam['akce_cena_bez_dph'];
}else{
$cena=$zaznam['cena_bez_dph'];
}
}
return $cena;
}
function cena_zbozi_det___bez_dph($id){
global $settings,$lan,$_SESSION;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."SHOP_ZBOZI_DETAIL_CENY where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($_SESSION['vip_zakaznik']==1){
$cena=$zaznam['vip_cena_bez_dph'];
}else
if($zaznam['akce_cena_bez_dph']<>0){
$cena=$zaznam['akce_cena_bez_dph'];
}else{
$cena=$zaznam['cena_bez_dph'];
}
}
return $cena;
}
function is_email($email) {
return eregi("^[a-z\'0-9]+([._-][a-z\'0-9]+)*@([a-z0-9]+([._-][a-z0-9]+))+$",$email);
}
function udelej_mezi_rub($id){
global $settings,$lan,$_url_adresa_webu,$seo_link;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam[$seo_link]!='')$url=$_url_adresa_webu.str_replace('//','/',zjisti_pod_rubriky_seo($zaznam['id']).'/');
if($zaznam['rodic_id']>4)
return udelej_mezi_rub($zaznam['rodic_id']).' ť '.$zaznam['nazev_'.$lan].'';
else
return ' ť '.$zaznam['nazev_'.$lan].'';
}
}
function zjisti_description_rubriku($id){
global $settings,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam['rodic_id']==0||$zaznam['description_'.$lan]!='') return $zaznam['description_'.$lan];
else return zjisti_description_rubriku(zjisti_basic_rubriku($zaznam['rodic_id']));
}}
function zjisti_keywords_rubriku($id){
global $settings,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam['rodic_id']==0||$zaznam['keywords_'.$lan]!='') return $zaznam['keywords_'.$lan];
else return zjisti_description_rubriku(zjisti_basic_rubriku($zaznam['rodic_id']));
}}
function zjisti_basic_rubriku($id){
global $settings;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam['rodic_id']==0) return $zaznam['id'];
else return zjisti_basic_rubriku($zaznam['rodic_id']);
}}
function zjisti_basic_rubriku_d($id){
global $settings;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam['rodic_id']==zjisti_basic_rubriku($zaznam['rodic_id'])) return $zaznam['id'];
else return zjisti_basic_rubriku_d($zaznam['rodic_id']);
}}
function zjisti_pod_rubriky_sql($id,$cols_name){
global $settings;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where rodic_id='".$id."'");
$data ='';
while($zaznam=mysql_fetch_array($vysledek)){
$data .= zjisti_pod_rubriky_sql($zaznam['id'],$cols_name)." or ".$cols_name."='".$zaznam['id']."' ";
}
return $data ;
}
function zjisti_pod_rubriky_seo($id){
global $settings,$seo_link;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
$data ='';
if(mysql_num_rows($vysledek)==1)
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam[$seo_link]!='')
$data.= zjisti_pod_rubriky_seo($zaznam['rodic_id']).$zaznam[$seo_link];
}
if($data=='')
return false;
else
return $data.'/';
}
function zjisti_pod_rubriky_nazvy($id){
global $settings,$seo_link,$lan;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
if($zaznam['rodic_id']>4)
return zjisti_pod_rubriky_nazvy($zaznam['rodic_id']).', '.$zaznam['nadpis_'.$lan];
else return $zaznam['nadpis_'.$lan];
}}
function zjisti_pod_rubriky_id($id){
global $settings,$seo_link;
$vysledek=mysql_query("select * from ".$settings['db_table_name']."rubriky where id='".$id."'");
while($zaznam=mysql_fetch_array($vysledek)){
return zjisti_pod_rubriky_id($zaznam['rodic_id']).','.$zaznam['id'];
}}
function pocet_stroju_v_rubrice($id){
global $settings;
$vysledek=mysql_query("select id from ".$settings['db_table_name']."SHOP_ZBOZI where zobrazovat=1 and ( rodic_id='".$id."'".zjisti_pod_rubriky_sql($id,'rodic_id')." ) ");
return mysql_num_rows($vysledek);
}
function udelej_strankovani($url,$str,$strankovat_po,$pocet_clanku)
{
// 'index.php?rubrika='.$_GET['rubrika'].'&str=',$str,$strankovat_po,$pocet_novinek
$kolik=ceil($pocet_clanku/$strankovat_po);
if($kolik>1)
for($i=0;$i<$kolik;$i++){
if($i==$str){
echo ' '.($i+1).' ';
}else{
echo ' '.($i+1).' ';
}
}
}
function obrazek_zbozi_img($id){
global $_url_adresa_webu,$settings;
$vysledek=mysql_query("select obrazek_min from ".$settings['db_table_name']."SHOP_ZBOZI where zobrazovat=1 and id='".$id."' ");
$obrazek =trim(@mysql_result($vysledek,0,'obrazek_min'));
$return='';
if($obrazek!=''){
$return='
';
}
return $return;
}
function udelej_selec_box_kategorii_url($id,$id_select,$no,$onchange){?>
}
function vypsani_kategorii_url($id_posledni,$pocet_odskoku,$id_select,$no){
global $settings,$_url_adresa_webu;
global $id_r;
global $odskoku;
global $seo_odkaz;
$lan='CZ';
$seo_odkaz;
if($lan=='CZ')$seo_link=$seo_odkaz; else $seo_link='seo_odkaz_'.$lan;
$vysledek=Mysql_query("select * from ".$settings['db_table_name']."rubriky where rodic_id='".$id_posledni."' order by poradi") or die(mysql_error());
while($zaznam=mysql_fetch_array($vysledek)){
//global $id_select;
if($no!=$zaznam[id]){
$url=$_url_adresa_webu.strtolower($lan).'/'.$zaznam[$seo_link].'/';
echo '';
$odskoku++;
vypsani_kategorii_url($zaznam[id],$odskoku,$id_select,$no);
$odskoku--;
}
} //$odskoku=0;
}
?>