0) { // Delete selected entries foreach ($_POST['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__); } // 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 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($_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=%s 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=%s 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=%s 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); } } // ?>