34 lines
1.5 KiB
PHP
Executable File
34 lines
1.5 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
$continue=0;
|
|
|
|
if ($num2!='') {
|
|
if ($activ2=='' || $activ2==0) $activ2='0';
|
|
$reqUpdate="UPDATE `rRegles` SET ";
|
|
if ($activ2!='') {$reqUpdate .="activ=" .$activ2. ", ";$continue=1;}
|
|
if ($desc2!='') {$reqUpdate .="description='" .$desc2. "', ";$continue=1;}
|
|
if ($prio2!='') {$reqUpdate .="prio='" .$prio2. "', ";$continue=1;}
|
|
if ($C12!='') {$reqUpdate .="C1='" .$C12. "', ";$continue=1;}
|
|
if ($C22!='') {$reqUpdate .="C2='" .$C22. "', ";$continue=1;}
|
|
if ($C32!='') {$reqUpdate .="C3='" .$C32. "', ";$continue=1;}
|
|
if ($avantage2!='') {$reqUpdate .="avantage='" .$avantage2. "', ";$continue=1;}
|
|
if ($typeA2!='') {$reqUpdate .="typeAvantage='" .$typeA2. "', ";$continue=1;}
|
|
|
|
if ($continue==1) {
|
|
$rest = strlen($reqUpdate)-2;
|
|
$reqUpdate=substr($reqUpdate,0,$rest);
|
|
$reqUpdate .= " WHERE num=" .$num2. " ;";
|
|
if (isset($debug[2]) && $debug[2] == '1' ) $debugMsg .= monDebug (2, [' requeteUpdate' => $reqUpdate ],'regle.reqUpdate');
|
|
$resConn='';
|
|
$resConn=$idPdo->query($reqUpdate);
|
|
if ($resConn) {
|
|
if (isset($debug[2]) && $debug[2] == '1' ) $debugMsg .= monDebug (2,['Mise à jour de la règle effectuée avec succès !' => ''],''); $admMsgClass='ok';
|
|
}
|
|
else {
|
|
$admMsg .= "Echec de la mise à jour de la règle."; $admMsgClass='ko';
|
|
}
|
|
} // continue
|
|
else if (isset($debug[2]) && $debug[2] == '1' ) monDebug (2,['continue' => $continue],'');
|
|
}
|
|
else {$admMsg .= "Echec de la mise à jour la de la règle : num2 vide: " .$num2; $admMsgClass='ko';}
|
|
?>
|