if ($USER['email'] == null) { $ERRORS[] = 'E-mail address was blank.'; } elseif (preg_match('/^[a-z0-9_+.]{1,64}@([a-z0-9-.]*){1,}\\.[a-z]{1,5}$/i', $USER['email']) == false) { $ERRORS[] = 'Invalid e-mail address specified.'; } if (sizeof($ERRORS) > 0) { draw_errors($ERRORS); } else { // Create an user and set some base attrs. $new_user = new User($db); $new_user->setUserName($USER['user_name']); $new_user->setRegisteredIpAddr($_SERVER['REMOTE_ADDR']); $new_user->setPassword($USER['password']); $new_user->setCurrentSaltExpiration($new_user->sysdate()); $new_user->setLastActivity($new_user->sysdate()); $new_user->setAccessLevel('user'); $new_user->setEmail($USER['email']); $new_user->setAge($USER['age']); $new_user->setGender($USER['gender']); $new_user->setProfile($USER['profile']); $new_user->setCurrency($APP_CONFIG['starting_funds']); $new_user->setUserTitle('User'); $new_user->setTextareaPreference('tinymce'); $new_user->setDatetimeCreated($new_user->sysdate()); $new_user->setDatetimeLastPost($new_user->sysdate()); $new_user->setPasswordResetRequested($new_user->sysdate()); $new_user->setTimezoneId(54); // 54 = UTC $new_user->setDatetimeFormatId(1); // Y-m-d H:i:s $new_user->setShowOnlineStatus('Y');
function getGroupAdmins($groupId) { if ($this->enableSmfIntegration) { // SMF query $sql = "SELECT sm.ID_MEMBER as admin_id, sm.memberName as name, sm.additionalGroups, sm.emailAddress as email, \r\n gas.steam_id, gas.active, ga.admin_group_id, sm.ID_GROUP, sm.additionalGroups,\r\n (SELECT COALESCE(group_name, '') from gban_admin_group WHERE admin_group_id = ga.admin_group_id) as group_name\r\n FROM " . $this->smfTablePrefix . "members sm, gban_admin_steam gas, gban_group_admin ga\r\n WHERE sm.ID_MEMBER = gas.admin_id \r\n AND ga.admin_id = sm.ID_MEMBER\r\n AND ga.server_group_id = '" . addslashes($groupId) . "'\r\n AND sm.ID_MEMBER 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 UPPER(sm.memberName)"; } else { // Standalone query $sql = "SELECT a.admin_id, a.name, a.access_level, a.email, gas.steam_id, gas.active, ga.admin_group_id,\r\n (SELECT COALESCE(group_name, '') from gban_admin_group WHERE admin_group_id = ga.admin_group_id) as group_name\r\n FROM gban_admins a, gban_admin_steam gas, gban_group_admin ga\r\n WHERE a.admin_id = gas.admin_id \r\n AND ga.admin_id = a.admin_id\r\n AND ga.server_group_id = '" . addslashes($groupId) . "'\r\n AND a.admin_id 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 ga.admin_group_id ASC, 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'])); } else { $user->setAccessLevel($users[$i]['access_level']); } $user->setEmail($users[$i]['email']); $user->setSteamId($users[$i]['steam_id']); $user->setActive($users[$i]['active']); $user->setAdminGroupId($users[$i]['admin_group_id']); $user->setAdminGroupName($users[$i]['group_name']); array_push($userList, $user); // Add the user object to the array } return $userList; }