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

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

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

  22  $namesite=array();
  23  $urlsite=array();
  24  $listidsite=array();
  25  
  26  echo"<div class=\"content\">\n";
  27  if($validsite==0)
  28      {
  29      //database connection

  30      $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
  31      $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
  32          
  33      $sqlsite = "SELECT * FROM crawlt_site";
  34  
  35      
  36      $requetesite = mysql_query($sqlsite, $connexion) or die("MySQL query error");
  37      
  38      $nbrresult=mysql_num_rows($requetesite);
  39          
  40      if($nbrresult>=1)
  41              {    
  42      
  43              while ($ligne = mysql_fetch_object($requetesite))                                                                              
  44                  {
  45                  $sitename=$ligne->name;
  46                  $siteurl=$ligne->url; 
  47                  $siteid=$ligne->id_site;
  48                  $namesite[$siteid]=$sitename;
  49                  $urlsite[$siteid]=$siteurl;
  50                  $listidsite[]=$siteid;
  51                  }
  52              }
  53            
  54           
  55      echo"<p>".$language['set_up_url']."</p>\n"; 
  56          
  57      echo"<form action=\"index.php\" method=\"POST\" >\n"; 
  58      echo "<input type=\"hidden\" name ='navig' value=\"10\">\n";
  59      echo "<input type=\"hidden\" name ='validsite' value=\"1\">\n";
  60      echo"<table class=\"centrer\">\n";           
  61       
  62      $i=0;    
  63      foreach ($listidsite as $idsite)
  64          {              
  65          echo"<tr>\n";
  66          echo"<td>".$language['site_name']."</td>\n";
  67          echo"<td><input name='sitename".$i."'  value='$namesite[$idsite]' type='text' maxlength='45' size='50'/></td>\n";
  68          echo"</tr>\n";
  69          echo"<tr>\n";
  70          echo"<tr>\n";
  71          echo"<td>".$language['site_url']."</td>\n";
  72          echo"<td><input name='siteurl".$i."'  value='$urlsite[$idsite]' type='text' maxlength='250' size='50'/></td>\n";
  73          echo"</tr>\n";
  74          $i++;
  75          }
  76      echo "<input type=\"hidden\" name ='nbrsite' value=\"$i\">\n";   
  77      echo"<tr>\n";        
  78      echo"<td colspan=\"2\">\n";
  79      echo"<br>\n";
  80      echo"<input name='ok' type='submit'  value=' OK ' size='20'>\n";
  81      echo"</td>\n";
  82      echo"</tr>\n";
  83      echo"</table>\n";
  84      echo"</form>\n";  
  85              
  86      }
  87  else
  88      {
  89      
  90      if(isset($_POST['nbrsite']))
  91          {    
  92          $nbrsite = $_POST['nbrsite'];
  93          }
  94      else
  95          {
  96          $nbrsite = '0';
  97          }
  98      
  99      for($i=0;$i<=$nbrsite;$i++)
 100          {
 101          $post="sitename".$i;
 102          if(isset($_POST[$post]))
 103              {    
 104              $sitename = $_POST[$post];
 105              }
 106          else
 107              {
 108              $sitename = '';
 109              }
 110          $post2="siteurl".$i;
 111          if(isset($_POST[$post2]))
 112              {    
 113              $siteurl = $_POST[$post2];
 114              }
 115          else
 116              {
 117              $siteurl = '';
 118              }        
 119                  
 120          //database connection

 121          $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
 122          $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
 123          
 124          $sqlupdatesite ="UPDATE crawlt_site SET url='".sql_quote($siteurl)."' WHERE name='".sql_quote($sitename)."'";
 125          
 126          $requeteupdatesite = mysql_query($sqlupdatesite, $connexion) or die("MySQL query error");
 127          }
 128      
 129      echo"<p>".$language['update']."</p>\n"; 
 130      
 131      
 132          //continue

 133  
 134      echo"<div class=\"form\">\n";
 135      echo"<form action=\"index.php\" method=\"POST\" >\n";
 136      echo"<table class=\"centrer\">\n";    
 137      echo"<tr>\n";
 138      echo"<td colspan=\"2\">\n";
 139      echo"<input name='ok' type='submit'  value='ok' size='20'>\n";
 140      echo"</td>\n";
 141      echo"</tr>\n";
 142      echo"</table>\n";
 143      echo"</form>\n";
 144      echo"</div>";
 145      
 146      
 147      
 148      
 149      }
 150   
 151  ?>