(no commit message)
[mailer.git] / 0.2.1 / inc / modules / guest / what-active.php
1 <?php\r
2 /************************************************************************\r
3  * MXChange v0.2.1                                    Start: 11/26/2004 *\r
4  * ================                             Last change: 11/26/2004 *\r
5  *                                                                      *\r
6  * -------------------------------------------------------------------- *\r
7  * File              : what-active.php                                  *\r
8  * -------------------------------------------------------------------- *\r
9  * Short description : Today active members list                        *\r
10  * -------------------------------------------------------------------- *\r
11  * Kurzbeschreibung  : Liste heutiger aktiver Mitglieder                *\r
12  * -------------------------------------------------------------------- *\r
13  *                                                                      *\r
14  * -------------------------------------------------------------------- *\r
15  * Copyright (c) 2003 - 2007 by Roland Haeder                           *\r
16  * For more information visit: http://www.mxchange.org                  *\r
17  *                                                                      *\r
18  * This program is free software; you can redistribute it and/or modify *\r
19  * it under the terms of the GNU General Public License as published by *\r
20  * the Free Software Foundation; either version 2 of the License, or    *\r
21  * (at your option) any later version.                                  *\r
22  *                                                                      *\r
23  * This program is distributed in the hope that it will be useful,      *\r
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
26  * GNU General Public License for more details.                         *\r
27  *                                                                      *\r
28  * You should have received a copy of the GNU General Public License    *\r
29  * along with this program; if not, write to the Free Software          *\r
30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
31  * MA  02110-1301  USA                                                  *\r
32  ************************************************************************/\r
33 \r
34 // Some security stuff...\r
35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))\r
36 {\r
37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
38         require($INC);\r
39 }\r
40  elseif ((!EXT_IS_ACTIVE("active")) && (!IS_ADMIN()))\r
41 {\r
42         ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "active");\r
43         return;\r
44 }\r
45 \r
46 // Add description as navigation point\r
47 ADD_DESCR("guest", basename(__FILE__));\r
48 \r
49 // The day normally starts on 00:00:00, so let's subtract current hours/minutes/seconds from current time stamp!\r
50 $START = time() - date("H", time())*60*60 - date("m", time())*60 - date("s", time());\r
51 \r
52 // Check for members who were active only this day\r
53 $ADD = "uid";\r
54 if (EXT_IS_ACTIVE("nickname")) $ADD = "nickname";\r
55 \r
56 $result = SQL_QUERY_ESC("SELECT userid, ".$ADD.", last_online\r
57 FROM "._MYSQL_PREFIX."_user_data\r
58 WHERE last_online >= %s AND status='CONFIRMED'\r
59 ORDER BY last_online DESC LIMIT %s",\r
60  array($START, $CONFIG['active_limit']), __FILE__, __LINE__);\r
61 \r
62 if (SQL_NUMROWS($result) > 0)\r
63 {\r
64         // At least one member was online so let's load them all\r
65         $OUT = ""; $SW = 2;\r
66         while(list($uid, $nick, $last) = SQL_FETCHROW($result))\r
67         {\r
68                 $nick2 = "---";\r
69                 if (($nick != $uid) && (!empty($nick))) $nick2 = $nick;\r
70 \r
71                 // Transfer data to array\r
72                 $content = array(\r
73                         'sw'     => $SW,\r
74                         'uid'    => $uid,\r
75                         'nick'   => $nick2,\r
76                         'points' => TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "points") - GET_TOTAL_DATA($uid, "user_data", "used_points")),\r
77                         'last'   => MAKE_DATETIME($last, "2"),\r
78                 );\r
79 \r
80                 // Load template\r
81                 $OUT .= LOAD_TEMPLATE("guest_active_row", true, $content);\r
82 \r
83                 // Switch colors\r
84                 $SW = 3 - $SW;\r
85         }\r
86 }\r
87  else\r
88 {\r
89         // No member was online today! :-(\r
90         $OUT = LOAD_TEMPLATE("guest_active_none_row", true);\r
91 }\r
92 \r
93 // Remember output in constant\r
94 define('__ACTIVE_ROWS', $OUT);\r
95 \r
96 // Load template\r
97 LOAD_TEMPLATE("guest_active_table");\r
98 \r
99 //\r
100 ?>\r