diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-03-21 22:43:07 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-03-21 22:43:07 +0000 |
| commit | a4e51c9699c7a09bea32ad832a9818abba008801 (patch) | |
| tree | 42feb7021db4bd9cb9334e65b23260d491d3b131 /phpBB/memberlist.php | |
| parent | 68b7397da8197d23dae07fc0e7927697cb1e3492 (diff) | |
| download | forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.gz forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.bz2 forums-a4e51c9699c7a09bea32ad832a9818abba008801.tar.xz forums-a4e51c9699c7a09bea32ad832a9818abba008801.zip | |
- first try to break things...
git-svn-id: file:///svn/phpbb/trunk@5108 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/memberlist.php')
| -rw-r--r-- | phpBB/memberlist.php | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index c9a5b3fb3d..3e0cffa1b8 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -135,7 +135,8 @@ switch ($mode) // Grab relevant data $sql = "SELECT user_id, username, user_email, user_lang, $sql_field FROM " . USERS_TABLE . " - WHERE user_id = $user_id"; + WHERE user_id = $user_id + AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; $result = $db->sql_query($sql); if (!($row = $db->sql_fetchrow($result))) @@ -227,9 +228,10 @@ switch ($mode) } // We left join on the session table to see if the user is currently online - $sql = 'SELECT username, user_id, user_colour, user_permissions, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_allow_viewemail, user_posts, user_regdate, user_rank, user_from, user_occ, user_interests, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_avatar, user_avatar_width, user_avatar_height, user_avatar_type, user_lastvisit + $sql = 'SELECT username, user_id, user_type, user_colour, user_permissions, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_allow_viewemail, user_posts, user_regdate, user_rank, user_from, user_occ, user_interests, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_avatar, user_avatar_width, user_avatar_height, user_avatar_type, user_lastvisit FROM ' . USERS_TABLE . " - WHERE user_id = $user_id"; + WHERE user_id = $user_id + AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; $result = $db->sql_query($sql); if (!($member = $db->sql_fetchrow($result))) @@ -358,7 +360,7 @@ switch ($mode) if ($member['user_sig']) { - $member['user_sig'] = censor_text(smilie_text($member['user_sig'])); + $member['user_sig'] = censor_text(smiley_text($member['user_sig'])); } $poster_avatar = ''; @@ -818,7 +820,7 @@ switch ($mode) { $sql = 'SELECT COUNT(u.user_id) AS total_users FROM ' . USERS_TABLE . " u$sql_from - WHERE u.user_type <> " . USER_IGNORE . " + WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ") $sql_where"; $result = $db->sql_query($sql); |