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);
+ }
+}
+//
+?>