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 57d2a6dc95b4e84447d249c91b2b9840abc56554..a5ad5e61faac792850edddcf981b50a5fe52f9e2 100644 (file)
--- a/inc/modules/guest/what-top10.php
+++ b/inc/modules/guest/what-top10.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
  * Mailer v0.2.1-FINAL                                Start: 11/24/2004 *
- * ================                             Last change: 11/26/2004 *
+ * ===================                          Last change: 11/26/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-top10.php                                   *
@@ -14,10 +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 - 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 *
@@ -42,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
 
@@ -64,44 +63,41 @@ ORDER BY
        `total_logins` DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
-       $content['nickname'] = '---';
+       $content['nickname'] = '';
 
        // Get nickname
        if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
 
        // Prepare data for template
        $content = array(
-               'sw'           => $SW,
-               'cnt'          => $cnt,
+               'cnt'          => $count,
                'userid'       => $content['userid'],
                'nickname'     => $content['nickname'],
                'total_logins' => $content['total_logins'],
-               'points'       => translateComma(countSumTotalData($content['userid'], 'user_points', 'points')),
+               'points'       => getTotalPoints($content['userid']),
                'last_online'  => generateDateTime($content['last_online'], 3),
        );
 
        // Load row template
        $OUT .= loadTemplate('guest_top10_row_login', true, $content);
 
-       // Switch colors and count one up
-       $SW = 3 - $SW; $cnt++;
+       // Count one up
+       $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(
-                       'sw'    => $SW,
                        'index' => $i
                );
 
                // Load row template
                $OUT .= loadTemplate('guest_top10_empty5', true, $content);
-               $SW = 3 - $SW;
        } // END - for
 } // END - if
 
@@ -114,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
@@ -132,43 +128,40 @@ ORDER BY
        d.last_online DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
-       $content['nickname'] = '---';
+       $content['nickname'] = '';
 
        // Get nickname
        if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
 
        // Prepare data for template
        $content = array(
-               'sw'          => $SW,
-               'cnt'         => $cnt,
+               'cnt'         => $count,
                'userid'      => $content['userid'],
                'nickname'    => $content['nickname'],
-               'points'      => translateComma($content['points']),
+               'points'      => $content['points'],
                'last_online' => generateDateTime($content['last_online'], 3)
        );
 
        // Load row template
        $OUT .= loadTemplate('guest_top10_row_earner', true, $content);
 
-       // Switch colors and count one up
-       $SW = 3 - $SW; $cnt++;
+       // Count one up
+       $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(
-                       'sw'    => $SW,
                        'index' => $i
                );
 
                // Load row template
                $OUT .= loadTemplate('guest_top10_empty4', true, $content);
-               $SW = 3 - $SW;
        } // END - for
 } // END - if
 
@@ -199,44 +192,41 @@ ORDER BY
        d.last_online DESC
 LIMIT {?top10_max?}", __FILE__, __LINE__);
 
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $count = 1;
 while ($content = SQL_FETCHARRAY($result)) {
        // Init nickname
-       $content['nickname'] = '---';
+       $content['nickname'] = '';
 
        // Get nickname
        if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
 
        // Prepare data for template
        $content = array(
-               'sw'          => $SW,
-               'cnt'         => $cnt,
+               'cnt'         => $count,
                'userid'      => $content['userid'],
                'refs'        => $content['refs'],
                'nickname'    => $content['nickname'],
-               'points'      => translateComma(countSumTotalData($content['userid'], 'user_points', 'points')),
+               'points'      => getTotalPoints($content['userid']),
                'last_online' => generateDateTime($content['last_online'], 3)
        );
 
        // Load row template
        $OUT .= loadTemplate('guest_top10_row_refs', true, $content);
 
-       // Switch colors and count one up
-       $SW = 3 - $SW; $cnt++;
+       // Count one up
+       $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(
-                       'sw'    => $SW,
                        'index' => $i
                );
 
                // Load row template
                $OUT .= loadTemplate('guest_top10_empty5', true, $content);
-               $SW = 3 - $SW;
        } // END - for
 } // END - if