Example #1
0
 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;
 }