aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2008-03-18 11:58:34 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2008-03-18 11:58:34 +0000
commita3b98e510e63a270985d478c4a5a2f43cbbcead6 (patch)
tree7d49429819ac4a1c420505043f21a75707ea6a2b /phpBB/includes
parent5a1d2a94a3af00cee33e0add91a1c5a75c09c250 (diff)
downloadforums-a3b98e510e63a270985d478c4a5a2f43cbbcead6.tar
forums-a3b98e510e63a270985d478c4a5a2f43cbbcead6.tar.gz
forums-a3b98e510e63a270985d478c4a5a2f43cbbcead6.tar.bz2
forums-a3b98e510e63a270985d478c4a5a2f43cbbcead6.tar.xz
forums-a3b98e510e63a270985d478c4a5a2f43cbbcead6.zip
i somehow mixed my local copy with the changes
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8442 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
-rw-r--r--phpBB/includes/functions.php24
1 files changed, 11 insertions, 13 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php
index 283ab94cf3..0b79cffda3 100644
--- a/phpBB/includes/functions.php
+++ b/phpBB/includes/functions.php
@@ -3159,7 +3159,7 @@ function obtain_users_online($forum_id = 0)
{
$reading_sql = ' AND s.session_forum_id = ' . (int) $forum_id;
}
-
+$config['load_online_time'] = 500000;
$online_users = array(
'online_users' => array(),
'hidden_users' => array(),
@@ -3182,21 +3182,21 @@ function obtain_users_online($forum_id = 0)
WHERE s.session_time >= ' . ($time - ((int) ($time % 30))) .
$reading_sql .
' AND s.session_user_id <> ' . ANONYMOUS;
- $result = $db->sql_query($sql, 30);
+ $result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Skip multiple sessions for one user
if (!isset($online_users['online_users'][$row['session_user_id']]))
{
- $online_users['online_users'][$row['session_user_id']] = $row['session_user_id'];
+ $online_users['online_users'][$row['session_user_id']] = (int) $row['session_user_id'];
if ($row['session_viewonline'])
{
$online_users['visible_online']++;
}
else
{
- $online_users['hidden_users'][$row['session_user_id']] = $row['session_user_id'];
+ $online_users['hidden_users'][$row['session_user_id']] = (int) $row['session_user_id'];
$online_users['hidden_online']++;
}
}
@@ -3218,21 +3218,19 @@ function obtain_users_online_string($online_users, $forum_id = 0)
global $db, $user, $auth;
$user_online_link = $online_userlist = '';
- $prev_user_id = 0;
if (sizeof($online_users['online_users']))
{
- $sql = 'SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour
- FROM ' . USERS_TABLE . ' u
- WHERE ' . $db->sql_in_set('u.user_id', $online_users['online_users']) . '
- ORDER BY u.username_clean ASC';
- $result = $db->sql_query($sql, 100);
+ $sql = 'SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour
+ FROM ' . USERS_TABLE . '
+ WHERE ' . $db->sql_in_set('user_id', $online_users['online_users']) . '
+ ORDER BY username_clean ASC';
+ $result = $db->sql_query($sql);
- $userlist_array = array();
while ($row = $db->sql_fetchrow($result))
{
- // Skip multiple sessions for one user
- if ($row['user_id'] != $prev_user_id)
+ // User is logged in and therefore not a guest
+ if ($row['user_id'] != ANONYMOUS)
{
if (isset($online_users['hidden_users'][$row['user_id']]))
{