Fixes for 'empty version'

[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 5d7453ff5e25a0a570a8c4ecdad057a8ba5bc050..40a5cf88d3f31df5dc03586e2d523bb9a87523f9 100644 (file)
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -1,6 +1,6 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 07/03/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 07/03/2004 *
  * ================                             Last change: 08/22/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
@@ -52,7 +52,7 @@ if (isGetRequestElementSet('rallye')) {
                        $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s AND `price_level`='%s' LIMIT 1",
                        array(bigintval(getRequestElement('rallye')), bigintval(postRequestElement('level'))), __FILE__, __LINE__);
 
-                       if (SQL_NUMROWS($result) == 0) {
+                       if (SQL_NUMROWS($result) == '0') {
                                // Ok, new price level entered!
                                SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_rallye_prices` (rallye_id, price_level, points, info)
 VALUES ('%s','%s','%s','%s')",
@@ -73,8 +73,7 @@ VALUES ('%s','%s','%s','%s')",
                }
        } elseif (isPostRequestElementSet('remove')) {
                // Check if at last one line is selected
-               $SEL = countPostSelection();
-               if ($SEL > 0) {
+               if (countPostSelection() > 0) {
                        // Delete selected entries
                        foreach (postRequestElement('sel') as $id => $sel) {
                                SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
@@ -93,14 +92,23 @@ VALUES ('%s','%s','%s','%s')",
                        $id = bigintval($id);
 
                        // Update entry
-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_prices` SET rallye_id=%s, price_`level`='%s', points='%s', info='%s' WHERE `id`=%s LIMIT 1",
-                       array(
-                               postRequestElement('rallye_id', $id),
-                               bigintval($level),
-                               postRequestElement('points', $id),
-                               postRequestElement('infos', $id),
-                               $id
-                       ), __FILE__, __LINE__);
+                       SQL_QUERY_ESC("UPDATE
+       `{?_MYSQL_PREFIX?}_rallye_prices`
+SET
+       `rallye_id`=%s,
+       `price_level`=%d,
+       `points`=%s,
+       `info`='%s'
+WHERE
+       `id`=%s
+LIMIT 1",
+                               array(
+                                       postRequestElement('rallye_id', $id),
+                                       bigintval($level),
+                                       postRequestElement('points', $id),
+                                       postRequestElement('infos', $id),
+                                       $id
+                               ), __FILE__, __LINE__);
                }
 
                // Output message
@@ -109,8 +117,7 @@ VALUES ('%s','%s','%s','%s')",
 
        if (isPostRequestElementSet('edit')) {
                // Check if at last one line is selected
-               $SEL = countPostSelection();
-               if ($SEL > 0) {
+               if (countPostSelection() > 0) {
                        // Make selected editable
                        $OUT = ''; $SW = 2;
                        foreach (postRequestElement('sel') as $id => $sel) {
@@ -124,7 +131,7 @@ VALUES ('%s','%s','%s','%s')",
                                $content = array(
                                        'sw'      => $SW,
                                        'id'      => $id,
-                                       'rallyes' => generateOptionList("rallye_data", 'id', "title", $rallye),
+                                       'rallyes' => generateOptionList('rallye_data', 'id', 'title', $rallye),
                                        'level'   => $level,
                                        'points'  => $points,
                                        'infos'   => $infos,
@@ -148,13 +155,12 @@ VALUES ('%s','%s','%s','%s')",
                }
        } elseif (isPostRequestElementSet('del')) {
                // Check if at last one line is selected
-               $SEL = countPostSelection();
-               if ($SEL > 0) {
+               if (countPostSelection() > 0) {
                        // List all prices
                        $OUT = ''; $SW = 2;
                        foreach (postRequestElement('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__);
                                list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
                                SQL_FREERESULT($result);