[Sommaire] [Imprimer]

   1  <?php
   2  //----------------------------------------------------------------------

   3  //  CrawlTrack 2.2.1

   4  //----------------------------------------------------------------------

   5  // Crawler Tracker for website

   6  //----------------------------------------------------------------------

   7  // Author: Jean-Denis Brun

   8  //----------------------------------------------------------------------

   9  // Website: www.crawltrack.fr

  10  //----------------------------------------------------------------------

  11  // That script is distributed under GNU GPL license

  12  //----------------------------------------------------------------------

  13  // file: adminusersuppress.php

  14  //----------------------------------------------------------------------

  15  
  16  if (!defined('IN_CRAWLT_ADMIN'))
  17  {
  18      echo"<h1>Hacking attempt !!!!</h1>";
  19      exit();
  20  }
  21  
  22  //initialize array

  23  $loginuser=array();
  24  
  25  if(isset($_POST['suppressuser']))
  26      {    
  27      $suppressuser = (int)$_POST['suppressuser'];
  28      }
  29  else
  30      {
  31      $suppressuser = 0;
  32      }
  33  
  34  if(isset($_POST['suppressuserok']))
  35      {    
  36      $suppressuserok = (int)$_POST['suppressuserok'];
  37      }
  38  else
  39      {
  40      $suppressuserok = 0;
  41      }
  42  
  43  
  44  
  45  if($suppressuser==1)
  46      
  47      {
  48      
  49      if(isset($_POST['logintosuppress']))
  50          {    
  51          $logintosuppress = $_POST['logintosuppress'];
  52          }
  53      else
  54          {
  55          header("Location:../index.php");
  56          }
  57      
  58          
  59      if($suppressuserok==1)
  60          {
  61          //login suppression

  62          
  63          //database connection

  64          $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
  65          $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
  66  
  67          //database query to suppress the login        

  68          $sqldelete = "DELETE FROM crawlt_login WHERE crawlt_user= '".sql_quote($logintosuppress)."'";
  69  
  70          $requetedelete = mysql_query($sqldelete, $connexion) or die("MySQL query error");
  71          
  72          if($requetedelete)
  73              {
  74              echo"<br><br><h1>".$language['user_suppress_ok']."</h1>\n";
  75              
  76              echo"<div class=\"form\">\n";
  77              echo"<form action=\"index.php\" method=\"POST\" >\n";
  78              echo "<input type=\"hidden\" name ='navig' value='6'>\n";            
  79              echo"<input name='ok' type='submit'  value='OK' size='20'>\n";
  80              echo"</form>\n";
  81              echo"</div>\n";    
  82              }
  83          else
  84              {
  85              echo"<br><br><h1>".$language['user_suppress_no_ok']."</h1>\n";            
  86              
  87              echo"<div class=\"form\">\n";
  88              echo"<form action=\"index.php\" method=\"POST\" >\n";
  89              echo "<input type=\"hidden\" name ='navig' value='6'>\n";            
  90              echo"<input name='ok' type='submit'  value='OK' size='20'>\n";
  91              echo"</form>\n";
  92              echo"</div>\n";            
  93              }
  94          
  95          }
  96      else
  97          {
  98          //validation of suppression    

  99      
 100          //display    

 101          
 102          $logintosuppress    = stripslashes($logintosuppress);
 103          $logintosuppressdisplay=htmlentities($logintosuppress);        
 104  
 105          echo"<br><br><h1>".$language['user_suppress_validation']."</h1>\n";
 106          echo"<h1>".$language['login'].":&nbsp;$logintosuppressdisplay</h1>\n";
 107      
 108          echo"<div class=\"form\">\n";
 109          echo"<form action=\"index.php\" method=\"POST\" >\n";
 110          echo "<input type=\"hidden\" name ='navig' value='6'>\n";
 111          echo "<input type=\"hidden\" name ='validform' value=\"8\">";
 112          echo "<input type=\"hidden\" name ='suppressuser' value=\"1\">\n";
 113          echo "<input type=\"hidden\" name ='suppressuserok' value=\"1\">\n";    
 114          echo "<input type=\"hidden\" name ='logintosuppress' value=\"$logintosuppress\">\n";
 115          echo"<table class=\"centrer\">\n";    
 116          echo"<tr>\n";
 117          echo"<td colspan=\"2\">\n";
 118          echo"<input name='ok' type='submit'  value=' ".$language['yes']." ' size='20'>\n";
 119          echo"</td>\n";
 120          echo"</tr>\n";
 121          echo"</table>\n";
 122          echo"</form>\n";
 123          echo"</div>";
 124      
 125          echo"<div class=\"form\">\n";
 126          echo"<form action=\"index.php\" method=\"POST\" >\n";
 127          echo "<input type=\"hidden\" name ='navig' value='6'>\n";
 128          echo "<input type=\"hidden\" name ='validform' value=\"8\">";
 129          echo "<input type=\"hidden\" name ='suppressuser' value=\"0\">\n";
 130          echo "<input type=\"hidden\" name ='suppressuserok' value=\"0\">\n";    
 131          echo"<table class=\"centrer\">\n";    
 132          echo"<tr>\n";
 133          echo"<td colspan=\"2\">\n";
 134          echo"<input name='ok' type='submit'  value=' ".$language['no']." ' size='20'>\n";
 135          echo"</td>\n";
 136          echo"</tr>\n";
 137          echo"</table>\n";
 138          echo"</form>\n";
 139          echo"</div>";    
 140      
 141          }    
 142      
 143      }
 144  else
 145      {
 146  
 147          
 148      //database connection

 149      $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
 150      $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
 151  
 152      //database query to get user list

 153          
 154      $sqldeleteuser = "SELECT * FROM crawlt_login WHERE admin=0";
 155  
 156      $requetedeleteuser = mysql_query($sqldeleteuser, $connexion) or die("MySQL query error");
 157  
 158  
 159      $nbrresult=mysql_num_rows($requetedeleteuser);
 160          
 161      if($nbrresult>=1)
 162              {
 163              while ($ligne = mysql_fetch_object($requetedeleteuser))                                                                              
 164                  {
 165                  $idlogin=$ligne->id_login; 
 166                  $userlogin=$ligne->crawlt_user;
 167                  $loginuser[$idlogin]=$userlogin;
 168                  }
 169      
 170          //display    

 171  
 172          echo"<br><br><h1>".$language['user_suppress']."</h1>\n";
 173  
 174          echo"<div class='tableau' align='center'>\n";    
 175          echo"<table   cellpadding='0px' cellspacing='0' width='450px'>\n";
 176          echo"<tr><th class='tableau2' colspan='2'>\n";
 177          echo"".$language['user_list']."\n";
 178          echo"</th></tr>\n";
 179  
 180          foreach ($loginuser as $user1)
 181              {
 182              $user1display=htmlentities($user1);        
 183              echo"<tr><td class='tableau3' width='300px'>\n";
 184              echo"".$user1display."\n";
 185              echo"</td><td class='tableau4'>\n";    
 186              echo"<form action=\"index.php\" method=\"POST\" >\n";
 187              echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 188              echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 189              echo "<input type=\"hidden\" name ='validform' value=\"8\">\n";    
 190              echo "<input type=\"hidden\" name ='suppressuser' value=\"1\">\n";
 191              echo "<input type=\"hidden\" name ='logintosuppress' value=\"$user1\">\n";            
 192              echo"<input type='submit' class='button4' value='".$language['suppress_user']."'>\n";
 193              echo"</form>\n";
 194              echo"</td></tr>\n";
 195              }
 196          echo"</table></div>\n";
 197          echo"<br>\n";
 198          }
 199      else
 200          {
 201          echo"<br><br><h1>".$language['user_suppress']."</h1>\n";
 202  
 203          echo"<div class='tableau' align='center'>\n";    
 204          echo"<table   cellpadding='0px' cellspacing='0' width='450px'>\n";
 205          echo"<tr><th class='tableau2' colspan='2'>\n";
 206          echo"".$language['user_list']."\n";
 207          echo"</th></tr>\n";        
 208          echo"</table></div>\n";
 209          echo"<br>\n";        
 210          
 211          }
 212      }
 213  
 214  ?>