X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=ca256746fe0757a23df4064824c8fe2087ad5634;hp=91565cf9e3234575182989391ef1fc3b71645895;hpb=e1653405d28923c78b2e292125306ccf61138f24;p=mailer.git diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index 91565cf9e3..f551ef47b7 100644 --- a/inc/modules/admin/what-config_rallye_prices.php +++ b/inc/modules/admin/what-config_rallye_prices.php @@ -1,299 +1,3 @@ 0) - { - // Delete selected entries - foreach ($_POST['sel'] as $id=>$sel) - { - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - - // Output message - LOAD_TEMPLATE ("admin_settings_saved", false, RALLYE_ENTRIES_DELETED); - } - else - { - LOAD_TEMPLATE ("admin_settings_saved", false, RALLYE_ENTRIES_NOT_DELETED); - } - } - elseif (isset($_POST['change'])) - { - // Change entries - foreach ($_POST['level'] as $id=>$level) - { - // Secure ID - $id = bigintval($id); - - // Update entry - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_rallye_prices SET rallye_id=%d, price_level='%s', points='%s', info='%s' WHERE id=%d LIMIT 1", - array($_POST['rallye_id'][$id], bigintval($level), $_POST['points'][$id], $_POST['infos'][$id], $id), __FILE__, __LINE__); - } - - // Output message - LOAD_TEMPLATE ("admin_settings_saved", false, RALLYE_ENTRIES_CHANGED); - } - - if (isset($_POST['edit'])) - { - // Check if at last one line is selected - $SEL = SELECTION_COUNT($_POST['sel']); - if ($SEL > 0) - { - // Make selected editable - $SW = 2; $OUT = ""; - foreach ($_POST['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=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'rallyes' => ADD_OPTION_LINES("rallye_data", "id", "title", $rallye), - 'level' => $level, - 'points' => $points, - 'infos' => $infos, - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_rallye_edit_row", true, $content); - $SW = 3 - $SW; - } - define('__PRICE_ROWS', $OUT); - - // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); - - // Load main template - LOAD_TEMPLATE("admin_config_rallye_edit"); - } - else - { - // Nothing selected - $content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3; - LOAD_TEMPLATE("admin_settings_saved", false, $content); - } - } - elseif (isset($_POST['del'])) - { - // Check if at last one line is selected - $SEL = SELECTION_COUNT($_POST['sel']); - if ($SEL > 0) - { - // List all prices - $SW = 2; $OUT = ""; - foreach ($_POST['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=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($rallye, $level, $points, $infos) = SQL_FETCHROW($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 .= LOAD_TEMPLATE("admin_config_rallye_del_row", true, $content); - $SW = 3 - $SW; - } - define('__PRICE_ROWS', $OUT); - - // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); - - // Load main template - LOAD_TEMPLATE("admin_config_rallye_del"); - } - else - { - // Nothing selected - $content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3; - LOAD_TEMPLATE("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=%d ORDER BY price_level", - array(bigintval($_GET['rallye'])), __FILE__, __LINE__); - - if (SQL_NUMROWS($result) > 0) - { - // Load all prices for the selected rallye - $SW = 2; $OUT = ""; - while(list($id, $level, $points, $infos) = SQL_FETCHROW($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 .= LOAD_TEMPLATE("admin_config_rallye_prices_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - define('__PRICE_ROWS', $OUT); - - // Prepare data for the main template - define('__RALLYE_ID', $_GET['rallye']); - - // Load main template - LOAD_TEMPLATE("admin_config_rallye_prices"); - } - } - - // Add form for adding new price level - if (empty($_POST['edit'])) - { - LOAD_TEMPLATE("admin_add_rallye_prices", false, $_GET['rallye']); - } -} - 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, "._MYSQL_PREFIX."_admins AS a -WHERE d.admin_id=a.id ORDER BY start_time DESC", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { - // List found rallyes - $SW = 2; $OUT = ""; - while (list($id, $aid, $start, $end, $title, $alogin, $active) = SQL_FETCHROW($result)) - { - $select = ""; - if ($active == 'Y') $select = "".$id.""; - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'select' => $select, - 'title' => $title, - 'aid' => $aid, - 'email_link' => CREATE_EMAIL_LINK($aid), - 'alogin' => $alogin, - 'start' => MAKE_DATETIME($start, "3"), - 'end' => MAKE_DATETIME($end, "3"), - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_list_rallye_prices_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - define('__RALLYE_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_list_rallye_prices"); - } - else - { - // No rallyes setup so far - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_NO_RALLYES_SETUP); - } -} -// +// @DEPRECATED ?>