phpBB/viewonline.php

   1 <?php
   2 /**
   3 *
   4 * @package phpBB3
   5 * @version $Id$
   6 * @copyright (c) 2005 phpBB Group
   7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   8 *
   9 */
  10
  11 /**
  12 * @ignore
  13 */
  14 define('IN_PHPBB', true);
  15 if (!defined('PHPBB_ROOT_PATH')) define('PHPBB_ROOT_PATH', './');
  16 if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
  17 include(PHPBB_ROOT_PATH . 'common.' . PHP_EXT);
  18
  19 // Start session management
  20 phpbb::$user->session_begin();
  21 phpbb::$acl->init(phpbb::$user->data);
  22 phpbb::$user->setup('memberlist');
  23
  24 // Get and set some variables
  25 $mode           = request_var('mode', '');
  26 $session_id     = request_var('s', '');
  27 $start          = request_var('start', 0);
  28 $sort_key       = request_var('sk', 'b');
  29 $sort_dir       = request_var('sd', 'd');
  30 $show_guests= (phpbb::$config['load_online_guests']) ? request_var('sg', 0) : 0;
  31
  32 // Can this user view profiles/memberlist?
  33 if (!phpbb::$acl->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))
  34 {
  35         if (!phpbb::$user->is_guest)
  36         {
  37                 trigger_error('NO_VIEW_USERS');
  38         }
  39
  40         login_box('', phpbb::$user->lang['LOGIN_EXPLAIN_VIEWONLINE']);
  41 }
  42
  43 $sort_key_text = array('a' => phpbb::$user->lang['SORT_USERNAME'], 'b' => phpbb::$user->lang['SORT_JOINED'], 'c' => phpbb::$user->lang['SORT_LOCATION']);
  44 $sort_key_sql = array('a' => 'u.username_clean', 'b' => 's.session_time', 'c' => 's.session_page');
  45
  46 // Sorting and order
  47 if (!isset($sort_key_text[$sort_key]))
  48 {
  49         $sort_key = 'b';
  50 }
  51
  52 $order_by = $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');
  53
  54 // Whois requested
  55 if ($mode == 'whois' && phpbb::$acl->acl_get('a_') && $session_id)
  56 {
  57         include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);
  58
  59         $sql = 'SELECT u.user_id, u.username, u.user_type, s.session_ip
  60                 FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . " s
  61                 WHERE s.session_id = '" . phpbb::$db->sql_escape($session_id) . "'
  62                         AND     u.user_id = s.session_user_id";
  63         $result = phpbb::$db->sql_query($sql);
  64
  65         if ($row = phpbb::$db->sql_fetchrow($result))
  66         {
  67                 phpbb::$template->assign_var('WHOIS', user_ipwhois($row['session_ip']));
  68         }
  69         phpbb::$db->sql_freeresult($result);
  70
  71         // Output the page
  72         page_header(phpbb::$user->lang['WHO_IS_ONLINE']);
  73
  74         phpbb::$template->set_filenames(array(
  75                 'body' => 'viewonline_whois.html',
  76         ));
  77         make_jumpbox(append_sid('viewforum'));
  78
  79         page_footer();
  80 }
  81
  82 // Forum info
  83 $sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id
  84         FROM ' . FORUMS_TABLE . '
  85         ORDER BY left_id ASC';
  86 $result = phpbb::$db->sql_query($sql, 600);
  87
  88 $forum_data = array();
  89 while ($row = phpbb::$db->sql_fetchrow($result))
  90 {
  91         $forum_data[$row['forum_id']] = $row;
  92 }
  93 phpbb::$db->sql_freeresult($result);
  94
  95 $guest_counter = 0;
  96
  97 // Get number of online guests (if we do not display them)
  98 if (!$show_guests)
  99 {
 100         if (phpbb::$db->features['count_distinct'])
 101         {
 102                 $sql = 'SELECT COUNT(DISTINCT session_ip) as num_guests
 103                                 FROM ' . SESSIONS_TABLE . '
 104                                 WHERE session_user_id = ' . ANONYMOUS . '
 105                                         AND session_time >= ' . (time() - (phpbb::$config['load_online_time'] * 60));
 106         }
 107         else
 108         {
 109                 $sql = 'SELECT COUNT(session_ip) as num_guests
 110                         FROM (
 111                                 SELECT DISTINCT session_ip
 112                                         FROM ' . SESSIONS_TABLE . '
 113                                         WHERE session_user_id = ' . ANONYMOUS . '
 114                                                 AND session_time >= ' . (time() - (phpbb::$config['load_online_time'] * 60)) .
 115                         ')';
 116                 break;
 117         }
 118         $result = phpbb::$db->sql_query($sql);
 119         $guest_counter = (int) phpbb::$db->sql_fetchfield('num_guests');
 120         phpbb::$db->sql_freeresult($result);
 121 }
 122
 123 // Get user list
 124 $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline
 125         FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s
 126         WHERE u.user_id = s.session_user_id
 127                 AND s.session_time >= ' . (time() - (phpbb::$config['load_online_time'] * 60)) .
 128                 ((!$show_guests) ? ' AND s.session_user_id <> ' . ANONYMOUS : '') . '
 129         ORDER BY ' . $order_by;
 130 $result = phpbb::$db->sql_query($sql);
 131
 132 $prev_id = $prev_ip = $user_list = array();
 133 $logged_visible_online = $logged_hidden_online = $counter = 0;
 134
 135 while ($row = phpbb::$db->sql_fetchrow($result))
 136 {
 137         if ($row['user_id'] != ANONYMOUS && !isset($prev_id[$row['user_id']]))
 138         {
 139                 $view_online = $s_user_hidden = false;
 140                 $user_colour = ($row['user_colour']) ? ' style="color:#' . $row['user_colour'] . '" class="username-coloured"' : '';
 141
 142                 $username_full = ($row['user_type'] != phpbb::USER_IGNORE) ? get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']) : '<span' . $user_colour . '>' . $row['username'] . '</span>';
 143
 144                 if (!$row['session_viewonline'])
 145                 {
 146                         $view_online = (phpbb::$acl->acl_get('u_viewonline')) ? true : false;
 147                         $logged_hidden_online++;
 148
 149                         $username_full = '<em>' . $username_full . '</em>';
 150                         $s_user_hidden = true;
 151                 }
 152                 else
 153                 {
 154                         $view_online = true;
 155                         $logged_visible_online++;
 156                 }
 157
 158                 $prev_id[$row['user_id']] = 1;
 159
 160                 if ($view_online)
 161                 {
 162                         $counter++;
 163                 }
 164
 165                 if (!$view_online || $counter > $start + phpbb::$config['topics_per_page'] || $counter <= $start)
 166                 {
 167                         continue;
 168                 }
 169         }
 170         else if ($show_guests && $row['user_id'] == ANONYMOUS && !isset($prev_ip[$row['session_ip']]))
 171         {
 172                 $prev_ip[$row['session_ip']] = 1;
 173                 $guest_counter++;
 174                 $counter++;
 175
 176                 if ($counter > $start + phpbb::$config['topics_per_page'] || $counter <= $start)
 177                 {
 178                         continue;
 179                 }
 180
 181                 $s_user_hidden = false;
 182                 $username_full = get_username_string('full', $row['user_id'], phpbb::$user->lang['GUEST']);
 183         }
 184         else
 185         {
 186                 continue;
 187         }
 188
 189         preg_match('#^([a-z/_]+)#i', $row['session_page'], $on_page);
 190         if (!sizeof($on_page))
 191         {
 192                 $on_page[1] = '';
 193         }
 194
 195         switch ($on_page[1])
 196         {
 197                 case 'index':
 198                         $location = phpbb::$user->lang['INDEX'];
 199                         $location_url = append_sid('index');
 200                 break;
 201
 202                 case 'adm/index':
 203                         $location = phpbb::$user->lang['ACP'];
 204                         $location_url = append_sid('index');
 205                 break;
 206
 207                 case 'posting':
 208                 case 'viewforum':
 209                 case 'viewtopic':
 210                         preg_match('#_f_=([0-9]+)x#i', $row['session_page'], $forum_id);
 211                         $forum_id = (sizeof($forum_id)) ? (int) $forum_id[1] : 0;
 212
 213                         if ($forum_id && phpbb::$acl->acl_get('f_list', $forum_id))
 214                         {
 215                                 $location = '';
 216                                 $location_url = append_sid('viewforum', 'f=' . $forum_id);
 217
 218                                 if ($forum_data[$forum_id]['forum_type'] == FORUM_LINK)
 219                                 {
 220                                         $location = sprintf(phpbb::$user->lang['READING_LINK'], $forum_data[$forum_id]['forum_name']);
 221                                         break;
 222                                 }
 223
 224                                 switch ($on_page[1])
 225                                 {
 226                                         case 'posting':
 227                                                 preg_match('#mode=([a-z]+)#', $row['session_page'], $on_page);
 228                                                 $posting_mode = (!empty($on_page[1])) ? $on_page[1] : '';
 229
 230                                                 switch ($posting_mode)
 231                                                 {
 232                                                         case 'reply':
 233                                                         case 'quote':
 234                                                                 $location = sprintf(phpbb::$user->lang['REPLYING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
 235                                                         break;
 236
 237                                                         default:
 238                                                                 $location = sprintf(phpbb::$user->lang['POSTING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
 239                                                         break;
 240                                                 }
 241                                         break;
 242
 243                                         case 'viewtopic':
 244                                                 $location = sprintf(phpbb::$user->lang['READING_TOPIC'], $forum_data[$forum_id]['forum_name']);
 245                                         break;
 246
 247                                         case 'viewforum':
 248                                                 $location = sprintf(phpbb::$user->lang['READING_FORUM'], $forum_data[$forum_id]['forum_name']);
 249                                         break;
 250                                 }
 251                         }
 252                         else
 253                         {
 254                                 $location = phpbb::$user->lang['INDEX'];
 255                                 $location_url = append_sid('index');
 256                         }
 257                 break;
 258
 259                 case 'search':
 260                         $location = phpbb::$user->lang['SEARCHING_FORUMS'];
 261                         $location_url = append_sid('search');
 262                 break;
 263
 264                 case 'faq':
 265                         $location = phpbb::$user->lang['VIEWING_FAQ'];
 266                         $location_url = append_sid('faq');
 267                 break;
 268
 269                 case 'viewonline':
 270                         $location = phpbb::$user->lang['VIEWING_ONLINE'];
 271                         $location_url = append_sid('viewonline');
 272                 break;
 273
 274                 case 'memberlist':
 275                         $location = (strpos($row['session_page'], 'mode=viewprofile') !== false) ? phpbb::$user->lang['VIEWING_MEMBER_PROFILE'] : phpbb::$user->lang['VIEWING_MEMBERS'];
 276                         $location_url = append_sid('memberlist');
 277                 break;
 278
 279                 case 'mcp':
 280                         $location = phpbb::$user->lang['VIEWING_MCP'];
 281                         $location_url = append_sid('index');
 282                 break;
 283
 284                 case 'ucp':
 285                         $location = phpbb::$user->lang['VIEWING_UCP'];
 286
 287                         // Grab some common modules
 288                         $url_params = array(
 289                                 'mode=register'         => 'VIEWING_REGISTER',
 290                                 'i=pm&mode=compose'     => 'POSTING_PRIVATE_MESSAGE',
 291                                 'i=pm&'                         => 'VIEWING_PRIVATE_MESSAGES',
 292                                 'i=profile&'            => 'CHANGING_PROFILE',
 293                                 'i=prefs&'                      => 'CHANGING_PREFERENCES',
 294                         );
 295
 296                         foreach ($url_params as $param => $lang)
 297                         {
 298                                 if (strpos($row['session_page'], $param) !== false)
 299                                 {
 300                                         $location = phpbb::$user->lang[$lang];
 301                                         break;
 302                                 }
 303                         }
 304
 305                         $location_url = append_sid('index');
 306                 break;
 307
 308                 case 'download/file':
 309                         $location = phpbb::$user->lang['DOWNLOADING_FILE'];
 310                         $location_url = append_sid('index');
 311                 break;
 312
 313                 case 'report':
 314                         $location = phpbb::$user->lang['REPORTING_POST'];
 315                         $location_url = append_sid('index');
 316                 break;
 317
 318                 default:
 319                         $location = phpbb::$user->lang['INDEX'];
 320                         $location_url = append_sid('index');
 321                 break;
 322         }
 323
 324         phpbb::$template->assign_block_vars('user_row', array(
 325                 'USERNAME'                      => $row['username'],
 326                 'USERNAME_COLOUR'       => $row['user_colour'],
 327                 'USERNAME_FULL'         => $username_full,
 328                 'LASTUPDATE'            => phpbb::$user->format_date($row['session_time']),
 329                 'FORUM_LOCATION'        => $location,
 330                 'USER_IP'                       => (phpbb::$acl->acl_get('a_')) ? (($mode == 'lookup' && $session_id == $row['session_id']) ? gethostbyaddr($row['session_ip']) : $row['session_ip']) : '',
 331                 'USER_BROWSER'          => (phpbb::$acl->acl_get('a_user')) ? $row['session_browser'] : '',
 332
 333                 'U_USER_PROFILE'        => ($row['user_type'] != phpbb::USER_IGNORE) ? get_username_string('profile', $row['user_id'], '') : '',
 334                 'U_USER_IP'                     => append_sid('viewonline', 'mode=lookup' . (($mode != 'lookup' || $row['session_id'] != $session_id) ? '&amp;s=' . $row['session_id'] : '') . "&amp;sg=$show_guests&amp;start=$start&amp;sk=$sort_key&amp;sd=$sort_dir"),
 335                 'U_WHOIS'                       => append_sid('viewonline', 'mode=whois&amp;s=' . $row['session_id']),
 336                 'U_FORUM_LOCATION'      => $location_url,
 337
 338                 'S_USER_HIDDEN'         => $s_user_hidden,
 339                 'S_GUEST'                       => ($row['user_id'] == ANONYMOUS) ? true : false,
 340                 'S_USER_TYPE'           => $row['user_type'],
 341         ));
 342 }
 343 phpbb::$db->sql_freeresult($result);
 344 unset($prev_id, $prev_ip);
 345
 346 // Generate reg/hidden/guest online text
 347 $vars_online = array(
 348         'REG'   => array('logged_visible_online', 'l_r_user_s'),
 349         'HIDDEN'=> array('logged_hidden_online', 'l_h_user_s'),
 350         'GUEST' => array('guest_counter', 'l_g_user_s')
 351 );
 352
 353 foreach ($vars_online as $l_prefix => $var_ary)
 354 {
 355         switch ($$var_ary[0])
 356         {
 357                 case 0:
 358                         $$var_ary[1] = phpbb::$user->lang[$l_prefix . '_USERS_ZERO_ONLINE'];
 359                 break;
 360
 361                 case 1:
 362                         $$var_ary[1] = phpbb::$user->lang[$l_prefix . '_USER_ONLINE'];
 363                 break;
 364
 365                 default:
 366                         $$var_ary[1] = phpbb::$user->lang[$l_prefix . '_USERS_ONLINE'];
 367                 break;
 368         }
 369 }
 370 unset($vars_online);
 371
 372 $pagination = generate_pagination(append_sid('viewonline', "sg=$show_guests&amp;sk=$sort_key&amp;sd=$sort_dir"), $counter, phpbb::$config['topics_per_page'], $start);
 373
 374 // Grab group details for legend display
 375 if (phpbb::$acl->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))
 376 {
 377         $sql = 'SELECT group_id, group_name, group_colour, group_type
 378                 FROM ' . GROUPS_TABLE . '
 379                 WHERE group_legend = 1
 380                 ORDER BY group_name ASC';
 381 }
 382 else
 383 {
 384         $sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type
 385                 FROM ' . GROUPS_TABLE . ' g
 386                 LEFT JOIN ' . USER_GROUP_TABLE . ' ug
 387                         ON (
 388                                 g.group_id = ug.group_id
 389                                 AND ug.user_id = ' . phpbb::$user->data['user_id'] . '
 390                                 AND ug.user_pending = 0
 391                         )
 392                 WHERE g.group_legend = 1
 393                         AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . phpbb::$user->data['user_id'] . ')
 394                 ORDER BY g.group_name ASC';
 395 }
 396 $result = phpbb::$db->sql_query($sql);
 397
 398 $legend = '';
 399 while ($row = phpbb::$db->sql_fetchrow($result))
 400 {
 401         if ($row['group_name'] == 'BOTS')
 402         {
 403                 $legend .= (($legend != '') ? ', ' : '') . '<span style="color:#' . $row['group_colour'] . '">' . phpbb::$user->lang['G_BOTS'] . '</span>';
 404         }
 405         else
 406         {
 407                 $legend .= (($legend != '') ? ', ' : '') . '<a style="color:#' . $row['group_colour'] . '" href="' . append_sid('memberlist', 'mode=group&amp;g=' . $row['group_id']) . '">' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</a>';
 408         }
 409 }
 410 phpbb::$db->sql_freeresult($result);
 411
 412 // Refreshing the page every 60 seconds...
 413 meta_refresh(60, append_sid('viewonline', "sg=$show_guests&amp;sk=$sort_key&amp;sd=$sort_dir&amp;start=$start"));
 414
 415 // Send data to template
 416 phpbb::$template->assign_vars(array(
 417         'TOTAL_REGISTERED_USERS_ONLINE' => sprintf($l_r_user_s, $logged_visible_online) . sprintf($l_h_user_s, $logged_hidden_online),
 418         'TOTAL_GUEST_USERS_ONLINE'              => sprintf($l_g_user_s, $guest_counter),
 419         'LEGEND'                                                => $legend,
 420         'PAGINATION'                                    => $pagination,
 421         'PAGE_NUMBER'                                   => on_page($counter, phpbb::$config['topics_per_page'], $start),
 422
 423         'U_SORT_USERNAME'               => append_sid('viewonline', 'sk=a&amp;sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a') . '&amp;sg=' . ((int) $show_guests)),
 424         'U_SORT_UPDATED'                => append_sid('viewonline', 'sk=b&amp;sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a') . '&amp;sg=' . ((int) $show_guests)),
 425         'U_SORT_LOCATION'               => append_sid('viewonline', 'sk=c&amp;sd=' . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a') . '&amp;sg=' . ((int) $show_guests)),
 426
 427         'U_SWITCH_GUEST_DISPLAY'        => append_sid('viewonline', 'sg=' . ((int) !$show_guests)),
 428         'L_SWITCH_GUEST_DISPLAY'        => ($show_guests) ? phpbb::$user->lang['HIDE_GUESTS'] : phpbb::$user->lang['DISPLAY_GUESTS'],
 429         'S_SWITCH_GUEST_DISPLAY'        => (phpbb::$config['load_online_guests']) ? true : false,
 430 ));
 431
 432 // We do not need to load the who is online box here. ;)
 433 phpbb::$config['load_online'] = false;
 434
 435 // Output the page
 436 page_header(phpbb::$user->lang['WHO_IS_ONLINE']);
 437
 438 phpbb::$template->set_filenames(array(
 439         'body' => 'viewonline_body.html',
 440 ));
 441 make_jumpbox(append_sid('viewforum'));
 442
 443 page_footer();
 444
 445 ?>