Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $path="../";
- include($path."lib/lib.inc.php");
- $rubrique="index";
- $page="admin_messages";
- $lang="_fr";
- $color="#EADFF4";
- $database=baseconnect();
- //selection du champ affichage
- $type_message=(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"]);
- if ($type_message==1)
- {
- $titre_page="Conseils";
- $champ="conseils";
- }
- else if ($type_message==2)
- {
- $titre_page="News";
- $champ="news";
- }
- else if ($type_message==3)
- {
- $titre_page="T�moignages";
- $champ="temoignages";
- }
- //ajout suppression et action ajouter
- echo $GET["id_suppr"];
- if ($_GET["id_suppr"]!=""){
- $query_suppr="DELETE FROM messages_boites WHERE id='".$_GET["id_suppr"]."'";
- mysql_query($query_suppr,$database);
- echo $query_suppr."</br>";
- if($_GET["page"]==1) {
- $query_select="
- SELECT
- *
- FROM messages_boites
- WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages=1 ORDER BY id ASC";
- echo $query_select."</br>";
- $res_select=mysql_query($query_select,$database);
- while ($data_maj=mysql_fetch_array($res_select)){
- //todo boucle sur toutes les pages != 1 et update
- $tab_page=array(2,3,4,5,6,7,8,9,10,11);
- foreach($tab_page as $num_page){
- $sql= "DELETE FROM messages_boites WHERE id_affichage_pages=$num_page AND type_message=".$_GET["type_message"];
- mysql_query($sql);
- echo $sql."<br/>";
- //todo : faire un update pour cahque page, voir UPDATE en dessous
- $query_maj="INSERT INTO messages_boites(affiche_message,message,id_affichage_pages,type_message) VALUES(". $data_maj['affiche_message'] .",'". $data_maj['message'] ."',". $num_page .",". $_GET['type_message'] .")";
- //mysql_query($query_maj,$database);
- //echo $query_maj .'<br/>';
- }
- echo $query_maj;
- }
- }
- exit;
- }
- else if ($_GET["action"]=="ajouter"){
- $query_insert="INSERT INTO messages_boites(id_affichage_pages,type_message) VALUES('".$_GET["page"]."','".$_GET["type_message"]."')";
- mysql_query($query_insert,$database);
- if($_GET["page"]==1) {
- $sql= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_GET["type_message"];
- mysql_query($sql);
- $query_select="
- SELECT
- *
- FROM messages_boites
- WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages=1 ORDER BY id ASC";
- $res_select=mysql_query($query_select,$database);
- while ($data_maj=mysql_fetch_array($res_select)){
- //todo boucle sur toutes les pages != 1 et update
- $tab_page=array(2,3,4,5,6,7,8,9,10,11);
- foreach($tab_page as $num_page){
- //todo : faire un update pour cahque page, voir UPDATE en dessous
- $query_maj="INSERT INTO messages_boites(affiche_message,message,id_affichage_pages,type_message) VALUES(". $data_maj['affiche_message'] .",'". $data_maj['message'] ."',". $num_page .",". $_GET['type_message'] .")";
- mysql_query($query_maj,$database);
- //echo $query_maj .'<br/>';
- }
- }
- }
- }
- //action valider
- else if ($_POST["valider"]=="VALIDER"){
- $sql2= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_POST["type_message"];
- mysql_query($sql2);
- $query_select="
- SELECT
- *
- FROM messages_boites
- WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages='".(($_GET["page"])?$_GET["page"]:$_POST["page"])."'ORDER BY id ASC";
- $res_select=mysql_query($query_select,$database);
- while ($data_maj=mysql_fetch_array($res_select)){
- if($_POST["page"]==1){
- //todo boucle sur toutes les pages != 1 et update
- $tab_page=array(2,3,4,5,6,7,8,9,10,11);
- foreach($tab_page as $num_page){
- //todo delete pour page en question($num_page) tous les enregistrements
- //
- if($_POST["page"]==1){
- }
- //insert data pour chaque page
- //demain à voir qu es t ce qu' il fait
- $sql3="INSERT INTO messages_boites(affiche_message,message,id_affichage_pages,type_message) VALUES(" .(($_POST["affichemessage_".$data_maj['id']]==1)?"1":"0").",'".addslashes($_POST["textemessage_".$data_maj['id']])."',". $num_page .",". $_POST['type_message'] .")";
- mysql_query($sql3);
- echo $sql3."</br>";
- // var_dump($data_maj['id']);
- /* echo '<pre>';
- print_r($_POST);
- echo '</pre>';*/
- }
- }
- $query_maj="UPDATE messages_boites SET affiche_message='".(($_POST["affichemessage_".$data_maj['id']]==1)?"1":"0")."',message='".addslashes($_POST["textemessage_".$data_maj['id']])."' WHERE id='".$data_maj['id']."'";
- mysql_query($query_maj,$database);
- }
- //exit;
- header("Location: index.php");
- }
- #Contenu de la page
- headpage($rubrique,$page);
- bodypage($rubrique,$page);
- hautpage($rubrique,$page);
- menupage_admin($rubrique,$page);
- bandeauhaut($rubrique,$page);
- logohaut($rubrique,$page);
- //CONTENU CENTRAL DE LA PAGE
- $query="
- SELECT
- *
- FROM messages_boites
- WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages='".(($_GET["page"])?$_GET["page"]:$_POST["page"])."' ORDER BY id";
- $res=mysql_query($query,$database);
- //affichage pave sur la page
- $query_affich="SELECT affiche_".$champ." FROM messages_pages WHERE id='".(($_GET["page"])?$_GET["page"]:$_POST["page"])."'";
- $res_affich=mysql_query($query_affich,$database);
- $data_affich=mysql_fetch_array($res_affich);
- echo "
- <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
- <tr class=\"txttableau\">
- <td> </td>
- </tr>
- <tr class=\"txttableau\">
- <td align=\"right\">
- <form name=\"form1\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."\">
- <input type=hidden name=type_message value=\"".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."\">
- <input type=hidden name=page value=\"".(($_GET["page"])?$_GET["page"]:$_POST["page"])."\">
- <input type=hidden name=titre_page value=\"".(($_GET["titre_page"])?$_GET["titre_page"]:$_POST["titre_page"])."\">
- <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
- <tr>
- <td colspan=\"4\" align=center><strong>".(($_GET["titre_page"])?stripslashes($_GET["titre_page"]):stripslashes($_POST["titre_page"]))." - $titre_page</strong></td>
- </tr>
- <tr class=\"txttableau\">
- <td colspan=4 align=center><a href=\"".$_SERVER["PHP_SELF"]."?page=".(($_GET["page"])?$_GET["page"]:$_POST["page"])."&type_message=".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."&titre_page=".(($_GET["titre_page"])?$_GET["titre_page"]:$_POST["titre_page"])."&action=ajouter\">Ajouter</a></td>
- </tr>
- <tr class=\"txttableau\">
- <td align=center colspan=4>
- <input name=\"valider\" type=\"submit\" class=\"txtdroite\" value=\"VALIDER\"> <input name=\"annuler\" type=\"button\" class=\"txttableau\" value=\"Annuler\" onclick=\"javascript:window.location='index.php'\">
- </td>
- </tr>
- ";
- echo "
- <tr class=\"txttableau\">
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- ";
- $i=1;
- while ($data=mysql_fetch_array($res))
- {
- if (!is_int($i/2)) echo "
- <tr class=\"txttableau\">";
- echo "
- <td align=\"right\">
- <table class=\"txttableau\">
- <tr>
- <td><input type=\"checkbox\" name=\"affichemessage_".$data["id"]."\" value=\"1\"".(($data["affiche_message"]==1)?" checked":"")."> Conseil $i</td>
- </tr>
- <tr>
- <td><a href=\"".$_SERVER['PHP_SELF']."?id_suppr=".$data['id']."&page=".$_REQUEST["page"]."&type_message=".$_REQUEST["type_message"]."&titre_page=".$_REQUEST["titre_page"]."\">Supprimer</a></td>
- </tr>
- </table>
- <td>
- <textarea name=\"textemessage_".$data["id"]."\" rows=\"4\">".stripslashes($data['message'])."</textarea>
- </td>";
- if (is_int($i/2)) echo "
- </tr>
- ";
- $i++;
- }
- echo "
- <tr class=\"txttableau\">
- <td align=center colspan=4>
- <input name=\"valider\" type=\"submit\" class=\"txtdroite\" value=\"VALIDER\"> <input name=\"annuler\" type=\"button\" class=\"txttableau\" value=\"Annuler\" onclick=\"javascript:window.location='index.php'\">
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- ";
- //**********FIN CONTENU CENTRAL
- boite_droite_admin($rubrique,$page);
- bas_page_admin($rubrique,$page);
- baseclose($database);
- ?>
Add Comment
Please, Sign In to add comment