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

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

  15  
  16  if (!defined('IN_CRAWLT_INSTALL'))
  17  {
  18      echo"<h1>Hacking attempt !!!!</h1>";
  19      exit();
  20  }
  21  
  22  
  23  $sitenamedisplay=htmlentities($sitename);
  24  $siteurldisplay=htmlentities($siteurl);
  25  
  26  //valid form

  27  
  28  if($validsite==1 && $sitename=='')
  29      {
  30      echo"<p>".$language['site_no_ok']."</p>";
  31  
  32      
  33      $validsite=0;
  34      echo"<div class=\"form\">\n";
  35      echo"<form action=\"index.php\" method=\"POST\" >\n";
  36      echo "<input type=\"hidden\" name ='validform' value='4'>\n";
  37      echo "<input type=\"hidden\" name ='navig' value='15'>\n";
  38      echo "<input type=\"hidden\" name ='sitename' value='$sitenamedisplay'>\n";
  39      echo "<input type=\"hidden\" name ='siteurl' value='$siteurldisplay'>\n";    
  40      echo"<input name='ok' type='submit'  value=' ".$language['back_to_form']." ' size='20'>\n";
  41      echo"</form>\n";
  42      echo"</div>\n";
  43      }
  44  else
  45      {
  46  
  47  
  48      //database connection

  49  
  50      include "include/configconnect.php";
  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  
  55      if($validsite !=1)
  56          {
  57          //form to add site in the database

  58  
  59          echo"<p>".$language['set_up_site']."</p>\n";
  60          echo"</div>\n";
  61      
  62  
  63          echo"<div class=\"form\">\n";
  64          echo"<form action=\"index.php\" method=\"POST\" >\n";
  65          echo "<input type=\"hidden\" name ='navig' value='15'>\n";
  66          echo "<input type=\"hidden\" name ='validform' value=\"4\">";
  67          echo "<input type=\"hidden\" name ='validsite' value=\"1\">";
  68          echo"<table class=\"centrer\">\n";
  69          echo"<tr>\n";
  70          echo"<td>".$language['site_name']."</td>\n";
  71          echo"<td><input name='sitename'  value='$sitenamedisplay' type='text' maxlength='45' size='50'/></td>\n";
  72          echo"</tr>\n";
  73          echo"<tr>\n";
  74          echo"<td>".$language['site_url']."</td>\n";
  75          echo"<td><input name='siteurl'  value='$siteurldisplay' type='text' maxlength='250' size='50'/></td>\n";
  76          echo"</tr>\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      else
  87          {
  88          //add the site in the database

  89  
  90          //check if site already exist        

  91          
  92          $sqlexist = "SELECT * FROM crawlt_site
  93          WHERE name='".sql_quote($sitename)."'";
  94  
  95          $requeteexist = mysql_query($sqlexist, $connexion) or die("MySQL query error");
  96          
  97          $nbrresult=mysql_num_rows($requeteexist);
  98          
  99          if($nbrresult>=1)
 100              {
 101              //site already exist

 102              
 103              echo"<h1>".$language['exist_site']."</h1>\n";
 104              
 105              echo"<div class=\"form\">\n";
 106              echo"<form action=\"index.php\" method=\"POST\" >\n";
 107              echo "<input type=\"hidden\" name ='navig' value='15'>\n";
 108              echo "<input type=\"hidden\" name ='validform' value=\"4\">";
 109              echo "<input type=\"hidden\" name ='validsite' value=\"0\">";
 110              echo"<table class=\"centrer\">\n";    
 111              echo"<tr>\n";
 112              echo"<td colspan=\"2\">\n";
 113              echo"<br>\n";
 114              echo"<input name='ok' type='submit'  value=' ".$language['new_site']." ' size='20'>\n";
 115              echo"</td>\n";
 116              echo"</tr>\n";
 117              echo"</table>\n";
 118              echo"</form>\n";            
 119  
 120              //continue

 121              
 122              echo"<form action=\"index.php\" method=\"POST\" >\n";
 123              echo "<input type=\"hidden\" name ='navig' value='15'>\n";
 124              echo "<input type=\"hidden\" name ='validform' value=\"6\">";
 125              echo"<table class=\"centrer\">\n";    
 126              echo"<tr>\n";
 127              echo"<td colspan=\"2\">\n";
 128              echo"<input name='ok' type='submit'  value=' ".$language['step4_install']." ' size='20'>\n";
 129              echo"</td>\n";
 130              echo"</tr>\n";
 131              echo"</table>\n";
 132              echo"</form>\n";
 133              echo"</div>";            
 134                          
 135              }
 136          else
 137              {            
 138              //the site didn't exist, we can add it in the database            

 139              $sqlsite2="INSERT INTO crawlt_site (name, url) VALUES ('".sql_quote($sitename)."','".sql_quote($siteurl)."')";
 140              $requetesite2 = mysql_query($sqlsite2, $connexion) or die("MySQL query error");
 141              
 142              //emptied the cache table

 143              $sqlcache = "TRUNCATE TABLE crawlt_cache";
 144              $requetecache = mysql_query($sqlcache, $connexion) or die("MySQL query error");            
 145              
 146  
 147              //check is requete is successfull

 148  
 149              if($requetesite2==1)
 150                  {
 151                  echo"<p>".$language['site_ok']."</p>\n";
 152              
 153                  //add a new site

 154  
 155                  echo"<div class=\"form\">\n";
 156                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 157                  echo "<input type=\"hidden\" name ='navig' value='15'>\n";
 158                  echo "<input type=\"hidden\" name ='validform' value=\"4\">";
 159                  echo "<input type=\"hidden\" name ='validsite' value=\"0\">";
 160                  echo"<table class=\"centrer\">\n";    
 161                  echo"<tr>\n";
 162                  echo"<td colspan=\"2\">\n";
 163                  echo"<br>\n";
 164                  echo"<input name='ok' type='submit'  value=' ".$language['new_site']." ' size='20'>\n";
 165                  echo"</td>\n";
 166                  echo"</tr>\n";
 167                  echo"</table>\n";
 168                  echo"</form>\n";            
 169  
 170                  //continue

 171              
 172                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 173                  echo "<input type=\"hidden\" name ='navig' value='15'>\n";
 174                  echo "<input type=\"hidden\" name ='validform' value=\"6\">";
 175                  echo"<table class=\"centrer\">\n";    
 176                  echo"<tr>\n";
 177                  echo"<td colspan=\"2\">\n";
 178                  echo"<input name='ok' type='submit'  value=' ".$language['step4_install']." ' size='20'>\n";
 179                  echo"</td>\n";
 180                  echo"</tr>\n";
 181                  echo"</table>\n";
 182                  echo"</form>\n";
 183                  echo"</div>";
 184                  }
 185              }
 186          }
 187  
 188      }
 189  
 190  
 191  ?>