X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=1d211e3d1081d2da97e24d9b0b46b1e748125069;hp=f21bad00b33d7e39aa4dc7eef2c6c3fbc043c6e0;hb=30ae22f62ae87c53a56baf0d134569ba91011111;hpb=dd3f996989d9fd027b007fe829ae7356f3780b37

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index f21bad00b3..1d211e3d10 100644
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 07/03/2004 *
- * ================                             Last change: 08/22/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 07/03/2004 *
+ * ===================                          Last change: 08/22/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-config_rallye_prices.php                    *
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -39,56 +40,58 @@
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!isAdmin())) {
 	die();
-}
+} // END - if
 
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
 
-if (isGetRequestElementSet('rallye')) {
+if (isGetRequestParameterSet('rallye')) {
 	// Price submitted?
-	if (isPostRequestElementSet('add')) {
-		if ((isPostRequestElementSet(('level'))) && ((isPostRequestElementSet(('points'))) || (isPostRequestElementSet(('info'))))) {
+	if (isFormSent('add')) {
+		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(getRequestElement('rallye')), bigintval(postRequestElement('level'))), __FILE__, __LINE__);
+			array(bigintval(getRequestParameter('rallye')), bigintval(postRequestParameter('level'))), __FILE__, __LINE__);
 
-			if (SQL_NUMROWS($result) == 0) {
+			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(getRequestElement('rallye')),
-					bigintval(postRequestElement('level')),
-					postRequestElement('points'),
-					postRequestElement('info')
+					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 (isPostRequestElementSet('remove')) {
+	} elseif (isFormSent('remove')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (ifPostContainsSelections()) {
 			// Delete selected entries
-			foreach (postRequestElement('sel') as $id => $sel) {
+			foreach (postRequestParameter('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__);
-			}
+					array(bigintval($id)), __FILE__, __LINE__);
+			} // 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 (isPostRequestElementSet('change')) {
+	} elseif (isFormSent('change')) {
 		// Change entries
-		foreach (postRequestElement('level') as $id => $level) {
+		foreach (postRequestParameter('level') as $id => $level) {
 			// Secure id
 			$id = bigintval($id);
 
@@ -97,129 +100,95 @@ VALUES ('%s','%s','%s','%s')",
 	`{?_MYSQL_PREFIX?}_rallye_prices`
 SET
 	`rallye_id`=%s,
-	`price_`level``='%s',
-	`points`='%s',
+	`price_level`=%d,
+	`points`=%s,
 	`info`='%s'
 WHERE
 	`id`=%s
 LIMIT 1",
 				array(
-					postRequestElement('rallye_id', $id),
+					postRequestParameter('rallye_id', $id),
 					bigintval($level),
-					postRequestElement('points', $id),
-					postRequestElement('infos', $id),
+					postRequestParameter('points', $id),
+					postRequestParameter('infos', $id),
 					$id
 				), __FILE__, __LINE__);
 		}
 
 		// Output message
-		loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ENTRIES_CHANGED'));
+		loadTemplate('admin_settings_saved', false, '{--RALLYE_ENTRIES_CHANGED--}');
 	}
 
-	if (isPostRequestElementSet('edit')) {
+	if (isFormSent('edit')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (ifPostContainsSelections()) {
 			// Make selected editable
-			$OUT = ''; $SW = 2;
-			foreach (postRequestElement('sel') as $id => $sel) {
+			$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
-			$content['rallye'] = getRequestElement('rallye');
+			$content['rallye'] = getRequestParameter('rallye');
 
 			// Load main template
 			loadTemplate('admin_config_rallye_edit', false, $content);
 		} else {
 			// Nothing selected
-			$content = sprintf(getMessage('RALLYE_NO_PRICES_SELECTED'), "<a href=\"{?URL?}/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".getRequestElement('rallye')."\">", "</a>");
+			$content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestParameter('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}';
 			loadTemplate('admin_settings_saved', false, $content);
 		}
-	} elseif (isPostRequestElementSet('del')) {
+	} elseif (isFormSent('del')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (ifPostContainsSelections()) {
 			// List all prices
-			$OUT = ''; $SW = 2;
-			foreach (postRequestElement('sel') as $id => $sel) {
+			$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;
 
 			// Prepare data for the main template
-			$content['rallye'] = getRequestElement('rallye');
+			$content['rallye'] = getRequestParameter('rallye');
 
 			// Load main template
 			loadTemplate('admin_config_rallye_del', false, $content);
 		} else {
 			// Nothing selected
-			$content = "{--RALLYE_NO_PRICES_SELECTED_1--}<a href=\"{?URL?}/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".getRequestElement('rallye')."\">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}";
+			$content = '{--RALLYE_NO_PRICES_SELECTED_1--}<a href="{%url=modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=' . getRequestParameter('rallye') . '%}">{--RALLYE_NO_PRICES_SELECTED_2--}</a>{--RALLYE_NO_PRICES_SELECTED_3--}';
 			loadTemplate('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` ASC",
-			array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
+			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
@@ -229,17 +198,17 @@ LIMIT 1",
 			$content['rows'] = $OUT;
 
 			// Prepare data for the main template
-			$content['rallye'] = getRequestElement('rallye');
+			$content['rallye'] = getRequestParameter('rallye');
 
 			// Load main template
 			loadTemplate('admin_config_rallye_prices', false, $content);
-		}
+		} // END - if
 	}
 
 	// Add form for adding new price level
-	if (!isPostRequestElementSet('edit')) {
-		loadTemplate('admin_add_rallye_prices', false, getRequestElement('rallye'));
-	}
+	if (!isFormSent('edit')) {
+		loadTemplate('admin_add_rallye_prices', false, getRequestParameter('rallye'));
+	} // END - if
 } else {
 	// No rallye selected so display all available without prices
 	$result = SQL_QUERY("SELECT
@@ -252,17 +221,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),
@@ -270,8 +237,7 @@ ORDER BY
 
 			// Load row template and switch color
 			$OUT .= loadTemplate('admin_list_rallye_prices_row', true, $content);
-			$SW = 3 - $SW;
-		}
+		} // END - while
 
 		// Free memory
 		SQL_FREERESULT($result);
@@ -280,7 +246,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--}');
 	}
 }