X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-stats.php;h=72bb67e7999f27c5e31fcaa63be607120c053916;hp=1348afd9eea77034a617dec716d96a186d77e1fc;hb=f3e4c2c048761589836fdbe6bd2e46599a1833a7;hpb=8f60465485bd5e9ab2c0ddfa1f054458cf510042 diff --git a/inc/modules/guest/what-stats.php b/inc/modules/guest/what-stats.php index 1348afd9ee..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 * @@ -41,8 +46,9 @@ if (!defined('__SECURITY')) { 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(getConfig('guest_stats')); -switch ($_GET['mode']) { +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"; @@ -66,16 +72,16 @@ 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 gender='M' AND `status`='CONFIRMED'", __FILE__, __LINE__)); - $female = SQL_NUMROWS(SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE gender='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__)); @@ -85,11 +91,15 @@ case "MEMBERS": // Statistics about your members // 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=%s 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 @@ -97,19 +107,20 @@ case "MEMBERS": // Statistics about your members // 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) { // 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=%s", - 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); @@ -123,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) - { + 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 @@ -139,13 +149,10 @@ 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 - { + } else { $OUT .= "\n"; $r2 = " right2"; $l = "ll"; $r = "lr"; @@ -155,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, @@ -180,24 +186,26 @@ case "MODULES": // TOP10 module clicks 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 + // @TODO Rewrite this to one template and $OUT .= .... OUTPUT_HTML(" - + "); } if (SQL_NUMROWS($guest_t10) > 0) { // Guest clicks OUTPUT_HTML(" - + "); $SW = 2; - while (list($clicks, $title) = SQL_FETCHROW($guest_t10)) { + while ($content = SQL_FETCHARRAY($guest_t10)) { OUTPUT_HTML(" - - + + "); $SW = 3 - $SW; } @@ -206,13 +214,13 @@ case "MODULES": // TOP10 module clicks if (SQL_NUMROWS($guest_t10) > 0) { // Guest clicks OUTPUT_HTML(" - + "); $SW = 2; - while (list($clicks, $title) = SQL_FETCHROW($mem_t10)) { + while ($content = SQL_FETCHARRAY($mem_t10)) { OUTPUT_HTML(" - - + + "); $SW = 3 - $SW; } @@ -221,14 +229,16 @@ case "MODULES": // TOP10 module clicks if ((SQL_NUMROWS($guest_t10) > 0) || (SQL_NUMROWS($mem_t10) > 0)) { // Output footer OUTPUT_HTML(" - +
{!GUEST_TOPTEN_STATS!}{--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." + ".$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; }