X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=7b73f1148b2a79b192d6053b4e5193a45ccd6883;hp=d9a27694f23dc92b498567cb4bd787eff9d2f220;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hpb=cca98f57dff720b174d21d071cee8303462485d7;ds=sidebyside

diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php
index d9a27694f2..7b73f1148b 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