X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=83e90ef5423db15c3f258fd2a072253e153b6594;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=2ad2cebeca0283ba6e12f093d719ea8a62895218;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-config_rallye_prices.php b/0.2.1/inc/modules/admin/what-config_rallye_prices.php index 2ad2cebeca..83e90ef542 100644 --- a/0.2.1/inc/modules/admin/what-config_rallye_prices.php +++ b/0.2.1/inc/modules/admin/what-config_rallye_prices.php @@ -1,299 +1,299 @@ - 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); - } -} -// -?> + 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); + } +} +// +?>