real_escape_string($time['to']); $mysql['from'] = $db->real_escape_string($time['from']); //show real or filtered clicks $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT user_pref_breakdown, user_pref_show, user_cpc_or_cpv FROM 202_users_pref WHERE user_id=".$mysql['user_id']; $user_result = _mysqli_query($user_sql, $dbGlobalLink); //($user_sql); $user_row = $user_result->fetch_assoc(); $breakdown = $user_row['user_pref_breakdown']; if ($user_row['user_pref_show'] == 'all') { $click_flitered = ''; } if ($user_row['user_pref_show'] == 'real') { $click_filtered = " AND click_filtered='0' "; } if ($user_row['user_pref_show'] == 'filtered') { $click_filtered = " AND click_filtered='1' "; } if ($user_row['user_pref_show'] == 'filtered_bot') { $click_filtered = " AND click_bot='1' "; } if ($user_row['user_pref_show'] == 'leads') { $click_filtered = " AND click_lead='1' "; } if ($user_row['user_cpc_or_cpv'] == 'cpv') $cpv = true; else $cpv = false; $de = new DataEngine(); $data=($de->getReportData('country', $mysql['from'], $mysql['to'],$cpv)); $dr= new DisplayData(); $dr->displayReport('country', $data, $de->foundRows()); ?>