getConnection(); global $server_row; // record the mysql error $clean['mysql_error_text'] = mysqli_error($db); // if on dev server, echo the error echo $sql . '

' . $clean['mysql_error_text'] . '

'; 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 = 'A mysql error has been reported

time: ' . date('r', time()) . '
server_name: ' . $_SERVER['SERVER_NAME'] . '

user_id: ' . $_SESSION['user_id'] . '
script_url: ' . $site_url . '
$_SERVER: ' . serialize($_SERVER) . '

. . . . . . . .

_mysqli_query: ' . $sql . '

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 ?>

A database error has occured, the webmaster has been notified

If this error persists, you may email us directly: %s',$_SERVER['SERVER_ADMIN'],$_SERVER['SERVER_ADMIN']); ?>

= 0) { $new_amount = $currency_before . number_format($amount, $decimals) . $currency_after; } else { $new_amount = $currency_before . number_format($amount, $decimals) . $currency_after; $new_amount = '(' . $new_amount . ')'; } } else { $new_amount = $currency_before . $currency_after; } return $new_amount; } function display_calendar($page, $show_time, $show_adv, $show_bottom, $show_limit, $show_breakdown, $show_type, $show_cpc_or_cpv = true, $show_adv_breakdown = false) { global $navigation; $database = DB::getInstance(); $db = $database->getConnection(); AUTH::set_timezone($_SESSION['user_timezone']); $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT * FROM 202_users_pref WHERE user_id=" . $mysql['user_id']; $user_result = _mysqli_query($user_sql); $user_row = $user_result->fetch_assoc(); $html['user_pref_aff_network_id'] = htmlentities($user_row['user_pref_aff_network_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_aff_campaign_id'] = htmlentities($user_row['user_pref_aff_campaign_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_text_ad_id'] = htmlentities($user_row['user_pref_text_ad_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_method_of_promotion'] = htmlentities($user_row['user_pref_method_of_promotion'], ENT_QUOTES, 'UTF-8'); $html['user_pref_landing_page_id'] = htmlentities($user_row['user_pref_landing_page_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_ppc_network_id'] = htmlentities($user_row['user_pref_ppc_network_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_ppc_account_id'] = htmlentities($user_row['user_pref_ppc_account_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_1'] = htmlentities($user_row['user_pref_group_1'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_2'] = htmlentities($user_row['user_pref_group_2'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_3'] = htmlentities($user_row['user_pref_group_3'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_4'] = htmlentities($user_row['user_pref_group_4'], ENT_QUOTES, 'UTF-8'); $time = grab_timeframe(); $html['from'] = date('m/d/Y', $time['from']); $html['to'] = date('m/d/Y', $time['to']); $html['ip'] = htmlentities($user_row['user_pref_ip'], ENT_QUOTES, 'UTF-8'); if($user_row['user_pref_subid'] != '0' && !empty($user_row['user_pref_subid'])){ $html['subid'] = htmlentities($user_row['user_pref_subid'], ENT_QUOTES, 'UTF-8'); } else{ $html['subid'] = ''; } $html['user_pref_country_id'] = htmlentities($user_row['user_pref_country_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_region_id'] = htmlentities($user_row['user_pref_region_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_isp_id'] = htmlentities($user_row['user_pref_isp_id'], ENT_QUOTES, 'UTF-8'); $html['referer'] = htmlentities($user_row['user_pref_referer'], ENT_QUOTES, 'UTF-8'); $html['keyword'] = htmlentities($user_row['user_pref_keyword'], ENT_QUOTES, 'UTF-8'); $html['page'] = htmlentities($page, ENT_QUOTES, 'UTF-8'); $html['user_pref_device_id'] = htmlentities($user_row['user_pref_device_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_browser_id'] = htmlentities($user_row['user_pref_browser_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_platform_id'] = htmlentities($user_row['user_pref_platform_id'], ENT_QUOTES, 'UTF-8'); ?>

Refine your search:

Start date:

End date:

Loading stats...

getConnection(); AUTH::set_timezone($_SESSION['user_timezone']); $filterEngine = new FilterEngine; $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT * FROM 202_users_pref WHERE user_id=" . $mysql['user_id']; $user_result = _mysqli_query($user_sql); $user_row = $user_result->fetch_assoc(); // print_r($user_row); $html['user_pref_aff_network_id'] = htmlentities($user_row['user_pref_aff_network_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_aff_campaign_id'] = htmlentities($user_row['user_pref_aff_campaign_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_text_ad_id'] = htmlentities($user_row['user_pref_text_ad_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_method_of_promotion'] = htmlentities($user_row['user_pref_method_of_promotion'], ENT_QUOTES, 'UTF-8'); $html['user_pref_landing_page_id'] = htmlentities($user_row['user_pref_landing_page_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_ppc_network_id'] = htmlentities($user_row['user_pref_ppc_network_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_ppc_account_id'] = htmlentities($user_row['user_pref_ppc_account_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_1'] = htmlentities($user_row['user_pref_group_1'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_2'] = htmlentities($user_row['user_pref_group_2'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_3'] = htmlentities($user_row['user_pref_group_3'], ENT_QUOTES, 'UTF-8'); $html['user_pref_group_4'] = htmlentities($user_row['user_pref_group_4'], ENT_QUOTES, 'UTF-8'); $time = grab_timeframe(); $html['from'] = date('m/d/Y', $time['from']); $html['to'] = date('m/d/Y', $time['to']); $html['ip'] = htmlentities($user_row['user_pref_ip'], ENT_QUOTES, 'UTF-8'); if($user_row['user_pref_subid'] != '0' && !empty($user_row['user_pref_subid'])){ $html['subid'] = htmlentities($user_row['user_pref_subid'], ENT_QUOTES, 'UTF-8'); } else{ $html['subid'] = ''; } $html['filter_name1'] = htmlentities($filterEngine->getFilter('filter_name',1), ENT_QUOTES, 'UTF-8'); $html['filter_name2'] = htmlentities($filterEngine->getFilter('filter_name',2), ENT_QUOTES, 'UTF-8'); $html['filter_name3'] = htmlentities($filterEngine->getFilter('filter_name',3), ENT_QUOTES, 'UTF-8'); $html['filter_condition1'] = htmlentities($filterEngine->getFilter('filter_condition',1), ENT_QUOTES, 'UTF-8'); $html['filter_condition2'] = htmlentities($filterEngine->getFilter('filter_condition',2), ENT_QUOTES, 'UTF-8'); $html['filter_condition3'] = htmlentities($filterEngine->getFilter('filter_condition',3), ENT_QUOTES, 'UTF-8'); $html['filter_value1'] = htmlentities($filterEngine->getFilter('filter_value',1), ENT_QUOTES, 'UTF-8'); $html['filter_value2'] = htmlentities($filterEngine->getFilter('filter_value',2), ENT_QUOTES, 'UTF-8'); $html['filter_value3'] = htmlentities($filterEngine->getFilter('filter_value',3), ENT_QUOTES, 'UTF-8'); $html['user_pref_country_id'] = htmlentities($user_row['user_pref_country_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_region_id'] = htmlentities($user_row['user_pref_region_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_isp_id'] = htmlentities($user_row['user_pref_isp_id'], ENT_QUOTES, 'UTF-8'); $html['referer'] = htmlentities($user_row['user_pref_referer'], ENT_QUOTES, 'UTF-8'); $html['keyword'] = htmlentities($user_row['user_pref_keyword'], ENT_QUOTES, 'UTF-8'); $html['page'] = htmlentities($page, ENT_QUOTES, 'UTF-8'); $html['user_pref_device_id'] = htmlentities($user_row['user_pref_device_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_browser_id'] = htmlentities($user_row['user_pref_browser_id'], ENT_QUOTES, 'UTF-8'); $html['user_pref_platform_id'] = htmlentities($user_row['user_pref_platform_id'], ENT_QUOTES, 'UTF-8'); ?>

Refine your search:

Start date:

End date:

Loading stats...

getConnection(); $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT user_pref_time_predefined, user_pref_time_from, user_pref_time_to FROM 202_users_pref WHERE user_id='" . $mysql['user_id'] . "'"; $user_result = _mysqli_query($user_sql); ; // ($user_sql); $user_row = $user_result->fetch_assoc(); if (($user_row['user_pref_time_predefined'] == 'today') or ($user_row['pref_time_from'] != '')) { $time['from'] = mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time())); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'yesterday') { $time['from'] = mktime(0, 0, 0, date('m', time() - 86400), date('d', time() - 86400), date('Y', time() - 86400)); $time['to'] = mktime(23, 59, 59, date('m', time() - 86400), date('d', time() - 86400), date('Y', time() - 86400)); } if ($user_row['user_pref_time_predefined'] == 'last7') { $time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 7), date('d', time() - 86400 * 7), date('Y', time() - 86400 * 7)); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'last14') { $time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 14), date('d', time() - 86400 * 14), date('Y', time() - 86400 * 14)); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'last30') { $time['from'] = mktime(0, 0, 0, date('m', time() - 86400 * 30), date('d', time() - 86400 * 30), date('Y', time() - 86400 * 30)); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'thismonth') { $time['from'] = mktime(0, 0, 0, date('m', time()), 1, date('Y', time())); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'lastmonth') { $time['from'] = mktime(0, 0, 0, date('m', time() - 2629743), 1, date('Y', time() - 2629743)); $time['to'] = mktime(23, 59, 59, date('m', time() - 2629743), getLastDayOfMonth(date('m', time() - 2629743), date('Y', time() - 2629743)), date('Y', time() - 2629743)); } if ($user_row['user_pref_time_predefined'] == 'thisyear') { $time['from'] = mktime(0, 0, 0, 1, 1, date('Y', time())); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == 'lastyear') { $time['from'] = mktime(0, 0, 0, 1, 1, date('Y', time() - 31556926)); $time['to'] = mktime(0, 0, 0, 12, getLastDayOfMonth(date('m', time() - 31556926), date('Y', time() - 31556926)), date('Y', time() - 31556926)); } if ($user_row['user_pref_time_predefined'] == 'alltime') { // for the time from, do something special select the exact date this user was registered and use that :) $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user2_sql = "SELECT user_time_register FROM 202_users WHERE user_id='" . $mysql['user_id'] . "'"; $user2_result = $db->query($user2_sql) or record_mysql_error($user2_sql); $user2_row = $user2_result->fetch_assoc(); $time['from'] = $user2_row['user_time_register']; $time['from'] = mktime(0, 0, 0, date('m', $time['from']), date('d', $time['from']), date('Y', $time['from'])); $time['to'] = mktime(23, 59, 59, date('m', time()), date('d', time()), date('Y', time())); } if ($user_row['user_pref_time_predefined'] == '') { $time['from'] = $user_row['user_pref_time_from']; $time['to'] = $user_row['user_pref_time_to']; } $time['user_pref_time_predefined'] = $user_row['user_pref_time_predefined']; return $time; } function getLastDayOfMonth($month, $year) { return date("d", mktime(0, 0, 0, $month + 1, 0, $year)); } function getTrackingDomain() { $database = DB::getInstance(); $db = $database->getConnection(); $tracking_domain_sql = " SELECT `user_tracking_domain` FROM `202_users_pref` WHERE `user_id`='" . $db->real_escape_string($_SESSION['user_id']) . "' "; $tracking_domain_result = _mysqli_query($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; } // the above, if true, are options to turn on specific filtering techniques. function query($command, $db_table, $pref_time, $pref_adv, $pref_show, $pref_order, $offset, $pref_limit, $count, $isspy = false) { $database = DB::getInstance(); $db = $database->getConnection(); // grab user preferences $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT * FROM 202_users_pref WHERE user_id='" . $mysql['user_id'] . "'"; $user_result = _mysqli_query($user_sql); // ($user_sql); $user_row = $user_result->fetch_assoc(); $count_sql = "SELECT count(*) AS count FROM 202_dataengine AS 2c "; $theWheres = ''; // do extra joins if advance selector is enabled if ($pref_adv == true) { // if ppc network lookup with no individual ppc network account lookup do this if ($user_row['user_pref_ppc_network_id'] and ! ($user_row['user_pref_ppc_account_id'])) { if (! preg_match('/202_ppc_accounts/', $command)) { $command .= " LEFT JOIN 202_ppc_accounts AS 2pa ON (2c.ppc_account_id = 2pa.ppc_account_id) "; } if (! preg_match('/202_ppc_networks/', $command)) { $command .= " LEFT JOIN 202_ppc_networks AS 2pn ON (2pa.ppc_network_id = 2pn.ppc_network_id) "; } $theWheres .= " LEFT JOIN 202_ppc_accounts AS 2pa ON (2c.ppc_account_id = 2pa.ppc_account_id) "; $theWheres .= " LEFT JOIN 202_ppc_networks AS 2pn ON (2pa.ppc_network_id = 2pn.ppc_network_id) "; } // if aff network lookup with no individual aff campaign lookup do this if ($user_row['user_pref_aff_network_id'] and ! ($user_row['user_pref_aff_campaign_id'])) { if (! preg_match('/202_aff_campaigns/', $command)) { $command .= " LEFT JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) "; } if (! preg_match('/202_aff_networks/', $command)) { $command .= " LEFT JOIN 202_aff_networks AS 2an ON (2ac.aff_network_id = 2an.aff_network_id) "; } $theWheres .= " LEFT JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) "; $theWheres .= " LEFT JOIN 202_aff_networks AS 2an ON (2ac.aff_network_id = 2an.aff_network_id) "; } // if domain lookup if ($user_row['user_pref_referer']) { if (! preg_match('/202_clicks_site/', $command)) { $command .= " LEFT JOIN 202_clicks_site AS 2cs ON (2c.click_id = 2cs.click_id) "; } if (! preg_match('/202_site_urls/', $command)) { $command .= " LEFT JOIN 202_site_urls AS 2su ON (2cs.click_referer_site_url_id = 2su.site_url_id) "; } if (! preg_match('/202_site_domains/', $command)) { $command .= " LEFT JOIN 202_site_domains AS 2sd ON (2su.site_domain_id = 2sd.site_domain_id) "; } $count_sql .= " LEFT JOIN 202_clicks_site AS 2cs ON (2c.click_id = 2cs.click_id) "; $count_sql .= " LEFT JOIN 202_site_urls AS 2su ON (2cs.click_referer_site_url_id = 2su.site_url_id) "; // $count_sql .= " LEFT JOIN 202_site_domains AS 2sd ON (2su.site_domain_id = 2sd.site_domain_id) "; $theWheres .= " LEFT JOIN 202_clicks_site AS 2cs ON (2c.click_id = 2cs.click_id) "; $theWheres .= " LEFT JOIN 202_site_urls AS 2su ON (2cs.click_referer_site_url_id = 2su.site_url_id) "; // $theWheres .= " LEFT JOIN 202_site_domains AS 2sd ON (2su.site_domain_id = 2sd.site_domain_id) "; } // if there is a keyword lookup, and we have not joined the 202 keywords table. do so now if ($user_row['user_pref_keyword']) { if (! preg_match('/202_keywords/', $command)) { $command .= " LEFT JOIN 202_keywords AS 2k ON (2ca.keyword_id = 2k.keyword_id) "; } $count_sql .= " LEFT JOIN 202_keywords AS 2k ON (2c.keyword_id = 2k.keyword_id) "; } // if there is a ip lookup, and we have not joined the 202 ip table. do so now if ($user_row['user_pref_ip']) { if (! preg_match('/202_ips/', $command)) { $command .= " LEFT JOIN 202_ips AS 2i ON (2ca.ip_id = 2i.ip_id) "; } $count_sql .= " LEFT JOIN 202_ips AS 2i ON (2c.ip_id = 2i.ip_id) "; } // if there is a country lookup, and we have not joined the 202 country table. do so now if ($user_row['user_pref_country_id'] and ! preg_match('/202_locations_country/', $command)) { $command .= " LEFT JOIN 202_locations_country AS 2cy ON (2ca.country_id = 2cy.country_id) "; } // if there is a region lookup, and we have not joined the 202 region table. do so now if ($user_row['user_pref_region_id'] and ! preg_match('/202_locations_region/', $command)) { $command .= " LEFT JOIN 202_locations_region AS 2rg ON (2ca.region_id = 2rg.region_id) "; } // if there is a isp lookup, and we have not joined the 202 isp table. do so now if ($user_row['user_pref_isp_id'] and ! preg_match('/202_locations_isp/', $command)) { $command .= " LEFT JOIN 202_locations_isp AS 2is ON (2ca.isp_id = 2is.isp_id) "; } // if there is a device lookup, and we have not joined the 202 device table. do so now if ($user_row['user_pref_device_id']) { if (! preg_match('/202_device_models/', $command)) { $command .= " LEFT JOIN 202_device_models AS 2d ON (2ca.device_id = 2d.device_id) "; } $count_sql .= " LEFT JOIN 202_device_models AS 2d ON (2c.device_id = 2d.device_id) "; } // if there is a browser lookup, and we have not joined the 202 browser table. do so now if ($user_row['user_pref_browser_id'] and ! preg_match('/202_browsers/', $command)) { $command .= " LEFT JOIN 202_browsers AS 2b ON (2ca.browser_id = 2b.browser_id) "; } // if there is a platform lookup, and we have not joined the 202 platform table. do so now if ($user_row['user_pref_platform_id'] and ! preg_match('/202_platforms/', $command)) { $command .= " LEFT JOIN 202_platforms AS 2p ON (2ca.platform_id = 2p.platform_id) "; } } if($_SESSION['publisher']==false){ //user is able to see all camapigns $click_sql = $command . " WHERE $db_table.user_id!='0' "; $count_where .= " WHERE $db_table.user_id!='0' "; } else{ $click_sql = $command . " WHERE $db_table.user_id='" . $_SESSION['user_own_id'] . "' "; //user can only see thier campaigns $count_where .= " WHERE $db_table.user_id='" .$_SESSION['user_own_id'] . "' "; } if ($user_row['user_pref_subid']) { $mysql['user_landing_subid'] = $db->real_escape_string($user_row['user_pref_subid']); $click_sql .= " AND 2c.click_id='" . $mysql['user_landing_subid'] . "'"; } // set show preferences if ($pref_show == true) { if ($user_row['user_pref_show'] == 'filtered') { $click_sql .= " AND click_filtered='1' "; $count_where .= " AND click_filtered='1' "; } elseif ($user_row['user_pref_show'] == 'real') { $click_sql .= " AND click_filtered='0' "; $count_where .= " AND click_filtered='0' "; } elseif ($user_row['user_pref_show'] == 'leads') { $click_sql .= " AND click_filtered='0' AND click_lead='1' "; $count_where .= " AND click_filtered='0' AND click_lead='1' "; } elseif ($user_row['user_pref_show'] == 'filtered_bot') { $click_sql .= " AND click_bot='1'"; $count_where .= " AND click_bot='1'"; } } // set advanced preferences if ($pref_adv == true) { if ($user_row['user_pref_ppc_network_id'] and ! ($user_row['user_pref_ppc_account_id'])) { $mysql['user_pref_ppc_network_id'] = $db->real_escape_string($user_row['user_pref_ppc_network_id']); if ($user_row['user_pref_ppc_network_id'] == '16777215') { $click_sql .= " AND 2pn.ppc_network_id IS NULL"; $count_where .= " AND ppc_network_id IS NULL"; } else { $click_sql .= " AND 2pn.ppc_network_id='" . $mysql['user_pref_ppc_network_id'] . "'"; $count_where .= " AND ppc_network_id='" . $mysql['user_pref_ppc_network_id'] . "'"; } } if ($user_row['user_pref_ppc_account_id']) { $mysql['user_pref_ppc_account_id'] = $db->real_escape_string($user_row['user_pref_ppc_account_id']); $click_sql .= " AND 2c.ppc_account_id='" . $mysql['user_pref_ppc_account_id'] . "'"; $count_where .= " AND 2c.ppc_account_id='" . $mysql['user_pref_ppc_account_id'] . "'"; } if ($user_row['user_pref_aff_network_id'] and ! $user_row['user_pref_aff_campaign_id']) { $mysql['user_pref_aff_network_id'] = $db->real_escape_string($user_row['user_pref_aff_network_id']); $click_sql .= " AND 2an.aff_network_id='" . $mysql['user_pref_aff_network_id'] . "'"; $count_where .= " AND 2c.aff_network_id='" . $mysql['user_pref_aff_network_id'] . "'"; } if ($user_row['user_pref_aff_campaign_id']) { $mysql['user_pref_aff_campaign_id'] = $db->real_escape_string($user_row['user_pref_aff_campaign_id']); $click_sql .= " AND 2c.aff_campaign_id='" . $mysql['user_pref_aff_campaign_id'] . "'"; $count_where .= " AND 2c.aff_campaign_id='" . $mysql['user_pref_aff_campaign_id'] . "'"; } if ($user_row['user_pref_text_ad_id']) { $mysql['user_pref_text_ad_id'] = $db->real_escape_string($user_row['user_pref_text_ad_id']); $click_sql .= " AND 2ca.text_ad_id='" . $mysql['user_pref_text_ad_id'] . "'"; $count_where .= " AND 2c.text_ad_id='" . $mysql['user_pref_text_ad_id'] . "'"; } if ($user_row['user_pref_method_of_promotion'] != '0') { if ($user_row['user_pref_method_of_promotion'] == 'directlink') { $click_sql .= " AND 2c.landing_page_id=''"; $count_where .= " AND 2c.landing_page_id=''"; } elseif ($user_row['user_pref_method_of_promotion'] == 'landingpage') { $click_sql .= " AND 2c.landing_page_id!=''"; $count_where .= " AND 2c.landing_page_id!=''"; } } if ($user_row['user_pref_landing_page_id']) { $mysql['user_landing_page_id'] = $db->real_escape_string($user_row['user_pref_landing_page_id']); $click_sql .= " AND 2c.landing_page_id='" . $mysql['user_landing_page_id'] . "'"; $count_where .= " AND 2c.landing_page_id='" . $mysql['user_landing_page_id'] . "'"; } if ($user_row['user_pref_country_id']) { $mysql['user_pref_country_id'] = $db->real_escape_string($user_row['user_pref_country_id']); $click_sql .= " AND 2ca.country_id=" . $mysql['user_pref_country_id']; $count_where .= " AND 2c.country_id=" . $mysql['user_pref_country_id']; } if ($user_row['user_pref_region_id']) { $mysql['user_pref_region_id'] = $db->real_escape_string($user_row['user_pref_region_id']); $click_sql .= " AND 2ca.region_id=" . $mysql['user_pref_region_id']; $count_where .= " AND 2c.region_id=" . $mysql['user_pref_region_id']; } if ($user_row['user_pref_isp_id']) { $mysql['user_pref_isp_id'] = $db->real_escape_string($user_row['user_pref_isp_id']); $click_sql .= " AND 2is.isp_id=" . $mysql['user_pref_isp_id']; $count_where .= " AND 2c.isp_id=" . $mysql['user_pref_isp_id']; } if ($user_row['user_pref_referer']) { $mysql['user_pref_referer'] = $db->real_escape_string($user_row['user_pref_referer']); $click_sql .= " AND 2sd.site_domain_host LIKE '%" . $mysql['user_pref_referer'] . "%'"; $count_where .= " AND 2su.site_url_id in (select site_url_id from 202_site_urls where site_url_address like '%" . $mysql['user_pref_referer'] . "%')"; // $count_where .= " AND 2su.site_url_id in (SELECT distinct 2de.click_referer_site_url_id FROM 202_dataengine as 2de LEFT JOIN 202_site_urls ON (2de.click_referer_site_url_id = site_url_id) WHERE site_url_address LIKE '%".$mysql['user_pref_referer']."%')"; } if ($user_row['user_pref_keyword']) { $mysql['user_pref_keyword'] = $db->real_escape_string($user_row['user_pref_keyword']); $click_sql .= " AND 2k.keyword_id in (SELECT keyword_id from 202_keywords where keyword LIKE CONVERT( _utf8 '%" . $mysql['user_pref_keyword'] . "%' USING utf8 ) COLLATE utf8_general_ci) "; $count_where .= " AND 2k.keyword_id in (SELECT keyword_id from 202_keywords where keyword LIKE CONVERT( _utf8 '%" . $mysql['user_pref_keyword'] . "%' USING utf8 ) COLLATE utf8_general_ci) "; } if ($user_row['user_pref_ip']) { $mysql['user_pref_ip'] = $db->real_escape_string($user_row['user_pref_ip']); $click_sql .= " AND 2i.ip_address LIKE '%" . $mysql['user_pref_ip'] . "%'"; $count_where .= " AND 2i.ip_address LIKE '%" . $mysql['user_pref_ip'] . "%'"; } if ($user_row['user_pref_device_id']) { $mysql['user_pref_device_id'] = $db->real_escape_string($user_row['user_pref_device_id']); $click_sql .= " AND 2d.device_type=" . $mysql['user_pref_device_id']; $count_where .= " AND 2d.device_type=" . $mysql['user_pref_device_id']; } if ($user_row['user_pref_browser_id']) { $mysql['user_pref_browser_id'] = $db->real_escape_string($user_row['user_pref_browser_id']); $click_sql .= " AND 2b.browser_id=" . $mysql['user_pref_browser_id']; $count_where .= " AND 2c.browser_id=" . $mysql['user_pref_browser_id']; } if ($user_row['user_pref_platform_id']) { $mysql['user_pref_platform_id'] = $db->real_escape_string($user_row['user_pref_platform_id']); $click_sql .= " AND 2p.platform_id=" . $mysql['user_pref_platform_id']; $count_where .= " AND 2c.platform_id=" . $mysql['user_pref_platform_id']; } } // set time preferences if ($pref_time == true) { $time = grab_timeframe(); $mysql['from'] = $db->real_escape_string($time['from']); $mysql['to'] = $db->real_escape_string($time['to']); if ($mysql['from'] != '') { $click_sql .= " AND click_time > " . $mysql['from'] . " "; $count_where .= " AND click_time > " . $mysql['from'] . " "; } if ($mysql['to'] != '') { $click_sql .= " AND click_time < " . $mysql['to'] . " "; $count_where .= " AND click_time < " . $mysql['to'] . " "; } } if ($isspy) { $from = time() - 86400; $click_sql .= " AND click_time > " . $from . " "; } // set limit preferences if ($pref_order == true) { $click_sql .= $pref_order; } // only if we want to count stuff like the click history clicks do we need to do any of the stuff below. if ($count == true) { if ($isspy) $count_sql = "select count(*) as count from 202_clicks_spy"; else $count_sql = $count_sql . $count_where; if ($mysql['user_landing_subid']) { $join= " AND 2c."; if($isspy){ $join = " WHERE "; } $count_sql .= $join."click_id='" . $mysql['user_landing_subid'] . "'"; } if ($pref_limit == true) { $count_sql .= " LIMIT " . $pref_limit; } // before it limits, we want to know the TOTAL number of rows $count_result = _mysqli_query($count_sql); $count_row = $count_result->fetch_assoc(); $rows = $count_row['count']; // $rows=1; // only if there is a limit set, run this code if ($pref_limit == true) { // rows is the total count of rows in this query. $query['rows'] = $rows; $query['offset'] = $offset; if ((is_numeric($offset) and ($pref_limit == true)) or ($pref_limit == true)) { $click_sql .= " LIMIT "; } if (is_numeric($offset) and ($pref_limit == true)) { $mysql['offset'] = $db->real_escape_string($offset * $user_row['user_pref_limit']); $click_sql .= $mysql['offset'] . ","; // declare starting row number $query['from'] = ($query['offset'] * $user_row['user_pref_limit']) + 1; } else { $query['from'] = 1; } if ($pref_limit == true) { if (is_numeric($pref_limit)) { $mysql['user_pref_limit'] = $db->real_escape_string($pref_limit); } else { $mysql['user_pref_limit'] = $db->real_escape_string($user_row['user_pref_limit']); } $click_sql .= $mysql['user_pref_limit']; // declare the number of pages $query['pages'] = ceil($query['rows'] / $user_row['user_pref_limit']) + 1; // declare end starting row number $query['to'] = ($query['from'] + $mysql['user_pref_limit']) - 1; if ($query['to'] > $query['rows']) { $query['to'] = $query['rows']; } } else { $query['pages'] = 1; $query['to'] = $query['rows']; } if (($query['from'] == 1) and ($query['to'] == 0)) { $query['from'] = 0; } } } else { // only if there is a limit set, run this code if ($pref_limit != false) { // rows is the total count of rows in this query. $query['rows'] = $rows; $query['offset'] = $offset; if ((is_numeric($offset) and ($pref_limit == true)) or ($pref_limit == true)) { $click_sql .= " LIMIT "; } if (is_numeric($offset) and ($pref_limit == true)) { $mysql['offset'] = $db->real_escape_string($offset * $user_row['user_pref_limit']); $click_sql .= $mysql['offset'] . ","; // declare starting row number $query['from'] = ($query['offset'] * $user_row['user_pref_limit']) + 1; } else { $query['from'] = 1; } if ($pref_limit == true) { if (is_numeric($pref_limit)) { $mysql['user_pref_limit'] = $db->real_escape_string($pref_limit); } else { $mysql['user_pref_limit'] = $db->real_escape_string($user_row['user_pref_limit']); } $click_sql .= $mysql['user_pref_limit']; // declare the number of pages $query['pages'] = ceil($query['rows'] / $user_row['user_pref_limit']) + 1; // declare end starting row number $query['to'] = ($query['from'] + $user_row['user_pref_limit']) - 1; if ($query['to'] > $query['rows']) { $query['to'] = $query['rows']; } } else { $query['pages'] = 1; $query['to'] = $query['rows']; } if (($query['from'] == 1) and ($query['to'] == 0)) { $query['from'] = 0; } } } // check if using dataengine if (stripos($click_sql, "202_dataengine")) { $click_sql = str_replace("2ca.", "2c.", $click_sql); } $query['click_sql'] = $click_sql; return $query; } function pcc_network_icon($ppc_network_name, $ppc_account_name) { // 7search if ((preg_match("/7search/i", $ppc_network_name)) or (preg_match("/7 search/i", $ppc_network_name))) { $ppc_network_icon = '7search.ico'; } // adbrite if (preg_match("/adbrite/i", $ppc_network_name)) { $ppc_network_icon = 'adbrite.ico'; } // adoori if (preg_match("/adoori/i", $ppc_network_name)) { $ppc_network_icon = 'adoori.ico'; } // adTegrity if ((preg_match("/adtegrity/i", $ppc_network_name)) or (preg_match("/ad tegrity/i", $ppc_network_name))) { $ppc_network_icon = 'adtegrity.png'; } // ask if (preg_match("/ask/i", $ppc_network_name)) { $ppc_network_icon = 'ask.ico'; } // adblade if ((preg_match("/adblade/i", $ppc_network_name)) or (preg_match("/ad blade/i", $ppc_network_name))) { $ppc_network_icon = 'adblade.ico'; } // adsonar if ((preg_match("/adsonar/i", $ppc_network_name)) or (preg_match("/ad sonar/i", $ppc_network_name)) or (preg_match("/quigo/i", $ppc_network_name))) { $ppc_network_icon = 'adsonar.png'; } // marchex if ((preg_match("/marchex/i", $ppc_network_name)) or (preg_match("/goclick/i", $ppc_network_name))) { $ppc_network_icon = 'marchex.png'; } // bidvertiser if (preg_match("/bidvertiser/i", $ppc_network_name)) { $ppc_network_icon = 'bidvertiser.gif'; } // enhance if (preg_match("/enhance/i", $ppc_network_name)) { $ppc_network_icon = 'enhance.ico'; } // facebook if ((preg_match("/facebook/i", $ppc_network_name)) or (preg_match("/fb/i", $ppc_network_name))) { $ppc_network_icon = 'facebook.ico'; } // findology if (preg_match("/findology/i", $ppc_network_name)) { $ppc_network_icon = 'findology.png'; } // google if ((preg_match("/google/i", $ppc_network_name)) or (preg_match("/adwords/i", $ppc_network_name))) { $ppc_network_icon = 'google.ico'; } // instagram if (preg_match("/instagram/i", $ppc_network_name)) { $ppc_network_icon = 'instagram.ico'; } // kanoodle if (preg_match("/kanoodle/i", $ppc_network_name)) { $ppc_network_icon = 'kanoodle.ico'; } // looksmart if (preg_match("/looksmart/i", $ppc_network_name)) { $ppc_network_icon = 'looksmart.gif'; } // hi5 if ((preg_match("/hi5/i", $ppc_network_name)) or (preg_match("/hi 5/i", $ppc_network_name))) { $ppc_network_icon = 'hi5.ico'; } // miva if ((preg_match("/miva/i", $ppc_network_name)) or (preg_match("/searchfeed/i", $ppc_network_name))) { $ppc_network_icon = 'miva.ico'; } // mailchimp if ((preg_match("/mailchimp/i", $ppc_network_name)) or (preg_match("/searchfeed/i", $ppc_network_name))) { $ppc_network_icon = 'mailchimp.ico'; } // msn if ((preg_match("/microsoft/i", $ppc_network_name)) or (preg_match("/MSN/i", $ppc_network_name)) or (preg_match("/bing/i", $ppc_network_name)) or (preg_match("/adcenter/i", $ppc_network_name))) { $ppc_network_icon = 'msn.ico'; } // pinterest if ((preg_match("/pinterest/i", $ppc_network_name))) { $ppc_network_icon = 'pinterest.ico'; } // pulse360 if ((preg_match("/pulse360/i", $ppc_network_name)) or (preg_match("/pulse 360/i", $ppc_network_name))) { $ppc_network_icon = 'pulse360.ico'; } // quora if (preg_match("/quora/i", $ppc_network_name)) { $ppc_network_icon = 'quora.ico'; } // snapchat if (preg_match("/snapchat/i", $ppc_network_name)) { $ppc_network_icon = 'snapchat.ico'; } // search123 if ((preg_match("/search123/i", $ppc_network_name)) or (preg_match("/search 123/i", $ppc_network_name))) { $ppc_network_icon = 'google.ico'; } // searchfeed if (preg_match("/searchfeed/i", $ppc_network_name)) { $ppc_network_icon = 'searchfeed.gif'; } // yahoo if ((preg_match("/yahoo/i", $ppc_network_name)) or (preg_match("/YSM/i", $ppc_network_name))) { $ppc_network_icon = 'yahoo.ico'; } // mediatraffic if ((preg_match("/mediatraffic/i", $ppc_network_name)) or (preg_match("/media traffic/i", $ppc_network_name))) { $ppc_network_icon = 'mediatraffic.png'; } // mochi if ((preg_match("/mochi/i", $ppc_network_name)) or (preg_match("/mochimedia/i", $ppc_network_name)) or (preg_match("/mochi media/i", $ppc_network_name))) { $ppc_network_icon = 'mochi.ico'; } // myspace if ((preg_match("/myspace/i", $ppc_network_name)) or (preg_match("/my space/i", $ppc_network_name)) or (preg_match("/myads/i", $ppc_network_name)) or (preg_match("/my ads/i", $ppc_network_name))) { $ppc_network_icon = 'myspace.ico'; } // fox audience network if (preg_match("/fox/i", $ppc_network_name)) { $ppc_network_icon = 'foxnetwork.ico'; } // adsdaq if (preg_match("/adsdaq/i", $ppc_network_name)) { $ppc_network_icon = 'adsdaq.png'; } // twitter if (preg_match("/twitter/i", $ppc_network_name)) { $ppc_network_icon = 'twitter.ico'; } // amazon if (preg_match("/amazon/i", $ppc_network_name)) { $ppc_network_icon = 'amazon.ico'; } // adengage if ((preg_match("/adengage/i", $ppc_network_name)) or (preg_match("/ad engage/i", $ppc_network_name))) { $ppc_network_icon = 'adengage.ico'; } // adtoll if ((preg_match("/adtoll/i", $ppc_network_name)) or (preg_match("/ad toll/i", $ppc_network_name))) { $ppc_network_icon = 'adtoll.ico'; } // ezanga if ((preg_match("/ezangag/i", $ppc_network_name)) or (preg_match("/e zanga/i", $ppc_network_name))) { $ppc_network_icon = 'ezanga.ico'; } // aol if ((preg_match("/aol/i", $ppc_network_name)) or (preg_match("/quigo/i", $ppc_network_name))) { $ppc_network_icon = 'aol.ico'; } // aol if ((preg_match("/revtwt/i", $ppc_network_name)) or (preg_match("/rev twt/i", $ppc_network_name))) { $ppc_network_icon = 'revtwt.ico'; } // advertising.com if (preg_match("/advertising.com/i", $ppc_network_name)) { $ppc_network_icon = 'advertising.com.ico'; } // advertise.com if (preg_match("/advertise.com/i", $ppc_network_name)) { $ppc_network_icon = 'advertise.com.gif'; } // adready if ((preg_match("/adready/i", $ppc_network_name)) or (preg_match("/ad ready/i", $ppc_network_name))) { $ppc_network_icon = 'adready.ico'; } // abc search if ((preg_match("/abcsearch/i", $ppc_network_name)) or (preg_match("/abc search/i", $ppc_network_name))) { $ppc_network_icon = 'abcsearch.png'; } // abc search if ((preg_match("/megaclick/i", $ppc_network_name)) or (preg_match("/mega click/i", $ppc_network_name))) { $ppc_network_icon = 'megaclick.ico'; } // etology if (preg_match("/etology/i", $ppc_network_name)) { $ppc_network_icon = 'etology.ico'; } // youtube if ((preg_match("/youtube/i", $ppc_network_name)) or (preg_match("/you tube/i", $ppc_network_name))) { $ppc_network_icon = 'youtube.ico'; } // social media if ((preg_match("/socialmedia/i", $ppc_network_name)) or (preg_match("/social media/i", $ppc_network_name))) { $ppc_network_icon = 'socialmedia.ico'; } // zango if ((preg_match("/zango/i", $ppc_network_name)) or (preg_match("/leadimpact/i", $ppc_network_name)) or (preg_match("/lead impact/i", $ppc_network_name))) { $ppc_network_icon = 'zango.ico'; } // jema media if ((preg_match("/jema media/i", $ppc_network_name)) or (preg_match("/jemamedia/i", $ppc_network_name))) { $ppc_network_icon = 'jemamedia.png'; } // direct cpv if ((preg_match("/directcpv/i", $ppc_network_name)) or (preg_match("/direct cpv/i", $ppc_network_name))) { $ppc_network_icon = 'directcpv.png'; } // linksador if ((preg_match("/linksador/i", $ppc_network_name))) { $ppc_network_icon = 'linksador.png'; } // adon network if ((preg_match("/adonnetwork/i", $ppc_network_name)) or (preg_match("/adon network/i", $ppc_network_name)) or (preg_match("/Adon/i", $ppc_network_name)) or (preg_match("/ad-on/i", $ppc_network_name))) { $ppc_network_icon = 'adonnetwork.ico'; } // plenty of fish if ((preg_match("/plentyoffish/i", $ppc_network_name)) or (preg_match("/plenty of fish/i", $ppc_network_name)) or (preg_match("/pof/i", $ppc_network_name))) { $ppc_network_icon = 'plentyoffish.ico'; } // clicksor if (preg_match("/clicksor/i", $ppc_network_name)) { $ppc_network_icon = 'clicksor.ico'; } // traffic vance if ((preg_match("/trafficvance/i", $ppc_network_name)) or (preg_match("/traffic vance/i", $ppc_network_name))) { $ppc_network_icon = 'trafficvance.ico'; } // adknowledge if ((preg_match("/adknowledge/i", $ppc_network_name)) or (preg_match("/bidsystem/i", $ppc_network_name)) or (preg_match("/bid system/i", $ppc_network_name)) or (preg_match("/cubics/i", $ppc_network_name))) { $ppc_network_icon = 'adknowledge.ico'; } if ((preg_match("/admob/i", $ppc_network_name)) or (preg_match("/ad mob/i", $ppc_network_name))) { $ppc_network_icon = 'admob.ico'; } if ((preg_match("/adside/i", $ppc_network_name)) or (preg_match("/ad side/i", $ppc_network_name))) { $ppc_network_icon = 'adside.ico'; } // unknown if (! isset($ppc_network_icon)) { $ppc_network_icon = 'unknown.gif'; } $html['ppc_network_icon'] = '

'; return $html['ppc_network_icon']; } class INDEXES { // this returns the location_country_id, when a Country Code is given function get_country_id($country_name, $country_code) { global $memcacheWorking, $memcache; 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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['country_name'] = $db->real_escape_string($country_name); $mysql['country_code'] = $db->real_escape_string($country_code); $country_sql = "SELECT country_id FROM 202_locations_country WHERE country_code='" . $mysql['country_code'] . "'"; $country_result = _mysqli_query($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['country_name'] = $db->real_escape_string($country_name); $mysql['country_code'] = $db->real_escape_string($country_code); $country_sql = "SELECT country_id FROM 202_locations_country WHERE country_code='" . $mysql['country_code'] . "'"; $country_result = _mysqli_query($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($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($city_name, $country_id) { global $memcacheWorking, $memcache; 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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['city_name'] = $db->real_escape_string($city_name); $mysql['country_id'] = $db->real_escape_string($country_id); $city_sql = "SELECT city_id FROM 202_locations_city WHERE city_name='" . $mysql['city_name'] . "'"; $city_result = _mysqli_query($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['city_name'] = $db->real_escape_string($city_name); $mysql['country_id'] = $db->real_escape_string($country_id); $city_sql = "SELECT city_id FROM 202_locations_city WHERE city_name='" . $mysql['city_name'] . "'"; $city_result = _mysqli_query($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($city_sql); // ($ip_sql); $city_id = $db->insert_id; return $city_id; } } } // this returns the isp_id, when a isp name is given function get_isp_id($isp) { global $memcacheWorking, $memcache; 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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['isp'] = $db->real_escape_string($isp); $isp_sql = "SELECT isp_id FROM 202_locations_isp WHERE isp_name='" . $mysql['isp'] . "'"; $isp_result = _mysqli_query($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['isp'] = $db->real_escape_string($isp); $isp_sql = "SELECT isp_id FROM 202_locations_isp WHERE isp_name='" . $mysql['isp'] . "'"; $isp_result = _mysqli_query($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($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($ip_address) { global $memcacheWorking, $memcache; 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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['ip_address'] = $db->real_escape_string($ip_address); $ip_sql = "SELECT ip_id FROM 202_ips WHERE ip_address='" . $mysql['ip_address'] . "'"; $ip_result = _mysqli_query($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['ip_address'] = $db->real_escape_string($ip_address); $ip_sql = "SELECT ip_id FROM 202_ips WHERE ip_address='" . $mysql['ip_address'] . "'"; $ip_result = _mysqli_query($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($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($site_url_address) { global $memcacheWorking, $memcache; $parsed_url = @parse_url($site_url_address); $site_domain_host = $parsed_url['host']; $site_domain_host = str_replace('www.', '', $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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['site_domain_host'] = $db->real_escape_string($site_domain_host); $site_domain_sql = "SELECT site_domain_id FROM 202_site_domains WHERE site_domain_host='" . $mysql['site_domain_host'] . "'"; $site_domain_result = _mysqli_query($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['site_domain_host'] = $db->real_escape_string($site_domain_host); $site_domain_sql = "SELECT site_domain_id FROM 202_site_domains WHERE site_domain_host='" . $mysql['site_domain_host'] . "'"; $site_domain_result = _mysqli_query($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($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($site_url_address) { global $memcacheWorking, $memcache; $site_domain_id = INDEXES::get_site_domain_id($site_url_address); 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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['site_url_address'] = $db->real_escape_string($site_url_address); $mysql['site_domain_id'] = $db->real_escape_string($site_domain_id); $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($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($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 { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['site_url_address'] = $db->real_escape_string($site_url_address); $mysql['site_domain_id'] = $db->real_escape_string($site_domain_id); $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($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($site_url_sql); // ($site_url_sql); $site_url_id = $db->insert_id; return $site_url_id; } } } // this returns the keyword_id function get_keyword_id($keyword) { global $memcacheWorking, $memcache; // only grab the first 255 charactesr of keyword // $keyword = substr($keyword, 0, 255); if ($memcacheWorking) { // get from memcached $getKeyword = $memcache->get(md5("keyword-id" . $keyword . systemHash())); if ($getKeyword) { return $getKeyword; } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['keyword'] = $db->real_escape_string($keyword); $keyword_sql = "SELECT keyword_id FROM 202_keywords WHERE keyword='" . $mysql['keyword'] . "'"; $keyword_result = _mysqli_query($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, 0); return $keyword_id; } else { $keyword_sql = "INSERT INTO 202_keywords SET keyword='" . $mysql['keyword'] . "'"; $keyword_result = _mysqli_query($keyword_sql); // ($keyword_sql); $keyword_id = $db->insert_id; $setID = setCache(md5("keyword-id" . $keyword . systemHash()), $keyword_id, 0); return $keyword_id; } } } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['keyword'] = $db->real_escape_string($keyword); $keyword_sql = "SELECT keyword_id FROM 202_keywords WHERE keyword='" . $mysql['keyword'] . "'"; $keyword_result = _mysqli_query($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($keyword_sql); // ($keyword_sql); $keyword_id = $db->insert_id; return $keyword_id; } } } // this returns the c1 id function get_c1_id($c1) { global $memcacheWorking, $memcache; // only grab the first 350 charactesr of c1 $c1 = substr($c1, 0, 350); if ($memcacheWorking) { // get from memcached $getc1 = $memcache->get(md5("c1-id" . $c1 . systemHash())); if ($getc1) { return $getc1; } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c1'] = $db->real_escape_string($c1); $c1_sql = "SELECT c1_id FROM 202_tracking_c1 WHERE c1='" . $mysql['c1'] . "'"; $c1_result = _mysqli_query($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, 0); return $c1_id; } else { $c1_sql = "INSERT INTO 202_tracking_c1 SET c1='" . $mysql['c1'] . "'"; $c1_result = _mysqli_query($c1_sql); // ($c1_sql); $c1_id = $db->insert_id; $setID = setCache(md5("c1-id" . $c1 . systemHash()), $c1_id, 0); return $c1_id; } } } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c1'] = $db->real_escape_string($c1); $c1_sql = "SELECT c1_id FROM 202_tracking_c1 WHERE c1='" . $mysql['c1'] . "'"; $c1_result = _mysqli_query($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($c1_sql); // ($c1_sql); $c1_id = $db->insert_id; return $c1_id; } } } // this returns the c2 id function get_c2_id($c2) { global $memcacheWorking, $memcache; // only grab the first 350 charactesr of c2 $c2 = substr($c2, 0, 350); if ($memcacheWorking) { // get from memcached $getc2 = $memcache->get(md5("c2-id" . $c2 . systemHash())); if ($getc2) { return $getc2; } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c2'] = $db->real_escape_string($c2); $c2_sql = "SELECT c2_id FROM 202_tracking_c2 WHERE c2='" . $mysql['c2'] . "'"; $c2_result = _mysqli_query($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, 0); return $c2_id; } else { $c2_sql = "INSERT INTO 202_tracking_c2 SET c2='" . $mysql['c2'] . "'"; $c2_result = _mysqli_query($c2_sql); // ($c2_sql); $c2_id = $db->insert_id; $setID = setCache(md5("c2-id" . $c2 . systemHash()), $c2_id, 0); return $c2_id; } } } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c2'] = $db->real_escape_string($c2); $c2_sql = "SELECT c2_id FROM 202_tracking_c2 WHERE c2='" . $mysql['c2'] . "'"; $c2_result = _mysqli_query($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($c2_sql); // ($c2_sql); $c2_id = $db->insert_id; return $c2_id; } } } // this returns the c3 id function get_c3_id($c3) { global $memcacheWorking, $memcache; // only grab the first 350 charactesr of c3 $c3 = substr($c3, 0, 350); if ($memcacheWorking) { // get from memcached $getc3 = $memcache->get(md5("c3-id" . $c3 . systemHash())); if ($getc3) { return $getc3; } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c3'] = $db->real_escape_string($c3); $c3_sql = "SELECT c3_id FROM 202_tracking_c3 WHERE c3='" . $mysql['c3'] . "'"; $c3_result = _mysqli_query($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, 0); return $c3_id; } else { $c3_sql = "INSERT INTO 202_tracking_c3 SET c3='" . $mysql['c3'] . "'"; $c3_result = _mysqli_query($c3_sql); // ($c3_sql); $c3_id = $db->insert_id; $setID = setCache(md5("c3-id" . $c3 . systemHash()), $c3_id, 0); return $c3_id; } } } else { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['c3'] = $db->real_escape_string($c3); $c3_sql = "SELECT c3_id FROM 202_tracking_c3 WHERE c3='" . $mysql['c3'] . "'"; $c3_result = _mysqli_query($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($c3_sql); // ($c3_sql); $c3_id = $db->insert_id; return $c3_id; } } } // this returns the c4 id 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 = setCache(md5("c4-id" . $c4 . systemHash()), $c4_id, 0); 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 = setCache(md5("c4-id" . $c4 . systemHash()), $c4_id, 0); 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; } } } } function runHourly($user_pref) {} function runWeekly($user_pref) {} // 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 = $memcache->set(md5($user_id, $queries . systemHash()), false); setCache(md5($user_id, $queries . systemHash()), 5); } } function memcache_mysql_fetch_assoc($sql, $allowCaching = 1, $minutes = 5) { global $memcacheWorking, $memcache; if ($memcacheWorking == false) { $result = _mysqli_query($sql); $row = $result->fetch_assoc(); return $row; } else { if ($allowCaching == 0) { $result = _mysqli_query($sql); $row = $result->fetch_assoc(); return $row; } else { // Check if its set $getCache = $memcache->get(md5($sql . systemHash())); if ($getCache === false) { // cache this data $result = _mysqli_query($sql); $fetchArray = $result->fetch_assoc(); //$setCache = $memcache->set(md5($sql . systemHash()), serialize($fetchArray), false, 60 * $minutes); setCache(md5($sql . systemHash()), serialize($fetchArray), 60 * $minutes); // store all this users memcache keys, so we can delete them fast later on memcache_set_user_key($sql); return $fetchArray; } else { // Data Cached return unserialize($getCache); } } } } function foreach_memcache_mysql_fetch_assoc($sql, $allowCaching = 1) { global $memcacheWorking, $memcache; if ($memcacheWorking == false) { $row = array(); $result = _mysqli_query($sql); // ($sql); while ($fetch = $result->fetch_assoc()) { $row[] = $fetch; } return $row; } else { if ($allowCaching == 0) { $row = array(); $result = _mysqli_query($sql); // ($sql); while ($fetch = $result->fetch_assoc()) { $row[] = $fetch; } return $row; } else { $getCache = $memcache->get(md5($sql . systemHash())); if ($getCache === false) { // if data is NOT cache, cache this data $row = array(); $result = _mysqli_query($sql); // ($sql); while ($fetch = $result->fetch_assoc()) { $row[] = $fetch; } $setCache = setCache(md5($sql . systemHash()), serialize($row), 60 * 5); // 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); } } } } // this function delays an SQL statement, puts iy in a mysql table, to be cronjobed out every 5 minutes function delay_sql($delayed_sql) { if (is_string($delayed_sql)) $mysql['delayed_sql'] = str_replace("'", "''", $delayed_sql); else return false; $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($delayed_sql); // ($delayed_sql); } function user_cache_time($user_id) { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['user_id'] = $db->real_escape_string($user_id); $sql = "SELECT cache_time FROM 202_users_pref WHERE user_id='" . $mysql['user_id'] . "'"; $result = _mysqli_query($sql); $row = $result->fetch_assoc(); return $row['cache_time']; } function get_user_data_feedback($user_id) { $database = DB::getInstance(); $db = $database->getConnection(); $mysql['user_id'] = $db->real_escape_string($user_id); $sql = "SELECT user_email, user_time_register, clickserver_api_key, install_hash, user_hash, modal_status, vip_perks_status FROM 202_users WHERE user_id='" . $mysql['user_id'] . "'"; $result = _mysqli_query($sql); $row = $result->fetch_assoc(); return array( 'user_email' => $row['user_email'], 'time_stamp' => $row['user_time_register'], 'api_key' => $row['clickserver_api_key'], 'install_hash' => $row['install_hash'], 'user_hash' => $row['user_hash'], 'modal_status' => $row['modal_status'], 'vip_perks_status' => $row['vip_perks_status'] ); } function clickserver_api_upgrade_url($key) { // Initiate curl $ch = curl_init(); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/auth/?apiKey=' . $key . '&clickserverId=' . base64_encode($_SERVER['HTTP_HOST'])); // Execute $result = curl_exec($ch); $data = json_decode($result, true); if ($data['isValidKey'] != 'true' || $data['isValidDomain'] != 'true') { return false; die(); } $download_url = $data['downloadURL']; return $download_url; curl_close($ch); } function clickserver_api_key_validate($key) { // Initiate curl $ch = curl_init(); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/auth/?apiKey=' . $key . '&clickserverId=' . base64_encode($_SERVER['HTTP_HOST'])); // Execute $result = curl_exec($ch); $data = json_decode($result, true); if ($data['isValidKey'] != 'true' || $data['isValidDomain'] != 'true') { return false; die(); } return true; curl_close($ch); } function api_key_validate($key) { $post = array(); $post['key'] = $key; $fields = http_build_query($post); // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/validate-customers-key'); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set to post curl_setopt($ch, CURLOPT_POST, 1); // Set post fields curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); // Execute $result = curl_exec($ch); if (curl_errno($ch)) { // echo 'error:' . curl_error($c); } // close connection curl_close($ch); $data = json_decode($result, true); return $result; } function systemHash() { $hash = hash('ripemd160', $_SERVER['HTTP_HOST'] . $_SERVER['SERVER_ADDR']); return $hash; } function getBrowserIcon($name) { switch ($name) { case 'Chrome': $icon = 'chrome'; break; case 'Chrome Frame': $icon = 'chrome'; break; case 'Android': $icon = 'android'; break; case 'Chrome Mobile': $icon = 'chrome'; break; case 'Chrome Mobile iOS': $icon = 'chrome'; break; case 'Firefox': $icon = 'firefox'; break; case 'IE': $icon = 'ie'; break; case 'Mobile Safari': $icon = 'safari'; break; case 'Safari': $icon = 'safari'; break; case 'Opera': $icon = 'opera'; break; case 'Opera Tablet': $icon = 'opera'; break; case 'Opera Mobile': $icon = 'opera'; break; case 'WebKit Nightly': $icon = 'webkitnightly'; break; default: $icon = 'other'; } return $icon; } function getSurveyData($install_hash) { // Initiate curl $ch = curl_init(); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/deep/survey/' . $install_hash); // Execute $result = curl_exec($ch); // close connection curl_close($ch); $data = json_decode($result, true); return $data; } function updateSurveyData($install_hash, $post) { $fields = http_build_query($post); // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/deep/survey/' . $install_hash); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set to post curl_setopt($ch, CURLOPT_POST, 1); // Set post fields curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); // Execute $result = curl_exec($ch); $data = json_decode($result, true); // close connection curl_close($ch); return $data; } function intercomHash($install_hash) { // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/hash/?h=' . $install_hash); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); $data = json_decode($result, true); // close connection curl_close($ch); return $data['user_hash']; } function rotator_data($query, $type) { // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v1/deep/rotator/' . $type . '/' . $query); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); // close connection curl_close($ch); return $result; } function changelog() { // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/clickserver/currentversion/paid/changelogs.php'); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); // close connection curl_close($ch); return json_decode($result, true); } function changelogPremium() { // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/clickserver/currentversion/paid/changelogs.php'); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); // close connection curl_close($ch); return json_decode($result, true); } function callAutoCron($endpoint) { $protocol = stripos($_SERVER['SERVER_PROTOCOL'], 'https') === true ? 'https://' : 'http://'; $domain = $protocol . '' . getTrackingDomain(). get_absolute_url(); $domain = base64_encode($domain); // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/autocron/' . $endpoint . '/' . $domain); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); // close connection curl_close($ch); return json_decode($result, true); } function registerDailyEmail($time, $timezone, $hash) { $protocol = stripos($_SERVER['SERVER_PROTOCOL'], 'https') === true ? 'https://' : 'http://'; $domain = rtrim($protocol . '' . getTrackingDomain(). get_absolute_url(), '/'); $domain = base64_encode($domain); if ($time) { $date = new DateTime($time . ':00:00', new DateTimeZone($timezone)); $date->setTimezone(new DateTimeZone('UTC')); $set_time = $date->format('H'); } else { $set_time = 'NA'; } // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/' . $hash . '/' . $domain . '/' . $set_time); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); // close connection curl_close($ch); } function tagUserByNetwork($install_hash, $type, $network) { $post = array(); $post['network'] = $network; $fields = http_build_query($post); // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/tag/user/' . $install_hash . '/' . $type); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set to post curl_setopt($ch, CURLOPT_POST, 1); // Set post fields curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); // Execute $result = curl_exec($ch); if (curl_errno($ch)) { echo 'error:' . curl_error($c); } // close connection curl_close($ch); } function getDNIHost() { $protocol = stripos($_SERVER['SERVER_PROTOCOL'], 'https') === true ? 'https://' : 'http://'; $domain = rtrim($protocol . '' . getTrackingDomain(). get_absolute_url(), '/'); return base64_encode($domain); } function getAllDniNetworks($install_hash) { // Initiate curl $ch = curl_init(); // Set the url curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $install_hash . '/networks/all'); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Execute $result = curl_exec($ch); curl_close($ch); return json_decode($result, true); } function authDniNetworks($hash, $network, $key, $affId) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'host' => getDNIHost() ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/auth/' . $network); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); if ($httpcode !== 200) { return array( 'auth' => false ); } else { $json = json_decode($result, true); return array( 'auth' => true, 'processed' => $json['processed'], 'currency' => $json['currency'] ); } } function getDniOffers($hash, $network, $key, $affId, $currency, $offset, $limit, $sort_by, $filter_by) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'currency' => $currency, 'host' => getDNIHost(), 'sort' => $sort_by, 'filter' => $filter_by ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/all/' . $offset . '/' . $limit); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function getDniOfferById($hash, $network, $key, $affId, $id) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'host' => getDNIHost() ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/id/' . $id); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function requestDniOfferAccess($hash, $network, $key, $affId, $id, $type) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'host' => getDNIHost() ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/' . $type . '/' . $id); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function submitDniOfferAnswers($hash, $network, $api_key, $affId, $id, $answers) { $fields = array( 'api_key' => $api_key, 'affiliate_id' => $affId, 'host' => getDNIHost(), 'answers' => $answers ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/answers/' . $id); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function setupDniOffer($hash, $network, $key, $affId, $currency, $id, $ddlci) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'currency' => $currency, 'host' => getDNIHost(), 'ddlci' => $ddlci ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/setup/' . $id); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function getDNICacheProgress($hash, $data) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/dni/' . $hash . '/cache/progress'); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, false); curl_setopt($ch, CURLOPT_HTTPHEADER, array( "Content-type: application/json" )); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data, true)); $results = curl_exec($ch); curl_close($ch); return $results; } function setupDniOfferTrack($hash, $network, $key, $affId, $id, $ddlci = false) { $fields = array( 'api_key' => $key, 'affiliate_id' => $affId, 'host' => getDNIHost(), 'ddlci' => $ddlci ); $url = 'https://my.tracking202.com/api/v2/dni/' . $hash . '/offers/' . $network . '/setup/track/'; if ($ddlci) { $url .= 'dl/'; } $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url . $id); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); $result = curl_exec($ch); curl_close($ch); return $result; } function getForeignPayout($currency, $payout_currency, $payout) { $fields = array( 'currency' => $currency, 'payout_currency' => $payout_currency, 'payout' => $payout ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/get-foreign-payout'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function validateCustomersApiKey($key) { $fields = array( 'key' => $key ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/validate-customers-key'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function validateRevContentCredentials($id, $secret) { $fields = array( 'id' => $id, 'secret' => $secret ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/premium-p202/validate-revcontent-credentials'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function pushToRevContent($id, $secret, $boost, $boost_id, array $ads) { $fields = array( 'id' => $id, 'secret' => $secret, 'boost' => $boost, 'boost_id' => $boost_id, 'ads' => $ads ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/premium-p202/push-revcontent'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function pushToFacebook($api_key, $group, $ad_set_id, array $ads) { $fields = array( 'campaign_name' => $group, 'ad_set_id' => $ad_set_id, 'ads' => $ads ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/premium-p202/facebook-ads/push-facebook/'.$api_key); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function getFacebookCampaignsAndAdSets($api_key) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/premium-p202/facebook-ads/get-ad-sets/'.$api_key); 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); $result = json_decode($result, true); return $result; } 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_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); return $result; } function showHelp($page) { switch ($page) { case 'step1': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=7158893&t202kw="; break; case 'step2': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=7158909&t202kw="; break; case 'step3': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=3158915&t202kw="; break; case 'step4': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=3158922&t202kw="; break; case 'step5': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=2158936&t202kw="; break; case 'step6': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=6158942&t202kw="; break; case 'step7': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=5158952&t202kw="; break; case 'slp': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=5158884&t202kw="; break; case 'alp': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=3158798&t202kw="; break; case 'step8': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=8158965&t202kw="; break; case 'step9': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=4158973&t202kw="; break; case 'overview': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=5158862&t202kw="; break; case 'groupoverview': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=4158853&t202kw="; break; case 'breakdown': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=3158819&t202kw="; break; case 'dayparting': case 'weekparting': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=1158832&t202kw="; break; case 'analyze': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=8158803&t202kw="; break; case 'visitor': case 'spy': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=1158987&t202kw="; break; case 'dni': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=3158846&t202kw="; break; case 'clickbank': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=4158829&t202kw="; break; case 'slack': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=1158876&t202kw="; break; case 'update': $url = "http://click202.com/tracking202/redirect/dl.php?t202id=5158996&t202kw="; break; } if ($url){ echo ''; } } function createId($length){ return bin2hex( random_bytes($length)); } function createPublisherIds(){ if(function_exists('random_bytes')){ $sql ="SELECT user_id FROM 202_users WHERE TRIM(COALESCE(`user_public_publisher_id`, '')) = ''"; $update_query='UPDATE'; $user_result = _mysqli_query($sql); //loop over all empty publisher ids and set them while( $user_row = $user_result->fetch_assoc()) { $query = "UPDATE `202_users` SET `user_public_publisher_id` = '".createId(5)."' WHERE `user_id` = '".$user_row['user_id']."'"; _mysqli_query($query); } } } function getDashEmail() { global $db; //get the main users dash email and api key from the db $sql = "SELECT user_dash_email,p202_customer_api_key FROM 202_users WHERE user_id ='".$_SESSION['user_id']."'"; $user_result = _mysqli_query($sql); $user_row = $user_result->fetch_assoc(); //if found we are done return the email for usage if ($user_row['user_dash_email']) { return $user_row['user_dash_email']; } else { //email not found, try and set it from api call to the server if ($user_row['p202_customer_api_key']) { $dashEmail = getSetDashEmail($user_row['p202_customer_api_key']); if ($dashEmail['code'] == 200 && $dashEmail['email'] != '') { //found it save to DB and return $mysql['email'] = $db->real_escape_string($dashEmail['email']); $sql = "UPDATE `202_users` SET user_dash_email='".$mysql['email']."' WHERE user_id ='".$_SESSION['user_id']."'"; $user_result = _mysqli_query($sql); return ($mysql['email']); } } } } function getSetDashEmail($key) { $fields = array( 'key' => $key ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/v2/get-customers-email'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 60); $result = curl_exec($ch); curl_close($ch); $result = json_decode($result, true); return $result; } function getWallpaper($key='') { $fields = array( 'key' => $key ); $fields = http_build_query($fields); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://my.tracking202.com/api/ads/wallpapers/extern'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT ,0); curl_setopt($ch, CURLOPT_TIMEOUT, 10); $result = curl_exec($ch); curl_close($ch); if(strlen($result)>2000 || !$result){ $result = array( 'wallpaperImg' => 'https://dp5k1x6z3k332.cloudfront.net/frank-mckenna-269330.jpg', 'wallpaperUrl' => 'http://prosper.tracking202.com/apps/?utm_source=p202profb' ); return $result; } $result = json_decode($result, true); return $result; } ?>