X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-stats.php;h=72bb67e7999f27c5e31fcaa63be607120c053916;hp=7278e3bb976783ce2bc6e380f7fe6cda253376d1;hb=f3e4c2c048761589836fdbe6bd2e46599a1833a7;hpb=5ef6ed7373ae85e5635e39e2a0adf9496a8add05 diff --git a/inc/modules/guest/what-stats.php b/inc/modules/guest/what-stats.php index 7278e3bb97..72bb67e799 100644 --- a/inc/modules/guest/what-stats.php +++ b/inc/modules/guest/what-stats.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Statistiken * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: stelzi $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,73 +37,90 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } + // Add description as navigation point -ADD_DESCR("guest", basename(__FILE__)); +ADD_DESCR("guest", __FILE__); // Derterminate which stats we want and set mode and title for the link below stats block -if (!isset($_GET['mode'])) $_GET['mode'] = strtolower($CONFIG['guest_stats']); -switch ($_GET['mode']) -{ - case "members": $CONFIG['guest_stats'] = "MEMBERS"; $lmode = "modules"; $ltitle = GUEST_STATS_MODULES; break; - case "modules": $CONFIG['guest_stats'] = "MODULES"; $lmode = "members"; $ltitle = GUEST_STATS_MEMBERS; break; +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"; + $ltitle = getMessage('GUEST_STATS_MODULES'); + break; + + case "modules" : + setConfigEntry('guest_stats', "MODULES"); + $lmode = "members"; + $ltitle = getMessage('GUEST_STATS_MEMBERS'); + break; + + case "inactive": + setConfigEntry('guest_stats', "INACTIVE"); + $lmode = "inactive"; + $ltitle = getMessage('GUEST_STATS_INACTIVE'); + break; } -OPEN_TABLE("100%", "guest_content", "center", "top"); -switch ($CONFIG['guest_stats']) +switch (getConfig('guest_stats')) { 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 >= ".START_YDAY." AND last_online < ".START_TDAY." AND status='CONFIRMED'", __FILE__, __LINE__)); - $tmem = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE last_online >= ".START_TDAY." AND status='CONFIRMED'", __FILE__, __LINE__)); + $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__)); // Yesterday / today registered - $yreg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE joined >= ".START_YDAY." AND joined < ".START_TDAY, __FILE__, __LINE__)); - $treg = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE joined >= ".START_TDAY, __FILE__, __LINE__)); + $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__)); // Only males / females - $male = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE sex='M' AND status='CONFIRMED'", __FILE__, __LINE__)); - $female = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE sex='F' AND status='CONFIRMED'", __FILE__, __LINE__)); + $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__)); + $unconfirmed = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE status != 'CONFIRMED'", __FILE__, __LINE__)); // Total members $total = $male + $female; // List every month $months = array(); - for ($idx = 1; $idx < 13; $idx++) - { - $month = $idx; if ($idx < 10) $month = "0".$idx; - $months[$month] = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE birth_month=%d AND status='CONFIRMED'", - array(bigintval($month)), __FILE__, __LINE__)); + for ($idx = 1; $idx < 13; $idx++) { + // Copy it so we don't touch the for() loop index + $month = $idx; + + // Append leading zero + if ($idx < 10) $month = "0".$idx; + + // Count months + $months[$month] = GET_TOTAL_DATA(bigintval($month), "user_data", "userid", "birth_month", true, " AND `status`='CONFIRMED'"); } // Members in categories - $result = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats WHERE visible='Y' ORDER BY id", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT id, cat FROM `{!_MYSQL_PREFIX!}_cats` WHERE `visible`='Y' ORDER BY `id`", __FILE__, __LINE__); // Load categories first $cats = array(); $cat_cnt = array(); - while (list($id, $cat) = SQL_FETCHROW($result)) - { + // @TODO This can be somehow rewritten + while ($content = SQL_FETCHARRAY($result)) { // Simple... - $cats[$id] = $cat; + $cats[$content['id']] = $content['cat']; } // Now we have all categories loaded, count members - foreach ($cats as $id=>$dummy) - { + foreach ($cats as $id => $dummy) { // We only need id and nothing more to count... - $cat_cnt[$id] = SQL_NUMROWS(SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE cat_id=%d", - array(bigintval($id)), __FILE__, __LINE__)); + $cat_cnt[$id] = GET_TOTAL_DATA(bigintval($id), "user_cats", "id", "cat_id", true); } // Prepare data for the template + // @TODO Rewrite all these constants define('__TOTAL_USERS' , $total); define('__UNCONFIRMED' , $unconfirmed); define('__MALE_COUNT' , $male); @@ -112,14 +134,13 @@ case "MEMBERS": // Statistics about your members // Generate monthly stats $SW = 2; $r2 = " right2"; $l = "ll"; $r = "lr"; $OUT = ""; - foreach ($months as $month=>$cnt) - { - if ($SW == 2) $OUT .= "\n"; + foreach ($months as $month => $cnt) { + if ($SW == 2) $OUT .= "\n"; // Prepare data for template $content = array( 'l_class' => $l, - 'm_descr' => $MONTH_DESCR[$month], + 'm_descr' => $GLOBALS['month_descr'][$month], 'r_class' => $r, 'r2_class' => $r2, 'cnt' => $cnt @@ -128,14 +149,11 @@ case "MEMBERS": // Statistics about your members // Load row template $OUT .= LOAD_TEMPLATE("guest_stats_month_row", true, $content); - if ($SW == 2) - { + if ($SW == 2) { $r2 = ""; $l = "rl"; $r = "rr"; - } - else - { - $OUT .= "\n"; + } else { + $OUT .= "\n"; $r2 = " right2"; $l = "ll"; $r = "lr"; } @@ -144,9 +162,8 @@ case "MEMBERS": // Statistics about your members define('__MONTH_STATS_ROWS', $OUT); // Generate category stats - $SW = 2; $OUT = ""; - foreach ($cat_cnt as $id=>$cnt) - { + $OUT = ""; $SW = 2; + foreach ($cat_cnt as $id => $cnt) { // Prepare data for the template $content = array( 'sw' => $SW, @@ -166,64 +183,64 @@ case "MEMBERS": // Statistics about your members 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__); - if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) - { + 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 = ""; + if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) { // Output header - OUTPUT_HTML(" - - -"); + // @TODO Rewrite this to one template and $OUT .= .... + OUTPUT_HTML("
".GUEST_TOPTEN_STATS."
+ + +"); } - if (SQL_NUMROWS($guest_t10) > 0) - { + if (SQL_NUMROWS($guest_t10) > 0) { // Guest clicks - OUTPUT_HTML(" - -"); + OUTPUT_HTML(" + +"); $SW = 2; - while (list($clicks, $title) = SQL_FETCHROW($guest_t10)) - { - OUTPUT_HTML(" - - -"); + while ($content = SQL_FETCHARRAY($guest_t10)) { + OUTPUT_HTML(" + + +"); $SW = 3 - $SW; } } - if (SQL_NUMROWS($guest_t10) > 0) - { + + if (SQL_NUMROWS($guest_t10) > 0) { // Guest clicks - OUTPUT_HTML(" - -"); + OUTPUT_HTML(" + +"); $SW = 2; - while (list($clicks, $title) = SQL_FETCHROW($mem_t10)) - { - OUTPUT_HTML(" - - -"); + while ($content = SQL_FETCHARRAY($mem_t10)) { + OUTPUT_HTML(" + + +"); $SW = 3 - $SW; } } - if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) - { + + if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) { // Output footer - OUTPUT_HTML(" - - -
{--GUEST_TOPTEN_STATS--}
".GUEST_TOP_GUEST_STATS."
{--GUEST_TOP_GUEST_STATS--}
".$title."  ".$clicks."
".$content['title']."  ".$content['counter']."
".GUEST_TOP_MEMBER_STATS."
{--GUEST_TOP_MEMBER_STATS--}
".$title."  ".$clicks."
".$content['title']."  ".$content['counter']."
".$ltitle."
"); + OUTPUT_HTML(" + + ".$ltitle." + + +"); } break; case "INACTIVE": // Deactivated stats - LOAD_TEMPLATE("admin_settings_saved", false, "".GUEST_STATS_DEACTIVATED.""); + LOAD_TEMPLATE("admin_settings_saved", false, "{--GUEST_STATS_DEACTIVATED--}"); break; } -CLOSE_TABLE(); + // ?>