X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=24aa58332c9fafa37e7f562963d7b54ad30f486f;hb=51ad4dc0ad7540d36b605e5ad958c42b68dced1f;hp=182525c71aa87708d772c24d1ffac8bd32457eba;hpb=4c221b6350439b8f91db58f142f03f79014f2eaf;p=mailer.git diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php index 182525c71a..24aa58332c 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 (isGetRequestParameterSet('mid')) { // Only a specific mail shall be displayed $sql = sprintf("SELECT - `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `cat_id` + `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`cat_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE @@ -78,7 +78,7 @@ LIMIT 1", } elseif (isGetRequestParameterSet('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`, `cat_id` + `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`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`