API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.05 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. echo $GET["id_suppr"];
  33. if ($_GET["id_suppr"]!=""){
  34. $query_suppr="DELETE FROM messages_boites WHERE id='".$_GET["id_suppr"]."'";
  35. mysql_query($query_suppr,$database);
  36. echo $query_suppr."</br>";
  37. if($_GET["page"]==1) {
  38.  
  39.  
  40. $query_select="
  41. SELECT
  42. *
  43. FROM messages_boites
  44. WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages=1 ORDER BY id ASC";
  45. echo $query_select."</br>";
  46. $res_select=mysql_query($query_select,$database);
  47.  
  48. while ($data_maj=mysql_fetch_array($res_select)){
  49. //todo boucle sur toutes les pages != 1 et update
  50. $tab_page=array(2,3,4,5,6,7,8,9,10,11);
  51. foreach($tab_page as $num_page){
  52. $sql= "DELETE FROM messages_boites WHERE id_affichage_pages=$num_page AND type_message=".$_GET["type_message"];
  53. mysql_query($sql);
  54. echo $sql."<br/>";
  55. //todo : faire un update pour cahque page, voir UPDATE en dessous
  56. $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'] .")";
  57. //mysql_query($query_maj,$database);
  58. //echo $query_maj .'<br/>';
  59. }
  60. echo $query_maj;
  61. }
  62. }
  63. exit;
  64. }
  65.  
  66. else if ($_GET["action"]=="ajouter"){
  67.  
  68. $query_insert="INSERT INTO messages_boites(id_affichage_pages,type_message) VALUES('".$_GET["page"]."','".$_GET["type_message"]."')";
  69. mysql_query($query_insert,$database);
  70.  
  71.  
  72. if($_GET["page"]==1) {
  73. $sql= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_GET["type_message"];
  74. mysql_query($sql);
  75.  
  76. $query_select="
  77. SELECT
  78. *
  79. FROM messages_boites
  80. WHERE type_message='".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."' AND id_affichage_pages=1 ORDER BY id ASC";
  81. $res_select=mysql_query($query_select,$database);
  82.  
  83. while ($data_maj=mysql_fetch_array($res_select)){
  84. //todo boucle sur toutes les pages != 1 et update
  85. $tab_page=array(2,3,4,5,6,7,8,9,10,11);
  86. foreach($tab_page as $num_page){
  87. //todo : faire un update pour cahque page, voir UPDATE en dessous
  88. $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'] .")";
  89. mysql_query($query_maj,$database);
  90. //echo $query_maj .'<br/>';
  91. }
  92.  
  93. }
  94. }
  95.  
  96. }
  97. //action valider
  98. else if ($_POST["valider"]=="VALIDER"){
  99. $sql2= "DELETE FROM messages_boites WHERE id_affichage_pages!=1 AND type_message=".$_POST["type_message"];
  100. mysql_query($sql2);
  101. $query_select="
  102. SELECT
  103. *
  104. FROM messages_boites
  105. 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";
  106. $res_select=mysql_query($query_select,$database);
  107.  
  108. while ($data_maj=mysql_fetch_array($res_select)){
  109. if($_POST["page"]==1){
  110. //todo boucle sur toutes les pages != 1 et update
  111. $tab_page=array(2,3,4,5,6,7,8,9,10,11);
  112. foreach($tab_page as $num_page){
  113. //todo delete pour page en question($num_page) tous les enregistrements
  114. //
  115. if($_POST["page"]==1){
  116.  
  117. }
  118. //insert data pour chaque page
  119. //demain à voir qu es t ce qu' il fait
  120. $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'] .")";
  121. mysql_query($sql3);
  122.  
  123. echo $sql3."</br>";
  124. // var_dump($data_maj['id']);
  125. /* echo '<pre>';
  126. print_r($_POST);
  127. echo '</pre>';*/
  128.  
  129. }
  130.  
  131. }
  132. $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']."'";
  133. mysql_query($query_maj,$database);
  134. }
  135. //exit;
  136. header("Location: index.php");
  137. }
  138.  
  139. #Contenu de la page
  140. headpage($rubrique,$page);
  141.  
  142. bodypage($rubrique,$page);
  143.  
  144. hautpage($rubrique,$page);
  145.  
  146. menupage_admin($rubrique,$page);
  147.  
  148. bandeauhaut($rubrique,$page);
  149.  
  150. logohaut($rubrique,$page);
  151.  
  152. //CONTENU CENTRAL DE LA PAGE
  153.  
  154. $query="
  155. SELECT
  156. *
  157. FROM messages_boites
  158. 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";
  159. $res=mysql_query($query,$database);
  160.  
  161. //affichage pave sur la page
  162. $query_affich="SELECT affiche_".$champ." FROM messages_pages WHERE id='".(($_GET["page"])?$_GET["page"]:$_POST["page"])."'";
  163. $res_affich=mysql_query($query_affich,$database);
  164. $data_affich=mysql_fetch_array($res_affich);
  165.  
  166. echo "
  167. <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
  168. <tr class=\"txttableau\">
  169. <td>&nbsp;</td>
  170. </tr>
  171. <tr class=\"txttableau\">
  172. <td align=\"right\">
  173. <form name=\"form1\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."\">
  174. <input type=hidden name=type_message value=\"".(($_GET["type_message"])?$_GET["type_message"]:$_POST["type_message"])."\">
  175. <input type=hidden name=page value=\"".(($_GET["page"])?$_GET["page"]:$_POST["page"])."\">
  176. <input type=hidden name=titre_page value=\"".(($_GET["titre_page"])?$_GET["titre_page"]:$_POST["titre_page"])."\">
  177. <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
  178. <tr>
  179. <td colspan=\"4\" align=center><strong>".(($_GET["titre_page"])?stripslashes($_GET["titre_page"]):stripslashes($_POST["titre_page"]))." - $titre_page</strong></td>
  180. </tr>
  181. <tr class=\"txttableau\">
  182. <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>
  183. </tr>
  184.  
  185. <tr class=\"txttableau\">
  186. <td align=center colspan=4>
  187. <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'\">
  188. </td>
  189. </tr>
  190. ";
  191.  
  192. echo "
  193. <tr class=\"txttableau\">
  194. <td>&nbsp;</td>
  195. <td>&nbsp;</td>
  196. <td>&nbsp;</td>
  197. <td>&nbsp;</td>
  198. </tr>
  199. ";
  200.  
  201.  
  202. $i=1;
  203. while ($data=mysql_fetch_array($res))
  204. {
  205. if (!is_int($i/2)) echo "
  206. <tr class=\"txttableau\">";
  207.  
  208. echo "
  209. <td align=\"right\">
  210. <table class=\"txttableau\">
  211. <tr>
  212. <td><input type=\"checkbox\" name=\"affichemessage_".$data["id"]."\" value=\"1\"".(($data["affiche_message"]==1)?" checked":"")."> Conseil $i</td>
  213. </tr>
  214. <tr>
  215. <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>
  216. </tr>
  217. </table>
  218. <td>
  219. <textarea name=\"textemessage_".$data["id"]."\" rows=\"4\">".stripslashes($data['message'])."</textarea>
  220. </td>";
  221.  
  222. if (is_int($i/2)) echo "
  223. </tr>
  224. ";
  225. $i++;
  226. }
  227.  
  228. echo "
  229. <tr class=\"txttableau\">
  230. <td align=center colspan=4>
  231. <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'\">
  232. </td>
  233. </tr>
  234. </table>
  235. </td>
  236. </tr>
  237. </table>
  238. ";
  239. //**********FIN CONTENU CENTRAL
  240.  
  241. boite_droite_admin($rubrique,$page);
  242.  
  243. bas_page_admin($rubrique,$page);
  244. baseclose($database);
  245. ?>
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!