{
$razeni = "v.datum desc";
$selected[0] = "selected";
}
if($odeslano_promazat)
{
$SQL = "select id from vzkazy
where (platnost_do<Now() and platnost_do<>'0000-00-00' and platnost_do is not null)";
if(DB_select($SQL, $vystup, $pocet))
{
while($zaznam = MySQL_fetch_array($vystup))
{
$SQL_vs = "delete from vzkazy_skupiny where id_vzkaz='".$zaznam["id"]."'";
DB_exec($SQL_vs);
$SQL_v = "delete from vzkazy where id='".$zaznam["id"]."'";
DB_exec($SQL_v);
}
}
}
$SQL_neplatne = "select platnost_do from vzkazy where platnost_do<Now() and platnost_do<>'0000-00-00' and platnost_do is not null";
if(DB_select($SQL_neplatne, $vystup, $pocet_neplatnych))
{
while($zaz = MySQL_fetch_array($vystup))
{
$neplatne[] = $zaz["platnost_do"];
}
}
if($pocet_neplatnych<>0) $pocet_neplatnych = "<font color=red><b>$pocet_neplatnych</b></font>";
$SQL = " select distinct v.id id_vzkazu, v.text text, v.datum datum,
v.platnost_do platnost_do, v.trida trida, v.predmet predmet,
u.jmeno jmeno, u.prijmeni prijmeni, s.skupina skupina
$podminka = " id = '".$vymaz[0]."' ";
for($i=1;$i<count($vymaz);$i++)
{
$podminka .= " or id = '".$vymaz[$i]."' ";
}
$SQL = "select nazev from soubory where $podminka ";
if(DB_select($SQL, $vystup, $pocet))
{
while($zaznam = MySQL_fetch_array($vystup))
{
if(!(unlink(c_files."files_kraj/".$zaznam["nazev"])))
echo "soubor ".$zaznam["nazev"]." se nepodaøilo odstranit";
}
}
$SQL = "delete from soubory where $podminka";
DB_exec($SQL);
$vyber=2;
}
switch($vyber)
{
case 1:
//Tlacitka($kod, "k_edit_prilohy.php", $pole_vyberu, $pole_tlacitek,1);
/************ ulozit prilohu *******************************************/
echo "<center>".Hlaska($chyba, "Soubor se nepodaøilo ulo¾it", "Soubor byl úspì¹nì ulo¾en")."</center>";
if($chyba<>"ok")
{
echo "<form action=\"./k_send_prilohy.php?kod=$kod\" method=post enctype=\"multipart/form-data\">";
$SQL = "select * from soubory where typ='k_zpravodaj' order by datum desc";
if(DB_select($SQL, $vystup, $pocet))
{
if($pocet==0) echo Text_alter("","V databázi nejsou ulo¾eny ¾ádné zpravodaje.");
if(Prihlasen3($kod, $REMOTE_ADDR, $skupina, 5, $fullname, $login, $chyba))
{
NoCACHE();
Hlavicka("Oprava vlastních údajù", $fullname, $kod);
if($odeslano_udaje)
{
if(StrPos(StrToLower(" ".$url), "http://")==false and EReg_Replace(" ", "", $url)<>"") $url = "http://$url";
$SQL = "select * from ucitele where login = '******'";
DB_select($SQL, $vystup, $pocet);
$SQL_update = "update ucitele set titul_pred='$titul_pred', titul_za='$titul_za', tel2='$tel2', mail2='$mail2', url='$url', vyuc_oa='$vyucuje_OA', vyuc_vose='$vyucuje_VOSE' where login='******'";
DB_exec($SQL_update);
}
else
{
$SQL_insert = "insert into rozvrhy (login_uc, predmety, tridy, ucebny, aktualizace) values ('$login', '$predmet', '$trida','$ucebna', 'Now()')";
DB_exec($SQL_insert);
}
$SQL = "select * from ucitele where login='******'";
if(DB_select($SQL, $vystup, $pocet))
{
if($zaznam=MySQL_fetch_array($vystup))
{
$jmeno = $zaznam["jmeno"];
$prijmeni = $zaznam["prijmeni"];
$titul_pred = $zaznam["titul_pred"];
$titul_za = $zaznam["titul_za"];
$zkratka = $zaznam["zkratka"];
$kabinet = $zaznam["kabinet"];
$vyucuje_OA = $zaznam["vyuc_oa"];
$vyucuje_VOSE = $zaznam["vyuc_vose"];
$mail1 = $zaznam["mail1"];
function Uloz_uziv($login, $fullname, $id_skup, $prava, &$kod)
{ global $REMOTE_ADDR;
$log = "log_uloz.txt";
VytvorLog($log);
srand((double)microtime()*1e6);
$kod = "$login|$id_skup|".rand();
ZapisDoLogu($log, "kod=$kod");
$cas = date("Y-m-d H:i:s");
/*$SQL = "delete from prihl_uziv where ip='$REMOTE_ADDR' and kod<>'$kod' ";
DB_exec($SQL);*/
$SQL = "select count(*) pocet from prihl_uziv where login_uc = '$login'";
DB_select($SQL, $vystup, $zaznamu);
$zaznam = MySQL_fetch_array($vystup);
if ($zaznam["pocet"]==0)
{
$SQL = "insert into prihl_uziv(kod, ip, fullname, cas, login_uc, skupina, prava) values
('$kod', '$REMOTE_ADDR', '$fullname', '$cas', '$login', '$id_skup', '$prava')";
}
else
{
$SQL = "update prihl_uziv set kod='$kod', ip='$REMOTE_ADDR', fullname='$fullname',
cas='$cas', skupina='$id_skup' where login_uc='$login' ";
}
DB_exec($SQL);
$cas = time()+3600*24*365;
/*echo "kod = $kod";
echo "cas = $cas";*/
}
if(StrPos(StrToLower(" ".$url), "http://")==false and EReg_Replace(" ", "", $url)<>"") $url = "http://$url";
/* UlozFoto($foto1, $foto1_type, $foto1_nazev, 1);
UlozFoto($foto2, $foto2_type, $foto2_nazev, 2);
UlozFoto($foto3, $foto3_type, $foto3_nazev, 3);*/
$SQL = "select * from ucitele where login = '******'";
DB_select($SQL, $vystup, $pocet);
$SQL_update = "update ucitele set titul_pred='$titul_pred',
titul_za='$titul_za', jmeno='$jmeno',
prijmeni='$prijmeni', id_skup = '$skupina_id',
zkratka='$zkratka', kabinet='$kabinet',
tel1='$tel1', tel2='$tel2', mail1='$mail1',
mail2='$mail2', url='$url', vyuc_oa='$vyucuje_OA',
vyuc_vose='$vyucuje_VOSE', aktivni='$aktivni'
where login='******'";
DB_exec($SQL_update);
$chyba="ok";
}
}
else
{
$SQL = "select * from ucitele where login='******'";
if(DB_select($SQL, $vystup, $pocet))
{
if($zaznam=MySQL_fetch_array($vystup))
{
$login = $zaznam["login"];
$jmeno = $zaznam["jmeno"];
$prijmeni = $zaznam["prijmeni"];
$skupina_id = $zaznam["id_skup"];
$titul_pred = $zaznam["titul_pred"];
