X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid.php;h=4778ba91301b7975b4b28e092ed4bf2b5a5c74ba;hp=b877c10f19b9d172b4a7d61ecf21268762f2c226;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hpb=cca98f57dff720b174d21d071cee8303462485d7

diff --git a/mailid.php b/mailid.php
index b877c10f19..4778ba9130 100644
--- a/mailid.php
+++ b/mailid.php
@@ -64,12 +64,12 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 		// Maybe he wants to confirm an email?
 		if ($url_mid > 0) {
 			// Normal-Mails
-			$result = SQL_QUERY_ESC("SELECT link_type FROM `{!MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND userid=%s LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND userid=%s LIMIT 1",
 				array($url_mid, $url_uid), __FILE__, __LINE__);
 			$type = "mailid"; $DATA = $url_mid;
 		} elseif ($url_bid > 0) {
 			// Bonus-Mail
-			$result = SQL_QUERY_ESC("SELECT link_type FROM `{!MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND userid=%s LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND userid=%s LIMIT 1",
 				array($url_bid, $url_uid), __FILE__, __LINE__);
 			$type = "bonusid"; $DATA = $url_bid;
 		} else {
@@ -88,7 +88,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 			{
 			case "NORMAL":
 				// Is the stats ID valid?
-				$result = SQL_QUERY_ESC("SELECT pool_id, url, subject FROM `{!MYSQL_PREFIX!}_user_stats` WHERE id=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT pool_id, url, subject FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE id=%s LIMIT 1",
 					array($url_mid), __FILE__, __LINE__);
 				break;
 
@@ -100,7 +100,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 				} // END - if
 
 				// Bonus-Mails
-				$result = SQL_QUERY_ESC("SELECT id, url, subject FROM `{!MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT id, url, subject FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1",
 					array($url_bid), __FILE__, __LINE__);
 				break;
 			}
@@ -116,7 +116,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 				$EXTRA_TITLE = COMPILE_CODE($EXTRA_TITLE);
 
 				// Is the user's ID unlocked?
-				$result = SQL_QUERY_ESC("SELECT status, gender, surname, family FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT status, gender, surname, family FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
 					array($url_uid), __FILE__, __LINE__);
 				if (SQL_NUMROWS($result) == 1) {
 					list($status, $gender, $sname, $fname) = SQL_FETCHROW($result);
@@ -126,7 +126,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 						switch ($ltype)
 						{
 						case "NORMAL":
-							$result = SQL_QUERY_ESC("SELECT payment_id FROM `{!MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT payment_id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
 								array(bigintval($pool)), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1)
 							{
@@ -141,7 +141,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 							break;
 
 						case "BONUS":
-							$result = SQL_QUERY_ESC("SELECT points, time FROM `{!MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT points, time FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1",
 								array($url_bid), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1)
 							{
@@ -161,7 +161,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 						// Was that mail a valid one?
 						if ($VALID) {
 							// If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
-							if (($time == "0") && ($payment > 0)) { $URL = URL; $time = "1"; }
+							if (($time == "0") && ($payment > 0)) { $URL = constant('URL'); $time = "1"; }
 							if (($time > 0) && (($payment > 0) || ($points > 0))) {
 								// He can confirm this mail!
 								// Export data into constants for the template