FM / drivers

/home/desid573/public_html/angel/drivers/

/home/desid573/public_html/angel/drivers

Name	Size	Mode	Actions
twilio-php-master/	-	0755	rm
avail.php	19359	0644	edit dl rm
cancel_booking.php	4537	0644	edit dl rm
checkDetails.php	1050	0644	edit dl rm
create.php	2332	0644	edit dl rm
createbilling.php	7335	0644	edit dl rm
createdriver.php	4708	0644	edit dl rm
daily.php	9342	0644	edit dl rm
default.php	16383	0644	edit dl rm
delete.php	942	0644	edit dl rm
deletedriver.php	3508	0644	edit dl rm
error_log	193375	0644	edit dl rm
getDailyAvailability.php	3065	0644	edit dl rm
getDefaultAvailability.php	1102	0644	edit dl rm
getDriverAvailability.php	1642	0644	edit dl rm
home.php	5517	0644	edit dl rm
login.php	7782	0644	edit dl rm
loginDriver.php	1214	0644	edit dl rm
new.php	835	0644	edit dl rm
off.php	3502	0644	edit dl rm
register.php	8676	0644	edit dl rm
setDefaultAvailability.php	3257	0644	edit dl rm
setDriverAvailability.php	3365	0644	edit dl rm
setDriverPin.php	2189	0644	edit dl rm
smsregister.php	1564	0644	edit dl rm
updateDetails.php	3350	0644	edit dl rm

Edit: /home/desid573/public_html/angel/drivers/setDefaultAvailability.php (3257B)

<?php

$driver = $_POST['driver'];

$day1 = $_POST['day1'];
$day2 = $_POST['day2'];
$day3 = $_POST['day3'];
$day4 = $_POST['day4'];
$day5 = $_POST['day5'];
$day6 = $_POST['day6'];
$day7 = $_POST['day7'];

if($driver != "") {

$dbhost = "localhost";
	    $dbuser = "desid573_famcab";
	    $dbpass = "C]+6wQySxov(";
	    $dbname = "desid573_eway_codes";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    
	    $query   = "SELECT * FROM driver_default_avail WHERE driver = '".$driver."'";
	    $success = $conn->query($query);
 
	    if (!$success) {
    		error_log("Couldn't enter data: ".$conn->error);
    		}
    		
    	if($success->num_rows > 0) {
    	    $query   = "UPDATE driver_default_avail SET day1 = '".$day1."', day2 = '".$day2."', day3 = '".$day3."', day4 = '".$day4."', day5 = '".$day5."', day6 = '".$day6."', day7 = '".$day7."', date_updated = NOW() WHERE driver = '".$driver."'";
	        $success = $conn->query($query);
	        if($success) {
	            $response = ["status" => "OK", "message" => "Updated new default availability"];
	        } else {
	            error_log($conn->error);
	            $response = ["status" => "error", "message" => "Error updating new default availability"];
	        }
    	    
    	} else {
    	    //insert
    	    $query   = "INSERT INTO driver_default_avail (id, driver, day1, day2, day3, day4, day5, day6, day7, date_updated) VALUES (NULL, '".$driver."', '".$day1."', '".$day2."', '".$day3."', '".$day4."', '".$day5."', '".$day6."',	'".$day7."', NOW())";
    	    $success = $conn->query($query);
	        
	        if($success) {
	            $response = ["status" => "OK", "message" => "Added new default availability"];
	        } else {
	            error_log($conn->error);
	            $response = ["status" => "error", "message" => "Error adding new default availability"];
	        }
	        
	        
	        
	        
    	}
    		
    		
} else {
    ["status" => "error", "message" => "Not enough data"];
    
}

$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    
	    $query   = "SELECT * FROM drivers WHERE id = ".$driver;
	    $success = $conn->query($query);
        $row = $success->fetch_assoc();
        $drivername = $row["driver"];
            
            $slackmessage = $drivername." has updated default availability\nSun: ".$day1."\nMon: ".$day2."\nTues: ".$day3."\nWed: ".$day4."\nThurs: ".$day5."\nFri: ".$day6."\nSat: ".$day7;

$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": "'.$slackmessage.'"}');

$response = curl_exec($curlObj);

curl_close($curlObj);

echo json_encode($response, true);
    		
    		?>

connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query = "SELECT * FROM driver_default_avail WHERE driver = '".$driver."'"; $success = $conn->query($query); if (!$success) { error_log("Couldn't enter data: ".$conn->error); } if($success->num_rows > 0) { $query = "UPDATE driver_default_avail SET day1 = '".$day1."', day2 = '".$day2."', day3 = '".$day3."', day4 = '".$day4."', day5 = '".$day5."', day6 = '".$day6."', day7 = '".$day7."', date_updated = NOW() WHERE driver = '".$driver."'"; $success = $conn->query($query); if($success) { $response = ["status" => "OK", "message" => "Updated new default availability"]; } else { error_log($conn->error); $response = ["status" => "error", "message" => "Error updating new default availability"]; } } else { //insert $query = "INSERT INTO driver_default_avail (id, driver, day1, day2, day3, day4, day5, day6, day7, date_updated) VALUES (NULL, '".$driver."', '".$day1."', '".$day2."', '".$day3."', '".$day4."', '".$day5."', '".$day6."', '".$day7."', NOW())"; $success = $conn->query($query); if($success) { $response = ["status" => "OK", "message" => "Added new default availability"]; } else { error_log($conn->error); $response = ["status" => "error", "message" => "Error adding new default availability"]; } } } else { ["status" => "error", "message" => "Not enough data"]; } $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query = "SELECT * FROM drivers WHERE id = ".$driver; $success = $conn->query($query); $row = $success->fetch_assoc(); $drivername = $row["driver"]; $slackmessage = $drivername." has updated default availability\nSun: ".$day1."\nMon: ".$day2."\nTues: ".$day3."\nWed: ".$day4."\nThurs: ".$day5."\nFri: ".$day6."\nSat: ".$day7; $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": "'.$slackmessage.'"}'); $response = curl_exec($curlObj); curl_close($curlObj); echo json_encode($response, true); ?>