X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=a5a4ab2f1dff4811691b4d3356638ec634802d33;hb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;hp=226fa76ffbabc322c0311413deb3400f3eea84bb;hpb=428be1738c81a57e4e75b4f701df9414656a3b13;p=mailer.git diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php index 226fa76ffb..a5a4ab2f1d 100644 --- a/inc/modules/admin/what-email_details.php +++ b/inc/modules/admin/what-email_details.php @@ -52,7 +52,7 @@ if (!isExtensionInstalledAndNewer('sql_patches', '0.7.4')) { // Normal mails ordered by your members $sql = "SELECT - `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`mails_sent`,`cat_id` + `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `mails_sent`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE @@ -66,7 +66,7 @@ $SQL2 = ''; if (isGetRequestElementSet('mid')) { // Only a specific mail shall be displayed $sql = sprintf("SELECT - `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`mails_sent`,`cat_id` + `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `mails_sent`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE @@ -78,7 +78,7 @@ LIMIT 1", } elseif (isGetRequestElementSet('userid')) { // All mails by a specific member shall be displayed $sql = sprintf("SELECT - `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`mails_sent`,`cat_id` + `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `mails_sent`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE @@ -96,7 +96,7 @@ $result_bonus = false; if ((isExtensionActive('bonus')) && (empty($WHO))) { // Check for maximum pages $result_bonus = SQL_QUERY("SELECT - `id`,`subject`,`text`,`receivers`,`points`,`time`,`data_type`,`timestamp`,`url`,`cat_id`,`target_send`,`mails_sent`,`clicks`, + `id`, `subject`, `text`, `receivers`, `points`, `time`, `data_type`, `timestamp`, `url`, `cat_id`, `target_send`, `mails_sent`, `clicks`, (`mails_sent` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_bonus`