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/en/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	include "db_connection.php";
	if(!empty($_GET['code']) && isset($_GET['code'])){
		
		$code=$_GET['code'];
		
		$sql="SELECT * FROM user WHERE activationcode='".$code."'";
		$sqlres=mysqli_query($connection,$sql);
		$num = mysqli_num_rows($sqlres);
		
		if($num>0){
			$result4 = mysqli_fetch_array($sqlres);
			$new_email = $result4['new_email_request'];
			$status = $result4['status'];
			if($new_email == ''){
				$sql2="UPDATE user SET status=1 WHERE activationcode='".$code."'";
				$result1=mysqli_query($connection,$sql2);
				$sql3="UPDATE advertise SET adstatus=1 WHERE em_id='".$result4['id']."'";
				$result2=mysqli_query($connection,$sql3);
				$msg="Verification Completed."; 
				$_SESSION['status'] = 1;
				header("location: ".SUB_URL."/login");
			}elseif($status == 1){
				$sql2="UPDATE user SET status=1, email='".$new_email."', new_email_request='' WHERE activationcode='".$code."'";
				$result1=mysqli_query($connection,$sql2);
				$msg="Verification Completed."; 
				$_SESSION['status'] = 1;
				header("location: ".SUB_URL."/login");
			}else{
				$_SESSION['status'] = 1;
				header("location: ".SUB_URL."/login");
			}
		}else{
			echo $msg ="Wrong activation code! Contact support for help: [email protected]";
		}
	}
?>