prepare("SELECT exten_for_external, exten_for_ext_pass, conf_extension FROM external_users WHERE exten_for_external = ? AND exten_for_ext_pass = ? AND conf_extension = ?"); $query->bind_param("sss", $crsipusername, $extenPassEnc, $conferenceExt); $query->execute(); $extqueryres = $query->get_result()->fetch_array(); if (!$extqueryres) { http_response_code(400); exit(); } else { // Check if the current user has been banned from accessing this conference $queryselck = $mysqli->prepare("SELECT banned_sipusername, conf_extension, banned_until FROM banned_users WHERE banned_sipusername = ? AND conf_extension = ?"); $queryselck->bind_param("ss", $crsipusername, $conferenceExt); $queryselck->execute(); $userdatafromdbck = $queryselck->get_result()->fetch_assoc(); if ($userdatafromdbck) { $currentDate = new DateTime(date("Y-m-d H:i:s")); $banDate = new DateTime($userdatafromdbck['banned_until']); if ($currentDate <= $banDate) { $banmessage = 'failure'; } else { $banmessage = 'success'; // Remove the database record, since the ban time has expired $querydel = $mysqli->prepare("DELETE FROM banned_users WHERE banned_sipusername = ? AND conf_extension = ?"); $querydel->bind_param("ss", $crsipusername, $conferenceExt); $querydel->execute(); } } else { $banmessage = 'success'; } } $response = array('notbanned' => $banmessage); echo json_encode($response); } else { header("Location: ../login.php"); } ?>