plugins/WhosOnline.php
changeset 4 0b3a0aedfd53
parent 3 2b2084ca1e60
child 5 e8eff401ece3
equal deleted inserted replaced
3:2b2084ca1e60 4:0b3a0aedfd53
     1 <?php
       
     2 /*
       
     3 Plugin Name: Who's Online
       
     4 Plugin URI: javascript: // No URL yet, stay tuned!
       
     5 Description: This plugin tracks who is currently online. 3 queries per page request. This plugin works ONLY with MySQL and will likely be difficult to port because it uses unique indices and the REPLACE command.
       
     6 Author: Dan Fuhry
       
     7 Version: 0.1
       
     8 Author URI: http://www.enanocms.org/
       
     9 */
       
    10 
       
    11 /*
       
    12  * Who's Online plugin for Enano
       
    13  * Version 0.1
       
    14  * Copyright (C) 2007 Dan Fuhry
       
    15  *
       
    16  * This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License
       
    17  * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
       
    18  *
       
    19  * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
       
    20  * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.
       
    21  */
       
    22 
       
    23 global $whos_online;
       
    24 $whos_online = Array('not_yet_initialized');
       
    25 
       
    26 // First things first - create the table if needed
       
    27 $ver = getConfig('whos_online_version');
       
    28 if($ver != '0.1')
       
    29 {
       
    30   if(!
       
    31     $db->sql_query('DROP TABLE IF EXISTS '.table_prefix.'online;')
       
    32     ) $db->_die('Could not clean out old who\'s-online table');
       
    33   // The key on username allows the REPLACE command later, to save queries
       
    34   if(!$db->sql_query('CREATE TABLE '.table_prefix.'online(
       
    35         entry_id int(12) UNSIGNED NOT NULL auto_increment,
       
    36         user_id int(12) NOT NULL,
       
    37         username varchar(63) NOT NULL,
       
    38         last_load int(12) NOT NULL,
       
    39         PRIMARY KEY ( entry_id ),
       
    40         KEY ( username )
       
    41       );')
       
    42     ) $db->_die('Could not create new who\'s-online table');
       
    43   if(!$db->sql_query('CREATE UNIQUE INDEX '.table_prefix.'onluser ON '.table_prefix.'online(username);'))
       
    44     $db->_die('Could not create index on username column.');
       
    45   setConfig('whos_online_version', '0.1');
       
    46 }
       
    47 
       
    48 $plugins->attachHook('session_started', '__WhosOnline_UserCount();');
       
    49 $plugins->attachHook('login_success', '__WhosOnline_logonhandler();');
       
    50 $plugins->attachHook('logout_success', '__WhosOnline_logoffhandler($ou, $oid, $level);');
       
    51 
       
    52 function __WhosOnline_UserCount()
       
    53 {
       
    54   global $db, $session, $paths, $template, $plugins; // Common objects
       
    55   global $whos_online;
       
    56   $whos_online = Array();
       
    57   $whos_online['users'] = Array();
       
    58   $whos_online['guests'] = Array();
       
    59   $q = $db->sql_query('REPLACE INTO '.table_prefix.'online SET user_id='.$session->user_id.',username=\''.$db->escape($session->username).'\',last_load='.time().';'); if(!$q) $db->_die('');
       
    60   $q = $db->sql_query('DELETE FROM '.table_prefix.'online WHERE last_load<'.( time() - 60*60*24 ).';'); if(!$q) $db->_die('');
       
    61   $q = $db->sql_query('SELECT o.username,o.user_id,u.user_level FROM '.table_prefix.'online AS o
       
    62     LEFT JOIN '.table_prefix.'users AS u
       
    63       ON u.user_id=o.user_id
       
    64     WHERE last_load>'.( time() - 60*5 - 1 ).' ORDER BY username ASC'); if(!$q) $db->_die('');
       
    65   $num_guests = 0;
       
    66   $num_users = 0;
       
    67   $users = Array();
       
    68   while ( $row = $db->fetchrow() )
       
    69   {
       
    70     ( $row['user_id'] == 1 ) ? $num_guests++ : $num_users++;
       
    71     if($row['user_id'] > 1)
       
    72     {
       
    73       switch($row['user_level'])
       
    74       {
       
    75         case USER_LEVEL_MEMBER:
       
    76         default:
       
    77           $color = '303030';
       
    78           $weight = 'normal';
       
    79           break;
       
    80         case USER_LEVEL_MOD:
       
    81           $color = '00AA00';
       
    82           $weight = 'bold';
       
    83           break;
       
    84         case USER_LEVEL_ADMIN:
       
    85           $color = 'AA0000';
       
    86           $weight = 'bold';
       
    87           break;
       
    88       }
       
    89       $users[] = "<a href='".makeUrlNS('User', str_replace(' ', '_', $row['username']))."' style='color: #$color; font-weight: $weight'>{$row['username']}</a>";
       
    90       $whos_online['users'][] = $row['username'];
       
    91     }
       
    92     else
       
    93     {
       
    94       $whos_online['guests'][] = $row['username'];
       
    95     }
       
    96   }
       
    97   $total = $num_guests + $num_users;
       
    98   $ms = ( $num_users == 1 ) ? '' : 's';
       
    99   $gs = ( $num_guests == 1 ) ? '' : 's';
       
   100   $ts = ( $total == 1 ) ? '' : 's';
       
   101   $is_are = ( $total == 1 ) ? 'is' : 'are';
       
   102   $users = implode(', ', $users);
       
   103   $online_main = ( $num_users > 0 ) ? "<br />
       
   104                Users online right now:
       
   105                <div style='max-height: 100px; clip: rect(0px,auto,auto,0px); overflow: auto;'>
       
   106                $users
       
   107                </div>
       
   108                Legend:<br /><span style='color: #00AA00; font-weight: bold;'>Moderators</span> :: <span style='color: #AA0000; font-weight: bold;'>Administrators</span>"
       
   109                : '';
       
   110   $html = "<div style='padding: 5px;'>
       
   111              <small>
       
   112                There $is_are <b>$total</b> user$ts online :: <b>$num_guests</b> guest$gs and <b>$num_users</b> member$ms
       
   113                $online_main
       
   114              </small>
       
   115            </div>";
       
   116   $template->sidebar_widget('Who\'s Online', $html);
       
   117 }
       
   118 
       
   119 function __WhosOnline_logonhandler()
       
   120 {
       
   121   global $db, $session, $paths, $template, $plugins; // Common objects
       
   122   $q = $db->sql_query('DELETE FROM '.table_prefix.'online WHERE user_id=1 AND username=\''.$db->escape($_SERVER['REMOTE_ADDR']).'\';');
       
   123   if(!$q)
       
   124     echo $db->get_error();
       
   125   if(!$session->theme)
       
   126     $session->register_guest_session();
       
   127   $template->load_theme($session->theme, $session->style);
       
   128   __WhosOnline_UserCount();
       
   129 }
       
   130 
       
   131 function __WhosOnline_logoffhandler($username, $user_id, $level)
       
   132 {
       
   133   if($level <= USER_LEVEL_MEMBER)
       
   134   {
       
   135     global $db, $session, $paths, $template, $plugins; // Common objects
       
   136     $q = $db->sql_query('DELETE FROM '.table_prefix.'online WHERE user_id=\''.intval($user_id).'\' AND username=\''.$db->escape($username).'\';');
       
   137     if(!$q)
       
   138       echo $db->get_error();
       
   139     $q = $db->sql_query('REPLACE INTO '.table_prefix.'online SET user_id=1,username=\''.$db->escape($_SERVER['REMOTE_ADDR']).'\',last_load='.time().';'); if(!$q) $db->_die('');
       
   140     if(!$q)
       
   141       echo $db->get_error();
       
   142   }
       
   143 }
       
   144  
       
   145 ?>