X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=90e604af84dcb6f6500dd26f795fd9d942e891a7;hb=c5173c4d66be7ec72fbf8051a2097cbb377e87a0;hp=96cefc7879cba5a11516c2b9532b939181aa2d34;hpb=951995d00ebde2284d6503c610b0c8dfa9bc8f5c;p=mailer.git diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index 96cefc7879..90e604af84 100644 --- a/inc/modules/admin/what-config_rallye_prices.php +++ b/inc/modules/admin/what-config_rallye_prices.php @@ -1,7 +1,7 @@ 0) { + if (ifPostContainsSelections()) { // Delete selected entries - foreach (postRequestElement('sel') as $id => $sel) { + foreach (postRequestParameter('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__); + } // END - foreach // Output message - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_DELETED')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_DELETED--}'); } else { - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_NOT_DELETED')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_NOT_DELETED--}'); } - } elseif (isPostRequestElementSet('change')) { + } elseif (isFormSent('change')) { // Change entries - foreach (postRequestElement('level') as $id => $level) { + 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`='%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`=%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 - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_CHANGED')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_CHANGED--}'); } - if (isPostRequestElementSet('edit')) { + if (isFormSent('edit')) { // Check if at last one line is selected - $SEL = countPostSelection(); - if ($SEL > 0) { + if (ifPostContainsSelections()) { // Make selected editable - $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $id => $sel) { + $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__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); + $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); - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'rallyes' => generateOptionList("rallye_data", 'id', "title", $rallye), - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); + // 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); - $SW = 3 - $SW; - } + } // END - foreach + + // Remember row content $content['rows'] = $OUT; // Prepare data for the main template - $content['rallye'] = getRequestElement('rallye'); + $content['rallye'] = getRequestParameter('rallye'); // Load main template loadTemplate('admin_config_rallye_edit', false, $content); } else { // Nothing selected - $content = sprintf(getMessage('RALLYE_NO_PRICES_SELECTED'), "", ""); + $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}'; loadTemplate('admin_settings_saved', false, $content); } - } elseif (isPostRequestElementSet('del')) { + } elseif (isFormSent('delete')) { // Check if at last one line is selected - $SEL = countPostSelection(); - if ($SEL > 0) { + if (ifPostContainsSelections()) { // List all prices - $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $id => $sel) { + $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__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); + $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); - if (empty($infos)) $infos = '---'; - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); - // Load row template and switch color $OUT .= loadTemplate('admin_config_rallye_del_row', true, $content); - $SW = 3 - $SW; - } + } // END - foreach $content['rows'] = $OUT; // Prepare data for the main template - $content['rallye'] = getRequestElement('rallye'); + $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--}"; + $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}'; loadTemplate('admin_settings_saved', false, $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(getRequestElement('rallye'))), __FILE__, __LINE__); + array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Load all prices for the selected rallye - $OUT = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { - // Fix empty info - if (empty($content['info'])) $content['info'] = '---'; - - // Prepare data for the row template - // @TODO Rewritings: level->price_level, infos->info in template - $content = array( - 'sw' => $SW, - 'id' => $content['id'], - 'level' => $content['price_level'], - 'points' => $content['points'], - 'infos' => $content['info'], - ); - // Load row template and switch color $OUT .= loadTemplate('admin_config_rallye_prices_row', true, $content); - $SW = 3 - $SW; } // END - while // Free memory @@ -220,17 +196,17 @@ VALUES ('%s','%s','%s','%s')", $content['rows'] = $OUT; // Prepare data for the main template - $content['rallye'] = getRequestElement('rallye'); + $content['rallye'] = getRequestParameter('rallye'); // Load main template loadTemplate('admin_config_rallye_prices', false, $content); - } + } // END - if } // Add form for adding new price level - if (!isPostRequestElementSet('edit')) { - loadTemplate('admin_add_rallye_prices', false, getRequestElement('rallye')); - } + 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 @@ -243,21 +219,15 @@ 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 = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { - $select = ""; - if ($content['is_active'] == 'Y') $select = "