<?
include "config.php";


//echo "send: ".$s;

$tag_celeb = str_replace("–", " +", $s);
$tag_celeb = " +".$tag_celeb;

$celebrita = explode("–", $s);
$celeb_jmeno=$celebrita[0];
$celeb_prijmeni=$celebrita[1];
$titulek = "$celeb_jmeno"." "."$celeb_prijmeni";

//echo $tag_celeb;	

$pocet_instory = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_instory where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_sport = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_sport where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_vipstory = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_vipstory where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_krimi = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_krimi where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_styl = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_styl where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_bydleni = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_home where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);
$pocet_hobby = mysql_result(mysql_query ("SELECT COUNT(id_clanku) FROM clanky_hobby where MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND aktivni='a'"),0);

$pocet_zaznamu=$pocet_instory+$pocet_sport+$pocet_vipstory+$pocet_krimi+$pocet_styl+$pocet_bydleni+$pocet_hobby;


//$pocet_zaznamu = $pocet_zaznamu-1;


$pocet_stran=ceil($pocet_zaznamu/$zaznamu_nastrane);
$limit1=(($archiv)*$zaznamu_nastrane);
$limit2=$zaznamu_nastrane;

$limit="LIMIT ".$limit1.", ".$limit2."";


if (isset($a)) {
$S = mysql_fetch_array(mysql_query("SELECT * FROM $tabulka_clanky WHERE MATCH (titulek, text) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND id_clanku=$a"));
$limit1=14;
if (isset($archiv)) $limit1=$l+14;
$sql = mysql_query("SELECT * FROM $tabulka_clanky WHERE MATCH (titulek, text) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE) AND  aktivni='a' AND (datum < '$S[datum]')  ORDER BY  datum DESC LIMIT $limit1, 14");
}

$sql = mysql_query("
SELECT id_clanku, titulek, datum, obrazek2, 'zpravy' AS wiki_tabulka FROM clanky_instory  WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a'  
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'sport' AS wiki_tabulka FROM clanky_sport WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'vipstory' AS wiki_tabulka FROM clanky_vipstory WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'krimi' AS wiki_tabulka FROM clanky_krimi WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'styl' AS wiki_tabulka FROM clanky_styl WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'bydleni' AS wiki_tabulka FROM clanky_home WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 
UNION ALL 
SELECT id_clanku, titulek, datum, obrazek2, 'hobby' AS wiki_tabulka FROM clanky_hobby WHERE MATCH (titulek, text, tags) AGAINST ('*$tag_celeb*' IN BOOLEAN MODE)  AND aktivni='a' 


ORDER BY datum DESC  $limit");


$sql_cel = mysql_query("SELECT * FROM celebrity WHERE MATCH(jmeno) AGAINST('$celeb_jmeno' IN BOOLEAN MODE) AND MATCH (prijmeni) AGAINST ('$celeb_prijmeni' IN BOOLEAN MODE)");
$pocet = mysql_num_rows($sql_cel);

if (($pocet=="0")&&($pocet_zaznamu=="0")) { header("Location: /nenalezeno"); }


if ($pocet=="1" || $pocet_zaznamu!="0") {

$Cel = mysql_fetch_array($sql_cel);

// overeni spravnosti adresesy
if (isset($cd)) {
	$celeb = explode("–", $celeb);
	$celebr_jmeno=$celeb[0];
	$celebr_prijmeni=$celeb[1];
	$title_real=$Cel[0]."-".$Cel[jmeno]."-".$Cel[prijmeni].".html";
	$title_zadany=$cd."-".$celebr_jmeno."-".$celebr_prijmeni;
	//echo $title_real."<br/>";
	//echo $title_zadany;

	if ($title_real!=$title_zadany) header("Location: /nenalezeno");
	
	}
// konec overeni


$arr = explode ("-", $Cel[datum_narozeni]); 
$rok = $arr[0]; 
$mesic = $arr[1]; 
$den = $arr[2]; 


$nowdate = date("Ymd"); 
$birthday = $rok.$mesic.$den; 

if ($Cel[datum_narozeni]!="0000-00-00" && $Cel[datum_narozeni]!="" && $Cel[datum_umrti]=="0000-00-00") {
$age = "(".floor(($nowdate-$birthday)/10000)." let)";  }

else if  ($Cel[datum_narozeni]!="0000-00-00" && $Cel[datum_narozeni]!="" && $Cel[datum_umrti]!="0000-00-00") {
$arr_smrt = explode ("-", $Cel[datum_umrti]); 
$rok_smrt = $arr_smrt[0]; 
$mesic_smrt = $arr_smrt[1]; 
$den_smrt = $arr_smrt[2]; 
$dethday=$rok_smrt.$mesic_smrt.$den_smrt;
$live_age = floor(($dethday-$birthday)/10000);
$age = "(".$rok." – ".$rok_smrt.")";

}
else $age = "";

include "func.php";

head($titulek);


}

//else header("Location: /nenalezeno");


?>


<!-- (C)2000-2014 Gemius SA - gemiusAudience / instory.cz / Ostatni -->
<script type="text/javascript">
<!--//--><![CDATA[//><!--
var pp_gemius_identifier = 'ogiQpL95GyWKedu6cyljVYawP4LFIHuA65HiKzE5tdD.97';
// lines below shouldn't be edited
function gemius_pending(i) { window[i] = window[i] || function() {var x = window[i+'_pdata'] = window[i+'_pdata'] || []; x[x.length]=arguments;};};
gemius_pending('gemius_hit'); gemius_pending('gemius_event'); gemius_pending('pp_gemius_hit'); gemius_pending('pp_gemius_event');
(function(d,t) {try {var gt=d.createElement(t),s=d.getElementsByTagName(t)[0],l='http'+((location.protocol=='https:')?'s':''); gt.setAttribute('async','async');
gt.setAttribute('defer','defer'); gt.src=l+'://spir.hit.gemius.pl/xgemius.js'; s.parentNode.insertBefore(gt,s);} catch (e) {}})(document,'script');
//--><!]]>
</script>


<div id="page">
	

	<!-- Header -->
	<? require("header.php"); ?>
	<!-- END od Header -->	
	
	
	<div id="article-content">


		<div class="title" style="margin-top:60px; margin-left:60px;" ><h2 class="negative-font" style="font-size:200%; margin: 40px 0 10px 0; line-height:90%;" ><? echo "<span style='color:#a6a6a6'>Wiki: </span>".str_replace("–", " ", $s)."<br />";?>
		<? if ($age!="") { ?><span style="font-family:'roboto_slablight'; color:#E06; font-size: 70%"><? echo $age." <span style='color:#989797;'>/</span>";?></span><? } ?>
		<? if ($Cel[profese]!="") { ?><span style="font-family:'roboto_slablight'; font-size: 70%;"><? echo $Cel[profese];?></span><? } ?></div>
		
		<p style="margin-top:15px; font-size: 130%; line-height: 130%;"><? if ($Cel[popis]!="" && $Cel[datum_umrti]=="0000-00-00") echo "<span style='font-family: roboto_slabbold; '>Status:</span> ".$Cel[popis];?>
			<? if ($Cel[popis]!="" && $Cel[datum_umrti]!="0000-00-00") echo "<span style='font-family: roboto_slabbold; color:#989797;'>Vzpomínka inStory.cz:</span> ".$Cel[popis];?>
		</p>
			<? if ($Cel[obrazek]!="") {?><div style="margin:-4px 0 0 0px;"><img src="//instory.cz/content/celebrity/<? echo $Cel[obrazek];?>" width="640px" class="images_celeb"></div><? } ?>

				<div class="clearfix"></div>
				<? if ($Cel[shrnuti]!="") { ?><div style="font-family:'roboto_slablight'; margin: 15px 20px 20px 60px; font-size: 95%; line-height: 160%;"><? echo $Cel[shrnuti];?></div><? } ?>
				
				
								<div class="clearfix"></div>
					<? if (($Cel[text]!="") && ($Cel[obrazek]!="") && (!isset($cd))) { ?>
					<div class="title" style="margin:20px 0 45px 60px; color:#0091f4; font-size:110%;" ><a href="/<? echo $s;?>/<? echo $Cel[0];?>-<? echo $s;?>.html" class="celeb">Zobrazit celý profil osobnosti <? echo str_replace("–", " ", $s);?></a></div><? } ?>

			</div>
			<div class="clearfix"></div>


		<? if (isset($cd)) { 
		
		$datum_narozeni = explode("-", $Cel[datum_narozeni]);
		$datum_narozeni = $datum_narozeni[2].". ".$mesic_text[$datum_narozeni[1]]." ".$datum_narozeni[0];
		
		?>
	<div style="height:4px;"></div>	
	<div id="article-content-cel" style="margin-top: <? if ($Cel[shrnuti]!="") echo '-5px'; else echo '15px';?>">

		<div class="title" style="padding: 5px 0 0 60px; margin-bottom:5px; background: #FFF" >
		
		<p style="padding-left:0px; font-family:'roboto_slablight'; font-size: 130%;"><b style="color:#a6a6a6; font-family: roboto_slabregular, arial black;">Narození:</b> <? echo $datum_narozeni;?> <? if ($live_age>0) echo " (✝".$live_age.")"; ?>&nbsp;&nbsp;/&nbsp;&nbsp;&nbsp;<b style="color:#a6a6a6; font-family: roboto_slabregular, arial black">Zaměření:</b> <? echo $Cel[profese];?></p></div>
		<p style="margin-bottom:20px; font-size: 105%; line-height: 110%;"><? echo $Cel[text];?></p>
				<div class="clearfix"></div>
					

			</div>
			<div class="clearfix"></div>
			
			<? } ?>
			
			
<!-- timeline -->
	<div id="timeline">		
		<div id="archiv-content" style="float:left;">
		
		<? if ($pocet_zaznamu=="1") $clanek_text="článek";
			elseif ($pocet_zaznamu>1 && $pocet_zaznamu<5) $clanek_text="články";
			else $clanek_text="článků"; 
			if ($Cel[osloveni]!="") $o_celebrite=" o "."<span style='font-family: roboto_slabbold;'>".$Cel[osloveni]."</span>";
			?>
		
			<div class="search_count"><span style="font-family: roboto_slablight; color:#000; font-weight:normal; font-size:120%;"><? echo "$pocet_zaznamu"." "."$clanek_text".$o_celebrite; ?></span></div>
			
			
		<? $i=1; while ($V = mysql_fetch_array($sql)): 
				$photos_number = mysql_result(mysql_query ("SELECT COUNT(id_photo) FROM `$tabulka_foto` WHERE id_clanku=$V[0]"),0); 

				if ($V[wiki_tabulka]=="zpravy") { $cesta_web_obr = "http://instory.cz"; $barva_web="#008aff";$rubrika_web="ZPRÁVY";}
				if ($V[wiki_tabulka]=="krimi") { $cesta_web_obr = "http://instory.cz"; $barva_web="#008aff";$rubrika_web="KRIMI";}
				if ($V[wiki_tabulka]=="vipstory") { $cesta_web_obr = "http://instory.cz"; $barva_web="#eb1c23"; $rubrika_web="CELEBRITY";}
				if ($V[wiki_tabulka]=="sport") 	{ $cesta_web_obr = "http://instory.cz"; $barva_web="#37b34a"; $rubrika_web="SPORT";}
				if ($V[wiki_tabulka]=="bydleni") { $cesta_web_obr = "http://instory.cz"; $barva_web="#b6589b"; $rubrika_web="BYDLENÍ";}
				if ($V[wiki_tabulka]=="hobby") { $cesta_web_obr = "http://instory.cz"; $barva_web="#895d3a"; $rubrika_web="HOBBY";}

		
		?>
		<div class="next-article">
								<div style="float: left; margin-left: 60px; margin-top: <? if ($i==1) echo "0px"; else echo "20px";?>;">
									<? if($i!=1) { ?><div class="timeline-separator" style="margin-top:-20px; position: absolute;	margin-bottom: 20px; margin-left: 0px;"></div><? } ?>
		<a href="<? echo '//'.$V[wiki_tabulka];?>.instory.cz/<? echo friendly_url($V[0], $V[titulek]);?>"><img src="<? echo $cesta_web_obr;?>/content/images/<? echo $V[obrazek2];?>" class="img_vypis" ></a></div>
		
		<div style="float: left; background: #FF; width: 280px; margin-left: 20px; margin-top: -12px;">
							<div id="rubrika_over" style="margin-top:<? if ($i==1) echo "0px"; else echo "20px";?>; margin-left:0px; background: <? echo $barva_web; ?>">
						    <? echo $rubrika_web;?></div>
												
								<div class="clearfix"></div>	

							<div class="datum" style="margin-top:-17px;"><? $create_date = explode (" ", $V[datum]); $create_datum = explode ("-", $create_date[0]);  $create_time = explode (":", $create_date[1]);
										$mesic=$create_datum[1]; 
										$create_datum = "$create_datum[2]".". "."$mesic_text[$mesic]"." "."$create_datum[0]"." | "."$create_time[0]".":"."$create_time[1]";
									    
									    echo $create_datum; ;
									    
									    ?></div>
						
		<div class="clearfix"></div>	


		<h3 class="archiv"><a href="<? echo '//'.$V[wiki_tabulka];?>.instory.cz/<? echo friendly_url($V[0], $V[titulek]);?>"><? echo $V[titulek];?></a></h3></div>
		</div>
		<? $i++; endwhile;
		if (($archiv+1)<$pocet_stran) { ?>

		<div class="next"><h1><a href="..<? if (!isset($cd)) echo '';?>/dalsi/<? echo $s; ?>–archiv–<? echo ($archiv+1);?><? if (isset($a)) echo "&amp;a=$a&amp;l=$limit1";?>" class="nextlink">Další články »</a></h1></div><? } 
		else  echo "<div class='bomba_black' style='margin-top:30px;' >Víc už toho není</div>";?>

		</div>
		
				<!-- LEFT Banners -->	
	
	<div style="position: absolute; left:630px; top:16px;">
		<div id="topSquare" style="margin-top:147px">
		<div style="margin-top: 20px; position: absolute; top: 0px;"><? $section_link="ostatni"; $PageId_sec="4"; include_once("banners/square_300x300.php");  ?></div>
		</div>
		</div>
		</div>
		<?  if (($i>4)||(isset($cd))) { ?><div style="position: absolute; top:230px;"><?include "db_vipstory_connect.php"; include("nazory.php");?></div><? } ?>
		<?  if (($i>7)||(isset($cd)))  { ?><div id="commentWrapper" style="top: 260px;"><? $section_link="ostatni"; $PageId_sec="4"; require("banners/sky_300x600.php"); include "db_vipstory_connect.php"; ?></div><? } ?>
	
	</div>

<!-- LEFT Banners KONEC -->	


		</div>
		
	
<!-- END of Timeline -->
	<div class="clearfix"></div>

		
<div style="margin-top: 45px;">

	<? include "story.php"; ?>
</div>	

<!-- END of Timeline -->

</div>
		<!-- Footer -->
	<? include("footer.php");?>
	<!-- End of Footer -->
<script src="/js/float_banner.js"></script>