A lot rewrites from double-quote to single-quote, some fixes for extension handling...

[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 569ff0e1d08e54935f3e82dae9802a36110c440d..26e13668fc5f99d1c9ad2dbe9a0cf83b14bfbf84 100644 (file)
--- a/inc/modules/admin/what-list_sponsor.php
+++ b/inc/modules/admin/what-list_sponsor.php
@@ -10,7 +10,12 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Alle Sponsoren und deren Details auflisten       *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $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 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
@@ -38,7 +43,7 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+ADD_DESCR('admin', __FILE__);
 
 if (REQUEST_ISSET_GET(('id'))) {
        // Show detailed informations to a sponsor
@@ -65,6 +70,7 @@ WHERE id='%s' LIMIT 1",
                if (empty($orders)) $orders = 0;
 
                // Prepare all data for the template
+               // @TODO Rewrite this huge amount of constants
                //  Sponsor's ID
                define('__SPONSOR_ID'         , REQUEST_GET('id'));
                //  Company's data
@@ -109,7 +115,7 @@ WHERE id='%s' LIMIT 1",
                LOAD_TEMPLATE("admin_list_sponsor_details");
        } else {
                // Sponsor not found
-               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_SPONSOR_404'), REQUEST_GET('id')));
+               LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_SPONSOR_404'), REQUEST_GET('id')));
        }
 } elseif (REQUEST_ISSET_GET(('rid'))) {
        // Search for sponsor
@@ -131,11 +137,11 @@ WHERE refid='%s' ORDER BY `id`",
                        SQL_FREERESULT($result);
                } else {
                        // No refs made so far
-                       LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_SPONSOR_REFS_404'), "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_sponsor&amp;id=".bigintval(REQUEST_GET('rid'))."\">".bigintval(REQUEST_GET('rid'))."</a>"));
+                       LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_SPONSOR_REFS_404'), "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_sponsor&amp;id=".bigintval(REQUEST_GET('rid'))."\">".bigintval(REQUEST_GET('rid'))."</a>"));
                }
        } else {
                // Sponsor not found
-               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval(REQUEST_GET('rid'))));
+               LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval(REQUEST_GET('rid'))));
        }
 } else {
        // List all sponsors
@@ -143,21 +149,22 @@ WHERE refid='%s' ORDER BY `id`",
 FROM `{!_MYSQL_PREFIX!}_sponsor_data` ORDER BY `id`", __FILE__, __LINE__);
        if (SQL_NUMROWS($result_main) > 0) {
                // At least one sponsor found!
-               $OUT = ""; $SW = 2;
-               while (list($id, $gender, $sname, $fname, $email, $status, $created, $last, $amount, $used, $ip) = SQL_FETCHROW($result_main)) {
+               $OUT = ''; $SW = 2;
+               while ($content = SQL_FETCHARRAY($result_main)) {
                        // Transfer data to array
+                       // @TODO Rewritings: sname->surname,fname->family,ip->remote_addr in template
                        $content = array(
-                               'id'      => $id,
+                               'id'      => $content['id'],
                                'sw'      => $SW,
-                               'gender'   => TRANSLATE_GENDER($gender),
-                               'sname'   => $sname,
-                               'fname'   => $fname,
-                               'email'   => "mailto:".$email,
-                               'status'  => SPONSOR_TRANSLATE_STATUS($status),
-                               'created' => MAKE_DATETIME($created, "2"),
-                               'last'    => MAKE_DATETIME($last, "2"),
-                               'points'  => TRANSLATE_COMMA($amount - $used),
-                               'ip'      => $ip,
+                               'gender'  => TRANSLATE_GENDER($content['gender']),
+                               'sname'   => $content['surname'],
+                               'fname'   => $content['family'],
+                               'email'   => "mailto:".$content['email'],
+                               'status'  => SPONSOR_TRANSLATE_STATUS($content['status']),
+                               'created' => MAKE_DATETIME($content['sponsor_created'], "2"),
+                               'last'    => MAKE_DATETIME($content['last_online'], "2"),
+                               'points'  => TRANSLATE_COMMA($content['points_amount'] - $content['points_used']),
+                               'ip'      => $content['remote_addr'],
                        );
 
                        // Load row template
@@ -167,13 +174,15 @@ FROM `{!_MYSQL_PREFIX!}_sponsor_data` ORDER BY `id`", __FILE__, __LINE__);
 
                // Free memory
                SQL_FREERESULT($result_main);
+
+               // @TODO Rewrite this constant
                define('__SPONSOR_ROWS', $OUT);
 
                // Load final template
                LOAD_TEMPLATE("admin_list_sponsor");
        } else {
                // No sponsors registered so far
-               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SPONSOR_NONE_REGISTERED'));
+               LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_REGISTERED'));
        }
 }