<?php
 	if(isset($_SESSION['id'])){
		echo'<div id="menu"> <!-- MENU Z -->
			<div id="innermenuhome">
			<ul>
   			<li><div id="btn1"><a href="index.php?page='.$domu.'">Domů</a></div></li>
   			<li class="dropdown">
				<div id="btn2"><a href="index.php?page='.$recenze.'">Herní recenze</a></div>
   					<div class="dropdown-content">
						<a href="index.php?page='.$akcni.'">Akční</a>
    			  		<a href="index.php?page='.$sportovni.'">Sportovní</a>

                <a href="index.php?page='.$zavodni.'">Závodní</a>
						</div>
			</li>


			<li class="dropdown">
   				<div id="btn3"><a href="index.php?page='.$novinky.'">Mobilní sekce</a></div>
   					<div class="dropdown-content">
    			  			<a href="index.php?page='.$hry.'">Mobilní hry</a>
    			  			<a href="index.php?page='.$hw.'">Mobilní app</a>
    			  		</div>
   			</li>
   			<li><div id="btn4"><a href="index.php?page='.$about.'">O nás</a></div></li>
   		<!--	<li><div id="btn5">';?><a href="mail.html" onclick="window.open('mail.html', 'mail', 'location=no,status=no,width=600,height=500,resizable'); return false">Napište nám</a></div></li> -->
   			<?php echo'<li><div id="btn6"><a href="index.php?page='.$forum.'">Forum</a></div></li>';
   			echo'<li><div id="btn7"><a href="index.php?page='.$admin.'&load=me-udaje">Administrace</a></div></li>
   			<li><div id="btn8"><a href="logout.php">Odhlásit se</a></div></li>';

			echo'</ul>
			</div>
			</div><!-- MENU K -->';
			}else {
		echo'<div id="menu"> <!-- MENU Z -->
			<div id="innermenuhome_odhlasen">
			<ul>
   			<li><div id="btn1"><a href="index.php?page='.$domu.'">Domů</a></div></li>
   			<li class="dropdown">
				<div id="btn2"><a href="index.php?page='.$recenze.'">Herní recenze</a></div>
   					<div class="dropdown-content">
						<a href="index.php?page='.$akcni.'">Akční</a>
    			  		<a href="index.php?page='.$sportovni.'">Sportovní</a>
    			  		<a href="index.php?page='.$zavodni.'">Závodní</a>
						</div>
			</li>


			<li class="dropdown">
   				<div id="btn3"><a href="index.php?page='.$novinky.'">Mobilní sekce</a></div>
   					<div class="dropdown-content">
    			  			<a href="index.php?page='.$hry.'">Mobilní hry</a>
    			  			<a href="index.php?page='.$hw.'">Mobilní app</a>
    			  		</div>
   			</li>
   			<li><div id="btn4"><a href="index.php?page='.$about.'">O nás</a></div></li>
   	<!--		<li><div id="btn5">';?><a href="mail.html" onclick="window.open('mail.html', 'mail', 'location=no,status=no,width=600,height=500,resizable'); return false">Napište nám</a></div></li> -->
   			<?php echo'<li><div id="btn6"><a href="index.php?page='.$forum.'">Forum</a></div></li>';
   			echo'<li><div id="btn7"><a href="index.php?page='.$admin.'&load=me-udaje">Administrace</a></div></li>';

			echo'</ul>
			</div>
			</div><!-- MENU K -->';}
	 ?>

<div id="container">
			<div id="obsah">
				<div id="floatbloky"><!-- float bloky Z -->

					<h1 style="margin-top:5px;margin-bottom:5px;text-align:middle; color: #ffa500;font-weight:bold"> Aktuality </h1>
						<?php
				include_once("config.php");
				/*$vypis1 = mysqli_query($id_spojeni, "SELECT * FROM novinka WHERE ID_novinka > (SELECT MAX(ID_novinka) - 5 FROM novinka) ORDER BY Pridan DESC");*/
				$vypis1 = mysqli_query($id_spojeni, "SELECT * FROM (SELECT ID_aktuality, NULL AS ID_turnaje, Pridan,Nazev,Podnadpis,Text,ID_uzivatel FROM aktuality UNION SELECT NULL AS ID_aktuality, ID_turnaje, Pridan,Nazev,Podnadpis,Text,ID_uzivatel FROM turnaje )AS tmptable2 ORDER BY STR_TO_DATE(`Pridan`,'%d-%m-%Y') DESC LIMIT 10");
				$vypis2 = mysqli_query($id_spojeni, "SELECT * FROM aktuality WHERE ID_aktuality > (SELECT MAX(ID_aktuality) - 5 FROM aktuality) ORDER BY Pridan DESC");
			echo'<div id="boxes">';
				while($nacti1= mysqli_fetch_array($vypis1)) {
					$id_turnaje = $nacti1['ID_turnaje'];
					$id_aktuality = $nacti1['ID_aktuality'];
					$jmeno = $nacti1['ID_uzivatel'];
					$nacti_jmeno = mysqli_query($id_spojeni, "SELECT * FROM uzivatel WHERE ID_uzivatel = '$jmeno'");
					while($vypis_jmeno = mysqli_fetch_array($nacti_jmeno)) {

						if($id_turnaje > 0) {
						echo'
								<div /*style="margin-top:20px;margin-bottom:20px; text-align:middle"*/class="easyblok" id="second" >
								<a href=index.php?page=turnaje&turnaje='.$nacti1["ID_turnaje"].'>
								<p class="nadpis_domu">'.$nacti1["Nazev"].'</p></a>
								<p class="napsal_domu">Autor '.$vypis_jmeno["Jmeno"].' | '.$nacti1["Pridan"].'</p>
								'.$nacti1["Podnadpis"].'
								<a class="vicedomu" href=index.php?page=turnaje&turnaje='.$nacti1["ID_turnaje"].'>Více...</a>
								</div>';
								}elseif($id_aktuality > 0) {
								echo'

								<div  /*style="margin-top:20px;margin-bottom:20px;text-align:middle"*/class="easyblok"  id="first" >
								<a href=index.php?page=aktuality&aktuality='.$nacti1["ID_aktuality"].'><p class="nadpis_domu">'.$nacti1["Nazev"].'</p></a>
								<p class="napsal_domu">Autor '.$vypis_jmeno["Jmeno"].' | '.$nacti1["Pridan"].'</p>

								'.$nacti1["Podnadpis"].'
								<a class="vicedomu" href=index.php?page=aktuality&aktuality='.$nacti1["ID_aktuality"].'>Více...</a>
								</div>';
								}
				}}
				echo'</div>';



					while($nacti2= mysqli_fetch_array($vypis2)) {
					$jmeno = $nacti2['ID_uzivatel'];
					$nacti_jmeno = mysqli_query($id_spojeni, "SELECT * FROM uzivatel WHERE ID_uzivatel = '$jmeno'");
					while($vypis_jmeno = mysqli_fetch_array($nacti_jmeno)) {
						/*echo'

								<td class="horizont" id="right" rowspan="2"><a href=index.php?page=recenze&recenze='.$nacti2["ID_recenze"].'><p class="nadpis">'.$nacti2["Nazev"].'</p></a>
								<p class="napsal">Autor '.$vypis_jmeno["Jmeno"].' | '.$nacti2["Pridan"].'</p>

								'.$nacti2["Podnadpis"].'
								<a href=index.php?page=recenze&recenze='.$nacti2["ID_recenze"].'>Více...</a></td>
							</tr>
						</table>';*/
				}}
			 ?>
				</div>
			 </div>
			</div>