<?
require "inc/funkce.php";
require "inc/conf.php";
require "adm2/req/pass.php";

/*
get page & seo params by send url

get url & page ID & META:
1) check lang by /en/ ...
2) search last part of url in db: "url" table [url,table,id,lang]
3) set page ID,table name & meta
4) add other languages url of cur. page to lang links
*/

// conf types
$send_url = $_SERVER['REQUEST_URI'];

// def. get params
$get_m = false;

// check if url contain params (?)
$send_parms = $sql_main_get = false;
$pos = strpos($send_url, '?');
if ($pos !== false) {
	$tmp_arr = explode('?',$send_url);
	$send_url = trim($tmp_arr[0]);
	
	// handle params
	$send_parms = trim($tmp_arr[1]);
	$params_arr = explode('&',$send_parms);
	
	// main catogories
	foreach ($params_arr as $key => $value_get) {
		$value_get = urldecode($value_get);
		$tmp_value_arr = explode('=',$value_get);
		$value = $tmp_value_arr[1];
		$key = $tmp_value_arr[0];
		
		if ($value!='') {
			// send month
			if ($key=='m') {
        		$get_m = FixInt($value); // def->'cs'
			}
		}
	}
}

// conf types
if (substr($send_url,-1)=='/') $send_url = substr($send_url,0,-1);
$page_arr = explode('/',$send_url);
$url_pos = $page_arr[count($page_arr)-1]!='' ? 1 : 2; // detect '/' at last char
$page_link = $page_arr[count($page_arr)-$url_pos]; // detect page key
$page_lang = $page_arr[count($page_arr)-($url_pos+1)]; // detect page key
$page_id = $page_type = $page = $table = $title = $descr = $title_seo = $descr_seo = $page_top = $types_id = $breadcrumb = false;
$page_url_arr = $types_arr = $types_url_arr = $types_top_arr = $pages_arr = $pages_url_arr = $pages_top_arr = 
$data_url_arr = $menu_title_arr = $menu_url_arr = $footer_title_arr = $footer_text_arr = $footer_text2_arr = 
$header_title_arr = $header_text_arr = $header_text2_arr = array();

$homepage_id = 5;

// detect language
if ($page_link=='en' || $page_lang=='en') {
	$lang_sql_str = '1';
	$lang = 'en';
	$language_link = 'en/';
	
	include "inc/lang-en.php";
} else if ($page_link=='pl' || $page_lang=='pl') {
	$lang_sql_str = '2';
	$lang = 'pl';
	$language_link = 'pl/';
	
	include "inc/lang-pl.php";
} else {
	$lang_sql_str = '';
	$lang = 'cs';
	$language_link = 'cs/';
	
	include "inc/lang-cs.php";
}

// main catogories
if ($page_link == 'klavir.cz' || $page_link == 'index.php' || in_array($page_link,$conf_web_domains) || $page_link == '' || $page_link=='cs' || $page_link=='en' || $page_link=='pl') {
	$page = 'homepage';
	$page_url_arr = array('cs'=>'./','en'=>'./en/','pl'=>'./pl/');
	
	$table = 'klavesa';
	$page_id = $homepage_id;
	$i = 0;
	
	// for all pages read products pages for top menu (cache?)
	$sSql = "SELECT * FROM klavesa WHERE status='1' ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// if not set page icon use page title
		$ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam);
		$pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam);
		$pages_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam);
		
		// if set, add link to this page as subpage
		$pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam);
		
		// if this page == current -> set page type
		if ($zaznam['id']==$homepage_id) {
			$page_type = printSqlCol('idtypustranky',$zaznam);
			$page_top = printSqlCol('idhlavnistranky',$zaznam);
			
			if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$text = printSqlCol('popis'.$lang_sql_str,$zaznam);
			$text2 = printSqlCol('perex'.$lang_sql_str,$zaznam);
		}
		
		// header
		if ($zaznam['idtypustranky']==4) {
			$header_title_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$header_text_arr[] = strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam));
			$header_text2_arr[] = strip_tags(printSqlCol('perex'.$lang_sql_str,$zaznam));
		}
		
		// footer
		if ($zaznam['idtypustranky']==2) {
			$footer_title_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$footer_text_arr[] = printSqlCol('popis'.$lang_sql_str,$zaznam);
			$footer_text2_arr[] = printSqlCol('perex'.$lang_sql_str,$zaznam);
		}
		
		// kontakty
		if ($zaznam['id']==12) {
			$kontakty_title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$kontakty_text = printSqlCol('popis'.$lang_sql_str,$zaznam);
		}
	}
	
} else {
	
	// found url in db
	$sSql = "SELECT * FROM url WHERE url$lang_sql_str='$page_link'";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// page conf
		$page = printSqlCol('url'.$lang_sql_str,$zaznam);
		$page_id = printSqlCol('idzaznamu',$zaznam);
		$table = printSqlCol('tabulka',$zaznam);
		
		// links to other langs
		$page_url_arr = array('cs'=>$root.'cs/'.printSqlCol('url',$zaznam),'en'=>$root.'en/'.printSqlCol('url1',$zaznam),'pl'=>$root.'pl/'.printSqlCol('url2',$zaznam));
		
		// seo for cur. page in cur. lang
		$title_seo = printSqlCol('title'.$lang_sql_str,$zaznam);
		$descr_seo = printSqlCol('descr'.$lang_sql_str,$zaznam);
	}
	
	// for all pages read products pages for top menu (cache?)
	$sSql = "SELECT * FROM klavesa WHERE status='1' ORDER BY razeni";
	$vysledek = Pg_Exec($sSql);
	while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
		
		// if not set page icon use page title
		$ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam);
		$pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam);
		$pages_url_arr[$zaznam['id']] = printSqlCol('link'.$lang_sql_str,$zaznam);
		
		// if set, add link to this page as subpage
		$pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam);
		
		// if this page == current -> set page type
		if ($page_id>0 && $zaznam['id']==$page_id && $table=='klavesa') {
			$page_type = printSqlCol('idtypustranky',$zaznam);
			$page_top = printSqlCol('idhlavnistranky',$zaznam);
			
			if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$text = printSqlCol('popis'.$lang_sql_str,$zaznam);
			$text2 = printSqlCol('perex'.$lang_sql_str,$zaznam);
		}
		
		// header
		if ($zaznam['idtypustranky']==4) {
			$header_title_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$header_text_arr[] = strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam));
			$header_text2_arr[] = strip_tags(printSqlCol('perex'.$lang_sql_str,$zaznam));
		}
		
		// footer
		if ($zaznam['idtypustranky']==2) {
			$footer_title_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$footer_text_arr[] = printSqlCol('popis'.$lang_sql_str,$zaznam);
			$footer_text2_arr[] = printSqlCol('perex'.$lang_sql_str,$zaznam);
		}
		
		// kontakty
		if ($zaznam['id']==12) {
			$kontakty_title = printSqlCol('titulek'.$lang_sql_str,$zaznam);
			$kontakty_text = printSqlCol('popis'.$lang_sql_str,$zaznam);
		}
	}
	
	// get SEO & page data
}

// 404 error page
if (!$page) {
	$page = '404';
}

// folder
$inc_str = '';

// send order email

// anti spam
$aspm		= isset($_POST['aspm']) && $_POST['aspm']!='' ? $_POST['aspm'] : false;
$my_code	= 14 * SubStr(GetEnv('REMOTE_ADDR'),0,2);
$send_mail = false;
$insert_db = false;

if(isset($_POST['aspm']) && $_POST['aspm']!='' && $aspm==$my_code) {
	
	//echo '<!--aspm 2: '.$aspm.'-'.$my_code.'-->';
	
	$jmeno		= GetOrPostSafe('jmeno','post','str');
	$narozeni	= GetOrPostSafe('narozeni','post','str');
	$mesto		= GetOrPostSafe('mesto','post','str');
	$ulice		= GetOrPostSafe('ulice','post','str');
	$psc		= GetOrPostSafe('psc','post','str');
	$email		= GetOrPostSafe('email','post','str');
	$telefon	= GetOrPostSafe('telefon','post','str');
	
	$zastupce	= GetOrPostSafe('zastupce','post','str');
	$zastupcenarozeni	= GetOrPostSafe('zastupcenarozeni','post','str');
	$zastupcetelefon	= GetOrPostSafe('zastupcetelefon','post','str');
	$ucitel		= GetOrPostSafe('ucitel','post','str');
	$skola		= GetOrPostSafe('skola','post','str');
	$repertoar	= GetOrPostSafe('repertoar','post','str');
	$fakturace	= GetOrPostSafe('fakturace','post','str');
	
	$ubytovani	= GetOrPostSafe('ubytovani','post','str');
	$ubytovaniden1	= GetOrPostSafe('ubytovaniden1','post','int');
	$ubytovaniden2	= GetOrPostSafe('ubytovaniden2','post','int');
	$ubytovaniden3	= GetOrPostSafe('ubytovaniden3','post','int');
	$ubytovaniden4	= GetOrPostSafe('ubytovaniden4','post','int');
	//$ubytovaniden5	= GetOrPostSafe('ubytovaniden5','post','int');

	$poznamky	= GetOrPostSafe('poznamky','post','str');
	//$registrace	= GetOrPostSafe('registrace','post','str');

	if ($telefon && $jmeno && $email && $mesto && $ulice && $psc && $repertoar && $zastupce) {
	
		//echo '<!--telefon: '.$telefon.'-'.$dotaz.'-'.$email.'-->';
		
		$body = $body2 = '';
		
		// insert data to db
		$id = Pg_Exec("SELECT nextval('klavesaregistrace_id_seq');");
		$id = Pg_Fetch_Array($id,0);
		$id = $id['nextval'];
		
		// send email to web
		$subject = "Registrace - $conf_title\n\n";
		$body .= "".$title."\n";
		$body .=      "--------------------------\n";
		$body .=      "$jmeno_text: $jmeno\n";
		$body .=      "$narozeni_text: $narozeni\n";
		$body .=      "$mesto_text: $mesto\n";
		$body .=      "$ulice_text: $ulice\n";
		$body .=      "$psc_text: $psc\n";
		$body .=      "$email_text: $email\n";
		$body .=      "$telefon_text: $telefon\n";
		$body .=      "$zastupce_text: $zastupce\n";
		$body .=      "$zastupce_narozeni_text: $zastupcenarozeni\n";
		$body .=      "$zastupce_telefon_text: $zastupcetelefon\n";
		$body .=      "$ucitel_text: $ucitel\n";
		$body .=      "$skola_text: $skola\n";
		$body .=      "$repertoar_text: $repertoar\n";
		$body .=      "$fakturacni_udaje_text: $fakturace\n";
		$body .=      "Variabilní symbol: 2017".sprintf('%04d', $id)."\n";
		$body .=      "--------------------------\n";
		$body .=      "$ubytovani_text: $conf_ubytovani_arr[$ubytovani]\n";
		if ($ubytovaniden1==1) $body .=      "$ubytovani_1_text\n";
		if ($ubytovaniden2==1) $body .=      "$ubytovani_2_text\n";
		if ($ubytovaniden3==1) $body .=      "$ubytovani_3_text\n";
		if ($ubytovaniden4==1) $body .=      "$ubytovani_4_text\n";
		$body .=      "$ubytovani_poznamky_text: $poznamky\n";
		$body .=      "--------------------------\n";
		
		require 'adm2/mailer/class.phpmailer.php';
		
		$mail = new PHPMailer;
		// SMTP
		$mail->IsSMTP();
		$mail->SMTPAuth = true;
		$mail->Host = 'posta.pixman.cz';
		$mail->Port = 25;
		$mail->Username = 'smtp@pixman.eu';
		$mail->Password = 'PixmaniSMTP.*';
		
		$mail->From = 'smtp@pixman.eu';
		$mail->FromName = $conf_title;
		
		$mail->AddAddress('dana.cernotova@broumovsko.cz');
		$mail->AddBCC('jarda@pixman.cz');
		
		$mail->AddReplyTo($email, 'Soutezici - '.$jmeno);
		
		$mail->Subject = $subject;
		$mail->Body    = $body;
		
		// mail to user
		$subject2 = "Registrace / Registration - $conf_title\n\n";
		$body2 .= "".$title."\n";
		$body2 .=      "--------------------------\n"; // VS: 2015001
		$body2 .=      "$jmeno_text: $jmeno\n";
		$body2 .=      "$podekovani_text\n";
		
		$body2 .=      "--------------------------\n";
		
if ($lang=='en') {

	$body2 .= "Dear sir/madam, 
by this e-mail we confirm acceptation of your registration to the competition.

Foreign competitors can pay the registration fee in cash after arrival in Broumov Monastery.

Business place:
MMB A.S. OSTRAVA – MASARYKOVO NÁM.
MASARYKOVO NÁMĚSTÍ 51/32
702 00 OSTRAVA
Bank account: 204271558/0600
Currency: CZK
IBAN: CZ69 0600 0000 0002 0427 1558
SWIFT BIC: AGBACZPP
Variable symbol: 2017".sprintf('%04d', $id)."

Competitors in 1st and 2nd category
registration until the 20th March: 550 CZK
registration until the 21th April: 750 CZK

Competitors in 3rd and 4th category
registration until the 20th March: 790 CZK
registration until the 21th April: 990 CZK

In case of any doubt, don't hesitate to contact the person in charge: 
Dana Černotová, e-mail: dana.cernotova@broumovsko.cz

Best regards,
working group of the Broumov Key\n";

} else if ($lang=='pl') {

	$body2 .= "Dzień dobry,

Niniejszym potwierdzenie przyjęcie Państwa zgłoszenia do konkursu. 

Opłatę uczestnika należy wpłacić po przyjeździe na konkurs.

Miejsce prowadzenia działalności:
MMB A.S. OSTRAVA – MASARYKOVO NÁM.
MASARYKOVO NÁMĚSTÍ 51/32
702 00 OSTRAVA
Dane bankowe: 204271558/0600
Znakowanie Waluta: CZK
Numer rachunku IBAN: CZ69 0600 0000 0002 0427 1558
SWIFT BIC: AGBACZPP
Zmienna Symbol: 2017".sprintf('%04d', $id)."

Opłata konkursowa: 1. + 2. kategoria
Rejestracja do 20. marca: 550 CZK
Rejestracja do 21. kwietnia: 750 CZK

Opłata konkursowa: 3. + 4. kategoria
Rejestracja do 20. marca: 790 CZK
Rejestracja do 21. kwietnia: 990 CZK

W przypadku jakichkolwiek wątpliwości, nie wahaj się skontaktować się z osobą odpowiedzialną za:
Dana Černotová, e-mail: dana.cernotova@broumovsko.cz

Z poważaniem,
Grupa robocza Broumov Key\n";

} else {

	$body2 .= "Dobrý den,
tímto potvrzujeme přijetí Vaší soutěžní přihlášky.

Převeďte prosím soutěžní poplatek v částce 750 Kč pokud patříte do 1. a 2. kategorie / 990 Kč 
pokud patříte do 3. a 5. kategorie na číslo účtu, které je uvedeno níže. 
Nezapomeňte uvést svůj variabilní symbol.

Číslo účtu: 204271558/0600
Variabilní symbol: 2017".sprintf('%04d', $id)."

V případě nejasností se ozvěte na kontakt: Dana Černotová, e-mail: dana.cernotova@broumovsko.cz
S pozdravem,
tým Broumovské klávesy.\n";

}
		
		$sendcommand = "INSERT INTO klavesaregistrace (id,status,jmeno,narozeni,mesto,ulice,psc,email,telefon,
		zastupce,zastupcenarozeni,zastupcetelefon,ucitel,skola,repertoar,fakturace,ubytovani,ubytovaniden1,ubytovaniden2,
		ubytovaniden3,ubytovaniden4,poznamky,registrace,datumzadani) VALUES (";
		$sendcommand .= "'".addSqlCol($id)."',";
		$sendcommand .= "1,";
		$sendcommand .= "'".addSqlCol($jmeno)."',";
		$sendcommand .= "'".addSqlCol($narozeni)."',";
		$sendcommand .= "'".addSqlCol($mesto)."',";
		$sendcommand .= "'".addSqlCol($ulice)."',";
		$sendcommand .= "'".addSqlCol($psc)."',";
		$sendcommand .= "'".addSqlCol($email)."',";
		$sendcommand .= "'".addSqlCol($telefon)."',";
		$sendcommand .= "'".addSqlCol($zastupce)."',";
		$sendcommand .= "'".addSqlCol($zastupcenarozeni)."',";
		$sendcommand .= "'".addSqlCol($zastupcetelefon)."',";
		$sendcommand .= "'".addSqlCol($ucitel)."',";
		$sendcommand .= "'".addSqlCol($skola)."',";
		$sendcommand .= "'".addSqlCol($repertoar)."',";
		$sendcommand .= "'".addSqlCol($fakturace)."',";
		$sendcommand .= "'".addSqlCol($ubytovani)."',";
		$sendcommand .= "'".addSqlCol($ubytovaniden1)."',";
		$sendcommand .= "'".addSqlCol($ubytovaniden2)."',";
		$sendcommand .= "'".addSqlCol($ubytovaniden3)."',";
		$sendcommand .= "'".addSqlCol($ubytovaniden4)."',";
		$sendcommand .= "'".addSqlCol($poznamky)."',";
		$sendcommand .= "'".addSqlCol($subject."\n".$body."\n\n".$subject2."\n".$body2)."',";
		$sendcommand .= "CURRENT_TIMESTAMP)";
		$sendcommand = str_replace("''","NULL",$sendcommand);
		
		//echo '<!--'.$sendcommand.'-->';
		
		if (Pg_Exec($sendcommand)) {
			$insert_db = true;
		}
		
		if(!$mail->Send()) {
			//echo 'Mailer Error: ' . $mail->ErrorInfo;
			//echo '<!--Mailer Error: '.$mail->ErrorInfo.'-->';
			
		} else {
			$send_mail = true;
			
			// send different mail to user
			$mail = new PHPMailer;
			// SMTP
 			$mail->IsSMTP();
			$mail->SMTPAuth = true;
			$mail->Host = 'posta.pixman.cz';
			$mail->Port = 25;
			$mail->Username = 'smtp@pixman.eu';
			$mail->Password = 'PixmaniSMTP.*';
		
			$mail->From = 'smtp@pixman.eu';
			$mail->FromName = $conf_title;
			
			$send_to = false;
			
			if ($email) {
				$mail->AddAddress($email);
			}
			
			$mail->AddReplyTo('prihlasky@klavir.cz', $conf_title);
            $mail->AddBCC('jarda@pixman.cz');
			$mail->AddBCC('dana.cernotova@broumovsko.cz');
			
			//$mail->AddCC('cc@example.com');
			
			$mail->Subject = $subject2;
			$mail->Body    = $body2;
			
			$mail->Send();
		}
	}
}
?>
<!DOCTYPE html>
<html>
	<head>
		<title><? echo $title_seo ? $title_seo : $conf_title.' - '.$title ?></title>
		<meta charset="utf-8">
		<meta name="description" content="<? echo $descr_seo ? $descr_seo : $conf_descr.' - '.$title ?>">
		<meta name="keywords" content="">
		<meta name="robots" content="index,follow">
		<meta name="author" content="desing: HMS design - www.hmsdesign.cz" />
		<link rel="stylesheet" href="<? echo $root ?>css/style.css">
	 	<link rel="stylesheet" href="<? echo $root ?>fancybox/source/jquery.fancybox.css?v=2.1.5" type="text/css" media="screen">
		<script type="text/javascript" src="<? echo $root ?>js/jquery-1.10.2.min.js"></script>
		<script type="text/javascript" src="<? echo $root ?>fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>
		<script type="text/javascript" src="<? echo $root ?>js/jquery.call.js"></script>
		<!--[if lt IE 9]>
		<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
		<![endif]-->
	</head>

	<body class="<? echo $lang ?>">
		<section class="cover">
			<div class="coverColLeft">
				<h1 class="highlight"><? echo $conf_title ?></h1>
				<p class="h1 highlight">
					<? echo $header_title_arr[0] ?>
				</p>
				<p class="botPoz">
					<? echo $header_text_arr[0] ?>
				</p>
			</div>
			<div class="coverColRight">
<? if ($lang=='en') { ?>
				<a href="<? echo $page=='homepage' ? $root : $page_url_arr['cs'] ?>">Česky</a> &nbsp; &nbsp; 
				<a href="<? echo $page=='homepage' ? $root.'pl/' : $page_url_arr['pl'] ?>">Polski</a>
<? } else if ($lang=='pl') { ?>
				<a href="<? echo $page=='homepage' ? $root : $page_url_arr['cs'] ?>">Česky</a> &nbsp; &nbsp; 
				<a href="<? echo $page=='homepage' ? $root.'en/' : $page_url_arr['en'] ?>">English</a>
<? } else  { ?>
				<a href="<? echo $page=='homepage' ? $root.'en/' : $page_url_arr['en'] ?>">English</a> &nbsp; &nbsp; 
				<a href="<? echo $page=='homepage' ? $root.'pl/' : $page_url_arr['pl'] ?>">Polski</a>
<? } ?>
				<p class="botPoz right">
					<? echo $header_text2_arr[0] ?>
				</p>
			</div>
		</section>
		<nav>
			<ul class="nav">
				<li class="home">
					<a href="<? echo $root.$language_link ?>"> &nbsp; </a>
				</li>
				<li>
					<a href="<? echo $root.$language_link ?>"><? echo $pages_arr[5] ?></a>
				</li>
				<li>
					<a href="<? echo $pages_url_arr[9] ?>"><? echo $pages_arr[9] ?></a>
				</li>
				<!--<li>
					<a href="<? echo $pages_url_arr[10] ?>"><? echo $pages_arr[10] ?></a>
				</li>-->
				<li>
					<a href="<? echo $pages_url_arr[4] ?>"><? echo $pages_arr[4] ?></a>
				</li>
				<li>
					<a href="<? echo $pages_url_arr[11] ?>"><? echo $pages_arr[11] ?></a>
				</li>
				<li>
					<a href="<? echo $pages_url_arr[12] ?>"><? echo $pages_arr[12] ?></a>
				</li>
			</ul>
		</nav>
<?
// homepage
if ($page == 'homepage') {

	// list subpages
	$page_data = array();
	
	$sSql = "SELECT * FROM ".$table." WHERE idhlavnistranky=$page_id AND soubor IS NOT NULL AND status = 1 ORDER BY razeni";
	$vysledek_pcs = Pg_Exec($sSql);
	while ($zaznam_pcs = Pg_Fetch_Assoc($vysledek_pcs)) {
		$page_data[] = array(
			'title'=>printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs),
			'text'=>strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam_pcs)),
			'text2'=>strip_tags(printSqlCol('perex'.$lang_sql_str,$zaznam_pcs)),
			'link'=>printSqlCol('link'.$lang_sql_str,$zaznam_pcs),
			'pcs'=>$root.'galerie/'.$table.'/'.$zaznam_pcs['id'].'/'.printSqlCol('soubor',$zaznam_pcs)
		);
	}
?>
		<div class="leftCol">
			<div class="imageHold">
				<img class="image" alt="" src="<? echo $page_data[0]['pcs'] ?>">
				<p class="topPoz">
					<? echo $page_data[0]['title'] ?>
					<br>
					<? echo $page_data[0]['text'] ?>
				</p>
				<p class="botPoz highlight highlightSize">
					<? echo $page_data[0]['text2'] ?>
				</p>
				<div class="reset"></div>
			</div>
			<section class="leftCont">
				<span class="cal">&nbsp;</span>
				<? echo $text ?>
			</section>
		</div>
		<div class="rightCol">
			<section class="rightCont">
				<span class="rep">&nbsp;</span>
				<? echo $text2 ?>
			</section>
<!-- 			<div class="imageHold">
				<a href="https://docs.google.com/forms/d/e/1FAIpQLSfsGb5fIeLOl_rCrL6_dbrNrjq2eIAGVYUr2_DNf_ajH7T0jg/viewform?prihlasky<? /*echo $page_data[1]['link']*/ ?>">
					<img class="image" alt="" src="<? echo $page_data[1]['pcs'] ?>">
					<strong class="topPoz highlight highlightSizeBig"><? echo $page_data[1]['title'] ?></strong>
					<p class="botPoz">
						<? echo $vice_informaci_text ?> &gt;
					</p>
					<div class="reset"></div>
				</a>
			</div> -->
		</div>
<? 
// other pages
} else { 
	
	// login form
	if ($page_id=='DISABLE') { // 10
	
		if ($send_mail) {
?>
		<section class="signup">
			<h1><? echo $title ?></h1>
			
			<? echo $text2 ?>

<?
		} else {
?>
		
		<section class="signup">
			<h1><? echo $title ?></h1>
			
			<? echo $text ?>
			
			<form method="post">
				
				<fieldset>
				
					<label class="bigLabel"><span class="comp">*</span> <? echo $jmeno_text ?></label>
					<input type="text" name="jmeno" id="jmeno" value="" class="smallInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $jmeno_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $narozeni_text ?></label>
					<input type="text" name="narozeni" id="narozeni" value="" class="bigInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $narozeni_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $mesto_text ?></label>
					<input type="text" name="mesto" id="mesto" value="" class="bigInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $mesto_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $ulice_text ?></label>
					<input type="text" name="ulice" id="ulice" value="" class="bigInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $ulice_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $psc_text ?></label>
					<input type="text" name="psc" id="psc" value="" class="smallestInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $psc_help_text ?>
							</p>
						</div>
					</div>
					<br class="reset">
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $email_text ?></label>
					<input type="text" name="email" id="email" value="" class="bigInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $email_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $telefon_text ?></label>
					<input type="text" name="telefon" id="telefon" value="" class="bigInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $telefon_help_text ?>
							</p>
						</div>
					</div>
					<br>
					
					<label class="bigLabel"><span class="comp">*</span> <? echo $zastupce_text ?></label>
					<input type="text" name="zastupce" id="zastupce" value="" class="smallInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $zastupce_help_text ?>
							</p>
						</div>
					</div>
					<br class="reset">
					
					<label class="bigLabel"><span class="comp">*</span> <? echo $zastupce_narozeni_text ?></label>
					<input type="text" name="zastupcenarozeni" id="zastupcenarozeni" value="" class="smallInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $zastupce_narozeni_help_text ?>
							</p>
						</div>
					</div>
					<br class="reset">
					
					<label class="bigLabel"><span class="comp">*</span> <? echo $zastupce_telefon_text ?></label>
					<input type="text" name="zastupcetelefon" id="zastupcetelefon" value="" class="smallInput">
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $telefon_help_text ?>
							</p>
						</div>
					</div>
					<br class="reset">
					
					<label class="bigLabel"><? echo $ucitel_text ?></label>
					<input type="text" name="ucitel" value="" class="smallInput">
<? if ($ucitel_help_text!='') { ?>
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $ucitel_help_text ?>
							</p>
						</div>
					</div>
<? } ?>
					<br>
					
					<label class="smallLabel"><? echo $skola_text ?></label>
					<input type="text" name="skola" value="" class="bigInput">
<? if ($skola_help_text!='') { ?>
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $skola_help_text ?>
							</p>
						</div>
					</div>
<? } ?>
					<br>
					
					<label class="smallLabel"><span class="comp">*</span> <? echo $repertoar_text ?></label>
					<textarea class="bigInput" name="repertoar" id="repertoar" rows="3"></textarea>
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $repertoar_help_text ?>
							</p>
						</div>
					</div>
					<br>

					<label class="smallLabel"><? echo $fakturacni_udaje_text ?></label>
					<textarea class="bigInput" name="fakturace" rows="3"></textarea>
<? if ($fakturacni_udaje_help_text!='') { ?>
					<div class="help">?
						<div class="helpDisplay">
							<p>
								<? echo $fakturacni_udaje_help_text ?>
							</p>
						</div>
					</div>
<? } ?>
					<br>
					
				</fieldset>
				
				<fieldset>
					
					<p class="formHead"><? echo $ubytovani_text ?></p>
					
					<div class="reset"></div>
					
<? if ($lang=='en') { ?>
					<p class="note">For accommodation we recommend <a onclick="window.open(this.href,'_blank');return false;" href="https://www.booking.com/hotel/cz/praha-broumov1.cs.html?label=gen173nr-1FCAEoggJCAlhYSDNiBW5vcmVmaDqIAQGYAQXCAQp3aW5kb3dzIDEwyAEM2AEB6AEB-AELkgIBeagCAw;sid=4346d7dd5afdce374b584f52a1bfbd74;dest_id=-542218;dest_type=city;dist=0;group_adults=2;hpos=3;room1=A%2CA;sb_price_type=total;srfid=8f60b1c9c010e50ae9876560432d9acc03778462X3;type=total;ucfs=1&#hotelTmpl">Hotel Praha - more info</a></p>
<? } else if ($lang=='pl') { ?>
					<p class="note">Przy zakwaterowaniu zalecamy <a onclick="window.open(this.href,'_blank');return false;" href="https://www.booking.com/hotel/cz/praha-broumov1.cs.html?label=gen173nr-1FCAEoggJCAlhYSDNiBW5vcmVmaDqIAQGYAQXCAQp3aW5kb3dzIDEwyAEM2AEB6AEB-AELkgIBeagCAw;sid=4346d7dd5afdce374b584f52a1bfbd74;dest_id=-542218;dest_type=city;dist=0;group_adults=2;hpos=3;room1=A%2CA;sb_price_type=total;srfid=8f60b1c9c010e50ae9876560432d9acc03778462X3;type=total;ucfs=1&#hotelTmpl">Hotel Praha - więcej tutaj</a></p>
<? } else { ?>
					<p class="note">Pro ubytování doporučujeme <a onclick="window.open(this.href,'_blank');return false;" href="https://www.booking.com/hotel/cz/praha-broumov1.cs.html?label=gen173nr-1FCAEoggJCAlhYSDNiBW5vcmVmaDqIAQGYAQXCAQp3aW5kb3dzIDEwyAEM2AEB6AEB-AELkgIBeagCAw;sid=4346d7dd5afdce374b584f52a1bfbd74;dest_id=-542218;dest_type=city;dist=0;group_adults=2;hpos=3;room1=A%2CA;sb_price_type=total;srfid=8f60b1c9c010e50ae9876560432d9acc03778462X3;type=total;ucfs=1&#hotelTmpl">Hotel Praha - více zde</a></p>
<? } ?>
					<!--<p class="note"><? echo $ubytovani_help_text ?></p>
					
					<div>
						<select name="ubytovani">
						</select>
						<div class="reset"></div>
					</div>
					<br>
					
					<p class="formHead"><? echo $ubytovani_termin_text ?></p>
					<div class="formCol">
						<input type="checkbox" id="chk1" name="ubytovaniden1" value="1">
						<label for="chk1"><? echo $ubytovani_1_text ?></label>
					</div>
					<div class="formCol">
						<input type="checkbox" id="chk2" name="ubytovaniden2" value="1">
						<label for="chk2"><? echo $ubytovani_2_text ?></label>
					</div>
					<div class="formCol">
						<input type="checkbox" id="chk3" name="ubytovaniden3" value="1">
						<label for="chk3"><? echo $ubytovani_3_text ?></label>
					</div>
					<div class="formCol">
						<input type="checkbox" id="chk4" name="ubytovaniden4" value="1">
						<label for="chk4"><? echo $ubytovani_4_text ?></label>
					</div>-->
					
					<div class="reset"></div>
					
					<br>
					
					<label class="smallLabel"><? echo $ubytovani_poznamky_text ?></label>
					<textarea class="bigInput" name="poznamky" rows="3"></textarea>
					<br>
					
				</fieldset>
				
				<fieldset>
					<input type="button" class="submitButton" value="<? echo $odeslat_text ?>">
					<input type="hidden" name="aspm" id="aspm" value="" class="hide">
				</fieldset>
			</form>
			
			<script type="text/javascript">
			if (document.getElementById("aspm")) {
				document.getElementById("aspm").value=14 * <? echo SubStr(GetEnv('REMOTE_ADDR'),0,2) ?>;
			}
			</script>
			
		</section>
<?
		}
		
	// photogallery
	} else if ($page_type==1) {
?>
		<section class="board">
			<h1><? echo $title ?></h1>
			
			<? echo $text ?>
			
			<? echo $text2 ?>
			
<? 
		// list photos
		$fotogalerie_arr = array();
		
		$sSql = "SELECT * FROM ".$table."obsah WHERE rozmery IS NOT NULL ORDER BY idzaznamu,razeni";
		$vysledek_pcs = Pg_Exec($sSql);
		while ($zaznam_pcs = Pg_Fetch_Assoc($vysledek_pcs)) {
			if (isset($fotogalerie_arr[$zaznam_pcs['idzaznamu']])) {
				$fotogalerie_arr[$zaznam_pcs['idzaznamu']] .= '<a href="'.$root.'galerie/'.$table.'/'.$zaznam_pcs['idzaznamu'].'/'.$zaznam_pcs['soubor'].'" class="fancybox" data-fancybox-group="group'.$zaznam_pcs['idzaznamu'].'" title="'.printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs).'"></a>'."\n";
			} else {
				$fotogalerie_arr[$zaznam_pcs['idzaznamu']] = ' '; // first photo is empty -> show at next rec. list
			}
		}
		
		// list subpages
		$sSql = "SELECT * FROM ".$table." WHERE idhlavnistranky=$page_id AND soubor IS NOT NULL AND status = 1 ORDER BY razeni";
		$vysledek_pcs = Pg_Exec($sSql);
		while ($zaznam_pcs = Pg_Fetch_Assoc($vysledek_pcs)) {
?>
			<div class="imageCol">
				<a href="<? echo $root ?>galerie/<? echo $table ?>/<? echo $zaznam_pcs['id'] ?>/<? echo $zaznam_pcs['soubor'] ?>" class="fancybox" data-fancybox-group="group<? echo $zaznam_pcs['id'] ?>">
					<div class="imageHold">
						<img class="image" src="<? echo $root ?>galerie/<? echo $table ?>/<? echo $zaznam_pcs['id'] ?>/m-<? echo printSqlCol('soubor',$zaznam_pcs) ?>" alt="<? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?>">
					</div>
					<p><? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?></p>
				</a>
				<? if (isset($fotogalerie_arr[$zaznam_pcs['id']])) echo $fotogalerie_arr[$zaznam_pcs['id']] ?>
			</div>
<? } ?>
			<div class="reset"></div>
		</section>
		
<?
	// partners
	} else if ($page_type==3) {
?>
		<section class="board partners">
			<h1><? echo $title ?></h1>
			
			<? echo $text ?>
			
			<? echo $text2 ?>
<? 
		// list partners
		$sSql = "SELECT * FROM ".$table."obsah WHERE idzaznamu='$page_id' AND rozmery IS NOT NULL ORDER BY razeni";
		$vysledek_pcs = Pg_Exec($sSql);
		while ($zaznam_pcs = Pg_Fetch_Assoc($vysledek_pcs)) {
?>
			<div class="imageCol">
				<div class="imageHold">
					<a href="<? echo printSqlCol('video',$zaznam_pcs) ?>" target="_blank">
						<img class="image" alt="<? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?>" src="<? echo $root ?>galerie/<? echo $table ?>/<? echo $page_id ?>/m-<? echo printSqlCol('soubor',$zaznam_pcs) ?>">
					</a>
				</div>
			</div>
<? } ?>
			
			<div class="reset"></div>
		</section>
		
<? 
	// clasic pages
	} else {
?>
		<? 
			if (!empty($text)) {
		?>
		<div class="leftCol">
			<section class="leftCont">
				<? echo $text ?>
			</section>
		</div>		
		<? 
			}
			if (!empty($text2)) {
		?>
		<div class="rightCol">
			<section class="rightCont">
				<? echo $text2 ?>
			</section>
		</div>	
		<? 
			}
		?>
		
		<div class="reset"></div>
		
		<? 
		// list files
		$sSql = "SELECT * FROM ".$table."obsah WHERE idzaznamu='$page_id' ORDER BY razeni";
		$vysledek_pcs = Pg_Exec($sSql);
		while ($zaznam_pcs = Pg_Fetch_Assoc($vysledek_pcs)) {
			
			// pcs
			if (printSqlCol('rozmery',$zaznam_pcs)!='') {
?>
			<div class="imageCol">
				<div class="imageHold">
					<a href="<? echo printSqlCol('video',$zaznam_pcs) ?>" target="_blank">
						<img class="image" alt="<? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?>" src="<? echo $root ?>galerie/<? echo $table ?>/<? echo $zaznam_pcs['id'] ?>/m-<? echo printSqlCol('soubor',$zaznam_pcs) ?>">
					</a>
				</div>
			</div>
			
<? 			
			} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs)!='' && printSqlCol('video',$zaznam_pcs)!='') {
?>

			<p>
				<a href="<? echo printSqlCol('video',$zaznam_pcs) ?>" target="_blank"><? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?></a>
			</p>

<?
			} else if (printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs)!='' && printSqlCol('soubor',$zaznam_pcs)!='') {
?>

			<p>
				<a href="<? echo $root ?>galerie/<? echo $table ?>/<? echo $zaznam_pcs['idzaznamu'] ?>/<? echo printSqlCol('soubor',$zaznam_pcs) ?>" target="_blank"><? echo printSqlCol('titulek'.$lang_sql_str,$zaznam_pcs) ?></a>
			</p>

<?			}
		}	
	}
} ?>
		<div class="connector">
			<div class="leftCol">
				<div class="imageHold">
					<a href="<? echo $pages_url_arr[4] ?>">
						<img class="image" alt="" src="<? echo $root ?>pcs/04.jpg">
						<h2 class="topPoz"><? echo $pages_arr[4] ?></h2>
						<p class="botPoz">
							<? echo $vice_informaci_text ?> &gt;
						</p>
						<div class="reset"></div>
					</a>
				</div>
			</div>
			<div class="rightCol">
				<section class="rightContBot">
					<div>
						<h2><? echo $pages_arr[12] ?></h2>
						<? echo $kontakty_text ?>
					</div>
				</section>
			</div>
			<div class="reset"></div>
		</div>
		
		<footer>
			<div class="leftCol">
				<div class="footColOne">
					<? $i=0;echo $footer_text_arr[$i] ?>
				</div>
				<div class="footColTwo">
					<? echo $footer_text2_arr[$i];$i++ ?>
				</div>
				<div class="reset"></div>
			</div>
			<div class="rightCol">
				<span class="logo">&nbsp;</span>
				<div class="footColOne">
					<? echo $footer_text_arr[$i];$i++ ?>
				</div>
				<div class="social">
					<!--<a href="#" class="twitter">&nbsp;</a>-->
					<a href="https://www.facebook.com/pages/Broumovsk%C3%A1-kl%C3%A1vesa/339154759475107?sk=timeline" target="_blank" class="facebook">&nbsp;</a>
				</div>
				<a class="monastery" href="http://www.klasterbroumov.cz/" target="_blank">&nbsp;</a>
			</div>
			<div class="reset"></div>
			<p class="copyr">&copy; Broumovská klávesa 2017 / All rights reserved</p>
			<p class="webdesign"><a onclick="window.open(this.href,'_blank');return false;" href="http://www.hmsdesign.cz" title="Design, koncepce, výroba HMS design / HMS webdesign">Design, koncepce, výroba HMS design / HMS webdesign</a></p>
		</footer>
<?
// close db con.
@pg_close($spojeni);
?>
		<script type="text/javascript">
			function printMsg(type) {
				if (type) {
					alert('<? echo $msg_ok_text ?>');
				} else {
					alert('<? echo $msg_nok_text ?>');
				}
			}
		</script>
		<script type="text/javascript">
			(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
			(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
			m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
			})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
			
			ga('create', 'UA-51466202-2', 'auto');
			ga('send', 'pageview');
		</script>
		
	</body>
</html>