diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-10-15 17:43:07 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-10-15 17:43:07 +0000 |
| commit | a47fa4d6cab862a9635f3e30d01ad2740c45a888 (patch) | |
| tree | 10d3ad33badde24948065613ff884cc37ee87781 /phpBB/memberlist.php | |
| parent | 8661a45de596e06e89e8fa8f12efb91293780419 (diff) | |
| download | forums-a47fa4d6cab862a9635f3e30d01ad2740c45a888.tar forums-a47fa4d6cab862a9635f3e30d01ad2740c45a888.tar.gz forums-a47fa4d6cab862a9635f3e30d01ad2740c45a888.tar.bz2 forums-a47fa4d6cab862a9635f3e30d01ad2740c45a888.tar.xz forums-a47fa4d6cab862a9635f3e30d01ad2740c45a888.zip | |
Remove need for session_ids for "allowed" bots, dump user_founder/user_active in favour of user_type, new user_type, USER_IGNORE
git-svn-id: file:///svn/phpbb/trunk@4603 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/memberlist.php')
| -rw-r--r-- | phpBB/memberlist.php | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index cd18970e30..25dea6cb37 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -410,7 +410,7 @@ switch ($mode) $sql = 'SELECT username, user_email, user_allow_viewemail, user_lang, user_jabber, user_notify_method FROM ' . USERS_TABLE . " WHERE user_id = $user_id - AND user_active = 1"; + AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; $result = $db->sql_query($sql); if (!($row = $db->sql_fetchrow($result))) @@ -676,7 +676,7 @@ switch ($mode) { $sql = 'SELECT COUNT(user_id) AS total_users FROM ' . USERS_TABLE . ' - WHERE user_id <> ' . ANONYMOUS . " + WHERE user_type <> ' . USER_IGNORE . " $where_sql"; $result = $db->sql_query($sql); @@ -728,6 +728,8 @@ switch ($mode) ); } + // TODO + // ????????? $sql = 'SELECT session_user_id, MAX(session_time) AS session_time FROM ' . SESSIONS_TABLE . ' WHERE session_time >= ' . (time() - 300) . ' @@ -745,7 +747,7 @@ switch ($mode) // Do the SQL thang $sql = 'SELECT username, user_id, user_colour, user_allow_viewemail, user_posts, user_regdate, user_rank, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_lastvisit FROM ' . USERS_TABLE . ' - WHERE user_id <> ' . ANONYMOUS . " + WHERE user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ") $where_sql ORDER BY $order_by"; $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start); |