A lot has been rewritten, ext-teams added, ext-forced continued:
[mailer.git] / inc / modules / admin / what-config_rallye_prices.php
index 7b4fb0a4e371de935403dd41e58c1b9bd35aea33..1c90f6a42086bfaf7873800912ab92d96a21bcf8 100644 (file)
@@ -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(
@@ -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)) {