108 lines
5.3 KiB
PHP
Executable File
108 lines
5.3 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
|
|
if (!empty($themeToDelete)) {
|
|
|
|
// -----------------------------------------------------
|
|
// Trouver le idTheme
|
|
// -----------------------------------------------------
|
|
if (empty($idThemeToDelete)) {
|
|
$reqSelect="SELECT idTh, `description` from cssthemes WHERE nom='" .$themeToDelete. "';";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Select id du Site a supprimer' => $reqSelect], 'theme.reqDelete.php');}
|
|
$resConn='';
|
|
$resConn = $idPdo->query($reqSelect);
|
|
if ($resConn) {
|
|
$result=$resConn->fetch(PDO::FETCH_ASSOC);
|
|
$idThemeToDelete=$result['idTh'];
|
|
$descTheme=$result['description'];
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Site a supprimer' => $idThemeToDelete, 'Site a supprimer desc ' => $descTheme, 'Table a supprimer' => $themeToDelete], '');}
|
|
$admMsgClass='ok';
|
|
}
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// Supression de la table css
|
|
// -----------------------------------------------------
|
|
$reqDelete="DROP TABLE IF EXISTS `" .$themeToDelete. "`;";
|
|
$continuer=0;
|
|
if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
|
|
try{
|
|
$idPdo->exec($reqDelete);
|
|
// $admMsg .='Supression dans la table css pour '.$themeToDelete. ' ok !' ;
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Table' => $themeToDelete, ' supprimée avec succès !' => ''], '');}
|
|
$continuer=1;
|
|
}
|
|
catch(PDOException $e) {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la table:' => $e->getMessage()], '');}
|
|
}
|
|
|
|
if ($continuer==1) {
|
|
// -----------------------------------------------------
|
|
// Supression de la ligne dans la table cssthemes
|
|
// -----------------------------------------------------
|
|
$reqDelete="DELETE from cssthemes WHERE nom='" .$themeToDelete. "';";
|
|
if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
|
|
try{
|
|
$idPdo->exec($reqDelete);
|
|
// $admMsg .='Supression du site pour '.$themeToDelete. ' ok !' ;
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression de la ligne dans la table des themes' => $themeToDelete, ' ok!' => ''], '');}
|
|
$admMsgClass='ok';
|
|
// -----------------------------------------------------
|
|
// Activation du site par defaut ou celui actif
|
|
// -----------------------------------------------------
|
|
include ($includePathAdmin. "/req/themesCss.reqSelect.Liste.php");
|
|
}
|
|
catch(PDOException $e) {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression de la ligne dans la table cssthemes' => $descTheme, 'err. PDO!' => $e->getMessage() ], '');}
|
|
$admMsgClass='ko';
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// Supression dans les autres tables
|
|
// -----------------------------------------------------
|
|
if (!empty($idThemeToDelete)) {
|
|
|
|
// -----------------------------------------------------
|
|
// Supression des lignes dans la table thmParam
|
|
// -----------------------------------------------------
|
|
$reqDelete="DELETE FROM `thmParam` WHERE idTheme=" .$idThemeToDelete. ";";
|
|
if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
|
|
try{
|
|
$idPdo->exec($reqDelete);
|
|
// $admMsg .='Supression dans la table parametre pour '.$themeToDelete. ' ok !' ;
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression dans la table thmParam pour ' => $themeToDelete, ' idTheme' => $idThemeToDelete], '');}
|
|
$admMsgClass='ok';
|
|
}
|
|
catch(PDOException $e) {
|
|
$admMsgClass='ko';
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la ligne dans la table des themes :' => $e->getMessage()], '');}
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// Supression des lignes dans la table design
|
|
// -----------------------------------------------------
|
|
$reqDelete="DELETE from design WHERE idTheme=" .$idThemeToDelete. ";";
|
|
if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
|
|
|
|
try{
|
|
$idPdo->exec($reqDelete);
|
|
$admMsg .='Supression du site `'.$descTheme. '` ok !' ;
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression dans la table design pour '.$themeToDelete => $idThemeToDelete ], '');}
|
|
$admMsgClass='ok';
|
|
}
|
|
catch(PDOException $e) {
|
|
$admMsgClass='ko';
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la ligne dans la table des themes :' => $e->getMessage()], '');}
|
|
}
|
|
}
|
|
}
|
|
else {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Echec de la supression de la table du Site' => $descTheme, 'idThemeToDelete' => $idThemeToDelete, 'themeToDelete' => $themeToDelete ], '');}
|
|
$admMsgClass='ko';
|
|
}
|
|
}
|
|
else {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Aucun Site à supprimer! : themeToDelete' => $themeToDelete], '');}
|
|
$admMsgClass='ko';
|
|
}
|
|
?>
|