]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-config_rallye_prices.php
Extension ext-earning introduced (unfinished), renamings:
[mailer.git] / inc / modules / admin / what-config_rallye_prices.php
index 693e7f057c0254ed3dfac9e3cbbac11ebd73b6c2..486411ae38b0af0b12c239266ac25fb9d40f0f38 100644 (file)
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -43,55 +41,55 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 } // END - if
 
 // Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
 
-if (isGetRequestParameterSet('rallye')) {
+if (isGetRequestElementSet('rallye')) {
        // Price submitted?
        if (isFormSent('add')) {
-               if ((isPostRequestParameterSet(('level'))) && ((isPostRequestParameterSet('points')) || (isPostRequestParameterSet(('info'))))) {
+               if ((isPostRequestElementSet('level')) && ((isPostRequestElementSet('points')) || (isPostRequestElementSet('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(getRequestParameter('rallye')), bigintval(postRequestParameter('level'))), __FILE__, __LINE__);
+                       array(bigintval(getRequestElement('rallye')), bigintval(postRequestElement('level'))), __FILE__, __LINE__);
 
                        if (SQL_HASZERONUMS($result)) {
                                // 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(
-                                       bigintval(getRequestParameter('rallye')),
-                                       bigintval(postRequestParameter('level')),
-                                       postRequestParameter('points'),
-                                       postRequestParameter('info')
+                                       bigintval(getRequestElement('rallye')),
+                                       bigintval(postRequestElement('level')),
+                                       postRequestElement('points'),
+                                       postRequestElement('info')
                                ), __FILE__, __LINE__);
-                               loadTemplate('admin_settings_saved', false, '{--RALLYE_PRICE_LEVEL_SAVED--}');
+                               displayMessage('{--RALLYE_PRICE_LEVEL_SAVED--}');
                        } else {
                                // Free memory
                                SQL_FREERESULT($result);
 
-                               // Price level found!
-                               loadTemplate('admin_settings_saved', false, '{--RALLYE_PRICE_ALREADY_FOUND--}');
+                               // Price level found
+                               displayMessage('{--RALLYE_PRICE_ALREADY_FOUND--}');
                        }
                }
-       } elseif (isFormSent('remove')) {
+       } elseif (isFormSent('do_delete')) {
                // Check if at last one line is selected
-               if (countPostSelection() > 0) {
+               if (ifPostContainsSelections()) {
                        // Delete selected entries
-                       foreach (postRequestParameter('sel') as $id => $sel) {
+                       foreach (postRequestElement('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__);
                        } // END - foreach
 
                        // Output message
-                       loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_DELETED--}');
+                       displayMessage('{--RALLYE_ENTRIES_DELETED--}');
                } else {
-                       loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_NOT_DELETED--}');
+                       displayMessage('{--RALLYE_ENTRIES_NOT_DELETED--}');
                }
-       } elseif (isFormSent('change')) {
+       } elseif (isFormSent('do_edit')) {
                // Change entries
-               foreach (postRequestParameter('level') as $id => $level) {
+               foreach (postRequestElement('level') as $id => $level) {
                        // Secure id
                        $id = bigintval($id);
 
@@ -107,26 +105,26 @@ WHERE
        `id`=%s
 LIMIT 1",
                                array(
-                                       postRequestParameter('rallye_id', $id),
+                                       postRequestElement('rallye_id', $id),
                                        bigintval($level),
-                                       postRequestParameter('points', $id),
-                                       postRequestParameter('infos', $id),
+                                       postRequestElement('points', $id),
+                                       postRequestElement('infos', $id),
                                        $id
                                ), __FILE__, __LINE__);
                }
 
                // Output message
-               loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_CHANGED--}');
+               displayMessage('{--RALLYE_ENTRIES_CHANGED--}');
        }
 
        if (isFormSent('edit')) {
                // Check if at last one line is selected
-               if (countPostSelection() > 0) {
+               if (ifPostContainsSelections()) {
                        // Make selected editable
                        $OUT = '';
-                       foreach (postRequestParameter('sel') as $id => $sel) {
+                       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__);
                                $content = SQL_FETCHARRAY($result);
                                SQL_FREERESULT($result);
@@ -142,23 +140,23 @@ LIMIT 1",
                        $content['rows'] = $OUT;
 
                        // Prepare data for the main template
-                       $content['rallye'] = getRequestParameter('rallye');
+                       $content['rallye'] = getRequestElement('rallye');
 
                        // Load main template
                        loadTemplate('admin_config_rallye_edit', false, $content);
                } else {
                        // Nothing selected
-                       $content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestParameter('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}';
-                       loadTemplate('admin_settings_saved', false, $content);
+                       $content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestElement('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}';
+                       displayMessage($content);
                }
-       } elseif (isFormSent('del')) {
+       } elseif (isFormSent('delete')) {
                // Check if at last one line is selected
-               if (countPostSelection() > 0) {
+               if (ifPostContainsSelections()) {
                        // List all prices
                        $OUT = '';
-                       foreach (postRequestParameter('sel') as $id => $sel) {
+                       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__);
                                $content = SQL_FETCHARRAY($result);
                                SQL_FREERESULT($result);
@@ -169,21 +167,21 @@ LIMIT 1",
                        $content['rows'] = $OUT;
 
                        // Prepare data for the main template
-                       $content['rallye'] = getRequestParameter('rallye');
+                       $content['rallye'] = getRequestElement('rallye');
 
                        // Load main template
                        loadTemplate('admin_config_rallye_del', false, $content);
                } else {
                        // Nothing selected
-                       $content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestParameter('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}';
-                       loadTemplate('admin_settings_saved', false, $content);
+                       $content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestElement('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--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__);
+               $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(getRequestElement('rallye'))), __FILE__, __LINE__);
 
-               if (SQL_NUMROWS($result) > 0) {
+               if (!SQL_HASZERONUMS($result)) {
                        // Load all prices for the selected rallye
                        $OUT = '';
                        while ($content = SQL_FETCHARRAY($result)) {
@@ -198,7 +196,7 @@ LIMIT 1",
                        $content['rows'] = $OUT;
 
                        // Prepare data for the main template
-                       $content['rallye'] = getRequestParameter('rallye');
+                       $content['rallye'] = getRequestElement('rallye');
 
                        // Load main template
                        loadTemplate('admin_config_rallye_prices', false, $content);
@@ -207,7 +205,7 @@ LIMIT 1",
 
        // Add form for adding new price level
        if (!isFormSent('edit')) {
-               loadTemplate('admin_add_rallye_prices', false, getRequestParameter('rallye'));
+               loadTemplate('admin_add_rallye_prices', false, getRequestElement('rallye'));
        } // END - if
 } else {
        // No rallye selected so display all available without prices
@@ -221,19 +219,14 @@ ON
        d.admin_id=a.id
 ORDER BY
        d.start_time DESC", __FILE__, __LINE__);
-       if (SQL_NUMROWS($result) > 0) {
+       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),
-                       );
+                       // @TODO rename: start->start_time, end->end_time
+                       $content['start'] = generateDateTime($content['start_time'], '3');
+                       $content['end']   = generateDateTime($content['end_time']  , '3');
 
                        // Load row template and switch color
                        $OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content);
@@ -246,7 +239,7 @@ ORDER BY
                loadTemplate('admin_list_rallye_prices', false, $OUT);
        } else {
                // No rallyes setup so far
-               loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SETUP--}');
+               displayMessage('{--RALLYE_NO_RALLYES_SETUP--}');
        }
 }