function get_c4_id($c4)
{
global $memcacheWorking, $memcache;
//only grab the first 350 charactesr of c4
$c4 = substr($c4, 0, 350);
if ($memcacheWorking) {
//get from memcached
$getc4 = $memcache->get(md5("c4-id" . $c4 . systemHash()));
if ($getc4) {
return $getc4;
} else {
$database = DB::getInstance();
$db = $database->getConnection();
$mysql['c4'] = $db->real_escape_string($c4);
$c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($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 = $memcache->set(md5("c4-id" . $c4 . systemHash()), $c4_id, false);
return $c4_id;
} else {
$c4_sql = "INSERT INTO 202_tracking_c4 SET c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($c4_sql);
//($c4_sql);
$c4_id = $db->insert_id;
$setID = $memcache->set(md5("c4-id" . $c4 . systemHash()), $c4_id, false);
return $c4_id;
}
}
} else {
$database = DB::getInstance();
$db = $database->getConnection();
$mysql['c4'] = $db->real_escape_string($c4);
$c4_sql = "SELECT c4_id FROM 202_tracking_c4 WHERE c4='" . $mysql['c4'] . "'";
$c4_result = _mysqli_query($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($c4_sql);
//($c4_sql);
$c4_id = $db->insert_id;
return $c4_id;
}
}
}
header('location: ' . $new_url);
die;
}
}
die("<h2>Error establishing a database connection - please contact the webhost</h2>");
}
//grab tracker data
$mysql['tracker_id_public'] = $db->real_escape_string($t202id);
$tracker_sql = "SELECT 202_trackers.user_id,\n\t\t\t\t\t\t202_trackers.aff_campaign_id,\n\t\t\t\t\t\ttext_ad_id,\n\t\t\t\t\t\tppc_account_id,\n\t\t\t\t\t\tclick_cpc,\n\t\t\t\t\t\tclick_cloaking,\n\t\t\t\t\t\taff_campaign_rotate,\n\t\t\t\t\t\taff_campaign_url,\n\t\t\t\t\t\taff_campaign_url_2,\n\t\t\t\t\t\taff_campaign_url_3,\n\t\t\t\t\t\taff_campaign_url_4,\n\t\t\t\t\t\taff_campaign_url_5,\n\t\t\t\t\t\taff_campaign_payout,\n\t\t\t\t\t\taff_campaign_cloaking\n\t\t\t\tFROM 202_trackers \n\t\t\t\tLEFT JOIN 202_aff_campaigns USING (aff_campaign_id) \n\t\t\t\tWHERE tracker_id_public='" . $mysql['tracker_id_public'] . "'";
$tracker_row = memcache_mysql_fetch_assoc($db, $tracker_sql);
if ($memcacheWorking) {
$url = $tracker_row['aff_campaign_url'];
$tid = $t202id;
$getKey = $memcache->get(md5('url_' . $tid . systemHash()));
if ($getKey === false) {
$setUrl = $memcache->set(md5('url_' . $tid . systemHash()), $url, false, 0);
}
}
//set the timezone to the users timezone
$mysql['user_id'] = $db->real_escape_string($tracker_row['user_id']);
$user_sql = "\n\tSELECT\n\t\tuser_timezone, \n\t\tuser_keyword_searched_or_bidded,\n\t\tmaxmind_isp \n\tFROM\n\t\t202_users\n\t\tLEFT JOIN 202_users_pref USING (user_id)\n\tWHERE\n\t\t202_users.user_id='" . $mysql['user_id'] . "'\n";
$user_row = memcache_mysql_fetch_assoc($db, $user_sql);
//now this sets it
AUTH::set_timezone($user_row['user_timezone']);
if (!$tracker_row) {
die;
}
//get mysql variables
$mysql['aff_campaign_id'] = $db->real_escape_string($tracker_row['aff_campaign_id']);
$mysql['ppc_account_id'] = $db->real_escape_string($tracker_row['ppc_account_id']);
$mysql['click_cpc'] = $db->real_escape_string($tracker_row['click_cpc']);
if ($count == count($rotate)) {
$default = false;
$redirect = redirect_process($db, $rule, $rotator_row['ppc_account_id'], $rotator_row['click_cpc'], $rotator_row['rotator_id'], $GeoData, $ip_address, $user_id, $IspData, $user_keyword_searched_or_bidded);
header('location: ' . $redirect);
die;
} else {
$default = true;
}
}
if ($default == true) {
$default = redirect_process($db, $rotator_row, $rotator_row['ppc_account_id'], $rotator_row['click_cpc'], $rotator_row['rotator_id'], $GeoData, $ip_address, $user_id, $IspData, $user_keyword_searched_or_bidded);
if ($usedCachedRedirect == true) {
if ($memcacheWorking) {
$getUrl = $memcache->get(md5("default_url" . $tracker_id . systemHash()));
if (!$getUrl) {
$memcache->set(md5('default_url' . $tracker_id . systemHash()), $default, false, 0);
}
}
}
header('location: ' . $default);
die;
}
//Redirect process function
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);
