06fbd764 |
<?php
/**
* Copyright (C) 2021 Double Bastion LLC
*
* This file is part of Roundpin, which is licensed under the
* GNU Affero General Public License Version 3.0. The license terms
* are detailed in the "LICENSE.txt" file located in the root directory.
*/
session_start();
if (isset($_POST['s_ajax_call']) && ($_POST['s_ajax_call'] == $_SESSION['validate_s_access'])) {
define('ACCESSCONST', TRUE);
require('db-connect.php');
$username = $_POST['username'];
// Get the id of the user for which we want to get the external user data
$query1 = $mysqli->query("SELECT id, userrole, username, enabled FROM app_users WHERE userrole = 'superadmin' AND BINARY username = '$username' AND enabled = 1");
$queryres = $query1->fetch_array();
$userID = $queryres[0];
$extdatafromdb = [];
if ($userID != '') {
// Get the data for the current user from the 'external_users' table
$querysel = $mysqli->query("SELECT id, userid, exten_for_external, exten_for_ext_pass, conf_access_link FROM external_users WHERE userid = '$userID'");
while ($extUserDataRow = $querysel->fetch_row()) {
$extenforexternal = $extUserDataRow[2];
if ($extUserDataRow[3] != '' && $extUserDataRow[3] != null && $extUserDataRow[3] != 'undefined') {
$sippassword = "%20%20%20%20%20%20%20";
} else { $sippassword = ''; }
$confaccesslink = $extUserDataRow[4];
$extdatafromdb[] = ['exten_for_external' => $extenforexternal, 'exten_for_ext_pass' => $sippassword, 'conf_access_link' => $confaccesslink];
}
}
echo json_encode($extdatafromdb);
} else {
header("Location: roundpin-login.php");
}
?>
|