function prData_Domy($spojeni)
{
$id = $_POST["iddata"];
$iddum = $_SESSION["iddum"];
$idmenu = $_SESSION["iddomy_Menu"];
if (!$idmenu) {
return 0;
}
$datum = date('Y-m-d-H-i-s');
$nazevdomu = $_SESSION["nazevdomu"];
$typ = $_GET["typ"];
$typmenu = $_POST["typm"];
$novy = $_POST["novy_x"] || $_POST["novy"];
$nahoru = $_POST["nahoru_x"];
$dolu = $_POST["dolu_x"];
$smazat = $_POST["smazat_x"];
$text = $_POST["text"];
$prejmenovat = $_POST["prejmenovat_x"] || $_POST["prejmenovat"];
if ($novy) {
switch ($typ) {
case "O":
$poradi = $_POST["poradinove"];
$nazevobr = "{$iddum}-{$idmenu}-{$nazevdomu}-{$datum}";
$cesta = CESTA_OBRAZKY;
$nazevs = UlozObrazek($cesta, $nazevobr, $typmenu);
$nazevs = $cesta . $nazevs;
$nazevnahl = str_replace("obr-", "nahled-", $nazevs);
$sql = "INSERT INTO domy_Data (id_domy_Menu,id_dum,soubor,nahled,typ,poradi) VALUES ({$idmenu},{$iddum},'{$nazevs}','{$nazevnahl}','O',{$poradi})";
$res = PrSql($spojeni, $sql);
break;
case "S":
$poradi = $_POST["poradinove"];
$text = $_POST["textn"];
$nazevs = "soub-{$iddum}-{$idmenu}-{$nazevdomu}-{$datum}";
$cesta = CESTA_SOUBORY;
$nazevs = UlozSoubor($cesta);
$nazevs = $cesta . $nazevs;
$sql = "INSERT INTO domy_Data (id_domy_Menu,id_dum,soubor,text,typ,poradi) VALUES ({$idmenu},{$iddum},'{$nazevs}','{$text}','S',{$poradi})";
$res = PrSql($spojeni, $sql);
break;
case "T":
$text = $_POST["text"];
$sql = "INSERT INTO domy_Data (id_domy_Menu,id_dum,text,typ) VALUES ({$idmenu},{$iddum},'{$text}','T')";
$res = PrSql($spojeni, $sql);
break;
}
}
if ($prejmenovat) {
$sql = "UPDATE domy_Data SET text='{$text}' where id_domy_Data={$id}";
$res = PrSql($spojeni, $sql);
}
if ($smazat) {
$sql = "SELECT * from domy_Data where id_domy_Data={$id}";
$res = PrSql($spojeni, $sql);
$zaznam = mysqli_fetch_array($res);
$soubor = $zaznam["soubor"];
// if ($soubor) unlink($soubor);
$sql = "DELETE from domy_Data where id_domy_Data={$id}";
$res = PrSql($spojeni, $sql);
}
if ($nahoru || $dolu) {
$poradi = $_POST["poradi"];
if ($nahoru) {
$sql = "SELECT * from domy_Data where poradi<{$poradi} and id_dum={$iddum} order by poradi DESC LIMIT 1";
} else {
$sql = "SELECT * from domy_Data where poradi>{$poradi} and id_dum={$iddum} order by poradi ASC LIMIT 1";
}
$res = PrSQL($spojeni, $sql);
$pocet = mysqli_num_rows($res);
if ($pocet > 0) {
$zaznam = mysqli_fetch_array($res);
$idvrchni = $zaznam["id_domy_Data"];
$porvrchni = $zaznam["poradi"];
$sql = "UPDATE domy_Data SET poradi={$porvrchni} where id_domy_Data={$id}";
$res = PrSql($spojeni, $sql);
$sql = "UPDATE domy_Data SET poradi={$poradi} where id_domy_Data={$idvrchni}";
$res = PrSql($spojeni, $sql);
}
}
editData_Domy($spojeni);
}
break;
case "editcontent_Data":
editContent_Data($spojeni);
break;
case "prData_Domy":
prData_Domy($spojeni);
break;
case "editMenuDomy":
$iddum = $_GET["iddum"];
$_SESSION["iddum"] = $iddum;
zobrazDomyMenu($spojeni);
break;
case "editdata_Domy":
$iddum = $_GET["idm"];
$_SESSION["iddomy_Menu"] = $iddum;
editData_Domy($spojeni);
break;
case "zobrazLDolniMenu":
zobrazLDolniMenu($spojeni);
break;
case "zobrazcontent_Menu":
$idm = $_GET["idm"];
$_SESSION["idhmenu"] = $idm;
zobrazContent_Menu($spojeni);
break;
case "zobrazhlavni_Menu":
zobrazHlavni_Menu($spojeni);
break;
case "edithlavni_Data":
$idm = $_GET["idm"];
$_SESSION["idhmenu"] = $idm;
