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: delete.php

<?php include('../functions.php');?>
<?php include('../login/auth.php');?>
<?php 
	$list_id = isset($_POST['list_id']) && is_numeric($_POST['list_id']) ? mysqli_real_escape_string($mysqli, (int)$_POST['list_id']) : exit;
	
	//delete autoresopnder emails
	$q = 'SELECT id FROM ares WHERE list = '.$list_id;
	$r = mysqli_query($mysqli, $q);
	if ($r && mysqli_num_rows($r) > 0)
	{
	    while($row = mysqli_fetch_array($r))
	    {
			$ares_id = $row['id'];
			
			$q2 = 'DELETE FROM ares_emails WHERE ares_id = '.$ares_id;
			mysqli_query($mysqli, $q2);
	    }  
	}	
	//delete autoresponder
	$q = 'DELETE FROM ares WHERE list = '.$list_id;
	mysqli_query($mysqli, $q);
	
	//delete segments
	$q = 'SELECT id FROM seg WHERE list = '.$list_id;
	$r = mysqli_query($mysqli, $q);
	if ($r && mysqli_num_rows($r) > 0)
	{
	    while($row = mysqli_fetch_array($r))
	    {
			$seg_id = $row['id'];
			
			$q2 = 'DELETE FROM seg_cons WHERE seg_id = '.$seg_id;
			mysqli_query($mysqli, $q2);
	    }  
	}	
	//delete segments
	$q = 'DELETE FROM seg WHERE list = '.$list_id;
	mysqli_query($mysqli, $q);
	
	//delete skipped_emails
	$q = 'DELETE FROM skipped_emails WHERE list = '.$list_id;
	mysqli_query($mysqli, $q);
	
	//Delete rules
	$q = 'DELETE FROM rules WHERE list = '.$list_id;
	mysqli_query($mysqli, $q);
	
	//delete list and its subscribers
	$q = 'DELETE FROM lists WHERE id = '.$list_id.' AND userID = '.get_app_info('main_userID');
	$r = mysqli_query($mysqli, $q);
	if ($r)
	{
		$q2 = 'DELETE FROM subscribers WHERE list = '.$list_id;
		$r2 = mysqli_query($mysqli, $q2);
		if ($r2)
		{
			//delete CSV file (in case it was uploaded and waiting for import by cron)
			$server_path_array = explode('delete.php', $_SERVER['SCRIPT_FILENAME']);
			$server_path = str_replace('includes/list/', '', $server_path_array[0]).'uploads/csvs/';
		
			$filename = $server_path.get_app_info('main_userID').'-'.$list_id.'.csv';
			
			if(file_exists($filename))	unlink($filename);
	
		    echo true; 
		}
	}
?>