OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/18/2021 10:11:21 AM	rwxr-xr-x
📄 add-custom-field.php	2.46 KB	11/18/2021 09:43:19 AM	rw-r--r--
📄 delete-custom-field.php	2.27 KB	11/18/2021 09:43:20 AM	rw-r--r--
📄 delete.php	1.94 KB	11/18/2021 09:43:20 AM	rw-r--r--
📄 dismiss.php	407 bytes	11/18/2021 09:43:20 AM	rw-r--r--
📄 edit-custom-field.php	2.35 KB	11/18/2021 09:43:19 AM	rw-r--r--
📄 edit.php	3.75 KB	11/18/2021 09:43:20 AM	rw-r--r--
📄 export-skipped-emails.php	1.22 KB	11/18/2021 09:43:19 AM	rw-r--r--
📄 main.php	10.37 KB	11/18/2021 09:43:19 AM	rw-r--r--
📄 progress.php	2.04 KB	11/18/2021 09:43:19 AM	rw-r--r--

Editing: export-skipped-emails.php

<?php include('../functions.php');?>
<?php include('../login/auth.php');?>
<?php 
	/********************************/
	$l = isset($_GET['l']) && is_numeric($_GET['l']) ? mysqli_real_escape_string($mysqli, (int)$_GET['l']) : '';
	$filename = 'not-imported.csv';
	$data = '';
	/********************************/
	
	//Get all skipped eamils from last import
	$q = 'SELECT email, reason FROM skipped_emails use index (s_list) WHERE list = '.$l.' ORDER BY reason ASC, email ASC';
	$r = mysqli_query($mysqli, $q);
	if ($r && mysqli_num_rows($r) > 0)
	{
	    while($row = mysqli_fetch_array($r))
	    {
			$email = $row['email'];
			$reason = $row['reason'];
			
			if($reason==1)
				$data .= $email.',Malformed'."\n";
			else if($reason==2)
				$data .= $email.',Unsubscribed / Bounced /Marked as spam'."\n";
			else if($reason==3)
				$data .= $email.',Already exists'."\n";
			else if($reason==4)
				$data .= $email.',Suppressed'."\n";
	    }  
	}
	$first_line = '"'._('Email address').'","'._('Reason').'"'."\n";
	$data = $first_line.str_replace("\r" , "" , $data);
	
	header("Content-type: application/csv");
	header("Content-Disposition: attachment; filename=\"$filename\"");
	header("Pragma: no-cache");
	header("Expires: 0");
	print "$data";
?>