Fix for previous commit

[mailer.git] / inc / gen_mediadata.php

diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php
index 31e0761d91912d573ef34174e814dd1682f647f7..4bbce46084204c6b2be92a95a201dc8192ada2e1 100644 (file)
--- 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