X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=b78c7d684f697b26574ff91e901c368d895c486a;hb=0ddf8f6c578aa2c1ff1db9fb8eb0b93a1e247b73;hp=ce08c0b4c845d1f1d8bae7a664637b8bb85bde99;hpb=18e32f1a8971b18bace4f051094acf27800bd7d9;p=mailer.git diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index ce08c0b4c8..b78c7d684f 100644 --- a/inc/modules/admin/what-config_rallye_prices.php +++ b/inc/modules/admin/what-config_rallye_prices.php @@ -14,8 +14,6 @@ * $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 * @@ -48,33 +46,36 @@ addMenuDescription('admin', __FILE__); if (isGetRequestParameterSet('rallye')) { // Price submitted? if (isFormSent('add')) { - if ((isPostRequestParameterSet(('level'))) && ((isPostRequestParameterSet('points')) || (isPostRequestParameterSet(('info'))))) { + if ((isPostRequestParameterSet('level')) && ((isPostRequestParameterSet('points')) || (isPostRequestParameterSet('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__); if (SQL_HASZERONUMS($result)) { // 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')", + SQL_QUERY_ESC("INSERT INTO + `{?_MYSQL_PREFIX?}_rallye_prices` +(`rallye_id`, `price_level`, `points`, `info`) + VALUES +(%s, %s, '%s', '%s')", array( bigintval(getRequestParameter('rallye')), bigintval(postRequestParameter('level')), postRequestParameter('points'), postRequestParameter('info') ), __FILE__, __LINE__); - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_PRICE_LEVEL_SAVED')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_PRICE_LEVEL_SAVED--}'); } else { // Free memory SQL_FREERESULT($result); // Price level found! - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_PRICE_ALREADY_FOUND')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_PRICE_ALREADY_FOUND--}'); } } } elseif (isFormSent('remove')) { // Check if at last one line is selected - if (countPostSelection() > 0) { + if (ifPostContainsSelections()) { // Delete selected entries foreach (postRequestParameter('sel') as $id => $sel) { SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1", @@ -82,9 +83,9 @@ VALUES ('%s','%s','%s','%s')", } // 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 (isFormSent('change')) { // Change entries @@ -113,35 +114,29 @@ LIMIT 1", } // Output message - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_CHANGED')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_CHANGED--}'); } if (isFormSent('edit')) { // Check if at last one line is selected - if (countPostSelection() > 0) { + if (ifPostContainsSelections()) { // Make selected editable - $OUT = ''; $SW = 2; + $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", + $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); + $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 @@ -154,32 +149,20 @@ LIMIT 1", $content = '{--RALLYE_NO_PRICES_SELECTED_1--}{--RALLYE_NO_PRICES_SELECTED_2--}{--RALLYE_NO_PRICES_SELECTED_3--}'; loadTemplate('admin_settings_saved', false, $content); } - } elseif (isFormSent('del')) { + } elseif (isFormSent('delete')) { // Check if at last one line is selected - if (countPostSelection() > 0) { + if (ifPostContainsSelections()) { // List all prices - $OUT = ''; $SW = 2; + $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); + $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; @@ -198,26 +181,12 @@ LIMIT 1", $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) { + 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 @@ -250,17 +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)) { // Prepare data for the row template $content = array( - 'sw' => $SW, 'id' => $content['id'], 'title' => $content['title'], 'admin_id' => $content['admin_id'], - 'admin_link' => generateAdminLink($content['admin_id']), 'login' => $content['login'], 'start' => generateDateTime($content['start_time'], 3), 'end' => generateDateTime($content['end_time'], 3), @@ -268,7 +235,6 @@ ORDER BY // Load row template and switch color $OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content); - $SW = 3 - $SW; } // END - while // Free memory @@ -278,7 +244,7 @@ ORDER BY loadTemplate('admin_list_rallye_prices', false, $OUT); } else { // No rallyes setup so far - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_NO_RALLYES_SETUP')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SETUP--}'); } }