Beispiel #1
0
include_once $_SERVER['DOCUMENT_ROOT'] . '/202-config/connect2.php';
//run script
$mysql['landing_page_id_public'] = $db->real_escape_string($_GET['lpip']);
if (isset($_GET['202vars'])) {
    $mysql['202vars'] = base64_decode($db->real_escape_string($_GET['202vars']));
}
$tracker_sql = "SELECT  aff_campaign_name,\n\t\t\t\t\t\t  aff_campaign_rotate,\n\t\t\t\t\t\t  aff_campaign_url,\n\t\t\t\t\t\t  aff_campaign_url_2,\n\t\t\t\t\t\t  aff_campaign_url_3,\n\t\t\t\t\t\t  aff_campaign_url_4,\n\t\t\t\t\t\t  aff_campaign_url_5\n\t\t\t\tFROM    202_landing_pages LEFT JOIN 202_aff_campaigns USING (aff_campaign_id)\n\t\t\t\tWHERE   landing_page_id_public='" . $mysql['landing_page_id_public'] . "'";
$tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql);
if (!$tracker_row) {
    die;
}
//DONT ESCAPE THE DESITNATIONL URL IT TOTALLY SCREWS UP
$html['aff_campaign_name'] = htmlentities($tracker_row['aff_campaign_name'], ENT_QUOTES, 'UTF-8');
//modify the redirect site url to go through another cloaked link
$redirect_site_url = rotateTrackerUrl($db, $tracker_row);
// get the click id
$click_id = $_COOKIE['tracking202subid'];
$redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id);
if (isset($mysql['202vars'])) {
    $redirect_site_url = setPrePopVars($mysql['202vars'], $redirect_site_url, false);
}
?>

<html>
	<head>
		<title><?php 
echo $html['aff_campaign_name'];
?>
</title>
		<meta name="robots" content="noindex">
Beispiel #2
0
function redirect_process($db, $rule, $ppc_account, $cpc, $rotator_id, $GeoData, $ip_address, $user_id, $IspData, $keyword_type)
{
    $mysql['aff_campaign_id'] = $db->real_escape_string($rule['aff_campaign_id']);
    $mysql['click_cpc'] = $db->real_escape_string($rule['click_cpc']);
    $mysql['click_payout'] = $db->real_escape_string($rule['aff_campaign_payout']);
    $mysql['rule_id'] = $db->real_escape_string($rule['rule_id']);
    $mysql['ppc_account'] = $db->real_escape_string($ppc_account);
    $mysql['cpc'] = $db->real_escape_string($cpc);
    $mysql['click_time'] = time();
    /* ok, if $_GET['OVRAW'] that is a yahoo keyword, if on the REFER, there is a $_GET['q], that is a GOOGLE keyword... */
    //so this is going to check the REFERER URL, for a ?q=, which is the ACUTAL KEYWORD searched.
    $referer_url_parsed = @parse_url($_SERVER['HTTP_REFERER']);
    $referer_url_query = $referer_url_parsed['query'];
    @parse_str($referer_url_query, $referer_query);
    switch ($keyword_type) {
        case "bidded":
            #try to get the bidded keyword first
            if ($_GET['OVKEY']) {
                //if this is a Y! keyword
                $keyword = $db->real_escape_string($_GET['OVKEY']);
            } elseif ($_GET['utm_source']) {
                $keyword = $db->real_escape_string($_GET['utm_source']);
            } elseif ($_GET['t202kw']) {
                $keyword = $db->real_escape_string($_GET['t202kw']);
            } elseif ($referer_query['p']) {
                $keyword = $db->real_escape_string($referer_query['p']);
            } elseif ($_GET['target_passthrough']) {
                //if this is a mediatraffic! keyword
                $keyword = $db->real_escape_string($_GET['target_passthrough']);
            } else {
                //if this is a zango, or more keyword
                $keyword = $db->real_escape_string($_GET['keyword']);
            }
            break;
        case "searched":
            #try to get the searched keyword
            if ($referer_query['q']) {
                $keyword = $db->real_escape_string($referer_query['q']);
            } elseif ($referer_query['p']) {
                $keyword = $db->real_escape_string($referer_query['p']);
            } elseif ($_GET['OVRAW']) {
                //if this is a Y! keyword
                $keyword = $db->real_escape_string($_GET['OVRAW']);
            } elseif ($_GET['target_passthrough']) {
                //if this is a mediatraffic! keyword
                $keyword = $db->real_escape_string($_GET['target_passthrough']);
            } elseif ($_GET['keyword']) {
                //if this is a zango, or more keyword
                $keyword = $db->real_escape_string($_GET['keyword']);
            } elseif ($_GET['search_word']) {
                //if this is a eniro, or more keyword
                $keyword = $db->real_escape_string($_GET['search_word']);
            } elseif ($_GET['query']) {
                //if this is a naver, or more keyword
                $keyword = $db->real_escape_string($_GET['query']);
            } elseif ($_GET['encquery']) {
                //if this is a aol, or more keyword
                $keyword = $db->real_escape_string($_GET['encquery']);
            } elseif ($_GET['terms']) {
                //if this is a about.com, or more keyword
                $keyword = $db->real_escape_string($_GET['terms']);
            } elseif ($_GET['rdata']) {
                //if this is a viola, or more keyword
                $keyword = $db->real_escape_string($_GET['rdata']);
            } elseif ($_GET['qs']) {
                //if this is a virgilio, or more keyword
                $keyword = $db->real_escape_string($_GET['qs']);
            } elseif ($_GET['wd']) {
                //if this is a baidu, or more keyword
                $keyword = $db->real_escape_string($_GET['wd']);
            } elseif ($_GET['text']) {
                //if this is a yandex, or more keyword
                $keyword = $db->real_escape_string($_GET['text']);
            } elseif ($_GET['szukaj']) {
                //if this is a wp.pl, or more keyword
                $keyword = $db->real_escape_string($_GET['szukaj']);
            } elseif ($_GET['qt']) {
                //if this is a O*net, or more keyword
                $keyword = $db->real_escape_string($_GET['qt']);
            } elseif ($_GET['k']) {
                //if this is a yam, or more keyword
                $keyword = $db->real_escape_string($_GET['k']);
            } elseif ($_GET['words']) {
                //if this is a Rambler, or more keyword
                $keyword = $db->real_escape_string($_GET['words']);
            } else {
                $keyword = $db->real_escape_string($_GET['t202kw']);
            }
            break;
    }
    $keyword = str_replace('%20', ' ', $keyword);
    $keyword_id = INDEXES::get_keyword_id($db, $keyword);
    $mysql['keyword_id'] = $db->real_escape_string($keyword_id);
    $c1 = $db->real_escape_string($_GET['c1']);
    $c1 = str_replace('%20', ' ', $c1);
    $c1_id = INDEXES::get_c1_id($db, $c1);
    $mysql['c1_id'] = $db->real_escape_string($c1_id);
    $c2 = $db->real_escape_string($_GET['c2']);
    $c2 = str_replace('%20', ' ', $c2);
    $c2_id = INDEXES::get_c2_id($db, $c2);
    $mysql['c2_id'] = $db->real_escape_string($c2_id);
    $c3 = $db->real_escape_string($_GET['c3']);
    $c3 = str_replace('%20', ' ', $c3);
    $c3_id = INDEXES::get_c3_id($db, $c3);
    $mysql['c3_id'] = $db->real_escape_string($c3_id);
    $c4 = $db->real_escape_string($_GET['c4']);
    $c4 = str_replace('%20', ' ', $c4);
    $c4_id = INDEXES::get_c4_id($db, $c4);
    $mysql['c4_id'] = $db->real_escape_string($c4_id);
    $device_id = PLATFORMS::get_device_info($db, $detect, $_GET['ua']);
    $mysql['platform_id'] = $db->real_escape_string($device_id['platform']);
    $mysql['browser_id'] = $db->real_escape_string($device_id['browser']);
    $mysql['device_id'] = $db->real_escape_string($device_id['device']);
    if ($device_id['type'] == '4') {
        $mysql['click_bot'] = '1';
    }
    $mysql['click_in'] = 1;
    $mysql['click_out'] = 1;
    $ip_id = INDEXES::get_ip_id($db, $ip_address);
    $mysql['ip_id'] = $db->real_escape_string($ip_id);
    $country_id = INDEXES::get_country_id($db, $GeoData['country'], $GeoData['country_code']);
    $mysql['country_id'] = $db->real_escape_string($country_id);
    $region_id = INDEXES::get_region_id($db, $GeoData['region'], $mysql['country_id']);
    $mysql['region_id'] = $db->real_escape_string($region_id);
    $city_id = INDEXES::get_city_id($db, $GeoData['city'], $mysql['country_id']);
    $mysql['city_id'] = $db->real_escape_string($city_id);
    if ($IspData != null) {
        $isp_id = INDEXES::get_isp_id($db, $IspData);
        $mysql['isp_id'] = $db->real_escape_string($isp_id);
    }
    if ($device_id['type'] == '4') {
        $mysql['click_filtered'] = '1';
    } else {
        $click_filtered = FILTER::startFilter($db, $click_id, $ip_id, $ip_address, $user_id);
        $mysql['click_filtered'] = $db->real_escape_string($click_filtered);
    }
    if ($_GET[lpr] != '') {
        $click_sql1 = "\tSELECT \t202_clicks.click_id,keyword,keyword_id\n\t\t\t\t\tFROM \t\t202_clicks\n\t\t\t\t\tLEFT JOIN\t202_clicks_advance USING (click_id)\n\t\t\t\t\tLEFT JOIN \t202_ips USING (ip_id) \n\t\t\t\t\tLEFT JOIN \t202_keywords USING (keyword_id) \n\t\t\t\t\tWHERE \t202_ips.ip_address='" . $ip_address . "'\n\t\t\t\t\tAND\t\t202_clicks.user_id='" . $user_id . "'  \n\t\t\t\t\tAND\t\t202_clicks.click_time >= '30'\n\t\t\t\t\tORDER BY \t202_clicks.click_id DESC \n\t\t\t\t\tLIMIT \t\t1";
        $click_result1 = $db->query($click_sql1) or record_mysql_error($click_sql1);
        $click_row1 = $click_result1->fetch_assoc();
        $mysql['click_id'] = $db->real_escape_string($click_row1['click_id']);
        $keyword = $db->real_escape_string($keyword);
        $keyword_id = $db->real_escape_string($click_row1['keyword_id']);
        $mysql['keyword_id'] = $db->real_escape_string($keyword_id);
    } else {
        //ok we have the main data, now insert this row
        $click_sql = "INSERT INTO  202_clicks_counter SET click_id=DEFAULT";
        $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
        //now gather the info for the advance click insert
        $click_id = $db->insert_id;
        $mysql['click_id'] = $db->real_escape_string($click_id);
    }
    $mysql['click_alp'] = 0;
    $mysql['rotator_id'] = $db->real_escape_string($rotator_id);
    $mysql['user_id'] = $db->real_escape_string($user_id);
    //ok we have the main data, now insert this row
    $click_sql = "REPLACE INTO   202_clicks\n\t\t\t  SET           \tclick_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tuser_id = '" . $mysql['user_id'] . "',   \n\t\t\t\t\t\t\taff_campaign_id = '" . $mysql['aff_campaign_id'] . "',   \n\t\t\t\t\t\t\tppc_account_id = '" . $mysql['ppc_account'] . "',   \n\t\t\t\t\t\t\tclick_cpc = '" . $mysql['cpc'] . "',   \n\t\t\t\t\t\t\tclick_payout = '" . $mysql['click_payout'] . "',   \n\t\t\t\t\t\t\tclick_alp = '" . $mysql['click_alp'] . "',\n\t\t\t\t\t\t\tclick_filtered = '" . $mysql['click_filtered'] . "',\n\t\t\t\t\t\t\tclick_bot = '" . $mysql['click_bot'] . "',\n\t\t\t\t\t\t\tclick_time = '" . $mysql['click_time'] . "',\n\t\t\t\t\t\t\trotator_id = '" . $mysql['rotator_id'] . "',\n\t\t\t\t\t\t\trule_id = '" . $mysql['rule_id'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //ok we have the main data, now insert this row
    $click_sql = "REPLACE INTO   202_clicks_spy\n\t\t\t\t  SET           \tclick_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\t\tuser_id = '" . $mysql['user_id'] . "',   \n\t\t\t\t\t\t\t\taff_campaign_id = '" . $mysql['aff_campaign_id'] . "',   \n\t\t\t\t\t\t\t\tppc_account_id = '" . $mysql['ppc_account'] . "',   \n\t\t\t\t\t\t\t\tclick_cpc = '" . $mysql['cpc'] . "',   \n\t\t\t\t\t\t\t\tclick_payout = '" . $mysql['click_payout'] . "',   \n\t\t\t\t\t\t\t\tclick_filtered = '" . $mysql['click_filtered'] . "',\n\t\t\t\t\t\t\t\tclick_bot = '" . $mysql['click_bot'] . "',\n\t\t\t\t\t\t\t\tclick_alp = '" . $mysql['click_alp'] . "',\n\t\t\t\t\t\t\t\tclick_time = '" . $mysql['click_time'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //now we have the click's advance data, now insert this row
    $click_sql = "REPLACE INTO   202_clicks_advance\n\t\t\t  SET           click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\ttext_ad_id='" . $mysql['text_ad_id'] . "',\n\t\t\t\t\t\t\tkeyword_id='" . $mysql['keyword_id'] . "',\n\t\t\t\t\t\t\tip_id='" . $mysql['ip_id'] . "',\n\t\t\t\t\t\t\tcountry_id='" . $mysql['country_id'] . "',\n\t\t\t\t\t\t\tregion_id='" . $mysql['region_id'] . "',\n\t\t\t\t\t\t\tisp_id='" . $mysql['isp_id'] . "',\n\t\t\t\t\t\t\tcity_id='" . $mysql['city_id'] . "',\n\t\t\t\t\t\t\tplatform_id='" . $mysql['platform_id'] . "',\n\t\t\t\t\t\t\tbrowser_id='" . $mysql['browser_id'] . "',\n\t\t\t\t\t\t\tdevice_id='" . $mysql['device_id'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //insert the tracking data
    $click_sql = "\n\tREPLACE INTO\n\t\t202_clicks_tracking\n\tSET\n\t\tclick_id='" . $mysql['click_id'] . "',\n\t\tc1_id = '" . $mysql['c1_id'] . "',\n\t\tc2_id = '" . $mysql['c2_id'] . "',\n\t\tc3_id = '" . $mysql['c3_id'] . "',\n\t\tc4_id = '" . $mysql['c4_id'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //now gather variables for the clicks record db
    //lets determine if cloaking is on
    if ($rule['aff_campaign_cloaking'] == 1) {
        $cloaking_on = true;
        $mysql['click_cloaking'] = 1;
        //if cloaking is on, add in a click_id_public, because we will be forwarding them to a cloaked /cl/xxxx link
        $click_id_public = rand(1, 9) . $click_id . rand(1, 9);
        $mysql['click_id_public'] = $db->real_escape_string($click_id_public);
    } else {
        $mysql['click_cloaking'] = 0;
    }
    //ok we have our click recorded table, now lets insert theses
    $click_sql = "REPLACE INTO   202_clicks_record\n\t\t\t  SET           click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_id_public='" . $mysql['click_id_public'] . "',\n\t\t\t\t\t\t\tclick_cloaking='" . $mysql['click_cloaking'] . "',\n\t\t\t\t\t\t\tclick_in='" . $mysql['click_in'] . "',\n\t\t\t\t\t\t\tclick_out='" . $mysql['click_out'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //now lets get variables for clicks site
    //so this is going to check the REFERER URL, for a ?url=, which is the ACUTAL URL, instead of the google content, pagead2.google....
    if ($referer_query['url']) {
        $click_referer_site_url_id = INDEXES::get_site_url_id($db, $referer_query['url']);
    } else {
        $click_referer_site_url_id = INDEXES::get_site_url_id($db, $_SERVER['HTTP_REFERER']);
    }
    $mysql['click_referer_site_url_id'] = $db->real_escape_string($click_referer_site_url_id);
    $outbound_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
    $click_outbound_site_url_id = INDEXES::get_site_url_id($db, $outbound_site_url);
    $mysql['click_outbound_site_url_id'] = $db->real_escape_string($click_outbound_site_url_id);
    if ($cloaking_on == true) {
        $cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . '/tracking202/redirect/cl.php?pci=' . $click_id_public;
    }
    if ($rule['aff_campaign_id'] != null) {
        //rotate the urls
        $redirect_site_url = rotateTrackerUrl($db, $rule);
    } else {
        if ($rule['default_url'] != null) {
            $redirect_site_url = $rule['default_url'];
        } elseif ($rule['redirect_url'] != null) {
            $redirect_site_url = $rule['redirect_url'];
        }
    }
    $redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id);
    $click_redirect_site_url_id = INDEXES::get_site_url_id($db, $redirect_site_url);
    $mysql['click_redirect_site_url_id'] = $db->real_escape_string($click_redirect_site_url_id);
    //insert this
    $click_sql = "REPLACE INTO   202_clicks_site\n\t\t\t  SET           click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_referer_site_url_id='" . $mysql['click_referer_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'";
    $click_result = $db->query($click_sql) or record_mysql_error($db, $click_sql);
    //update the click summary table
    $now = time();
    $today_day = date('j', time());
    $today_month = date('n', time());
    $today_year = date('Y', time());
    //the click_time is recorded in the middle of the day
    $click_time = mktime(12, 0, 0, $today_month, $today_day, $today_year);
    $mysql['click_time'] = $db->real_escape_string($click_time);
    //check to make sure this click_summary doesn't already exist
    $check_sql = "SELECT  *\n\t\t\t\t  FROM    202_summary_overview\n\t\t\t\t  WHERE   user_id='" . $mysql['user_id'] . "'\n\t\t\t\t  AND     aff_campaign_id='" . $mysql['aff_campaign_id'] . "'\n\t\t\t\t  AND     ppc_account_id='" . $mysql['ppc_account'] . "'\n\t\t\t\t  AND     click_time='" . $mysql['click_time'] . "'";
    $check_result = $db->query($check_sql) or record_mysql_error($db, $check_sql);
    $check_count = $check_result->num_rows;
    //if this click summary hasn't been recorded do this now
    if ($check_count == 0) {
        $insert_sql = "INSERT INTO 202_summary_overview\n\t\t\t\t\t   SET         user_id='" . $mysql['user_id'] . "',\n\t\t\t\t\t\t\t\t   aff_campaign_id='" . $mysql['aff_campaign_id'] . "',\n\t\t\t\t\t\t\t\t   ppc_account_id='" . $mysql['ppc_account'] . "',\n\t\t\t\t\t\t\t\t   click_time='" . $mysql['click_time'] . "'";
        $insert_result = $db->query($insert_sql);
    }
    if ($rule['aff_campaign_id'] != null) {
        //set the cookie
        setClickIdCookie($mysql['click_id'], $rule['aff_campaign_id']);
    }
    //now we've recorded, now lets redirect them
    if ($cloaking_on == true) {
        //if cloaked, redirect them to the cloaked site.
        return $cloaking_site_url;
    } else {
        return $redirect_site_url;
    }
}
Beispiel #3
0
if ($info_row['click_cloaking'] == 1 or $info_row['click_cloaking'] == -1 and $info_row['aff_campaign_cloaking'] == 1 or !isset($info_row['click_cloaking']) and $info_row['aff_campaign_cloaking'] == 1) {
    $cloaking_on = true;
    $mysql['click_cloaking'] = 1;
    // if cloaking is on, add in a click_id_public, because we will be forwarding them to a cloaked /cl/xxxx link
} else {
    $mysql['click_cloaking'] = 0;
}
$update_sql = "\n\tUPDATE\n\t\t202_clicks_record\n\tSET\n\t\tclick_out='" . $mysql['click_out'] . "',\n\t\tclick_cloaking='" . $mysql['click_cloaking'] . "'\n\tWHERE\n\t\tclick_id='" . $mysql['click_id'] . "'\n";
delay_sql($db, $update_sql);
$outbound_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($db, $outbound_site_url);
$mysql['click_outbound_site_url_id'] = $db->real_escape_string($click_outbound_site_url_id);
if ($cloaking_on == true) {
    $cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
}
$redirect_site_url = rotateTrackerUrl($db, $info_row);
$redirect_site_url = replaceTrackerPlaceholders($db, $redirect_site_url, $click_id);
$click_redirect_site_url_id = INDEXES::get_site_url_id($db, $redirect_site_url);
$mysql['click_redirect_site_url_id'] = $db->real_escape_string($click_redirect_site_url_id);
$update_sql = "\n\tUPDATE\n\t\t202_clicks_site\n\tSET\n\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'\n\tWHERE\n\t\tclick_id='" . $mysql['click_id'] . "'\n";
delay_sql($db, $update_sql);
// alright now the updates,
// WE WANT TO DELAY THESES UPDATES, in a MYSQL DATBASES? Or else the UPDATES lag the server, the UPDATES have to wait until it locks to update the server
// so what happens is if there not delayed, if someone is pulling MASSIVE queries on the t202 website, it'll wait till they load before our update runs,
// and that means if this update wasn't delayed it'd wait untill their queries were done on the site before moving forward. Massive slowness, so we update delays theses in cronjobs a at a lter time.
// ADD TO CLICK SUMMARY TABLE?
// update the click summary table if this is a 'real click'
// if ($info_row['click_filtered'] == 0) {
$mysql['landing_page_id'] = $db->real_escape_string($info_row['landing_page_id']);
$mysql['user_id'] = $db->real_escape_string($info_row['user_id']);
// set timezone correctly
Beispiel #4
0
}
$update_sql = "UPDATE \t202_clicks_record\n\t\t\t\tSET\t\t\tclick_out='" . $mysql['click_out'] . "',\n\t\t\t\t\t\t\tclick_cloaking='" . $mysql['click_cloaking'] . "'\n\t\t\t\tWHERE\t\tclick_id='" . $mysql['click_id'] . "'";
delay_sql($update_sql);
//clicks_site
//	click_outbound_site_url_id='".$mysql['click_outbound_site_url_id']."',
//	click_cloaking_site_url_id='".$mysql['click_cloaking_site_url_id']."',
//	click_redirect_site_url_id='".$mysql['click_redirect_site_url_id']."'";
$outbound_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($outbound_site_url);
$mysql['click_outbound_site_url_id'] = mysql_real_escape_string($click_outbound_site_url_id);
if ($cloaking_on == true) {
    $cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
    $click_cloaking_site_url_id = INDEXES::get_site_url_id($cloaking_site_url);
    $mysql['click_cloaking_site_url_id'] = mysql_real_escape_string($click_cloaking_site_url_id);
}
$url = rotateTrackerUrl($info_row);
$redirect_site_url = $url . $info_row['click_id'];
$click_redirect_site_url_id = INDEXES::get_site_url_id($redirect_site_url);
$mysql['click_redirect_site_url_id'] = mysql_real_escape_string($click_redirect_site_url_id);
$update_sql = "UPDATE \t202_clicks_site\n\t\t\t\tSET\t\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_cloaking_site_url_id='" . $mysql['click_cloaking_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'\n\t\t\t\tWHERE\t\tclick_id='" . $mysql['click_id'] . "'";
delay_sql($update_sql);
//alright now the updates,
//WE WANT TO DELAY THESES UPDATES, in a MYSQL DATBASES? Or else the UPDATES lag the server, the UPDATES have to wait until it locks to update the server
//so what happens is if there not delayed, if someone is pulling MASSIVE queries on the website, it'll wait till they load before our update runs,
//and that means if this update wasn't delayed it'd wait untill their queries were done on the site before moving forward.  Massive slowness, so we update delays theses in  cronjobs a at a lter time.
//ADD TO CLICK SUMMARY TABLE?
//update the click summary table if this is a 'real click'
if ($info_row['click_filtered'] == 0) {
    $mysql['landing_page_id'] = mysql_real_escape_string($info_row['landing_page_id']);
    $mysql['user_id'] = mysql_real_escape_string($info_row['user_id']);
    //set timezone correctly
Beispiel #5
0
if ($referer_query['url']) {
    $click_referer_site_url_id = INDEXES::get_site_url_id($referer_query['url']);
} else {
    $click_referer_site_url_id = INDEXES::get_site_url_id($_SERVER['HTTP_REFERER']);
}
$mysql['click_referer_site_url_id'] = mysql_real_escape_string($click_referer_site_url_id);
$outbound_site_url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($outbound_site_url);
$mysql['click_outbound_site_url_id'] = mysql_real_escape_string($click_outbound_site_url_id);
if ($cloaking_on == true) {
    $cloaking_site_url = 'http://' . $_SERVER['SERVER_NAME'] . '/redirect/cl.php?pci=' . $click_id_public;
    $click_cloaking_site_url_id = INDEXES::get_site_url_id($cloaking_site_url);
    $mysql['click_cloaking_site_url_id'] = mysql_real_escape_string($click_cloaking_site_url_id);
}
//rotate the urls
$url = rotateTrackerUrl($tracker_row);
$redirect_site_url = $url . $click_id;
$click_redirect_site_url_id = INDEXES::get_site_url_id($redirect_site_url);
$mysql['click_redirect_site_url_id'] = mysql_real_escape_string($click_redirect_site_url_id);
//insert this
$click_sql = "INSERT INTO   202_clicks_site\n\t\t\t  SET           click_id='" . $mysql['click_id'] . "',\n\t\t\t\t\t\t\tclick_referer_site_url_id='" . $mysql['click_referer_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_outbound_site_url_id='" . $mysql['click_outbound_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_cloaking_site_url_id='" . $mysql['click_cloaking_site_url_id'] . "',\n\t\t\t\t\t\t\tclick_redirect_site_url_id='" . $mysql['click_redirect_site_url_id'] . "'";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);
//update the click summary table if this is a 'real click'
#if ($click_filtered == 0) {
$now = time();
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
//the click_time is recorded in the middle of the day
$click_time = mktime(12, 0, 0, $today_month, $today_day, $today_year);
$mysql['click_time'] = mysql_real_escape_string($click_time);