X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=8922660483b0431a3120658c7ed2384c646ee926;hp=7f4246a5083b89c8d576e23d0e4007ad6cb218c3;hb=ff9e8f739bd4b6e184b2a6bf427334196e501da8;hpb=b353f8583ae3c0a9224d97a2ed01fd8cd7965081

diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php
index 7f4246a508..8922660483 100644
--- a/inc/gen_mediadata.php
+++ b/inc/gen_mediadata.php
@@ -86,14 +86,10 @@ updateMediadataEntry(array('total_clicks', 'bonus_clicks') , 'init', $bclicks);
 updateMediadataEntry(array('total_orders', 'bonus_orders') , 'init', $bcount);
 
 // Aquire total used points
-$result = SQL_QUERY('SELECT SUM(`used_points`) AS used_points FROM `{?_MYSQL_PREFIX?}_user_data`', __FILE__, __LINE__);
-list($used) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
+$used = countSumTotalData('', 'user_data', 'used_points', '');
 
 // ... and total points
-$result = SQL_QUERY('SELECT SUM(`points`) AS points FROM `{?_MYSQL_PREFIX?}_user_points`', __FILE__, __LINE__);
-list($points) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
+$points = countSumTotalData('', 'user_points', 'points', '');
 
 // Update database
 updateMediadataEntry(array('total_points'), 'init', ($points - $used));