<?php
                                echo "<div id='school'>";
                                echo "<div id='schools'>";
                                  echo "<h4>Testy</h4>";
                                  
                                  if(isset($_GET['id_predmet']))
                                    {
                                      if(is_numeric($_GET['id_predmet']))
                                        {
                                          if(!isset($_GET['akce']))
                                            {
                                              /*------------------------ NASTAVENI AKTIVITY TESTU ------------------------*/
                                              if(isset($_GET['stav']) AND isset($_GET['id_test']))
                                                {
                                                  if($_GET['stav'] == "aktivni" AND is_numeric($_GET['id_test']))
                                                    {
                                                      mysql_query("UPDATE vk_testy SET aktivni = 1 WHERE id='".intval($_GET['id_test'])."' AND id_predmet='".intval($_GET['id_predmet'])."'") or die(mysql_error());
                                                    }
                                                  elseif($_GET['stav'] == "neaktivni" AND is_numeric($_GET['id_test']))
                                                    {
                                                      mysql_query("UPDATE vk_testy SET aktivni = 0 WHERE id='".intval($_GET['id_test'])."' AND id_predmet='".intval($_GET['id_predmet'])."'") or die(mysql_error());
                                                    }
                                                }
                                              
                                              /*------------------------ KONEC NASTAVENI AKTIVITY TESTU ------------------------*/
                                              
                                              if(isset($_GET['slozka']))
                                                {
                                                  /*------------------------ VYPIS ULOZENYCH TESTU ------------------------*/
                                                  
                                                  
                                                        echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&akce=pridat#system'>Vytvořit nový test</a>";
                                                        echo "<div id='sclist'>";
                                                          echo "<h5>".jmeno_slozky($_GET['slozka'])."</h5>";
                                                        echo "</div>";
                                                        echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."#system'><img src='images/arrow_up.png' title='zpět na výpis složek' alt='zpet'> zpět na výpis složek</a><br /><br />";
                                                        
                                                  $vypis_testu = mysql_query("SELECT id, jmeno, typ, druh, DATE_FORMAT(od, '%e.%m:%Y %Hh') AS od_a, DATE_FORMAT(do, '%e.%m:%Y %Hh') AS do_a, aktivni FROM vk_testy WHERE id_zadal='".intval($_SESSION['id'])."' AND id_predmet='".intval($_GET['id_predmet'])."' AND slozka = '".intval($_GET['slozka'])."'") or die(mysql_error());
                                                  
                                                  if(mysql_num_rows($vypis_testu)==0)
                                                    {
                                                      echo "Žádný test nebyl vytvořen.";
                                                      
                                                      if(isset($_GET['ukol']))
                                                            {
                                                              echo "<br />";
                                                              if($_GET['ukol'] == "smazat")
                                                                {
                                                                  echo "Smazat složku včetně všech testů? <a href='page.php?q=testy&id_predmet=6&del_slozka=".$_GET['slozka']."#system'>ANO</a><br />";
                                                                }
                                                              elseif($_GET['ukol'] == "prejmenovat")
                                                                {
                                                                  if(isset($_POST['prejmenovat_slozku_x']))
                                                                    {
                                                                      if(trim($_POST['slozka']) == "")
                                                                        {
                                                                          echo "Jméno složky nesmí být prázdné.<br />";
                                                                        }
                                                                      else
                                                                        {
                                                                          if(mb_strlen($_POST['slozka']>30))
                                                                            {
                                                                              echo "Jméno složky je příliš dlouhé.<br />";
                                                                            }
                                                                          else
                                                                            {
                                                                              $kolik = mysql_query("SELECT id FROM vk_slozka WHERE id_predmet='".intval($_GET['id_predmet'])."' AND slozka='".mysql_real_escape_string($_POST['slozka'])."'");
                                                                              
                                                                              if(mysql_num_rows($kolik)!=0)
                                                                                {
                                                                                  echo "Jméno složky již existuje.<br />";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_query("UPDATE vk_slozka SET slozka='".mysql_real_escape_string($_POST['slozka'])."' WHERE id='".intval($_GET['slozka'])."'"))
                                                                                    echo "Složka upravena.<br />";
                                                                                  else
                                                                                    echo "Složku se nepodařilo upravit.<br />";
                                                                                }
                                                                            }
                                                                        }
                                                                    }
                                                                  
                                                                  $slozka = mysql_result(mysql_query("SELECT slozka FROM vk_slozka WHERE id='".intval($_GET['slozka'])."'"),0);
                                                                  
                                                                  echo "<form action='' method='POST'>";
                                                                    echo "<input type='text' name='slozka' value='".$slozka."' class='skola'> <input type='image' name='prejmenovat_slozku' src='images/rename.png'>";
                                                                  echo "</form>";
                                                                }
                                                              
                                                            }
                                                      echo "<div class='small'><br /><a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&ukol=smazat#system'>smazat složku</a> | <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&ukol=prejmenovat#system'>přejmenovat složku</a></div>";
                                                    }
                                                  else
                                                    {
                                                        echo "<h5>Přidané testy</h5>";
                                                        echo "<div id='sclist'>";
                                                          
                                                           echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."#system'><img src='images/arrow_up.png' title='zpět na výpis složek' alt='zpet'> zpět na výpis složek</a><br /><br />";
                                                          
                                                          /* ---------------- VYPSANI TESTU VE SLOZCE ----------------- */
                                                          while($detail_testy = mysql_fetch_assoc($vypis_testu))
                                                            {
                                                              switch($detail_testy['typ'])
                                                                {
                                                                  case 1 : $typ="<img src='images/test_skolni.png' alt='skolni' title='Školní test' />"; break;
                                                                  case 2 : $typ="<img src='images/test_domaci.png' alt='domaci' title='Domácí test' />"; break;
                                                                  case 3 : $typ="<img src='images/test_verejny.png' alt='verejny' title='Veřejný test' />"; break;
                                                                }
                                                              
                                                              echo "<div class='school'>
                                                                                          <div class='name'>".$typ." ".$detail_testy['jmeno']." - (".$detail_testy['od_a']." - ".$detail_testy['do_a'].")</div>
                                                                                          <div class='actions'>";
                                                                                  if($detail_testy['aktivni'] == 0)
                                                                      echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&id_test=".$detail_testy['id']."&stav=aktivni#system'><img src='images/red.gif' alt='neaktivni test' title='Neaktivní test (studentum se nezobrazuje)' /></a>";
                                                                    else
                                                                      echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&id_test=".$detail_testy['id']."&stav=neaktivni#system'><img src='images/green.gif' alt='aktivni test' title='Aktivní test (studentum se zobrazuje)' /></a>";
                                                                    //<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=pridat_otazku'><img src='images/vlozit_otazku.png' alt='vlozit otazku' title='Vložit otázku' /></a>      
                                                                    echo "
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=nahled_testu#system'><img src='images/lupa.png' alt='nahled testu' title='Náhled testu' /></a>
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=edit#system'><img src='images/edit.png' alt='upravit test' title='Upravit test' /></a>
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=kopirovat_test#system'><img src='images/copy.gif' alt='kopirovat test' title='Kopírovat test' /></a>
                                                                                        <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=smazat_test#system'><img src='images/delete.png' alt='delete' title='Smazat test' /></a>
                                                                                          </div>
                                                                                          <div class='clr'></div>
                                                                                      </div>";
                                                            }
                                                          
                                                          echo "<div class='small'><br /><a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&ukol=smazat#system'>smazat složku</a> | <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$_GET['slozka']."&ukol=prejmenovat#system'>přejmenovat složku</a></div>";
                                                          
                                                          if(isset($_GET['ukol']))
                                                            {
                                                              echo "<br />";
                                                              if($_GET['ukol'] == "smazat")
                                                                {
                                                                  echo "Smazat složku včetně všech testů? <a href='page.php?q=testy&id_predmet=6&del_slozka=".$_GET['slozka']."#system'>ANO</a><br />";
                                                                }
                                                              elseif($_GET['ukol'] == "prejmenovat")
                                                                {
                                                                  if(isset($_POST['prejmenovat_slozku_x']))
                                                                    {
                                                                      if(trim($_POST['slozka']) == "")
                                                                        {
                                                                          echo "Jméno složky nesmí být prázdné.<br />";
                                                                        }
                                                                      else
                                                                        {
                                                                          if(mb_strlen($_POST['slozka']>30))
                                                                            {
                                                                              echo "Jméno složky je příliš dlouhé.<br />";
                                                                            }
                                                                          else
                                                                            {
                                                                              $kolik = mysql_query("SELECT id FROM vk_slozka WHERE id_predmet='".intval($_GET['id_predmet'])."' AND slozka='".mysql_real_escape_string($_POST['slozka'])."'");
                                                                              
                                                                              if(mysql_num_rows($kolik)!=0)
                                                                                {
                                                                                  echo "Jméno složky již existuje.<br />";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_query("UPDATE vk_slozka SET slozka='".mysql_real_escape_string($_POST['slozka'])."' WHERE id='".intval($_GET['slozka'])."'"))
                                                                                    echo "Složka upravena.<br />";
                                                                                  else
                                                                                    echo "Složku se nepodařilo upravit.<br />";
                                                                                }
                                                                            }
                                                                        }
                                                                    }
                                                                  
                                                                  $slozka = mysql_result(mysql_query("SELECT slozka FROM vk_slozka WHERE id='".intval($_GET['slozka'])."'"),0);
                                                                  
                                                                  echo "<form action='' method='POST'>";
                                                                    echo "<input type='text' name='slozka' value='".$slozka."' class='skola'> <input type='image' name='prejmenovat_slozku' src='images/rename.png'>";
                                                                  echo "</form>";
                                                                }
                                                              
                                                            }
                                                          /* ---------------- KONEC VYPSANI TESTU VE SLOZCE ----------------- */
                                                        echo "</div>";
                                                    }
                                                  /*------------------------ KONEC VYPIS ULOZENYCH TESTU ------------------------*/
                                                }
                                              else // vypis testu bez slozky
                                                {
                                                
                                                  /*------------------------ VYPIS ULOZENYCH TESTU ------------------------*/
                                                  
                                                  
                                                        echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&akce=pridat#system'>Vytvořit nový test</a>";
                                                        echo "<div id='sclist'>";
                                                        echo "</div>";
                                                  
                                                  $vypis_testu = mysql_query("SELECT id, jmeno, typ, druh, DATE_FORMAT(od, '%e.%m:%Y %Hh') AS od_a, DATE_FORMAT(do, '%e.%m:%Y %Hh') AS do_a, aktivni FROM vk_testy WHERE id_zadal='".intval($_SESSION['id'])."' AND id_predmet='".intval($_GET['id_predmet'])."' AND slozka = 0") or die(mysql_error());
                                                  
                                                          /* --- ----- ------- SMAZAT SLOZKU ----------- */
                                                          
                                                          if(isset($_GET['del_slozka']))
                                                            {
                                                              // zjistit jaky testy jsou ve slozkce
                                                              $testy_smazat = mysql_query("SELECT id FROM vk_testy WHERE slozka='".intval($_GET['del_slozka'])."' AND id_predmet='".intval($_GET['id_predmet'])."'");
                                                              
                                                              while($test_smazat = mysql_fetch_assoc($testy_smazat))
                                                                {
                                                                  mysql_query("DELETE FROM vk_test_zak_nahoda WHERE id_test='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_zak_vypracovani WHERE id_test='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_zak_odpovedi WHERE id_test='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_odpovedi WHERE id_test='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_otazky WHERE id_test='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_testy WHERE id='".intval($test_smazat['id'])."'") or die(mysql_error());
                                                                }
                                                              
                                                              mysql_query("DELETE FROM vk_slozka WHERE id='".intval($_GET['del_slozka'])."'") or die(mysql_error());
                                                              
                                                              echo "Složka odstraněna.<br />";
                                                            }
                                                         
                                                         /* --- ----- ------- KONEC SMAZAT SLOZKU ----------- */
                                                          
                                                          /* ------------------------ VYTVORENI SLOZKY ------------------------*/
                                                  
                                                          if(isset($echo_pridat_slozku))
                                                            {
                                                              echo $echo_pridat_slozku."<div class='line'></div>";
                                                            }
                                                  
                                                          echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."#system' method='post'>";
            ;                                              echo "Název složky: <input type='text' name='slozka' class='skola'> <input type='image' name='vytor_slozku' src='images/submit_slozka.png'><br />";
                                                          echo "</form>";
                                                          
                                                          /* ------------------------ KONEC VYTVORENI SLOZKY ------------------------*/
                                                          
                                                          /* ---------------- VYPSANI SLOZEK ----------------- */
                                                          
                                                          $slozky = mysql_query("SELECT id, slozka FROM vk_slozka WHERE id_predmet='".intval($_GET['id_predmet'])."'");
                                                          
                                                          
                                                            while($slozka = mysql_fetch_assoc($slozky))
                                                              {
                                                                echo "<img src='images/folder.png' alt='slozka'> <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&slozka=".$slozka['id']."#system'>".$slozka['slozka']."</a><br />";
                                                              }
                                                          
                                                          
                                                          
                                                          /* ---------------- KONEC VYPSANI SLOZEK ----------------- */
                                                       
                                                  
                                                  if(mysql_num_rows($vypis_testu)==0)
                                                    {
                                                      echo "Žádný test nebyl vytvořen.";
                                                    }
                                                  else
                                                    {
                                                        echo "<h5>Přidané testy</h5>";
                                                        echo "<div id='sclist'>";
                                                        
                                                          /* ---------------- VYPSANI TESTU BEZ SLOZEK ----------------- */
                                                          while($detail_testy = mysql_fetch_assoc($vypis_testu))
                                                            {
                                                              switch($detail_testy['typ'])
                                                                {
                                                                  case 1 : $typ="<img src='images/test_skolni.png' alt='skolni' title='Školní test' />"; break;
                                                                  case 2 : $typ="<img src='images/test_domaci.png' alt='domaci' title='Domácí test' />"; break;
                                                                  case 3 : $typ="<img src='images/test_verejny.png' alt='verejny' title='Veřejný test' />"; break;
                                                                }
                                                              
                                                              echo "<div class='school'>
                                                                                          <div class='name'>".$typ." ".$detail_testy['jmeno']." - (".$detail_testy['od_a']." - ".$detail_testy['do_a'].")</div>
                                                                                          <div class='actions'>";
                                                                                  if($detail_testy['aktivni'] == 0)
                                                                      echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&stav=aktivni#system'><img src='images/red.gif' alt='neaktivni test' title='Neaktivní test (studentum se nezobrazuje)' /></a>";
                                                                    else
                                                                      echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&stav=neaktivni#system'><img src='images/green.gif' alt='aktivni test' title='Aktivní test (studentum se zobrazuje)' /></a>";
                                                                    //<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=pridat_otazku'><img src='images/vlozit_otazku.png' alt='vlozit otazku' title='Vložit otázku' /></a>      
                                                                    echo "
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=nahled_testu#system'><img src='images/lupa.png' alt='nahled testu' title='Náhled testu' /></a>
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=edit_test#system'><img src='images/edit.png' alt='upravit test' title='Upravit test' /></a>
                                                                          <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=kopirovat_test#system'><img src='images/copy.gif' alt='kopirovat test' title='Kopírovat test' /></a>
                                                                                        <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testy['id']."&akce=smazat_test#system'><img src='images/delete.png' alt='delete' title='Smazat test' /></a>
                                                                                          </div>
                                                                                          <div class='clr'></div>
                                                                                      </div>";
                                                            }
                                                          
                                                          
                                                          /* ---------------- KONEC VYPSANI TESTU BEZ SLOZEK ----------------- */
                                                        echo "</div>";
                                                    }
                                                  /*------------------------ KONEC VYPIS ULOZENYCH TESTU ------------------------*/
                                                }
                                            }
                                          else
                                            {
                                              if($_GET['akce'] == "pridat")
                                                {
                                                  // kontrola zda ucitel vyucuje predmet
                                                  $kontrola = mysql_query("SELECT id FROM vk_ucitel WHERE id_uzivatel='".intval($_SESSION['id'])."' AND id_predmet = '".intval($_GET['id_predmet'])."'");
                                                  
                                                  if(mysql_num_rows($kontrola) != 1)
                                                    {
                                                      echo "Pro zadaný předmět nemáte oprávnění tvořit testy.";
                                                    }
                                                  else
                                                    {
                                                        if(isset($echo_ucitel_pridat_test))
                                                          {
                                                            for($s=0;$s<count($echo_ucitel_pridat_test);$s++)
                                                              {
                                                                echo $echo_ucitel_pridat_test[$s]."<br />";
                                                              }
                                                            echo "<br />";
                                                          }
                                                        
                                                        include("include/form/ucitel_pridat_test.php");
                                                        
                                                    }
                                                }
                                              elseif($_GET['akce'] == "vytvoreno")
                                                {
                                                  echo "<div id='new_school'>";
                                                  $posledni_test = mysql_query("SELECT id, jmeno, druh, typ, pocet_otazek,pocet_nahodnych_otazek FROM vk_testy WHERE id_zadal = '".intval($_SESSION['id'])."' AND id_predmet='".intval($_GET['id_predmet'])."' ORDER BY id DESC LIMIT 0,1");
                                                  
                                                  if(mysql_num_rows($posledni_test) == 0)
                                                    {
                                                      echo "Test nebyl nalezen.";
                                                    }
                                                  else
                                                    {
                                                      $detail_testu = mysql_fetch_assoc($posledni_test);
                                                      
                                                      switch ($detail_testu['typ'])
                                                      {
                                                        case "1": $typ = "Školní"; break;
                                                        case "2": $typ = "Domácí"; break;
                                                        case "3": $typ = "Veřejný"; break;
                                                      }

                                                      switch ($detail_testu['druh'])
                                                      {
                                                        case "1": $druh = "textový"; break;
                                                        case "2": $druh = "zaškrtávací"; break;
                                                      }
                                                      
                                                      echo "<br />".$typ." ".$druh." test <b>".$detail_testu['jmeno']."</b> byl vytvořen.<br /><br />";
                                                      
                                                      /*  --------------- PRIDAT PRVNI OTAZKU S ODPOVEDI ------------------------*/
                                                      
                                                      
                                                      if(isset($_GET['nahodna']))
                                                        {
                                                          if(is_numeric($_GET['nahodna']))
                                                            {
                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku&nahodna=".$_GET['nahodna']."' method='POST'>";
                                                            }
                                                          else
                                                            {
                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                            }
                                                        }
                                                      else
                                                        {
                                                          echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                        }
                                                      
                                                        if($detail_testu['druh']==1) // textovy
                                                          {
                                                            if(!isset($_GET['nahodna']))
                                                              {
                                                                for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                  {
                                                                    include("include/form/pridat_otazku_t.php");
                                                                  }
                                                              }
                                                            else
                                                              {
                                                                if(is_numeric($_GET['nahodna']))
                                                                  {
                                                                    for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++) // odecist jednu otazku (posledni bude nahodna)
                                                                      {
                                                                        include("include/form/pridat_otazku_t.php");
                                                                      }
                                                                    
                                                                    /*for($opak=$detail_testu['pocet_otazek'];$opak<=$detail_testu['pocet_otazek']+$_GET['nahodna']-1;$opak++)
                                                                      {
                                                                        include("include/form/pridat_otazku_t_nahodna.php");
                                                                      }*/
                                                                    
                                                                    echo "<div class='line'></div>";
                                                                    
                                                                    $reset = 1;
                                                                    $celek = 1;
                                                                    $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                    $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                    
                                                                    for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                      {
                                                                        if(($reset % $_GET['nahodna']) == 0)
                                                                          {
                                                                            include("include/form/pridat_otazku_t_nahodna.php");
                                                                            echo "<div class='line'></div>";
                                                                            $reset=0;
                                                                            $celek++;
                                                                          }
                                                                        else
                                                                          {
                                                                            include("include/form/pridat_otazku_t_nahodna.php");
                                                                          }
                                                                        
                                                                        $reset++;
                                                                      }
                                                                    
                                                                  }
                                                                else
                                                                  {
                                                                    echo "Bylo vloženo něco špatně.";
                                                                  }
                                                              }
                                                            
                                                            echo "<input type='image' name='otazka-add-t-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-t-n' src='images/submit_test_neaktiv.png' />";
                                                          }
                                                        else  // zaskrtavaci
                                                          {
                                                            if(!isset($_GET['nahodna']))
                                                              {
                                                                for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                  {
                                                                    include("include/form/pridat_otazku.php");
                                                                  }
                                                              }
                                                            else
                                                              {
                                                                if(is_numeric($_GET['nahodna']))
                                                                  {
                                                                    for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                      {
                                                                        include("include/form/pridat_otazku.php");
                                                                      }
                                                                    
                                                                    echo "<div class='line'></div>";
                                                                    
                                                                    /*for($opak=$detail_testu['pocet_otazek'];$opak<=$detail_testu['pocet_otazek']+$_GET['nahodna']-1;$opak++)
                                                                      {
                                                                        include("include/form/pridat_otazku_nahodna.php");
                                                                      }*/
                                                                    $reset = 1;
                                                                    $celek = 1;
                                                                    $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                    $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                    
                                                                    for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                      {
                                                                        if(($reset % $_GET['nahodna']) == 0)
                                                                          {
                                                                            include("include/form/pridat_otazku_nahodna.php");
                                                                            echo "<div class='line'></div>";
                                                                            $reset=0;
                                                                            $celek++;
                                                                          }
                                                                        else
                                                                          {
                                                                            include("include/form/pridat_otazku_nahodna.php");
                                                                          }
                                                                        
                                                                        $reset++;
                                                                      }
                                                                  }
                                                              }
                                                            
                                                            echo "<input type='image' name='otazka-add-z-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-z-n' src='images/submit_test_neaktiv.png' />";
                                                          }
                                                      echo "</form>";
                                                      ?> 
                                                      
                                                       <?php
                                                      /*  --------------- KONEC PRIDAT PRVNI OTAZKU S ODPOVEDI ------------------------*/
                                                    }
                                                  
                                                  echo "</div>";
                                                }
                                            }
                                            
                                          /* ------------ TESTY OTAZKY ------------------------------ */
                                          if(isset($_GET['id_test']))
                                            {
                                              echo "<div id='new_school'>";
                                              if(!is_numeric($_GET['id_test']))
                                                {
                                                  echo "Špatná hodnota: ID_TEST.<br />";
                                                }
                                              else
                                                {
                                                  // kontrola zda ID otazky patri k ID TEST
                                                  $kontrola_test = mysql_query("SELECT id, druh, pocet_otazek, pocet_nahodnych_otazek FROM vk_testy WHERE id_predmet = '".intval($_GET['id_predmet'])."' AND id = '".intval($_GET['id_test'])."'");
                                                  
                                                  if(mysql_num_rows($kontrola_test) != 1)
                                                    {
                                                      echo "Špatně zadané hodnoty proměnných. Opakujte akci, nebo kontaktujte administrátora.<br />";
                                                    }
                                                  else
                                                    {
                                                      $detail_testu = mysql_fetch_assoc($kontrola_test);
                                                      if(isset($_GET['akce']))
                                                        {
                                                          if($_GET['akce'] == "pridat_otazku")
                                                            {
                                                              echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$_GET['id_test']."#system'>Výpis testů</a><br /><br />";
                                                              if($detail_testu['druh'] == 2) // zaskrtavaci
                                                                {
                                                                  
                                                                  //print_r($_POST);
                                                                  
                                                                  
                                                                  //echo "<br />";
                                                                  
                                                                  if((isset($_POST['otazka-add-z-a_x']) AND isset($_POST['otazka-add-z-a_y'])) OR (isset($_POST['otazka-add-z-n_x']) AND isset($_POST['otazka-add-z-n_y'])))
                                                                    {
                                                                    
                                                                      $pridat_otazku = true;
                                                                      $echo_pridat_otazku = Array();
                                                                      $otazka_chyba = Array();
                                                                      
                                                                      $pocet_otazek = $detail_testu['pocet_otazek'];
                                                                    
                                                                      //$pocet_otazek = $detail_testu['pocet_otazek'];
                                                                      //$pocet_nahodnych_otazek = count($_POST['otazka']) - $detail_testu['pocet_otazek'];
                                                                  
                                                                      for ($num=1;$num<=$pocet_otazek;$num++)
                                                                        {
                                                                          //echo "Otazka c.".$num."<br />";
                                                                          
                                                                          /* ----- kontrola otazka ----- */
                                                                          if(!isset($_POST['otazka'][$num])) // vlozena otazka
                                                                            {
                                                                              $otazka_chyba[$num]=true;
                                                                              $pridat_otazku = false;
                                                                              $echo_pridat_otazku[] = "Otázka č. ".$num." nebyla vložena.";
                                                                            }
                                                                          else
                                                                            {
                                                                              if(trim($_POST['otazka'][$num]) == "")
                                                                                {
                                                                                  $otazka_chyba[$num]=true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "Otázka č. ".$num." nebyla vložena.";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_real_escape_string($_POST['otazka'][$num])!= $_POST['otazka'][$num])
                                                                                    {
                                                                                      $otazka_chyba[$num]=true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Do otázky č. ".$num." byly vloženy nepovolené znaky.";
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          /* ----- KONEC kontrola otazka ----- */
                                                                          
                                                                          for($num2=1;$num2<=count($_POST['odpoved'][$num]);$num2++)
                                                                            {
                                                                              /* ----- kontrola odpovedi ----- */
                                                                              if(trim($_POST['odpoved'][$num][$num2]) == "")
                                                                                {
                                                                                  $otazka_chyba[$num]=true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "Odpověď č.".$num2." v otázce č. ".$num." je prázdná.";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_real_escape_string($_POST['odpoved'][$num][$num2])!= $_POST['odpoved'][$num][$num2])
                                                                                    {
                                                                                      $otazka_chyba[$num]=true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Odpověď č.".$num2." v otázce č. ".$num." obsahuje nepovolené znaky.";
                                                                                    }
                                                                                }
                                                                              /* ----- KONEC kontrola odpovedi ----- */
                                                                              
                                                                            }
                                                                          //echo "<br />";
                                                                          
                                                                          /* ----- kontrola spravne odpovedi ----- */
                                                                              if(!isset($_POST['spravna_odpoved'][$num]))
                                                                                {
                                                                                  $otazka_chyba[$num]=true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "Nebyla vybrána správná odpověď v otázce č. ".$num.".";
                                                                                }
                                                                              
                                                                          /* ----- KONEC kontrola spravne odpovedi ----- */
                                                                          
                                                                          /* ----- kontrola poctu odpovedi ----- */
                                                                              
                                                                              if(count($_POST['odpoved'][$num])<2) // musi byt minimalne 2 odpovedi
                                                                                {
                                                                                  $otazka_chyba[$num]=true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "V otázce č. ".$num." musí být vloženy minimálně 2 různé odpovědi.";
                                                                                }
                                                                          
                                                                          /* ----- KONEC kontrola poctu odpovedi ----- */      
                                                                          
                                                                          if(isset($otazka_chyba[$num]))
                                                                            {
                                                                              $echo_pridat_otazku[].= "<div class='line'></div>";
                                                                            }
                                                                        }
                                                                      
                                                                      if(isset($_GET['nahodna']))
                                                                        {
                                                                          if(is_numeric($_GET['nahodna']))
                                                                            {
                                                                              $reset = 1;
                                                                              $celek = 1;
                                                                              $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                              $opakovani = $detail_testu['pocet_otazek']+$opakovani;

                                                                              for ($num3=$pocet_otazek+1;$num3<=$opakovani;$num3++)
                                                                                {
                                                                                  //echo "Otazka c.".$num."<br />";
                                                                                  
                                                                                  /* ----- kontrola otazka ----- */
                                                                                  if(!isset($_POST['otazka'][$num3])) // vlozena otazka
                                                                                    {
                                                                                      $otazka_chyba[$num3]=true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Otázka č. ".$num3." nebyla vložena.";
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      if(trim($_POST['otazka'][$num3]) == "")
                                                                                        {
                                                                                          $otazka_chyba[$num3]=true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "Otázka č. ".$num3." nebyla vložena.";
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          if(mysql_real_escape_string($_POST['otazka'][$num3])!= $_POST['otazka'][$num3])
                                                                                            {
                                                                                              $otazka_chyba[$num3]=true;
                                                                                              $pridat_otazku = false;
                                                                                              $echo_pridat_otazku[] = "Do otázky č. ".$num3." byly vloženy nepovolené znaky.";
                                                                                            }
                                                                                        }
                                                                                    }
                                                                                  
                                                                                  /* ----- KONEC kontrola otazka ----- */
                                                                                  
                                                                                  for($num4=1;$num4<=count($_POST['odpoved'][$num3]);$num4++)
                                                                                    {
                                                                                      /* ----- kontrola odpovedi ----- */
                                                                                      if(trim($_POST['odpoved'][$num3][$num4]) == "")
                                                                                        {
                                                                                          $otazka_chyba[$num3]=true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "Odpověď č.".$num4." v otázce č. ".$num3." je prázdná.";
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          if(mysql_real_escape_string($_POST['odpoved'][$num3][$num4])!= $_POST['odpoved'][$num3][$num4])
                                                                                            {
                                                                                              $otazka_chyba[$num3]=true;
                                                                                              $pridat_otazku = false;
                                                                                              $echo_pridat_otazku[] = "Odpověď č.".$num4." v otázce č. ".$num3." obsahuje nepovolené znaky.";
                                                                                            }
                                                                                        }
                                                                                      /* ----- KONEC kontrola odpovedi ----- */
                                                                                      
                                                                                    }
                                                                                  //echo "<br />";
                                                                                  
                                                                                  /* ----- kontrola spravne odpovedi ----- */
                                                                                      if(!isset($_POST['spravna_odpoved'][$num3]))
                                                                                        {
                                                                                          $otazka_chyba[$num3]=true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "Nebyla vybrána správná odpověď v otázce č. ".$num3.".";
                                                                                        }
                                                                                      
                                                                                  /* ----- KONEC kontrola spravne odpovedi ----- */
                                                                                  
                                                                                  /* ----- kontrola poctu odpovedi ----- */
                                                                                      
                                                                                      if(count($_POST['odpoved'][$num3])<2) // musi byt minimalne 2 odpovedi
                                                                                        {
                                                                                          $otazka_chyba[$num3]=true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "V otázce č. ".$num3." musí být vloženy minimálně 2 různé odpovědi.";
                                                                                        }
                                                                                  
                                                                                  /* ----- KONEC kontrola poctu odpovedi ----- */      
                                                                                  if(isset($otazka_chyba[$num3]))
                                                                                    $echo_pridat_otazku[].= "<div class='line'></div>";
                                                                                    
                                                                                  $reset++;
                                                                                }
                                                                            }
                                                                        }

                                                                      if($pridat_otazku == true)
                                                                        {
                                                                          // ulozit normalni otazky
                                                                          for ($num=1;$num<=$pocet_otazek;$num++)
                                                                            {
                                                                              //echo "Otazka c.".$num."<br />";
                                                                              mysql_query("INSERT INTO vk_otazky (`id`, `id_test`, `otazka`, `nahodna`, `celek`) VALUES (NULL,'".intval($_GET['id_test'])."', '".mysql_real_escape_string($_POST['otazka'][$num])."', '1','0')") or die(mysql_error());
                                                                              $last_id = mysql_insert_id();
                                                                              
                                                                              for($num2=1;$num2<=count($_POST['odpoved'][$num]);$num2++)
                                                                                {
                                                                                  if($num2 == $_POST['spravna_odpoved'][$num])
                                                                                    $spravnost = 1; 
                                                                                  else
                                                                                    $spravnost = 2;
                                                                                    
                                                                                  mysql_query("INSERT INTO vk_odpovedi (`id`,`id_test`,`id_otazka`,`odpoved`,`spravnost`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($last_id)."','".mysql_real_escape_string($_POST['odpoved'][$num][$num2])."','$spravnost')") or die(mysql_error()."a");
                                                                                }
                                                                            }
                                                                          
                                                                          // ulozit nahodne otazky
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                                  
                                                                                  for ($num3=$pocet_otazek+1;$num3<=$opakovani;$num3++)
                                                                                    {
                                                                                      //echo "Otazka c.".$num."<br />";
                                                                                      mysql_query("INSERT INTO vk_otazky (`id`, `id_test`, `otazka`, `nahodna`, `celek`) VALUES (NULL,'".intval($_GET['id_test'])."', '".mysql_real_escape_string($_POST['otazka'][$num3])."', '2','".intval($celek)."')") or die(mysql_error()."b");
                                                                                      $last_id = mysql_insert_id();
                                                                                      
                                                                                      for($num4=1;$num4<=count($_POST['odpoved'][$num3]);$num4++)
                                                                                        {
                                                                                          if($num4 == $_POST['spravna_odpoved'][$num3])
                                                                                            $spravnost = 1; 
                                                                                          else
                                                                                            $spravnost = 2;
                                                                                            
                                                                                          mysql_query("INSERT INTO vk_odpovedi (`id`,`id_test`,`id_otazka`,`odpoved`,`spravnost`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($last_id)."','".mysql_real_escape_string($_POST['odpoved'][$num3][$num4])."','$spravnost')") or die(mysql_error()."c");
                                                                                        }
                                                                                      
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                      
                                                                                      $reset++;
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          if(isset($_POST['otazka-add-z-a_x']))
                                                                            {
                                                                              mysql_query("UPDATE vk_testy SET aktivni='1' WHERE id='".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                              $echo_pridat_otazku[] = "Aktivní test v pořádku uložen.";
                                                                            }
                                                                          else
                                                                            {
                                                                              $echo_pridat_otazku[] = "Neaktivní test v pořádku uložen.";
                                                                            }
                                                                        }
                                                                    }
                                                                    
                                                                  
                                                                  if(isset($echo_pridat_otazku))
                                                                    {
                                                                      if(count($echo_pridat_otazku)!=0)
                                                                        {
                                                                          for($o=0; $o < count($echo_pridat_otazku); $o++)
                                                                            {
                                                                              echo $echo_pridat_otazku[$o]."<br />";
                                                                            }
                                                                        }
                                                                    }
                                                                    
                                                                  if(isset($pridat_otazku)) // chyba, neco chybi ve formulari
                                                                    {
                                                                      if($pridat_otazku == true) // ulozeno - vypsat normalni form
                                                                        {
                                                                          //include("include/form/pridat_otazku.php");
                                                                        }
                                                                      else
                                                                        {
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku&nahodna=".$_GET['nahodna']."' method='POST'>";
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                            }
                                                                          
                                                                          for ($opak=1;$opak<=$pocet_otazek;$opak++)
                                                                            {
                                                                              print "
                                                                                    <div class='otazkaWrap' id='otazkaWrap-".$opak."'>
                                                                                    <p>
                                                                                    <label for='otazka-".$opak."'>Otázka: ".$opak."*</label>
                                                                                    <input type='text' name='otazka[".$opak."]' class='skola' value='".$_POST['otazka'][$opak]."' />
                                                                                    </p>
                                                                                    <br class='clr'/>
                                                                                    <label for='odpoved-".$opak."-1' class='labelOdpoved'>Odpověd: *</label><br />
                                                                                    
                                                                                      ";
                                                                              for($odpo=1; $odpo <= count($_POST['odpoved'][$opak]); $odpo++)
                                                                                    {
                                                                                      if(isset($_POST['spravna_odpoved'][$opak]))
                                                                                        {
                                                                                          if($_POST['spravna_odpoved'][$opak]==$odpo)
                                                                                            $check = "CHECKED ";
                                                                                          else
                                                                                            $check = "";
                                                                                        }
                                                                                      else
                                                                                        $check = "";
                                                                                      print "
                                                                                              <div class='odpoved odpoved-".$opak."-".$odpo."'>
                                                                                                <input type='radio' name='spravna_odpoved[".$opak."]' value='".$odpo."' class='skola-radio' ".$check." /> <input type='text' name='odpoved[".$opak."][".$odpo."]' class='skola' value='".$_POST['odpoved'][$opak][$odpo]."' /><br />
                                                                                              </div>
                                                                                              
                                                                                            ";
                                                                                    }
                                                                              
                                                                              print "
                                                                                      <div class='buttons'></div>
                                                                                    
                                                                                    </div>
                                                                                    <br class='clr'/> 
                                                                                    ";
                                                                             
                                                                             echo "\n<div class='line'></div>\n\n";
                                                                            }
                                                                          
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  echo "<div class='line'></div>";
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $numero = $detail_testu['pocet_otazek']+1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                                  for ($opak=$pocet_otazek+1;$opak<=$opakovani;$opak++)
                                                                                    {
                                                                                      print "
                                                                                            Náhodná otázka č. ".$celek."<br />
                                                                                            <div class='otazkaWrap' id='otazkaWrap-".$opak."'>
                                                                                            <p>
                                                                                            <label for='otazka-".$opak."'>Otázka: ".$numero."*</label>
                                                                                            <input type='text' name='otazka[".$opak."]' class='skola' value='".$_POST['otazka'][$opak]."' />
                                                                                            </p>
                                                                                            <br class='clr'/>
                                                                                            <label for='odpoved-".$opak."-1' class='labelOdpoved'>Odpověd: *</label><br />
                                                                                            
                                                                                              ";
                                                                                      for($odpo=1; $odpo <= count($_POST['odpoved'][$opak]); $odpo++)
                                                                                            {
                                                                                              if(isset($_POST['spravna_odpoved'][$opak]))
                                                                                                {
                                                                                                  if($_POST['spravna_odpoved'][$opak]==$odpo)
                                                                                                    $check = "CHECKED ";
                                                                                                  else
                                                                                                    $check = "";
                                                                                                }
                                                                                              else
                                                                                                $check = "";
                                                                                              print "
                                                                                                      <div class='odpoved odpoved-".$opak."-".$odpo."'>
                                                                                                        <input type='radio' name='spravna_odpoved[".$opak."]' value='".$odpo."' class='skola-radio' ".$check." /> <input type='text' name='odpoved[".$opak."][".$odpo."]' class='skola' value='".$_POST['odpoved'][$opak][$odpo]."' /><br />
                                                                                                      </div>
                                                                                                      
                                                                                                    ";
                                                                                            }
                                                                                      
                                                                                      print "
                                                                                              <div class='buttons'></div>
                                                                                            
                                                                                            </div>
                                                                                            <br class='clr'/> 
                                                                                            ";
                                                                                     
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          echo "<div class='line'></div>";
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                     
                                                                                      echo "\n<div class='line'></div>\n\n";
                                                                                      $numero++;
                                                                                      $reset++;
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          echo "<input type='image' name='otazka-add-z-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-z-n' src='images/submit_test_neaktiv.png' />";
                                                                          echo "</form>";
                                                                        }
                                                                    }
                                                                  else // nova otazka
                                                                    {
                                                                      //include("include/form/pridat_otazku.php");
                                                                      
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku&nahodna=".$_GET['nahodna']."' method='POST'>";
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                            }
                                                                          
                                                                          if(!isset($_GET['nahodna']))
                                                                            {
                                                                              for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                                {
                                                                                  include("include/form/pridat_otazku.php");
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                                    {
                                                                                      include("include/form/pridat_otazku.php");
                                                                                    }
                                                                                  
                                                                                  echo "<div class='line'></div>";
                                                                                  
                                                                                  /*for($opak=$detail_testu['pocet_otazek'];$opak<=$detail_testu['pocet_otazek']+$_GET['nahodna']-1;$opak++)
                                                                                    {
                                                                                      include("include/form/pridat_otazku_nahodna.php");
                                                                                    }*/
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                                  
                                                                                  for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                                    {
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          include("include/form/pridat_otazku_nahodna.php");
                                                                                          echo "<div class='line'></div>";
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          include("include/form/pridat_otazku_nahodna.php");
                                                                                        }
                                                                                      
                                                                                      $reset++;
                                                                                    }
                                                                                }
                                                                            }  
                                                                          
                                                                          echo "<input type='image' name='otazka-add-z-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-z-n' src='images/submit_test_neaktiv.png' />";
                                                                          echo "</form>";
                                                                          
                                                                    }
                                                                }
                                                              else  // textovy
                                                                {
                                                                  if((isset($_POST['otazka-add-t-a_x']) AND isset($_POST['otazka-add-t-a_y'])) OR (isset($_POST['otazka-add-t-n_x']) AND isset($_POST['otazka-add-t-n_y'])))
                                                                    {
                                                                      //print_r($_POST);
                                                                      $pridat_otazku = true;
                                                                      $echo_pridat_otazku = Array();
                                                                      $otazka_chyba = Array();
                                                                      
                                                                      $pocet_otazek = $detail_testu['pocet_otazek'];
                                                                       
                                                                      
                                                                      //$pocet_otazek = $detail_testu['pocet_otazek'];
                                                                      //$pocet_nahodnych_otazek = count($_POST['otazka']) - $detail_testu['pocet_otazek'];
                                                                      
                                                                      for($i=1;$i<=$pocet_otazek;$i++)
                                                                        {
                                                                          if(!isset($_POST['otazka'][$i])) // vlozena otazka
                                                                            {
                                                                              $otazka_chyba[$i] = true;
                                                                              $pridat_otazku = false;
                                                                              $echo_pridat_otazku[] = "Otázka č.".$i." nebyla vložena.";
                                                                            }
                                                                          else
                                                                            {
                                                                              if(trim($_POST['otazka'][$i]) == "")
                                                                                {
                                                                                  $otazka_chyba[$i] = true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "Otázka č.".$i." nebyla vložena.";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_real_escape_string($_POST['otazka'][$i])!= $_POST['otazka'][$i])
                                                                                    {
                                                                                      $otazka_chyba[$i] = true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Do otázky č.".$i." byly vloženy nepovolené znaky.";
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          if(!isset($_POST['odpoved'][$i])) // vlozena odpoveds
                                                                            {
                                                                              $otazka_chyba[$i] = true;
                                                                              $pridat_otazku = false;
                                                                              $echo_pridat_otazku[] = "Odpověď č.".$i." nebyla vložena.";
                                                                            }
                                                                          else
                                                                            {
                                                                              if(trim($_POST['odpoved'][$i]) == "")
                                                                                {
                                                                                  $otazka_chyba[$i] = true;
                                                                                  $pridat_otazku = false;
                                                                                  $echo_pridat_otazku[] = "Odpověď č.".$i." nebyla vložena.";
                                                                                }
                                                                              else
                                                                                {
                                                                                  if(mysql_real_escape_string($_POST['odpoved'][$i])!= $_POST['odpoved'][$i])
                                                                                    {
                                                                                      $otazka_chyba[$i] = true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Do odpovědi č.".$i." byly vloženy nepovolené znaky.";
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          if(isset($otazka_chyba[$i]))
                                                                            $echo_pridat_otazku[] .= "<div class='line'></div>";
                                                                        }
                                                                        
                                                                      if(isset($_GET['nahodna']))
                                                                        {
                                                                          
                                                                          if(is_numeric($_GET['nahodna']))
                                                                            {
                                                                              $reset = 1;
                                                                              $celek = 1;
                                                                              $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                              $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                              for($s=$pocet_otazek+1;$s<=$opakovani;$s++)
                                                                                {
                                                                                  if(!isset($_POST['otazka'][$s])) // vlozena otazka
                                                                                    {
                                                                                      $otazka_chyba[$s] = true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Otázka č.".$s." nebyla vložena.";
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      if(trim($_POST['otazka'][$s]) == "")
                                                                                        {
                                                                                          $otazka_chyba[$s] = true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "Otázka č.".$s." nebyla vložena.";
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          if(mysql_real_escape_string($_POST['otazka'][$s])!= $_POST['otazka'][$s])
                                                                                            {
                                                                                              $otazka_chyba[$s] = true;
                                                                                              $pridat_otazku = false;
                                                                                              $echo_pridat_otazku[] = "Do otázky č.".$s." byly vloženy nepovolené znaky.";
                                                                                            }
                                                                                        }
                                                                                    }
                                                                                  
                                                                                  if(!isset($_POST['odpoved'][$s])) // vlozena odpoveds
                                                                                    {
                                                                                      $otazka_chyba[$s] = true;
                                                                                      $pridat_otazku = false;
                                                                                      $echo_pridat_otazku[] = "Odpověď u otázky č.".$s." nebyla vložena.";
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      if(trim($_POST['odpoved'][$s]) == "")
                                                                                        {
                                                                                          $otazka_chyba[$s] = true;
                                                                                          $pridat_otazku = false;
                                                                                          $echo_pridat_otazku[] = "Odpověď u otázky č.".$s." nebyla vložena.";
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          if(mysql_real_escape_string($_POST['odpoved'][$s])!= $_POST['odpoved'][$s])
                                                                                            {
                                                                                              $otazka_chyba[$s] = true;
                                                                                              $pridat_otazku = false;
                                                                                              $echo_pridat_otazku[] = "Do odpovědi u otázky č.".$s." byly vloženy nepovolené znaky.";
                                                                                            }
                                                                                        }
                                                                                    }
                                                                                  
                                                                                  if(isset($otazka_chyba[$s]))
                                                                                    $echo_pridat_otazku[] .= "<div class='line'></div>";
                                                                                  
                                                                                  if(($reset % $_GET['nahodna']) == 0)
                                                                                    {
                                                                                      $reset=0;
                                                                                      $celek++;
                                                                                    }
                                                                                  
                                                                                  $reset++;
                                                                                  
                                                                                }
                                                                            }
                                                                        }
                                                                      
                                                                      if($pridat_otazku == true)
                                                                        {
                                                                          for($a=1;$a<=$pocet_otazek;$a++)
                                                                            {
                                                                              mysql_query("INSERT INTO vk_otazky (`id`, `id_test`, `otazka`,`nahodna`,`celek`) VALUES (NULL,'".intval($_GET['id_test'])."', '".mysql_real_escape_string($_POST['otazka'][$a])."','1','0')") or die(mysql_error());
                                                                              $last_id = mysql_insert_id();
                                                                              
                                                                              mysql_query("INSERT INTO vk_odpovedi (`id`,`id_test`,`id_otazka`,`odpoved`,`spravnost`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($last_id)."','".mysql_real_escape_string($_POST['odpoved'][$a])."', 1)") or die(mysql_error());
                                                                            }
                                                                          
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              //$reset = 1;
                                                                              //$celek = 1;
                                                                              //$opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                              //$opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                              
                                                                             /* for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                                {
                                                                                  if(($reset % $_GET['nahodna']) == 0)
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t_nahodna.php");
                                                                                      echo "<div class='line'></div>";
                                                                                      $reset=0;
                                                                                      $celek++;
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t_nahodna.php");
                                                                                    } */
                                                                                  
                                                                                  //$reset++;
                                                                                //}
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                                  
                                                                                  for($e=$pocet_otazek+1;$e<=$opakovani;$e++)
                                                                                    {
                                                                                      mysql_query("INSERT INTO vk_otazky (`id`, `id_test`, `otazka`,`nahodna`,`celek`) VALUES (NULL,'".intval($_GET['id_test'])."', '".mysql_real_escape_string($_POST['otazka'][$e])."','2','".intval($celek)."')") or die(mysql_error());
                                                                                      $last_id = mysql_insert_id();
                                                                                      
                                                                                      mysql_query("INSERT INTO vk_odpovedi (`id`,`id_test`,`id_otazka`,`odpoved`,`spravnost`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($last_id)."','".mysql_real_escape_string($_POST['odpoved'][$e])."', 1)") or die(mysql_error());
                                                                                      
                                                                                      
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                      
                                                                                      $reset++;
                                                                                    }
                                                                                }
                                                                            }
                                                                          
                                                                          if(isset($_POST['otazka-add-t-a_x']))
                                                                            {
                                                                              mysql_query("UPDATE vk_testy SET aktivni='1' WHERE id='".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                              $echo_pridat_otazku[] = "Aktivní test v pořádku uložen.";
                                                                            }
                                                                          else
                                                                            {
                                                                              $echo_pridat_otazku[] = "Neaktivní test v pořádku uložen.";
                                                                            }
                                                                        }
                                                                    }
                                                                    
                                                                  
                                                                  if(isset($echo_pridat_otazku))
                                                                    {
                                                                      if(count($echo_pridat_otazku)!=0)
                                                                        {
                                                                          for($o=0; $o < count($echo_pridat_otazku); $o++)
                                                                            {
                                                                              echo $echo_pridat_otazku[$o]."<br />";
                                                                            }
                                                                        }
                                                                    }
                                                                    
                                                                  if(isset($pridat_otazku)) // chyba, neco chybi ve formulari
                                                                    {
                                                                      if($pridat_otazku == true) // ulozeno - vypsat normalni form
                                                                        {
                                                                          //include("include/form/pridat_otazku_t.php");
                                                                        }
                                                                      else
                                                                        {
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku&nahodna=".$_GET['nahodna']."' method='POST'>";
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                            }
                                                                          
                                                                          for($i=1;$i<=$pocet_otazek;$i++)
                                                                            {
                                                                              echo "<div class='line'></div>";
                                                                              echo "<table border='0' width='550'>";
                                                                                echo "<tr>";
                                                                                  echo "<td><b>Otázka č.".$i.": *</b></td>";
                                                                                  echo "<td><input type='text' name='otazka[".$i."]' class='skola' value='".$_POST['otazka'][$i]."' /></td>";
                                                                                echo "</tr>";
                                                                                echo "<tr>";
                                                                                  echo "<td>Odpověď: *</td>";
                                                                                  echo "<td><input type='text' name='odpoved[".$i."]' class='skola' value='".$_POST['odpoved'][$i]."' /></td>";
                                                                                echo "</tr>";
                                                                              echo "</table>";
                                                                            }
                                                                          
                                                                          if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  //$reset = 1;
                                                                              //$celek = 1;
                                                                              //$opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                              //$opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                              
                                                                             /* for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                                {
                                                                                  if(($reset % $_GET['nahodna']) == 0)
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t_nahodna.php");
                                                                                      echo "<div class='line'></div>";
                                                                                      $reset=0;
                                                                                      $celek++;
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t_nahodna.php");
                                                                                    } */
                                                                                  
                                                                                  //$reset++;
                                                                                //}
                                                                                
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                              
                                                                                  for($i2=$pocet_otazek+1;$i2<=$opakovani;$i2++)
                                                                                    {
                                                                                      
                                                                                      echo "<div class='line'></div>";
                                                                                      echo "<table border='0' width='550'>";
                                                                                        echo "<tr>";
                                                                                          echo "<td colspan='2'>Náhodná otázka č. ".$celek."</td>";
                                                                                        echo "<tr>";
                                                                                        echo "<tr>";
                                                                                          echo "<td><b>Otázka č.".$i2.": *</b></td>";
                                                                                          echo "<td><input type='text' name='otazka[".$i2."]' class='skola' value='".$_POST['otazka'][$i2]."' /></td>";
                                                                                        echo "</tr>";
                                                                                        echo "<tr>";
                                                                                          echo "<td>Odpověď: *</td>";
                                                                                          echo "<td><input type='text' name='odpoved[".$i2."]' class='skola' value='".$_POST['odpoved'][$i2]."' /></td>";
                                                                                        echo "</tr>";
                                                                                      echo "</table>";
                                                                                      
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          echo "<div class='line'></div>";
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                      
                                                                                      $reset++;
                                                                                    }
                                                                                }
                                                                            }
                                                                          echo "<input type='image' name='otazka-add-t-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-t-n' src='images/submit_test_neaktiv.png' />";
                                                                          echo "</form>";
                                                                        }
                                                                    }
                                                                  else // nova otazka
                                                                    {
                                                                      //include("include/form/pridat_otazku_t.php");
                                                                      if(isset($_GET['nahodna']))
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku&nahodna=".$_GET['nahodna']."' method='POST'>";
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              echo "<form action='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$detail_testu['id']."&akce=pridat_otazku' method='POST'>";
                                                                            }
                                                                          
                                                                          if(!isset($_GET['nahodna']))
                                                                            {
                                                                              for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++)
                                                                                {
                                                                                  include("include/form/pridat_otazku_t.php");
                                                                                }
                                                                            }
                                                                          else
                                                                            {
                                                                              if(is_numeric($_GET['nahodna']))
                                                                                {
                                                                                  for($opak=1;$opak<=$detail_testu['pocet_otazek'];$opak++) // odecist jednu otazku (posledni bude nahodna)
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t.php");
                                                                                    }
                                                                                  
                                                                                  /*for($opak=$detail_testu['pocet_otazek'];$opak<=$detail_testu['pocet_otazek']+$_GET['nahodna']-1;$opak++)
                                                                                    {
                                                                                      include("include/form/pridat_otazku_t_nahodna.php");
                                                                                    }*/
                                                                                  
                                                                                  echo "<div class='line'></div>";
                                                                                  
                                                                                  $reset = 1;
                                                                                  $celek = 1;
                                                                                  $opakovani = $detail_testu['pocet_nahodnych_otazek']*$_GET['nahodna'];
                                                                                  $opakovani = $detail_testu['pocet_otazek']+$opakovani;
                                                                                  
                                                                                  for($opak=$detail_testu['pocet_otazek']+1;$opak<=$opakovani;$opak++)
                                                                                    {
                                                                                      if(($reset % $_GET['nahodna']) == 0)
                                                                                        {
                                                                                          include("include/form/pridat_otazku_t_nahodna.php");
                                                                                          echo "<div class='line'></div>";
                                                                                          $reset=0;
                                                                                          $celek++;
                                                                                        }
                                                                                      else
                                                                                        {
                                                                                          include("include/form/pridat_otazku_t_nahodna.php");
                                                                                        }
                                                                                      
                                                                                      $reset++;
                                                                                    }
                                                                                  
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "Bylo vloženo něco špatně.";
                                                                                }
                                                                            } 
                                                                          
                                                                          echo "<input type='image' name='otazka-add-t-a' src='images/submit_test_aktiv.png' /> <input type='image' name='otazka-add-t-n' src='images/submit_test_neaktiv.png' />";
                                                                          echo "</form>";
                                                                    }
                                                                }
                                                            }
                                                          elseif($_GET['akce'] == "smazat_test")
                                                            {
                                                              if(!isset($_GET['potvrdit']))
                                                                {
                                                                  echo "Opravdu smazat <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$_GET['id_test']."&akce=smazat_test&potvrdit=true#system'>ANO</a> | <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."#system'>NE</a>";
                                                                }
                                                              else
                                                                {
                                                                  mysql_query("DELETE FROM vk_odpovedi WHERE id_test = '".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_otazky WHERE id_test = '".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_testy WHERE id = '".intval($_GET['id_test'])."' AND id_predmet = '".intval($_GET['id_predmet'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_zak_odpovedi WHERE id_test = '".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_zak_vypracovani WHERE id_test = '".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                  mysql_query("DELETE FROM vk_test_zak_nahoda WHERE id_test = '".intval($_GET['id_test'])."'") or die(mysql_error());
                                                                  
                                                                  echo "Test byl úspěšně smazán. <a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."#system'>Pokračujte na výpis testů.</a>";
                                                                }
                                                            }
                                                          elseif($_GET['akce'] == "edit_test")
                                                            {
                                                              include("include/rozdeleni/testy/3_4_script_edit_test.php");
                                                              include("include/rozdeleni/testy/testy_edit_testu.php");
                                                            }
                                                          elseif($_GET['akce'] == "nahled_testu")
                                                            {
                                                              include("include/rozdeleni/testy/testy_nahled_testu.php");
                                                            }
                                                          elseif($_GET['akce'] == "kopirovat_test")
                                                            {
                                                              include("include/rozdeleni/testy/testy_kopirovat_test.php");
                                                            }
                                                        }
                                                    }
                                                }
                                              echo "</div>";
                                            }
                                              
                                              
                                          /* ------------ KONEC TEST OTAZKY ------------------------------ */
                                        }
                                      else
                                        {
                                          echo "Chyba: špatný parametr.";
                                        }
                                    }
                                  elseif(isset($_GET['tridni']))
                                    {
                                      if($_GET['tridni'] == true)
                                        {
                                          // zjistit v jake tride je tridni
                                          $id_zjistit = mysql_query("SELECT id_skola, id_trida FROM vk_ucitel WHERE id_uzivatel='".intval($_SESSION['id'])."' AND id_predmet IS NULL AND tridni_ucitel=1");
                                          if(mysql_num_rows($id_zjistit)!=1)
                                            {
                                              echo "Nastala chyba, kontaktujte administrátora.";
                                            }
                                          else
                                            {
                                              $vypsat_id = mysql_fetch_assoc($id_zjistit);
                                              
                                              echo vypsat_skolu_tridu($vypsat_id['id_skola'],$vypsat_id['id_trida'])." <br />";
                                              
                                              if(!isset($_GET['id_predmet'])) // vypsat vypis testu
                                                {
                                                  /*------------------------ VYPIS ULOZENYCH TESTU ------------------------*/
                                                    include("include/vypsat_vypis_testu_tridni.php");
                                                  /*------------------------ KONEC VYPIS ULOZENYCH TESTU ------------------------*/
                                                }
                                              else  // nahled testu
                                                {
                                                  if(!is_numeric($_GET['id_predmet']))
                                                    {
                                                      /*------------------------ VYPIS ULOZENYCH TESTU ------------------------*/
                                                        include("include/vypsat_vypis_testu_tridni.php");
                                                      /*------------------------ KONEC VYPIS ULOZENYCH TESTU ------------------------*/
                                                    }
                                                  else
                                                    {
                                                      if(!isset($_GET['akce']))
                                                        {
                                                          /*------------------------ VYPIS ULOZENYCH TESTU ------------------------*/
                                                            include("include/vypsat_vypis_testu_tridni.php");
                                                          /*------------------------ KONEC VYPIS ULOZENYCH TESTU ------------------------*/
                                                        }
                                                      else
                                                        {
                                                          if($_GET['akce'] == "nahled_testu")
                                                            {
                                                              $hlavicka = mysql_query("SELECT id_skola, id_trida, id_predmet, typ, jmeno, od, do, zn_1, zn_2, zn_3, zn_4, vaha, aktivni FROM vk_testy WHERE id='".$_GET['id_test']."'") or die(mysql_error());
                                                              
                                                              if(mysql_num_rows($hlavicka) != 1)
                                                                {
                                                                  echo "Požadovaný test nebyl nalezen. V případě opakovaných problémů, kontaktujte administrátora.";
                                                                }
                                                              else
                                                                {
                                                                  $hlavicka_detail = mysql_fetch_assoc($hlavicka);
                                                                  
                                                                  if($hlavicka_detail['aktivni']==1)
                                                                    $viditelnost = "ano";
                                                                  else
                                                                    $viditelnost = "ne";
                                                                  
                                                                  echo "Jméno testu: ".$hlavicka_detail['jmeno']."<br />";
                                                                  echo "Třída - předmět: ".vypsat_z_id_predmet($hlavicka_detail['id_predmet'])."<br />";
                                                                  echo "Začátek testu: ".$hlavicka_detail['od']."<br />";
                                                                  echo "Konec testu: ".$hlavicka_detail['do']."<br />";
                                                                  echo "Typ testu: ".vypsat_typ($hlavicka_detail['typ'])."<br />";
                                                                  echo "Známka 1 od: ".$hlavicka_detail['zn_1']." %<br />";
                                                                  echo "Známka 2 od: ".$hlavicka_detail['zn_2']." %<br />";
                                                                  echo "Známka 3 od: ".$hlavicka_detail['zn_3']." %<br />";
                                                                  echo "Známka 4 od: ".$hlavicka_detail['zn_4']." %<br />";
                                                                  echo "Váha známky: ".$hlavicka_detail['vaha']."<br />";
                                                                  echo "Viditelnost pro studenty: ".$viditelnost."<br />";
                                                                  
                                                                  
                                                                  /* -------------------- VYPIS OTAZEK UCITEL ------------------*/
                                                                  
                                                                  $otazky = mysql_query("SELECT ot.id AS id_otazka, ot.otazka, ot.nahodna, ot.celek, od.odpoved, od.spravnost FROM vk_otazky AS ot LEFT JOIN vk_odpovedi AS od ON ot.id=od.id_otazka WHERE ot.id_test='".intval($_GET['id_test'])."' AND od.id_test='".intval($_GET['id_test'])."' ORDER BY od.id") or die(mysql_error());
                                                                  
                                                                  echo "<div id='sclist'>";
                                                                  
                                                                  if(mysql_num_rows($otazky)==0)
                                                                    {
                                                                      echo "Nebyly vloženy žádné otázky k testu.<br />";
                                                                      //echo "<a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$_GET['id_test']."&akce=pridat_otazku'>Vložte otázky do testu</a>";
                                                                    }
                                                                  else
                                                                    {
                                                                      /* ----- VYPIS HLASKY PRI MAZANI OTAZKY ----- */
                                                                        if(isset($echo_del_otazku))
                                                                          echo $echo_del_otazku;
                                                                      /* ----- KONEC VYPIS HLASKY PRI MAZANI OTAZKY ----- */
                                                                    
                                                                      $posledni = "";
                                                                      $celek = "";
                                                                      $num = 1;
                                                                      $num2 = 1;
                                                                      while($otazka = mysql_fetch_assoc($otazky))
                                                                        {
                                                                            if($posledni != $otazka['id_otazka'])
                                                                              {
                                                                                if($otazka['nahodna']==1)
                                                                                  {
                                                                                    echo "<div class='otazka'>";
                                                                                      //echo "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."<span class='del'><a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$_GET['id_test']."&akce=nahled_testu&del_otazku=".$otazka['id_otazka']."'><img src='images/del.png' title='Smazat otázku'></a></span>";
                                                                                      echo "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."";
                                                                                    echo "</div>\n";
                                                                                    $num++;
                                                                                  }
                                                                                else
                                                                                  {
                                                                                    
                                                                                    echo "<div class='otazka'>";
                                                                                    if($celek != $otazka['celek'])
                                                                                      echo "<div class='line'></div>";
                                                                                      
                                                                                      echo "Náhodná otázka č. ".$otazka['celek']."<br /><br />";
                                                                                      //echo "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."<span class='del'><a href='page.php?q=testy&id_predmet=".$_GET['id_predmet']."&id_test=".$_GET['id_test']."&akce=nahled_testu&del_otazku=".$otazka['id_otazka']."'><img src='images/del.png' title='Smazat otázku'></a></span>";
                                                                                      echo "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."";
                                                                                    echo "</div>\n";
                                                                                    $num++;
                                                                                  }
                                                                              }
                                                                            echo "<div class='odpoved'>\n";
                                                                              if($otazka['spravnost'] == 1)
                                                                                echo "<input type='radio' class='skola-radio' CHECKED DISABLED /> \n";
                                                                              else
                                                                                echo "<input type='radio' class='skola-radio' DISABLED /> \n";
                                                                              
                                                                              echo "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                            echo "</div>\n";
                                                                          $posledni = $otazka['id_otazka'];
                                                                          $celek = $otazka['celek'];
                                                                        }
                                                                        
                                                                      echo "<div class='clr'></div>";
                                                                      echo "<br />";
                                                                    }
                                                                                    
                                                                                    
                                                                  echo "</div>";
                                                                  
                                                                  /* -------------------- KONEC VYPIS OTAZEK UCITEL ------------------*/
                                                                }
                                                            }
                                                          else
                                                            {
                                                              echo "Špatně zvolný parametr. <br />";
                                                            }
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                      else
                                        {
                                          echo "Špatná hodnota parametru. Opakujte akci nebo kontaktujte administrátora.<br />";
                                        }
                                    }
                                  else
                                    {
                                      echo "Nebyl určen předmět.";
                                    }
                                  
                                echo "</div>";
                                echo "</div>";
?>