X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=4bbce46084204c6b2be92a95a201dc8192ada2e1;hb=0e104a9282a1cdc7d769bbccb03bd3462aa8f4e0;hp=31e0761d91912d573ef34174e814dd1682f647f7;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2;p=mailer.git diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 31e0761d91..4bbce46084 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -55,6 +55,8 @@ $result_media = SQL_QUERY('SELECT SUM(`clicks`) AS `normal_clicks` FROM `{?_MYSQL_PREFIX?}_user_stats`', __FILE__, __LINE__); + +// Merge data together $content = merge_array($content, SQL_FETCHARRAY($result_media)); // Free memory @@ -70,7 +72,10 @@ if (isExtensionActive('bonus')) { SUM(`mails_send`) AS `bonus_send`, SUM(`clicks`) AS `bonus_clicks` FROM - `{?_MYSQL_PREFIX?}_bonus`', __FILE__, __LINE__); + `{?_MYSQL_PREFIX?}_bonus` +LIMIT 1', __FILE__, __LINE__); + + // Merge data together $content = merge_array($content, SQL_FETCHARRAY($result_media)); // Free memory