Next wave of lesser getMessage() usage and more EL

[mailer.git] / inc / modules / admin / what-list_sponsor.php

diff --git a/inc/modules/admin/what-list_sponsor.php b/inc/modules/admin/what-list_sponsor.php
index b6369c6b44d475855796756dad1337679375e3e7..9a82dde5dba0672583e7b039e88428512c6011d3 100644 (file)
--- a/inc/modules/admin/what-list_sponsor.php
+++ b/inc/modules/admin/what-list_sponsor.php
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -39,7 +40,7 @@
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!isAdmin())) {
        die();
-}
+} // END - if
 
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
@@ -59,43 +60,25 @@ WHERE `id`='%s' LIMIT 1",
                // Check if an entry is empty
                foreach ($content as $k => $v) {
                        if (empty($v)) $content[$k] = '---';
-               }
-
-               // Check for sponsor's orders (only count)
-               $result_orders = SQL_QUERY_ESC("SELECT COUNT(id) FROM `{?_MYSQL_PREFIX?}_sponsor_orders` WHERE sponsorid='%s'",
-               array(bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
-               list($orders) = SQL_FETCHROW($result_orders);
-               SQL_FREERESULT($result_orders);
-               if (empty($orders)) $orders = '0';
+               } // END - foreach
 
                // Prepare all data for the template
                //  Sponsor's id
-               $content['id']                = getRequestParameter('id');
-               //  Personal data
-               $content['gender']      = translateGender($content['gender']);
+               $content['id']          = getRequestParameter('id');
                //  Contact data
                $content['email_link']  = generateEmailLink($content['email'], 'sponsor_data');
-               $content['url']         = generateDerefererUrl($content['url']);
                //  Timestamps
                $content['created']     = generateDateTime($content['sponsor_created'], 2);
                $content['last_online'] = generateDateTime($content['last_online'], 2);
                $content['last_change'] = generateDateTime($content['last_change'], 2);
-               //  Sponsor points
-               $content['points_amount'] = translateComma($content['points_amount']);
-               $content['points_used']   = translateComma($content['points_used']);
-               //  Warning because low points
-               $content['receive_warnings'] = translateYesNo($content['receive_warnings']);
-               $content['warning_interval'] = createFancyTime($content['warning_interval']);
                //  Orders total
-               $content['orders']           = $orders;
-               //  Other data
-               $content['status']           = sponsorTranslateUserStatus($content['status']);
+               $content['orders']      = countSumTotalData(bigintval(getRequestParameter('id')), 'sponsor_orders', 'id', 'sponsorid', true);
 
                // Load template
                loadTemplate('admin_list_sponsor_details', false, $content);
        } else {
                // Sponsor not found
-               loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_404', getRequestParameter('id')));
+               loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_404', bigintval(getRequestParameter('id'))));
        }
 } elseif (isGetRequestParameterSet('rid')) {
        // Search for sponsor
@@ -145,19 +128,18 @@ ORDER BY
                $OUT = ''; $SW = 2;
                while ($content = SQL_FETCHARRAY($result_main)) {
                        // Transfer data to array
-                       // @TODO Rewritings: surname->surname,family->family,ip->remote_addr in template
                        $content = array(
-                               'id'      => $content['id'],
-                               'sw'      => $SW,
-                               'gender'  => translateGender($content['gender']),
-                               'surname'   => $content['surname'],
-                               'family'   => $content['family'],
-                               'email'   => generateEmailLink($content['email'], 'sponsor_data'),
-                               'status'  => sponsorTranslateUserStatus($content['status']),
-                               'created' => generateDateTime($content['sponsor_created'], 2),
-                               'last_online'    => generateDateTime($content['last_online'], 2),
-                               'points'  => translateComma($content['points_amount'] - $content['points_used']),
-                               'ip'      => $content['remote_addr'],
+                               'id'          => $content['id'],
+                               'sw'          => $SW,
+                               'gender'      => $content['gender'],
+                               'surname'     => $content['surname'],
+                               'family'      => $content['family'],
+                               'email'       => generateEmailLink($content['email'], 'sponsor_data'),
+                               'status'      => $content['status'],
+                               'created'     => generateDateTime($content['sponsor_created'], 2),
+                               'last_online' => generateDateTime($content['last_online'], 2),
+                               'points'      => translateComma($content['points_amount'] - $content['points_used']),
+                               'remote_addr' => $content['remote_addr'],
                        );
 
                        // Load row template
@@ -172,7 +154,7 @@ ORDER BY
                loadTemplate('admin_list_sponsor', false, $OUT);
        } else {
                // No sponsors registered so far
-               loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_REGISTERED'));
+               loadTemplate('admin_settings_saved', false, '{--ADMIN_SPONSOR_NONE_REGISTERED--}');
        }
 }