real_escape_string($_SESSION['user_id']); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $from = explode('-', $_POST['from']); $from = explode(':', $from[1]); $from_hour = $from[0]; $from_minute = $from[1]; $from = explode('-', $_POST['from']); $from = explode('/', $from[0]); $from_month = trim($from[0]); $from_day = trim($from[1]); $from_year = trim($from[2]); $to = explode('-', $_POST['to']); $to = explode(':', $to[1]); $to_hour = $to[0]; $to_minute = $to[1]; $to = explode('-', $_POST['to']); $to = explode('/', $to[0]); $to_month = trim($to[0]); $to_day = trim($to[1]); $to_year = trim($to[2]); $clean['from'] = mktime($from_hour,$from_minute,0,$from_month,$from_day,$from_year); $clean['to'] = mktime($to_hour,$to_minute,59,$to_month,$to_day,$to_year); $mysql['from'] = $db->real_escape_string($clean['from']); $mysql['to'] = $db->real_escape_string($clean['to']); $mysql['click_id'] = $db->real_escape_string($_POST['logs_subid']); $mysql['campaign_id'] = $db->real_escape_string($_POST['logs_campaign']); $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']; if ($_POST['logs_campaign']) { $logs_sql .= " AND campaign_id = '".$mysql['campaign_id']."'"; } if ($_POST['logs_subid']) { $logs_sql .= " AND click_id = '".$mysql['click_id']."'"; } $logs_result = _mysqli_query($logs_sql); } ?>
Results %s
',$logs_result->num_rows); ?>
fetch_assoc()) { ?>
SubID Campaign Click Time Conversion Time Time Difference IP Address Pixel Type
User agent: