Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory :  /home/u107206879/domains/escort46.de/public_html/admin/service/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	include "../db_connection.php";
	include "../sessioncheck.php";
	if(isset($_POST['crud']) && ($_POST['crud']=='delete') && !empty($_POST['crud']) && isset($_POST['value']) && !empty($_POST['value'])){
		$id = $_POST['value'];
		$sql=mysqli_query($connection,"SELECT photo FROM images WHERE em_id=$id");
		while($row=mysqli_fetch_assoc($sql)){
			$photo = $row['photo'];
			$photo_1 = '178_'.$photo;
			$photo_2 = '310_'.$photo;
			unlink("../../user_images/$photo");
			unlink("../../thumbnails/$photo_1");
			unlink("../../thumbnails/$photo_2");
		}
		//delete user's ads		 
		$sql=mysqli_query($connection,"select id as ad_id from advertise  WHERE em_id=$id");
		while($row=mysqli_fetch_assoc($sql)){
			$ad_id = "";
			$ad_id =$row['ad_id'];
			mysqli_query($connection,"DELETE FROM advertise WHERE id=$ad_id");
			mysqli_query($connection,"DELETE FROM ads_adservices WHERE ad_id=$ad_id");	
			mysqli_query($connection,"DELETE FROM page_ads_links WHERE ad_id=$ad_id");		
			mysqli_query($connection,"DELETE FROM images WHERE ad_id=$ad_id");
			mysqli_query($connection,"DELETE FROM off_messages WHERE sender_id='$ad_id' or receiver_id='$ad_id'");
			mysqli_query($connection,"DELETE FROM pricelist WHERE ad_id=$ad_id");
			mysqli_query($connection,"DELETE FROM report_ads WHERE ad_id=$ad_id");
			mysqli_query($connection,"DELETE FROM schedule WHERE ad_id=$ad_id");
			mysqli_query($connection,"DELETE FROM wishlist WHERE ad_id=$ad_id");
		}	
		
		//delete use data		
		mysqli_query($connection,"DELETE FROM user WHERE id=$id");
		mysqli_query($connection,"DELETE FROM advertise WHERE em_id=$id");
		mysqli_query($connection,"DELETE FROM images WHERE em_id=$id");
		mysqli_query($connection,"DELETE FROM pricelist WHERE em_id=$id");
		mysqli_query($connection,"DELETE FROM schedule WHERE em_id=$id");
		mysqli_query($connection,"DELETE FROM events WHERE em_id=$id");
		mysqli_query($connection,"DELETE FROM report_ads WHERE user_id=$id");
		mysqli_query($connection,"DELETE FROM support WHERE user_id=$id");
		mysqli_query($connection,"DELETE FROM support_tickets WHERE user_id=$id");
		mysqli_query($connection,"DELETE FROM wishlist WHERE user_id=$id");
		echo '1';
    }
?>