<?
@session_start();
require ("config2015.php");

@ $pripojit = mysql_connect($mysql_server,$mysql_login,$mysql_pass);
@ $vyberdb  = mysql_select_db($mysql_db);

if(!( ($rpage = $_GET["rpage"]) && !empty($rpage) ) ) $rpage = "titulka";

if(!($rpage == "titulka")) {

  if($rpage == "podporujeme") {
         
     if( ($uname = $_GET["uname"]) && !empty($uname) ) {
                                                        $title = $pages_organizace[$uname][0];
                                                        if(count($pages_organizace[$uname]) > 2) $coverimg = $pages_organizace[$uname][2];
     }
     
       else $title = $pages[$rpage][0];
  
  }
    else $title = $pages[$rpage][0];

}

if(($subpage = $_GET["subpage"]) && !empty($subpage) ) {

    $title = $subpages[$subpage][0];

}

if(($rpage == "prispevky") && ( ($uname = $_GET["uname"]) && !empty($uname) )) {

  $query_title = "SELECT nazev,popis,fbpopis,fbimg,coverimg FROM dmpz_prispevek WHERE uname = \"".$uname."\"";
  
  if($get_title = mysql_query($query_title)) {
  
    if( ($number_title = mysql_num_rows($get_title)) && !empty($number_title) ) {
    
       $row_title = mysql_fetch_array($get_title);
       
       $title = $row_title["nazev"];
       
       $p_popis    = $row_title["popis"];
       $p_fbpopis  = $row_title["fbpopis"];
       
       if(empty($p_fbpopis)) {
                               if(!empty($p_popis)) $fbpopis = strip_tags($p_popis);
       
       }
         else $fbpopis = $p_fbpopis;
       
       $p_fbimg    = $row_title["fbimg"];
       $p_coverimg = $row_title["coverimg"];
       
       
       if(empty($p_fbimg)) {
                            if(!empty($p_coverimg)) $fbimg = "http://www.dobremistoprozivot.cz/images/prispevky/".$p_coverimg;  
       } 
         else $fbimg = "http://www.dobremistoprozivot.cz/images/prispevky/".$p_fbimg;
    
    } // end num
  
  } // end res

} // end if -prispevek


if(($rpage == "special") && ( ($uname = $_GET["uname"]) && !empty($uname) )) {

       $title = $specialy_ogs[$uname][1];
       $fbpopis = $specialy_ogs[$uname][2];

       $fbimg = "http://www.dobremistoprozivot.cz/images/fb/".$specialy_ogs[$uname][0];  
       
} // end if - special


// zjistim, zda jsou na titulce nejake slidy
$slides = array();

if($rpage == "titulka") {
  
  $query_slides = "SELECT 
	                       dmpz_prispevek.nazev as nazev,
	                       dmpz_prispevek.uname as uname,   
	                     
	                       dmpz_prispevek.misto as misto,
	                       
	                       dmpz_prispevek.slideimg as slideimg, 
	
	                       UNIX_TIMESTAMP(dmpz_prispevek.od) as od_unix,
	                       DATE_FORMAT(dmpz_prispevek.od, '%e.%c.%Y') as od_format,
	                       DATE_FORMAT(od, '%e.%c.') as odx,
	                       DATE_FORMAT(dmpz_prispevek.od, '%e') as od_format_den,
	                       DATE_FORMAT(dmpz_prispevek.od, '%c') as od_format_mesic,
	                       DATE_FORMAT(dmpz_prispevek.od, '%Y') as od_format_rok,
	                       
	                       UNIX_TIMESTAMP(dmpz_prispevek.do) as do_unix,
	                       DATE_FORMAT(dmpz_prispevek.do, '%e.%c.%Y') as do_format,
	                       DATE_FORMAT(do, '%e.%c.') as dox, 
	                       DATE_FORMAT(dmpz_prispevek.do, '%e') as do_format_den,
	                       DATE_FORMAT(dmpz_prispevek.do, '%c') as do_format_mesic,
	                       DATE_FORMAT(dmpz_prispevek.do, '%Y') as do_format_rok,
	                       
	                       dmpz_prispevek.odkaz as odkaz,
	                       dmpz_prispevek.odkaz_target as odkaz_target 
                       
                    FROM dmpz_prispevek 
               
	                WHERE aktivni < 2    
		               	
	                AND slide > 0  
	                
	                ORDER BY vlozeno DESC";
  
  if($get_slides = mysql_query($query_slides)) {
	
	if( ($number_slides = mysql_num_rows($get_slides)) && !empty($number_slides) )  {
	
	     for($i = 0; $i < $number_slides; $i++) {
			
			$row_slides = mysql_fetch_array($get_slides);
									
			$slide_nazev       = $row_slides["nazev"];
			$slide_uname       = $row_slides["uname"];
					
			$slide_misto       = $row_slides["misto"];
			$slideimg          = $row_slides["slideimg"];
			
			$od_unix           = $row_slides["od_unix"];
			$od_format         = $row_slides["od_format"];
			
			$od_format_den     = $row_slides["od_format_den"]; // 1 - 31
			$od_format_mesic   = $row_slides["od_format_mesic"]; // 1 - 12
			$od_format_rok     = $row_slides["od_format_rok"];
			
			$do_unix           = $row_slides["do_unix"];
			$do_format         = $row_slides["do_format"];
			
			$do_format_den     = $row_slides["do_format_den"]; // 1 - 31
			$do_format_mesic   = $row_slides["do_format_mesic"]; // 1 - 12
			$do_format_rok     = $row_slides["do_format_rok"];
			
			$od   = $row_slides["odx"];
 			$do   = $row_slides["dox"];
			
			$odkaz          = $row_slides["odkaz"];
			$odkaz_target   = $row_slides["odkaz_target"];

			$odkaz_href = "";
			$odkaz_target_html = "";
			
			// kompilace odkazu			
			if(!empty($odkaz)) {			
			                    $odkaz_href = $odkaz;
			                    if(!empty($odkaz_target)) {
			                                               if($odkaz_target < 2) $odkaz_target_html = " target=\"_blank\"";	
			                                                 else $odkaz_target_html = " class=\"fancybox\"";			
			                    }
			} 
	
	           else $odkaz_href = "/index2016.php?rpage=prispevky&uname=".$uname;

	           
	        // kompilace terminu   
	        $termin_string = "";   
	        if(!empty($od_unix)) {			
								    $termin_string = $od;								    
									if(!($do == "0.0.")) {
						 				                      if(!($od_format_rok == $do_format_rok)) $termin_string .= $od_format_rok;
						 				                      	                         
						 				                      $termin_string . " - ";
						 				                      $termin_string . $do.$do_format_rok;
						 			}
						 			  else $termin_string . $od_format_rok;	 			 
			} // end if - termin vyplnen   
	           
			$feat_slide = array($slide_nazev,$slide_uname,$odkaz_href,$odkaz_target_html,$slide_misto,$slideimg,$termin_string);
			
			array_push($slides,$feat_slide);
			
	           
	     } // enf for - slides
	
	} // end num
	
  } // end res

} // end if - titulka


displayTop();

 //error_reporting(E_ALL);
 //ini_set('display_errors', '1');

if(($subpage = $_GET["subpage"]) && !empty($subpage)) include($includes_path.$subpage.".inc");
  else include($includes_path.$rpage.".inc");


@ mysql_close($pripojit);


displayBottom(); 
?>