X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=535af09f673f479061be3e74343ac8b321fd8142;hb=e19231f39d9d6583cc5753dbd2638c597957fdd1;hp=686808daca23514b925e6f16f240ccd9b8d8c79f;hpb=63f159414369b5ea19a8ca75d8cd8033c45d8341;p=mailer.git diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 686808daca..535af09f67 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -10,13 +10,8 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Prueft bestehende Mailbuchungen * * -------------------------------------------------------------------- * - * $Revision:: $ * - * $Date:: $ * - * $Tag:: 0.2.1-FINAL $ * - * $Author:: $ * - * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * Copyright (c) 2009 - 2016 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 +45,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 +71,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 +83,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);