X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=4bbce46084204c6b2be92a95a201dc8192ada2e1;hb=9d83303b8272d7ea91b0e661609e48894262a432;hp=0f72be55323825c1bec8c27b2f1033383604945e;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8;p=mailer.git diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 0f72be5532..4bbce46084 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -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