From dd3f996989d9fd027b007fe829ae7356f3780b37 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Thu, 5 Nov 2009 14:20:29 +0000
Subject: [PATCH 1/1] SQL error fixed, query optimized

---
 .../admin/what-config_rallye_prices.php       | 29 ++++++++++++-------
 1 file changed, 19 insertions(+), 10 deletions(-)

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index 5d7453ff5e..f21bad00b3 100644
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -93,14 +93,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``='%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__);
 		}
 
 		// Output message
@@ -124,7 +133,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,
@@ -154,7 +163,7 @@ VALUES ('%s','%s','%s','%s')",
 			$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);
-- 
2.30.2