prepare("SELECT id, 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", $vconfExtension, $extenPassEnc, $conferenceExt); $query->execute(); $extqueryres = $query->get_result()->fetch_array(); if (!$extqueryres) { http_response_code(400); exit(); } else { if ($callerExt != null && $callerExt != 'undefined' && $callerExt != '') { $query2 = $mysqli->prepare("SELECT id, wss_server, profile_name, sip_username, display_vconf_user FROM app_users WHERE sip_username = ?"); $query2->bind_param("s", $callerExtMod); $query2->execute(); $userpref = $query2->get_result()->fetch_assoc(); if ($userpref) { $userDesc = $userpref['profile_name']; $nameDisplay = $userpref['display_vconf_user']; $messagetosend = 'success'; } else { $query3 = $mysqli->prepare("SELECT id, profile_name, exten_for_external, display_vconf_user FROM external_users WHERE exten_for_external = ?"); $query3->bind_param("s", $callerExt); $query3->execute(); $userdisplay = $query3->get_result()->fetch_assoc(); if ($userdisplay) { $userDesc = $userdisplay['profile_name']; $nameDisplay = $userdisplay['display_vconf_user']; $messagetosend = 'success'; } else { $userDesc = null; $nameDisplay = null; $messagetosend = "An error occurred while getting the user data!"; } } } } $response = ['result' => $messagetosend, 'userdescription' => $userDesc, 'namedisplay' => $nameDisplay]; echo json_encode($response); } else { header("Location: ../login.php"); }