<?php
  
  /*
  // +----------------------------------------------------------------------+
  // | SimpleCloak                                                          |
  // | Class for cloaking content                                           |
  // | http://www.SEOEgghead.com                                            |
  // +----------------------------------------------------------------------+
  // | Copyright (c) 2005-2006 Jaimie Sirovich and Cristian Darie           |
  // +----------------------------------------------------------------------+
  */
  
  // load configuration file
  require_once('config.inc.php');
  
  class SimpleCloak
  {  
    // returns the confidence level
    function isSpider($spider\_name\; =\; \text{'}\text{'},$check_uas = true, $check\_ips\; =\; true)\; \{\; //\; default\; confidence\; level\; to\; 0$confidence = 0;
      
      // matching user agent?    
      if ($check\_uas)\; if\; (SimpleCloak::\_get(0,$spider_name, 'UA', $\_SERVER[\text{'}HTTP\_USER\_AGENT\text{'}]))$confidence += 2;
    
      // matching IP?    
      if ($check\_ips)\; if\; (SimpleCloak::\_get(0,$spider_name, 'IP', '', $\_SERVER[\text{'}REMOTE\_ADDR\text{'}]))$confidence += 3;     
      
      // return confidence level
      return $confidence;\; \}\; //\; retrieve\; cloaking\; data\; filtered\; by\; the\; supplied\; parameters\; function\; \_get($id = 0, $spider\_name\; =\; \text{'}\text{'},$record_type = '', 
                 $value\; =\; \text{'}\text{'},$wildcard_value = '')
    {
      // by default, retrieve all records
      $q\; =\; "\; SELECT\; cloak\_data.*\; FROM\; cloak\_data\; WHERE\; TRUE\; ";\; //\; add\; filters\; if\; ($id) {
        $id\; =\; (int)$id;
        $q\; .=\; "\; AND\; id\; =$id ";
      }     
      if ($spider\_name)\; \{$spider_name = mysql_escape_string($spider\_name);$q .= " AND spider_name = '$spider\_name\text{'}\; ";\; \}\; if\; ($record_type) {            
        $record\_type\; =\; mysql\_escape\_string($record_type);
        $q\; .=\; "\; AND\; record\_type\; =\; \text{'}$record_type' ";
      }      
      if ($value)\; \{$value = mysql_escape_string($value);$q .= " AND value = '$value\text{'}\; ";\; \}\; if\; ($wildcard_value) {
        $wildcard\_value\; =\; mysql\_escape\_string($wildcard_value);
        $q\; .=\; "\; AND\; \text{'}$wildcard_value' LIKE CONCAT(value, '%') ";
      }
      
      // 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);\; //\; close\; database\; connection\; mysql\_close($dbLink);       
        
      // return the results as an associative array
      $rows\; =\; array();\; while\; ($_x = mysql_fetch_assoc($tmp))\; \{$rows[] = $\_x;\; \}\; return$rows;
    }  
    
    // updates the entire database with fresh spider data, but only if our data is
    // more than 7 days old, and if the online version from iplists.org has changed
    function updateAll()
    {      
      // 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");\; //\; retrieve\; last\; update\; information\; from\; database$q = "SELECT cloak_update.* FROM cloak_update";
      $tmp\; =\; mysql\_query($q);
      $updated\; =\; mysql\_fetch\_assoc($tmp);    
      $db\_version\; =$updated['version']; 
      $updated\_on\; =$updated ['updated_on'];
   
      // get the latest update more recent than 7 days, don't attempt an update    
      if (isset(updated_on) > strtotime("-604800 seconds"))) 
      {
        // close database connection 
        mysql_close($dbLink);\; //\; return\; false\; to\; indicate\; an\; update\; wasn\text{'}t\; performed\; return\; false;\; \}\; //\; read\; the\; latest\; iplists\; version$version_url = 'http://www.iplists.com/nw/version.php';
      $latest\_version\; =\; mysql\_escape\_string(file\_get\_contents($version_url));
  
      // if no updated version information was retrieved, abort
      if (!$latest\_version)\; \{\; //\; return\; false\; to\; indicate\; an\; update\; wasn\text{'}t\; performed\; return\; false;\; \}\; //\; save\; the\; update\; data$q = "DELETE FROM cloak_update";
      mysql_query($q);$q = "INSERT INTO cloak_update (version, updated_on) " . 
           "VALUES('$latest\_version\text{'},\; NOW())";\; mysql\_query($q);
      
      // if we already have the current data, don't attempt an update 
      if ($latest\_version\; ==$db_version) 
      {
        // close database connection 
        mysql_close($dbLink);\; //\; return\; false\; to\; indicate\; an\; update\; wasn\text{'}t\; performed\; return\; false;\; \}\; //\; update\; the\; database\; SimpleCloak::\_updateCloakingDB(\text{'}google\text{'},\; \text{'}http://www.iplists.com/nw/google.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}yahoo\text{'},\; \text{'}http://www.iplists.com/nw/inktomi.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}msn\text{'},\; \text{'}http://www.iplists.com/nw/msn.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}ask\text{'},\; \text{'}http://www.iplists.com/nw/askjeeves.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}altavista\text{'},\; \text{'}http://www.iplists.com/nw/altavista.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}lycos\text{'},\; \text{'}http://www.iplists.com/nw/lycos.txt\text{'});SimpleCloak::\_updateCloakingDB(\text{'}wisenut\text{'},\; \text{'}http://www.iplists.com/nw/wisenut.txt\text{'});//\; close\; connection\; mysql\_close($dbLink);
  
      // return true to indicate a successful update
      return true;
    }
    
    // update the database for the mentioned spider, by reading the provided URL
    function _updateCloakingDB($spider\_name,$url, 
        $ua\_regex\; =\; \text{'}/^\#\; UA\; "(.*)"$/m', $ip\_regex\; =\; \text{'}/^([0-9.]+)$/m')
    {
      // use cURL to read the data from $url\; //\; NOTE:\; additional\; settings\; are\; required\; when\; accessing\; the\; web\; through\; a\; proxy$ch = curl_init();    
      curl_setopt ($ch,\; CURLOPT\_URL,$url);
      curl_setopt ($ch,\; CURLOPT\_HEADER,\; 1);\; curl\_setopt\; ($ch, CURLOPT_RETURNTRANSFER, 1);
      curl_setopt ($ch,\; CURLOPT\_FOLLOWLOCATION,\; 1);\; curl\_setopt\; ($ch, CURLOPT_TIMEOUT, 60);
      $result\; =\; curl\_exec($ch);
      curl_close($ch);\; //\; use\; \_parseListURL\; to\; parse\; the\; list\; of\; IPs\; and\; user\; agents$lists = SimpleCloak::_parseListURL($result,$ua_regex, $ip\_regex);\; //\; if\; the\; user\; agents\; and\; IPs\; weren\text{'}t\; retrieved,\; we\; cancel\; the\; update\; if\; (!$lists['ua_list'] || !$lists[\text{'}ip\_list\text{'}])\; return;\; //\; lock\; the\; cloack\_data\; table\; to\; avoid\; concurrency\; problems\; mysql\_query(\text{'}LOCK\; TABLES\; cloak\_data\; WRITE\text{'});\; //\; delete\; all\; the\; existing\; data\; for$spider_name
      SimpleCloak::_deleteSpiderData($spider\_name);\; //\; insert\; the\; list\; of\; user\; agents\; for\; the\; spider\; foreach\; ($lists['ua_list'] as $ua)\; \{\; SimpleCloak::\_insertSpiderData($spider_name, 'UA', $ua);\; \}\; //\; insert\; the\; list\; of\; IPs\; for\; the\; spider\; foreach\; ($lists['ip_list'] as $ip)\; \{\; SimpleCloak::\_insertSpiderData($spider_name, 'IP', $ip);\; \}\; //\; release\; the\; table\; lock\; mysql\_query(\text{'}UNLOCK\; TABLES\text{'});\; \}\; //\; helper\; function\; used\; to\; parse\; lists\; of\; user\; agents\; and\; IPs\; function\; \_parseListURL($data, $ua\_regex,$ip_regex)
    {
      $ua\_list\_ret\; =\; preg\_match\_all($ua_regex, $data,$ua_list);
      $ip\_list\_ret\; =\; preg\_match\_all($ip_regex, $data,$ip_list);
      return array('ua_list' => $ua\_list[1],\; \text{'}ip\_list\text{'}\; =>$ip_list[1]);  
    }
  
    // inserts a new row of data to the cloaking table
    function _insertSpiderData($spider\_name,$record_type, $value)\; \{\; //\; escape\; input\; data$spider_name = mysql_escape_string($spider\_name);$record_type = mysql_escape_string($record\_type);$value = mysql_escape_string($value);\; //\; build\; and\; execute\; the\; INSERT\; query$q  = "INSERT INTO cloak_data (spider_name, record_type, value) " . 
            "VALUES ('$spider\_name\text{'},\; \text{'}$record_type', '$value\text{'})";\; mysql\_query($q);            
    }
    
    // delete the cloaking data for the mentioned spider
    function _deleteSpiderData($spider\_name)\; \{\; //\; escape\; input\; data$spider_name = mysql_escape_string($spider\_name);\; //\; build\; and\; execute\; the\; DELETE\; query$q = "DELETE FROM cloak_data WHERE spider_name='$spider\_name\text{'}";\; mysql\_query($q);  
    }
  }
  ?>