real_escape_string($_SESSION['user_id']); $user_sql = "SELECT user_time_register FROM 202_users WHERE user_id=".$mysql['user_id']; $user_result = _mysqli_query($user_sql); $user_row = $user_result->fetch_assoc(); $campaign_sql = "SELECT aff_campaign_id, aff_campaign_name FROM 202_aff_campaigns WHERE user_id=".$mysql['user_id']." AND aff_campaign_deleted = '0'"; $campaign_result = _mysqli_query($campaign_sql); $time = grab_timeframe(); $html['from'] = date('m/d/Y - G:i', $time['from']); $html['to'] = date('m/d/Y - G:i', $time['to']); $mysql['to'] = $db->real_escape_string($time['to']); $mysql['from'] = $db->real_escape_string($time['from']); $logs_sql = "SELECT 2ca.aff_campaign_name, 2l.click_id, 2l.click_time, 2l.conv_time, 2l.time_difference, 2l.ip, 2l.pixel_type, 2l.user_agent FROM 202_conversion_logs AS 2l LEFT JOIN 202_aff_campaigns AS 2ca ON (2l.campaign_id = 2ca.aff_campaign_id) WHERE 2l.user_id=".$mysql['user_id']." AND 2l.click_time >= ".$mysql['from']." AND 2l.click_time < ".$mysql['to']; $logs_result = _mysqli_query($logs_sql); //show the template template_top('Conversion Logs',NULL,NULL,NULL); ?>
Conversion Logs
Refine your search:
Results %s
',$logs_result->num_rows); ?>
fetch_assoc()) { ?>
SubID Campaign Click Time Conversion Time Time Difference IP Address Pixel Type
User agent: