X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=2164ff00dd24d381e1d412ae248f486230b2019a;hp=9b92287488d63e7995bc9d1c11cde10ecb4b9dd8;hpb=c76a064ef78992c6eab593314d51f1841f8fb266;p=mailer.git
diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index 9b92287488..f551ef47b7 100644
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -1,252 +1,3 @@
$sel) {
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- } // END - foreach
-
- // Output message
- displayMessage('{--RALLYE_ENTRIES_DELETED--}');
- } else {
- displayMessage('{--RALLYE_ENTRIES_NOT_DELETED--}');
- }
- } elseif (isFormSent('do_edit')) {
- // Change entries
- foreach (postRequestParameter('level') as $id => $level) {
- // Secure id
- $id = bigintval($id);
-
- // Update entry
- 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(
- postRequestParameter('rallye_id', $id),
- bigintval($level),
- postRequestParameter('points', $id),
- postRequestParameter('infos', $id),
- $id
- ), __FILE__, __LINE__);
- }
-
- // Output message
- displayMessage('{--RALLYE_ENTRIES_CHANGED--}');
- }
-
- if (isFormSent('edit')) {
- // Check if at last one line is selected
- if (ifPostContainsSelections()) {
- // Make selected editable
- $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",
- array(bigintval($id)), __FILE__, __LINE__);
- $content = SQL_FETCHARRAY($result);
- SQL_FREERESULT($result);
-
- // Add more content
- $content['rallye_content'] = generateOptionList('rallye_data', 'id', 'title', $content['rallye_id']);
-
- // Load row template and switch color
- $OUT .= loadTemplate('admin_config_rallye_edit_row', true, $content);
- } // END - foreach
-
- // Remember row content
- $content['rows'] = $OUT;
-
- // Prepare data for the main template
- $content['rallye'] = getRequestParameter('rallye');
-
- // Load main template
- loadTemplate('admin_config_rallye_edit', false, $content);
- } else {
- // Nothing selected
- $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}';
- displayMessage($content);
- }
- } elseif (isFormSent('delete')) {
- // Check if at last one line is selected
- if (ifPostContainsSelections()) {
- // List all prices
- $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",
- array(bigintval($id)), __FILE__, __LINE__);
- $content = SQL_FETCHARRAY($result);
- SQL_FREERESULT($result);
-
- // Load row template and switch color
- $OUT .= loadTemplate('admin_config_rallye_del_row', true, $content);
- } // END - foreach
- $content['rows'] = $OUT;
-
- // Prepare data for the main template
- $content['rallye'] = getRequestParameter('rallye');
-
- // Load main template
- loadTemplate('admin_config_rallye_del', false, $content);
- } else {
- // Nothing selected
- $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}';
- displayMessage($content);
- }
- } 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",
- array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__);
-
- if (!SQL_HASZERONUMS($result)) {
- // Load all prices for the selected rallye
- $OUT = '';
- while ($content = SQL_FETCHARRAY($result)) {
- // Load row template and switch color
- $OUT .= loadTemplate('admin_config_rallye_prices_row', true, $content);
- } // END - while
-
- // Free memory
- SQL_FREERESULT($result);
-
- // @TODO Rewrite these two constants
- $content['rows'] = $OUT;
-
- // Prepare data for the main template
- $content['rallye'] = getRequestParameter('rallye');
-
- // Load main template
- loadTemplate('admin_config_rallye_prices', false, $content);
- } // END - if
- }
-
- // Add form for adding new price level
- if (!isFormSent('edit')) {
- loadTemplate('admin_add_rallye_prices', false, getRequestParameter('rallye'));
- } // END - if
-} else {
- // No rallye selected so display all available without prices
- $result = SQL_QUERY("SELECT
- d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active
-FROM
- `{?_MYSQL_PREFIX?}_rallye_data` AS d
-LEFT JOIN
- `{?_MYSQL_PREFIX?}_admins` AS a
-ON
- d.admin_id=a.id
-ORDER BY
- d.start_time DESC", __FILE__, __LINE__);
- if (!SQL_HASZERONUMS($result)) {
- // List found rallyes
- $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),
- );
-
- // Load row template and switch color
- $OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content);
- } // END - while
-
- // Free memory
- SQL_FREERESULT($result);
-
- // Load main template
- loadTemplate('admin_list_rallye_prices', false, $OUT);
- } else {
- // No rallyes setup so far
- displayMessage('{--RALLYE_NO_RALLYES_SETUP--}');
- }
-}
-
-// [EOF]
+// @DEPRECATED
?>