X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=bc376e20cfd5f2cc03e0c294716e75ec0140e9ea;hp=cd3fdb2ec2dead7b9d1b6a3f4ebff033317c2692;hb=e3934352dffa6eb9da59a137ae1a9414e5b4d80b;hpb=879d21c8fbaf8868194aeb456a77ab95b0dc43b0 diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index cd3fdb2ec2..bc376e20cf 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -57,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 @@ -72,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