<?

$host = "localhost";


$user = "praguein_www2";


$pass = "h3TjfhhtSTLvET5h/";


$dbf = "praguein_www2";

//echo 'Hello world pred';

$mysql = new mysqli($host, $user, $pass, $dbf);

//echo 'Hello world za';


$mysql->query("SET NAMES utf8");


$mysql->query("SET character_set_results=\"utf8\"");


$mysql->query("SET character_set_client=\"utf8\"");


$mysql->query("SET character_set_connection=\"utf8\"");


if(@file_exists("./class/general.php"))

	
	require_once "./class/general.php";


else

	if(@file_exists("../class/general.php"))

		
	require_once "../class/general.php";

?><?
function overEmail($email)
{
	$reg_email = "^((([a-z]|[0-9]|!|#|$|%|&|'|\*|\+|\-|/|=|\?|\^|_|`|\{|\||\}|~)+(\.([a-z]|[0-9]|!|#|$|%|&|'|\*|\+|\-|/|=|\?|\^|_|`|\{|\||\}|~)+)*)@((((([a-z]|[0-9])([a-z]|[0-9]|\-){0,61}([a-z]|[0-9])\.))*([a-z]|[0-9])([a-z]|[0-9]|\-){0,61}([a-z]|[0-9])\.(af|ax|al|dz|as|ad|ao|ai|aq|ag|ar|am|aw|au|at|az|bs|bh|bd|bb|by|be|bz|bj|bm|bt|bo|ba|bw|bv|br|io|bn|bg|bf|bi|kh|cm|ca|cv|ky|cf|td|cl|cn|cx|cc|co|km|cg|cd|ck|cr|ci|hr|cu|cy|cz|dk|dj|dm|do|ec|eg|sv|gq|er|ee|et|fk|fo|fj|fi|fr|gf|pf|tf|ga|gm|ge|de|gh|gi|gr|gl|gd|gp|gu|gt| gg|gn|gw|gy|ht|hm|va|hn|hk|hu|is|in|id|ir|iq|ie|im|il|it|jm|jp|je|jo|kz|ke|ki|kp|kr|kw|kg|la|lv|lb|ls|lr|ly|li|lt|lu|mo|mk|mg|mw|my|mv|ml|mt|mh|mq|mr|mu|yt|mx|fm|md|mc|mn|ms|ma|mz|mm|na|nr|np|nl|an|nc|nz|ni|ne|ng|nu|nf|mp|no|om|pk|pw|ps|pa|pg|py|pe|ph|pn|pl|pt|pr|qa|re|ro|ru|rw|sh|kn|lc|pm|vc|ws|sm|st|sa|sn|cs|sc|sl|sg|sk|si|sb|so|za|gs|es|lk|sd|sr|sj|sz|se|ch|sy|tw|tj|tz|th|tl|tg|tk|to|tt|tn|tr|tm|tc|tv|ug|ua|ae|gb|us|um|uy|uz|vu|ve|vn|vg|vi|wf|eh|ye|zm|zw|eu|com|edu|gov|int|mil|net|org|biz|info|name|pro|aero|coop|museum|arpa))|(((([0-9]){1,3}\.){3}([0-9]){1,3}))|(\[((([0-9]){1,3}\.){3}([0-9]){1,3})\])))$";
	if(eRegI($reg_email,$email))
		return true;
	else
		return false;
}
function stringToDate($stringDate)
{
	$expDatum=explode(".",$stringDate);
	$d=(int) $expDatum[0];
	$m=(int) $expDatum[1];
	$r=(int) $expDatum[2];
	$intDate=mktime(0,0,0,$m,$d,$r);
	if($intDate==-1)
		return '0000-00-00';
	else
	{
		if(strLen($m)<2) $m = "0".$m;
		if(strLen($d)<2) $d = "0".$d;
		return $r.'-'.$m.'-'.$d;
	}
}

function dateToString($date)
{
	$expDatum=explode("-",$date);
	$d=(int) $expDatum[2];
	$m=(int) $expDatum[1];
	$r=(int) $expDatum[0];
	$intDate=mktime(0,0,0,$m,$d,$r);
	if($intDate==-1)
		return '';
	else
		return $d.'.'.$m.'.'.$r;
}

function dateToStringM($date)
{
	$expDatum=explode("-",$date);
	$d=(int) $expDatum[2];
	$m=(int) $expDatum[1];
	$r=(int) $expDatum[0];
	$intDate=mktime(0,0,0,$m,$d,$r);
	if($intDate==-1)
		return '';
	else
		return $d.'.'.$m.'.';
}

function zkracenyText($text,$delka)
{
	if(strLen($text) > $delka)
		return subStr($text,0,$delka)." ...";
	else
		return $text;
}

function zobrazCena($value, $sleva_klient = 0)
{
	if($value == 0):
		return "";
	else:
		list($whole, $decimals) = split ('[.,]', $value, 2);
                $value = $value*((100-$sleva_klient)/100);
                if (intval($decimals) > 0)
			return number_format($value,2,","," ")." Kč";
		else
			return number_format($value,0,","," ") .",- Kč";
	endif;
}

function zobrazCenaNC($value)
{
	if($value == 0):
		return "";
	else:
		list($whole, $decimals) = split ('[.,]', $value, 2);
		if (intval($decimals) > 0)
			return number_format($value,2,","," ");
		else
			return number_format($value,0,","," ") .",-";
	endif;
}

function cenaKurzu($kurz,$mysql,$sleva_navic=0)
{
	$glob = $mysql->prepare("SELECT hodnota FROM a_nastaveni WHERE vlastnost='globalni_sleva'");
	$glob->execute();
	$glob->bind_result($sleva_glob);
	$glob->fetch();
	$glob->free_result();
	
	$slevy = $mysql->prepare("SELECT k.cena,k.sleva,kat.sleva FROM kurz_verejnost k JOIN kurz_kategorie kat ON k.id_kategorie=kat.id WHERE k.id=? GROUP BY k.id");
	$slevy->bind_param("i",$kurz);
	$slevy->execute();
	$slevy->bind_result($cena_kurz,$sleva_kurz,$sleva_kat);
	$slevy->fetch();
	$slevy->free_result();
	
	if(empty($sleva_glob))
		$sleva_glob = 0;
	
	$sleva = 0;
	if($sleva_kurz)
		$sleva = $sleva_kurz;
	else
		if($sleva_kat)
			$sleva = $sleva_kat;
		else
			if($sleva_glob)
				$sleva = $sleva_glob;
	
	if($sleva)
		$sleva_zakl_proc = $sleva;
	else
		$sleva_zakl_proc = 0;
	
	if($sleva_navic)
		$sleva_vernost_proc = $sleva_navic;
	
	if($sleva)
	{
		$koef = $sleva / 100;				
		$sleva_zakl = $cena_kurz * $koef;		
		$sleva_z = $sleva_zakl / 10;				
		if(round($sleva_z) != $sleva_z)		
			$sleva_z = floor($sleva_z)+1;	
		$sleva_z = $sleva_z * 10;			
		$sleva_zakl = $sleva_z;					
	}
	else
		$sleva_zakl = 0;
	
//	if($sleva_navic)
//	{
//		$koef = $sleva_navic / 100;				
//		//$sleva_vernost = $cena_kurz * $koef; // sleva za vernost by se mela pocitat z uz snizene castky
//		$sleva_vernost = ($cena_kurz-$sleva_zakl)*$koef;
//		$sleva_z = $sleva_vernost / 10;				
//		if(round($sleva_z) != $sleva_z)		
//			$sleva_z = floor($sleva_z)+1;	
//		$sleva_z = $sleva_z * 10;			
//		$sleva_vernost = $sleva_z;					
//	}
//	else
//		$sleva_vernost = 0;
	
//	$sleva = $sleva_zakl + $sleva_vernost;
	$sleva = $sleva_zakl;
	
	$cena_konec = $cena_kurz - $sleva;
        $cena_konec_pred_vernostni_slevou = $cena_konec;
        $cena_konec = $sleva_navic != 0 ? $cena_konec*((100-$sleva_navic)/100) : $cena_konec;
//	$cena_konec = floor($cena_konec / 10) * 10;
	$cena_konec = floor($cena_konec);
	
        $sleva_vernost = $cena_konec_pred_vernostni_slevou - $cena_konec;
        
//        $cena->kurz = $cena_kurz;
//	$cena->sleva = $sleva;
//	$cena->konec = $cena_konec;
//	$cena->sleva_zakl = $sleva_zakl;
//	$cena->sleva_vernost = $sleva_vernost;
//	$cena->sleva_zakl_proc = $sleva_zakl_proc;
//	$cena->sleva_vernost_proc = $sleva_vernost_proc;
	
        $cena = new Cena($cena_kurz, $sleva, $cena_konec, $sleva_zakl, $sleva_vernost, $sleva_zakl_proc, $sleva_vernost_proc);
        
	return $cena;
}

function getImgPaddingStyle($obrazek,$def_padding,$width,$height,$unit='px') {
 $imagesize=getimagesize($obrazek);

 if (($width/$height)>($imagesize[0]/$imagesize[1])) {
  $h=$height;
  $w=(int) (($height * $imagesize[0]) / $imagesize[1]);
 } else {
  $w=$width;
  $h=(int) (($width * $imagesize[1]) / $imagesize[0] );
 }

 $horiz=2*$def_padding+($width-$w);
 $vert=2*$def_padding+($height-$h);
 $padding_left=floor($horiz/2);
 $padding_top=floor($vert/2);

 return('padding: '.$padding_top.$unit.' '.($horiz-$padding_left).$unit.' '.($vert-$padding_top).$unit.' '.$padding_left.$unit.';');
}

function formatText($s) {
	return(str_replace("\n",'<br />',$s));
}

function SEO($string)
{
	 $table = array(
        'Š'=>'S', 'š'=>'s', 'Đ'=>'Dj', 'đ'=>'dj', 'Ž'=>'Z', 'ž'=>'z', 'Č'=>'C', 'č'=>'c', 'Ć'=>'C', 'ć'=>'c',
        'À'=>'A', 'Á'=>'A', 'Â'=>'A', 'Ã'=>'A', 'Ä'=>'A', 'Å'=>'A', 'Æ'=>'A', 'Ç'=>'C', 'È'=>'E', 'É'=>'E',
        'Ê'=>'E', 'Ë'=>'E', 'Ì'=>'I', 'Í'=>'I', 'Î'=>'I', 'Ï'=>'I', 'Ñ'=>'N', 'Ò'=>'O', 'Ó'=>'O', 'Ô'=>'O',
        'Õ'=>'O', 'Ö'=>'O', 'Ø'=>'O', 'Ù'=>'U', 'Ú'=>'U', 'Û'=>'U', 'Ü'=>'U', 'Ý'=>'Y', 'Þ'=>'B', 'ß'=>'Ss',
        'à'=>'a', 'á'=>'a', 'â'=>'a', 'ã'=>'a', 'ä'=>'a', 'å'=>'a', 'æ'=>'a', 'ç'=>'c', 'è'=>'e', 'é'=>'e',
        'ê'=>'e', 'ë'=>'e', 'ì'=>'i', 'í'=>'i', 'î'=>'i', 'ï'=>'i', 'ð'=>'o', 'ñ'=>'n', 'ò'=>'o', 'ó'=>'o',
        'ô'=>'o', 'õ'=>'o', 'ö'=>'o', 'ø'=>'o', 'ù'=>'u', 'ú'=>'u', 'û'=>'u', 'ý'=>'y', 'ý'=>'y', 'þ'=>'b',
        'ÿ'=>'y', 'Ŕ'=>'R', 'ŕ'=>'r', 'ř'=>'r', 'Ř'=>'R', 'Ě'=>'E', 'ě'=>'e', 'ů'=>'u', 'Ů'=>'U', 'Ď'=>'D',
        'ď'=>'d', 'Ť'=>'T', 'ť'=>'t', 'Ň'=>'N', 'ň'=>'n' 
    );                                                                                  
  $string=str_replace("&amp;","-",$string); 
  $string=strtr($string, $table);
	$NEakceptovatelneZnaky_regvyr = '#[^-a-zA-Z0-9 ]#';
	$string = preg_replace( $NEakceptovatelneZnaky_regvyr, '', $string);
	$string = trim($string);
	$string = preg_replace('#[-_ ]+#', '-', $string);
	$string = strtolower($string);
	return $string;
}

function cropLongText($text, $limit, $cutLastWord = false) {
// $text - text $limit - pocet zobrazenych znaku (posledni roztrzene slovo vynechano)
    $text = strip_tags($text);
    if (strlen($text) <= $limit) {
        return $text;
    } else {
        $text = substr($text, 0, $limit + 1);
        if($cutLastWord)
            return $text . "...";
        $pos = strrpos($text, " ");
        return substr($text, 0, ($pos ? $pos : -1)) . " ...";
    }
}

function generateRandomString($length = 10, $numeric = true) {
    $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $numeric ? $characters = '0123456789'.$characters : null;
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}


class Cena {
    var $kurz, $sleva, $konec, $sleva_zakl, $sleva_vernost, $sleva_zakl_proc, $sleva_vernost_proc;
    public function __construct($kurz, $sleva, $konec, $sleva_zakl, $sleva_vernost, $sleva_zakl_proc, $sleva_vernost_proc) {
        $this->kurz = $kurz;
        $this->sleva = $sleva;
        $this->konec = $konec;
        $this->sleva_zakl = $sleva_zakl;
        $this->sleva_vernost = $sleva_vernost;
        $this->sleva_zakl_proc = $sleva_zakl_proc;
        $this->sleva_vernost_proc = $sleva_vernost_proc;
    }
    
    public function getCena(){
        return $this;
    }
}


?>
<br />
<b>Fatal error</b>:  Class 'nastaveni' not found in <b>/data/www/pragueinstitute_cz/www2/_hlavicka.php</b> on line <b>16</b><br />