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

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

  15  //This product includes GeoLite data created by MaxMind, available from

  16  //http://maxmind.com/"

  17  //----------------------------------------------------------------------

  18  
  19  
  20  
  21  //crawlt_ip_data table creation

  22  
  23  //check if table already exist

  24  
  25  $table_exist8 = 0;
  26  
  27  $sql = "SHOW TABLES ";                                                
  28  $tables = mysql_query($sql, $connexion) or die("MySQL query error"); 
  29  
  30  while (list($tablename)=mysql_fetch_array($tables)) 
  31      {
  32  
  33      if($tablename == 'crawlt_ip_data')
  34          {
  35          $table_exist8 = 1;
  36          }
  37      }
  38  
  39  
  40  if($table_exist8 == 0)
  41      {
  42  
  43      //the table didn't exist, we can create it

  44  
  45      $result10 = mysql_query("CREATE TABLE crawlt_ip_data (
  46      ip_from INTEGER UNSIGNED NOT NULL,
  47      ip_to INTEGER UNSIGNED NOT NULL,
  48      country_code CHAR(2) NULL,
  49      PRIMARY KEY(ip_from, ip_to)
  50      )") or die("MySQL query error");
  51      }
  52  else
  53      {
  54      $result10=1;
  55      }
  56  
  57  if($result10==1)
  58      {
  59      
  60          //check if table is already filled

  61  
  62      $nbr=0;
  63      $resultat2=mysql_query("SELECT ip_from FROM crawlt_ip_data") or die("MySQL query error");
  64      $nbr2 = mysql_num_rows($resultat2);
  65  
  66      if($nbr2<100)
  67          {
  68          
  69          //we can insert the data

  70      
  71          include "./include/requeteip01.php";
  72          include "./include/requeteip02.php";
  73          include "./include/requeteip03.php";
  74          include "./include/requeteip04.php";
  75          include "./include/requeteip05.php";
  76          include "./include/requeteip06.php";
  77          include "./include/requeteip07.php";
  78          include "./include/requeteip08.php";
  79          include "./include/requeteip09.php";
  80          include "./include/requeteip10.php";
  81      
  82      
  83          if($result111==1 && $result112==1 && $result113==1 && $result114==1 && $result115==1 && $result116==1 && $result117==1 && $result118==1 && $result119==1)
  84              {
  85              $result11=1;
  86              }
  87  
  88          }
  89      else
  90          {
  91          $result11=1;
  92          }
  93              
  94      }    
  95  ?>