diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-03-24 18:00:21 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-03-24 18:00:21 +0000 |
| commit | 6bc4b1412b42c275b0715ee47c5bf923ee3f2206 (patch) | |
| tree | cb9b93f00944ee675e7a0aca76b3c9513e1128ba /phpBB/ucp.php | |
| parent | f269de0fd49481dae1dd28076d6e08115b9edba0 (diff) | |
| download | forums-6bc4b1412b42c275b0715ee47c5bf923ee3f2206.tar forums-6bc4b1412b42c275b0715ee47c5bf923ee3f2206.tar.gz forums-6bc4b1412b42c275b0715ee47c5bf923ee3f2206.tar.bz2 forums-6bc4b1412b42c275b0715ee47c5bf923ee3f2206.tar.xz forums-6bc4b1412b42c275b0715ee47c5bf923ee3f2206.zip | |
#5280
git-svn-id: file:///svn/phpbb/trunk@7229 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/ucp.php')
| -rwxr-xr-x | phpBB/ucp.php | 75 |
1 files changed, 40 insertions, 35 deletions
diff --git a/phpBB/ucp.php b/phpBB/ucp.php index 2713f794eb..f4ddd55f6d 100755 --- a/phpBB/ucp.php +++ b/phpBB/ucp.php @@ -241,53 +241,58 @@ if (!$user->data['is_registered']) login_box('', $user->lang['LOGIN_EXPLAIN_UCP']); } +// Instantiate module system and generate list of available modules +$module->list_modules('ucp'); -// Output listing of friends online -$update_time = $config['load_online_time'] * 60; +// Check if the zebra module is set +$zebra_enabled = $module->is_active('zebra') ? true : false; -$sql = $db->sql_build_query('SELECT_DISTINCT', array( - 'SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, u.user_allow_viewonline, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline', +if ($zebra_enabled) +{ + // Output listing of friends online + $update_time = $config['load_online_time'] * 60; - 'FROM' => array( - USERS_TABLE => 'u', - ZEBRA_TABLE => 'z' - ), + $sql = $db->sql_build_query('SELECT_DISTINCT', array( + 'SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, u.user_allow_viewonline, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline', - 'LEFT_JOIN' => array( - array( - 'FROM' => array(SESSIONS_TABLE => 's'), - 'ON' => 's.session_user_id = z.zebra_id' - ) - ), + 'FROM' => array( + USERS_TABLE => 'u', + ZEBRA_TABLE => 'z' + ), - 'WHERE' => 'z.user_id = ' . $user->data['user_id'] . ' - AND z.friend = 1 - AND u.user_id = z.zebra_id', + 'LEFT_JOIN' => array( + array( + 'FROM' => array(SESSIONS_TABLE => 's'), + 'ON' => 's.session_user_id = z.zebra_id' + ) + ), - 'GROUP_BY' => 'z.zebra_id, u.user_id, u.username_clean, u.user_allow_viewonline, u.user_colour, u.username', + 'WHERE' => 'z.user_id = ' . $user->data['user_id'] . ' + AND z.friend = 1 + AND u.user_id = z.zebra_id', - 'ORDER_BY' => 'u.username_clean ASC', -)); + 'GROUP_BY' => 'z.zebra_id, u.user_id, u.username_clean, u.user_allow_viewonline, u.user_colour, u.username', -$result = $db->sql_query($sql); + 'ORDER_BY' => 'u.username_clean ASC', + )); -while ($row = $db->sql_fetchrow($result)) -{ - $which = (time() - $update_time < $row['online_time'] && $row['viewonline'] && $row['user_allow_viewonline']) ? 'online' : 'offline'; + $result = $db->sql_query($sql); - $template->assign_block_vars("friends_{$which}", array( - 'USER_ID' => $row['user_id'], + while ($row = $db->sql_fetchrow($result)) + { + $which = (time() - $update_time < $row['online_time'] && $row['viewonline'] && $row['user_allow_viewonline']) ? 'online' : 'offline'; - 'U_PROFILE' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']), - 'USER_COLOUR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']), - 'USERNAME' => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']), - 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'])) - ); -} -$db->sql_freeresult($result); + $template->assign_block_vars("friends_{$which}", array( + 'USER_ID' => $row['user_id'], -// Instantiate module system and generate list of available modules -$module->list_modules('ucp'); + 'U_PROFILE' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']), + 'USER_COLOUR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']), + 'USERNAME' => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']), + 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'])) + ); + } + $db->sql_freeresult($result); +} // Select the active module $module->set_active($id, $mode); |