]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-config_rallye_prices.php
Old config.php is now automatically updated to new config-local.php format, several...
[mailer.git] / inc / modules / admin / what-config_rallye_prices.php
index 05af9628f26f4d65ef3990e494d59b32686e28f7..82fee1e1552249d2c7081067e72c1f9086a936b5 100644 (file)
@@ -51,18 +51,18 @@ if (REQUEST_ISSET_GET(('rallye'))) {
                if ((REQUEST_ISSET_POST(('level'))) && ((REQUEST_ISSET_POST(('points'))) || (REQUEST_ISSET_POST(('info'))))) {
                        // Submitted data is valid, but maybe we already have this price level?
                        $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s AND price_level='%s' LIMIT 1",
-                               array(bigintval(REQUEST_GET('rallye')), bigintval(REQUEST_POST('level'))), __FILE__, __LINE__);
+                       array(bigintval(REQUEST_GET('rallye')), bigintval(REQUEST_POST('level'))), __FILE__, __LINE__);
 
                        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')",
- array(
-       bigintval(REQUEST_GET('rallye')),
-       bigintval(REQUEST_POST('level')),
-       REQUEST_POST('points'),
-       REQUEST_POST('info')
-), __FILE__, __LINE__);
                              array(
+                               bigintval(REQUEST_GET('rallye')),
+                               bigintval(REQUEST_POST('level')),
+                               REQUEST_POST('points'),
+                               REQUEST_POST('info')
+                               ), __FILE__, __LINE__);
                                LOAD_TEMPLATE('admin_settings_saved', false, getMessage('RALLYE_PRICE_LEVEL_SAVED'));
                        } else {
                                // Free memory
@@ -79,7 +79,7 @@ VALUES ('%s','%s','%s','%s')",
                        // Delete selected entries
                        foreach (REQUEST_POST('sel') as $id => $sel) {
                                SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE `id`=%s LIMIT 1",
-                                       array(bigintval($id)), __FILE__, __LINE__);
+                               array(bigintval($id)), __FILE__, __LINE__);
                        }
 
                        // Output message
@@ -95,13 +95,13 @@ VALUES ('%s','%s','%s','%s')",
 
                        // 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(
-                                       REQUEST_POST('rallye_id', $id),
-                                       bigintval($level),
-                                       REQUEST_POST('points', $id]),
-                                       REQUEST_POST('infos', $id),
-                                       $id
-                               ), __FILE__, __LINE__);
+                       array(
+                       REQUEST_POST('rallye_id', $id),
+                       bigintval($level),
+                       REQUEST_POST('points', $id),
+                       REQUEST_POST('infos', $id),
+                       $id
+                       ), __FILE__, __LINE__);
                }
 
                // Output message
@@ -117,7 +117,7 @@ VALUES ('%s','%s','%s','%s')",
                        foreach (REQUEST_POST('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",
-                                       array(bigintval($id)), __FILE__, __LINE__);
+                               array(bigintval($id)), __FILE__, __LINE__);
                                list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
                                SQL_FREERESULT($result);
 
@@ -156,7 +156,7 @@ VALUES ('%s','%s','%s','%s')",
                        foreach (REQUEST_POST('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",
-                                       array(bigintval($id)), __FILE__, __LINE__);
+                               array(bigintval($id)), __FILE__, __LINE__);
                                list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
                                SQL_FREERESULT($result);
 
@@ -190,7 +190,7 @@ VALUES ('%s','%s','%s','%s')",
        } 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",
-                       array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
+               array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
 
                if (SQL_NUMROWS($result) > 0) {
                        // Load all prices for the selected rallye