<?php $myUpdate = new myUpdate(__FILE__); $myUpdate->table = $thisSite->PREFIXE_TBL_PUB . "stats"; $myUpdate->field["nb_click"] = "LITERAL:nb_click+1"; $myUpdate->where = "id_bandeau=:id_bandeau AND aa=:aa AND mm=:mm AND jj=:jj AND lg=:lg"; $myUpdate->whereValue["id_bandeau"] = array($__GET["id"], PDO::PARAM_INT); $myUpdate->whereValue["aa"] = array(date(Y), PDO::PARAM_STR); $myUpdate->whereValue["mm"] = array(date(m), PDO::PARAM_STR); $myUpdate->whereValue["jj"] = array(date(d), PDO::PARAM_STR); $myUpdate->whereValue["lg"] = array($thisSite->current_lang, PDO::PARAM_STR); $result = $myUpdate->execute(); $mySelect = new mySelect(__FILE__); $mySelect->tables = $thisSite->PREFIXE_TBL_PUB . "bandeaux"; $mySelect->fields = "lien_destination"; $mySelect->where = "id=:id_bandeau AND lg=:lg"; $mySelect->whereValue["id_bandeau"] = array($__GET["id"], PDO::PARAM_INT); $mySelect->whereValue["lg"] = array($thisSite->current_lang, PDO::PARAM_STR); $result = $mySelect->query(); $row = current($result); $lien_destination = stripslashes($row["lien_destination"]); if ($lien_destination != "") { $parse_lien = parse_url($lien_destination); if ($parse_lien["scheme"] == "") { $lien_destination = $thisSite->RACINE . $lien_destination; } header("Location: {$lien_destination}"); }
function deleteArbo($idDel) { global $thisSite; $arbo_site = array(); $mySelect = new mySelect(__FILE__); $mySelect->tables = $thisSite->PREFIXE_TBL_GEN . "arbo"; $mySelect->fields = "*"; $result = $mySelect->query(); foreach ($result as $row) { $nivRub = unserialize($row['arbo_menu']); //echoa($row['code_menu']); //echoa($nivRub); if (array_key_exists($idDel, $nivRub)) { unset($nivRub[$idDel]); } if (is_array($nivRub)) { foreach ($nivRub as $idRub => $nivsRub) { //echoa($nivsRub); if (is_array($nivsRub)) { if (array_key_exists($idDel, $nivsRub)) { unset($nivRub[$idRub][$idDel]); } } if (is_array($nivsRub)) { foreach ($nivsRub as $idsRub => $nivssRub) { //echoa($nivssRub); if (is_array($nivssRub)) { if (array_key_exists($idDel, $nivssRub)) { unset($nivRub[$idRub][$idsRub][$idDel]); } } } } //$nivsRub } } //$nivRub //echoa($nivRub); $myUpdate = new myUpdate(__FILE__); $myUpdate->table = $thisSite->PREFIXE_TBL_GEN . "arbo"; $myUpdate->field["arbo_menu"] = serialize($nivRub); $myUpdate->where = "code_menu='" . $row['code_menu'] . "'"; $result = $myUpdate->execute(); } // suppression dans l'arbo }
public function addArbo() { global $thisSite; if ($this->idPage == 0 || $this->idPage == "") { return false; } $myTable = $thisSite->PREFIXE_TBL_GEN . "arbo"; if ($this->idPageParent == "") { $this->idPageParent = 0; } if ($this->code_menu == "noneItem" || $this->code_menu == "") { $this->code_menu = "horsmenu"; } $mySelect = new mySelect(__FILE__); $mySelect->tables = $myTable; $mySelect->fields = "arbo_menu"; $mySelect->where = "code_menu='" . $this->code_menu . "'"; $result = $mySelect->query(); $row = current($result); $arbo_menu = unserialize($row['arbo_menu']); if (is_array($this->idPageParent)) { $arbo_menu[$this->idPageParent[0]][$this->idPageParent[1]][$this->idPage] = ""; } else { if ($this->idPageParent > 0) { $arbo_menu[$this->idPageParent][$this->idPage] = ""; } else { $arbo_menu[$this->idPage] = ""; } } $myUpdate = new myUpdate(__FILE__); $myUpdate->table = $myTable; $myUpdate->field["arbo_menu"] = serialize($arbo_menu); $myUpdate->where = "code_menu='" . $this->code_menu . "'"; $result = $myUpdate->execute(); }
} $idSet = $formMaj->set_datas(); // Ajout à l'arboresence hors menu if ($majInsert == 1 && $__POST["show_in_arbo"] == "1") { $classPage = new classPage(); $classPage->idPage = $idSet; if ($__POST["add_menu"] != "0") { $classPage->code_menu = $__POST["add_menu"]; } $classPage->addArbo(); } if ($__POST["article_tableId"] != "") { list($article_table, $article_id) = explode(".", $__POST["article_tableId"]); if ($article_table != "" && $article_id > 0) { foreach ($myAdmin->LIST_LANG_EXTENSION_FIELD as $clg => $extLg) { $myUpdateA = new myUpdate(__FILE__); $myUpdateA->table = $article_table; $myUpdateA->field["titre"] = $__POST["page_titre" . $extLg]; $myUpdateA->field["actif"] = $__POST["actif"]; $myUpdateA->where = "id=:id AND lg=:lg"; $myUpdateA->whereValue["id"] = array($article_id, PDO::PARAM_INT); $myUpdateA->whereValue["lg"] = array($clg, PDO::PARAM_STR); $resultA = $myUpdateA->execute(); } } } $thisSite->reInit = 1; // permet la réactualisation du site public pour que les modifications soient prisent en compte actionFormMaj($__POST["actionForm"]); } // chargement des données
public function set_datas($debug = 0) { global $myAdmin; global $PDO; global $__POST; global $datas_lang; global $idCurrent; global $majInsert; $this->TableFields = $PDO->getFieldsName($this->tables); foreach ($this->whereValuebyLg as $clg => $whereValueFull) { $extlg = $myAdmin->LIST_LANG_EXTENSION_FIELD[$clg]; if ($this->count_datas($clg) > 0) { // UPDATE $myUpdate = new myUpdate(__FILE__); $myUpdate->table = $this->tables; $myUpdate->where = $this->whereFull; $myUpdate->whereValue = $whereValueFull; //echoa($TableFields); //echoa($__POST); $fields = $this->prepare_maj_fields($extlg, "update"); foreach ($fields as $fieldName => $value) { $myUpdate->field[$fieldName] = $value; } $result = $myUpdate->execute(); } else { // INSERT $myInsert = new myInsert(__FILE__); $myInsert->table = $this->tables; if ($this->multiLang == true) { $myInsert->field["lg"] = $clg; } if ($idCurrent > 0) { $myInsert->field["id"] = $idCurrent; $chrono = $PDO->getNextChrono($this->tables, $idCurrent); if ($chrono > 0) { $myInsert->field["chrono"] = $chrono; } } else { // on recherche le dernier ID et on ajoute 1 $idCurrent = $PDO->getNextID($this->tables, $this->nextIdMin, $this->nextIdMax); $myInsert->field["id"] = $idCurrent; $chrono = $PDO->getNextChrono($this->tables); if ($chrono > 0) { $myInsert->field["chrono"] = $chrono; } } $fields = $this->prepare_maj_fields($extlg, "insert"); foreach ($fields as $fieldName => $value) { $myInsert->field[$fieldName] = $value; } $result = $myInsert->execute(); } // $this->count_datas($clg)>0 } // langue if ($this->maj_media_inside == false) { $this->maj_media_inside($idCurrent); } // pour éviter la récurcivité if ($majInsert == 1) { $action = "INS"; } else { $action = "UPD"; } $myAdmin->addLogs($myAdmin->pageCurrent, $action, $idCurrent, $result); ////// // Fin de la mise à jour // Choix Notification et reroutage éventuel $notification = ""; if ($result === false || !isset($result)) { $notificationClass = "jBox-Notice-red"; $notification = "<div><i class='fa fa-times mrs'></i>" . $datas_lang["majKo"] . "</div>"; } else { $notificationClass = "jBox-Notice-green"; $notification = "<div><i class='fa fa-check mrs'></i>" . $datas_lang["majOk"] . "</div>"; } $notification = addslashes($notification); $myAdmin->notification = $notification; $myAdmin->notificationClass = $notificationClass; if ($_POST["actionForm"] == "valider" && $notification == "") { exit; } return $idCurrent; }