FM / angel

/home/desid573/public_html/angel

Name	Size	Mode	Actions
assets/	-	0755	rm
drivers/	-	0755	rm
font/	-	0755	rm
lib/	-	0755	rm
payment/	-	0755	rm
stripe/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
angeldrivers.png	132095	0644	edit dl rm
a_name_address.php	1289	0644	edit dl rm
booking.php	9621	0644	edit dl rm
booking_28-04-2017.php	947	0644	edit dl rm
booking_29-04-2017.php	3717	0644	edit dl rm
cancel.php	2430	0644	edit dl rm
cancel_booking.php	5367	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2582	0644	edit dl rm
contact_us_mail.php	903	0644	edit dl rm
dispatch.php	864	0644	edit dl rm
error_log	436257456	0644	edit dl rm
generate_credit.php	3187	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getPrice.php	738	0644	edit dl rm
getuser_byid.php	2341	0644	edit dl rm
getuser_bymail.php	1968	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	2219	0644	edit dl rm
get_completed_bookings.php	727	0644	edit dl rm
get_directions.php	813	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1465	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
home.php	1660	0644	edit dl rm
homekey_img.png	14037	0644	edit dl rm
hook.php	21267	0644	edit dl rm
hook_set_up.php	654	0644	edit dl rm
index.php	12007	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
jobdetails.php	12197	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	7798	0644	edit dl rm
login_api_old.php	5653	0644	edit dl rm
noteconfirm.php	9259	0644	edit dl rm
online_booking.php	28283	0644	edit dl rm
passwordResetLink.php	5195	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2184	0644	edit dl rm
priceCheck.php	0	0644	edit dl rm
reset_email.php	1755	0644	edit dl rm
search.php	830	0644	edit dl rm
send_bulk_notif.php	1692	0644	edit dl rm
setprice.php	4429	0644	edit dl rm
setprice_database.php	585	0644	edit dl rm
smsconfirm.php	9830	0644	edit dl rm
smssend.php	2354	0644	edit dl rm
stripe-php-master.zip	254366	0644	edit dl rm
test1.php	159	0644	edit dl rm
test_222.php	845	0644	edit dl rm
thankyou.php	17470	0644	edit dl rm
update_api.php	6290	0644	edit dl rm
update_api_on_mail.php	4677	0644	edit dl rm
validatecode.php	1094	0644	edit dl rm
validatephone.php	1034	0644	edit dl rm

Edit: /home/desid573/public_html/angel/generate_referall.php (2779B)

<?php
require("lib/config.php");

// =============== Get referral code 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;
        $cid = $row["id"];
		
    }
    
    $seed = str_split('abcdefghijklmnopqrstuvwxyz'
                 .'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
                 .'0123456789!@'); 
shuffle($seed); // probably optional since array_is randomized; this may be redundant
$rand = '';
foreach (array_rand($seed, 6) as $k) $rand .= $seed[$k];

$sql = "SELECT * FROM `referrals` WHERE `customer_id` = '".$cid."'";
$exist = $conn->query($sql);

if ($exist->num_rows >0) {
	$cell = $exist->fetch_assoc();
	$code = $cell["code"];
	$value = $cell["value"];
	$sql = "SELECT * FROM `referal_claim` WHERE `customer_id` = '".$cid."'";
	$claims = $conn->query($sql);
	if($claims->num_rows >0) {
	$claimsRow = $claims->fetch_assoc();
	$ref_created = $claimsRow["referrals_generated"];
	$ref_claimed = $claimsRow["referrals_claimed"];
	$value = $claimsRow["value"];
	
	} else {
	$ref_created = 0;
	$ref_claimed = 0;
	$value = 0;
	
	}
	
	
	$Res["message"] = "Referral Code Already Exists"; 
	$Res["status"] = "OK";
	$Res["code"] = $code;
	$Res["value"] = $value;
	$Res["ref_created"] = $ref_created;
	$Res["ref_claimed"] = $ref_claimed;
	$Res["value"] = $value;

} else {

$code = "RF".$rand;
  $value = "0.8";
		
    
    			$sql = "INSERT INTO `referrals` (`id`, `customer_id`, `code`, `value`, `date_created`, `date_modified`) VALUES (NULL, '".$cid."', '".$code."', '".$value."', NOW() ,NOW() )";
    		$success = $conn->query($sql);
    		
    		
			
			
			
			
    	if($success) {
	$Res["message"] = "Referral Code Generated"; 
	$Res["status"] = "OK";
	$Res["code"] = $code;
	$Res["ref_created"] = 0;
	$Res["ref_claimed"] = 0;
	$Res["value"] = 0;
	 
	
	
	
	} else {
	$Res["message"] = "Error Generating Referral Code"; 
	$Res["status"] = "error"; 
	echo $conn->error;
	}
	}
	
	$sql = "SELECT * FROM credits where customer_id = '".$cid."' and is_used = 0";
	$result = $conn->query($sql);
	$credit_value = 0;
		if ($result->num_rows > 0) 
		{
		    	while($row = $result->fetch_assoc()) 
			{
		        $credit_value = $credit_value + $row['value'];
				
		    	}
		    	$Res["credit_value"] = $credit_value;
		    } else {
		    	$Res["credit_value"] = 0;
		    }
	
	
		
} else {
$Res["message"] = "Customer not found"; 
$Res["status"] = "error"; 
error_log("add to customers error: ".$conn->error);
}

echo json_encode(new ArrayObject($Res)); 
/*echo "<pre>";
print_r($Res);
//print_r($response);
echo "</pre>";*/
$conn->close();

cmd: