$roi = @round($net / $cost * 100); $total_roi = @round($total_net / $total_cost * 100); //html escape vars $html['clicks'] = htmlentities(number_format($clicks), ENT_QUOTES, 'UTF-8'); $html['leads'] = htmlentities(number_format($leads), ENT_QUOTES, 'UTF-8'); $html['su_ratio'] = htmlentities($su_ratio . '%', ENT_QUOTES, 'UTF-8'); $html['payout'] = htmlentities(dollar_format($payout), ENT_QUOTES, 'UTF-8'); $html['epc'] = htmlentities(dollar_format($epc), ENT_QUOTES, 'UTF-8'); $html['avg_cpc'] = htmlentities(dollar_format($avg_cpc, $cpv), ENT_QUOTES, 'UTF-8'); $html['income'] = htmlentities(dollar_format($income), ENT_QUOTES, 'UTF-8'); $html['cost'] = htmlentities(dollar_format($cost, $cpv), ENT_QUOTES, 'UTF-8'); $html['net'] = htmlentities(dollar_format($net, $cpv), ENT_QUOTES, 'UTF-8'); $html['roi'] = htmlentities(number_format($roi) . '%', ENT_QUOTES, 'UTF-8'); $html['ppc_account_name'] = htmlentities($info_row2['ppc_account_name'], ENT_QUOTES, 'UTF-8'); $html['aff_campaign_payout'] = htmlentities($info_row['aff_campaign_payout'], ENT_QUOTES, 'UTF-8'); $ppc_network_icon = pcc_network_icon($info_row2['ppc_network_name'], $info_row2['ppc_account_name']); //shorten campaign name if (strlen($html['ppc_account_name']) > 20) { $html['ppc_account_name'] = substr($html['ppc_account_name'], 0, 20) . '...'; } ?> <tr> <td colspan="4" style="text-align:left; padding-left: 10px;"><?php echo $ppc_network_icon; ?> - <?php echo $html['ppc_account_name']; ?> </td> <td><?php
$html['ppc_network_name'] = htmlentities($click_row['ppc_network_name'], ENT_QUOTES, 'UTF-8'); $html['ppc_account_name'] = htmlentities($click_row['ppc_account_name'], ENT_QUOTES, 'UTF-8'); $html['ip_address'] = htmlentities($click_row['ip_address'], ENT_QUOTES, 'UTF-8'); $html['click_cpc'] = htmlentities(dollar_format($click_row['click_cpc']), ENT_QUOTES, 'UTF-8'); $html['keyword'] = htmlentities($click_row['keyword'], ENT_QUOTES, 'UTF-8'); $html['click_lead'] = htmlentities($click_row['click_lead'], ENT_QUOTES, 'UTF-8'); $html['click_filtered'] = htmlentities($click_row['click_filtered'], ENT_QUOTES, 'UTF-8'); //rotate colors $html['row_class'] = 'item'; if ($x == 0) { $html['row_class'] = 'item alt'; $x = 1; } else { $x--; } $ppc_network_icon = pcc_network_icon($click_row['ppc_network_name'], $click_row['ppc_account_name']); if (geoLocationDatabaseInstalled() == true) { $html['location'] = ''; if ($click_row['location_country_name']) { if ($click_row['location_country_name']) { $origin = $click_row['location_country_name']; } if ($click_row['location_region_code'] and !is_numeric($click_row['location_region_code'])) { $origin = $click_row['location_region_code'] . ', ' . $origin; } if ($click_row['location_city_name']) { $origin = $click_row['location_city_name'] . ', ' . $origin; } $html['origin'] = htmlentities($origin, ENT_QUOTES, 'UTF-8'); $html['location'] = '<img title="' . $html['origin'] . '" src="http://' . $_SERVER['SERVER_NAME'] . '/xtracks-img/flags/' . strtolower($click_row['location_country_code']) . '.png"/>'; }
$html['browser_name'] = htmlentities($click_row['browser_name'], ENT_QUOTES, 'UTF-8'); $html['platform_name'] = htmlentities($click_row['platform_name'], ENT_QUOTES, 'UTF-8'); $html['country_code'] = htmlentities($click_row['country_code'], ENT_QUOTES, 'UTF-8'); $html['country_name'] = htmlentities($click_row['country_name'], ENT_QUOTES, 'UTF-8'); $html['region_name'] = htmlentities($click_row['region_name'], ENT_QUOTES, 'UTF-8'); $html['city_name'] = htmlentities($click_row['city_name'], ENT_QUOTES, 'UTF-8'); $html['isp_name'] = htmlentities($click_row['isp_name'], ENT_QUOTES, 'UTF-8'); //rotate colors $html['row_class'] = 'item'; if ($x == 0) { $html['row_class'] = 'item alt'; $x = 1; } else { $x--; } $ppc_network_icon = pcc_network_icon($click_row['ppc_network_name'], $click_row['ppc_account_name'], $html['referer_host']); if (!$click_row['type_name']) { $html['device_type'] = '<span id="device-tooltip"><span data-toggle="tooltip" title="Browser: ' . $html['browser_name'] . '<br/> Platform: ' . $html['platform_name'] . ' <br/>Device: ' . $html['device_name'] . '"><img title="' . $click_row['type_name'] . '" src="/202-img/icons/platforms/other.png"/></span></span>'; } else { $html['device_type'] = '<span id="device-tooltip"><span data-toggle="tooltip" title="Browser: ' . $html['browser_name'] . '<br/> Platform: ' . $html['platform_name'] . ' <br/>Device: ' . $html['device_name'] . '"><img title="' . $click_row['type_name'] . '" src="/202-img/icons/platforms/' . $click_row['type_name'] . '.png"/></span></span> <img src="/202-img/icons/browsers/' . getBrowserIcon($html['browser_name']) . '.png">'; } if (!$html['country_code']) { $html['country_code'] = 'non'; } //if this is an advance landing page, make the offer name, the landing page name if ($click_row['click_alp'] == 1) { $html['aff_campaign_name'] = $html['landing_page_nickname']; } //before it ends, if this click is past 5 seconds, set true to $endofnewclicks $diff = time() - $click_row['click_time']; if ($diff > 5 and $new == true) {