X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=86b94a69d333ef7645da324985bb66676ebda158;hp=ddb605da4974e3274ba793bb252cefd1ced84f9c;hb=57227d33e870ec5cd271209c4a978a52b45c2dd6;hpb=9554a8d81c0b81430503ef8156748ffbb61daa00 diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index ddb605da49..86b94a69d3 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 (countPostSelection() > 0) { // 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')); } else { loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_NOT_DELETED')); } - } elseif (isPostRequestElementSet('change')) { + } elseif (isPostRequestParameterSet('change')) { // Change entries - foreach (postRequestElement('level') as $id => $level) { - // Secure ID + 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')); } - if (isPostRequestElementSet('edit')) { + if (isPostRequestParameterSet('edit')) { // Check if at last one line is selected - $SEL = countPostSelection(); - if ($SEL > 0) { + if (countPostSelection() > 0) { // Make selected editable $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $id => $sel) { + 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__); + array(bigintval($id)), __FILE__, __LINE__); list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -124,7 +131,7 @@ VALUES ('%s','%s','%s','%s')", $content = array( 'sw' => $SW, 'id' => $id, - 'rallyes' => generateOptionList("rallye_data", 'id', "title", $rallye), + 'rallyes' => generateOptionList('rallye_data', 'id', 'title', $rallye), 'level' => $level, 'points' => $points, 'infos' => $infos, @@ -133,29 +140,28 @@ VALUES ('%s','%s','%s','%s')", // Load row template and switch color $OUT .= loadTemplate('admin_config_rallye_edit_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_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 (isPostRequestParameterSet('del')) { // Check if at last one line is selected - $SEL = countPostSelection(); - if ($SEL > 0) { + if (countPostSelection() > 0) { // List all prices $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $id => $sel) { + 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__); + $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); SQL_FREERESULT($result); @@ -173,23 +179,23 @@ VALUES ('%s','%s','%s','%s')", // 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__); + $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_NUMROWS($result) > 0) { // Load all prices for the selected rallye @@ -220,17 +226,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 (!isPostRequestParameterSet('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 @@ -247,17 +253,13 @@ ORDER BY // List found rallyes $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { - $select = ""; - if ($content['is_active'] == 'Y') $select = "
".$content['id']."
"; - // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $content['id'], - 'select' => $select, 'title' => $content['title'], 'admin_id' => $content['admin_id'], - 'email_link' => generateEmailLink($content['admin_id']), + 'admin_link' => generateAdminLink($content['admin_id']), 'login' => $content['login'], 'start' => generateDateTime($content['start_time'], 3), 'end' => generateDateTime($content['end_time'], 3), @@ -266,7 +268,7 @@ ORDER BY // Load row template and switch color $OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content); $SW = 3 - $SW; - } + } // END - while // Free memory SQL_FREERESULT($result);