class FILTER {
function startFilter($click_id, $ip_id, $ip_address, $user_id) {
//we only do the other checks, if the first ones have failed.
//we will return the variable filter, if the $filter returns TRUE, when the click is inserted and recorded we will insert the new click already inserted,
//what was lagign this query is before it would insert a click, then scan it and then update the click, the updating later on was lagging, now we will just insert and it will not stop the clicks from being redirected becuase of a slow update.
//check the user
$filter = FILTER::checkUserIP($click_id, $ip_id, $user_id);
if ($filter == false) {
//check the netrange
$filter = FILTER::checkNetrange($click_id, $ip_address);
if ($filter == false) {
$filter = FILTER::checkLastIps($user_id, $ip_id);
/*
//check the configurations
$filter = FILTER::checkIPTiming($click_id, $ip_id, $user_id, $click_time, 1, 150); if ($filter == false) {
$filter = FILTER::checkIPTiming($click_id, $ip_id, $user_id, $click_time, 20, 3600); if ($filter == false) {
$filter = FILTER::checkIPTiming($click_id, $ip_id, $user_id, $click_time, 50, 86400); if ($filter == false) {
$filter = FILTER::checkIPTiming($click_id, $ip_id, $user_id, $click_time, 100, 2629743); if ($filter == false) {
$filter = FILTER::checkIPTiming($click_id, $ip_id, $user_id, $click_time, 1000, 7889231); if ($filter == false) {
}}}}}
*/
}
}
if ($filter == true) {
return 1;
} else {
return 0;
}
}
function checkUserIP($click_id, $ip_id, $user_id) {
$mysql['ip_id'] = mysql_real_escape_string($ip_id);
$mysql['user_id'] = mysql_real_escape_string($user_id);
$count_sql = "SELECT COUNT(*)
FROM 202_users
WHERE user_id='".$mysql['user_id']."'
AND user_last_login_ip_id='".$mysql['ip_id']."'";
$count_result = _mysql_query($count_sql) ; //($count_sql);
//if the click_id's ip address, is the same ip adddress of the click_id's owner's last logged in ip, filter this. This means if the ip hit on the page was the same as the owner of the click affiliate program, we want to filter out the clicks by the owner when he/she is trying to test
if (mysql_result($count_result,0,0) > 0) {
return true;
}
return false;
}
function checkNetrange($click_id, $ip_address) {
$ip_address = ip2long($ip_address);
//check each netrange
/*google1 */ if (($ip_address >= 1208926208) and ($ip_address <= 1208942591)) { return true; }
/*MSN */ if (($ip_address >= 1093926912) and ($ip_address <= 1094189055)) { return true; }
/*google2 */ if (($ip_address >= 3512041472) and ($ip_address <= 3512074239)) { return true; }
/*Yahoo */ if (($ip_address >= 3640418304) and ($ip_address <= 3640426495)) { return true; }
/*google3 */ if (($ip_address >= 1123631104) and ($ip_address <= 1123639295)) { return true; }
/*level 3 communications */ if (($ip_address >= 1094189056) and ($ip_address <= 1094451199)) { return true; }
/*yahoo2 */ if (($ip_address >= 3515031552) and ($ip_address <= 3515039743)) { return true; }
/*Yahoo3 */ if (($ip_address >= 3633393664) and ($ip_address <= 3633397759)) { return true; }
/*Google5 */ if (($ip_address >= 1089052672) and ($ip_address <= 1089060863)) { return true; }
/*Yahoo */ if (($ip_address >= 1209925632) and ($ip_address <= 1209991167)) { return true; }
/*Yahoo */ if (($ip_address >= 1241907200) and ($ip_address <= 1241972735)) { return true; }
/*Performance Systems International Inc. */ if (($ip_address >= 637534208) and ($ip_address <= 654311423)) { return true; }
/*Microsoft */ if (($ip_address >= 3475898368) and ($ip_address <= 3475963903)) { return true; }
/*googleNew */ if (($ip_address >= -782925824) and ($ip_address <= -782893057)) { return true; }
//if it was none of theses, return false
return false;
}
//this will filter out a click if it the IP WAS RECORDED, for a particular user within the last 24 hours, if it existed before, filter out this click.
function checkLastIps($user_id, $ip_id) {
$mysql['user_id'] = mysql_real_escape_string($user_id);
$mysql['ip_id'] = mysql_real_escape_string($ip_id);
$check_sql = "SELECT COUNT(*) AS count FROM 202_last_ips WHERE user_id='".$mysql['user_id']."' AND ip_id='".$mysql['ip_id']."'";
$check_result = _mysql_query($check_sql) ; //($check_sql);
$check_row = mysql_fetch_assoc($check_result);
$count = $check_row['count'];
if ($count > 0) {
//if this ip has been seen within the last 24 hours, filter it out.
return true;
} else {
//else if this ip has not been recorded, record it now
$mysql['time'] = time();
$insert_sql = "INSERT INTO 202_last_ips SET user_id='".$mysql['user_id']."', ip_id='".$mysql['ip_id']."', time='".$mysql['time']."'";
$insert_result = _mysql_query($insert_sql) ; //($insert_sql);
return false;
}
}
