From: Roland Häder Date: Sat, 20 Nov 2010 15:37:49 +0000 (+0000) Subject: Fix for missing array element 'userid', see ticket #205, thanks to piter01 X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=fdfe034bd27d3d4eaf75dda77e76c8555177b076;ds=sidebyside 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 5f70cb0a83..fdfe3c8bc0 100644 --- 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 - `id`, `sender`, `subject`, `payment_id`, `cat_id` + `id`, `sender` AS `userid`, `subject`, `payment_id`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` ORDER BY @@ -61,7 +61,7 @@ ORDER BY 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