API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2018
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.72 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. $path="../";
  3. include($path."lib/lib.inc.php");
  4.  
  5. $rubrique="index";
  6. $page="admin_messages";
  7. $lang="_fr";
  8. $color="#EADFF4";
  9.  
  10. $database=baseconnect();
  11.  
  12. //selection du champ affichage
  13. $type_message=(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"]);
  14. if ($type_message==1)
  15. {
  16. $titre_page="Conseils";
  17. $champ="conseils";
  18. }
  19. else if ($type_message==2)
  20. {
  21. $titre_page="News";
  22. $champ="news";
  23. }
  24. else if ($type_message==3)
  25. {
  26. $titre_page="T�moignages";
  27. $champ="temoignages";
  28. }
  29.  
  30.  
  31. //ajout suppression et action ajouter
  32. if ($_GET["id_suppr"]!=""){
  33. $query_suppr="DELETE FROM messages_boites WHERE id='".$_GET["id_suppr"]."'";
  34. mysql_query($query_suppr,$database);
  35. }
  36. else if ($_GET["action"]=="ajouter"){
  37. $query_insert="INSERT INTO messages_boites(id_affichage_pages,type_message) VALUES('".$_GET["page"]."','".$_GET["type_message"]."')";
  38. mysql_query($query_insert,$database);
  39.  
  40.  
  41. if($_GET["page"]==1) {
  42. $sql= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_GET["type_message"];
  43. mysql_query($sql);
  44.  
  45. $query_select="
  46. SELECT
  47. *
  48. FROM messages_boites
  49. WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages=1 ORDER BY id ASC";
  50. $res_select=mysql_query($query_select,$database);
  51.  
  52. while ($data_maj=mysql_fetch_array($res_select)){
  53. //todo boucle sur toutes les pages != 1 et update
  54. $tab_page=array(2,3,4,5,6,7,8,9,10,11);
  55. foreach($tab_page as $num_page){
  56. //todo : faire un update pour cahque page, voir UPDATE en dessous
  57. $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'] .")";
  58. mysql_query($query_maj,$database);
  59. //echo $query_maj .'<br/>';
  60. }
  61.  
  62. }
  63. }
  64.  
  65. }
  66. //action valider
  67. else if ($_POST["valider"]=="VALIDER"){
  68. $sql2= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_POST["type_message"];
  69. mysql_query($sql2);
  70. $query_select="
  71. SELECT
  72. *
  73. FROM messages_boites
  74. 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";
  75. $res_select=mysql_query($query_select,$database);
  76.  
  77. while ($data_maj=mysql_fetch_array($res_select)){
  78. if($_POST["page"]==1){
  79. //todo boucle sur toutes les pages != 1 et update
  80. $tab_page=array(2,3,4,5,6,7,8,9,10,11);
  81. foreach($tab_page as $num_page){
  82. //todo delete pour page en question($num_page) tous les enregistrements
  83. //
  84. if($_POST["page"]==1){
  85.  
  86. }
  87. //insert data pour chaque page
  88. //demain à voir qu es t ce qu' il fait
  89. $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'] .")";
  90. mysql_query($sql3);
  91.  
  92. echo $sql3."</br>";
  93. // var_dump($data_maj['id']);
  94. /* echo '<pre>';
  95. print_r($_POST);
  96. echo '</pre>';*/
  97.  
  98. }
  99.  
  100. }
  101. $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']."'";
  102. mysql_query($query_maj,$database);
  103. }
  104. //exit;
  105. header("Location: index.php");
  106. }
  107.  
  108. #Contenu de la page
  109. headpage($rubrique,$page);
  110.  
  111. bodypage($rubrique,$page);
  112.  
  113. hautpage($rubrique,$page);
  114.  
  115. menupage_admin($rubrique,$page);
  116.  
  117. bandeauhaut($rubrique,$page);
  118.  
  119. logohaut($rubrique,$page);
  120.  
  121. //CONTENU CENTRAL DE LA PAGE
  122.  
  123. $query="
  124. SELECT
  125. *
  126. FROM messages_boites
  127. 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";
  128. $res=mysql_query($query,$database);
  129.  
  130. //affichage pave sur la page
  131. $query_affich="SELECT affiche_".$champ." FROM messages_pages WHERE id='".(($_GET["page"])?$_GET["page"]:$_POST["page"])."'";
  132. $res_affich=mysql_query($query_affich,$database);
  133. $data_affich=mysql_fetch_array($res_affich);
  134.  
  135. echo "
  136. <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
  137. <tr class=\"txttableau\">
  138. <td>&nbsp;</td>
  139. </tr>
  140. <tr class=\"txttableau\">
  141. <td align=\"right\">
  142. <form name=\"form1\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."\">
  143. <input type=hidden name=type_message value=\"".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."\">
  144. <input type=hidden name=page value=\"".(($_GET["page"])?$_GET["page"]:$_POST["page"])."\">
  145. <input type=hidden name=titre_page value=\"".(($_GET["titre_page"])?$_GET["titre_page"]:$_POST["titre_page"])."\">
  146. <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
  147. <tr>
  148. <td colspan=\"4\" align=center><strong>".(($_GET["titre_page"])?stripslashes($_GET["titre_page"]):stripslashes($_POST["titre_page"]))." - $titre_page</strong></td>
  149. </tr>
  150. <tr class=\"txttableau\">
  151. <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>
  152. </tr>
  153.  
  154. <tr class=\"txttableau\">
  155. <td align=center colspan=4>
  156. <input name=\"valider\" type=\"submit\" class=\"txtdroite\" value=\"VALIDER\">&nbsp;&nbsp;&nbsp;&nbsp;<input name=\"annuler\" type=\"button\" class=\"txttableau\" value=\"Annuler\" onclick=\"javascript:window.location='index.php'\">
  157. </td>
  158. </tr>
  159. ";
  160.  
  161. echo "
  162. <tr class=\"txttableau\">
  163. <td>&nbsp;</td>
  164. <td>&nbsp;</td>
  165. <td>&nbsp;</td>
  166. <td>&nbsp;</td>
  167. </tr>
  168. ";
  169.  
  170.  
  171. $i=1;
  172. while ($data=mysql_fetch_array($res))
  173. {
  174. if (!is_int($i/2)) echo "
  175. <tr class=\"txttableau\">";
  176.  
  177. echo "
  178. <td align=\"right\">
  179. <table class=\"txttableau\">
  180. <tr>
  181. <td><input type=\"checkbox\" name=\"affichemessage_".$data["id"]."\" value=\"1\"".(($data["affiche_message"]==1)?" checked":"")."> Conseil $i</td>
  182. </tr>
  183. <tr>
  184. <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>
  185. </tr>
  186. </table>
  187. <td>
  188. <textarea name=\"textemessage_".$data["id"]."\" rows=\"4\">".stripslashes($data['message'])."</textarea>
  189. </td>";
  190.  
  191. if (is_int($i/2)) echo "
  192. </tr>
  193. ";
  194. $i++;
  195. }
  196.  
  197. echo "
  198. <tr class=\"txttableau\">
  199. <td align=center colspan=4>
  200. <input name=\"valider\" type=\"submit\" class=\"txtdroite\" value=\"VALIDER\">&nbsp;&nbsp;&nbsp;&nbsp;<input name=\"annuler\" type=\"button\" class=\"txttableau\" value=\"Annuler\" onclick=\"javascript:window.location='index.php'\">
  201. </td>
  202. </tr>
  203. </table>
  204. </td>
  205. </tr>
  206. </table>
  207. ";
  208. //**********FIN CONTENU CENTRAL
  209.  
  210. boite_droite_admin($rubrique,$page);
  211.  
  212. bas_page_admin($rubrique,$page);
  213. baseclose($database);
  214. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!