FM / cal

/home/desid573/public_html/magicride.ng/cal/

/home/desid573/public_html/magicride.ng/cal

Name	Size	Mode	Actions
components/	-	0755	rm
css/	-	0755	rm
fonts/	-	0755	rm
img/	-	0755	rm
js/	-	0755	rm
less/	-	0755	rm
tmpls/	-	0755	rm
bower.json	315	0644	edit dl rm
check.php	463	0644	edit dl rm
composer.json	839	0644	edit dl rm
config.php	342	0644	edit dl rm
CONTRIBUTING.md	372	0644	edit dl rm
error_log	1379	0644	edit dl rm
events.json.php	1742	0644	edit dl rm
event_report.php	5315	0644	edit dl rm
get-event-list.php	1803	0644	edit dl rm
getEvents.php	716	0644	edit dl rm
Gruntfile.js	1076	0644	edit dl rm
index-bs3.html	7991	0644	edit dl rm
index.html	8237	0644	edit dl rm
LICENSE	1080	0644	edit dl rm
min.html	4309	0644	edit dl rm
min.php	5924	0644	edit dl rm
package.json	832	0644	edit dl rm
README.md	9183	0644	edit dl rm
register-driver.php	3277	0644	edit dl rm
web.config	188	0644	edit dl rm

Edit: /home/desid573/public_html/magicride.ng/cal/register-driver.php (3277B)

<?php

require("config.php");
require_once('../class.phpmailer.php');
    require_once('../class.smtp.php');

$event = $_GET["event"];

$driver_id = $_GET["ref"];

if($event != "" AND $driver_id != "") {
    
    $sql = "SELECT * FROM onboard_register WHERE driver_id = ".$driver_id;
    
    $success = $conn->query($sql);
    
    if($success->num_rows > 0) {
        
        $response["status"] = "error";
        $response["message"] = "You have already registered";
        
        
    } else {
        
        $sql = "INSERT INTO onboard_register (`id`, `event_id`, `driver_id`, `date_signed_up`) VALUES (NULL,".$event.",".$driver_id.", NOW())";
        
        
        
        $success = $conn->query($sql);
        
        if(!$success) {
            
            $response["status"] = "error";
            $response["message"] = $conn->error;
            
            
        } else {
            
            $sql = "SELECT * FROM driver_onboard WHERE id = ".$driver_id;
            
            $success = $conn->query($sql);
    
            if($success->num_rows > 0) {
                
                $row = $success->fetch_assoc();
                
                $response["driver_name"] = $row["first_name"];
                $response["status"] = "success";
                $response["message"] = "Successfully added";
                date_default_timezone_set("Africa/Lagos");
                $sql = "SELECT * FROM onboard_events WHERE id = ".$_GET["event"];
                
                $success = $conn->query($sql);
                
                $event = $success->fetch_assoc();
                
                $message = "<h3>Thanks for registering for an Onboarding Session with MagicRide</h3>";
                $message .= "<p>You have registered for ".$event["title"].".</p>";
                $message .= "<p>Please arrive before ".date("g a", $event["start_time"]/1000)." as training will begin promptly</p>";
                
                
                $message .= "</p>Kind Regards<br><br>The MagicRide Team</p>.";
        
                $mail = new PHPMailer;   
                $mail->SMTPDebug = false;      
                $mail->isSMTP();                                    
                $mail->Host = "hp275.hostpapa.com";  // specify main and backup server
                $mail->Port = 465;
                $mail->SMTPSecure = "ssl";
                $mail->SMTPAuth = true;     // turn on SMTP authentication
                $mail->Username = "training@magicride.ng";  // SMTP username
                $mail->Password = "magicride2019"; // SMTP password
                
                $mail->From = "training@magicride.ng";
                $mail->FromName = "MagicRide";
                //$mail->AddAddress($_POST["inputEmail"]);
                $mail->AddAddress("lwscann@gmail.com");
                
                $mail->IsHTML(true);                                  // set email format to HTML
                
                $mail->Subject = 'Thanks for Registering, '.$_POST["First_Name"];
                $mail->Body = $message;
                $mail->Send();
            
                
            } 
            
        }
        
        
    }
    
    echo json_encode($response);
    
}

query($sql); if($success->num_rows > 0) { $response["status"] = "error"; $response["message"] = "You have already registered"; } else { $sql = "INSERT INTO onboard_register (`id`, `event_id`, `driver_id`, `date_signed_up`) VALUES (NULL,".$event.",".$driver_id.", NOW())"; $success = $conn->query($sql); if(!$success) { $response["status"] = "error"; $response["message"] = $conn->error; } else { $sql = "SELECT * FROM driver_onboard WHERE id = ".$driver_id; $success = $conn->query($sql); if($success->num_rows > 0) { $row = $success->fetch_assoc(); $response["driver_name"] = $row["first_name"]; $response["status"] = "success"; $response["message"] = "Successfully added"; date_default_timezone_set("Africa/Lagos"); $sql = "SELECT * FROM onboard_events WHERE id = ".$_GET["event"]; $success = $conn->query($sql); $event = $success->fetch_assoc(); $message = "

Thanks for registering for an Onboarding Session with MagicRide

"; $message .= "

You have registered for ".$event["title"].".

"; $message .= "

Please arrive before ".date("g a", $event["start_time"]/1000)." as training will begin promptly

"; $message .= "

Kind Regards

The MagicRide Team

."; $mail = new PHPMailer; $mail->SMTPDebug = false; $mail->isSMTP(); $mail->Host = "hp275.hostpapa.com"; // specify main and backup server $mail->Port = 465; $mail->SMTPSecure = "ssl"; $mail->SMTPAuth = true; // turn on SMTP authentication $mail->Username = "training@magicride.ng"; // SMTP username $mail->Password = "magicride2019"; // SMTP password $mail->From = "training@magicride.ng"; $mail->FromName = "MagicRide"; //$mail->AddAddress($_POST["inputEmail"]); $mail->AddAddress("lwscann@gmail.com"); $mail->IsHTML(true); // set email format to HTML $mail->Subject = 'Thanks for Registering, '.$_POST["First_Name"]; $mail->Body = $message; $mail->Send(); } } } echo json_encode($response); }