Cr@wltr@ck 2.2.1 : /include/adminusersite.php source

[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: adminusersite.php

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

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

  22  $listsite=array();
  23  $listidsite=array();
  24  
  25  //valid form

  26  
  27  if($validlogin==1)
  28      {
  29      if($login=='' OR $password2=='' OR $password3=='' OR $password2 != $password3)
  30          {        
  31          echo"<br><br><p>".$language['login_no_ok']."</p>";
  32  
  33  
  34          echo"<div class=\"form\">\n";
  35          echo"<form action=\"index.php\" method=\"POST\" >\n";
  36          echo "<input type=\"hidden\" name ='validform' value='7'>\n";
  37          echo "<input type=\"hidden\" name ='navig' value='6'>\n";
  38          echo "<input type=\"hidden\" name ='validlogin' value='0'>\n";
  39          echo "<input type=\"hidden\" name ='logintype' value='$logintype'>\n";                    
  40          echo "<input type=\"hidden\" name ='login' value='$login'>\n";
  41          echo "<input type=\"hidden\" name ='password2' value='$password2'>\n";
  42          echo "<input type=\"hidden\" name ='password3' value='$password3'>\n";
  43          echo "<input type=\"hidden\" name ='site' value='$site'>\n";        
  44          echo"<input name='ok' type='submit'  value=' ".$language['back_to_form']." ' size='20'>\n";
  45          echo"</form>\n";
  46          echo"</div>\n";
  47          }
  48      else
  49          {
  50          //database connection

  51          $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
  52          $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
  53          
  54          //check if login already exist

  55              
  56          $sqlexist = "SELECT * FROM crawlt_login
  57          WHERE crawlt_user='".sql_quote($login)."'";
  58  
  59          $requeteexist = mysql_query($sqlexist, $connexion) or die("MySQL query error");
  60          
  61          $nbrresult=mysql_num_rows($requeteexist);
  62          
  63          if($nbrresult>=1)
  64              {
  65              //login already exist        

  66              echo"<br><br><h1>".$language['exist_login']."</h1>";
  67  
  68  
  69              echo"<div class=\"form\">\n";
  70              echo"<form action=\"index.php\" method=\"POST\" >\n";
  71              echo "<input type=\"hidden\" name ='validform' value='7'>\n";
  72              echo "<input type=\"hidden\" name ='navig' value='6'>\n";
  73              echo "<input type=\"hidden\" name ='validlogin' value='0'>\n";
  74              echo "<input type=\"hidden\" name ='logintype' value='$logintype'>\n";                    
  75              echo "<input type=\"hidden\" name ='login' value='$login'>\n";
  76              echo "<input type=\"hidden\" name ='password2' value='$password2'>\n";
  77              echo "<input type=\"hidden\" name ='password3' value='$password3'>\n";
  78              echo "<input type=\"hidden\" name ='site' value='$site'>\n";        
  79              echo"<input name='ok' type='submit'  value=' ".$language['back_to_form']." ' size='20'>\n";
  80              echo"</form>\n";
  81              echo"</div>\n";
  82              }
  83          else
  84              {        
  85                  
  86              //add the login in the database

  87          
  88              //password treatment

  89              $pass=md5($password2);
  90  
  91              $admin=0;
  92              $website=$site;
  93  
  94          
  95              $sqllogin="INSERT INTO crawlt_login (crawlt_user,crawlt_password,admin,site) VALUES ('".sql_quote($login)."','".sql_quote($pass)."','".sql_quote($admin)."','".sql_quote($website)."')";
  96              $requetelogin = mysql_query($sqllogin, $connexion) or die("MySQL query error");
  97  
  98              //check is requete is successfull

  99  
 100              if($requetelogin==1)
 101                  {
 102                  echo"<br><br><h2>".$language['user_site_creation']."</h2>\n";
 103  
 104                  echo"<p>".$language['login_ok']."</p>\n";    
 105              
 106                  echo"<div class=\"form\">\n";
 107                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 108                  echo "<input type=\"hidden\" name ='navig' value='6'>\n";            
 109                  echo"<input name='ok' type='submit'  value='OK' size='20'>\n";
 110                  echo"</form>\n";
 111                  echo"</div>\n";                                
 112              
 113                  }
 114              else
 115                  {
 116                  echo"<br><br><h2>".$language['user_site_creation']."</h2>\n";            
 117                  echo"<p>".$language['login_no_ok2']."</p>";
 118  
 119              
 120                  echo"<div class=\"form\">\n";
 121                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 122                  echo "<input type=\"hidden\" name ='validform' value='7'>\n";
 123                  echo "<input type=\"hidden\" name ='navig' value='6'>\n";
 124                  echo "<input type=\"hidden\" name ='validlogin' value='1'>\n";
 125                  echo "<input type=\"hidden\" name ='site' value='$site'>\n";            
 126                  echo "<input type=\"hidden\" name ='logintype' value='$logintype'>\n";        
 127                  echo "<input type=\"hidden\" name ='login' value='$login'>\n";
 128                  echo "<input type=\"hidden\" name ='password2' value='$password2'>\n";
 129                  echo "<input type=\"hidden\" name ='password3' value='$password3'>\n";
 130                  echo"<input name='ok' type='submit'  value=' ".$language['retry']." ' size='20'>\n";
 131                  echo"</form>\n";
 132                  echo"</div>\n";
 133                  }
 134              }
 135          }
 136          
 137      }
 138  
 139  //form

 140  
 141  else
 142      {
 143          echo"<br><br><h2>".$language['user_site_creation']."</h2>\n";
 144          echo"<p>".$language['user_site_setup']."</p>\n";
 145          echo"<p>".$language['login_user_site_what']."</p>\n";
 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          //mysql requete

 153      
 154          $sqlsite = "SELECT * FROM crawlt_site";
 155  
 156      
 157          $requetesite = mysql_query($sqlsite, $connexion) or die("MySQL query error");
 158      
 159          $nbrresult=mysql_num_rows($requetesite);
 160      
 161          while ($ligne = mysql_fetch_object($requetesite))                                                                              
 162              {
 163              $sitename=$ligne->name; 
 164              $siteid=$ligne->id_site;
 165              $listsite[]=$sitename;
 166              $listidsite[]=$siteid;
 167              }
 168  
 169          //preparation of site list display

 170          $nbrsite=sizeof($listsite);
 171          $nbrsiteaf=0;
 172          
 173  
 174          
 175      echo"</div>\n";
 176  
 177      //data collect form

 178  
 179      echo"<div class=\"form\">\n";
 180      echo"<form action=\"index.php\" method=\"POST\" >\n";
 181      echo"<table class=\"centrer\">\n";
 182      echo"<tr><td>\n";
 183      echo"".$language['site_name']."";
 184      echo"<select  size=\"1\" name=\"site\"  style=\" font-size:14px; font-weight:bold; color: #003399;
 185      font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">\n";
 186      do
 187          {
 188          if($listidsite[$nbrsiteaf]==$site)
 189              {
 190              echo"<option value=\"$listidsite[$nbrsiteaf]\" selected style=\" font-size:14px; font-weight:bold; color: #003399;
 191              font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$listsite[$nbrsiteaf]."</option>\n";
 192              }
 193          else
 194              {
 195              echo"<option value=\"$listidsite[$nbrsiteaf]\" style=\" font-size:14px; font-weight:bold; color: #003399;
 196              font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$listsite[$nbrsiteaf]."</option>\n";
 197              }        
 198              $nbrsiteaf=$nbrsiteaf+1;
 199          }
 200      
 201      while($nbrsiteaf<$nbrsite);
 202  
 203      echo"</select>\n";        
 204          
 205      echo "<input type=\"hidden\" name ='validform' value=\"7\">";
 206      echo "<input type=\"hidden\" name ='navig' value='6'>\n";
 207      echo "<input type=\"hidden\" name ='validlogin' value='1'>\n";            
 208      echo "<input type=\"hidden\" name ='logintype' value='$logintype'>\n";    
 209      echo"<td></tr>\n";
 210      echo"<tr>\n";
 211      echo"<td>".$language['login']."</td>\n";
 212      echo"<td><input name='login'  value='$login' type='text' maxlength='20' size='50'/></td>\n";
 213      echo"</tr>\n";
 214      echo"<tr>\n";
 215      echo"<td>".$language['password']."</td>\n";
 216      echo"<td><input name='password2' value='$password2' type='password' size='50'/></td>\n";
 217      echo"</tr>\n";
 218      echo"<tr>\n";
 219      echo"<td colspan=\"2\">\n";
 220      echo"".    $language['valid_password']."\n";
 221      echo"</td>\n";
 222      echo"</tr>\n";
 223      echo"<tr>\n";
 224      echo"<td>".$language['password']."</td>\n";
 225      echo"<td><input name='password3' value='$password3' type='password' size='50'/></td>\n";
 226      echo"</tr>\n";    
 227      echo"<tr>\n";
 228      echo"<td colspan=\"2\">\n";
 229      echo"<br>\n";
 230      echo"<input name='ok' type='submit'  value=' OK ' size='20'>\n";
 231      echo"</td>\n";
 232      echo"</tr>\n";
 233      echo"</table>\n";
 234      echo"</form>\n";
 235      }
 236  
 237  ?>
Code source de Cr@wltr@ck 2.2.1

/include/ -> adminusersite.php (source)
