<?php
                              echo "<div id='school'>\n";
                                echo "\t<h4>Testy</h4>\n";
                                echo "<div id='schools'>\n";
                                  echo "<div id='sclist'>";
                                $id_skola_trida = zak_zjistit_id_vse($_SESSION['id']);
                                
                                if($id_skola_trida != true)
                                  {
                                    // chybova hlaska
                                    
                                    echo "Nastala neočekávaná chyba. Opakujte akci nebo kontaktujte administrátora.<br />";
                                  }
                                else
                                  {
                                    if(isset($_GET['id_test']))
                                      {
                                        if(!is_numeric($_GET['id_test']))
                                          {
                                            // chybova hlaska
                                            echo "Nesprávný parametr testu.<br /><br />";
                                            
                                            include("include/vypsat_zak_seznam_testu.php");
                                          }
                                        else
                                          {
                                            // kontrola zda zak opravdu studuje dany predmet testu
                                            $kontrola = mysql_query("SELECT id FROM vk_testy WHERE id='".intval($_GET['id_test'])."' AND id_skola='".intval($id_skola_trida['id_skola'])."' AND id_trida='".$id_skola_trida['id_trida']."' AND aktivni = 1");
                                            
                                            if(mysql_num_rows($kontrola) != 1)
                                              {
                                                // chybova hlaska - zadano spatne ID testu do adresy
                                                echo "K požadovanému testu nemáte přístup.<br /><br />";
                                                
                                                include("include/vypsat_zak_seznam_testu.php");
                                              }
                                            else
                                              {
                                                $kontrola2 = mysql_query("SELECT typ, druh, jmeno, zn_1, zn_2, zn_3, zn_4, vaha, pocet_otazek, pocet_nahodnych_otazek FROM vk_testy WHERE id='".intval($_GET['id_test'])."' AND id_skola='".intval($id_skola_trida['id_skola'])."' AND id_trida='".$id_skola_trida['id_trida']."' AND od < NOW() AND do > NOW() AND aktivni=1");
                                                if(mysql_num_rows($kontrola2) != 1)
                                                  {
                                                    // chybova hlaska - pokus o pristup k testu v nepovolenou dobu
                                                    echo "Požadovaný test není spuštěn.<br /><br />";
                                                    
                                                    include("include/vypsat_zak_seznam_testu.php");
                                                  }
                                                else
                                                  {
                                                    $detail_test = mysql_fetch_assoc($kontrola2);
                                                    $pocet_otazek_celkem = $detail_test['pocet_otazek']+$detail_test['pocet_nahodnych_otazek'];
                                                    // kontrola zda byl test jiz vypracovan
                                                    $pocet_zapsanych_odpovedi = mysql_query("SELECT id FROM vk_zak_odpovedi WHERE id_test='".intval($_GET['id_test'])."' AND id_zak='".intval($_SESSION['id'])."'");
                                                    
                                                    if(mysql_num_rows($pocet_zapsanych_odpovedi) != $pocet_otazek_celkem)
                                                      {
                                                        $ukonceny_test = false;
                                                        
                                                        echo "<b>Název testu: </b>".$detail_test['jmeno']."<br />";
                                                        echo "<b>Váha známky: </b>".$detail_test['vaha']."<br />";
                                                        
                                                        if(isset($_POST['odeslat_test_x'])) // odeslani zaskrtavaciho testu
                                                          {
                                                            if(isset($_POST['odpoved']))
                                                              {
                                                                $pocet_otazek_celkem = $detail_test['pocet_otazek']+$detail_test['pocet_nahodnych_otazek'];
                                                                if($pocet_otazek_celkem != count($_POST['odpoved']))
                                                                  {
                                                                    echo "<br />Nebyly vyplněny všechny otázky.<br />";
                                                                  }
                                                                else
                                                                  {
                                                                    $pocet_spravnych = 0;
                                                                    $pocet_spatnych = 0;
                                                                    foreach($_POST['odpoved'] AS $id_otazka => $id_odpoved)
                                                                      {
                                                                        if(!is_numeric($id_otazka) AND !is_numeric($id_odpoved))
                                                                          {
                                                                            // chybova hlaska - podvod, pokus o vlozeni cizich hodnot
                                                                          }
                                                                        else
                                                                          {
                                                                            $spravna_odpoved = mysql_fetch_assoc(mysql_query("SELECT id FROM vk_odpovedi WHERE id_test='".intval($_GET['id_test'])."' AND id_otazka='".intval($id_otazka)."' AND spravnost = 1"));
                                                                            
                                                                            if($spravna_odpoved['id'] == $id_odpoved)
                                                                              {
                                                                                $spravnost[$id_otazka] = 1;
                                                                                $pocet_spravnych++;
                                                                              }
                                                                            else
                                                                              {
                                                                                $spravnost[$id_otazka] = 2;
                                                                                $pocet_spatnych++;
                                                                              }
                                                                            
                                                                            
                                                                            //echo $id_otazka." - ".$id_odpoved." ".$spravnost[$id_otazka]."<br />";
                                                                            mysql_query("INSERT INTO vk_zak_odpovedi (`id`,`id_test`,`id_otazka`, `id_zak`,`id_odpoved_zak`,`id_odpoved_spravna`,`spravnost`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."', '".intval($id_otazka)."', '".intval($_SESSION['id'])."','".intval($id_odpoved)."', '".intval($spravna_odpoved['id'])."', '".$spravnost[$id_otazka]."', NOW())") or die(mysql_error());
                                                                            
                                                                          }
                                                                      }
                                                                    
                                                                    $procent = 100/$pocet_otazek_celkem;
                                                                    $celkem_procent = $procent*$pocet_spravnych;
                                                                    $vysledna_znamka = zjistit_znamku($detail_test['zn_1'],$detail_test['zn_2'],$detail_test['zn_3'],$detail_test['zn_4'],$celkem_procent);
                                                                    
                                                                    echo "<div class='line'></div>";
                                                                    echo "<br />Úspěšnost: ".$celkem_procent." %<br />";
                                                                    echo "Výsledná známka: ".$vysledna_znamka."<br />";
                                                                    
                                                                    if($detail_test['typ'] == 2) // domaci test
                                                                      {
                                                                        if($vysledna_znamka!=1) // nedostal za jedna .. zapsat nejvyssi skore a smazat odpovedi 
                                                                          {
                                                                            mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                            mysql_query("DELETE FROM vk_zak_odpovedi WHERE id_test = '".intval($_GET['id_test'])."' AND id_zak='".intval($_SESSION['id'])."'");
                                                                          }
                                                                        else // ziska jednicku
                                                                          {
                                                                            mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                            mysql_query("INSERT INTO vk_znamky (`id`,`id_skola`,`id_trida`,`id_predmet`, `id_uzivatel`, `znamka`,`vaha`,`datum`,`jmeno`) VALUES (NULL, '".intval($id_skola_trida['id_skola'])."','".intval($id_skola_trida['id_trida'])."', '".intval(vypsat_id_predmet_z_test($_GET['id_test']))."', '".intval($_SESSION['id'])."','".intval($vysledna_znamka)."', '".intval($detail_test['vaha'])."', NOW(), '".mysql_real_escape_string($detail_test['jmeno'])."')") or die(mysql_error());
                                                                            $ukonceny_test = true;
                                                                          }
                                                                      }
                                                                    else // skolni
                                                                      {
                                                                        mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                        mysql_query("INSERT INTO vk_znamky (`id`,`id_skola`,`id_trida`,`id_predmet`, `id_uzivatel`, `znamka`,`vaha`,`datum`,`jmeno`) VALUES (NULL, '".intval($id_skola_trida['id_skola'])."','".intval($id_skola_trida['id_trida'])."', '".intval(vypsat_id_predmet_z_test($_GET['id_test']))."', '".intval($_SESSION['id'])."','".intval($vysledna_znamka)."', '".intval($detail_test['vaha'])."', NOW(), '".mysql_real_escape_string($detail_test['jmeno'])."')") or die(mysql_error());
                                                                        $ukonceny_test = true;
                                                                      }
                                                                  }
                                                              }
                                                            else
                                                              {
                                                                echo "<br />Nebyly vyplněny všechny otázky.<br />";
                                                              }
                                                          }
                                                        
                                                        if(isset($_POST['odeslat_test_t_x'])) // pri odeslani textoveho testu
                                                          {
                                                            if(isset($_POST['odpoved']))
                                                              {
                                                                $pocet_otazek_celkem = $detail_test['pocet_otazek']+$detail_test['pocet_nahodnych_otazek'];
                                                                if($pocet_otazek_celkem != count($_POST['odpoved']))
                                                                  {
                                                                    echo "<br />Nebyly vyplněny všechny otázky.<br />";
                                                                  }
                                                                else
                                                                  {
                                                                    $pocet_spravnych = 0;
                                                                    $pocet_spatnych = 0;
                                                                    $vse_ok = true;
                                                                    $numero = 1;
                                                                    foreach($_POST['odpoved'] AS $id_otazka => $odpoved)
                                                                      {
                                                                        if(trim($odpoved) == "")
                                                                          {
                                                                            echo "<br />Nebyla vyplněna odpověď č. $numero.<br />";
                                                                            $vse_ok = false;
                                                                          }
                                                                        else
                                                                          {
                                                                            if(!is_numeric($id_otazka))
                                                                              {
                                                                                // chybova hlaska - podvod, pokus o vlozeni cizich hodnot
                                                                                $spravnost[$id_otazka] = 2;
                                                                                $pocet_spatnych++;
                                                                                $vse_ok = false;
                                                                              }
                                                                            else
                                                                              {
                                                                                $spravna_odpoved = mysql_num_rows(mysql_query("SELECT id FROM vk_odpovedi WHERE id_test='".intval($_GET['id_test'])."' AND id_otazka='".intval($id_otazka)."' AND odpoved='".mysql_real_escape_string($odpoved)."' AND spravnost = 1"));
                                                                                
                                                                                if($spravna_odpoved == 1)
                                                                                  {
                                                                                    $spravnost[$id_otazka] = 1;
                                                                                    $pocet_spravnych++;
                                                                                  }
                                                                                else
                                                                                  {
                                                                                    $spravnost[$id_otazka] = 2;
                                                                                    $pocet_spatnych++;
                                                                                  }
                                                                                
                                                                                
                                                                                //echo $id_otazka." - ".$id_odpoved." ".$spravnost[$id_otazka]."<br />";
                                                                                mysql_query("INSERT INTO vk_zak_odpovedi (`id`,`id_test`,`id_otazka`, `id_zak`, `id_odpoved_spravna`,`odpoved`,`spravnost`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."', '".intval($id_otazka)."', '".intval($_SESSION['id'])."', '".intval($spravna_odpoved['id'])."', '".mysql_real_escape_string($odpoved)."', '".$spravnost[$id_otazka]."', NOW())") or die(mysql_error());
                                                                                
                                                                              }
                                                                          }
                                                                        $numero++;
                                                                      }
                                                                    
                                                                    if($vse_ok == true)
                                                                      {
                                                                        $procent = 100/$pocet_otazek_celkem;
                                                                        $celkem_procent = $procent*$pocet_spravnych;
                                                                        $vysledna_znamka = zjistit_znamku($detail_test['zn_1'],$detail_test['zn_2'],$detail_test['zn_3'],$detail_test['zn_4'],$celkem_procent);
                                                                        
                                                                        echo "<div class='line'></div>";
                                                                        echo "<br />Úspěšnost: ".$celkem_procent." %<br />";
                                                                        echo "Výsledná známka: ".$vysledna_znamka."<br />";
                                                                        
                                                                        if($detail_test['typ'] == 2) // domaci test
                                                                          {
                                                                            if($vysledna_znamka!=1) // nedostal za jedna .. zapsat nejvyssi skore a smazat odpovedi 
                                                                              {
                                                                                mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                                mysql_query("DELETE FROM vk_zak_odpovedi WHERE id_test = '".intval($_GET['id_test'])."' AND id_zak='".intval($_SESSION['id'])."'");
                                                                              }
                                                                            else // ziska jednicku
                                                                              {
                                                                                mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                                mysql_query("INSERT INTO vk_znamky (`id`,`id_skola`,`id_trida`,`id_predmet`, `id_uzivatel`, `znamka`,`vaha`,`datum`,`jmeno`) VALUES (NULL, '".intval($id_skola_trida['id_skola'])."','".intval($id_skola_trida['id_trida'])."', '".intval(vypsat_id_predmet_z_test($_GET['id_test']))."', '".intval($_SESSION['id'])."','".intval($vysledna_znamka)."', '".intval($detail_test['vaha'])."', NOW(), '".mysql_real_escape_string($detail_test['jmeno'])."')") or die(mysql_error());
                                                                                $ukonceny_test = true;
                                                                              }
                                                                          }
                                                                        else // skolni
                                                                          {
                                                                            mysql_query("INSERT INTO vk_zak_vypracovani (`id`,`id_test`,`id_zak`,`procent`,`znamka`,`datum`) VALUES (NULL, '".intval($_GET['id_test'])."','".intval($_SESSION['id'])."', '".intval($celkem_procent)."', '".intval($vysledna_znamka)."', NOW())") or die(mysql_error());
                                                                            mysql_query("INSERT INTO vk_znamky (`id`,`id_skola`,`id_trida`,`id_predmet`, `id_uzivatel`, `znamka`,`vaha`,`datum`,`jmeno`) VALUES (NULL, '".intval($id_skola_trida['id_skola'])."','".intval($id_skola_trida['id_trida'])."', '".intval(vypsat_id_predmet_z_test($_GET['id_test']))."', '".intval($_SESSION['id'])."','".intval($vysledna_znamka)."', '".intval($detail_test['vaha'])."', NOW(), '".mysql_real_escape_string($detail_test['jmeno'])."')") or die(mysql_error());
                                                                            $ukonceny_test = true;
                                                                          }  
                                                                      }
                                                                    else
                                                                      {
                                                                        //smazat odpovedi pro nevyplnenem testu
                                                                        mysql_query("DELETE FROM vk_zak_odpovedi WHERE id_test = '".intval($_GET['id_test'])."' AND id_zak='".intval($_SESSION['id'])."'");
                                                                      }
                                                                  }
                                                              }
                                                            else
                                                              {
                                                                echo "<br />Nebyly vyplněny všechny otázky.<br />";
                                                              }
                                                          }
                                                        
                                                        if($ukonceny_test != true) // neukonceny test
                                                          {
                                                            if($detail_test['druh']==2) // zaskrtavaci
                                                              {
                                                                /* -------------------- VYPIS OTAZEK  ------------------*/
                                                                          
                                                                          $otazky = mysql_query("SELECT ot.id AS id_otazka, ot.otazka, ot.nahodna, ot.celek, od.id AS id_odpoved, 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 ot.id, od.id") or die(mysql_error());
                                                                          
                                                                          echo "<div id='new_school'>";
                                                                          if(mysql_num_rows($otazky)==0)
                                                                            {
                                                                              echo "Nebyly vloženy žádné otázky k testu.<br />";
                                                                              echo "<a href='page.php?q=testy#system'>Zpět na výpis testů.</a>";
                                                                            }
                                                                          else
                                                                            {
                                                                              //zjistit ID nahodne otazky pokud existuje
                                                                              
                                                                              $id_nahodne_otazky_query = mysql_query("SELECT id_otazka FROM vk_test_zak_nahoda WHERE id_test='".intval($_GET['id_test'])."' AND id_zak = '".intval($_SESSION['id'])."' ORDER BY id_otazka");
                                                                              
                                                                              if(mysql_num_rows($id_nahodne_otazky_query) == 0)
                                                                                {
                                                                                  $id_nahodne_otazky = false;
                                                                                }
                                                                              else
                                                                                {
                                                                                  //$zjisti_id = mysql_fetch_assoc($id_nahodne_otazky_query);
                                                                                  $id_nahodne_otazky = true;
                                                                                }
                                                                            
                                                                              echo "<form action='page.php?q=testy&id_test=".$_GET['id_test']."#system' method='POST'>";
                                                                              $posledni = "";
                                                                              $celek_change = "";
                                                                              $num = 1;
                                                                              $num2 = 0;
                                                                              $vypsat_test = "";
                                                                              $nahodna_otazka = Array();
                                                                              $nahodna_otazka_celek = Array();
                                                                              $nahodna_exist = false;
                                                                              while($otazka = mysql_fetch_assoc($otazky))
                                                                                {
                                                                                  if($otazka['nahodna']==1)
                                                                                    {
                                                                                      if($posledni != $otazka['id_otazka'])
                                                                                        {
                                                                                          $vypsat_test .= "<div class='otazka'>";
                                                                                            $vypsat_test .= "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."";
                                                                                          $vypsat_test .= "</div>\n";
                                                                                          $num++;
                                                                                        }
                                                                                      $vypsat_test .= "<div class='odpoved'>\n";
                                                                                      $checked = "";
                                                                                      if(isset($_POST['odpoved'][$otazka['id_otazka']]))
                                                                                        {
                                                                                          if($_POST['odpoved'][$otazka['id_otazka']] == $otazka['id_odpoved'])
                                                                                            $checked = " CHECKED";
                                                                                        }
                                                                                      $vypsat_test .= "<input type='radio' name='odpoved[".$otazka['id_otazka']."]' value='".$otazka['id_odpoved']."' class='skola-radio' $checked /> \n";
                                                                                      $vypsat_test .= "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                                      $vypsat_test .= "</div>\n";
                                                                                      $posledni = $otazka['id_otazka'];
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                          if($posledni != $otazka['id_otazka'])
                                                                                            {
                                                                                              $nahodna_otazka_celek[$otazka['celek']][] = $otazka['id_otazka']; 
                                                                                              $nahodna_exist = true;
                                                                                              $num2++;
                                                                                              $od = $num+$otazka['celek']-1;
                                                                                              $nahodna_otazka[$otazka['id_otazka']] = "";
                                                                                              $nahodna_otazka[$otazka['id_otazka']] .= "<div class='otazka'>";
                                                                                                $nahodna_otazka[$otazka['id_otazka']] .= "<b>Otázka č.".$od.":</b> ".$otazka['otazka']."";
                                                                                              $nahodna_otazka[$otazka['id_otazka']] .= "</div>\n";
                                                                                            
                                                                                            }
                                                                                          $nahodna_otazka[$otazka['id_otazka']] .= "<div class='odpoved'>\n";
                                                                                          $checked = "";
                                                                                          if(isset($_POST['odpoved'][$otazka['id_otazka']]))
                                                                                            {
                                                                                              if($_POST['odpoved'][$otazka['id_otazka']] == $otazka['id_odpoved'])
                                                                                                $checked = " CHECKED";
                                                                                            }
                                                                                          $nahodna_otazka[$otazka['id_otazka']] .= "<input type='radio' name='odpoved[".$otazka['id_otazka']."]' value='".$otazka['id_odpoved']."' class='skola-radio' $checked /> \n";
                                                                                          $nahodna_otazka[$otazka['id_otazka']] .= "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                                          $nahodna_otazka[$otazka['id_otazka']] .= "</div>\n";
                                                                                          $posledni = $otazka['id_otazka'];
                                                                                          $celek_change = $otazka['celek'];
                                                                                          
                                                                                    }
                                                                                }
                                                                              
                                                                              echo $vypsat_test;
                                                                               
                                                                              if($nahodna_exist == true) // pokud existuji nahodne otazky, pridat je k testu
                                                                                {
                                                                                  if($id_nahodne_otazky == false)
                                                                                    {
                                                                                      //print_r($nahodna_otazka_celek);
                                                                                      foreach($nahodna_otazka_celek AS $celek => $id_ot)
                                                                                        {
                                                                                          $nahodne = array_rand($nahodna_otazka_celek[$celek],1);
                                                                                          //echo "<br /><br />".$nahodna_otazka_celek[$celek][$nahodne]."<br />";
                                                                                          
                                                                                          echo $nahodna_otazka[$nahodna_otazka_celek[$celek][$nahodne]];
                                                                                          
                                                                                          if($detail_test['typ']==1) // pokud je skolni, ulozit variantu
                                                                                            mysql_query("INSERT INTO vk_test_zak_nahoda (`id`,`id_test`,`id_zak`,`id_otazka`) VALUES (NULL, '".intval($_GET['id_test'])."', '".intval($_SESSION['id'])."','".intval($nahodna_otazka_celek[$celek][$nahodne])."')");
                                                                                        }
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      //echo $nahodna_otazka[$id_nahodne_otazky];
                                                                                      
                                                                                      while($id_otazka = mysql_fetch_assoc($id_nahodne_otazky_query))
                                                                                        {
                                                                                          echo $nahodna_otazka[$id_otazka['id_otazka']];
                                                                                        }
                                                                                    }
                                                                                }
                                                                              
                                                                                
                                                                              echo "<span class='center'><input type='image' src='images/submit_test_zak.png' name='odeslat_test' /></span>";
                                                                              echo "<div class='clr'></div>";
                                                                              echo "</form>";
                                                                              echo "<br />";
                                                                            }
                                                                                            
                                                                          echo "</div>";
                                                                          
                                                                          /* -------------------- KONEC VYPIS OTAZEK  ------------------*/
                                                              }
                                                            else // textovy
                                                              {
                                                                /* -------------------- VYPIS OTAZEK  ------------------*/
                                                                          
                                                                          $otazky = mysql_query("SELECT ot.id AS id_otazka, ot.otazka, ot.nahodna, ot.celek, od.id AS id_odpoved 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'])."'") or die(mysql_error());
                                                                          
                                                                          echo "<div id='new_school'>";
                                                                          if(mysql_num_rows($otazky)==0)
                                                                            {
                                                                              echo "Nebyly vloženy žádné otázky k testu.<br />";
                                                                              echo "<a href='page.php?q=testy#system'>Zpět na výpis testů.</a>";
                                                                            }
                                                                          else
                                                                            {
                                                                              // zjistit ID nahodne otazky
                                                                              $id_nahodne_otazky_query = mysql_query("SELECT id_otazka FROM vk_test_zak_nahoda WHERE id_test='".intval($_GET['id_test'])."' AND id_zak = '".intval($_SESSION['id'])."' ORDER BY id_otazka");
                                                                              
                                                                              if(mysql_num_rows($id_nahodne_otazky_query) == 0)
                                                                                {
                                                                                  $id_nahodne_otazky = false;
                                                                                }
                                                                              else
                                                                                {
                                                                                  $id_nahodne_otazky = true;
                                                                                }
                                                                              
                                                                              echo "<form action='page.php?q=testy&id_test=".$_GET['id_test']."' method='POST'>";
                                                                              $nahodna_exist = false;
                                                                              $posledni = "";
                                                                              $celek_change = "";
                                                                              $num = 1;
                                                                              $num2 = 0;
                                                                              $vypsat_test = "";
                                                                              $nahodna_otazka = Array();
                                                                              $nahodna_otazka_celek = Array();
                                                                              
                                                                              while($otazka = mysql_fetch_assoc($otazky))
                                                                                {
                                                                                  if($otazka['nahodna']==1)
                                                                                    {
                                                                                        if($posledni != $otazka['otazka'])
                                                                                          {
                                                                                            $vypsat_test .= "<div class='otazka'>";
                                                                                              $vypsat_test .= "<b>Otázka č.".$num.":</b> ".$otazka['otazka']."";
                                                                                            $vypsat_test .= "</div>\n";
                                                                                            $num++;
                                                                                          }
                                                                                        $vypsat_test .= "<div class='odpoved'>\n";
                                                                                        $checked = "";
                                                                                        
                                                                                        $vypsat_test .= "<input type='text' name='odpoved[".$otazka['id_otazka']."]' class='skola' value='' /> \n";
                                                                                        $vypsat_test .= "</div>\n";
                                                                                        $posledni = $otazka['otazka'];
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      if($posledni != $otazka['otazka'])
                                                                                          {
                                                                                            $nahodna_otazka_celek[$otazka['celek']][] = $otazka['id_otazka'];
                                                                                            $nahodna_exist = true;
                                                                                            $num2++;
                                                                                            $od = $num+$otazka['celek']-1;
                                                                                            $nahodna_otazka[$otazka['id_otazka']] = "";
                                                                                            $nahodna_otazka[$otazka['id_otazka']] .= "<div class='otazka'>";
                                                                                              $nahodna_otazka[$otazka['id_otazka']] .= "<b>Otázka č.".$od.":</b> ".$otazka['otazka']."";
                                                                                            $nahodna_otazka[$otazka['id_otazka']] .= "</div>\n";
                                                                                          }
                                                                                        $nahodna_otazka[$otazka['id_otazka']] .= "<div class='odpoved'>\n";
                                                                                        $checked = "";
                                                                                        
                                                                                        $nahodna_otazka[$otazka['id_otazka']] .= "<input type='text' name='odpoved[".$otazka['id_otazka']."]' class='skola' value='' /> \n";
                                                                                        $nahodna_otazka[$otazka['id_otazka']] .= "</div>\n";
                                                                                        $posledni = $otazka['otazka'];
                                                                                        $celek_change = $otazka['celek'];
                                                                                    }
                                                                                }
                                                                              
                                                                              
                                                                              echo $vypsat_test;
                                                                              
                                                                              if($nahodna_exist == true) // pokud existuji nahodne otazky, pridat je k testu
                                                                                {

                                                                                  if($id_nahodne_otazky == false)
                                                                                    {
                                                                                      foreach($nahodna_otazka_celek AS $celek => $id_ot)
                                                                                        {
                                                                                          $nahodne = array_rand($nahodna_otazka_celek[$celek],1);
                                                                                          //echo "<br /><br />".$nahodna_otazka_celek[$celek][$nahodne]."<br />";
                                                                                          
                                                                                          echo $nahodna_otazka[$nahodna_otazka_celek[$celek][$nahodne]];
                                                                                          
                                                                                          if($detail_test['typ']==1) // pokud je skolni, ulozit variantu
                                                                                            mysql_query("INSERT INTO vk_test_zak_nahoda (`id`,`id_test`,`id_zak`,`id_otazka`) VALUES (NULL, '".intval($_GET['id_test'])."', '".intval($_SESSION['id'])."','".intval($nahodna_otazka_celek[$celek][$nahodne])."')");
                                                                                        }
                                                                                    }
                                                                                  else
                                                                                    {
                                                                                      while($id_otazka = mysql_fetch_assoc($id_nahodne_otazky_query))
                                                                                        {
                                                                                          echo $nahodna_otazka[$id_otazka['id_otazka']];
                                                                                        }
                                                                                    }
                                                                                }
                                                                                
                                                                              echo "<span class='center'><input type='image' src='images/submit_test_zak.png' name='odeslat_test_t' /></span>";
                                                                              echo "<div class='clr'></div>";
                                                                              echo "</form>";
                                                                              echo "<br />";
                                                                            }
                                                                                            
                                                                          echo "</div>";
                                                                          
                                                                          /* -------------------- KONEC VYPIS OTAZEK  ------------------*/
                                                              }
                                                          }
                                                        else
                                                          {
                                                            echo "Test byl vypracován.";
                                                          }
                                                      }
                                                    else
                                                      {
                                                        echo "Test jste již vypracoval(a).";
                                                      }
                                                  }
                                              }
                                          }
                                      }
                                    
                                    if(isset($_GET['ukoncen']))
                                      {
                                        if(!is_numeric($_GET['ukoncen']))
                                          {
                                            // chybova hlaska
                                            echo "Nesprávný parametr testu.<br /><br />";
                                            
                                            include("include/vypsat_zak_seznam_testu.php");
                                          }
                                        else
                                          {
                                            // kontrola zda zak opravdu studuje dany predmet testu
                                            $kontrola = mysql_query("SELECT id FROM vk_testy WHERE id='".intval($_GET['ukoncen'])."' AND id_skola='".intval($id_skola_trida['id_skola'])."' AND id_trida='".$id_skola_trida['id_trida']."' AND aktivni = 1");
                                            
                                            if(mysql_num_rows($kontrola) != 1)
                                              {
                                                // chybova hlaska - zadano spatne ID testu do adresy
                                                echo "K požadovanému testu nemáte přístup.<br /><br />";
                                                
                                                include("include/vypsat_zak_seznam_testu.php");
                                              }
                                            else
                                              {
                                                $kontrola2 = mysql_query("SELECT typ, druh, jmeno, vaha, pocet_otazek FROM vk_testy WHERE id='".intval($_GET['ukoncen'])."' AND id_skola='".intval($id_skola_trida['id_skola'])."' AND id_trida='".$id_skola_trida['id_trida']."' AND do < NOW() AND aktivni=1");
                                                if(mysql_num_rows($kontrola2) != 1)
                                                  {
                                                    // chybova hlaska - pokus o pristup k testu v nepovolenou dobu
                                                    echo "Požadovaný test není spuštěn.<br /><br />";
                                                    
                                                    include("include/vypsat_zak_seznam_testu.php");
                                                  }
                                                else
                                                  {
                                                    // kontrola zda byl test jiz vypracovan
                                                    $pocet_zapsanych_odpovedi = mysql_query("SELECT id FROM vk_zak_vypracovani WHERE id_test='".intval($_GET['ukoncen'])."' AND id_zak='".intval($_SESSION['id'])."'");
                                                    
                                                    if(mysql_num_rows($pocet_zapsanych_odpovedi) != 0)
                                                      {
                                                        $detail_test = mysql_fetch_assoc($kontrola2);
                                                        $detail_vysledek = vypsat_vaha_znamka_testu($_SESSION['id'],$_GET['ukoncen']);
                                                        echo "<b>Název testu: </b>".$detail_test['jmeno']."<br />";
                                                        echo "<b>Váha známky: </b>".$detail_test['vaha']."<br />";
                                                        echo "<b>Datum vypracování: </b>".$detail_vysledek['datum_a']."<br />";
                                                        echo "<b>Úspěšnost: </b>".$detail_vysledek['procent']."%<br />";
                                                        //echo "<b>Výsledná známka: </b>".$detail_vysledek['znamka']."<br />";
                                                        
                                                        if($detail_test['typ']==2)
                                                          {
                                                            if($detail_vysledek['znamka']!=1)
                                                              echo "<b>Výsledná známka: </b>nebyla udělena<br />";
                                                            else
                                                              echo "<b>Výsledná známka: </b>".$detail_vysledek['znamka']."<br />";
                                                          }
                                                        else
                                                          {
                                                            echo "<b>Výsledná známka: </b>".$detail_vysledek['znamka']."<br />";
                                                          }
                                                        
                                                        echo "<div id='new_school'>";
                                                        if($detail_test['druh']==2) // zaskrtavaci
                                                          {
                                                            /* -------------------- VYPIS OTAZEK ZAK ------------------*/
                                                                  
                                                                  $otazky = mysql_query("SELECT ot.id AS id_otazka, ot.otazka, od.id AS id_zadane, od.odpoved, od.spravnost,zak.id_odpoved_zak FROM vk_otazky AS ot LEFT JOIN vk_odpovedi AS od ON ot.id=od.id_otazka LEFT JOIN vk_zak_odpovedi AS zak ON ot.id=zak.id_otazka WHERE ot.id_test='".intval($_GET['ukoncen'])."' AND od.id_test='".intval($_GET['ukoncen'])."' AND zak.id_zak='".intval($_SESSION['id'])."'") or die(mysql_error());
                                                                  
                                                                  if(mysql_num_rows($otazky)==0)
                                                                    {
                                                                      echo "Test nebyl úspěšně vypracován.<br />";
                                                                    }
                                                                  else
                                                                    {
                                                                      $posledni = "";
                                                                      $num = 1;
                                                                      while($otazka = mysql_fetch_assoc($otazky))
                                                                        {
                                                                            if($posledni != $otazka['id_otazka'])
                                                                              {
                                                                                echo "<div class='otazka'>";
                                                                                  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";
                                                                              
                                                                              if($otazka['id_zadane'] == $otazka['id_odpoved_zak'] AND $otazka['spravnost'] == 1)
                                                                                echo "<input type='text' class='skola-true' value='".$otazka['odpoved']."' DISABLED />\n";
                                                                              elseif($otazka['id_zadane'] == $otazka['id_odpoved_zak'] AND $otazka['spravnost'] != 1)
                                                                                echo "<input type='text' class='skola-false' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                              else
                                                                                echo "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                            echo "</div>\n";
                                                                          $posledni = $otazka['id_otazka'];
                                                                        }
                                                                        
                                                                      echo "<div class='clr'></div>";
                                                                      echo "<br />";
                                                                    }
                                                                  
                                                                  /* -------------------- KONEC VYPIS OTAZEK ZAK ------------------*/
                                                          }
                                                        else // textovy
                                                          {
                                                            /* -------------------- VYPIS OTAZEK ZAK ------------------*/
                                                                  
                                                                  $otazky = mysql_query("SELECT ot.id AS id_otazka, ot.otazka, od.odpoved, zak.spravnost,zak.odpoved AS odpoved_zak FROM vk_otazky AS ot LEFT JOIN vk_odpovedi AS od ON ot.id=od.id_otazka LEFT JOIN vk_zak_odpovedi AS zak ON ot.id=zak.id_otazka WHERE ot.id_test='".intval($_GET['ukoncen'])."' AND od.id_test='".intval($_GET['ukoncen'])."' AND zak.id_zak='".intval($_SESSION['id'])."'") or die(mysql_error());
                                                                  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#system'>Vložte otázky do testu</a>";
                                                                    }
                                                                  else
                                                                    {
                                                                      $posledni = "";
                                                                      $num = 1;
                                                                      while($otazka = mysql_fetch_assoc($otazky))
                                                                        {
                                                                            if($posledni != $otazka['id_otazka'])
                                                                              {
                                                                                echo "<div class='otazka'>";
                                                                                  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";
                                                                                  echo "<input type='text' class='skola-true' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                                }
                                                                              else
                                                                                {
                                                                                  echo "<input type='radio' class='skola-radio' CHECKED DISABLED /> \n";
                                                                                  echo "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                                  echo "</div>\n";
                                                                                  echo "<div class='odpoved'>\n";
                                                                                  echo "<input type='radio' class='skola-radio' DISABLED /> \n";
                                                                                  echo "<input type='text' class='skola-false' value='".$otazka['odpoved_zak']."' DISABLED /> \n";
                                                                                }
                                                                              
                                                                              //echo "<input type='text' class='skola' value='".$otazka['odpoved']."' DISABLED /> \n";
                                                                            echo "</div>\n";
                                                                          $posledni = $otazka['id_otazka'];
                                                                        }
                                                                        
                                                                      echo "<div class='clr'></div>";
                                                                      echo "<br />";
                                                                    }
                                                                                    
                                                                  /* -------------------- KONEC VYPIS OTAZEK ZAK ------------------*/
                                                          }
                                                        echo "</div>";
                                                      }
                                                    else
                                                      {
                                                        echo "Test nebyl vypracován.";
                                                      }
                                                  }
                                              }
                                          }
                                      }
                                    
                                    if(!isset($_GET['id_test']) AND !isset($_GET['ukoncen']))
                                      {
                                        include("include/vypsat_zak_seznam_testu.php");
                                      }
                                  }
                                
                                  echo "</div>";
                                  echo "</div>";
                                echo "</div>";
?>