/_contribs_/_hebergement_/multispip1/suppression.php

https://bitbucket.org/pombredanne/spip-zone-treemap · PHP · 150 lines · 136 code · 10 blank · 4 comment · 3 complexity · 21192bcbbe8971b7ff7a63b6e2130a21 MD5 · raw file 

    

  1. <?php

    2. 

  2. $niveauPage= "";

    3. 

  3. include($niveauPage . "inc_verif.php"); // Verification de l'ID de l'inscrit 

    4. 

  4. include($niveauPage . "inc_fonctions.php");

    5. 

  5. 

    6. 

  6. // Recuperer les variables 

    7. 

  7. if (isset($_REQUEST['idSupprime'])){

    8. 

  8. 	$idSupprime = $_REQUEST['idSupprime'];

    9. 

  9. 	settype($idSupprime, 'integer');

    10. 

  10. } else

    11. 

  11. 	$idSupprime = "";

    12. 

  12. 

    13. 

  13. // Connection 

    14. 

  14. include($niveauPage . "inc_connection.php");

    15. 

  15. mysql_connect($hote,$utilisateurBase,$mdpBase);

    16. 

  16. mysql_select_db($base);

    17. 

  17. 

    18. 

  18. settype($idUser, 'integer');

    19. 

  19. // requetes 

    20. 

  20. $lister= "SELECT * FROM sites, inscrits

    21. 

  21. WHERE sites.IdInscrit = inscrits.IdInscrit

    22. 

  22. AND sites.IdInscrit = '$idUser'

    23. 

  23. ORDER BY sites.IdSite DESC";

    24. 

  24. 

    25. 

  25. $supprimer= "DELETE FROM sites

    26. 

  26. WHERE idSite = '$idSupprime'

    27. 

  27. LIMIT 1";

    28. 

  28. 

    29. 

  29. ?>

    30. 

  30. <html>

    31. 

  31. <head>

    32. 

  32. <title>Suppression</title>

    33. 

  33. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

    34. 

  34. <?php 

    35. 

  35. // Supprimer le site séléctionné

    36. 

  36. if ($idSupprime) {

    37. 

  37. mysql_query($supprimer) or die("la requete a echouée parce que : ". mysql_error());

    38. 

  38. echo "<meta http-equiv=\"refresh\" content=\"0;URL=suppression.php\">";

    39. 

  39. }

    40. 

  40. ?>

    41. 

  41. <link href="css_edf.css" rel="stylesheet" type="text/css">

    42. 

  42. </head>

    43. 

  43. 

    44. 

  44. <body>

    45. 

  45. <table width="600" border="0" cellpadding="1" cellspacing="0" bgcolor="#003366">

    46. 

  46. 

    47. 

  47.   <tr>

    48. 

  48.     <td><table width="100%" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">

    49. 

  49.         <tr>

    50. 

  50.           <td><table width="100%" border="0" cellspacing="0" cellpadding="1">

    51. 

  51.                 <tr> 

    52. 

  52.                   <td colspan="2" bgcolor="#003366"><table width="100%" border="0" cellpadding="3" cellspacing="0" bgcolor="#003366">

    53. 

  53.                       <tr> 

    54. 

  54.                         

    55. 

  55.                       <td class="edf7"><strong><font color="#FFFFFF">Administration 

    56. 

  56.                         - Supprimer un site</font></strong></td>

    57. 

  57.                       </tr>

    58. 

  58.                     </table></td>

    59. 

  59.                 </tr>

    60. 

  60.                 <tr> 

    61. 

  61.                   <td colspan="2"><img src="images/dot.gif" width="500" height="5"></td>

    62. 

  62.                 </tr>

    63. 

  63.                 <tr> 

    64. 

  64.                   

    65. 

  65.                 <td class="edf7">

    66. 

  66. <table width="100%" border="0" cellpadding="1" cellspacing="2">

    67. 

  67.                     <tr> 

    68. 

  68.                       <td colspan="4" class="edf4"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    69. 

  69.                           <tr> 

    70. 

  70.                             <td background="images/pointill_bleu.gif"><img src="images/dot.gif" width="2" height="1"></td>

    71. 

  71.                           </tr>

    72. 

  72.                         </table></td>

    73. 

  73.                     </tr>

    74. 

  74.                     <tr> 

    75. 

  75.                       <td bgcolor="#F2F2F2" class="edf4">Site </td>

    76. 

  76.                       <td bgcolor="#F2F2F2" class="edf4">Commentaire</td>

    77. 

  77.                       <td align="center" bgcolor="#F2F2F2" class="edf4">Date</td>

    78. 

  78.                       <td bgcolor="#F2F2F2">&nbsp;</td>

    79. 

  79.                     </tr>

    80. 

  80.                     <tr> 

    81. 

  81.                       <td colspan="4" class="edf8"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    82. 

  82.                           <tr> 

    83. 

  83.                             <td background="images/pointill_bleu.gif"><img src="images/dot.gif" width="2" height="1"></td>

    84. 

  84.                           </tr>

    85. 

  85.                         </table></td>

    86. 

  86.                     </tr>

    87. 

  87. <?php

    88. 

  88. $requete= mysql_query($lister) or die("la requete a echouée parce que : ". mysql_error());

    89. 

  89. while ($resultat= mysql_fetch_object($requete))

    90. 

  90. { 

    91. 

  91. $date= "$resultat->dateEnregistrement";

    92. 

  92. ?>

    93. 

  93.                     <tr> 

    94. 

  94.                       <td class="edf8"><a href="<?php echo "$resultat->UrlSite" ?>"  class="edf8" target="_blank"><?php echo "$resultat->NomSite"; ?></a>&nbsp;</td>

    95. 

  95.                       <td class="edf5"><?php echo "$resultat->DescriptionSite"; ?>&nbsp;</td>

    96. 

  96.                       <td align="center" class="edf5"><?php formateDate($date); ?></td>

    97. 

  97.                       <td align="center"><a href="suppression.php?idSupprime=<?php echo "$resultat->IdSite"; ?>" class="edf7">Supprimer</a></td>

    98. 

  98.                     </tr>

    99. 

  99.                     <tr> 

    100. 

  100.                       <td colspan="4" class="edf8"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    101. 

  101.                           <tr> 

    102. 

  102.                             <td background="images/pointill_bleu.gif"><img src="images/dot.gif" width="2" height="1"></td>

    103. 

  103.                           </tr>

    104. 

  104.                         </table></td>

    105. 

  105.                     </tr>

    106. 

  106.                     <?php } ?>

    107. 

  107.                   </table>

    108. 

  108. 

    109. 

  109.                 </td>

    110. 

  110.                 </tr>

    111. 

  111.                 <tr> 

    112. 

  112.                   <td colspan="2"><img src="images/dot.gif" width="500" height="5"></td>

    113. 

  113.                 </tr>

    114. 

  114.                 <tr> 

    115. 

  115.                   <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">

    116. 

  116.                     <tr> 

    117. 

  117.                       <td bgcolor="#003366"><img src="images/dot.gif" width="2" height="1"></td>

    118. 

  118.                     </tr>

    119. 

  119.                   </table></td>

    120. 

  120.                 </tr>

    121. 

  121.                 <tr> 

    122. 

  122.                   <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="3">

    123. 

  123.                       <tr> 

    124. 

  124.                         <td><table width="100%" border="0" cellspacing="0" cellpadding="1">

    125. 

  125.                             <tr> 

    126. 

  126.                               <td bgcolor="#999999"> <table width="100%" border="0" cellpadding="2" cellspacing="2" bgcolor="#FFFFFF">

    127. 

  127.                                   <tr> 

    128. 

  128.                                     <td align="center" bgcolor="#999999" class="edf8"><a href="accueil_inscrits.php" class="edf8"><font color="#FFFFFF">Retourner 

    129. 

  129.                                       &agrave; l'administration</font></a></td>

    130. 

  130.                                   </tr>

    131. 

  131.                                 </table></td>

    132. 

  132.                             </tr>

    133. 

  133.                           </table></td>

    134. 

  134.                       </tr>

    135. 

  135.                     </table></td>

    136. 

  136.                 </tr>

    137. 

  137.               </table></td>

    138. 

  138.                     </tr>

    139. 

  139.                   </table></td>

    140. 

  140.               </tr>

    141. 

  141.             </table></td>

    142. 

  142.         </tr>

    143. 

  143.       </table></td>

    144. 

  144.   </tr>

    145. 

  145. </table>

    146. 

  146. <span class="edf11"><img src="images/dot.gif" width="500" height="5"><br><em>Cette action supprimera votre site de la liste des sites de <?php echo $nom_site; ?>. 

    147. 

  147. <br />Ni votre site, ni votre base ne seront physiquement détruits. Cela vous permet une sorte de site "privé".

    148. 

  148. <br />Vous pouvez bien entendu <a href="mailto:<?php echo $mailAdmin ?>">demander à l'administrateur du MultiSpip</a> de physiquement détruire votre site.</em></span>

    149. 

  149. </body>

    150. 

  150. </html>
    151.