X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=5f90d77c1d21d66be3e61d265a945313a57764eb;hb=cca98f57dff720b174d21d071cee8303462485d7;hp=effc1b8c72885a342de235389fb8b4d54e193616;hpb=9270eabb4c34f6fe04d56e7e702cf000849358d3;p=mailer.git

diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php
index effc1b8c72..5f90d77c1d 100644
--- a/inc/modules/admin/what-email_details.php
+++ b/inc/modules/admin/what-email_details.php
@@ -53,7 +53,7 @@ ADD_DESCR("admin", __FILE__);
 // Normal mails ordered by your members
 //              0     1       2       3       4           5          6          7       8        9          10
 $SQL = "SELECT id, sender, subject, text, receivers, payment_id, data_type, timestamp, url, target_send, cat_id
-FROM "._MYSQL_PREFIX."_pool
+FROM `{!MYSQL_PREFIX!}_pool`
 WHERE data_type IN('ADMIN','TEMP','NEW','ACTIVE')
 ORDER BY timestamp DESC";
 
@@ -64,7 +64,7 @@ if (!empty($_GET['mid'])) {
 	// Only a specific mail shall be displayed
 	//              0     1       2       3       4           5          6          7       8        9          10
 	$SQL = "SELECT id, sender, subject, text, receivers, payment_id, data_type, timestamp, url, target_send, cat_id
-	 FROM "._MYSQL_PREFIX."_pool
+	 FROM `{!MYSQL_PREFIX!}_pool`
 	 WHERE id='".bigintval($_GET['mid'])."'
 	 LIMIT 1";
 	$WHO = MAIL_ID.": ".$_GET['mid'];
@@ -72,9 +72,9 @@ if (!empty($_GET['mid'])) {
 	// All mails by a specific member shall be displayed
 	//              0     1       2       3       4           5          6          7       8        9          10
 	$SQL = "SELECT id, sender, subject, text, receivers, payment_id, data_type, timestamp, url, target_send, cat_id
-	 FROM "._MYSQL_PREFIX."_pool
-	 WHERE sender='".bigintval($_GET['u_id'])."'
-	 ORDER by timestamp DESC";
+FROM `{!MYSQL_PREFIX!}_pool`
+WHERE sender='".bigintval($_GET['u_id'])."'
+ORDER by timestamp DESC";
 	$WHO = USER_ID.": ".$_GET['u_id'];
 }
 
@@ -82,9 +82,9 @@ if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) {
 	// Bonus mails sent by you
 	//               0     1       2        3        4      5       6          7       8      9         10          11        12
 	$SQL2 = "SELECT id, subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, clicks
-	FROM "._MYSQL_PREFIX."_bonus
-	WHERE is_notify='N'
-	ORDER BY timestamp DESC";
+FROM `{!MYSQL_PREFIX!}_bonus`
+WHERE is_notify='N'
+ORDER BY timestamp DESC";
 
 	// Check for maximum pages
 	$result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__);
@@ -125,7 +125,7 @@ if (SQL_NUMROWS($result_list) > 0) {
 	// Walk through all entries
 	while ($pool = SQL_FETCHARRAY($result_list)) {
 		// Unconfirmed mails and sent mails
-		$result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1",
+		$result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM `{!MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
 		 array(bigintval($pool['id'])), __FILE__, __LINE__);
 		list($pool['sent_email'], $pool['clicks']) = SQL_FETCHROW($result_uncon);
 		SQL_FREERESULT($result_uncon);
@@ -134,7 +134,7 @@ if (SQL_NUMROWS($result_list) > 0) {
 		$pool['unconfirmed'] = $pool['sent_email'] - $pool['clicks'];
 		if ($pool['unconfirmed'] > 0) {
 			// Add link to list_unconfirmed what-file
-			$pool['unconfirmed'] = "<STRONG><A href=\"".URL."/modules.php?module=admin&amp;what=list_unconfirmed&amp;mid=".$pool['id']."\">".$pool['unconfirmed']."</A></STRONG>";
+			$pool['unconfirmed'] = "<strong><a href=\"".URL."/modules.php?module=admin&amp;what=list_unconfirmed&amp;mid=".$pool['id']."\">".$pool['unconfirmed']."</a></strong>";
 		} elseif ($pool['unconfirmed'] < 0) {
 			// Sometimes rarely displayed minus values will be "fixed" to zero
 			$pool['unconfirmed'] = 0;
@@ -193,7 +193,7 @@ if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) {
 			// Add link?
 			if ($bonus['unconfirmed'] > 0) {
 				// Add link to list_unconfirmed what-file
-				$bonus['unconfirmed'] = "<STRONG><A href=\"".URL."/modules.php?module=admin&amp;what=list_unconfirmed&amp;bid=".$bonus['id']."\">".$bonus['unconfirmed']."</A></STRONG>";
+				$bonus['unconfirmed'] = "<strong><a href=\"".URL."/modules.php?module=admin&amp;what=list_unconfirmed&amp;bid=".$bonus['id']."\">".$bonus['unconfirmed']."</a></strong>";
 			} // END - if
 
 			// Prepare content