FM / app

/home/desid573/public_html/app

Name	Size	Mode	Actions
braintree/	-	0755	rm
lib/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
appoff.php	4782	0644	edit dl rm
booking.php	9655	0644	edit dl rm
cancel_booking.php	4925	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2983	0644	edit dl rm
contact_us_mail.php	890	0644	edit dl rm
copy_account_to_homekey.php	4334	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
emailConfirmReset.php	401	0644	edit dl rm
error_log	586874	0644	edit dl rm
family-cab_small.jpg	98853	0644	edit dl rm
generate_credit.php	3098	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getuser_byid.php	2341	0644	edit dl rm
getuser_bymail.php	2183	0644	edit dl rm
get_all_booking.php	779	0644	edit dl rm
get_booking_bybooking_id.php	813	0644	edit dl rm
get_booking_byuser.php	1057	0644	edit dl rm
get_booking_status.php	2170	0644	edit dl rm
get_completed_bookings.php	710	0644	edit dl rm
get_ETA.php	6332	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1399	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
get_price.php	760	0644	edit dl rm
get_recipes.php	6361	0644	edit dl rm
get_TE.php	1217	0644	edit dl rm
index.php	10411	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	5789	0644	edit dl rm
noteconfirm.php	8208	0644	edit dl rm
off.php	2854	0644	edit dl rm
passwordResetLink.php	5190	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2141	0644	edit dl rm
post.php	2535	0644	edit dl rm
reset_email.php	1775	0644	edit dl rm
reset_phone.php	5717	0644	edit dl rm
test_222.php	845	0644	edit dl rm
update_api.php	5910	0644	edit dl rm
update_api_on_mail.php	4723	0644	edit dl rm
validatecode.php	1094	0644	edit dl rm
validatephone.php	1055	0644	edit dl rm

Edit: /home/desid573/public_html/app/copy_account_to_homekey.php (4334B)

<?php
require("lib/config.php");
require_once 'vendor/eway/eway-rapid-php/include_eway.php';
// =============== Get customer user api ===================================
$data  = $_REQUEST;
$sql = "SELECT * FROM customers where email = '".$_REQUEST['username']."'";
$result = $conn->query($sql);
if ($result->num_rows > 0) 
{
    while($row = $result->fetch_assoc()) 
	{
        $customer[] = $row;
		$sql = "SELECT * FROM `customer_details` where `cid` = '".$row["id"]."'"; 
		$result = $conn->query($sql);
		if ($result->num_rows > 0) 
		{
			while($row_details = $result->fetch_assoc()) 
			{
				$cust_detail[] = $row_details;
			}
		}
		
		$sql = "SELECT * FROM `customer_tokens`  where `cid` = '".$row["id"]."'"; 
		$result = $conn->query($sql);
		if ($result->num_rows > 0) 
		{
			while($row_token = $result->fetch_assoc()) 
			{
				$cust_token[] = $row_token;
			}
		}
    }
    
    	$dbhost = "localhost";
	$dbuser = "perthdes_coder";
	$dbpass = "coder1234!@#$";
	$dbname = "perthdes_new_pro_api";
	$conn = new mysqli($dbhost , $dbuser , $dbpass , $dbname );
// Check connection
 
	
	$sql = "SELECT * FROM customers where email = '".$_REQUEST['username']."'";
	$result = $conn->query($sql);
	if ($result->num_rows > 0) 
	{
		$Res["message"] = "Customer Already Exists"; 
		$Res["staus"] = "error";
		} else {

// Create connection
		$conn = new mysqli($dbhost , $dbuser , $dbpass , $dbname );
		// Check connection
		if ($conn->connect_error) {
  			  die("Connection failed: " . $conn->connect_error);
		} 
		
		$fullname = $customer[0]["name"];
		
    
    			$sql = "INSERT INTO `customers` (`id`, `name`, `mobile`, `email`,`password`, `firebase_token`, `promo_code`, `promo_used`,  			`is_delete`, `created`, `modified`) VALUES (NULL, '".$fullname."', '".$customer[0]["mobile"]."', '".$_REQUEST["username"]."', '".$customer[0]["password"]."', '', 'COPYFC', '0', '0',NOW() ,NOW() )";
    		if ($conn->query($sql) === TRUE) 
			{
			$cid = $conn->insert_id;
				if($conn->insert_id)
				{
			$sql_detail = "INSERT INTO `perthdes_new_pro_api`.`customer_details` (`id`, `cid`, `address`, `addr_lat`, `addr_long`) VALUES (NULL, '".$cid."', '".$cust_detail[0]["address"]."', '".$cust_detail[0]["addr_lat"]."','".$cust_detail[0]["addr_long"]."')";
					
					if ($conn->query($sql_detail) === TRUE) 
					{
						//$Res["customer_detail_id"] = $conn->insert_id;
						//$Res["customer_detail_status"] = "OK";
						$success[] = "Ok" ;
					}
					else
					{
						//$Res["customer_detail_status"] = "Error";
						$error[] = "Error";
						
					}
				$sql_token = "INSERT INTO `perthdes_new_pro_api`.`customer_tokens` (`id`, `cid`, `access_token_value`, `status`, `created`, `modified`) VALUES (NULL, '".$cid."', '".$cust_token ."', '1', NOW(), NOW())";
							
							if ($conn->query($sql_token) === TRUE) 
							{
								//$Res["customer_token_id"] = $conn->insert_id;
								//$Res["customer_token_status"] = "OK";
								$success[] = "Ok" ;
							}
							else
							{
								//$Res["customer_token_status"] = "Error";
								$error[] = "Error";
							}
					}
			
			
			
    	if(!$error) {
	$Res["message"] = "Details Copied to HomeKey App"; 
	$Res["staus"] = "OK"; 
	curlObj = curl_init();
	curl_setopt($curlObj, CURLOPT_URL, 'https://hooks.slack.com/services/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');
	curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
	curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
	curl_setopt($curlObj, CURLOPT_HEADER, 0);
	curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
	curl_setopt($curlObj, CURLOPT_POST, 1);
	curl_setopt($curlObj, CURLOPT_POSTFIELDS, '{"text": "New Customer '.$fullname.' created from FamCab App"}');

$response = curl_exec($curlObj);

curl_close($curlObj);
	
	} else {
	$Res["message"] = "Error Copying Payment Details"; 
	$Res["staus"] = "error"; 
	}
		
	} else {
	$Res["message"] = "Error Copying Customer Details"; 
	$Res["staus"] = "error"; 
	error_log("add to customers error: ".$conn->error);
	}
	
	}

} 
else 
{
	$Res["message"] = "Error Accessing Details"; 
	$Res["staus"] = "error"; 
}
	
	
echo json_encode(new ArrayObject($Res)); 
/*echo "<pre>";
print_r($Res);
//print_r($response);
echo "</pre>";*/
$conn->close();
// =============== New customer user api End Here ==========================

cmd: