* -------------------------------------------------------------------- *
* Kurzbeschreibung : Statistiken *
* -------------------------------------------------------------------- *
- * $Revision:: 856 $ *
+ * $Revision:: $ *
* $Date:: $ *
* $Tag:: 0.2.1-FINAL $ *
* $Author:: $ *
// Some security stuff...
if (!defined('__SECURITY')) {
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
require($INC);
}
// Add description as navigation point
-ADD_DESCR("guest", __FILE__);
+ADD_DESCR('guest', __FILE__);
// Derterminate which stats we want and set mode and title for the link below stats block
if (!REQUEST_ISSET_GET(('mode'))) REQUEST_SET_GET('mode', strtolower(getConfig('guest_stats')));
switch (REQUEST_GET('mode')) {
- case "members" :
- setConfigEntry('guest_stats', "MEMBERS");
- $lmode = "modules";
+ case 'members' :
+ setConfigEntry('guest_stats', 'MEMBERS');
+ $lmode = 'modules';
$ltitle = getMessage('GUEST_STATS_MODULES');
break;
- case "modules" :
- setConfigEntry('guest_stats', "MODULES");
- $lmode = "members";
+ case 'modules' :
+ setConfigEntry('guest_stats', 'MODULES');
+ $lmode = 'members';
$ltitle = getMessage('GUEST_STATS_MEMBERS');
break;
- case "inactive":
- setConfigEntry('guest_stats', "INACTIVE");
- $lmode = "inactive";
+ case 'inactive':
+ setConfigEntry('guest_stats', 'INACTIVE');
+ $lmode = 'inactive';
$ltitle = getMessage('GUEST_STATS_INACTIVE');
break;
}
switch (getConfig('guest_stats'))
{
-case "MEMBERS": // Statistics about your members
+case 'MEMBERS': // Statistics about your members
// Members yesterday / today online
- $ymem = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE last_online >= ".constant('START_YDAY')." AND last_online < ".constant('START_TDAY')." AND `status`='CONFIRMED'", __FILE__, __LINE__));
- $tmem = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE last_online >= ".constant('START_TDAY')." AND `status`='CONFIRMED'", __FILE__, __LINE__));
+ $ymem = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE last_online >= ".getConfig('START_YDAY')." AND `last_online` < ".getConfig('START_TDAY')." AND `status`='CONFIRMED'", __FILE__, __LINE__));
+ $tmem = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE last_online >= ".getConfig('START_TDAY')." AND `status`='CONFIRMED'", __FILE__, __LINE__));
// Yesterday / today registered
- $yreg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE joined >= ".constant('START_YDAY')." AND joined < ".constant('START_TDAY'), __FILE__, __LINE__));
- $treg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE joined >= ".constant('START_TDAY'), __FILE__, __LINE__));
+ $yreg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE joined >= ".getConfig('START_YDAY')." AND joined < ".getConfig('START_TDAY'), __FILE__, __LINE__));
+ $treg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE joined >= ".getConfig('START_TDAY'), __FILE__, __LINE__));
// Only males / females
- $male = GET_TOTAL_DATA("M", "user_data", "userid", "gender", true, " AND `status`='CONFIRMED'");
- $female = GET_TOTAL_DATA("F", "user_data", "userid", "gender", true, " AND `status`='CONFIRMED'");
+ $male = GET_TOTAL_DATA('M', 'user_data', 'userid', 'gender', true, " AND `status`='CONFIRMED'");
+ $female = GET_TOTAL_DATA('F', 'user_data', 'userid', 'gender', true, " AND `status`='CONFIRMED'");
// Unconfirmed accounts
$unconfirmed = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE status != 'CONFIRMED'", __FILE__, __LINE__));
$month = $idx;
// Append leading zero
- if ($idx < 10) $month = "0".$idx;
+ if ($idx < 10) $month = '0'.$idx;
// Count months
- $months[$month] = GET_TOTAL_DATA(bigintval($month), "user_data", "userid", "birth_month", true, " AND `status`='CONFIRMED'");
+ $months[$month] = GET_TOTAL_DATA(bigintval($month), 'user_data', 'userid', 'birth_month', true, " AND `status`='CONFIRMED'");
}
// Members in categories
// Now we have all categories loaded, count members
foreach ($cats as $id => $dummy) {
// We only need id and nothing more to count...
- $cat_cnt[$id] = GET_TOTAL_DATA(bigintval($id), "user_cats", "id", "cat_id", true);
+ $cat_cnt[$id] = GET_TOTAL_DATA(bigintval($id), 'user_cats', 'id', 'cat_id', true);
}
// Prepare data for the template
define('__LINK_TITLE' , $ltitle);
// Generate monthly stats
- $SW = 2; $r2 = " right2"; $l = "ll"; $r = "lr"; $OUT = "";
+ $SW = 2; $r2 = ' right2'; $l = 'll'; $r = 'lr'; $OUT = '';
foreach ($months as $month => $cnt) {
if ($SW == 2) $OUT .= "<tr>\n";
$OUT .= LOAD_TEMPLATE("guest_stats_month_row", true, $content);
if ($SW == 2) {
- $r2 = "";
- $l = "rl"; $r = "rr";
+ $r2 = '';
+ $l = 'rl'; $r = 'rr';
} else {
$OUT .= "</tr>\n";
- $r2 = " right2";
- $l = "ll"; $r = "lr";
+ $r2 = ' right2';
+ $l = 'll'; $r = 'lr';
}
$SW = 3 - $SW;
}
define('__MONTH_STATS_ROWS', $OUT);
// Generate category stats
- $OUT = ""; $SW = 2;
+ $OUT = ''; $SW = 2;
foreach ($cat_cnt as $id => $cnt) {
// Prepare data for the template
$content = array(
);
// Load row template and switch colors
- $OUT .= LOAD_TEMPLATE("guest_stats_cats_row", true, $content);
+ $OUT .= LOAD_TEMPLATE('guest_stats_cats_row', true, $content);
$SW = 3 - $SW;
}
define('__CATS_STATS_ROWS', $OUT);
// Load final template
- LOAD_TEMPLATE("guest_stats_member");
+ LOAD_TEMPLATE('guest_stats_member');
break;
-case "MODULES": // TOP10 module clicks
- $AND = "";
+case 'MODULES': // TOP10 module clicks
+ $AND = '';
if (!IS_ADMIN()) $AND = " AND `locked`='N' AND `visible`='Y'";
$guest_t10 = SQL_QUERY("SELECT counter, title FROM `{!_MYSQL_PREFIX!}_guest_menu` WHERE counter > 0".$AND." ORDER BY counter DESC LIMIT 0,10", __FILE__, __LINE__);
$mem_t10 = SQL_QUERY("SELECT counter, title FROM `{!_MYSQL_PREFIX!}_member_menu` WHERE counter > 0".$AND." ORDER BY counter DESC LIMIT 0,10", __FILE__, __LINE__);
- $OUT = "";
+ $OUT = '';
if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) {
// Output header
// @TODO Rewrite this to one template and $OUT .= ....
}
break;
-case "INACTIVE": // Deactivated stats
- LOAD_TEMPLATE("admin_settings_saved", false, "<strong>{--GUEST_STATS_DEACTIVATED--}</strong>");
+case 'INACTIVE': // Deactivated stats
+ LOAD_TEMPLATE('admin_settings_saved', false, "<strong>{--GUEST_STATS_DEACTIVATED--}</strong>");
break;
}