MODULE-NET : AJOUT

";echo "";}} else{ if($type=="ajout_page"){ $requette="SELECT code FROM sites WHERE client='$client' AND type='parametre' ORDER BY code" ; $resultat=mysql_query($requette); while($liste = mysql_fetch_row($resultat)){ $vieux_code=$liste[0]; } $code=$vieux_code+100; $fp = fopen("index.php","r"); $nom_page="index".$code.".php"; $nouvelle_page = fopen($nom_page, 'w+'); while (!feof ($fp)) { $ligne = fgets($fp); $ligne=str_replace("1000", $code, $ligne); fputs($nouvelle_page, $ligne); } fclose($fp); fclose($nouvelle_page); $requette="INSERT INTO sites (code, type, client, adresse) VALUES ('$code', 'parametre', '$client', '$nom_page')"; $resultat=mysql_query($requette); $type="parametre"; } if($type=="parametre"){if($Submit=="Modifier"){if($fond<>""){echo "

changement de l'image de fond

";$lienfond = "imgs/img/fond".$code.".jpg" ;copy($fond, "$lienfond");$couleur="fond";}$valeur=str_replace("\r","
",$valeur);$query0 = "UPDATE sites SET valeur ='$valeur', police = '$police', taille = '$taille', couleur = '$couleur', entete = '$aff_entete', menu1 = '$aff_menu', menu1_couleur = '$menu1_couleur', nom = '$nom', adresse = '$adresse', inclure= '$inclure' WHERE client = '$client' and code ='$code' LIMIT 1";$result0 = mysql_query($query0);echo "

Modification effectuée

";}echo "

"; $query4 = "SELECT * FROM sites WHERE client = '$client' and code='$code'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $valeur = $row4[3]; $couleur = $row4[9]; $aff_entete = $row4[16]; $aff_menu = $row4[17]; $menu1_couleur = $row4[18]; $nom = $row4[22]; $adresse = $row4[21];$inclure = $row4[20]; } echo "titre de la page :
";echo "nom de la page :
";echo "adresse de la page :
";echo " ";echo "
INCLURE L'ENTETE
"; echo "
Calques à inclure (separé par des virgules):"; echo "
LARGEUR DU MENU GAUCHE (vide pour pas de menu)
COULEUR DU MENU GAUCHE ";echo "
Couleur du fond de page
";echo "";echo "";$query5 = "SELECT * FROM couleur "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $coul = $row5[0];$compte=$compte + 1;echo "";if($compte=="6"){echo ""; $compte=0 ;}}if($compte=="0"){echo "";}if($compte=="1"){echo "";}if($compte=="2"){echo "";}if($compte=="3"){echo "";}if($compte=="4"){echo "";}if($compte=="5"){echo "";}echo "

";echo " changer l'image de fond :
";echo "";echo "

";echo "";echo " ";} if($type=="menu_cat"){if($Submit=="Modifier"){if($fond<>""){echo "

changement de l'image de fond du menu

";$lienfond = "imgs/img/fond_menu_cata.jpg" ;copy($fond, "$lienfond");$couleur="fond";}$valeur=str_replace("\r","
",$valeur);$query0 = "UPDATE param_menu_cat SET couleur = '$couleur', largeur = '$largeur' WHERE client = '$client' and niveau ='0' LIMIT 1";$result0 = mysql_query($query0);echo "

Modification effectuée

";}echo ""; $query4 = "SELECT * FROM param_menu_cat WHERE client = '$client' and niveau='0'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $couleur = $row4[3]; $largeur = $row4[6]; }echo "
LARGEUR DU MENU";echo " ";echo "

";echo "
Couleur du fond de page
";echo "";echo "";$query5 = "SELECT * FROM couleur "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $coul = $row5[0];$compte=$compte + 1;echo "";if($compte=="6"){echo ""; $compte=0 ;}}if($compte=="0"){echo "";}if($compte=="1"){echo "";}if($compte=="2"){echo "";}if($compte=="3"){echo "";}if($compte=="4"){echo "";}if($compte=="5"){echo "";}echo "

";echo " changer l'image de fond :
";echo "";echo "

";echo "";echo " ";} if($type=="rubrique_menu_cat"){if($aj_rub=="oui"){if($Submit==""){ $query0 = "INSERT INTO menu_cat (client, code, titre) VALUES ('$client', '$rubrique', 'titre')"; $result0 = mysql_query($query0);}}if($Submit=="Modifier"){$query0 = "UPDATE menu_cat SET titre = '$titre_rub_cat' WHERE client = '$client' and code ='$rubrique' LIMIT 1";$result0 = mysql_query($query0);echo "

Modification effectuée

";}echo ""; $query4 = "SELECT * FROM menu_cat WHERE client = '$client' and code='$rubrique'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $titre_rub_cat = $row4[2]; }echo "
Titre de la rubrique";echo " ";echo "

";} if($type=="fiche"){if($aj_fiche=="oui"){if($Submit==""){ $query0 = "INSERT INTO prod_cat (client, code, titre, texte, format) VALUES ('$client', '$rubrique', 'titre', 'placez le texte ici', 'simple')"; $result0 = mysql_query($query0);}}if($Submit=="Ajouter"){$code=$rubrique; $rub_prod = substr($code,0,6); echo "ref : $rub_prod code : $code rubrique : $rubrique"; $query4 = "SELECT * FROM prod_cat WHERE client = '$client' and code LIKE '$rub_prod%'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $code_new = $row4[1]; }$rubrique = $code_new +1;if($photo<>""){echo "

Mise à jour de la photo

";$lienphoto = "imgs/img/V".$rubrique.".jpg" ;copy($photo, "$lienphoto");}if($photo1<>""){echo "

Mise à jour de la photo

";$link = "imgs/img/P".$rubrique.".jpg" ;copy($photo1, "$link");} $texte_prod_cat=str_replace("\r","
",$texte_prod_cat); $query0 = "INSERT INTO prod_cat (client, code, titre, texte, format) VALUES ('$client', '$rubrique', '$titre_prod_cat', '$texte_prod_cat', 'simple')"; $result0 = mysql_query($query0);echo "

création effectuée

";}if($Submit=="Modifier"){if($photo<>""){echo "

Mise à jour de la photo

";$lienphoto = "imgs/img/V".$rubrique.".jpg" ;copy($photo, "$lienphoto");}if($photo1<>""){echo "

Mise à jour de la photo

";$link = "imgs/img/P".$rubrique.".jpg" ;copy($photo1, "$link");} $texte_prod_cat=str_replace("\r","
",$texte_prod_cat);$query0 = "UPDATE prod_cat SET titre = '$titre_prod_cat', texte = '$texte_prod_cat' WHERE client = '$client' and code ='$rubrique' LIMIT 1";$result0 = mysql_query($query0);echo "

Modification effectuée

";}echo ""; $query4 = "SELECT * FROM prod_cat WHERE client = '$client' and code='$rubrique'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $titre_prod_cat = $row4[2]; $texte_prod_cat = $row4[3]; }echo "
Titre du produit
"; $texte_prod_cat=str_replace("
","\r",$texte_prod_cat); echo "
";echo " ";echo " ";echo "

";echo "Vignette actuelle :

changer :

";echo "Grande actuelle :

changer :
";} if($type=="defile"){if($Submit=="Modifier"){ $valeur=str_replace("\r","
",$valeur); $query0 = "UPDATE sites SET valeur ='$valeur', valeur1 ='$valeur1', valeur2 ='$valeur2', police = '$police', taille = '$taille', couleur = '$couleur', gras = '$gras', italique = '$italique', souligne = '$souligne', rayer = '$rayer', div = '$div', lien = '$link' WHERE client = '$client' and code ='$code' LIMIT 1"; $result0 = mysql_query($query0); echo "

Modification effectuée

";}if($Submit=="Supprimer"){ echo ""; echo "

!!!!!!!! ATTENTION !!!!!!!!
Vous allez supprimer la ligne decrit ci-dessous
de maniere definitive. Apres reflexion cliquez sur confirmer:
"; echo ""; echo ""; echo " "; echo " "; echo "

";}if($Submit=="Confirmer"){ $query0 = "DELETE FROM sites WHERE client = '$client' and code='$code' LIMIT 1"; $result0 = mysql_query($query0); echo "

Produit éffacé

";}if($Submit=="Ajouter"){ $page_a=1; if($ajoute=="oui"){ $time1 = time() ; $time = $time1 ; $code=$ligne.time().time() ; } else{ $long = strlen($code); $long1 = $long - 3 ; $coef = substr($code,$long1); $coef = $coef + 1 ; $debut = substr($code,0,$long1); $code = $debut.$coef; } $valeur=""; $query0 = "INSERT INTO sites (client, type, code, valeur, parametre, police, taille, couleur, gras, italique, souligne, rayer, div) VALUES ('$client', '$type', '$code', '$valeur', '$parametre', '$police', '$taille', '$couleur', '$gras', '$italique', '$souligne', '$rayer', '$div' )"; $result0 = mysql_query($query0); echo "

texte ajouté

";}echo "

";echo "";echo "";echo "";if($page_a<>1){ $query4 = "SELECT * FROM sites WHERE client = '$client' and code='$code'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $valeur = $row4[3]; $valeur1 = $row4[5]; $valeur2 = $row4[6]; $police = $row4[7]; $taille = $row4[8]; $couleur = $row4[9]; $gras = $row4[10]; $italique = $row4[11]; $souligne = $row4[12]; $rayer = $row4[13]; $div = $row4[14]; $link = $row4[15]; if($valeur1==""){$valeur1=330;} if($valeur2==""){$valeur1=6;} }} $valeur=str_replace("
","\r",$valeur); echo " TEXTE :
";echo " largeur de la banderole :
";echo " vitesse de defilement :
";echo "

";echo "";echo " GRAS
";echo " italique
";echo " souligne
";echo "
";echo "

";echo "a droite
";echo "centre
";echo "a gauche
";echo "

";echo " ";echo " ";echo "";echo "

";echo "";echo "
lien hypertext :
"; echo ""; echo "

"; echo "

OPTIONS

";echo "

";$compte=0;echo "";$query5 = "SELECT * FROM police "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $poli = $row5[0];$compte=$compte + 1;echo "";if($compte=="2"){echo ""; $compte=0 ;}}if($compte=="0"){echo "";}if($compte=="1"){echo "";}echo "

";echo " $poli ";echo "

";echo "

";$query5 = "SELECT * FROM taille "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $tail = $row5[0];echo " la taille $tail
";}echo "

";$compte=0;echo "";$query5 = "SELECT * FROM couleur "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $coul = $row5[0];$compte=$compte + 1;echo "";if($compte=="6"){echo ""; $compte=0 ;}}if($compte=="0"){echo "";}if($compte=="1"){echo "";}if($compte=="2"){echo "";}if($compte=="3"){echo "";}if($compte=="4"){echo "";}if($compte=="5"){echo "";}echo "

";echo "";echo "

";echo "

";echo "";echo "";echo " ";echo "";} if($type=="texte_2"){if($Submit=="Modifier"){ $valeur=str_replace("\r","
",$valeur);$valeur=str_replace("\n","
",$valeur); $query0 = "UPDATE sites SET valeur ='$valeur', police = '$police', taille = '$taille', couleur = '$couleur', gras = '$gras', italique = '$italique', souligne = '$souligne', rayer = '$rayer', div = '$div', lien = '$link', nom = '$nom' WHERE client = '$client' and code ='$code' LIMIT 1"; $result0 = mysql_query($query0); echo "

Modification effectuée

";}if($Submit=="Supprimer"){ echo "";}if($Submit=="Confirmer"){ $query0 = "DELETE FROM sites WHERE client = '$client' and code='$code' LIMIT 1"; $result0 = mysql_query($query0); echo "

Produit éffacé

texte ajouté

";}echo "

";echo "";echo "";echo "";if($page_a<>1){ $query4 = "SELECT * FROM sites WHERE client = '$client' and code='$code'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $valeur = $row4[3]; $police = $row4[7]; $taille = $row4[8]; $couleur = $row4[9]; $gras = $row4[10]; $italique = $row4[11]; $souligne = $row4[12]; $rayer = $row4[13]; $div = $row4[14]; $link = $row4[15]; $nom = $row4[22]; }} $valeur=str_replace("
","\r",$valeur); echo "

"; echo "Nom :
";echo " ";echo "

";echo "
";echo "
";echo "
";echo "

";echo "";echo " GRAS
";echo " italique
";echo " souligne
";echo "
";echo "

";echo "";echo "";echo "";echo "";echo "

	droite
	centre
	gauche

";echo "

";echo "";echo "

";echo "

";echo "";echo "
lien hypertext :
"; echo ""; echo "

"; echo "

OPTIONS

";echo "

";echo " $poli ";echo "

";echo "

";$query5 = "SELECT * FROM taille "; $result5 = mysql_query($query5); while($row5 = mysql_fetch_row($result5)){ $tail = $row5[0];echo " la taille $tail
";}echo "

";echo "";echo "

";echo "

";echo "";echo "";echo " ";echo "

";} if($type=="image"){if($Submit=="Supprimer"){ echo "";} if($Submit=="Confirmer"){ $query0 = "DELETE FROM sites WHERE client = '$client' and code='$code' LIMIT 1"; $result0 = mysql_query($query0); echo "

image éffacé

";} if($Submit=="Modifier"){ if($photo<>""){ $name=$_FILES["photo"]["name"]; $ext=(strpos($name,".")+1); $extension=substr($name, $ext); $fichh=$code.".".$extension; $lienphoto = "imgs/img/".$code.".".$extension; copy($photo, "$lienphoto"); echo "

Mise à jour de la photo $lienphoto

"; $req_photo=", valeur='$fichh'"; } if($photo1<>""){ echo "

Mise à jour de la photo

";$link = "imgs/img/".time().".jpg" ;copy($photo1, "$link");} $query0 = "UPDATE sites SET div = '$div', lien = '$link', parametre = '$target', nom = '$nom' ".$req_photo." WHERE client = '$client' and code ='$code' LIMIT 1"; echo "$query0"; $result0 = mysql_query($query0); echo "

Modification effectuée

";} if($ajoute=="oui"){ $code=$ligne.time().time() ; $valeur=$code.".jpg"; $query0 = "INSERT INTO sites (client, type, code, valeur, parametre) VALUES ('$client', '$type', '$code', '$valeur', '$parametre')"; $result0 = mysql_query($query0); } $query4 = "SELECT * FROM sites WHERE client = '$client' and code='$code'"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_row($result4)){ $valeur = $row4[3]; $target = $row4[4]; $police = $row4[7]; $taille = $row4[8]; $couleur = $row4[9]; $gras = $row4[10]; $italique = $row4[11]; $souligne = $row4[12]; $rayer = $row4[13]; $div = $row4[14]; $nom = $row4[22]; $link = $row4[15]; }echo "";} if($type=="html"){ if($action=="Appliquer"){ $query0 = "UPDATE sites SET nom='$nom' WHERE client = '$client' and code='$code' "; $result0 = mysql_query($query0); if($fichier<>""){ $now=time(); copy($fichier, "$now"); $fp = fopen("$now","r"); $adresse="imgs/".$code.".jpl"; $fich = fopen("$adresse","w+"); $ecrire="oui"; while (!feof ($fp)) { $ligne = fgets($fp); // $fbody=""; // $fbody=stristr($ligne, '""){$ecrire="non";} if($ecrire=="oui"){ fputs($fich, $ligne); } // $body=""; // $body=stristr($ligne, '""){$ecrire="oui";} } fclose($fp); fclose($fich); unlink($now); } } if($action=="Supprimer"){ $adresse="imgs/".$code.".jpl"; unlink($adresse); $query0 = "DELETE FROM sites WHERE client = '$client' and code='$code' "; $result0 = mysql_query($query0); } if($ajoute=="oui"){ $code=$ligne.time().time() ; $valeur="imgs/".$code.".jpl"; $fich = fopen("$valeur","w+"); fclose($fich); $query0 = "INSERT INTO sites (client, type, code, valeur, parametre) VALUES ('$client', '$type', '$code', '$valeur', '$parametre')"; $result0 = mysql_query($query0); } echo ""; $fp = fopen("$valeur","r"); while (!feof ($fp)) { $ligne = fgets($fp); echo "$ligne
"; } fclose($fp); } } mysql_close(); ?>