'._T('evahabillage:EVA_suppr_table_confirm_explic');
echo '';
echo '';
fin_cadre_relief();
}
if ($_POST['creer_table']==1) {
$query_verif_table = 'SELECT * FROM '.$evaTable.' LIMIT 1';
$res_verif_table = spip_query($query_verif_table);
if ($res_verif_table == '') {eva_habillage_creer_tables($evaTable);}
$query_verif_themes = 'SELECT * FROM '.$evaTable.'_themes LIMIT 1';
$res_verif_themes = spip_query($query_verif_themes);
if ($res_verif_themes == '') {eva_habillage_creer_tables_themes($evaTable);}
$query_verif_images = 'SELECT * FROM '.$evaTable.'_images LIMIT 1';
$res_verif_images = spip_query($query_verif_images);
if ($res_verif_images == '') {eva_habillage_creer_tables_images($evaTable);}
}
include_spip("inc/eva_habillage_definition_themes");
$def_themes = eva_habillage_definition_themes ();
if (isset($_POST['restauration_habillage'])) {
$recherche_habillage_restaure = spip_query("SELECT habillage FROM eva_habillage WHERE sauvegarde='".mysql_escape_string($_POST['restauration_habillage'])."'");
$tab__habillage_restaure = spip_fetch_array($recherche_habillage_restaure);
spip_query("UPDATE eva_habillage SET habillage='".$tab__habillage_restaure['habillage']."' WHERE sauvegarde='Defaut'");
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage='Defaut'");
$recherche_images_restaure=spip_query("SELECT type,nom_div,nom_image,pos_x,pos_y,repetition,attach FROM eva_habillage_images WHERE nom_habillage='".mysql_escape_string($_POST['restauration_habillage'])."'");
while ($tab=spip_fetch_array($recherche_images_restaure)) {
spip_query("INSERT INTO eva_habillage_images VALUES ('','".$tab['type']."','Defaut','".$tab['nom_div']."','".$tab['nom_image']."','".$tab['pos_x']."','".$tab['pos_y']."','".$tab['repetition']."','".$tab['attach']."')");
}
$recherche_themes_restaure="SELECT * FROM eva_habillage_themes WHERE nom='".mysql_escape_string($_POST['restauration_habillage'])."'";
$result_restaure=spip_query($recherche_themes_restaure);
$tab_restaure=spip_fetch_array($result_restaure);
foreach($def_themes as $habillage_cles => $habillage_inutile) {
if (isset($tab_restaure[$habillage_cles])) {spip_query("UPDATE eva_habillage_themes SET ".$habillage_cles."='".$tab_restaure[$habillage_cles]."' WHERE nom='Defaut'");}
else {spip_query("UPDATE eva_habillage_themes SET ".$habillage_cles."='' WHERE nom='Defaut'");}
}
}
if ($_POST['modif_habillage']==1) {
$mes_modifs = "UPDATE eva_habillage_themes SET ";
foreach ($def_themes as $habillage_modif_cles => $habillage_modif_inutile) {
$mes_modifs_tableau [$habillage_modif_cles] =$habillage_modif_cles." = '".$_POST[$habillage_modif_cles]."'";
}
$mes_modifs_prov = implode(" , ",$mes_modifs_tableau);
$mes_modifs .= $mes_modifs_prov." WHERE nom='Defaut'";
spip_query($mes_modifs);
}
if (isset($_POST['integrer_theme_externe'])) {
include_spip('inc/eva_habillage_themes_externes');
$tab_externe = eva_charger_themes();
$theme_externe = $tab_externe[$_POST['integrer_theme_externe']];
spip_query("DELETE FROM eva_habillage_themes WHERE nom = 'Defaut'");
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage = 'Defaut'");
spip_query("UPDATE eva_habillage SET habillage = ".$theme_externe['habillage']." WHERE sauvegarde = 'Defaut'");
spip_query("INSERT INTO eva_habillage_themes VALUES ".$theme_externe['theme']);
$tab = $theme_externe['images'];
foreach ($tab as $val) {spip_query("INSERT INTO eva_habillage_images VALUES ".$val);}
}
$query_verif = 'SELECT * FROM '.$evaTable.' LIMIT 1';
$res_verif = spip_query($query_verif);
if ($res_verif == '') {
debut_cadre_trait_couleur($icone, false, '', _T('evahabillage:EVA_creer_table'));
echo ''._T('evahabillage:EVA_creer_les_table').'
';
echo '
';
fin_cadre_trait_couleur();
}
else {
$test_fri=spip_query("SELECT id_habillage FROM eva_habillage WHERE sauvegarde='Defaut'");
$tab_fri=spip_fetch_array($test_fri);
if (!isset($tab_fri['id_habillage'])) {spip_query("INSERT INTO eva_habillage VALUES ('','0','Defaut')");}
$requete1 = "SELECT habillage FROM eva_habillage WHERE sauvegarde = 'Defaut'";
$resultat1 = spip_query($requete1);
$resultat1_tableau = spip_fetch_array($resultat1);
$mon_habillage = $resultat1_tableau['habillage'];
// Premier Module - Choix de l'habillage de base
debut_cadre_couleur($icone, false, '', _T('evahabillage:EVA_etape1'));
echo _T('evahabillage:EVA_a_penser').'
';
echo ''. _T('evahabillage:EVA_actif');
if ($mon_habillage=='0'){echo _T('evahabillage:EVA_style_defaut');} else {echo "".$mon_habillage."";}
echo '
';
$image_habillage = ereg_replace(".css",".png",$mon_habillage);
if ($image_habillage=='0') {$image_habillage='eva_style.png';}
if (file_exists($path.$image_habillage)) {
echo '
';
}else{
echo '
';
}
echo '
'._T('evahabillage:EVA_choix').'
';
echo '
";
if (!isset($compteur_block)) {$compteur_block=0;}
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_choix_bloc');
echo debut_block_invisible($compteur_block);
$mes_blocs = EVA_mes_blocs();
foreach ($mes_blocs as $cle_blocs => $val_blocs) {
$compteur_block++;
echo '
'.bouton_block_invisible($compteur_block);
echo _T('evahabillage:'.$cle_blocs);
echo debut_block_invisible($compteur_block);
foreach($val_blocs as $val) {
if (isset($_POST[$val])) {
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage='Defaut' AND nom_div='".$val."'");
spip_query("INSERT INTO eva_habillage_images SET type = 'bloc' , nom_habillage='Defaut' , nom_div='".$val."' , nom_image='".$_POST[$val]."'");
}
}
echo '';
echo fin_block().'
';
}
echo fin_block().'
';
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_choix_nbre');
echo debut_block_invisible($compteur_block);
$nbre = EVA_mes_nbres();
foreach ($nbre as $cle_nbre => $val_nbre) {
foreach($val_nbre as $val) {
if (isset($_POST[$val])) {
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage='Defaut' AND nom_div='".$val."'");
spip_query("INSERT INTO eva_habillage_images SET type = 'nbre' , nom_habillage='Defaut' , nom_div='".$val."' , nom_image='".$_POST[$val]."'");
}
}
$compteur_block++;
echo '
'.bouton_block_invisible($compteur_block);
echo _T('evahabillage:'.$cle_nbre);
echo debut_block_invisible($compteur_block);
echo '';
echo fin_block().'
';
}
echo fin_block().'
';
fin_cadre_couleur();
//Module 2 - Ajustements prédéfinis des paramètres d'habillage
debut_cadre_trait_couleur($icone, false, '', _T('evahabillage:EVA_etape2'));
echo ''._T('evahabillage:EVA_etape2_detail').'
';
include_spip("inc/eva_habillage_choix_couleur");
eva_habillage_choix_couleur();
echo '
';
fin_cadre_trait_couleur();
//Module 3 - Ajout d'imges de fond dans les secteurs
debut_cadre_couleur($icone, false, '', _T('evahabillage:EVA_etape3'));
if (isset($_POST['supprime_image'])) {
spip_query("DELETE FROM eva_habillage_images WHERE id=".$_POST['supprime_image']);
}
if (isset($_POST['supprime_liste'])) {
spip_query("DELETE FROM eva_habillage_images WHERE id=".$_POST['supprime_liste']);
}
if (isset($_POST['secteur_image'])) {
$recup_image_exists = spip_query("SELECT id FROM eva_habillage_images WHERE nom_div = '".$_POST['secteur_image']."' AND nom_habillage = 'Defaut'");
$tab_recup_image_exists = spip_fetch_array($recup_image_exists);
$repeat = $_POST['repeat_x']+$_POST['repeat_y'];
if ($repeat==0) {$rep='no-repeat';}
elseif ($repeat==1) {$rep='repeat-x';}
elseif ($repeat==2) {$rep='repeat-y';}
elseif ($repeat==3) {$rep='repeat';}
if ($_POST['pos_x']==4) {$Xpos=$_POST['position_x'];} else {$Xpos=$_POST['pos_x'];}
if ($_POST['pos_y']==4) {$Ypos=$_POST['position_y'];} else {$Ypos=$_POST['pos_y'];}
if (isset($tab_recup_image_exists['id'])) {
$mise_a_jour_image = spip_query("UPDATE eva_habillage_images SET nom_image = '".$_POST['nom_image']."' , pos_x = '".$Xpos."' , pos_y = '".$Ypos."' , repetition = '".$rep."' , attach = '".$_POST['attach']."' WHERE id =".$tab_recup_image_exists['id']);
}
else {
$new_image = spip_query("INSERT INTO eva_habillage_images VALUES ('','image','Defaut','".$_POST['secteur_image']."','".$_POST['nom_image']."','".$Xpos."','".$Ypos."','".$rep."','".$_POST['attach']."')");
}
}
if (isset($_POST['secteur_liste'])) {
$recup_liste_exists = spip_query("SELECT id FROM eva_habillage_images WHERE nom_div = '".$_POST['secteur_liste']."' AND nom_habillage = 'Defaut'");
$tab_recup_liste_exists = spip_fetch_array($recup_liste_exists);
if (isset($tab_recup_liste_exists['id'])) {
$mise_a_jour_liste = spip_query("UPDATE eva_habillage_images SET nom_image = '".$_POST['nom_puce']."' , pos_x = '".$_POST['liste_position']."' WHERE id =".$tab_recup_liste_exists['id']);
}
else {
$new_liste = spip_query("INSERT INTO eva_habillage_images VALUES ('','liste','Defaut','".$_POST['secteur_liste']."','".$_POST['nom_puce']."','".$_POST['liste_position']."','','','')");
}
}
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_etape3_image_fond');
echo debut_block_invisible($compteur_block);
echo '
';
echo fin_block().'
';
/*******************
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_etape3_liste_puce');
echo debut_block_invisible($compteur_block);
echo '';
echo fin_block().'
';
********************/
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_etape3_liste_images_definies');
echo debut_block_invisible($compteur_block);
$recup_exist_image = spip_query("SELECT id , nom_div , nom_image FROM eva_habillage_images WHERE type = 'image' AND nom_habillage = 'Defaut'");
$test_exist_image = spip_query("SELECT id FROM eva_habillage_images WHERE type = 'image' AND nom_habillage = 'Defaut' LIMIT 1");
$tab_test_exist_image = spip_fetch_array($test_exist_image);
if ($tab_test_exist_image!='') {
echo '
';
echo '';
echo 'Secteur | Image | Supprimer ? |
';
while ($tab_exist_image = spip_fetch_array($recup_exist_image)) {
echo '|
';
}
echo '
';
}
else {
echo '
'._T('evahabillage:EVA_aucune_image_fond');
}
echo fin_block().'
';
/*********************
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_etape3_liste_puces_definies');
echo debut_block_invisible($compteur_block);
$recup_exist_liste = spip_query("SELECT id , nom_div FROM eva_habillage_images WHERE type = 'liste' AND nom_habillage = 'Defaut'");
$test_exist_liste = spip_query("SELECT id FROM eva_habillage_images WHERE type = 'liste' AND nom_habillage = 'Defaut' LIMIT 1");
$tab_test_exist_liste = spip_fetch_array($test_exist_liste);
if ($tab_test_exist_liste!='') {
echo '
';
while ($tab_exist_liste = spip_fetch_array($recup_exist_liste)) {
echo '|
';
}
echo '
';
}
else {
echo '
'._T('evahabillage:EVA_aucune_liste_fond');
}
echo fin_block();
*********************/
fin_cadre_couleur();
//Module 4 - Ajout de propriétés CSS personnelles
debut_cadre_trait_couleur($icone, false, '', _T('evahabillage:EVA_etape5'));
if (isset($_POST['nouvelle_regle'])) {spip_query("INSERT INTO eva_habillage_images VALUES ('','perso','Defaut','".mysql_escape_string($_POST['nouvelle_regle'])."','','','','','')");}
if (isset($_POST['supprime_perso'])) {spip_query("DELETE FROM eva_habillage_images WHERE id=".$_POST['supprime_perso']);}
echo ''._T('evahabillage:EVA_etape5_detail').'
';
echo '
';
$compteur_block++;
echo bouton_block_invisible($compteur_block);
echo _T('evahabillage:EVA_etape5_defini');
echo debut_block_invisible($compteur_block);
$recherche_perso_unique = spip_query("SELECT id FROM eva_habillage_images WHERE type='perso' AND nom_habillage='Defaut' LIMIT 1");
$tab_perso_unique = spip_fetch_array($recherche_perso_unique);
if (isset($tab_perso_unique['id'])) {
echo '
';
$recherche_perso = spip_query("SELECT id,nom_div FROM eva_habillage_images WHERE type='perso' AND nom_habillage='Defaut'");
while ($tab = spip_fetch_array($recherche_perso)) {
echo '|
';
}
echo '
';
}
else {
echo '
'._T('evahabillage:EVA_etape5_rien_defini');
}
echo fin_block();
fin_cadre_trait_couleur();
//Module 5 - Module de sauvegarde
debut_cadre_couleur($icone, false, '', _T('evahabillage:EVA_etape4'));
if (isset($_POST['supprimer_habillage'])) {
spip_query("DELETE FROM eva_habillage WHERE sauvegarde = '".mysql_escape_string($_POST['supprimer_habillage'])."'");
spip_query("DELETE FROM eva_habillage_themes WHERE nom='".mysql_escape_string($_POST['supprimer_habillage'])."'");
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage='".mysql_escape_string($_POST['supprimer_habillage'])."'");
}
if ((isset($_POST['nouvelle_sauvegarde'])) AND ($_POST['nouvelle_sauvegarde']!='Defaut')) {
$nom_habillage_defaut=spip_query("SELECT habillage FROM eva_habillage WHERE sauvegarde = 'Defaut'");
$tab_habillage_defaut=spip_fetch_array($nom_habillage_defaut);
spip_query("DELETE FROM eva_habillage WHERE sauvegarde='".mysql_escape_string($_POST['nouvelle_sauvegarde'])."'");
spip_query("INSERT INTO eva_habillage VALUES ('','".$tab_habillage_defaut['habillage']."','".mysql_escape_string($_POST['nouvelle_sauvegarde'])."')");
spip_query("DELETE FROM eva_habillage_themes WHERE nom='".mysql_escape_string($_POST['nouvelle_sauvegarde'])."'");
spip_query("INSERT INTO eva_habillage_themes SET nom ='".mysql_escape_string($_POST['nouvelle_sauvegarde'])."'");
$result_valeurs=spip_query($recherche_themes_defini);
$tab_valeurs=spip_fetch_array($result_valeurs);
foreach($def_themes as $habillage_cles => $habillage_inutile) {spip_query("UPDATE eva_habillage_themes SET ".$habillage_cles."='".$tab_valeurs[$habillage_cles]."' WHERE nom='".mysql_escape_string($_POST['nouvelle_sauvegarde'])."'");}
spip_query("DELETE FROM eva_habillage_images WHERE nom_habillage='".mysql_escape_string($_POST['nouvelle_sauvegarde'])."'");
$images_sauve = "SELECT type,nom_div,nom_image,pos_x,pos_y,repetition,attach FROM eva_habillage_images WHERE nom_habillage='Defaut'";
$result_images_sauve=spip_query($images_sauve);
while ($tab=spip_fetch_array($result_images_sauve)) {
spip_query("INSERT INTO eva_habillage_images VALUES ('','".$tab['type']."','".mysql_escape_string($_POST['nouvelle_sauvegarde'])."','".$tab['nom_div']."','".$tab['nom_image']."','".$tab['pos_x']."','".$tab['pos_y']."','".$tab['repetition']."','".$tab['attach']."')");
}
}
elseif($_POST['nouvelle_sauvegarde']=='Defaut') {
debut_cadre_relief('', false, '', _T('evahabillage:EVA_erreur_sauvegarde'));
echo _T('evahabillage:EVA_erreur_sauvegarde2');
fin_cadre_relief();
}
$recherche_sauvegardes = "SELECT nom FROM eva_habillage_themes WHERE nom != 'Defaut' ORDER BY nom";
$resultat_sauvegarde1 = spip_query($recherche_sauvegardes);
$resultat_sauvegarde2 = spip_query($recherche_sauvegardes);
$test_presence = spip_query($recherche_sauvegardes);
$tab_presence = spip_fetch_array($test_presence);
echo ''._T('evahabillage:EVA_etape4_sauvegarder').'
';
if ($tab_presence!='') {
echo '
'._T('evahabillage:EVA_etape4_restaurer').'
';
echo ''._T('evahabillage:EVA_etape4_supprimer').'
';
}
echo '
'._T('evahabillage:EVA_restauration_externe');
$chemin_themes = _DIR_PLUGIN_EVA_HABILLAGE."inc/eva_habillage_themes_externes.php";
if (file_exists($chemin_themes)) {
include_spip('inc/eva_habillage_themes_externes');
$tab_externe = eva_charger_themes();
if (isset($tab_externe)) {
echo _T('evahabillage:EVA_restauration_externe_choix').'
';
echo '';}
else {echo _T('evahabillage:EVA_restauration_externe_aucun');}
}
else {echo _T('evahabillage:EVA_restauration_externe_aucun');}
echo '
';
fin_cadre_couleur();
//Dernier cadre - Effacement des tables
debut_cadre_couleur_foncee($icone, false, '', _T('evahabillage:EVA_drop_table'));
echo _T('evahabillage:EVA_drop_table_explication');
echo '';
fin_cadre_couleur_foncee();
}
echo fin_gauche(), fin_page();
}
?>