PHP Dosya Yöneticisi

<?php
echo !defined("GUVENLIK") ? exit : NULL;
if ($yetki["demo"] != "1") {
    if (isset($_GET["status"])) {
        if ($_GET["status"] == "comment_set" || $_GET["status"] == "comment_process" || $_GET["status"] == "comment_edit" || $_GET["status"] == "category_add" || $_GET["status"] == "variant_add" || $_GET["status"] == "variant_multidelete" || $_GET["status"] == "variant_edit" || $_GET["status"] == "variant_group_add" || $_GET["status"] == "variant_group_edit" || $_GET["status"] == "variant_group_delete" || $_GET["status"] == "feature_group_add" || $_GET["status"] == "feature_group_edit" || $_GET["status"] == "feature_group_multidelete" || $_GET["status"] == "feature_add" || $_GET["status"] == "feature_edit" || $_GET["status"] == "feature_multidelete" || $_GET["status"] == "ecatalog_add" || $_GET["status"] == "ecatalog_edit" || $_GET["status"] == "ecatalog_multidelete" || $_GET["status"] == "brand_multidelete" || $_GET["status"] == "brand_delete" || $_GET["status"] == "brand_add" || $_GET["status"] == "brand_edit" || $_GET["status"] == "sub_category_delete" || $_GET["status"] == "subcategories_multidelete" || $_GET["status"] == "sub_category_edit" || $_GET["status"] == "sub_category_add" || $_GET["status"] == "category_edit" || $_GET["status"] == "categories_multidelete" || $_GET["status"] == "category_delete" || $_GET["status"] == "category_delete") {
            if ($_GET["status"] == "comment_process") {
                if ($_POST) {
                    $IDler = $_POST["processID"];
                    if ("0" < $IDler) {
                        $deleteName = trim(strip_tags($_POST["delete"]));
                        $successName = trim(strip_tags($_POST["active"]));
                        $noOnay = trim(strip_tags($_POST["pasive"]));
                        $bekle = trim(strip_tags($_POST["noposition"]));
                        if ($deleteName == "1" || $successName == "1" || $noOnay == "1" || $bekle == "1") {
                            if ($deleteName == "1") {
                                foreach ($IDler as $ids) {
                                    $yorumSsql = $db->prepare("select * from urun_yorum where id=:id");
                                    $yorumSsql->execute(["id" => $ids]);
                                    if ("0" < $yorumSsql->rowCount()) {
                                        $silmeislem = $db->prepare("DELETE from urun_yorum WHERE id=:id");
                                        $sil = $silmeislem->execute(["id" => $ids]);
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                                }
                            }
                            if ($successName == "1") {
                                foreach ($IDler as $ids) {
                                    $yorumSsql = $db->prepare("select * from urun_yorum where id=:id");
                                    $yorumSsql->execute(["id" => $ids]);
                                    if ("0" < $yorumSsql->rowCount()) {
                                        $guncelle = $db->prepare("UPDATE urun_yorum SET\r\n                                                onay=:onay\r\n                                         WHERE id=" . $ids . "      \r\n                                        ");
                                        $sonuc = $guncelle->execute(["onay" => "1"]);
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                                }
                            }
                            if ($noOnay == "1") {
                                foreach ($IDler as $ids) {
                                    $yorumSsql = $db->prepare("select * from urun_yorum where id=:id");
                                    $yorumSsql->execute(["id" => $ids]);
                                    if ("0" < $yorumSsql->rowCount()) {
                                        $guncelle = $db->prepare("UPDATE urun_yorum SET\r\n                                                onay=:onay\r\n                                         WHERE id=" . $ids . "      \r\n                                        ");
                                        $sonuc = $guncelle->execute(["onay" => "2"]);
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                                }
                            }
                            if ($bekle == "1") {
                                foreach ($IDler as $ids) {
                                    $yorumSsql = $db->prepare("select * from urun_yorum where id=:id");
                                    $yorumSsql->execute(["id" => $ids]);
                                    if ("0" < $yorumSsql->rowCount()) {
                                        $guncelle = $db->prepare("UPDATE urun_yorum SET\r\n                                                onay=:onay\r\n                                         WHERE id=" . $ids . "      \r\n                                        ");
                                        $sonuc = $guncelle->execute(["onay" => "0"]);
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                                }
                            }
                        } else {
                            echo "olamaz";
                        }
                    } else {
                        $_SESSION["main_alert"] = "nocheck2";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "comment_set" && isset($_POST["edit"]) && $_POST) {
                $guncelle = $db->prepare("UPDATE urun_detay SET\r\n                            urun_yorum_onay=:urun_yorum_onay\r\n                     WHERE id='1'      \r\n                    ");
                $sonuc = $guncelle->execute(["urun_yorum_onay" => $_POST["urun_yorum_onay"]]);
                if ($sonuc) {
                    $_SESSION["main_alert"] = "success";
                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                } else {
                    echo "Veritabanı Hatası";
                }
            }
            if ($_GET["status"] == "comment_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["comment_id"]) {
                    $sorguSql = $db->prepare("select * from urun_yorum where id=:id ");
                    $sorguSql->execute(["id" => $_POST["comment_id"]]);
                    if ("0" < $sorguSql->rowCount()) {
                        $guncelle = $db->prepare("UPDATE urun_yorum SET\r\n                                baslik=:baslik,\r\n                                yorum=:yorum,\r\n                                yildiz=:yildiz,\r\n                                gizli=:gizli,\r\n                                onay=:onay\r\n                         WHERE id=" . $_POST["comment_id"] . "      \r\n                        ");
                        $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "yorum" => $_POST["yorum"], "yildiz" => $_POST["yildiz"], "gizli" => $_POST["gizli"], "onay" => $_POST["onay"]]);
                        if ($sonuc) {
                            $_SESSION["main_alert"] = "success";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=products_comments");
                        } else {
                            echo "Veritabanı Hatası";
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_group_add") {
                if (isset($_POST["add"]) && $_POST) {
                    $kaydet = $db->prepare("INSERT INTO urun_varyant SET\r\n                          baslik=:baslik, \r\n                          durum=:durum,\r\n                          dil=:dil,\r\n                          sira=:sira\r\n                   ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "dil" => $_SESSION["dil"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_group_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["group_id"]) {
                    $guncelle = $db->prepare("UPDATE urun_varyant SET\r\n                          baslik=:baslik, \r\n                          durum=:durum,\r\n                          sira=:sira   \r\n                     WHERE id=" . $_POST["group_id"] . "      \r\n                    ");
                    $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_group_delete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $silmeislem = $db->prepare("DELETE from urun_varyant WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                            $silmeislem = $db->prepare("DELETE from urun_varyant_ozellik WHERE var_id=:var_id");
                            $sil = $silmeislem->execute(["var_id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_add") {
                if (isset($_POST["add"]) && $_POST && $_POST["var_id"]) {
                    $kaydet = $db->prepare("INSERT INTO urun_varyant_ozellik SET\r\n                          baslik=:baslik, \r\n                          var_id=:var_id\r\n                   ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "var_id" => $_POST["var_id"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants_list&parent=" . $_POST["var_id"] . "");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["var_id"] && $_POST["list_id"]) {
                    $guncelle = $db->prepare("UPDATE urun_varyant_ozellik SET\r\n                          baslik=:baslik\r\n                     WHERE id=" . $_POST["list_id"] . "      \r\n                    ");
                    $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants_list&parent=" . $_POST["var_id"] . "");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "variant_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants_list&parent=" . $_POST["var_id"] . "");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $silmeislem = $db->prepare("DELETE from urun_varyant_ozellik WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_variants_list&parent=" . $_POST["var_id"] . "");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_add") {
                if (isset($_POST["add"]) && $_POST && $_POST["grup_id"]) {
                    $kaydet = $db->prepare("INSERT INTO urun_ozellik SET\r\n                          baslik=:baslik, \r\n                          grup_id=:grup_id,\r\n                          sira=:sira\r\n                   ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "grup_id" => $_POST["grup_id"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features_list&parent=" . $_POST["grup_id"] . "");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["group_id"] && $_POST["list_id"] && $_POST["baslik"] && $_POST["sira"]) {
                    $guncelle = $db->prepare("UPDATE urun_ozellik SET\r\n                          baslik=:baslik, \r\n                          sira=:sira \r\n                     WHERE id=" . $_POST["list_id"] . "      \r\n                    ");
                    $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $guncelle = $db->prepare("UPDATE filtre_ozellik SET\r\n                               sira=:sira \r\n                         WHERE ozellik_id=" . $_POST["list_id"] . "      \r\n                        ");
                        $sonuc = $guncelle->execute(["sira" => $_POST["sira"]]);
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features_list&parent=" . $_POST["group_id"] . "");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features_list&parent=" . $_POST["parent"] . "");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $silmeislem = $db->prepare("DELETE from urun_ozellik WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features_list&parent=" . $_POST["parent"] . "");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_group_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["group_id"] && $_POST["sira"] && $_POST["baslik"]) {
                    $guncelle = $db->prepare("UPDATE urun_ozellik_grup SET\r\n                          baslik=:baslik, \r\n                          durum=:durum,\r\n                          sira=:sira   \r\n                     WHERE id=" . $_POST["group_id"] . "      \r\n                    ");
                    $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $guncelle = $db->prepare("UPDATE filtre_ozellik_grup SET\r\n                               sira=:sira \r\n                         WHERE kontrol=" . $_POST["group_id"] . "      \r\n                        ");
                        $sonuc = $guncelle->execute(["sira" => $_POST["sira"]]);
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_group_add") {
                if (isset($_POST["add"]) && $_POST) {
                    $kaydet = $db->prepare("INSERT INTO urun_ozellik_grup SET\r\n                          baslik=:baslik, \r\n                          durum=:durum,\r\n                          sira=:sira\r\n                   ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "sira" => $_POST["sira"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "feature_group_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $silmeislem = $db->prepare("DELETE from urun_ozellik_grup WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                            $silmeislem = $db->prepare("DELETE from urun_ozellik WHERE grup_id=:grup_id");
                            $sil = $silmeislem->execute(["grup_id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_features");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "ecatalog_edit") {
                if (isset($_POST["edit"]) && $_POST && $_POST["catalog_id"] && $_POST["baslik"] && $_POST["dosya"]) {
                    if (0 < $_FILES["url"]["size"]) {
                        $file_format = $_FILES["url"];
                        $kaynak = $_FILES["url"]["tmp_name"];
                        $uzanti = explode(".", $_FILES["url"]["name"]);
                        $random = rand(0, (int) 99999);
                        $random2 = rand(0, (int) 999);
                        $filename = trim(addslashes($_FILES["url"]["name"]));
                        $filename = str_replace(" ", "_", $filename);
                        $filename = str_replace("ş", "s", $filename);
                        $filename = str_replace("&", "-", $filename);
                        $filename = str_replace("%", "-", $filename);
                        $filename = str_replace("?", "-", $filename);
                        $filename = str_replace("+", "-", $filename);
                        $filename = str_replace("ı", "i", $filename);
                        $filename = str_replace("Ş", "s", $filename);
                        $filename = str_replace("ğ", "g", $filename);
                        $filename = str_replace("Ğ", "g", $filename);
                        $filename = str_replace("ü", "u", $filename);
                        $filename = str_replace("Ü", "u", $filename);
                        $filename = str_replace("ç", "c", $filename);
                        $filename = str_replace("Ç", "c", $filename);
                        $filename = str_replace("ö", "o", $filename);
                        $filename = str_replace("Ö", "o", $filename);
                        $filename = str_replace("İ", "i", $filename);
                        $filename = preg_replace("/\\s+/", "_", $filename);
                        $file_name_detay = $random . "-" . $random2 . "-" . $filename;
                        $target = "../i/e-catalog/" . $file_name_detay;
                        if ($file_format["type"] == "application/pdf") {
                            $gitti = move_uploaded_file($kaynak, $target);
                            unlink("../i/e-catalog/" . $_POST["dosya"] . "");
                            $mevcutFile = $file_name_detay;
                        } else {
                            $_SESSION["main_alert"] = "filetype";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                            exit;
                        }
                    } else {
                        $mevcutFile = $_POST["dosya"];
                    }
                    $guncelle = $db->prepare("UPDATE katalog SET\r\n                         baslik=:baslik,   \r\n                         url=:url      \r\n                     WHERE id=" . $_POST["catalog_id"] . "      \r\n                    ");
                    $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "url" => $mevcutFile]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "ecatalog_add") {
                if (isset($_POST["add"]) && $_POST && $_POST["baslik"]) {
                    if (0 < $_FILES["url"]["size"]) {
                        $file_format = $_FILES["url"];
                        $kaynak = $_FILES["url"]["tmp_name"];
                        $uzanti = explode(".", $_FILES["url"]["name"]);
                        $random = rand(0, (int) 99999);
                        $random2 = rand(0, (int) 999);
                        $filename = trim(addslashes($_FILES["url"]["name"]));
                        $filename = str_replace(" ", "_", $filename);
                        $filename = str_replace("ş", "s", $filename);
                        $filename = str_replace("&", "-", $filename);
                        $filename = str_replace("%", "-", $filename);
                        $filename = str_replace("?", "-", $filename);
                        $filename = str_replace("+", "-", $filename);
                        $filename = str_replace("ı", "i", $filename);
                        $filename = str_replace("Ş", "s", $filename);
                        $filename = str_replace("ğ", "g", $filename);
                        $filename = str_replace("Ğ", "g", $filename);
                        $filename = str_replace("ü", "u", $filename);
                        $filename = str_replace("Ü", "u", $filename);
                        $filename = str_replace("ç", "c", $filename);
                        $filename = str_replace("Ç", "c", $filename);
                        $filename = str_replace("ö", "o", $filename);
                        $filename = str_replace("Ö", "o", $filename);
                        $filename = str_replace("İ", "i", $filename);
                        $filename = preg_replace("/\\s+/", "_", $filename);
                        $file_name_detay = $random . "-" . $random2 . "-" . $filename;
                        $target = "../i/e-catalog/" . $file_name_detay;
                        if ($file_format["type"] == "application/pdf") {
                            $gitti = move_uploaded_file($kaynak, $target);
                            $kaydet = $db->prepare("INSERT INTO katalog SET\r\n                         baslik=:baslik,   \r\n                         url=:url,\r\n                         dil=:dil\r\n                    ");
                            $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "url" => $file_name_detay, "dil" => $_SESSION["dil"]]);
                            if ($sonuc) {
                                $_SESSION["main_alert"] = "success";
                                header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                            } else {
                                echo "Veritabanı Hatası";
                            }
                        } else {
                            $_SESSION["main_alert"] = "filetype";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                            exit;
                        }
                    } else {
                        $_SESSION["main_alert"] = "filesize";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                        exit;
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "ecatalog_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $katralogCek = $db->prepare("select * from katalog ");
                            $katralogCek->execute(["id" => $idler]);
                            if ("0" < $katralogCek->rowCount()) {
                                $kata = $katralogCek->fetch(PDO::FETCH_ASSOC);
                                unlink("../i/e-catalog/" . $kata["url"] . "");
                            }
                            $silmeislem = $db->prepare("DELETE from katalog WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=e_catalog");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "brand_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $markaSql = $db->prepare("select * from urun_marka where id=:id ");
                            $markaSql->execute(["id" => $idler]);
                            $markrow = $markaSql->fetch(PDO::FETCH_ASSOC);
                            unlink("../images/uploads/" . $markrow["gorsel"] . "");
                            unlink("../images/uploads/" . $markrow["gorsel_anasayfa"] . "");
                            $silmeislem = $db->prepare("DELETE from urun_marka WHERE id=:id");
                            $sil = $silmeislem->execute(["id" => $idler]);
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "brand_delete") {
                if (isset($_GET["no"]) && "0" < $_GET["no"]) {
                    $markaSql = $db->prepare("select * from urun_marka where id=:id ");
                    $markaSql->execute(["id" => trim(strip_tags($_GET["no"]))]);
                    if ($markaSql <= "0") {
                        header("Location:" . $ayar["site_url"] . "404");
                        exit;
                    }
                    $markrow = $markaSql->fetch(PDO::FETCH_ASSOC);
                    unlink("../images/uploads/" . $markrow["gorsel"] . "");
                    unlink("../images/uploads/" . $markrow["gorsel_anasayfa"] . "");
                    $silmeislem = $db->prepare("DELETE from urun_marka WHERE id=:id");
                    $sil = $silmeislem->execute(["id" => trim(strip_tags($_GET["no"]))]);
                    if ($sil) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                    } else {
                        echo "veritabanı hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "brand_edit" && isset($_POST["brandEdit"]) && $_POST) {
                $markaSql = $db->prepare("select * from urun_marka where id=:id ");
                $markaSql->execute(["id" => trim(strip_tags($_POST["brand_id"]))]);
                if ($markaSql <= "0") {
                    header("Location:" . $ayar["site_url"] . "404");
                    exit;
                }
                if ($_POST["seo_url"]) {
                    $seo_url = seo($_POST["seo_url"]);
                } else {
                    $seo_url = seo($_POST["baslik"]);
                }
                if ($_POST["baslik_seo"]) {
                    $seo_title = $_POST["baslik_seo"];
                } else {
                    $seo_title = $_POST["baslik"];
                }
                if (0 < $_FILES["gorsel"]["size"]) {
                    $file_format = $_FILES["gorsel"];
                    if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/gif" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                        include_once "inc/class.upload.php";
                        $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                        if ($upload->uploaded) {
                            $random = rand(0, (int) 0);
                            $random2 = rand(0, (int) 999);
                            $upload->file_name_body_pre = "brand_";
                            $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                            $upload->image_resize = true;
                            $upload->png_quality = 90;
                            $upload->webp_quality = 90;
                            $upload->jpeg_quality = 90;
                            $upload->png_compression = 9;
                            $upload->image_y = 80;
                            $upload->image_ratio = true;
                            $upload->process("../images/uploads");
                            $file_name_detay = $upload->file_dst_name;
                        }
                        $gorsel1 = "gonder";
                    } else {
                        $_SESSION["main_alert"] = "filetype";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                        exit;
                    }
                } else {
                    $gorsel1 = "yok";
                }
                if (0 < $_FILES["gorsel_anasayfa"]["size"]) {
                    $file_format_home = $_FILES["gorsel_anasayfa"];
                    if ($file_format_home["type"] == "image/jpeg" || $file_format_home["type"] == "image/jpg" || $file_format_home["type"] == "image/gif" || $file_format_home["type"] == "image/png" || $file_format_home["type"] == "image/webp" || $file_format_home["type"] == "image/jxr" || $file_format_home["type"] == "image/jp2" || $file_format_home["type"] == "image/bmp") {
                        include_once "inc/class.upload.php";
                        $upload = new Verot\Upload\Upload($_FILES["gorsel_anasayfa"]);
                        if ($upload->uploaded) {
                            $random = rand(0, (int) 0);
                            $random2 = rand(0, (int) 999);
                            $upload->file_name_body_pre = "brand_home_";
                            $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                            $upload->image_resize = true;
                            $upload->png_quality = 90;
                            $upload->webp_quality = 90;
                            $upload->jpeg_quality = 90;
                            $upload->png_compression = 9;
                            $upload->image_y = 80;
                            $upload->image_ratio = true;
                            $upload->process("../images/uploads");
                            $file_name_anasayfa = $upload->file_dst_name;
                        }
                        $gorsel2 = "gonder";
                    } else {
                        $_SESSION["main_alert"] = "filetype";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                        exit;
                    }
                } else {
                    $gorsel2 = "yok";
                }
                if ($gorsel1 == "gonder") {
                    $gorsel = $file_name_detay;
                    unlink("../images/uploads/" . $_POST["gorsel_old"] . "");
                }
                if ($gorsel1 == "yok") {
                    $gorsel = $_POST["gorsel_old"];
                }
                if ($gorsel2 == "gonder") {
                    $gorsel_home = $file_name_anasayfa;
                    unlink("../images/uploads/" . $_POST["gorsel_anasayfa_old"] . "");
                }
                if ($gorsel2 == "yok") {
                    $gorsel_home = $_POST["gorsel_anasayfa_old"];
                }
                $guncelle = $db->prepare("UPDATE urun_marka SET\r\n                         baslik=:baslik,   \r\n                         baslik_seo=:baslik_seo,\r\n                         seo_url=:seo_url,\r\n                         gorsel=:gorsel,\r\n                         gorsel_anasayfa=:gorsel_anasayfa,\r\n                         spot=:spot,\r\n                         sira=:sira,\r\n                         durum=:durum,\r\n                         anasayfa=:anasayfa,\r\n                         tags=:tags,\r\n                         meta_desc=:meta_desc    \r\n                     WHERE id=" . $_POST["brand_id"] . "      \r\n                    ");
                $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "baslik_seo" => $seo_title, "seo_url" => $seo_url, "gorsel" => $gorsel, "gorsel_anasayfa" => $gorsel_home, "spot" => $_POST["spot"], "sira" => $_POST["sira"], "durum" => $_POST["durum"], "anasayfa" => $_POST["anasayfa"], "tags" => $_POST["tags"], "meta_desc" => $_POST["meta_desc"]]);
                if ($sonuc) {
                    $guncelle = $db->prepare("UPDATE urun SET\r\n                                marka_sira\r\n                         WHERE marka=" . $_POST["brand_id"] . "      \r\n                        ");
                    $sonuc = $guncelle->execute(["marka_sira" => $_POST["sira"]]);
                    $_SESSION["main_alert"] = "success";
                    header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                } else {
                    echo "Veritabanı Hatası";
                }
            }
            if ($_GET["status"] == "brand_add" && isset($_POST["brandAdd"]) && $_POST) {
                if ($_POST["seo_url"]) {
                    $seo_url = seo($_POST["seo_url"]);
                } else {
                    $seo_url = seo($_POST["baslik"]);
                }
                if ($_POST["baslik_seo"]) {
                    $seo_title = $_POST["baslik_seo"];
                } else {
                    $seo_title = $_POST["baslik"];
                }
                if (0 < $_FILES["gorsel"]["size"] && 0 < $_FILES["gorsel_anasayfa"]["size"]) {
                    $file_format = $_FILES["gorsel"];
                    $file_format_home = $_FILES["gorsel_anasayfa"];
                    if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/gif" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                        if ($file_format_home["type"] == "image/jpeg" || $file_format_home["type"] == "image/jpg" || $file_format_home["type"] == "image/gif" || $file_format_home["type"] == "image/png" || $file_format_home["type"] == "image/webp" || $file_format_home["type"] == "image/jxr" || $file_format_home["type"] == "image/jp2" || $file_format_home["type"] == "image/bmp") {
                            include_once "inc/class.upload.php";
                            $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                            if ($upload->uploaded) {
                                $random = rand(0, (int) 0);
                                $random2 = rand(0, (int) 999);
                                $upload->file_name_body_pre = "brand_";
                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                $upload->image_resize = true;
                                $upload->png_quality = 90;
                                $upload->webp_quality = 90;
                                $upload->jpeg_quality = 90;
                                $upload->png_compression = 9;
                                $upload->image_y = 80;
                                $upload->image_ratio = true;
                                $upload->process("../images/uploads");
                                $file_name_detay = $upload->file_dst_name;
                            }
                            $upload = new Verot\Upload\Upload($_FILES["gorsel_anasayfa"]);
                            if ($upload->uploaded) {
                                $upload->file_name_body_pre = "brand_home_";
                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                $upload->image_resize = true;
                                $upload->png_quality = 90;
                                $upload->webp_quality = 90;
                                $upload->jpeg_quality = 90;
                                $upload->png_compression = 9;
                                $upload->image_y = 80;
                                $upload->image_ratio = true;
                                $upload->process("../images/uploads");
                                $file_name_anasayfa = $upload->file_dst_name;
                            }
                            $gorsel1 = "gonder";
                            $gorsel2 = "gonder";
                            if ($gorsel1 == "gonder") {
                                $gorsel = $file_name_detay;
                            }
                            if ($gorsel2 == "gonder") {
                                $gorsel_home = $file_name_anasayfa;
                            }
                            $kaydet = $db->prepare("INSERT INTO urun_marka SET\r\n                         baslik=:baslik,   \r\n                         baslik_seo=:baslik_seo,\r\n                         seo_url=:seo_url,\r\n                         gorsel=:gorsel,\r\n                         gorsel_anasayfa=:gorsel_anasayfa,\r\n                         spot=:spot,\r\n                         sira=:sira,\r\n                         durum=:durum,\r\n                         anasayfa=:anasayfa,\r\n                         tags=:tags,\r\n                         meta_desc=:meta_desc\r\n                    ");
                            $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "baslik_seo" => $seo_title, "seo_url" => $seo_url, "gorsel" => $gorsel, "gorsel_anasayfa" => $gorsel_home, "spot" => $_POST["spot"], "sira" => $_POST["sira"], "durum" => $_POST["durum"], "anasayfa" => $_POST["anasayfa"], "tags" => $_POST["tags"], "meta_desc" => $_POST["meta_desc"]]);
                            if ($sonuc) {
                                $_SESSION["main_alert"] = "success";
                                header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                            } else {
                                echo "Veritabanı Hatası";
                            }
                        } else {
                            $_SESSION["main_alert"] = "filetype";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                            exit;
                        }
                    } else {
                        $_SESSION["main_alert"] = "filetype";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                        exit;
                    }
                } else {
                    $_SESSION["main_alert"] = "filesize";
                    header("Location:" . $ayar["panel_url"] . "pages.php?page=brands");
                    exit;
                }
            }
            if ($_GET["status"] == "sub_category_delete") {
                if (isset($_GET["no"]) && "0" < $_GET["no"]) {
                    $sorgu = $db->prepare("select * from urun_cat where id='" . $_GET["no"] . "' ");
                    $sorgu->execute();
                    if ("0" < $sorgu->rowCount()) {
                        $row = $sorgu->fetch(PDO::FETCH_ASSOC);
                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                        $sil = $silmeislem->execute(["id" => $row["id"]]);
                        if ($sil) {
                            $sorguSub1 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                            $sorguSub1->execute(["ust_id" => $_GET["no"]]);
                            foreach ($sorguSub1 as $sorgu1) {
                                $sorguSub2 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                $sorguSub2->execute(["ust_id" => $sorgu1["id"]]);
                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                $sil = $silmeislem->execute(["id" => $sorgu1["id"]]);
                                foreach ($sorguSub2 as $sorgu2) {
                                    $sorguSub3 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                    $sorguSub3->execute(["ust_id" => $sorgu2["id"]]);
                                    $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                    $sil = $silmeislem->execute(["id" => $sorgu2["id"]]);
                                    foreach ($sorguSub3 as $sorgu3) {
                                        $sorguSub4 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                        $sorguSub4->execute(["ust_id" => $sorgu3["id"]]);
                                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                        $sil = $silmeislem->execute(["id" => $sorgu3["id"]]);
                                    }
                                }
                            }
                            $_SESSION["main_alert"] = "success";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=sub_categories&parent=" . $_GET["parent"] . "");
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "subcategories_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=sub_categories&parent=" . $_POST["parent"] . "");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $sorgu = $db->prepare("select * from urun_cat where id='" . $idler . "' ");
                            $sorgu->execute();
                            if ("0" < $sorgu->rowCount()) {
                                $row = $sorgu->fetch(PDO::FETCH_ASSOC);
                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                $sil = $silmeislem->execute(["id" => $row["id"]]);
                                if ($sil) {
                                    $sorguSub1 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                    $sorguSub1->execute(["ust_id" => $idler]);
                                    foreach ($sorguSub1 as $sorgu1) {
                                        $sorguSub2 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                        $sorguSub2->execute(["ust_id" => $sorgu1["id"]]);
                                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                        $sil = $silmeislem->execute(["id" => $sorgu1["id"]]);
                                        foreach ($sorguSub2 as $sorgu2) {
                                            $sorguSub3 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                            $sorguSub3->execute(["ust_id" => $sorgu2["id"]]);
                                            $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                            $sil = $silmeislem->execute(["id" => $sorgu2["id"]]);
                                            foreach ($sorguSub3 as $sorgu3) {
                                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                                $sil = $silmeislem->execute(["id" => $sorgu3["id"]]);
                                            }
                                        }
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=sub_categories&parent=" . $_POST["parent"] . "");
                                }
                            }
                        }
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "category_delete") {
                if (isset($_GET["no"]) && "0" < $_GET["no"]) {
                    $sorgu = $db->prepare("select * from urun_cat where id='" . $_GET["no"] . "' ");
                    $sorgu->execute();
                    if ("0" < $sorgu->rowCount()) {
                        $row = $sorgu->fetch(PDO::FETCH_ASSOC);
                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                        $sil = $silmeislem->execute(["id" => $row["id"]]);
                        if ($sil) {
                            $sorguSub1 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                            $sorguSub1->execute(["ust_id" => $_GET["no"]]);
                            foreach ($sorguSub1 as $sorgu1) {
                                $sorguSub2 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                $sorguSub2->execute(["ust_id" => $sorgu1["id"]]);
                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                $sil = $silmeislem->execute(["id" => $sorgu1["id"]]);
                                foreach ($sorguSub2 as $sorgu2) {
                                    $sorguSub3 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                    $sorguSub3->execute(["ust_id" => $sorgu2["id"]]);
                                    $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                    $sil = $silmeislem->execute(["id" => $sorgu2["id"]]);
                                    foreach ($sorguSub3 as $sorgu3) {
                                        $sorguSub4 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                        $sorguSub4->execute(["ust_id" => $sorgu3["id"]]);
                                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                        $sil = $silmeislem->execute(["id" => $sorgu3["id"]]);
                                        foreach ($sorguSub4 as $sorgu4) {
                                            $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                            $sil = $silmeislem->execute(["id" => $sorgu4["id"]]);
                                        }
                                    }
                                }
                            }
                            $_SESSION["main_alert"] = "success";
                            header("Location:" . $ayar["panel_url"] . "pages.php?page=categories");
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "categories_multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=categories");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $sorgu = $db->prepare("select * from urun_cat where id='" . $idler . "' ");
                            $sorgu->execute();
                            if ("0" < $sorgu->rowCount()) {
                                $row = $sorgu->fetch(PDO::FETCH_ASSOC);
                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                $sil = $silmeislem->execute(["id" => $row["id"]]);
                                if ($sil) {
                                    $sorguSub1 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                    $sorguSub1->execute(["ust_id" => $idler]);
                                    foreach ($sorguSub1 as $sorgu1) {
                                        $sorguSub2 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                        $sorguSub2->execute(["ust_id" => $sorgu1["id"]]);
                                        $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                        $sil = $silmeislem->execute(["id" => $sorgu1["id"]]);
                                        foreach ($sorguSub2 as $sorgu2) {
                                            $sorguSub3 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                            $sorguSub3->execute(["ust_id" => $sorgu2["id"]]);
                                            $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                            $sil = $silmeislem->execute(["id" => $sorgu2["id"]]);
                                            foreach ($sorguSub3 as $sorgu3) {
                                                $sorguSub4 = $db->prepare("select * from urun_cat where ust_id=:ust_id ");
                                                $sorguSub4->execute(["ust_id" => $sorgu3["id"]]);
                                                $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                                $sil = $silmeislem->execute(["id" => $sorgu3["id"]]);
                                                foreach ($sorguSub4 as $sorgu4) {
                                                    $silmeislem = $db->prepare("DELETE from urun_cat WHERE id=:id");
                                                    $sil = $silmeislem->execute(["id" => $sorgu4["id"]]);
                                                }
                                            }
                                        }
                                    }
                                    $_SESSION["main_alert"] = "success";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=categories");
                                }
                            }
                        }
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "category_add") {
                if (isset($_POST["catAdd"]) && $_POST) {
                    if ($_POST["seo_url"]) {
                        $seo_url = seo($_POST["seo_url"]);
                    } else {
                        $seo_url = seo($_POST["baslik"]);
                    }
                    if ($_POST["baslik_seo"]) {
                        $seo_title = $_POST["baslik_seo"];
                    } else {
                        $seo_title = $_POST["baslik"];
                    }
                    $kaydet = $db->prepare("INSERT INTO urun_cat SET\r\n                        baslik=:baslik,    \r\n                        durum=:durum,\r\n                        spot=:spot,\r\n                        tags=:tags,\r\n                        meta_desc=:meta_desc,\r\n                        ust_id=:ust_id,\r\n                        dil=:dil,\r\n                        seo_url=:seo_url,\r\n                        baslik_seo=:baslik_seo,\r\n                        sira=:sira,\r\n                        marka_filtre=:marka_filtre,\r\n                        ozellik_filtre=:ozellik_filtre,\r\n                        fiyat_filtre=:fiyat_filtre\r\n                    ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "spot" => $_POST["spot"], "tags" => $_POST["tags"], "meta_desc" => $_POST["meta_desc"], "ust_id" => "0", "dil" => $_SESSION["dil"], "seo_url" => $seo_url, "baslik_seo" => $seo_title, "sira" => $_POST["sira"], "marka_filtre" => $_POST["marka_filtre"], "ozellik_filtre" => $_POST["ozellik_filtre"], "fiyat_filtre" => $_POST["fiyat_filtre"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=categories");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "category_edit") {
                if (isset($_POST["catEdit"]) && $_POST) {
                    if ($_POST["cat_id"]) {
                        $katSql = $db->prepare("select * from urun_cat where id=:id ");
                        $katSql->execute(["id" => $_POST["cat_id"]]);
                        if ("0" < $katSql->rowCount()) {
                            if ($_POST["seo_url"]) {
                                $seo_url = seo($_POST["seo_url"]);
                            } else {
                                $seo_url = seo($_POST["baslik"]);
                            }
                            if ($_POST["baslik_seo"]) {
                                $seo_title = $_POST["baslik_seo"];
                            } else {
                                $seo_title = $_POST["baslik"];
                            }
                            $guncelle = $db->prepare("UPDATE urun_cat SET\r\n                                    baslik=:baslik,\r\n                                    sira=:sira,\r\n                                    baslik_seo=:baslik_seo,\r\n                                    seo_url=:seo_url,\r\n                                    meta_desc=:meta_desc,\r\n                                    tags=:tags,\r\n                                    durum=:durum,\r\n                                    ozellik_filtre=:ozellik_filtre,\r\n                                    marka_filtre=:marka_filtre,\r\n                                    fiyat_filtre=:fiyat_filtre,\r\n                                    spot=:spot\r\n                             WHERE id=" . $_POST["cat_id"] . "      \r\n                            ");
                            $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "sira" => $_POST["sira"], "baslik_seo" => $seo_title, "seo_url" => $seo_url, "meta_desc" => $_POST["meta_desc"], "tags" => $_POST["tags"], "durum" => $_POST["durum"], "ozellik_filtre" => $_POST["ozellik_filtre"], "marka_filtre" => $_POST["marka_filtre"], "fiyat_filtre" => $_POST["fiyat_filtre"], "spot" => $_POST["spot"]]);
                            if ($sonuc) {
                                $_SESSION["main_alert"] = "success";
                                header("Location:" . $ayar["panel_url"] . "pages.php?page=categories");
                            } else {
                                echo "Veritabanı Hatası";
                            }
                        } else {
                            header("Location:" . $ayar["site_url"] . "404");
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "sub_category_add") {
                if (isset($_POST["subcatAdd"]) && $_POST) {
                    if ($_POST["seo_url"]) {
                        $seo_url = seo($_POST["seo_url"]);
                    } else {
                        $seo_url = seo($_POST["baslik"]);
                    }
                    if ($_POST["baslik_seo"]) {
                        $seo_title = $_POST["baslik_seo"];
                    } else {
                        $seo_title = $_POST["baslik"];
                    }
                    $kaydet = $db->prepare("INSERT INTO urun_cat SET\r\n                        baslik=:baslik,    \r\n                        durum=:durum,\r\n                        spot=:spot,\r\n                        tags=:tags,\r\n                        meta_desc=:meta_desc,\r\n                        ust_id=:ust_id,\r\n                        dil=:dil,\r\n                        seo_url=:seo_url,\r\n                        baslik_seo=:baslik_seo,\r\n                        sira=:sira,\r\n                        marka_filtre=:marka_filtre,\r\n                        ozellik_filtre=:ozellik_filtre,\r\n                        fiyat_filtre=:fiyat_filtre\r\n                    ");
                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "durum" => $_POST["durum"], "spot" => $_POST["spot"], "tags" => $_POST["tags"], "meta_desc" => $_POST["meta_desc"], "ust_id" => $_POST["parent_id"], "dil" => $_SESSION["dil"], "seo_url" => $seo_url, "baslik_seo" => $seo_title, "sira" => $_POST["sira"], "marka_filtre" => $_POST["marka_filtre"], "ozellik_filtre" => $_POST["ozellik_filtre"], "fiyat_filtre" => $_POST["fiyat_filtre"]]);
                    if ($sonuc) {
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=sub_categories&parent=" . $_POST["parent_id"] . "");
                    } else {
                        echo "Veritabanı Hatası";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "sub_category_edit") {
                if (isset($_POST["subcatEdit"]) && $_POST) {
                    if ($_POST["cat_id"]) {
                        $katSql = $db->prepare("select * from urun_cat where id=:id ");
                        $katSql->execute(["id" => $_POST["cat_id"]]);
                        if ("0" < $katSql->rowCount()) {
                            if ($_POST["seo_url"]) {
                                $seo_url = seo($_POST["seo_url"]);
                            } else {
                                $seo_url = seo($_POST["baslik"]);
                            }
                            if ($_POST["baslik_seo"]) {
                                $seo_title = $_POST["baslik_seo"];
                            } else {
                                $seo_title = $_POST["baslik"];
                            }
                            $guncelle = $db->prepare("UPDATE urun_cat SET\r\n                                    baslik=:baslik,\r\n                                    sira=:sira,\r\n                                    baslik_seo=:baslik_seo,\r\n                                    seo_url=:seo_url,\r\n                                    meta_desc=:meta_desc,\r\n                                    tags=:tags,\r\n                                    durum=:durum,\r\n                                    ozellik_filtre=:ozellik_filtre,\r\n                                    marka_filtre=:marka_filtre,\r\n                                    fiyat_filtre=:fiyat_filtre,\r\n                                    spot=:spot\r\n                             WHERE id=" . $_POST["cat_id"] . "      \r\n                            ");
                            $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "sira" => $_POST["sira"], "baslik_seo" => $seo_title, "seo_url" => $seo_url, "meta_desc" => $_POST["meta_desc"], "tags" => $_POST["tags"], "durum" => $_POST["durum"], "ozellik_filtre" => $_POST["ozellik_filtre"], "marka_filtre" => $_POST["marka_filtre"], "fiyat_filtre" => $_POST["fiyat_filtre"], "spot" => $_POST["spot"]]);
                            if ($sonuc) {
                                $_SESSION["main_alert"] = "success";
                                header("Location:" . $ayar["panel_url"] . "pages.php?page=sub_categories&parent=" . $_POST["parent_id"] . "");
                            } else {
                                echo "Veritabanı Hatası";
                            }
                        } else {
                            header("Location:" . $ayar["site_url"] . "404");
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
        } else {
            header("Location:" . $ayar["site_url"] . "404");
        }
    } else {
        header("Location:" . $ayar["site_url"] . "404");
    }
} else {
    header("Location:" . $_SESSION["current_url"] . "");
    $_SESSION["main_alert"] = "demo";
}

İptal

📁 PHP Dosya Yöneticisi

📝 catalog_post2.php

📝 catalog_post2.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)