/home/desid573/public_html
Edit: /home/desid573/public_html/smssend.php (4252B)
connect_error);
} else if($from == "DesiDrivers"){
$dbhost = "localhost";
$dbuser = "desid573_inquiri";
$dbpass = "@G&{)0*&Ts^V";
$dbname = "desid573_inquiries";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or error_log($conn->connect_error);
}
if(!empty($check) && !empty($reference) && !empty($from)) {
$result = mysqli_query($conn, "SELECT conf_sms_sent, driver FROM jobs WHERE reference='".$reference."' ORDER BY conf_sms_sent DESC LIMIT 0,1");
$row = mysqli_fetch_assoc($result);
$sent = $row['conf_sms_sent'];
$driver = $row["driver"];
if($sent == "yes") {
if($driver != "") {
echo "SMS Sent & Dispatched to ".$driver;
} else {
echo "SMS Sent";
}
} else {
echo "no";
}
}
if(!empty($to) && !empty($from) && !empty($message))
{
// $account_sid = 'AC1b4db66d86197058950ad349a2327a85';
// $auth_token = '053ae80d10eac3b60c92179d3492badf';
// $client = new Client($account_sid, $auth_token);
$message = urldecode($message);
$data = '&to=' . $to .'&message=' . $message . '&senderid=' . "+61466062355";
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, 'https://api-mapper.clicksend.com/http/v2/send.php?method=http&username=lewis@perthdesignateddrivers.com.au&key=767676B6-7F74-7F47-E2F7-8A6F73B136CD');
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('application/x-www-form-urlencoded'));
curl_setopt($curlObj, CURLOPT_POST, 1);
curl_setopt($curlObj, CURLOPT_POSTFIELDS, $data);
// ,
$response = curl_exec($curlObj);
error_log($response);
//echo $response;
$xml = simplexml_load_string($response);
error_log($xml->messages->message->errortext);
if($xml->messages->message->errortext == "Success") {
$status = "OK";
}
// try {
// // $messages = $client->messages->create("$to", array('From' => "$from", 'body' => "$message"));
// } catch (Exception $e) {
// error_log($e);
// }
// if($messages) {
// $status = "OK";
// } else {
// // $from = "+12563636264";
// // $messages = $client->messages->create("$to", array('From' => "$from", 'body' => "$message"));
// if($messages->sid) {
// $status = "OK";
// } else {
// echo "error";
// return;
// }
// }
if($status == "OK"){
if($dbuser = "desid573_famcab"){
$query = mysqli_query($conn, "UPDATE jobs SET conf_sms_sent='yes' WHERE reference='".$reference."'");
if (!$query) {
error_log("Couldn't enter data: ".$conn->error);
}
} else if($dbuser = "desid573_inquiri"){
$query = mysqli_query($conn, "UPDATE jobs SET conf_sms_sent='yes' WHERE reference='".$reference."'");
if (!$query) {
error_log("Couldn't enter data: ".$conn->error);
}
}
echo $status;
}
}
