A lot has been rewritten, ext-teams added, ext-forced continued:

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

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index fb49ad871153075ed47dcd7bed431e0a8a0ae17b..1c90f6a42086bfaf7873800912ab92d96a21bcf8 100644 (file)
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -55,7 +55,7 @@ if (isGetRequestParameterSet('rallye')) {
                                // Ok, new price level entered!
                                SQL_QUERY_ESC("INSERT INTO
        `{?_MYSQL_PREFIX?}_rallye_prices`
-(`rallye_id`, `price_level`, `points`, `info`)
+(`rallye_id`,`price_level`,`points`,`info`)
        VALUES
 (%s, %s, '%s', '%s')",
                                array(
@@ -73,7 +73,7 @@ if (isGetRequestParameterSet('rallye')) {
                                displayMessage('{--RALLYE_PRICE_ALREADY_FOUND--}');
                        }
                }
-       } elseif (isFormSent('remove')) {
+       } elseif (isFormSent('do_delete')) {
                // Check if at last one line is selected
                if (ifPostContainsSelections()) {
                        // Delete selected entries
@@ -87,7 +87,7 @@ if (isGetRequestParameterSet('rallye')) {
                } else {
                        displayMessage('{--RALLYE_ENTRIES_NOT_DELETED--}');
                }
-       } elseif (isFormSent('change')) {
+       } elseif (isFormSent('do_edit')) {
                // Change entries
                foreach (postRequestParameter('level') as $id => $level) {
                        // Secure id
@@ -124,7 +124,7 @@ LIMIT 1",
                        $OUT = '';
                        foreach (postRequestParameter('sel') as $id => $sel) {
                                // Load data to selected rallye
-                               $result = SQL_QUERY_ESC("SELECT `rallye_id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
+                               $result = SQL_QUERY_ESC("SELECT `rallye_id`,`price_level`,`points`,`info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
                                        array(bigintval($id)), __FILE__, __LINE__);
                                $content = SQL_FETCHARRAY($result);
                                SQL_FREERESULT($result);
@@ -156,7 +156,7 @@ LIMIT 1",
                        $OUT = '';
                        foreach (postRequestParameter('sel') as $id => $sel) {
                                // Load data to selected rallye
-                               $result = SQL_QUERY_ESC("SELECT `rallye_id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
+                               $result = SQL_QUERY_ESC("SELECT `rallye_id`,`price_level`,`points`,`info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
                                        array(bigintval($id)), __FILE__, __LINE__);
                                $content = SQL_FETCHARRAY($result);
                                SQL_FREERESULT($result);
@@ -178,7 +178,7 @@ LIMIT 1",
                }
        } else {
                // a rallye was selected, so check if there are already prices assigned...
-               $result = SQL_QUERY_ESC("SELECT `id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY `price_level` ASC",
+               $result = SQL_QUERY_ESC("SELECT `id`,`price_level`,`points`,`info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY `price_level` ASC",
                        array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__);
 
                if (!SQL_HASZERONUMS($result)) {
@@ -224,14 +224,9 @@ ORDER BY
                $OUT = '';
                while ($content = SQL_FETCHARRAY($result)) {
                        // Prepare data for the row template
-                       $content = array(
-                               'id'         => $content['id'],
-                               'title'      => $content['title'],
-                               'admin_id'   => $content['admin_id'],
-                               'login'      => $content['login'],
-                               'start'      => generateDateTime($content['start_time'], 3),
-                               'end'        => generateDateTime($content['end_time'], 3),
-                       );
+                       // @TODO rename: start->start_time, end->end_time
+                       $content['start'] = generateDateTime($content['start_time'], '3');
+                       $content['end']   = generateDateTime($content['end_time']  , '3');
 
                        // Load row template and switch color
                        $OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content);