X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=7f9ff7c38856f677f4f20aa33fd3d1f063b3e8d5;hb=72f7e9ed8975d7fb4f2ebeb48dd43c896289a57b;hp=bc376e20cfd5f2cc03e0c294716e75ec0140e9ea;hpb=20741b93fd58620af677a7f1039ffd16ea6ec689;p=mailer.git diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index bc376e20cf..7f9ff7c388 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 - 2011 by Mailer Developer Team * + * Copyright (c) 2009 - 2013 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -50,25 +50,25 @@ $content = array( ); // Check for normal mails -$result_media = SQL_QUERY('SELECT +$result_media = sqlQuery('SELECT SUM(`max_rec`) AS `normal_send`, SUM(`clicks`) AS `normal_clicks` FROM `{?_MYSQL_PREFIX?}_user_stats`', __FILE__, __LINE__); // Merge data together -$content = merge_array($content, SQL_FETCHARRAY($result_media)); +$content = merge_array($content, sqlFetchArray($result_media)); // Free memory -SQL_FREERESULT($result_media); +sqlFreeResult($result_media); // Check for bonus extension if (isExtensionActive('bonus')) { // Count bonus mails - $bcount = countSumTotalData('', 'bonus', 'id', '', true); + $bcount = countSumTotalData('', 'bonus', 'id', '', TRUE); // Check for bonus mails - $result_media = SQL_QUERY('SELECT + $result_media = sqlQuery('SELECT SUM(`mails_send`) AS `bonus_send`, SUM(`clicks`) AS `bonus_clicks` FROM @@ -76,10 +76,10 @@ FROM LIMIT 1', __FILE__, __LINE__); // Merge data together - $content = merge_array($content, SQL_FETCHARRAY($result_media)); + $content = merge_array($content, sqlFetchArray($result_media)); // Free memory - SQL_FREERESULT($result_media); + sqlFreeResult($result_media); } // END - if // Load (maybe) missing file @@ -88,7 +88,7 @@ loadIncludeOnce('inc/libs/mediadata_functions.php'); // Insert info to database updateMediadataEntry(array('total_send' , 'normal_send') , 'init', $content['normal_send']); updateMediadataEntry(array('total_clicks', 'normal_clicks'), 'init', $content['normal_clicks']); -updateMediadataEntry(array('total_orders', 'normal_orders'), 'init', countSumTotalData('', 'user_stats', 'id', '', true)); +updateMediadataEntry(array('total_orders', 'normal_orders'), 'init', countSumTotalData('', 'user_stats', 'id', '', TRUE)); updateMediadataEntry(array('total_send' , 'bonus_send' ) , 'init', $content['bonus_send']); updateMediadataEntry(array('total_clicks', 'bonus_clicks') , 'init', $content['bonus_clicks']); updateMediadataEntry(array('total_orders', 'bonus_orders') , 'init', $bcount);