Next wave of lesser getMessage() usage and more EL

[mailer.git] / inc / modules / admin / what-email_details.php

diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php
index 14f7e44c506aef9eb95a1b4165e87e6e3f589dc0..c761546c94d512b27e7dfaad86de1d683ced90e1 100644 (file)
--- a/inc/modules/admin/what-email_details.php
+++ b/inc/modules/admin/what-email_details.php
@@ -65,30 +65,34 @@ WHERE
 ORDER BY
        `timestamp` DESC";
 
-$WHO = getMessage('_ALL');
+$WHO = '{--_ALL--}';
 $SQL2 = '';
 
 if (isGetRequestParameterSet(('mid'))) {
        // Only a specific mail shall be displayed
-       $sql = "SELECT
+       $sql = sprintf("SELECT
        `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `cat_id`
 FROM
        `{?_MYSQL_PREFIX?}_pool`
 WHERE
-       `id`='".bigintval(getRequestParameter('mid'))."'
-LIMIT 1";
-       $WHO = getMessage('MAIL_ID') . ': ' . getRequestParameter('mid');
+       `id`=%s
+LIMIT 1",
+               bigintval(getRequestParameter('mid'))
+       );
+       $WHO = '{--MAIL_ID--}' . ': ' . getRequestParameter('mid');
 } elseif (isGetRequestParameterSet('userid')) {
        // All mails by a specific member shall be displayed
-       $sql = "SELECT
+       $sql = sprintf("SELECT
        `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `cat_id`
 FROM
        `{?_MYSQL_PREFIX?}_pool`
 WHERE
-       `sender`='".bigintval(getRequestParameter('userid'))."'
+       `sender`=%s
 ORDER BY
-       `timestamp` DESC";
-       $WHO = getMessage('USER_ID') . ': ' . getRequestParameter('userid');
+       `timestamp` DESC",
+               bigintval(getRequestParameter('userid'))
+       );
+       $WHO = '{--USER_ID--}' . ': ' . getRequestParameter('userid');
 }
 
 // Init result_bonus