X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=7f9ff7c38856f677f4f20aa33fd3d1f063b3e8d5;hb=ec3907de5b6c1ca85da82232707c85d22e197c11;hp=5dabc850f87359dd14c916b323c7bc1421131d93;hpb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;p=mailer.git diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 5dabc850f8..7f9ff7c388 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -50,17 +50,17 @@ $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')) { @@ -68,7 +68,7 @@ if (isExtensionActive('bonus')) { $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