From ba5d5acef7f0a990271379d6344f4dce4ec50d36 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Tue, 21 Dec 2010 19:10:35 +0000
Subject: [PATCH] Fixed obsolete (?) links to category/payment

---
 inc/modules/admin/what-edit_emails.php              | 8 +++++++-
 templates/de/html/admin/admin_unlock_emails_row.tpl | 4 ++--
 2 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php
index fdfe3c8bc0..01880f1670 100644
--- a/inc/modules/admin/what-edit_emails.php
+++ b/inc/modules/admin/what-edit_emails.php
@@ -61,7 +61,13 @@ ORDER BY
 if (!SQL_HASZERONUMS($result)) {
 	if (isFormSent()) {
 		// Make mail editable...
-		$result = SQL_QUERY_ESC("SELECT `id`, `sender` AS `userid`, `subject`, `text`, `url` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT
+	`id`, `sender` AS `userid`, `subject`, `text`, `url`
+FROM
+	`{?_MYSQL_PREFIX?}_pool`
+WHERE
+	`id`=%s
+LIMIT 1",
 			array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__);
 
 		// Fetch row
diff --git a/templates/de/html/admin/admin_unlock_emails_row.tpl b/templates/de/html/admin/admin_unlock_emails_row.tpl
index f97d080f8a..2e18037fb7 100644
--- a/templates/de/html/admin/admin_unlock_emails_row.tpl
+++ b/templates/de/html/admin/admin_unlock_emails_row.tpl
@@ -14,10 +14,10 @@
 		<a href="{%pipe,generateFrametesterUrl=$content[url]%}" target="_blank">{--ADMIN_TEST_URL--}</a>
 	</td>
 	<td class="{%template,ColorSwitch%} top right" align="center">
-		<span class="notice" title="{%pipe,getCategory=$content[cat_id]%}">$content[cat_link]</span>
+		<span class="notice" title="{%pipe,getCategory=$content[cat_id]%}">$content[cat_id]</span>
 	</td>
 	<td class="{%template,ColorSwitch%} top right" align="center">
-		<span class="notice" title="{%pipe,getPaymentTitlePrice=$content[payment_id]%}">$content[pay_link]</span>
+		<span class="notice" title="{%pipe,getPaymentTitlePrice=$content[payment_id]%}">$content[payment_id]</span>
 	</td>
 	<td class="{%template,ColorSwitch%} top right" align="center">
 		$content[timestamp]
-- 
2.39.2