X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=33f53536c65ea0fcf0828c98fe5ed92a4187020e;hb=ab92fb7241d00636b0eb940f147449758820cba1;hp=fea6546b9bfc0d46df2ec5142cd73c39c30b123a;hpb=747c49b9f46a3d7d1d881c9e1c273ecf107f8d8b;p=mailer.git

diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php
index fea6546b9b..33f53536c6 100644
--- a/inc/modules/admin/what-config_rallye_prices.php
+++ b/inc/modules/admin/what-config_rallye_prices.php
@@ -48,13 +48,13 @@ if (!empty($_GET['rallye']))
 		if ((!empty($_POST['level'])) && ((!empty($_POST['points'])) || (!empty($_POST['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($_GET['rallye']), bigintval($_POST['level'])), __FILE__, __LINE__);
 
 			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)
+				SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_rallye_prices` (rallye_id, price_level, points, info)
 VALUES ('%s','%s','%s','%s')",
  array(
 	bigintval($_GET['rallye']),
@@ -79,7 +79,7 @@ VALUES ('%s','%s','%s','%s')",
 		if ($SEL > 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",
+				SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE id=%s LIMIT 1",
 					array(bigintval($id)), __FILE__, __LINE__);
 			}
 
@@ -95,7 +95,7 @@ VALUES ('%s','%s','%s','%s')",
 			$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",
+			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__);
 		}
 
@@ -113,7 +113,7 @@ VALUES ('%s','%s','%s','%s')",
 			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",
+				$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);
@@ -143,7 +143,7 @@ VALUES ('%s','%s','%s','%s')",
 		 else
 		{
 			// Nothing selected
-			$content = RALLYE_NO_PRICES_SELECTED_1."<a href=\"".URL."/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".$_GET['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=".$_GET['rallye']."\">".RALLYE_NO_PRICES_SELECTED_2."</a>".RALLYE_NO_PRICES_SELECTED_3;
 			LOAD_TEMPLATE("admin_settings_saved", false, $content);
 		}
 	}
@@ -158,7 +158,7 @@ VALUES ('%s','%s','%s','%s')",
 			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",
+				$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);
@@ -189,21 +189,21 @@ VALUES ('%s','%s','%s','%s')",
 		 else
 		{
 			// Nothing selected
-			$content = RALLYE_NO_PRICES_SELECTED_1."<a href=\"".URL."/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".$_GET['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=".$_GET['rallye']."\">".RALLYE_NO_PRICES_SELECTED_2."</a>".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",
+		$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))
+			while (list($id, $level, $points, $infos) = SQL_FETCHROW($result))
 			{
 				if (empty($infos)) $infos = "---";
 
@@ -243,7 +243,7 @@ VALUES ('%s','%s','%s','%s')",
 {
 	// 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
+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)
 	{