function getUnAddedServerAdmins($serverId, $groupId)
{
// SMF query
if ($this->enableSmfIntegration) {
if ($groupId > 0) {
$sql = "SELECT sm.ID_MEMBER as admin_id, sm.memberName as name, sm.ID_GROUP, sm.additionalGroups\r\n FROM " . $this->smfTablePrefix . "members sm\r\n WHERE sm.ID_MEMBER NOT IN (\r\n SELECT sa.admin_id\r\n FROM gban_group_admin sa\r\n WHERE server_group_id = '" . addslashes($groupId) . "'\r\n )\r\n ORDER BY name ASC";
} else {
$sql = "SELECT sm.ID_MEMBER as admin_id, sm.memberName as name, sm.ID_GROUP, sm.additionalGroups\r\n FROM " . $this->smfTablePrefix . "members sm\r\n WHERE sm.ID_MEMBER NOT IN (\r\n SELECT sa.admin_id\r\n FROM gban_server_admin sa\r\n WHERE server_id = '" . addslashes($serverId) . "'\r\n )\r\n ORDER BY name ASC";
}
} else {
// Standalone query
if ($groupId > 0) {
$sql = "SELECT a.admin_id, a.name\r\n FROM gban_admins a\r\n Inner Join gban_admin_steam s ON a.admin_id = s.admin_id\r\n WHERE s.active = '1' AND a.admin_id NOT IN (\r\n SELECT sa.admin_id\r\n FROM gban_group_admin sa\r\n WHERE server_group_id = '" . addslashes($groupId) . "'\r\n )\r\n ORDER BY a.name ASC";
} else {
$sql = "SELECT a.admin_id, a.name\r\n FROM gban_admins a\r\n Inner Join gban_admin_steam s ON a.admin_id = s.admin_id\r\n WHERE s.active = '1' AND a.admin_id NOT IN (\r\n SELECT sa.admin_id\r\n FROM gban_server_admin sa\r\n WHERE server_id = '" . addslashes($serverId) . "'\r\n )\r\n ORDER BY a.name ASC";
}
}
$this->db->sql_query($sql);
$users = $this->db->get_array();
$userList = array();
// Array of user objects
for ($i = 0; $i < count($users); $i++) {
$user = new User();
$user->setId($users[$i]['admin_id']);
$user->setName(stripslashes($users[$i]['name']));
if ($this->enableSmfIntegration) {
$user->setAccessLevel($this->getAccessLevel($users[$i]['ID_GROUP'], $users[$i]['additionalGroups']));
// Do not add those that fail
if ($user->getAccessLevel() > 0) {
array_push($userList, $user);
// Add the user object to the array
}
} else {
array_push($userList, $user);
// Add the user object to the array
}
}
return $userList;
}
