X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-del_email.php;h=0e98689ede7330a8e340a42fa0cf8f17967f270c;hb=e5dde615db05fb62ebe91bd1c030f40c9b91fe17;hp=11de7d3bb749c8a2020d6488a263122798bddd20;hpb=1c4e78c5d68b97b82a3b930aa6db1e6df188f653;p=mailer.git

diff --git a/inc/modules/admin/what-del_email.php b/inc/modules/admin/what-del_email.php
index 11de7d3bb7..0e98689ede 100644
--- a/inc/modules/admin/what-del_email.php
+++ b/inc/modules/admin/what-del_email.php
@@ -48,32 +48,27 @@ $cnt = '0';
 
 if (isGetRequestParameterSet('mid')) {
 	// Load email data
-	$result = SQL_QUERY_ESC("SELECT `id`, `sender`, `subject`, `url`, `timestamp`, `payment_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
+	$result = SQL_QUERY_ESC("SELECT `id`, `sender`, `subject`, `url`, `timestamp`, `cat_id`, `payment_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
 		array(bigintval(getRequestParameter('mid'))), __FILE__, __LINE__);
 
 	// Delete mail only once
 	if (SQL_NUMROWS($result) == 1) {
 		// Load data
-		list ($id, $sender, $subject, $url, $timestamp, $payId) = SQL_FETCHROW($result);
-		SQL_FREERESULT($result);
+		$content = SQL_FETCHARRAY($result);
 
 		// Get points we shall pay back per mail
-		$price = getPaymentPoints($payId, 'price');
+		// @TODO Unused: $price = getPaymentPoints($content['payment_id'], 'price');
+		// @TODO Unused: cat_id, payment_id
 
 		// Prepare data for the template
-		$content['id']        = $id;
-		$content['sender']    = generateUserProfileLink($sender);
-		$content['subject']   = $subject;
-		$content['url']       = generateDerefererUrl($url);
-		$content['url_raw']   = $url;
-		$content['timestamp'] = generateDateTime($timestamp, 0);
+		$content['timestamp'] = generateDateTime($content['timestamp'], 0);
 
 		// Load template
 		loadTemplate('admin_del_email_normal', false, $content);
 
 		// Load email template and send the email away
 		$message_user = loadEmailTemplate('order-deleted', $content, $sender);
-		sendEmail($sender, getMessage('MEMBER_ORDER_DELETED'), $message_user);
+		sendEmail($sender, '{--MEMBER_ORDER_DELETED--}', $message_user);
 
 		// Fetch right stats_id from pool
 		$result_pool = SQL_QUERY_ESC("SELECT
@@ -104,7 +99,7 @@ LIMIT 1",
 			// Shall we pay the points back to the user?
 			if ($totalPoints == 0) {
 				// No points repayed!
-				loadTemplate('admin_settings_saved', false, getMessage('ADMIN_NO_POINTS_REPAYED'));
+				loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_POINTS_REPAYED--}');
 			} elseif (getConfig('repay_deleted_mails') != 'SHRED') {
 				//* DEBUG: */ debugOutput($stats_id.':'.$totalPoints.'/'.$links.'/'.$price);
 				// Shall we payback to user or jackpot?
@@ -155,15 +150,18 @@ LIMIT 1",
 		outputHtml(getMaskedMessage('ADMIN_DELETED_MAILS_COUNT', $cnt));
 	} else {
 		// Mail already deleted!
-		loadTemplate('admin_settings_saved', false, getMessage('ADMIN_NORMAL_MAIL_ALREADY_DELETED'));
+		loadTemplate('admin_settings_saved', false, '{--ADMIN_NORMAL_MAIL_ALREADY_DELETED--}');
 	}
+
+	// Free result
+	SQL_FREERESULT($result);
 } elseif (isGetRequestParameterSet('pid')) {
 	// Remove stats entries
 	SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
 		array(bigintval(getRequestParameter('pid'))), __FILE__, __LINE__);
 
 	// Output message
-	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_USER_STATS_REMOVED'));
+	loadTemplate('admin_settings_saved', false, '{--ADMIN_USER_STATS_REMOVED--}');
 } elseif ((isGetRequestParameterSet('bid')) && (isExtensionActive('bonus'))) {
 	// Load data from bonus mail
 	$result = SQL_QUERY_ESC("SELECT `id`, `subject`, `url`, `timestamp`, `mails_sent` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s",
@@ -197,7 +195,7 @@ LIMIT 1",
 		loadTemplate('admin_del_email_bonus', false, $content);
 	} else {
 		// Mail already deleted!
-		loadTemplate('admin_settings_saved', false, getMessage('ADMIN_BONUS_MAIL_ALREADY_DELETED'));
+		loadTemplate('admin_settings_saved', false, '{--ADMIN_BONUS_MAIL_ALREADY_DELETED--}');
 	}
 
 	// Free result
@@ -232,15 +230,15 @@ LIMIT 1",
 		loadTemplate('admin_del_email_notify', false, $content);
 	} else {
 		// Mail already deleted!
-		loadTemplate('admin_settings_saved', false, getMessage('ADMIN_NOTIFY_MAIL_ALREADY_DELETED'));
+		loadTemplate('admin_settings_saved', false, '{--ADMIN_NOTIFY_MAIL_ALREADY_DELETED--}');
 	}
 
 	// Free result
 	SQL_FREERESULT($result);
 } else {
 	// No mail orders fond
-	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_WRONG_CALL'));
+	loadTemplate('admin_settings_saved', false, '{--ADMIN_WRONG_CALL--}');
 }
 
-//
+// [EOF]
 ?>