One Hat Cyber Team

Your IP : 108.162.241.211

Server IP : 188.114.97.4

Server : Linux thuru 6.5.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-4 (2023-11-20T10:19Z) x86_64

Server Software : Apache/2.4.51 (Unix) OpenSSL/1.0.2k-fips

PHP Version : 7.3.33

Buat File | Buat Folder

Dir : ~/home/thuruk/public_html/App/New/users/

View File Name : validate_otp.php


<?php
   
        include("../connections.php"); //database connection

        $mobile_number = mysqli_real_escape_string($connect,$_POST['mobile_number']);
        $pincode = mysqli_real_escape_string($connect,$_POST['pincode']);
        $session = mysqli_real_escape_string($connect,$_POST['session_id']);

		$json;
		if($session != "5f0e6bfbafe255ds003434349") {
			$json['status'] = 400;
			$json['msg'] = 'Session Expired';
		} else {
			$rsData = array();
		
		   $query="SELECT * FROM `user_otp` inner join users WHERE users.user_id =user_otp.user_id AND users.user_id='$mobile_number' AND otp_number='$pincode'";
		   
		   $rs = mysqli_query($connect,$query) or die(mysqli_error($connect));

                
                if(mysqli_num_rows($rs) == 1){
                    
                    $update_user="UPDATE `users` SET `status`='activate' WHERE user_id='$mobile_number'";
                      mysqli_query($connect,$update_user) or die(mysqli_error($connect));
                      
                      $otptable="UPDATE `user_otp` SET `status`='validated' WHERE user_id='$mobile_number' AND otp_number='$pincode'";
                      mysqli_query($connect,$otptable) or die(mysqli_error($connect));

                    
                    
                }


		   if($rs){
			   
			   	foreach($rs as $k => $v){
					$rsData[$k]['user_id'] = $v['user_id'];
					$rsData[$k]['name'] = $v['name'];
					$rsData[$k]['city'] =  $v['city'];
					$rsData[$k]['password'] = $v['password'];
					$rsData[$k]['status'] =  $v['status'];
				}
			}
			$json['status'] = 200;
			$json['msg'] = 'Success';
			$json['data'] = $rsData;
		}
//		header("Content-Type: application/json");
		
		echo json_encode($json);


?>