/home/desid573/public_html
Edit: /home/desid573/public_html/oops.php (3722B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT * FROM jobs");
while($row = mysqli_fetch_assoc($result)) {
$d = date_create_from_format("jS M, Y", $row["job_date"]);
$date24 = date_format($d, "Y-m-d");
if(strtotime($date24) > strtotime("NOW")) {
$url = "https://api.vromo.io/v2/graph/role/jobs/".$row["spat_ref"]."?access_token=".$vromo;
error_log($url);
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "$url");
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curlObj, CURLOPT_TIMEOUT, 3);
curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
//curl_setopt($curlObj, CURLOPT_POSTFIELDS, '[{"vehicle":{"id":' . $driver_id . '},"type":"dispatched"}]');
$response = curl_exec($curlObj);
$json = json_decode($response, true);
if (json_last_error() !== JSON_ERROR_NONE) {
error_log('JSON decoding error: ' . json_last_error_msg());
} else {
// 9. Process the retrieved data (e.g., print or use it)
$driver = $json["dispatches"]["items"][0]["vehicle"]["id"];
//error_log("job response ".$driver);
if(is_numeric($driver)) {
$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 drivers WHERE id = '".$driver."'";
$result2 = mysqli_query($conn, $query);
if(!$result2) {
error_log("driver lookup error ".$conn->error);
}
$row2 = mysqli_fetch_assoc($result2);
$driver_name = $row2['driver'];
error_log($driver_name." ".$row["id"]);
$dbuser = "desid573_famcab";
$dbpass = "C]+6wQySxov(";
$dbname = "desid573_familycab";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result3 = mysqli_query($conn, "UPDATE jobs SET `driver` = '".$driver_name."' WHERE `id` = ".$row["id"]);
if(!$result3) {
error_log($conn->error);
}
}
}
//error_log("job response ".$json);
curl_close($curlObj);
}
}
