No input data!
';
}
}
function slashes($str) {
if(get_magic_quotes_gpc()) return $str;
else return addslashes($str);
}
function navigation($offset,$total,$count,$url,$previous='',$next='') {
$tag = '';
$offset+=0;
$total+=0;
$count+=0;
if($total < 0) $total = 0;
if($offset < 0) $offset = 0;
if($offset > $total) $offset = $total;
if($count < 1) $count = 1;
if($total > $count) {
if(empty($previous)) $previous = '
';
if(empty($next)) $next = '
';
if($offset > 0) $tag .= ''.$previous.' ';
else $tag .= $previous.' ';
$tag .= '';
if($offset+$count < $total) $tag .= ' '.$next.'';
else $tag .= ' '.$next;
}
return $tag;
}
function czTxtDate($date) {
$mesic = array(
1 => 'ledna',
2 => 'února',
3 => 'března',
4 => 'dubna',
5 => 'kvěna',
6 => 'června',
7 => 'července',
8 => 'srpna',
9 => 'září',
10 => 'října',
11 => 'listopadu',
12 => 'prosince'
);
list($date,$time) = split(" ",$date);
list($year,$month,$day) = split("-",$date);
$year+=0;
$month+=0;
$day+=0;
if(checkdate($month,$day,$year)) {
return $day.'. '.$mesic[$month].' '.$year.' '.$time;
} else {
return '';
}
}
function showOrderArrow($href,$text,$current,$this) {
if(abs($current) == $this) {
if($current > 0) {
return ''.$text.' 
';
} else {
return ''.$text.' 
';
}
} else {
return ''.$text.'';
}
}
function czDate($date) {
return ereg_replace("^([0-9]{4})-([0-9]{2})-([0-9]{2})$","\\3.\\2.\\1", $date);
}
function dbDate($date) {
if(ereg("^([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date)) return ereg_replace("^([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})(.*)$","\\3.\\2.\\1", $date);
else return 'NULL';
}
function processDateTime($year,$month,$day,$hour,$minute,$second) {
if($year < 1980 || $year > 2222) $year = date('Y');
if($month < 1 || $month > 12) $month = date('m');
if($year < 1 || $year > 31) $year = date('d');
if($year < 0 || $year > 23) $year = date('H');
if($year < 0 || $year > 59) $year = date('i');
if($year < 0 || $year > 59) $year = date('s');
return "$year-$month-$day $hour:$minute:$second";
}
function phoneFormat($number) {
if(strlen($number) == 12) {
if(substr($number,0,2) == '42') return '(+'.substr($number,0,3).') '.substr($number,3,3).' '.substr($number,6,3).' '.substr($number,9,3);
else return ereg_replace("[0-9]{3}","\\1 ",$number);
} else {
return $number;
}
}
function validateEmail($email) {
return eregi("^[a-z]+[0-9a-z_.-]*@[0-9a-z_.-]+\.[a-z]{2,4}$",$email);
}
function emailHref($email) {
if(validateEmail($email)) {
return ''.$email.'';
} else {
return $email;
}
}
function genpwd() {
$pass = '';
for($i=0;$i<8;$i++) {
if($i == 0 || $i == 1 || $i == 4 || $i == 5) {
$pass .= chr(rand(97,122));
} else {
$pass .= chr(rand(48,57));
}
}
return $pass;
}
function image_type_to_extension_custom($imagetype)
{
if(empty($imagetype)) return false;
switch($imagetype)
{
case IMAGETYPE_GIF : return 'gif';
case IMAGETYPE_JPEG : return 'jpg';
case IMAGETYPE_PNG : return 'png';
case IMAGETYPE_SWF : return 'swf';
case IMAGETYPE_PSD : return 'psd';
case IMAGETYPE_WBMP : return 'wbmp';
case IMAGETYPE_XBM : return 'xbm';
case IMAGETYPE_TIFF_II : return 'tiff';
case IMAGETYPE_TIFF_MM : return 'tiff';
case IMAGETYPE_IFF : return 'aiff';
case IMAGETYPE_JB2 : return 'jb2';
case IMAGETYPE_JPC : return 'jpc';
case IMAGETYPE_JP2 : return 'jp2';
case IMAGETYPE_JPX : return 'jpf';
case IMAGETYPE_SWC : return 'swc';
default : return false;
}
}
function sortItemsCategories($category = NULL){
global $sql;
if(empty($category)){
$result = $sql->query("
SELECT category_id, count(*), max(orderby), min(orderby)
FROM items_categories_assoc
GROUP BY category_id
");
if($result->hr()){
while($p = $result->fa()){
$i = 0;
if($p['min'] != 0 || ($p['max'] + 1) != $p['min']){
$cat = $p['category_id'];
$r2 = $sql->query("SELECT item_id FROM items_categories_assoc WHERE category_id = $cat ORDER BY orderby");
while($row = $r2->fa()){
$sql->query("
UPDATE items_categories_assoc
SET orderby = $i
WHERE item_id = ".$row['item_id']."
AND category_id = $cat
");
$i++;
}
}
}
}
}else{
$result = $sql->query("
SELECT item_id
FROM items_categories_assoc
WHERE category_id = $category
ORDER BY orderby
");
if($result->hr()){
$i = 0;
while($pole = $result->fa()){
$item_id = $pole['item_id'];
$sql->query("
UPDATE items_categories_assoc
SET orderby = $i
WHERE item_id = $item_id
AND category_id = $category
");
$i++;
}
}
}
}
function sortItemsSubcategories($subcategory = NULL){
global $sql;
if(empty($subcategory)){
$result = $sql->query("
SELECT subcategory_id, count(*), max(orderby), min(orderby)
FROM items_subcategories_assoc
GROUP BY subcategory_id
");
if($result->hr()){
while($p = $result->fa()){
$i = 0;
if($p['min'] != 0 || ($p['max'] + 1) != $p['min']){
$cat = $p['subcategory_id'];
$r2 = $sql->query("SELECT item_id FROM items_subcategories_assoc WHERE subcategory_id = $cat ORDER BY orderby");
while($row = $r2-> fa()){
$sql->query("
UPDATE items_subcategories_assoc
SET orderby = $i
WHERE item_id = ".$row['item_id']."
AND subcategory_id = $cat
");
$i++;
}
}
}
}
}else{
$result = $sql->query("
SELECT item_id
FROM items_subcategories_assoc
WHERE subcategory_id = $subcategory
ORDER BY orderby
");
if($result->hr()){
$i = 0;
while($pole = $result->fa()){
$item_id = $pole['item_id'];
$sql->query("
UPDATE items_subcategories_assoc
SET orderby = $i
WHERE item_id = $item_id
AND subcategory_id = $subcategory
");
$i++;
}
}
}
}
function get_request($name){
return slashes($_REQUEST[$name]);
}
function string_2_url($text){
$dch = array("á", "č", "ď", "é", "ě", "í", "ň", "ó", "ř", "š", "ť", "ú", "ů", "ý", "ž", " - ", " ");
$wch = array("a", "c", "d", "e", "e", "i", "n", "o", "r", "s", "t", "u", "u", "y", "z", "-", "-");
$text = mb_strtolower($text, "UTF-8");
$text = str_replace($dch, $wch, $text);
$text = urlencode($text);
return $text;
}
function item_url($item_id){
global $sql;
$sql_query = "";
$sql_query .= "SELECT rewrite_cat.url AS url1, rewrite_subcat.url AS url2";
$sql_query .= " FROM rewrite_cat, rewrite_subcat, subcategories, items_subcategories_assoc";
$sql_query .= " WHERE items_subcategories_assoc.subcategory_id = subcategories.subcategory_id";
$sql_query .= " AND subcategories.subcategory_id = rewrite_subcat.subcategory_id";
$sql_query .= " AND subcategories.category_id = rewrite_cat.category_id";
$sql_query .= " AND items_subcategories_assoc.item_id = $item_id";
$q = $sql->query($sql_query);
if($q->hr() && $row = $q->fa()){
return '/'.$row['url1'].'/'.$row['url2'].'/'.$item_id;
}else{
return false;
}
}
function category_url($category_id){
global $sql;
$query = $sql->query("SELECT url FROM rewrite_cat WHERE category_id = $category_id");
if($row = $query->fa()){
$url = $row['url'];
return '/'.$url.'/';
}
}
function subcategory_url($subcategory_id){
global $sql;
$sql_query = "";
$sql_query .= "SELECT rewrite_cat.url AS url1, rewrite_subcat.url AS url2";
$sql_query .= " FROM rewrite_cat, rewrite_subcat, subcategories";
$sql_query .= " WHERE rewrite_subcat.subcategory_id = subcategories.subcategory_id";
$sql_query .= " AND subcategories.category_id = rewrite_cat.category_id";
$sql_query .= " AND rewrite_subcat.subcategory_id = $subcategory_id";
$query = $sql->query($sql_query);
if($row = $query->fa()){
$url1 = $row['url1'];
$url2 = $row['url2'];
return "/$url1/$url2/";
}
}
function parse_url_obchod(){
global $sql;
$url = $_SERVER['REQUEST_URI'];
$parts = explode('/', $url);
if(!empty($parts[2])){
$subcat_url = slashes($parts[2]);
$sql_query = "";
$sql_query .= "SELECT rewrite_subcat.subcategory_id AS subcategory_id, rewrite_cat.category_id AS category_id, rewrite_cat.url AS url";
$sql_query .= " FROM rewrite_subcat, subcategories, rewrite_cat";
$sql_query .= " WHERE rewrite_subcat.subcategory_id = subcategories.subcategory_id";
$sql_query .= " AND subcategories.category_id = rewrite_cat.category_id";
$sql_query .= " AND rewrite_subcat.url = '$subcat_url'";
$query = $sql->query($sql_query);
if($query->hr() && $row = $query->fa()){
if($parts[1] != $row['url']){
//
return array(2, '/'.$row['url'].'/'.$parts[2].'/');
}else{
return array(0, $row['subcategory_id']);
}
}else{
return array(3);
}
}elseif(!empty($parts[1])){
$url = slashes($parts[1]);
$query = $sql->query("SELECT category_id FROM rewrite_cat WHERE url = '$url'");
if($query->hr() && $row = $query->fa()){
return array(1, $row['category_id']);
}else{
return array(3);
}
}
}
function convert_number_to_words_czech($number){
$number_txt = '';
$thousands .= 0;
//thousands
if($number > 999){
$thousands = floor($number / 1000);
if($thousands == 1){
$number_txt .= 'tisíc';
}elseif($thousands > 1 && $thousands < 5){
$number_txt .= number_to_words_small($thousands).'tisíce';
}else{
$number_txt .= number_to_words_small($thousands).'tisíc';
}
$number -= $thousands*1000;
}
$number_txt .= number_to_words_small($number);
return $number_txt;
}
function number_to_words_small($number){
$return = '';
if($number > 99){
$hundreds = floor($number/100);
switch($hundreds){
case 1:
$return .= "sto";
break;
case 2:
$return .= "dvěstě";
break;
case 3:
$return .= "třista";
break;
case 4:
$return .= "čtyřista";
break;
case 5:
$return .= "pětset";
break;
case 6:
$return .= "šestset";
break;
case 7:
$return .= "sedmset";
break;
case 8:
$return .= "osmset";
break;
case 9:
$return .= "devětset";
break;
}
$number -= $hundreds*100;
}
if($number > 9 && $number < 20){
switch($number){
case 10:
$return .= 'deset';
break;
case 11:
$return .= 'jedenáct';
break;
case 12:
$return .= 'dvanáct';
break;
case 13:
$return .= 'třináct';
break;
case 14:
$return .= 'čtrnáct';
break;
case 15:
$return .= 'patnáct';
break;
case 16:
$return .= 'šestnáct';
break;
case 17:
$return .= 'sedmnáct';
break;
case 18:
$return .= 'osmnáct';
break;
case 19:
$return .= 'devatenáct';
break;
}
}else{
//tens
$tens = floor($number/10);
switch($tens){
case 0:
$return .= '';
break;
case 2:
$return .= 'dvacet';
break;
case 3:
$return .= 'třicet';
break;
case 4:
$return .= 'čtyřicet';
break;
case 5:
$return .= 'padesát';
break;
case 6:
$return .= 'šedesát';
break;
case 7:
$return .= 'sedmdesát';
break;
case 8:
$return .= 'osmdesát';
break;
case 9:
$return .= 'devadesát';
break;
}
$number -= $tens*10;
//units
switch($number){
case 1:
$return .= 'jedna';
break;
case 2:
$return .= 'dva';
break;
case 3:
$return .= 'tři';
break;
case 4:
$return .= 'čtyř';
break;
case 5:
$return .= 'pět';
break;
case 6:
$return .= 'šest';
break;
case 7:
$return .= 'sedm';
break;
case 8:
$return .= 'osm';
break;
case 9:
$return .= 'devět';
break;
}
}
return $return;
}
function wrap_text($text, $length){
if(strlen($text) >= $length){
$string = mb_substr($text, 0, $length - 3);
$pos = mb_strrpos($string, ' ');
if($pos === false){
$zakladni_popis = $string.'...';
}else{
$zakladni_popis = mb_substr($string, 0, $pos).'...';
}
}else{
$zakladni_popis = $text;
}
return $zakladni_popis;
}
?>
Chyba přihlášení
';
exit;
}
function login($user,$pass,$sql) {
if(empty($user)) {
authenticate();
} else {
if(($user=="cesta" && $pass=="zapravdou") || ($user=="admin" && $pass="admin1")) {
return true;
} else {
authenticate();
}
}
}
$user = slashes($_SERVER['PHP_AUTH_USER']);
$pass = slashes($_SERVER['PHP_AUTH_PW']);
$userId = login($user,$pass,$sql);
?>