More queries now depends on UNIX_TIMESTAMP() SQL function, wrong index in autopurge...
[mailer.git] / inc / modules / admin / what-usr_online.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 01/14/2005 *
4  * ================                             Last change: 01/14/2005 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : what-usr_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 ((!defined('__SECURITY')) || (!IS_ADMIN())) {
36         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
37         require($INC);
38 }
39
40 // Add description as navigation point
41 ADD_DESCR("admin", basename(__FILE__));
42
43 if (EXT_IS_ACTIVE("online", true))
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         // Remember values for the template
51         define('_GUESTS_ONLINE' , SQL_NUMROWS($result_guests));
52         define('_ADMINS_ONLINE' , SQL_NUMROWS($result_admins));
53         define('_MEMBERS_ONLINE', SQL_NUMROWS($result_members));
54
55         // Free memory
56         SQL_FREERESULT($result_guests);
57         SQL_FREERESULT($result_admins);
58         SQL_FREERESULT($result_members);
59
60         // Load template
61         LOAD_TEMPLATE("admin_mini_online");
62
63         // Check for online users
64         $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__);
65         if (SQL_NUMROWS($result) > 0)
66         {
67                 // Load header template
68                 LOAD_TEMPLATE("admin_online_header");
69
70                 // List all online users
71                 $SW = 2;
72                 while (list($id, $ip, $uid, $ref, $mod, $act, $wht, $mem, $admin, $time) = SQL_FETCHROW($result))
73                 {
74                         if (empty($act)) $act = "---";
75                         if (empty($wht))   $wht = "---";
76
77                         if ($admin == "Y")
78                         {
79                                 // Is an administrator
80                                 $uid = _IS_ADMIN;
81                         }
82                          elseif (($mem == "N") && ($admin == "N"))
83                         {
84                                 // Is a guest
85                                 $uid = _IS_GUEST;
86                         }
87                         OUTPUT_HTML("<TR>
88   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$id."</TD>
89   <TD align=\"center\" width=\"15%\" class=\"switch_sw".$SW." bottom right\">");
90                         if ($uid > 0)
91                         {
92                                 OUTPUT_HTML(ADMIN_USER_PROFILE_LINK($uid));
93                         }
94                          else
95                         {
96                                 OUTPUT_HTML($uid);
97                         }
98                         if ($ref > 0)
99                         {
100                                 $ref = ADMIN_USER_PROFILE_LINK($ref);
101                         }
102                         OUTPUT_HTML("</TD>
103   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$ip."</TD>
104   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$ref."</TD>
105   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$mod."</TD>
106   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom right\">".$act."</TD>
107   <TD align=\"center\" width=\"5%\" class=\"switch_sw".$SW." bottom right\">".$wht."</TD>
108   <TD align=\"center\" width=\"10%\" class=\"switch_sw".$SW." bottom\">".MAKE_DATETIME($time, "2")."</TD>
109 </TR>");
110                         $SW = 3 - $SW;
111                 }
112
113                 // Free memory
114                 SQL_FREERESULT($result);
115
116                 // Load footer template
117                 define('__FANCY_ONLINE_TIMEOUT', CREATE_FANCY_TIME($_CONFIG['online_timeout']));
118                 LOAD_TEMPLATE("admin_online_footer");
119         }
120 }
121  else
122 {
123         // Online statistics deactivated!
124         LOAD_TEMPLATE("admin_settings_saved", false, ONLINE_STATISTICS_DEACTIVATED);
125 }
126 //
127 ?>