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/after_booking_page.php (2595B)

<?php
require("lib/config.php");
require_once 'vendor/eway/eway-rapid-php/include_eway.php';
$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;
			}
		}
		$sql = "SELECT * FROM `booking` where email = '".$_REQUEST['username']."'";
		$result = $conn->query($sql);
		if ($result->num_rows > 0) 
		{
			while($row_booking = $result->fetch_assoc()) 
			{
				$cust_booking[] = $row_booking;
			}
		}
		
    }
}
$name = $customer[0]["name"];
$name_split = explode(" ",$name);
$fname = $name_split[0];
$lname = $name_split[1];
$cus = $customer[0]["name"];
$mob = $customer[0]["mobile"];

$Res["data"]["id"] = $customer[0]["id"];
		$Res["data"]["name"] = $customer[0]["name"];
		$Res["data"]["mobile"] = $customer[0]["mobile"];
		$Res["data"]["email"] = $customer[0]["email"];
		$Res["data"]["address"] = $cust_detail[0]["address"];
		$Res["data"]["addr_lat"] = $cust_detail[0]["addr_lat"];
		$Res["data"]["addr_long"] = $cust_detail[0]["addr_long"];
		$Res["data"]["pickup_addr"] = $cust_booking[0]["pickup_addr"];
		$Res["data"]["pickup_lat"] = $cust_booking[0]["pickup_lat"];
		$Res["data"]["pickup_long"] = $cust_booking[0]["pickup_long"];
		$Res["data"]["pickoff_addr"] = $cust_booking[0]["pickoff_addr"];
		$Res["data"]["pickoff_lat"] = $cust_booking[0]["pickoff_lat"];
		$Res["data"]["pickoff_long"] = $cust_booking[0]["pickoff_long"];
		$Res["data"]["booking_date"] = $cust_booking[0]["booking_date"];
		$Res["data"]["booking_time"] = $cust_booking[0]["booking_time"];
		$Res["data"]["Access_token"] = $cust_token[0]["access_token_value"];
		$Res["data"]["show_message"] = "Thank you for submitting your booking. Please make sure the above details are correct. 
You will receive confirmation via SMS within 30 mins. 
When the driver is en route you will receive a tracking link via SMS with driver contact details and their ETA.
Please call 1300466365 if you need to make any changes at short notice."; 
	echo json_encode(new ArrayObject($Res));

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; } } $sql = "SELECT * FROM `booking` where email = '".$_REQUEST['username']."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_booking = $result->fetch_assoc()) { $cust_booking[] = $row_booking; } } } } $name = $customer[0]["name"]; $name_split = explode(" ",$name); $fname = $name_split[0]; $lname = $name_split[1]; $cus = $customer[0]["name"]; $mob = $customer[0]["mobile"]; $Res["data"]["id"] = $customer[0]["id"]; $Res["data"]["name"] = $customer[0]["name"]; $Res["data"]["mobile"] = $customer[0]["mobile"]; $Res["data"]["email"] = $customer[0]["email"]; $Res["data"]["address"] = $cust_detail[0]["address"]; $Res["data"]["addr_lat"] = $cust_detail[0]["addr_lat"]; $Res["data"]["addr_long"] = $cust_detail[0]["addr_long"]; $Res["data"]["pickup_addr"] = $cust_booking[0]["pickup_addr"]; $Res["data"]["pickup_lat"] = $cust_booking[0]["pickup_lat"]; $Res["data"]["pickup_long"] = $cust_booking[0]["pickup_long"]; $Res["data"]["pickoff_addr"] = $cust_booking[0]["pickoff_addr"]; $Res["data"]["pickoff_lat"] = $cust_booking[0]["pickoff_lat"]; $Res["data"]["pickoff_long"] = $cust_booking[0]["pickoff_long"]; $Res["data"]["booking_date"] = $cust_booking[0]["booking_date"]; $Res["data"]["booking_time"] = $cust_booking[0]["booking_time"]; $Res["data"]["Access_token"] = $cust_token[0]["access_token_value"]; $Res["data"]["show_message"] = "Thank you for submitting your booking. Please make sure the above details are correct. You will receive confirmation via SMS within 30 mins. When the driver is en route you will receive a tracking link via SMS with driver contact details and their ETA. Please call 1300466365 if you need to make any changes at short notice."; echo json_encode(new ArrayObject($Res));