Extension 'ext-coupon' moved to branch, SQLs improved:

[mailer.git] / inc / modules / guest / what-top10.php

diff --git a/inc/modules/guest/what-top10.php b/inc/modules/guest/what-top10.php
index 20865bdfedd99f8410fed3acc8cf5c8f139c9df6..a5ad5e61faac792850edddcf981b50a5fe52f9e2 100644 (file)
--- a/inc/modules/guest/what-top10.php
+++ b/inc/modules/guest/what-top10.php
@@ -14,11 +14,9 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -43,10 +41,10 @@ if (!defined('__SECURITY')) {
 } // END - if
 
 // Add description as navigation point
-addMenuDescription('guest', __FILE__);
+addYouAreHereLink('guest', __FILE__);
 
 if ((!isExtensionActive('top10')) && (!isAdmin())) {
-       loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('top10'));
+       displayMessage(generateExtensionInactiveNotInstalledMessage('top10'));
        return;
 } // END - if
 
@@ -65,7 +63,7 @@ ORDER BY
        `total_logins` DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
        $content['nickname'] = '';
@@ -75,7 +73,7 @@ while ($content = SQL_FETCHARRAY($result)) {
 
        // Prepare data for template
        $content = array(
-               'cnt'          => $cnt,
+               'cnt'          => $count,
                'userid'       => $content['userid'],
                'nickname'     => $content['nickname'],
                'total_logins' => $content['total_logins'],
@@ -87,12 +85,12 @@ while ($content = SQL_FETCHARRAY($result)) {
        $OUT .= loadTemplate('guest_top10_row_login', true, $content);
 
        // Count one up
-       $cnt++;
+       $count++;
 } // END - while
 
-if ($cnt < getConfig('top10_max')) {
+if ($count < getConfig('top10_max')) {
        // Add more "blank" rows
-       for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
+       for ($i = $count; $i <= getConfig('top10_max'); $i++) {
                // Prepare data for template
                $content = array(
                        'index' => $i
@@ -112,7 +110,7 @@ SQL_FREERESULT($result);
 //// TOP earners
 $result = SQL_QUERY("SELECT
        d.userid,
-       (SUM(p.points) - d.used_points) AS points,
+       (SUM(p.points) - d.used_points) AS `points`,
        d.last_online
 FROM
        `{?_MYSQL_PREFIX?}_user_data` AS d
@@ -130,7 +128,7 @@ ORDER BY
        d.last_online DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
        $content['nickname'] = '';
@@ -140,7 +138,7 @@ while ($content = SQL_FETCHARRAY($result)) {
 
        // Prepare data for template
        $content = array(
-               'cnt'         => $cnt,
+               'cnt'         => $count,
                'userid'      => $content['userid'],
                'nickname'    => $content['nickname'],
                'points'      => $content['points'],
@@ -151,12 +149,12 @@ while ($content = SQL_FETCHARRAY($result)) {
        $OUT .= loadTemplate('guest_top10_row_earner', true, $content);
 
        // Count one up
-       $cnt++;
+       $count++;
 } // END - while
 
-if ($cnt < getConfig('top10_max')) {
+if ($count < getConfig('top10_max')) {
        // Add more "blank" rows
-       for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
+       for ($i = $count; $i <= getConfig('top10_max'); $i++) {
                // Prepare data for template
                $content = array(
                        'index' => $i
@@ -194,7 +192,7 @@ ORDER BY
        d.last_online DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
        $content['nickname'] = '';
@@ -204,7 +202,7 @@ while ($content = SQL_FETCHARRAY($result)) {
 
        // Prepare data for template
        $content = array(
-               'cnt'         => $cnt,
+               'cnt'         => $count,
                'userid'      => $content['userid'],
                'refs'        => $content['refs'],
                'nickname'    => $content['nickname'],
@@ -216,12 +214,12 @@ while ($content = SQL_FETCHARRAY($result)) {
        $OUT .= loadTemplate('guest_top10_row_refs', true, $content);
 
        // Count one up
-       $cnt++;
+       $count++;
 } // END - while
 
-if ($cnt < getConfig('top10_max')) {
+if ($count < getConfig('top10_max')) {
        // Add more "blank" rows
-       for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
+       for ($i = $count; $i <= getConfig('top10_max'); $i++) {
                // Prepare data for template
                $content = array(
                        'index' => $i