54 lines
2.7 KiB
PHP
Executable File
54 lines
2.7 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
$reqUpdate="UPDATE `referencement` SET ";
|
|
$doRequete=true;
|
|
|
|
if ($title!='') {$title=addslashes($title);$reqUpdate .= " title='" .$title. "', "; }
|
|
if (strlen($title[$i])>120) {$admMsg .= 'Vous dépassez la longueur maximale du titre : 120'; $doRequete=false; $admMsgClass='ko';}
|
|
|
|
if ($keywords!='') {$keywords=addslashes($keywords);$reqUpdate .= " keywords='" .$keywords. "', "; }
|
|
if ($description!='') {$description=addslashes($description);$reqUpdate .= " description='" .$description. "', "; }
|
|
if (strlen($description)>220) {$admMsg .= 'Vous dépassez la longueur maximale de la description : 220'; $doRequete=false; $admMsgClass='ko';}
|
|
if ($robots!='') {$reqUpdate .= " robots='" .$robots. "', "; }
|
|
|
|
$reqUpdate .= " lastUpdated = '" .$today. "', ";
|
|
$reqUpdate .= " language = '" .$dbLG. "', ";
|
|
|
|
if ($pageTitle!='') {$pageTitle=addslashes($pageTitle);$reqUpdate .= " pageTitle='" .$pageTitle. "', "; }
|
|
if (strlen($pageTitle)>120) {$admMsg .= 'Vous dépassez la longueur maximale du titre : 120'; $doRequete=false; $admMsgClass='ko';}
|
|
|
|
if($doRequete==true) {
|
|
$rest = strlen($reqUpdate)-2;
|
|
$reqUpdate=substr($reqUpdate,0,$rest);
|
|
$reqUpdate .= " WHERE pageID=" .$pageID. " AND language='" .$dbLG. "' ;";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqUpdate' => $reqUpdate], 'ref.reqUpdate.php');}
|
|
|
|
$resConn='';
|
|
$resConn=$idPdo->query($reqUpdate);
|
|
|
|
if ($resConn) {$admMsg .= " Mise à jour de la table de réferencement " .$dbLG. " effectuée avec succès !"; $admMsgClass='ok';}
|
|
else {$admMsg .= " Echec de la mise à jour de la table de réferencement " .$idLanguenav. " . (fichier ref.reqUpdate.php) ==> " .$reqUpdate; $admMsgClass='ko'; }
|
|
|
|
// -----------------------------------------------------
|
|
// Mettre à jour avancement
|
|
// -----------------------------------------------------
|
|
if (isset($_SESSION['avEt8'])) {
|
|
|
|
$resConn='';
|
|
$reqUpdate="UPDATE `avancement` set etapeStatut=1 WHERE etapeNum=8;";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqUpdate' => $reqUpdate], 'ref.reqUpdate.php');}
|
|
|
|
$resConn='';
|
|
$resConn=$idPdo->query($reqUpdate);
|
|
if ($resConn) {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Update etape8 ok' => ''], '');}
|
|
}
|
|
else if (isset($debug[2]) && $debug[2] == '1' ) $admMsg .= '<br>pb de update etape8: ref.reqUpdate.php';
|
|
|
|
// -----------------------------------------------------
|
|
// On recharge Avancement
|
|
// -----------------------------------------------------
|
|
include ("./avancement/checkAvancement.php");
|
|
}
|
|
}
|
|
?>
|