X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=40a5cf88d3f31df5dc03586e2d523bb9a87523f9;hb=c1671a3b6c02326b471916a28f4177c453871f51;hp=1e2fd625b6b89c16c93032dbfb8e8b561db772c3;hpb=dbb6aa4eaeff7c3bab27f143d881781380d43d41;p=mailer.git

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index 1e2fd625b6..40a5cf88d3 100644
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -1,6 +1,6 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 07/03/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 07/03/2004 *
  * ================                             Last change: 08/22/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
@@ -44,23 +44,23 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
 
-if (isGetRequestElementSet(('rallye'))) {
+if (isGetRequestElementSet('rallye')) {
 	// Price submitted?
 	if (isPostRequestElementSet('add')) {
 		if ((isPostRequestElementSet(('level'))) && ((isPostRequestElementSet(('points'))) || (isPostRequestElementSet(('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",
+			$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__);
 
-			if (SQL_NUMROWS($result) == 0) {
+			if (SQL_NUMROWS($result) == '0') {
 				// 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')",
 				array(
-				bigintval(getRequestElement('rallye')),
-				bigintval(postRequestElement('level')),
-				postRequestElement('points'),
-				postRequestElement('info')
+					bigintval(getRequestElement('rallye')),
+					bigintval(postRequestElement('level')),
+					postRequestElement('points'),
+					postRequestElement('info')
 				), __FILE__, __LINE__);
 				loadTemplate('admin_settings_saved', false, getMessage('RALLYE_PRICE_LEVEL_SAVED'));
 			} else {
@@ -73,8 +73,7 @@ VALUES ('%s','%s','%s','%s')",
 		}
 	} elseif (isPostRequestElementSet('remove')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (countPostSelection() > 0) {
 			// Delete selected entries
 			foreach (postRequestElement('sel') as $id => $sel) {
 				SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `id`=%s LIMIT 1",
@@ -89,18 +88,27 @@ VALUES ('%s','%s','%s','%s')",
 	} elseif (isPostRequestElementSet('change')) {
 		// Change entries
 		foreach (postRequestElement('level') as $id => $level) {
-			// Secure ID
+			// 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(
-			postRequestElement('rallye_id', $id),
-			bigintval($level),
-			postRequestElement('points', $id),
-			postRequestElement('infos', $id),
-			$id
-			), __FILE__, __LINE__);
+			SQL_QUERY_ESC("UPDATE
+	`{?_MYSQL_PREFIX?}_rallye_prices`
+SET
+	`rallye_id`=%s,
+	`price_level`=%d,
+	`points`=%s,
+	`info`='%s'
+WHERE
+	`id`=%s
+LIMIT 1",
+				array(
+					postRequestElement('rallye_id', $id),
+					bigintval($level),
+					postRequestElement('points', $id),
+					postRequestElement('infos', $id),
+					$id
+				), __FILE__, __LINE__);
 		}
 
 		// Output message
@@ -109,14 +117,13 @@ VALUES ('%s','%s','%s','%s')",
 
 	if (isPostRequestElementSet('edit')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (countPostSelection() > 0) {
 			// Make selected editable
 			$OUT = ''; $SW = 2;
 			foreach (postRequestElement('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__);
+					array(bigintval($id)), __FILE__, __LINE__);
 				list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
 				SQL_FREERESULT($result);
 
@@ -124,7 +131,7 @@ VALUES ('%s','%s','%s','%s')",
 				$content = array(
 					'sw'      => $SW,
 					'id'      => $id,
-					'rallyes' => generateOptionList("rallye_data", 'id', "title", $rallye),
+					'rallyes' => generateOptionList('rallye_data', 'id', 'title', $rallye),
 					'level'   => $level,
 					'points'  => $points,
 					'infos'   => $infos,
@@ -148,14 +155,13 @@ VALUES ('%s','%s','%s','%s')",
 		}
 	} elseif (isPostRequestElementSet('del')) {
 		// Check if at last one line is selected
-		$SEL = countPostSelection();
-		if ($SEL > 0) {
+		if (countPostSelection() > 0) {
 			// List all prices
 			$OUT = ''; $SW = 2;
 			foreach (postRequestElement('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__);
+				$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);
 
@@ -188,8 +194,8 @@ VALUES ('%s','%s','%s','%s')",
 		}
 	} 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(getRequestElement('rallye'))), __FILE__, __LINE__);
+		$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__);
 
 		if (SQL_NUMROWS($result) > 0) {
 			// Load all prices for the selected rallye
@@ -236,30 +242,25 @@ VALUES ('%s','%s','%s','%s')",
 	$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?}_rallye_data` AS d
 LEFT JOIN
 	`{?_MYSQL_PREFIX?}_admins` AS a
 ON
 	d.admin_id=a.id
 ORDER BY
-	`d.start_time` DESC", __FILE__, __LINE__);
+	d.start_time DESC", __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) > 0) {
 		// List found rallyes
 		$OUT = ''; $SW = 2;
 		while ($content = SQL_FETCHARRAY($result)) {
-			$select = "<input type=\"checkbox\" name=\"sel[".$content['id']."]\" class=\"admin_normal\" value=\"1\">";
-			if ($content['is_active'] == 'Y') $select = "<div class=\"big\">".$content['id']."</div>";
-
 			// Prepare data for the row template
-			// @TODO Rewritings: admin_id->admin_id, alogin->login in template
 			$content = array(
 				'sw'         => $SW,
 				'id'         => $content['id'],
-				'select'     => $select,
 				'title'      => $content['title'],
-				'admin_id'        => $content['admin_id'],
-				'email_link' => generateEmailLink($content['admin_id']),
-				'alogin'     => $content['login'],
+				'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),
 			);