X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=d9a27694f23dc92b498567cb4bd787eff9d2f220;hp=68abbb0486ca146cbf8737177a33316200691a8e;hb=cca98f57dff720b174d21d071cee8303462485d7;hpb=56156f6c4392510cdbe0eb4f2ccefc23b43e2672

diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php
index 68abbb0486..d9a27694f2 100644
--- a/inc/modules/admin/what-refbanner.php
+++ b/inc/modules/admin/what-refbanner.php
@@ -59,11 +59,11 @@ if (isset($_POST['ok'])) {
 	{
 	case "add":
 		// Check if banner is already added
-		$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_refbanner WHERE url='%s' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT id FROM `{!MYSQL_PREFIX!}_refbanner` WHERE url='%s' LIMIT 1",
 			array($_POST['url']), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 0) {
 			// Add banner
-			SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_refbanner (url, alternate, visible)
+			SQL_QUERY_ESC("INSERT INTO `{!MYSQL_PREFIX!}_refbanner` (url, alternate, visible)
 VALUES ('%s','%s','%s')",
 				array($_POST['url'], $_POST['alternate'], $_POST['visible']), __FILE__, __LINE__);
 		} else {
@@ -78,7 +78,7 @@ VALUES ('%s','%s','%s')",
 			$id = bigintval($id);
 
 			// Update entry
-			SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET url='%s', alternate='%s', visible='%s' WHERE id=%s LIMIT 1",
+			SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_refbanner` SET url='%s', alternate='%s', visible='%s' WHERE id=%s LIMIT 1",
 				array($_POST['url'][$id], $_POST['alternate'][$id], $_POST['visible'], $id), __FILE__, __LINE__);
 		}
 		break;
@@ -95,7 +95,7 @@ VALUES ('%s','%s','%s')",
 	$SW = ""; $OUT = "";
 	foreach ($_POST['sel'] as $id => $sel) {
 		// Load data
-		$result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM "._MYSQL_PREFIX."_refbanner WHERE id=%s LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM `{!MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1",
 		 array(bigintval($id)), __FILE__, __LINE__);
 		list($url, $alt, $vis) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
@@ -122,13 +122,13 @@ VALUES ('%s','%s','%s')",
 	{
 		// Delete banner
 		foreach ($_POST['sel'] as $id => $sel) {
-			SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refbanner WHERE id=%s LIMIT 1",
+			SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1",
 				array(bigintval($id)), __FILE__, __LINE__);
 		}
 	}
 
 	// Referal levels
-	$result = SQL_QUERY("SELECT id, url, alternate, visible, counter, clicks FROM "._MYSQL_PREFIX."_refbanner ORDER BY url", __FILE__, __LINE__);
+	$result = SQL_QUERY("SELECT id, url, alternate, visible, counter, clicks FROM `{!MYSQL_PREFIX!}_refbanner` ORDER BY url", __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) > 0)
 	{
 		// Make referal banner editable and deletable