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;