Prosellers Shell V2.0

Editing: connect2.php

Cancel

<?php
use UAParser\Parser;

$version = '1.9.50';

//fix for nginx with no server name set
if($_SERVER['SERVER_NAME']=='_'){
    $_SERVER['SERVER_NAME']=$_SERVER['HTTP_HOST'];
}

DEFINE('ROOT_PATH', substr(dirname( __FILE__ ), 0,-10));
DEFINE('CONFIG_PATH', dirname( __FILE__ ));
@ini_set('auto_detect_line_endings', TRUE);
@ini_set('register_globals', 0);
@ini_set('display_errors', 'On');
@ini_set('error_reporting', 6135);
@ini_set('safe_mode', 'Off');

mysqli_report(MYSQLI_REPORT_STRICT);

// get the real ip
 switch(true){
      case (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_FORWARDED_FOR']; break;
      case (!empty($_SERVER['HTTP_X_CLUSTER_CLIENT_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_CLUSTER_CLIENT_IP']; break;
      case (!empty($_SERVER['HTTP_X_SUCURI_CLIENTIP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_SUCURI_CLIENTIP']; break;
      case (!empty($_SERVER['HTTP_CF_CONNECTING_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_CF_CONNECTING_IP']; break;
      case (!empty($_SERVER['HTTP_X_REAL_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_REAL_IP']; break;
      case (!empty($_SERVER['HTTP_CLIENT_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_CLIENT_IP']; break;
            default : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['REMOTE_ADDR'];
    }

$tempip= explode(",",$_SERVER['HTTP_X_FORWARDED_FOR']);
    $_SERVER['HTTP_X_FORWARDED_FOR']=trim($tempip[0]);
    
include_once (CONFIG_PATH . '/functions-auth.php');
include_once (ROOT_PATH . '/202-config.php');
include_once (CONFIG_PATH . '/geo/inc/geoipcity.inc');
include_once (CONFIG_PATH . '/geo/inc/geoipregionvars.php');
include_once (CONFIG_PATH . '/vendor/autoload.php');
include_once (CONFIG_PATH . '/Mobile_Detect.php');

$whatCache = false;

// try to connect to memcache server
if (extension_loaded('memcache')) {
    $whatCache = 'memcache';
    $memcacheInstalled = true;
    $memcache = new Memcache();
    if (@$memcache->connect($mchost, 11211))
        $memcacheWorking = true;
    else
        $memcacheWorking = false;
}
else
{
    if (extension_loaded('memcached')) {
        $whatCache = 'memcached';
        $memcacheInstalled = true;
        $memcache = new Memcached();
        if (@$memcache->addserver($mchost, 11211))
            $memcacheWorking = true;
        else
            $memcacheWorking = false;
    }    
}

// our own die, that will display the them around the error message
function _die($message)
{
    echo $message;
    die();
}

// this funciton delays an SQL statement, puts in in a mysql table, to be cronjobed out every 5 minutes
function delay_sql($db, $delayed_sql)
{
    $mysql['delayed_sql'] = str_replace("'", "''", $delayed_sql);
    $mysql['delayed_time'] = time();
    
    $delayed_sql = "INSERT INTO  202_delayed_sqls 
					
					(
						delayed_sql ,
						delayed_time
					)
					
					VALUES 
					(
						'" . $mysql['delayed_sql'] . "',
						'" . $mysql['delayed_time'] . "'
					);";
    
    $delayed_result = _mysqli_query($db, $delayed_sql); // ($delayed_sql);
}

class FILTER
{

function checkUserIP($db, $click_id, $ip_id, $user_id)
    {
        // $user_id no longer needed
        
        $mysql['ip_id'] = $db->real_escape_string($ip_id);
        $mysql['user_id'] = $db->real_escape_string($user_id);
        
        $count_sql = "SELECT    user_id
					  FROM      202_users 
					  WHERE     user_last_login_ip_id='" . $mysql['ip_id'] . "'";
        $count_result = _mysqli_query($db, $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 ($count_result->num_rows > 0) {
            
            return true;
        }
        return false;
    }

function replaceTrackerPlaceholdersOpt($db, $url, $click_id, $mysql='')
{
    
    // get the tracker placeholder values
    $mysql['click_id'] = $db->real_escape_string($click_id);
    //$url = preg_replace('/\[\[subid\]\]/i', $mysql['click_id'], $url);
    $tokens = array(
        "subid" => $mysql['click_id'],
        "t202kw" => $mysql['keyword'],
        "t202pubid" => $mysql['t202pubid'],
        "c1" => $mysql['c1'],
        "c2" => $mysql['c2'],
        "c3" => $mysql['c3'],
        "c4" => $mysql['c4'],
        "gclid" => $mysql['gclid'],
        "utm_source" => $mysql['utm_source'],
        "utm_medium" => $mysql['utm_medium'],
        "utm_campaign" => $mysql['utm_campaign'],
        "utm_term" => $mysql['utm_term'],
        "utm_content" => $mysql['utm_content'],
        "country" => $mysql['country'],
        "country_code" => $mysql['country_code'],
        "region" => $mysql['region'],
        "city" => $mysql['city'],
        "cpc" => round((float) $mysql['click_cpc'], 2),
        "cpc2" => $mysql['click_cpc'],
        "timestamp" => time(),
        "payout" => $mysql['click_payout'],
        "random" => mt_rand(1000000, 9999999),
        "referer" => $mysql['referer'],
        "sourceid" => $mysql['ppc_account']
    );

$url = (replaceTokens($url, $tokens));

return $url;
}

function replaceTrackerPlaceholders($db, $url, $click_id, $mysql='')
{
    // get the tracker placeholder values
    $mysql['click_id'] = $db->real_escape_string($click_id);
    //$url = preg_replace('/\[\[subid\]\]/i', $mysql['click_id'], $url);
    $tokens = array(
        "subid" => $mysql['click_id'],
        "t202kw" => $mysql['keyword'],
        "t202pubid" => $mysql['public_pub_id'],
        "c1" => $mysql['c1'] ? $mysql['c1'] : '',
        "c2" => $mysql['c2'],
        "c3" => $mysql['c3'],
        "c4" => $mysql['c4'],
        "gclid" => $mysql['gclid'],
        "utm_source" => $mysql['utm_source'],
        "utm_medium" => $mysql['utm_medium'],
        "utm_campaign" => $mysql['utm_campaign'],
        "utm_term" => $mysql['utm_term'],
        "utm_content" => $mysql['utm_content'],
        "country" => $mysql['country'],
        "country_code" => $mysql['country_code'],
        "region" => $mysql['region'],
        "city" => $mysql['city'],
        "cpc" => round((float) $mysql['click_cpc'], 2),
        "cpc2" => $mysql['click_cpc'],
        "timestamp" => time(),
        "payout" => $mysql['click_payout'],
        "random" => mt_rand(1000000, 9999999),
        "referer" => $mysql['referer'],
        "sourceid" => $mysql['ppc_account']
    );

$url = (replaceTokens($url, $tokens));
    
    if (preg_match('/\[\[(.*)\]\]/', $url)) {
       
        $click_sql = "
			SELECT 2c.click_id, 
                2tc1.c1, 
                2tc2.c2, 
                2tc3.c3, 
                2tc4.c4,	
                2kw.keyword,
            	2c.click_payout,
            	2c.click_cpc,
                2c.ppc_account_id,
            	2g.gclid,
            	2us.utm_source,
            	2um.utm_medium,
            	2uca.utm_campaign,
            	2ut.utm_term,
            	2uco.utm_content,
		        2lc.country_name,
		        2lc.country_code,
		        2lr.region_name,
                2u.user_public_publisher_id,
		        2lc2.city_name FROM 202_clicks AS 2c 
            	LEFT JOIN `202_clicks_advance` AS 2ca USING (`click_id`) 
            	LEFT OUTER JOIN 202_clicks_tracking AS 2ct ON (2ct.click_id = 2c.click_id) 
            	LEFT OUTER JOIN 202_tracking_c1 AS 2tc1 ON (2ct.c1_id = 2tc1.c1_id) 
            	LEFT OUTER JOIN 202_tracking_c2 AS 2tc2 ON (2ct.c2_id = 2tc2.c2_id) 
            	LEFT OUTER JOIN 202_tracking_c3 AS 2tc3 ON (2ct.c3_id = 2tc3.c3_id) 
            	LEFT OUTER JOIN 202_tracking_c4 AS 2tc4 ON (2ct.c4_id = 2tc4.c4_id) 
            	LEFT JOIN `202_google` AS 2g on (2g.click_id=2c.click_id) 
            	LEFT JOIN `202_utm_source` AS 2us USING (`utm_source_id`)
                LEFT JOIN `202_utm_medium` AS 2um USING (`utm_medium_id`)
                LEFT JOIN `202_utm_campaign` AS 2uca USING (`utm_campaign_id`)
                LEFT JOIN `202_utm_term` AS 2ut USING (`utm_term_id`)
                LEFT JOIN `202_utm_content` AS 2uco USING (`utm_content_id`)
                LEFT JOIN `202_keywords` AS 2kw ON (2ca.`keyword_id` = 2kw.`keyword_id`) 
		        LEFT JOIN `202_locations_country` AS 2lc ON (2ca.`country_id` = 2lc.`country_id`)
		        LEFT JOIN `202_locations_region` AS 2lr ON (2ca.`region_id` = 2lr.`region_id`)    
		        LEFT JOIN `202_locations_city` AS 2lc2 ON (2ca.`city_id` = 2lc2.`city_id`)
                LEFT JOIN `202_users` AS 2u USING (`user_id`)
		    WHERE
				2c.click_id='" . $mysql['click_id'] . "'
		";
        
        $click_result = _mysqli_query($db, $click_sql);
        $click_row = $click_result->fetch_assoc();
        
        $mysql['t202kw'] = $db->real_escape_string($click_row['keyword']);
        $mysql['t202pubid'] = $db->real_escape_string($click_row['user_public_publisher_id']);
        $mysql['c1'] = $db->real_escape_string($click_row['c1']);
        $mysql['c2'] = $db->real_escape_string($click_row['c2']);
        $mysql['c3'] = $db->real_escape_string($click_row['c3']);
        $mysql['c4'] = $db->real_escape_string($click_row['c4']);
        $mysql['gclid'] = $db->real_escape_string($click_row['gclid']);
        $mysql['utm_source'] = $db->real_escape_string($click_row['utm_source']);
        $mysql['utm_medium'] = $db->real_escape_string($click_row['utm_medium']);
        $mysql['utm_campaign'] = $db->real_escape_string($click_row['utm_campaign']);
        $mysql['utm_term'] = $db->real_escape_string($click_row['utm_term']);
        $mysql['utm_content'] = $db->real_escape_string($click_row['utm_content']);
        $mysql['payout'] = $db->real_escape_string($click_row['click_payout']);
        $mysql['cpc'] = $db->real_escape_string($click_row['click_cpc']);
        $mysql['click_cpc'] = $db->real_escape_string($click_row['click_cpc']);
        $mysql['country'] = $db->real_escape_string($click_row['country_name']);
        $mysql['country_code'] = $db->real_escape_string($click_row['country_code']);
        $mysql['region'] = $db->real_escape_string($click_row['region_name']);
        $mysql['city'] = $db->real_escape_string($click_row['city_name']);
        $mysql['referer'] = urlencode($db->real_escape_string($_SERVER['HTTP_REFERER']));
        if( $db->real_escape_string($cvar_sql_row['ppc_account_id']) == '0'){
            $mysql['ppc_account'] = '';    
        }
        else{
            $mysql['ppc_account'] = $db->real_escape_string($cvar_sql_row['ppc_account_id']);
        }
        
        $tokens = array(
            "subid" => $mysql['click_id'],
            "t202kw" => $mysql['t202kw'],
            "t202pubid" => $mysql['t202pubid'],
            "c1" => $mysql['c1'],
            "c2" => $mysql['c2'],
            "c3" => $mysql['c3'],
            "c4" => $mysql['c4'],
            "gclid" => $mysql['gclid'],
            "utm_source" => $mysql['utm_source'],
            "utm_medium" => $mysql['utm_medium'],
            "utm_campaign" => $mysql['utm_campaign'],
            "utm_term" => $mysql['utm_term'],
            "utm_content" => $mysql['utm_content'],
            "country" => $mysql['country'],
            "country_code" => $mysql['country_code'],
            "region" => $mysql['region'],
            "city" => $mysql['city'],
            "cpc" => round($mysql['cpc'], 2),
            "cpc2" => $mysql['cpc'],
           // "timestamp" => time(), don't change the time it was already set
            "payout" => $mysql['click_payout'],
            "random" => mt_rand(1000000, 9999999),
            "referer" => $mysql['referer'],
            "sourceid" => $mysql['ppc_account']
        );
        
        $url = (replaceTokens($url, $tokens, 1)); //call replace tokens and allow it to fill all unset tokens with blanks
    }
    return $url;
}

function setClickIdCookie($click_id, $campaign_id = 0)
{
    // set the cookie for the PIXEL to fire, expire in 30 days
    $expire = time() + 2592000;
    setcookie('tracking202subid', $click_id, $expire, '/', $_SERVER['SERVER_NAME']);
    setcookie('tracking202subid_a_' . $campaign_id, $click_id, $expire, '/', $_SERVER['SERVER_NAME']);
}

function setClickIdCookieForLp($click_id, $lp_public_id)
{   
    $expire = time() + 2592000;
    setcookie('tracking202rlp_' . $lp_public_id, $click_id, $expire, '/', $_SERVER['SERVER_NAME']);
}

class PLATFORMS
{

// If Cache is not working
        else {
            
            return PLATFORMS::parseUserAgentInfo($db, $detect);
        }
    }

function botCheck($ip)
    {
        global $memcacheWorking, $memcache;
        
        if ($memcacheWorking) {
            $getFromCache = $memcache->get(md5("bot-ip" . $ua . systemHash()));
        } else {
            $getFromCache = false;
        }
        
        if (!$getFromCache) {

$ranges = array(
                '199.60.28.0/24',
                '199.103.122.0/24',
                '192.197.157.0/24',
                '207.68.128.0/18',
                '157.54.0.0/15',
                '157.56.0.0/14',
                '157.60.0.0/16',
                '70.32.128.0/19',
                '172.253.0.0/16',
                '173.194.0.0/16',
                '209.85.128.0/17',
                '72.14.192.0/18',
                '66.249.64.0/19',
                '108.177.0.0/17',
                '64.233.160.0/19',
                '66.102.0.0/20',
                '216.239.32.0/19',
                '203.208.60.0/24',
                '66.249.64.0/19',
                '72.14.199.0/24',
                '209.85.238.0/24',
                '204.236.235.245',
                '75.101.186.145',
                '31.13.97.0/24',
                '31.13.99.0/24',
                '31.13.100.0/24',
                '66.220.144.0/20',
                '69.63.189.0/24',
                '69.63.190.0/24',
                '69.171.224.0/20',
                '69.171.240.0/21',
                '69.171.248.0/24',
                '173.252.73.0/24',
                '173.252.74.0/24',
                '173.252.77.0/24',
                '173.252.100.0/22',
                '173.252.104.0/21',
                '173.252.112.0/24',
                '17.0.0.0/8',
                '157.55.39.0/24'
            );
            
            foreach ($ranges as $key => $value) {
                if (PLATFORMS::check_ip_range($ip, $value)) {
                    if ($memcacheWorking) {
                        setCache(md5("ip-bot" . $ip . systemHash()), true);
                    }
                    
                    return true;
                }
            }

return false;
        }
        
        return true;
    }

function check_ip_range($ip, $range) {
        if (strpos($range, '/') == false) {
            $range .= '/32';
        }
        list($range, $netmask) = explode('/', $range, 2);
        $range_decimal = ip2long($range);
        $ip_decimal = ip2long($ip);
        $wildcard_decimal = pow(2, (32 - $netmask)) - 1;
        $netmask_decimal = ~ $wildcard_decimal;
        return (($ip_decimal & $netmask_decimal) == ($range_decimal & $netmask_decimal));
    }
}

class INDEXES
{
    
    // this returns the location_country_id, when a Country Code is given
    function get_country_id($db, $country_name, $country_code)
    {
        global $memcacheWorking, $memcache;
        
        $mysql['country_name'] = $db->real_escape_string($country_name);
        $mysql['country_code'] = $db->real_escape_string($country_code);
        
        if ($memcacheWorking) {
            $time = 2592000; // 30 days in sec
                             // get from memcached
            $getID = $memcache->get(md5("country-id" . $country_name . systemHash()));
            
            if ($getID) {
                $country_id = $getID;
                return $country_id;
            } else {
                
                $country_sql = "SELECT country_id FROM 202_locations_country WHERE country_code='" . $mysql['country_code'] . "'";
                $country_result = _mysqli_query($db, $country_sql);
                $country_row = $country_result->fetch_assoc();
                if ($country_row) {
                    // if this ip_id already exists, return the ip_id for it.
                    $country_id = $country_row['country_id'];
                    // add to memcached
                    $setID = setCache(md5("country-id" . $country_name . systemHash()), $country_id, $time);
                    return $country_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $country_sql = "INSERT INTO 202_locations_country SET country_code='" . $mysql['country_code'] . "', country_name='" . $mysql['country_name'] . "'";
                    $country_result = _mysqli_query($db, $country_sql); // ($ip_sql);
                    $country_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("country-id" . $country_name . systemHash()), $country_id, $time);
                    return $country_id;
                }
            }
        } else {
            
            $country_sql = "SELECT country_id FROM 202_locations_country WHERE country_code='" . $mysql['country_code'] . "'";
            
            $country_result = _mysqli_query($db, $country_sql);
            $country_row = $country_result->fetch_assoc();
            if ($country_row) {
                // if this country already exists, return the location_country_id for it.
                $country_id = $country_row['country_id'];
                
                return $country_id;
            } else {
                // else if this doesn't exist, insert the new countryrow, and return the_id for this new row we found
                $country_sql = "INSERT INTO 202_locations_country SET country_code='" . $mysql['country_code'] . "', country_name='" . $mysql['country_name'] . "'";
                $country_result = _mysqli_query($db, $country_sql); // ($ip_sql);
                $country_id = $db->insert_id;
                
                return $country_id;
            }
        }
    }
    
    // this returns the location_city_id, when a City name is given
    function get_city_id($db, $city_name, $country_id)
    {
        global $memcacheWorking, $memcache;
        
        $mysql['city_name'] = $db->real_escape_string($city_name);
        $mysql['country_id'] = $db->real_escape_string($country_id);
        
        if ($memcacheWorking) {
            $time = 2592000; // 30 days in sec
                             // get from memcached
            $getID = $memcache->get(md5("city-id" . $city_name . $country_id . systemHash()));
            
            if ($getID) {
                $city_id = $getID;
                return $city_id;
            } else {
                
                $city_sql = "SELECT city_id FROM 202_locations_city WHERE city_name='" . $mysql['city_name'] . "' AND main_country_id='" . $mysql['country_id'] . "'";
                $city_result = _mysqli_query($db, $city_sql);
                $city_row = $city_result->fetch_assoc();
                if ($city_row) {
                    // if this ip_id already exists, return the ip_id for it.
                    $city_id = $city_row['city_id'];
                    // add to memcached
                    $setID = setCache(md5("city-id" . $city_name . $country_id . systemHash()), $city_id, $time);
                    return $city_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $city_sql = "INSERT INTO 202_locations_city SET city_name='" . $mysql['city_name'] . "', main_country_id='" . $mysql['country_id'] . "'";
                    $city_result = _mysqli_query($db, $city_sql); // ($ip_sql);
                    $city_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("city-id" . $city_name . $country_id . systemHash()), $city_id, $time);
                    return $city_id;
                }
            }
        } else {
            
            $city_sql = "SELECT city_id FROM 202_locations_city WHERE city_name='" . $mysql['city_name'] . "' AND main_country_id='" . $mysql['country_id'] . "'";
            $city_result = _mysqli_query($db, $city_sql);
            $city_row = $city_result->fetch_assoc();
            if ($city_row) {
                // if this country already exists, return the location_country_id for it.
                $city_id = $city_row['city_id'];
                
                return $city_id;
            } else {
                // else if this doesn't exist, insert the new cityrow, and return the_id for this new row we found
                $city_sql = "INSERT INTO 202_locations_city SET city_name='" . $mysql['city_name'] . "', main_country_id='" . $mysql['country_id'] . "'";
                $city_result = _mysqli_query($db, $city_sql); // ($ip_sql);
                $city_id = $db->insert_id;
                
                return $city_id;
            }
        }
    }
    
    // this returns the location_region_id, when a Region name is given
    function get_region_id($db, $region_name, $country_id)
    {
        global $memcacheWorking, $memcache;
        
        $mysql['region_name'] = $db->real_escape_string($region_name);
        $mysql['country_id'] = $db->real_escape_string($country_id);
        
        if ($memcacheWorking) {
            $time = 2592000; // 30 days in sec
                             // get from memcached
            $getID = $memcache->get(md5("region-id" . $region_name . $country_id . systemHash()));
            
            if ($getID) {
                $region_id = $getID;
                return $region_id;
            } else {
                
                $region_sql = "SELECT region_id FROM 202_locations_region WHERE region_name='" . $mysql['region_name'] . "' AND main_country_id='" . $mysql['country_id'] . "'";
                $region_result = _mysqli_query($db, $region_sql);
                $region_row = $region_result->fetch_assoc();
                if ($region_row) {
                    // if this ip_id already exists, return the ip_id for it.
                    $region_id = $region_row['region_id'];
                    // add to memcached
                    $setID = setCache(md5("region-id" . $region_name . $country_id . systemHash()), $region_id, $time);
                    return $region_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $region_sql = "INSERT INTO 202_locations_region SET region_name='" . $mysql['region_name'] . "', main_country_id='" . $mysql['country_id'] . "'";
                    $region_result = _mysqli_query($db, $region_sql); // ($ip_sql);
                    $region_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("region-id" . $region_name . $country_id . systemHash()), $region_id, $time);
                    return $region_id;
                }
            }
        } else {
            
            $region_sql = "SELECT region_id FROM 202_locations_region WHERE region_name='" . $mysql['region_name'] . "' AND main_country_id='" . $mysql['country_id'] . "'";
            $region_result = _mysqli_query($db, $region_sql);
            $region_row = $region_result->fetch_assoc();
            if ($region_row) {
                // if this country already exists, return the location_country_id for it.
                $region_id = $region_row['region_id'];
                
                return $region_id;
            } else {
                // else if this doesn't exist, insert the new cityrow, and return the_id for this new row we found
                $region_sql = "INSERT INTO 202_locations_region SET region_name='" . $mysql['region_name'] . "', main_country_id='" . $mysql['country_id'] . "'";
                $region_result = _mysqli_query($db, $region_sql); // ($ip_sql);
                $region_id = $db->insert_id;
                
                return $region_id;
            }
        }
    }
    
    // this returns the isp_id, when a isp name is given
    function get_isp_id($db, $isp)
    {
        global $memcacheWorking, $memcache;
        
        $mysql['isp'] = $db->real_escape_string($isp);
        
        if ($memcacheWorking) {
            $time = 604800; // 7 days in sec
                            // get from memcached
            $getID = $memcache->get(md5("isp-id" . $isp . systemHash()));
            
            if ($getID) {
                $isp_id = $getID;
                return $isp_id;
            } else {
                
                $isp_sql = "SELECT isp_id FROM 202_locations_isp WHERE isp_name='" . $mysql['isp'] . "'";
                $isp_result = _mysqli_query($db, $isp_sql);
                $isp_row = $isp_result->fetch_assoc();
                if ($isp_row) {
                    // if this ip_id already exists, return the ip_id for it.
                    $isp_id = $isp_row['isp_id'];
                    // add to memcached
                    $setID = setCache(md5("isp-id" . $isp . systemHash()), $isp_id, $time);
                    return $isp_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $isp_sql = "INSERT INTO 202_locations_isp SET isp_name='" . $mysql['isp'] . "'";
                    $isp_result = _mysqli_query($db, $isp_sql); // ($isp_sql);
                    $isp_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("isp-id" . $isp . systemHash()), $isp_id, $time);
                    return $isp_id;
                }
            }
        } else {
            
            $isp_sql = "SELECT isp_id FROM 202_locations_isp WHERE isp_name='" . $mysql['isp'] . "'";
            $isp_result = _mysqli_query($db, $isp_sql);
            $isp_row = $isp_result->fetch_assoc();
            if ($isp_row) {
                // if this isp already exists, return the isp_id for it.
                $isp_id = $isp_row['isp_id'];
                
                return $isp_id;
            } else {
                // else if this doesn't exist, insert the new isp row, and return the_id for this new row we found
                $isp_sql = "INSERT INTO 202_locations_isp SET isp_name='" . $mysql['isp'] . "'";
                $isp_result = _mysqli_query($db, $isp_sql); // ($isp_sql);
                $isp_id = $db->insert_id;
                
                return $isp_id;
            }
        }
    }
    
    // this returns the ip_id, when a ip_address is given
    function get_ip_id($db, $ip_address)
    {
        global $memcacheWorking, $memcache;
        
        $mysql['ip_address'] = $db->real_escape_string($ip_address);
        
        if ($memcacheWorking) {
            $time = 604800; // 7 days in sec
                            // get from memcached
            $getID = $memcache->get(md5("ip-id" . $ip_address . systemHash()));
            
            if ($getID) {
                $ip_id = $getID;
                return $ip_id;
            } else {
                
                $ip_sql = "SELECT ip_id FROM 202_ips WHERE ip_address='" . $mysql['ip_address'] . "'";
                $ip_result = _mysqli_query($db, $ip_sql);
                $ip_row = $ip_result->fetch_assoc();
                if ($ip_row) {
                    // if this ip_id already exists, return the ip_id for it.
                    $ip_id = $ip_row['ip_id'];
                    // add to memcached
                    $setID = setCache(md5("ip-id" . $ip_address . systemHash()), $ip_id, $time);
                    return $ip_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $ip_sql = "INSERT INTO 202_ips SET ip_address='" . $mysql['ip_address'] . "'";
                    $ip_result = _mysqli_query($db, $ip_sql); // ($ip_sql);
                    $ip_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("ip-id" . $ip_address . systemHash()), $ip_id, $time);
                    return $ip_id;
                }
            }
        } else {
            
            $ip_sql = "SELECT ip_id FROM 202_ips WHERE ip_address='" . $mysql['ip_address'] . "'";
            $ip_result = _mysqli_query($db, $ip_sql);
            $ip_row = $ip_result->fetch_assoc();
            if ($ip_row) {
                // if this ip already exists, return the ip_id for it.
                $ip_id = $ip_row['ip_id'];
                
                return $ip_id;
            } else {
                // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                $ip_sql = "INSERT INTO 202_ips SET ip_address='" . $mysql['ip_address'] . "'";
                $ip_result = _mysqli_query($db, $ip_sql); // ($ip_sql);
                $ip_id = $db->insert_id;
                
                return $ip_id;
            }
        }
    }
    
    // this returns the site_domain_id, when a site_url_address is given
    function get_site_domain_id($db, $site_url_address)
    {
        global $memcacheWorking, $memcache;
        
        $parsed_url = @parse_url(trim($site_url_address));
        
        $site_domain_host = trim($parsed_url[host] ? $parsed_url[host] : array_shift(explode('/', $parsed_url[path], 2)));
        $site_domain_host = str_replace('www.', '', $site_domain_host);
        
        $mysql['site_domain_host'] = $db->real_escape_string($site_domain_host);
        
        // if a cached key is found for this lpip, redirect to that url
        if ($memcacheWorking) {
            $time = 2592000; // 30 days in sec
                             // get from memcached
            $getID = $memcache->get(md5("domain-id" . $site_domain_host . systemHash()));
            
            if ($getID) {
                $site_domain_id = $getID;
                return $site_domain_id;
            } else {
                
                $site_domain_sql = "SELECT site_domain_id FROM 202_site_domains WHERE site_domain_host='" . $mysql['site_domain_host'] . "'";
                $site_domain_result = _mysqli_query($db, $site_domain_sql);
                $site_domain_row = $site_domain_result->fetch_assoc();
                if ($site_domain_row) {
                    // if this site_domain_id already exists, return the site_domain_id for it.
                    $site_domain_id = $site_domain_row['site_domain_id'];
                    // add to memcached
                    $setID = setCache(md5("domain-id" . $site_domain_host . systemHash()), $site_domain_id, $time);
                    return $site_domain_id;
                } else {
                    // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                    $site_domain_sql = "INSERT INTO 202_site_domains SET site_domain_host='" . $mysql['site_domain_host'] . "'";
                    $site_domain_result = _mysqli_query($db, $site_domain_sql); // ($site_domain_sql);
                    $site_domain_id = $db->insert_id;
                    // add to memcached
                    $setID = setCache(md5("domain-id" . $site_domain_host . systemHash()), $site_domain_id, $time);
                    return $site_domain_id;
                }
            }
        } else {
            
            $site_domain_sql = "SELECT site_domain_id FROM 202_site_domains WHERE site_domain_host='" . $mysql['site_domain_host'] . "'";
            $site_domain_result = _mysqli_query($db, $site_domain_sql);
            $site_domain_row = $site_domain_result->fetch_assoc();
            if ($site_domain_row) {
                // if this site_domain_id already exists, return the site_domain_id for it.
                $site_domain_id = $site_domain_row['site_domain_id'];
                // add to memcached
                return $site_domain_id;
            } else {
                // else if this doesn't exist, insert the new iprow, and return the_id for this new row we found
                $site_domain_sql = "INSERT INTO 202_site_domains SET site_domain_host='" . $mysql['site_domain_host'] . "'";
                $site_domain_result = _mysqli_query($db, $site_domain_sql); // ($site_domain_sql);
                $site_domain_id = $db->insert_id;
                return $site_domain_id;
            }
        }
    }
    
    // this returns the site_url_id, when a site_url_address is given
    function get_site_url_id($db, $site_url_address)
    {
        global $memcacheWorking, $memcache;
        
        $site_domain_id = INDEXES::get_site_domain_id($db, $site_url_address);
        
        $mysql['site_url_address'] = $db->real_escape_string($site_url_address);
        $mysql['site_domain_id'] = $db->real_escape_string($site_domain_id);
        
        if ($memcacheWorking) {
            $time = 604800; // 7 days in sec
                            // get from memcached
            $getURL = $memcache->get(md5("url-id" . $site_url_address . systemHash()));
            if ($getURL) {
                return $getURL;
            } else {
                
                $site_url_sql = "SELECT site_url_id FROM 202_site_urls WHERE site_url_address='" . $mysql['site_url_address'] . "' limit 1";
                $site_url_result = _mysqli_query($db, $site_url_sql);
                $site_url_row = $site_url_result->fetch_assoc();
                if ($site_url_row) {
                    // if this site_url_id already exists, return the site_url_id for it.
                    $site_url_id = $site_url_row['site_url_id'];
                    $setID = setCache(md5("url-id" . $site_url_address . systemHash()), $site_url_id, $time);
                    return $site_url_id;
                } else {
                    
                    $site_url_sql = "INSERT INTO 202_site_urls SET site_domain_id='" . $mysql['site_domain_id'] . "', site_url_address='" . $mysql['site_url_address'] . "'";
                    $site_url_result = _mysqli_query($db, $site_url_sql); // ($site_url_sql);
                    $site_url_id = $db->insert_id;
                    $setID = setCache(md5("url-id" . $site_url_address . systemHash()), $site_url_id, $time);
                    return $site_url_id;
                }
            }
        } else {
            
            $site_url_sql = "SELECT site_url_id FROM 202_site_urls WHERE site_domain_id='" . $mysql['site_domain_id'] . "' and site_url_address='" . $mysql['site_url_address'] . "' limit 1";
            $site_url_result = _mysqli_query($db, $site_url_sql);
            $site_url_row = $site_url_result->fetch_assoc();
            
            if ($site_url_row) {
                // if this site_url_id already exists, return the site_url_id for it.
                $site_url_id = $site_url_row['site_url_id'];
                return $site_url_id;
            } else {
                
                $site_url_sql = "INSERT INTO 202_site_urls SET site_domain_id='" . $mysql['site_domain_id'] . "', site_url_address='" . $mysql['site_url_address'] . "'";
                $site_url_result = _mysqli_query($db, $site_url_sql); // ($site_url_sql);
                $site_url_id = $db->insert_id;
                return $site_url_id;
            }
        }
    }
    
    // this returns the keyword_id
    function get_utm_id($db, $utm_var, $utm_type)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 350 characters of the utm variable
        $utm_var = substr($utm_var, 0, 350);
        
        $mysql['utm_var'] = $db->real_escape_string($utm_var);
        $mysql['utm_type'] = $db->real_escape_string($utm_type);
        
        if ($memcacheWorking) {
            // get from memcached
            $getUtm = $memcache->get(md5($mysql['utm_type'] . "_id" . $utm_var . systemHash()));
            if ($getUtm) {
                return $getUtm;
            } else {
                
                $utm_sql = "SELECT " . $mysql['utm_type'] . "_id FROM 202_" . $mysql['utm_type'] . " WHERE " . $mysql['utm_type'] . "='" . $mysql['utm_var'] . "'";
                $utm_result = _mysqli_query($db, $utm_sql);
                $utm_row = $utm_result->fetch_assoc();
                if ($utm_row) {
                    // if this already exists, return the id for it
                    $utm_id_name = $mysql['utm_type'] . "_id";
                    $utm_id = $utm_row[$utm_id_name];
                    $setID = setCache(md5($mysql['utm_type'] . "_id" . $utm_var . systemHash()), $utm_id, $time);
                    return $utm_id;
                } else {
                    
                    $utm_sql = "INSERT INTO 202_" . $mysql['utm_type'] . " SET " . $mysql['utm_type'] . "='" . $mysql['utm_var'] . "'";
                    $utm_result = _mysqli_query($db, $utm_sql);
                    $utm_id = $db->insert_id;
                    $setID = setCache(md5($mysql['utm_type'] . "_id" . $utm_var . systemHash()), $utm_id, $time);
                    return $utm_id;
                }
            }
        } else {
            
            $utm_sql = "SELECT " . $mysql['utm_type'] . "_id FROM 202_" . $mysql['utm_type'] . " WHERE " . $mysql['utm_type'] . "='" . $mysql['utm_var'] . "'";
            // die( $utm_sql);
            $utm_result = _mysqli_query($db, $utm_sql);
            $utm_row = $utm_result->fetch_assoc();
            if ($utm_row) {
                // if this already exists, return the id for it
                $utm_id_name = $mysql['utm_type'] . "_id";
                $utm_id = $utm_row[$utm_id_name];
                return $utm_id;
            } else {
                
                $utm_sql = "INSERT INTO 202_" . $mysql['utm_type'] . " SET " . $mysql['utm_type'] . "='" . $mysql['utm_var'] . "'";
                $utm_result = _mysqli_query($db, $utm_sql);
                $utm_id = $db->insert_id;
                return $utm_id;
            }
        }
    }

// if this already exists, return the id for it
                $var_id = $var_row['variable_set_id'];
                return $var_id;
            } else {
                $var_sql = "INSERT INTO 202_variable_sets SET variables = '" . $mysql['variables'] . "'";
                $var_result = _mysqli_query($db, $var_sql);
                $var_id = $db->insert_id;
                $var_sets = explode (",", $mysql['variables']);
                foreach ($var_sets as $var){
                    $row.= "(".  $var_id.",".$var."),";
                }

$row="insert into `202_variable_sets2` (`variable_set_id`, `variables`) values ".rtrim($row,',').";";
                
                _mysqli_query($db,$row);
                return $var_id;
            }
        }
    }
    
    // this returns the keyword_id
    function get_keyword_id($db, $keyword)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 255 characters of keyword
        // $keyword = substr($keyword, 0, 255);
        
        $mysql['keyword'] = $db->real_escape_string($keyword);
        
        if ($memcacheWorking) {
            // get from memcached
            $getKeyword = $memcache->get(md5("keyword-id" . $keyword . systemHash()));
            if ($getKeyword) {
                return $getKeyword;
            } else {
                
                $keyword_sql = "SELECT keyword_id FROM 202_keywords WHERE keyword='" . $mysql['keyword'] . "'";
                $keyword_result = _mysqli_query($db, $keyword_sql);
                $keyword_row = $keyword_result->fetch_assoc();
                if ($keyword_row) {
                    // if this already exists, return the id for it
                    $keyword_id = $keyword_row['keyword_id'];
                    $setID = setCache(md5("keyword-id" . $keyword . systemHash()), $keyword_id, $time);
                    return $keyword_id;
                } else {
                    
                    $keyword_sql = "INSERT INTO 202_keywords SET keyword='" . $mysql['keyword'] . "'";
                    $keyword_result = _mysqli_query($db, $keyword_sql); // ($keyword_sql);
                    $keyword_id = $db->insert_id;
                    $setID = setCache(md5("keyword-id" . $keyword . systemHash()), $keyword_id, $time);
                    return $keyword_id;
                }
            }
        } else {
            
            $keyword_sql = "SELECT keyword_id FROM 202_keywords WHERE keyword='" . $mysql['keyword'] . "'";
            $keyword_result = _mysqli_query($db, $keyword_sql);
            $keyword_row = $keyword_result->fetch_assoc();
            if ($keyword_row) {
                // if this already exists, return the id for it
                $keyword_id = $keyword_row['keyword_id'];
                return $keyword_id;
            } else {
                // else if this ip doesn't exist, insert the row and grab the id for it
                $keyword_sql = "INSERT INTO 202_keywords SET keyword='" . $mysql['keyword'] . "'";
                $keyword_result = _mysqli_query($db, $keyword_sql); // ($keyword_sql);
                $keyword_id = $db->insert_id;
                return $keyword_id;
            }
        }
    }

// this returns the c1 id
    function get_custom_var_id($db, $custom_var_name, $custom_var_data)
    {
        global $memcacheWorking, $memcache;
     
        // only grab the first 350 charactesr of custom_var
        $custom_var_data = substr($custom_var_data, 0, 350);
        $mysql[$custom_var_name] = $db->real_escape_string($custom_var_data);
    
        if ($memcacheWorking) {
            // get from memcached
            $getcustomvar = $memcache->get(md5($custom_var_name."-id" . $custom_var_data . systemHash()));
            if ($getcustomvar) {
                return $getcustomvar;
            } else {
    
                $custom_sql = "SELECT ".$custom_var_name."_id FROM 202_tracking_".$custom_var_name." WHERE ".$custom_var_name."='" . $mysql[$custom_var_name] . "'";
                $custom_result = _mysqli_query($db, $custom_sql);
                $custom_row = $custom_result->fetch_assoc();
                if ($custom_row) {
                    // if this already exists, return the id for it
                    $custom_id = $custom_row[$custom_var_name."_id"];
                    $setID = setCache(md5($custom_var_name."-id" . $custom_var_data . systemHash()), $custom_id);
                    return $custom_id;
                } else {
    
                    $custom_sql = "INSERT INTO 202_tracking_".$custom_var_name." SET ".$custom_var_name."='" . $mysql[$custom_var_name] . "'";
                    $custom_result = _mysqli_query($db, $custom_sql); // ($c1_sql);
                    $custom_id = $db->insert_id;
                    $setID = setCache(md5($custom_var_name."-id" . $custom_var_data . systemHash()), $custom_id);
                    return $custom_id;
                }
            }
        } else {
    
            $custom_sql = "SELECT ".$custom_var_name."_id FROM 202_tracking_".$custom_var_name." WHERE ".$custom_var_name."='" . $mysql[$custom_var_name] . "'";

$custom_result = _mysqli_query($db, $custom_sql);
            $custom_row = $custom_result->fetch_assoc();

if ($custom_row) {
                // if this already exists, return the id for it
                $custom_id = $custom_row[$custom_var_name."_id"];
                return $custom_id;
            } else {
                // else if this id doesn't exist, insert the row and grab the id for it
                $custom_sql = "INSERT INTO 202_tracking_".$custom_var_name." SET ".$custom_var_name."='" . $mysql[$custom_var_name] . "'";
                $custom_result = _mysqli_query($db, $custom_sql); 
                $custom_id = $db->insert_id;
                return $custom_id;
            }
        }
    }
    
    // this returns the c1 id
    function get_c1_id($db, $c1)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 350 charactesr of c1
        $c1 = substr($c1, 0, 350);
        
        $mysql['c1'] = $db->real_escape_string($c1);
        
        if ($memcacheWorking) {
            // get from memcached
            $getc1 = $memcache->get(md5("c1-id" . $c1 . systemHash()));
            if ($getc1) {
                return $getc1;
            } else {
                
                $c1_sql = "SELECT c1_id FROM 202_tracking_c1 WHERE c1='" . $mysql['c1'] . "'";
                $c1_result = _mysqli_query($db, $c1_sql);
                $c1_row = $c1_result->fetch_assoc();
                if ($c1_row) {
                    // if this already exists, return the id for it
                    $c1_id = $c1_row['c1_id'];
                    $setID = setCache(md5("c1-id" . $c1 . systemHash()), $c1_id);
                    return $c1_id;
                } else {
                    
                    $c1_sql = "INSERT INTO 202_tracking_c1 SET c1='" . $mysql['c1'] . "'";
                    $c1_result = _mysqli_query($db, $c1_sql); // ($c1_sql);
                    $c1_id = $db->insert_id;
                    $setID = setCache(md5("c1-id" . $c1 . systemHash()), $c1_id);
                    return $c1_id;
                }
            }
        } else {
            
            $c1_sql = "SELECT c1_id FROM 202_tracking_c1 WHERE c1='" . $mysql['c1'] . "'";
            $c1_result = _mysqli_query($db, $c1_sql);
            $c1_row = $c1_result->fetch_assoc();
            if ($c1_row) {
                // if this already exists, return the id for it
                $c1_id = $c1_row['c1_id'];
                return $c1_id;
            } else {
                // else if this ip doesn't exist, insert the row and grab the id for it
                $c1_sql = "INSERT INTO 202_tracking_c1 SET c1='" . $mysql['c1'] . "'";
                $c1_result = _mysqli_query($db, $c1_sql); // ($c1_sql);
                $c1_id = $db->insert_id;
                return $c1_id;
            }
        }
    }
    
    // this returns the c2 id
    function get_c2_id($db, $c2)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 350 charactesr of c2
        $c2 = substr($c2, 0, 350);
        
        $mysql['c2'] = $db->real_escape_string($c2);
        
        if ($memcacheWorking) {
            // get from memcached
            $getc2 = $memcache->get(md5("c2-id" . $c2 . systemHash()));
            if ($getc2) {
                return $getc2;
            } else {
                
                $c2_sql = "SELECT c2_id FROM 202_tracking_c2 WHERE c2='" . $mysql['c2'] . "'";
                $c2_result = _mysqli_query($db, $c2_sql);
                $c2_row = $c2_result->fetch_assoc();
                if ($c2_row) {
                    // if this already exists, return the id for it
                    $c2_id = $c2_row['c2_id'];
                    $setID = setCache(md5("c2-id" . $c2 . systemHash()), $c2_id);
                    return $c2_id;
                } else {
                    
                    $c2_sql = "INSERT INTO 202_tracking_c2 SET c2='" . $mysql['c2'] . "'";
                    $c2_result = _mysqli_query($db, $c2_sql); // ($c2_sql);
                    $c2_id = $db->insert_id;
                    $setID = setCache(md5("c2-id" . $c2 . systemHash()), $c2_id);
                    return $c2_id;
                }
            }
        } else {
            
            $c2_sql = "SELECT c2_id FROM 202_tracking_c2 WHERE c2='" . $mysql['c2'] . "'";
            $c2_result = _mysqli_query($db, $c2_sql);
            $c2_row = $c2_result->fetch_assoc();
            if ($c2_row) {
                // if this already exists, return the id for it
                $c2_id = $c2_row['c2_id'];
                return $c2_id;
            } else {
                // else if this ip doesn't exist, insert the row and grab the id for it
                $c2_sql = "INSERT INTO 202_tracking_c2 SET c2='" . $mysql['c2'] . "'";
                $c2_result = _mysqli_query($db, $c2_sql); // ($c2_sql);
                $c2_id = $db->insert_id;
                return $c2_id;
            }
        }
    }
    
    // this returns the c3 id
    function get_c3_id($db, $c3)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 350 charactesr of c3
        $c3 = substr($c3, 0, 350);
        
        $mysql['c3'] = $db->real_escape_string($c3);
        
        if ($memcacheWorking) {
            // get from memcached
            $getc3 = $memcache->get(md5("c3-id" . $c3 . systemHash()));
            if ($getc3) {
                return $getc3;
            } else {
                
                $c3_sql = "SELECT c3_id FROM 202_tracking_c3 WHERE c3='" . $mysql['c3'] . "'";
                $c3_result = _mysqli_query($db, $c3_sql);
                $c3_row = $c3_result->fetch_assoc();
                if ($c3_row) {
                    // if this already exists, return the id for it
                    $c3_id = $c3_row['c3_id'];
                    $setID = setCache(md5("c3-id" . $c3 . systemHash()), $c3_id);
                    return $c3_id;
                } else {
                    
                    $c3_sql = "INSERT INTO 202_tracking_c3 SET c3='" . $mysql['c3'] . "'";
                    $c3_result = _mysqli_query($db, $c3_sql); // ($c3_sql);
                    $c3_id = $db->insert_id;
                    $setID = setCache(md5("c3-id" . $c3 . systemHash()), $c3_id);
                    return $c3_id;
                }
            }
        } else {
            
            $c3_sql = "SELECT c3_id FROM 202_tracking_c3 WHERE c3='" . $mysql['c3'] . "'";
            $c3_result = _mysqli_query($db, $c3_sql);
            $c3_row = $c3_result->fetch_assoc();
            if ($c3_row) {
                // if this already exists, return the id for it
                $c3_id = $c3_row['c3_id'];
                return $c3_id;
            } else {
                // else if this ip doesn't exist, insert the row and grab the id for it
                $c3_sql = "INSERT INTO 202_tracking_c3 SET c3='" . $mysql['c3'] . "'";
                $c3_result = _mysqli_query($db, $c3_sql); // ($c3_sql);
                $c3_id = $db->insert_id;
                return $c3_id;
            }
        }
    }
    
    // this returns the c4 id
    function get_c4_id($db, $c4)
    {
        global $memcacheWorking, $memcache;
        
        // only grab the first 350 charactesr of c4
        $c4 = substr($c4, 0, 350);
        
        $mysql['c4'] = $db->real_escape_string($c4);
        
        if ($memcacheWorking) {
            // get from memcached
            $getc4 = $memcache->get(md5("c4-id" . $c4 . systemHash()));
            if ($getc4) {
                return $getc4;
            } else {
                
                $c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
                $c4_result = _mysqli_query($db, $c4_sql);
                $c4_row = $c4_result->fetch_assoc();
                if ($c4_row) {
                    // if this already exists, return the id for it
                    $c4_id = $c4_row['c4_id'];
                    $setID = setCache(md5("c4-id" . $c4 . systemHash()), $c4_id);
                    return $c4_id;
                } else {
                    
                    $c4_sql = "INSERT INTO 202_tracking_c4 SET c4='" . $mysql['c4'] . "'";
                    $c4_result = _mysqli_query($db, $c4_sql); // ($c4_sql);
                    $c4_id = $db->insert_id;
                    $setID = setCache(md5("c4-id" . $c4 . systemHash()), $c4_id);
                    return $c4_id;
                }
            }
        } else {
            
            $c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
            $c4_result = _mysqli_query($db, $c4_sql);
            $c4_row = $c4_result->fetch_assoc();
            if ($c4_row) {
                // if this already exists, return the id for it
                $c4_id = $c4_row['c4_id'];
                return $c4_id;
            } else {
                // else if this ip doesn't exist, insert the row and grab the id for it
                $c4_sql = "INSERT INTO 202_tracking_c4 SET c4='" . $mysql['c4'] . "'";
                $c4_result = _mysqli_query($db, $c4_sql); // ($c4_sql);
                $c4_id = $db->insert_id;
                return $c4_id;
            }
        }
    }
}

// for the memcache functions, we want to make a function that will be able to store al the memcache keys for a specific user, so when they update it, we can clear out all the associated memcache keys for that user, so we need two functions one to record all the use memcache keys, and another to delete all those user memcahces keys, will associate it in an array and use the main user_id for the identifier.
function memcache_set_user_key($sql)
{
    if (AUTH::logged_in() == true) {
        
        global $memcache;
        
        $sql = md5($sql);
        $user_id = $_SESSION['user_id'];
        
        $getCache = $memcache->get(md5($user_id . systemHash()));
        
        $queries = explode(",", $getCache);
        
        if (! in_array($sql, $queries)) {
            
            $queries[] = $sql;
        }
        
        $queries = implode(",", $queries);
        $setCache = setCache(md5($user_id, $queries . systemHash()), false);
    }
}

$setCache = setCache(md5($sql . systemHash()), serialize($row), 60 * 1);
                
                // store all this users memcache keys, so we can delete them fast later on
                memcache_set_user_key($sql);
                
                return $row;
            } else {
                // if data is cached, returned the cache data Data Cached
                return unserialize($getCache);
            }
        }
    }
}

function replaceTokens($url, $tokens = Array(), $fillblanks=0)
{
    $tokens = array_map('rawurlencode', $tokens);
    
    if ($tokens['c1'] || $fillblanks)
        $url = preg_replace('/\[\[c1\]\]/i', $tokens['c1'], $url);
    if ($tokens['c2'] || $fillblanks)
        $url = preg_replace('/\[\[c2\]\]/i', $tokens['c2'], $url);
    if ($tokens['c3'] || $fillblanks)
        $url = preg_replace('/\[\[c3\]\]/i', $tokens['c3'], $url);
    if ($tokens['c4'] || $fillblanks)
        $url = preg_replace('/\[\[c4\]\]/i', $tokens['c4'], $url);
    if ($tokens['t202pubid'] || $fillblanks)
        $url = preg_replace('/\[\[t202pubid\]\]/i', $tokens['t202pubid'], $url);
    if ($tokens['gclid'] || $fillblanks)
        $url = preg_replace('/\[\[gclid\]\]/i', $tokens['gclid'], $url);
    if ($tokens['utm_source'] || $fillblanks)
        $url = preg_replace('/\[\[utm_source\]\]/i', $tokens['utm_source'], $url);
    if ($tokens['utm_medium'] || $fillblanks)
        $url = preg_replace('/\[\[utm_medium\]\]/i', $tokens['utm_medium'], $url);
    if ($tokens['utm_campaign'] || $fillblanks)
        $url = preg_replace('/\[\[utm_campaign\]\]/i', $tokens['utm_campaign'], $url);
    if ($tokens['utm_term'] || $fillblanks)
        $url = preg_replace('/\[\[utm_term\]\]/i', $tokens['utm_term'], $url);
    if ($tokens['utm_content'] || $fillblanks)
        $url = preg_replace('/\[\[utm_content\]\]/i', $tokens['utm_content'], $url);
    if ($tokens['subid'] || $fillblanks)
        $url = preg_replace('/\[\[subid\]\]/i', $tokens['subid'], $url);
    if ($tokens['t202kw'] || $fillblanks)
        $url = preg_replace('/\[\[t202kw\]\]/i', $tokens['t202kw'], $url);
    if ($tokens['payout'] || $fillblanks)
        $url = preg_replace('/\[\[payout\]\]/i', $tokens['payout'], $url);
    if ($tokens['random'] || $fillblanks)
        $url = preg_replace('/\[\[random\]\]/i', $tokens['random'], $url);
    if ($tokens['cpc'] || $fillblanks)
        $url = preg_replace('/\[\[cpc\]\]/i', $tokens['cpc'], $url);
    if ($tokens['cpc2'] || $fillblanks)
        $url = preg_replace('/\[\[cpc2\]\]/i', $tokens['cpc2'], $url);
    if ($tokens['timestamp'] || $fillblanks)
        $url = preg_replace('/\[\[timestamp\]\]/i', $tokens['timestamp'], $url);
    if ($tokens['country'] || $fillblanks)
        $url = preg_replace('/\[\[country\]\]/i', $tokens['country'], $url);
    if ($tokens['country_code'] || $fillblanks)
        $url = preg_replace('/\[\[country_code\]\]/i', $tokens['country_code'], $url);
    if ($tokens['region'] || $fillblanks)
        $url = preg_replace('/\[\[region\]\]/i', $tokens['region'], $url);
    if ($tokens['city'] || $fillblanks)
        $url = preg_replace('/\[\[city\]\]/i', $tokens['city'], $url);
    if ($tokens['referer'] || $fillblanks) {
        $url = preg_replace('/\[\[referer\]\]/i', $tokens['referer'], $url);
        $url = preg_replace('/\[\[referrer\]\]/i', $tokens['referer'], $url);
    }
    if ($tokens['sourceid'] || $fillblanks)
        $url = preg_replace('/\[\[sourceid\]\]/i', $tokens['sourceid'], $url);
    if ($tokens['transactionid'] || $fillblanks)
        $url = preg_replace('/\[\[transactionid\]\]/i', $tokens['transactionid'], $url);    
    return $url;
}

function systemHash()
{
    $hash = hash('ripemd160', $_SERVER['HTTP_HOST'] . $_SERVER['SERVER_ADDR']);
    return $hash;
}

function setPCIdCookie($click_id_public)
{
    setcookie('tracking202pci', $click_id_public, 0, '/', $_SERVER['SERVER_NAME']);
}

function setOutboundCookie($outbound_site_url)
{
    setcookie('tracking202outbound', $outbound_site_url, 0, '/', $_SERVER['SERVER_NAME']);
}

function record_mysql_error($db, $sql)
{
    global $server_row;
    
    // record the mysql error
    $clean['mysql_error_text'] = mysqli_error($db);
    
    // if on dev server, echo the error
    
    echo $sql . '<br/><br/>' . $clean['mysql_error_text'] . '<br/><br/>';
    die();
    
    $ip_id = INDEXES::get_ip_id($_SERVER['HTTP_X_FORWARDED_FOR']);
    $mysql['ip_id'] = $db->real_escape_string($ip_id);
    
    $site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
    $site_id = INDEXES::get_site_url_id($site_url);
    $mysql['site_id'] = $db->real_escape_string($site_id);
    
    $mysql['user_id'] = $db->real_escape_string(strip_tags($_SESSION['user_id']));
    $mysql['mysql_error_text'] = $db->real_escape_string($clean['mysql_error_text']);
    $mysql['mysql_error_sql'] = $db->real_escape_string($sql);
    $mysql['script_url'] = $db->real_escape_string(strip_tags($_SERVER['SCRIPT_URL']));
    $mysql['server_name'] = $db->real_escape_string(strip_tags($_SERVER['SERVER_NAME']));
    $mysql['mysql_error_time'] = time();
    
    $report_sql = "INSERT     INTO  202_mysql_errors
								SET     mysql_error_text='" . $mysql['mysql_error_text'] . "',
										mysql_error_sql='" . $mysql['mysql_error_sql'] . "',
										user_id='" . $mysql['user_id'] . "',
										ip_id='" . $mysql['ip_id'] . "',
										site_id='" . $mysql['site_id'] . "',
										mysql_error_time='" . $mysql['mysql_error_time'] . "'";
    $report_query = _mysqli_query($report_sql);
    
    // email administration of the error
    $to = $_SERVER['SERVER_ADMIN'];
    $subject = 'mysql error reported - ' . $site_url;
    $message = '<b>A mysql error has been reported</b><br/><br/>
		
					time: ' . date('r', time()) . '<br/>
					server_name: ' . $_SERVER['SERVER_NAME'] . '<br/><br/>
					
					user_id: ' . $_SESSION['user_id'] . '<br/>
					script_url: ' . $site_url . '<br/>
					$_SERVER: ' . serialize($_SERVER) . '<br/><br/>
					
					. . . . . . . . <br/><br/>
												 
					_mysqli_query: ' . $sql . '<br/><br/>
					 
					mysql_error: ' . $clean['mysql_error_text'];
    $from = $_SERVER['SERVER_ADMIN'];
    $type = 3; // type 3 is mysql_error
               
    // send_email($to,$subject,$message,$from,$type);
               
    // report error to user and end page    ?>
<div class="warning" style="margin: 40px auto; width: 450px;">
	<div>
		<h3>A database error has occured, the webmaster has been notified</h3>
		<p>If this error persists, you may email us directly: <?php printf('<a href="mailto:%s">%s</a>',$_SERVER['SERVER_ADMIN'],$_SERVER['SERVER_ADMIN']); ?></p>
	</div>
</div>

<?php
    
template_bottom($server_row);
    die();
}

function get_absolute_url() {
	return substr(substr(dirname( __FILE__ ), 0,-10),strlen(realpath($_SERVER['DOCUMENT_ROOT'])));
}

function getTrackingDomain() {
    global $db;
    
    $tracking_domain_sql = "
		SELECT
			`user_tracking_domain`
		FROM
			`202_users_pref`
		WHERE
			`user_id`='1'
	";
    $tracking_domain_result = _mysqli_query($db, $tracking_domain_sql); //($user_sql);
    $tracking_domain_row = $tracking_domain_result->fetch_assoc();
    $tracking_domain = $_SERVER['SERVER_NAME'];
    if(strlen($tracking_domain_row['user_tracking_domain'])>0) {
        $tracking_domain = $tracking_domain_row['user_tracking_domain'];
    }
    return $tracking_domain;
}

function updateLpClickDataForRotator($redirect_id, $click_id, $rotator_id, $rule_id) {
    global $db;
    $click_sql = "
        REPLACE INTO
            202_clicks_rotator
        SET
            click_id='".$click_id."',
            rotator_id='".$rotator_id."',
            rule_id='".$rule_id."',
            rule_redirect_id = '".$redirect_id."'";
    $db->query($click_sql);
}

function parseUaForRotatorCriteria($detect, $parser, $ua) {
    $result = $parser->parse($ua);
    
    if( !$detect->isMobile() && !$detect->isTablet() ){

switch ($result->device->family) {
            //Is Bot
            case 'Bot':
                $result->device->family = "Bot";
            break;
            //Is Desktop
            case 'Other':
                $result->device->family = "Desktop";
            break;
        }
    } else {
        if ($detect->isTablet()) {
            $result->device->family = "Tablet";
            //If mobile 
        } else {
            $result->device->family = "Mobile";
        }
    }

return $result;
}

function ip_in_range($ip, $range) {
  if (strpos($range, '/') !== false) {
    list($range, $netmask) = explode('/', $range, 2);
    if (strpos($netmask, '.') !== false) {
      $netmask = str_replace('*', '0', $netmask);
      $netmask_dec = ip2long($netmask);
      return ( (ip2long($ip) & $netmask_dec) == (ip2long($range) & $netmask_dec) );
    } else {
      $x = explode('.', $range);
      while(count($x)<4) $x[] = '0';
      list($a,$b,$c,$d) = $x;
      $range = sprintf("%u.%u.%u.%u", empty($a)?'0':$a, empty($b)?'0':$b,empty($c)?'0':$c,empty($d)?'0':$d);
      $range_dec = ip2long($range);
      $ip_dec = ip2long($ip);

$wildcard_dec = pow(2, (32-$netmask)) - 1;
      $netmask_dec = ~ $wildcard_dec;

return (($ip_dec & $netmask_dec) == ($range_dec & $netmask_dec));
    }
  } else {
    if (strpos($range, '*') !==false) { 
      $lower = str_replace('*', '0', $range);
      $upper = str_replace('*', '255', $range);
      $range = "$lower-$upper";
    }

if (strpos($range, '-')!==false) { // A-B format
      list($lower, $upper) = explode('-', $range, 2);
      $lower_dec = (float)sprintf("%u",ip2long($lower));
      $upper_dec = (float)sprintf("%u",ip2long($upper));
      $ip_dec = (float)sprintf("%u",ip2long($ip));
      return ( ($ip_dec>=$lower_dec) && ($ip_dec<=$upper_dec) );
    }

return false;
  }
}

function getData($url)
{
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0);
    curl_setopt($ch, CURLOPT_TIMEOUT, 60);
    $result = curl_exec($ch);
    curl_close($ch);
    return $result;
}

function getTokens($mysql){
    $tokens = array(
        "subid" => $mysql['click_id'],
        "t202kw" => $mysql['t202kw'],
        "c1" => $mysql['c1'],
        "c2" => $mysql['c2'],
        "c3" => $mysql['c3'],
        "c4" => $mysql['c4'],
        "gclid" => $mysql['gclid'],
        "utm_source" => $mysql['utm_source'],
        "utm_medium" => $mysql['utm_medium'],
        "utm_campaign" => $mysql['utm_campaign'],
        "utm_term" => $mysql['utm_term'],
        "utm_content" => $mysql['utm_content'],
        "cpc" => round($mysql['cpc'], 2),
        "cpc2" => $mysql['cpc'],
        "timestamp" => time(),
        "payout" => $mysql['payout'],
        "random" => mt_rand(1000000, 9999999),
        "referer" => $mysql['referer'],
        "sourceid" => $mysql['ppc_account_id'],
        "transactionid" => $mysql['txid']
    );
    
    return $tokens;
}

Editing: connect2.php

Upload Files

Create New

Change Permissions

Change Date

Rename Item

Confirm Delete