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; }