function getIpsUser()
{
$ips = getIpbConnection();
if ($ips == null) {
die;
}
$user = mysqli_real_escape_string($ips, htmlentities($_POST['ipsUserName']));
global $ipb_prefix;
$query = "SELECT name FROM " . $ipb_prefix . "core_members WHERE name LIKE '{$user}%' ORDER BY name ASC";
$result = mysqli_query($ips, $query);
if (!$result) {
die;
}
while ($row = mysqli_fetch_array($result)) {
$data[] = array("id" => $row['name'], "text" => $row['name']);
}
echo json_encode($data);
}
function getServerAdministrators($serverid)
{
$serverid = intval($serverid);
global $mysql;
$query = "SELECT * FROM 1fx_servers_user_map INNER JOIN 1fx_users ON 1fx_servers_user_map.user_id=1fx_users.user_id WHERE 1fx_servers_user_map.user_id={$serverid} AND status=2";
$result = mysqli_query($mysql, $query);
$ipbSql = false;
global $ipb_prefix;
while ($row = mysqli_fetch_array($result)) {
if ($row['origin'] === "1") {
if ($ipbSql == false) {
$ipbSql = getIpbConnection();
}
$extraQuery = "SELECT email FROM " . $ipb_prefix . "core_members WHERE name='" . $row['username'] . "'";
$ipsResult = mysqli_fetch_array(mysqli_query($ipbSql, $extraQuery));
$data[] = array("id" => $row['user_id'], "username" => $row['username'], "origin" => $row['origin'], "email" => $ipsResult['email'], "fullname" => $row['username'], "status" => $row['status'], "prefer_email" => $row['prefer_email']);
} else {
$data[] = array("id" => $row['user_id'], "username" => $row['username'], "origin" => $row['origin'], "email" => $row['email'], "fullname" => $row['fullname'], "status" => $row['status'], "prefer_email" => $row['prefer_email']);
}
}
return $data;
}
