inc/modules/admin/what-user_online.php

   1 <?php
   2 /************************************************************************
   3  * MXChange v0.2.1                                    Start: 02/02/2004 *
   4  * ================                             Last change: 07/13/2004 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : action-online.php                                *
   8  * -------------------------------------------------------------------- *
   9  * Short description : Who is where? (DO NOT add sub menus!)            *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Wer ist wo? (KEINE Untermenues anhaengen!)       *
  12  * -------------------------------------------------------------------- *
  13  *                                                                      *
  14  * -------------------------------------------------------------------- *
  15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  16  * For more information visit: http://www.mxchange.org                  *
  17  *                                                                      *
  18  * This program is free software; you can redistribute it and/or modify *
  19  * it under the terms of the GNU General Public License as published by *
  20  * the Free Software Foundation; either version 2 of the License, or    *
  21  * (at your option) any later version.                                  *
  22  *                                                                      *
  23  * This program is distributed in the hope that it will be useful,      *
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
  26  * GNU General Public License for more details.                         *
  27  *                                                                      *
  28  * You should have received a copy of the GNU General Public License    *
  29  * along with this program; if not, write to the Free Software          *
  30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
  31  * MA  02110-1301  USA                                                  *
  32  ************************************************************************/
  33
  34 // Some security stuff...
  35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
  36 {
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
  38         require($INC);
  39 }
  40
  41 // Add description as navigation point
  42 ADD_DESCR("admin", basename(__FILE__));
  43 OUTPUT_HTML("</FONT><br /><br />");
  44
  45 // Count guests, members and admins
  46 $result_guests  = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_online WHERE is_admin='N' AND is_member='N'", __FILE__, __LINE__);
  47 $result_members = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_online WHERE is_admin='N' AND is_member='Y'", __FILE__, __LINE__);
  48 $result_admins  = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_online WHERE is_admin='Y'", __FILE__, __LINE__);
  49
  50 OUTPUT_HTML("<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" width=\"170\" class=\"admin_table dashed\">
  51 <TR><TD colspan=\"5\" height=\"7\" class=\"seperator admin_title\">&nbsp;</TD></TR>
  52 <TR>
  53   <TD colspan=\"3\" class=\"admin_title\" align=\"center\">
  54     <STRONG>".USER_NOW_ONLINE."</STRONG>
  55   </TD>
  56 </TR>
  57 <TR><TD colspan=\"5\" height=\"7\" class=\"seperator admin_title\">&nbsp;</TD></TR>
  58 <TR>
  59   <TD width=\"85%\" class=\"top2 bottom2\" align=\"right\"><FONT class=\"medium\">".GUESTS_ONLINE.":</FONT></TD>
  60   <TD width=\"5%\" class=\"top2 bottom2\">&nbsp;</TD>
  61   <TD width=\"10%\" class=\"top2 bottom2\"><B>".SQL_NUMROWS($result_guests)."</B></TD>
  62 </TR>
  63 <TR>
  64   <TD width=\"85%\" class=\"bottom2\" align=\"right\"><FONT class=\"medium\">".MEMBERS_ONLINE.":</FONT></TD>
  65   <TD width=\"5%\" class=\"bottom2\">&nbsp;</TD>
  66   <TD width=\"10%\" class=\"bottom2\"><B>".SQL_NUMROWS($result_members)."</B></TD>
  67 </TR>
  68 <TR>
  69   <TD width=\"85%\" align=\"right\"><FONT class=\"medium\">".ADMINS_ONLINE.":</FONT></TD>
  70   <TD width=\"5%\">&nbsp;</TD>
  71   <TD width=\"10%\"><B>".SQL_NUMROWS($result_admins)."</B></TD>
  72 </TR>
  73 </TABLE><br />");
  74
  75 $result = SQL_QUERY("SELECT id, ip, userid, refid, module, action, what, is_member, is_admin, timestamp FROM "._MYSQL_PREFIX."_online ORDER by timestamp DESC", __FILE__, __LINE__);
  76 if (SQL_NUMROWS($result) > 0)
  77 {
  78         // Load header template
  79         LOAD_TEMPLATE("admin_online_header");
  80
  81         // List all online users
  82         $SW = 2;
  83         while (list($id, $ip, $userid, $refid, $module, $action, $what, $mem, $admin, $time) = SQL_FETCHROW($result))
  84         {
  85                 if ($action == "") $action = "---";
  86                 if ($what   == "")   $what = "---";
  87
  88                 if ($admin == 'Y')
  89                 {
  90                         // Is an administrator
  91                         $userid = _IS_ADMIN;
  92                 }
  93                 elseif (($mem == 'N') && ($admin == 'N'))
  94                 {
  95                         // Is a guest
  96                         $userid = _IS_GUEST;
  97                 }
  98                 OUTPUT_HTML("<TR>
  99   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$id."</TD>
 100   <TD align=\"center\" width=\"15%\" class=\"switch_sw".$SW." bottom right\">");
 101                 if ($userid > 0)
 102                 {
 103                         OUTPUT_HTML("<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;u_id=".$userid."\">".$userid."</A>");
 104                 }
 105                 else
 106                 {
 107                         OUTPUT_HTML($userid);
 108                 }
 109                 if ($refid > 0)
 110                 {
 111                         $refid = "<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;u_id=".$refid."\">".$refid."</A>";
 112                 }
 113                 OUTPUT_HTML("</TD>
 114   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$ip."</TD>
 115   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$refid."</TD>
 116   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$module."</TD>
 117   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$action."</TD>
 118   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$what."</TD>
 119   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom\">".MAKE_DATETIME($time, "2")."</TD>
 120 </TR>");
 121                 $SW = 3 - $SW;
 122         }
 123         OUTPUT_HTML("<TR>
 124   <TD colspan=\"8\" align=\"center\" class=\"admin_footer\">
 125     ".ONLINE_TIMEOUT_IS_1.CREATE_FANCY_TIME($_CONFIG['online_timeout']).ONLINE_TIMEOUT_IS_2."
 126   </TD>
 127 </TR>
 128 </TABLE>");
 129 }
 130 //
 131 ?>