[ Closed ] Extension Stopforumspam Query Beta Working! (Page 1 of 2)

$url = 'http://www.stopforumspam.com/api?ip='.get_remote_address();

if(ini_get('allow_url_fopen') == 1) {

    $urlchecker = file_get_contents($url);
    if (strpos($urlchecker, 'yes')) {
        die($lang_common['No permission']); //got ya!
    }
    
} elseif(extension_loaded('curl')) {

    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_HEADER, FALSE);
    curl_setopt($curl, CURLOPT_TIMEOUT, 20);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    $result = curl_exec($curl);
    $ok = curl_errno($curl) === 0 && curl_getinfo($curl, CURLINFO_HTTP_CODE) === 200;
    
    if(!$ok) {
        //something gone wrong
    } else {
        if (strpos($result, 'yes')) {
            die($lang_common['No permission']); //got ya!
        }
    }
    
    curl_close ($curl);

} else {
    //You are doomed! I suggest contacting your hosting support for allowing_url_fopen or enabling curl :-)
}

curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

if (strpos($urlchecker, 'yes')) {
   $bot = array();
   $bot["ip"] = get_remote_address();
   preg_match_all('/<type>(.*?)<\/type>/', $urlchecker, $matches);
   $bot["type"] = $matches[1][0];
   preg_match_all('/<lastseen>(.*?)<\/lastseen>/', $urlchecker, $matches);
   $bot["lastseen"] = $matches[1][0];
   preg_match_all('/<frequency>(.*?)<\/frequency>/', $urlchecker, $matches);
   $bot["frequency"] = $matches[1][0];

   //store into db


   
   die("No permission"); //got ya!
}

// This function returns true if a spambot is found in the cache database.
// It first purges old records
function sfsCacheHit ($data, $field) {
    global $vbulletin, $sfsPurged, $sfsCacheHit;
    
    $sfsCacheHit = false;
    
    if (!$sfsPurged) {
            // purge cache database of old records
            $sql = "DELETE FROM " . TABLE_PREFIX . "vbstopforumspam_remotecache WHERE date < DATE_SUB(NOW(), INTERVAL " . (int)$vbulletin->options['vbstopforumspam_remote_cache'] . " MINUTE);";
            $vbulletin->db->query($sql);
            $sfsPurged = true;
    }
        
    // get rows from database that contain the data (cache hit)
    $sql = "SELECT spambot FROM " . TABLE_PREFIX . "vbstopforumspam_remotecache WHERE field = '$field' AND data = '" . addslashes($data) . "' LIMIT 1 ;";
    $result = $vbulletin->db->query($sql);

    $line = $vbulletin->db->fetch_array($result);
  if (!empty($line)) {            
        $sfsCacheHit = true;
      
          // if we have data in the results, check if we have a spam hit
          if ($line['spambot'] > 0) return VBSFS_FAIL;
          if ($line['spambot'] == 0) return VBSFS_HIT_BUT_PASS;
          // return VBSFS_FAIL if we have a spam hit or all return 2 if we have a hit but its not a spambot              
  }  
    return VBSFS_PASS;
}

// This function returns true if a spambot is found in the cache database.
// It first purges old records
function sfsCacheHit ($data, $field) {
    global $vbulletin, $sfsPurged, $sfsCacheHit;
    
    $sfsCacheHit = false;
    
    if (!$sfsPurged) {
            // purge cache database of old records
            $sql = "DELETE FROM " . TABLE_PREFIX . "vbstopforumspam_remotecache WHERE date < DATE_SUB(NOW(), INTERVAL " . (int)$vbulletin->options['vbstopforumspam_remote_cache'] . " MINUTE);";
            $vbulletin->db->query($sql);
            $sfsPurged = true;
    }
        
    // get rows from database that contain the data (cache hit)
    $sql = "SELECT spambot FROM " . TABLE_PREFIX . "vbstopforumspam_remotecache WHERE field = '$field' AND data = '" . addslashes($data) . "' LIMIT 1 ;";
    $result = $vbulletin->db->query($sql);

    $line = $vbulletin->db->fetch_array($result);
  if (!empty($line)) {            
        $sfsCacheHit = true;
      
          // if we have data in the results, check if we have a spam hit
          if ($line['spambot'] > 0) return VBSFS_FAIL;
          if ($line['spambot'] == 0) return VBSFS_HIT_BUT_PASS;
          // return VBSFS_FAIL if we have a spam hit or all return 2 if we have a hit but its not a spambot              
  }  
    return VBSFS_PASS;
}

<?php
        if (!$forum_db->table_exists('sfs'))
        {
            $schema = array(
                'FIELDS'        => array(
                    'ip'    => array(
                        'datatype'        => 'VARCHAR(39)',
                        'allow_null'    => false,
                        'default'        => '\'0.0.0.0\''
                    ),
                    'appears'        => array(
                        'datatype'        => 'INT(10) UNSIGNED',
                        'allow_null'    => false,
                        'default'        => '0'
                    ),
                    'last_seen'        => array(
                        'datatype'        => 'INT(10) UNSIGNED',
                        'allow_null'    => false,
                        'default'        => '0'
                    ),
                    'frequency'        => array(
                        'datatype'        => 'INT(10) UNSIGNED',
                        'allow_null'    => false,
                        'default'        => '0'
                    ),
                    
            );

            $forum_db->create_table('sfs', $schema);
        }

    $insert_query = array(
        'INSERT'    =>    'ip, appears, last_seen , frequency',
        'INTO'        =>    'sfs',
        'VALUES'      =>   
?>

    <![CDATA[
        $schema = array(
            'FIELDS'    =>    array(
                'ip'            => array(
                    'datatype'        =>    'VARCHAR(15)',
                    'allow_null'    =>    false,
                    'default'        =>    '\'0.0.0.0\''
                ),
                'lastseen'        => array(
                    'datatype'        => 'DATETIME',
                    'allow_null'    => false,
                    'default'        => '0'
                ),
                'frequency'        => array(
                    'datatype'        => 'SMALLINT UNSIGNED',
                    'allow_null'    => false,
                    'default'        => '0'
                )
            ),
            'PRIMARY KEY'        =>    array('ip')
        );
        $forum_db->create_table('stopforumspam', $schema);
      ]]>
    </install>
    
    <uninstall>
        <![CDATA[
            $forum_db->drop_table('stopforumspam');
        ]]>
    </uninstall>

    <hooks>
        <hook id="rg_start"><![CDATA[

                $register_head['sfs'] = '<script type="text/php" src="'.$ext_info['url'].'/sfs.php"></script>';

          $query = array(
            'SELECT'   => 'ip',
            'FROM'     => 'stopforumspam',
            'WHERE'    => 'ip='.get_remote_address(),
            'LIMIT'    => '1'
          );
          $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
          if($forum_db->num_rows($result) > 0) {
            //die('You are spammer')
          } else {
              //Request to to SFS.com
                  //Insert to db
          }
          
          $query = array(
            'INSERT'   => 'ip, last_seen, frequency',
            'INTO'     => 'stopforumspam',
            'VALUES'   => '\''.$bot["ip"].'\', \''.$bot["lastseen"].'\', \''.$bot["frequency"].'\''
          );
            $forum_db->query_build($query) or error(__FILE__, __LINE__);
        
    ]]></hook>

217.23.10.108      2010-07-20 01:23:02      2010-07-19 19:14:36      33
91.212.226.240     2010-07-20 01:59:24     2010-07-19 18:08:58     1782
91.212.226.210     2010-07-20 02:43:02     2010-07-19 18:32:46     2522
217.21.115.189     2010-07-20 04:13:06     2010-06-29 05:48:40     36
195.191.40.104     2010-07-20 08:28:09     2010-07-20 00:00:17     73