function prDomy($spojeni) { $nahoru = $_POST["nahoru_x"]; $dolu = $_POST["dolu_x"]; $prejmenovat = $_POST["prejmenovat_x"]; $novy = $_POST["novy_x"]; $smazat = $_POST["smazat_x"]; $id = $_POST["iddum"]; $hidden = $_POST["hidden"]; if (!$hidden) { $hidden = 0; } $novynazev = $_POST["nazev" . $id]; $idMenu = $_SESSION["idm"]; $maxx = X_NAHLED; $maxy = Y_NAHLED; if ($novy) { $nazevn = $_POST["nazevn"]; $poradi = $_POST["poradi"]; $tmp_name = $_FILES["userfile"]["tmp_name"]; $cesta = "images/nove/"; $nazev = "{$nazevn}-nahled"; if ($tmp_name) { $nazevobr = UlozObrazek($cesta, $nazev, "M"); } $sql = "INSERT INTO domy (id_lDolniMenu,nazev,poradi,obrazek) VALUES ({$idMenu},'{$nazevn}',{$poradi},'{$cesta}{$nazevobr}')"; $res = PrSql($spojeni, $sql); $idn = mysqli_insert_id($spojeni); $sql = "INSERT INTO `domy_Menu` (`id_dum`, `nazev`, `poradi`, `odkaz`, `typ`, `zobrazit`) VALUES\n({$idn}, 'Vizualisations', 1, NULL, 'V', 1),\n({$idn}, 'Plans', 2, NULL, 'P', 1),\n({$idn}, 'Recommande', 3, NULL, 'D', 1),\n({$idn}, 'A télécharger', 4, NULL, 'K', 1);"; $res = PrSql($spojeni, $sql); } if ($prejmenovat) { $tmp_name = $_FILES["userfile"]["tmp_name"]; $cesta = CESTA_OBRAZKY; $nazev = "{$iddum}-{$novynazev}-nahled"; if (!$hidden) { $hidden = 0; } if ($tmp_name) { $nazevobr = UlozObrazek($cesta, $nazev, $maxx, $maxy); $sqlsoubor = ",obrazek='{$cesta}{$nazevobr}'"; } $sql = "UPDATE domy SET nazev='{$novynazev}',hidden={$hidden} {$sqlsoubor} where id_dum={$id}"; $res = PrSql($spojeni, $sql); } if ($smazat) { $sql = "DELETE from domy where id_dum={$id}; "; $res = PrSql($spojeni, $sql); $sql = "DELETE from domy_Menu where id_dum={$id};"; $res = PrSql($spojeni, $sql); $sql = "SELECT * from domy_Data where id_dum={$id};"; $res = PrSql($spojeni, $sql); while ($zaznam = mysqli_fetch_array($res)) { if ($zaznam["soubor"]) { echo "Mažu soubor : " . $zaznam["soubor"] . "<br>"; unlink($zaznam["soubor"]); } } $sql = "DELETE from domy_Data where id_dum={$id};"; $res = PrSql($spojeni, $sql); } if ($nahoru || $dolu) { $poradi = $_POST["poradi"]; if ($nahoru) { $sql = "SELECT * from domy where poradi<{$poradi} and id_ldolnimenu={$idMenu} order by poradi DESC LIMIT 1"; } else { $sql = "SELECT * from domy where poradi>{$poradi} and id_ldolnimenu={$idMenu} 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_dum"]; $porvrchni = $zaznam["poradi"]; $sql = "UPDATE domy SET poradi='{$porvrchni}' where id_dum={$id}"; $res = PrSql($spojeni, $sql); $sql = "UPDATE domy SET poradi='{$poradi}' where id_dum={$idvrchni}"; $res = PrSql($spojeni, $sql); } } zobrazDomy($spojeni); }
<div class="slider-left"> <div class="slider-right"> <div class="slidesa"> <div id="karta-domu33"> <div id="text-admin"> <?php $cmd = $_GET["cmd"]; switch ($cmd) { case "prldolnimenu": prDolniMenu($spojeni); break; case "editdomy": $idm = $_GET["idm"]; $_SESSION["idm"] = $idm; zobrazDomy($spojeni); break; case "prDomy": prDomy($spojeni); break; case "prDomy_Menu": prDomy_Menu($spojeni); break; case "prcontent_Menu": prContent_Menu($spojeni); break; case "editcontent_Data": editContent_Data($spojeni); break; case "prData_Domy": prData_Domy($spojeni);