コード例 #1
0
ファイル: admfunkce.php プロジェクト: ctiborv/mz-pt.ch
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);
}
コード例 #2
0
ファイル: admin48156.php プロジェクト: ctiborv/mz-pt.ch
        <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);