Fix for missing array element 'userid', see ticket #205, thanks to piter01

diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php
index 5f70cb0a83e8cfff8dd7d4332a9e5983dcc87377..fdfe3c8bc03dff42e81d8e043acbb0304ed65ac0 100644 (file)
--- a/inc/modules/admin/what-edit_emails.php
+++ b/inc/modules/admin/what-edit_emails.php
@@ -51,7 +51,7 @@ if ((isFormSent()) && (!isPostRequestParameterSet('id'))) {
 
 // Query the pool
 $result = SQL_QUERY('SELECT
 
 // Query the pool
 $result = SQL_QUERY('SELECT

-       `id`, `sender`, `subject`, `payment_id`, `cat_id`
+       `id`, `sender` AS `userid`, `subject`, `payment_id`, `cat_id`

 FROM
        `{?_MYSQL_PREFIX?}_pool`
 ORDER BY
 FROM
        `{?_MYSQL_PREFIX?}_pool`
 ORDER BY


@@ -61,7 +61,7 @@ ORDER BY
 if (!SQL_HASZERONUMS($result)) {
        if (isFormSent()) {
                // Make mail editable...
 if (!SQL_HASZERONUMS($result)) {
        if (isFormSent()) {
                // Make mail editable...

-               $result = SQL_QUERY_ESC("SELECT `id`, `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
                        array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__);
 
                // Fetch row