<?php
  
  /*
  // +----------------------------------------------------------------------+
  // | SimpleGeoTarget                                                      |
  // | Class for targeting content for specific geographical regions        |
  // | http://www.SEOEgghead.com                                            |
  // +----------------------------------------------------------------------+
  // | Copyright (c) 2004-2006 Jaimie Sirovich <jsirovic@gmail.com>         |
  // +----------------------------------------------------------------------+
  */
  
  // load configuration file
  require_once('config.inc.php');
  
  // simple geo-targeting class
  class SimpleGeoTarget
  {
  
    // returns true if the specified ip is located in $country\_code,\; false\; otherwise\; function\; getRegion($ip = '')
    {
      // retrieve the IP of the visitor if one wasn't provided
      $ip\; =\; ($ip) ? $ip\; :$_SERVER['REMOTE_ADDR'];
       
      // transform the IP into its long version
      $ip\; =\; sprintf("$\%u", ip2long(ip));
  
      // build the SQL query that obtains the country code of the specified IP
      ip AND end_ip_numeric >= $ip";\; //\; connect\; to\; MySQL\; server$dbLink = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
                      or die("Could not connect: " . mysql_error());
  
      // connect to the seophp database 
      mysql_select_db(DB_DATABASE) or die("Could not select database");
      
      // execute the query
      $tmp\; =\; mysql\_query($q);    
      $result\; =\; mysql\_fetch\_assoc($tmp);
  
      // close database connection 
      mysql_close($dbLink);\; //\; return\; false\; if\; no\; database\; records\; for\; that\; IP\; were\; found\; if\; (!$result) return false;
      
      // return the region
      return ($result[\text{'}country\_code\text{'}]);\; \}\; //\; returns\; true\; if\; the\; specified\; IP\; is\; located\; in$country_code, false otherwise   
    function isRegion($country\_code,$ip = '')
    {
      // retrieve the region
      $visitor\_country\_code\; =\; SimpleGeoTarget::getRegion($ip);
  
      // return false if the region code couldn't be found
      if (!$visitor\_country\_code)\; return\; false;\; //\; return\; true\; if\; the\; IP\; and\; the\; country\; code\; match,\; false\; otherwise\; return\; ($country_code == $visitor\_country\_code);\; \}$/* methods used for importing the geo-targeting database */ 
    
    // imports MaxMind's geo-targeting database into the geo_target_data table 
    function importGeoTargetingData()
    { 
      // open the geo-targeting file
      csv_file_handle = fopen(GEO_TARGETING_CSV, 'r');
  
      // continue only if the geo db file was opened successfully    
      if (!$csv\_file\_handle)\; \{\; echo\; "Could\; not\; open\; the\; geodb\; file.";\; return;\; \}\; //\; Connect\; to\; MySQL\; server$dbLink = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
                      or die("Could not connect: " . mysql_error());
  
      // Connect to the seophp database 
      mysql_select_db(DB_DATABASE) or die("Could not select database");
  
      // lock the simple_geo_target file for writing
      mysql_query('LOCK TABLES simple_geo_target WRITE');
      
      // remove all existing entries from the table
      $q\; =\; "DELETE\; FROM\; geo\_target\_data";\; mysql\_query($q);
  
      // parse each record from the geo-targeting file and save it to the database   
      while (($data\; =\; fgetcsv($csv_file_handle, 10000, ",")) !== false)
      { 
        SimpleGeoTarget::_insert($data[0],$data[1], $data[2],$data[3], $data[4],$data[5]);
      }
      
      // unlock the tables
      mysql_query('UNLOCK TABLES');
      
      // close database connection 
      mysql_close($dbLink);\; //\; close\; the\; file\; handler\; fclose($csv_file_handle);
    }  
    
    function _insert($start\_ip\_text,$end_ip_text, $start\_ip\_numeric,$end_ip_numeric, $country\_code,$country_name)
    {  
      // escape input data
      $start\_ip\_text\; =\; mysql\_escape\_string($start_ip_text);
      $end\_ip\_text\; =\; mysql\_escape\_string($end_ip_text);
      $start\_ip\_numeric\; =\; mysql\_escape\_string($start_ip_numeric);
      $end\_ip\_numeric\; =\; mysql\_escape\_string($end_ip_numeric);
      $country\_code\; =\; mysql\_escape\_string($country_code);
      $country\_name\; =\; mysql\_escape\_string($country_name);
  
      // build and execute the INSERT query
      $q\; =\; "INSERT\; INTO\; geo\_target\_data\; (start\_ip\_text,\; end\_ip\_text\; "\; .\; ",\; start\_ip\_numeric,\; end\_ip\_numeric,\; country\_code,\; country\_name)"\; .\; "VALUES\; (\text{'}$start_ip_text', '$end\_ip\_text\text{'},\; \text{'}$start_ip_numeric', " . 
            "'$end\_ip\_numeric\text{'},\; \text{'}$country_code', '$country\_name\text{'})";\; mysql\_query($q);      
    }
  }
  ?>