Extension ext-network continued:

[mailer.git] / inc / libs / earning_functions.php

diff --git a/inc/libs/earning_functions.php b/inc/libs/earning_functions.php
index 3f747490bfa1fd97e3aa5250c057ecf301444c42..a1bb9a79f74048f3cf3d1fd00acc67111eb89349 100644 (file)
--- a/inc/libs/earning_functions.php
+++ b/inc/libs/earning_functions.php
@@ -87,18 +87,8 @@ function generateMemberEarningDataTable ($earningProvider) {
 
 // Handle earning id
 function doMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
-       // Does the user already have this earning?
-       $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS `cnt` FROM `{?_MYSQL_PREFIX?}_user_earning` WHERE `earning_id`=%s AND `earning_userid`=%s LIMIT 1",
-               array(
-                       bigintval($earningId),
-                       getMemberId()
-               ), __FUNCTION__, __LINE__);
-
-       // Get the count
-       list($count) = SQL_FETCHROW($result);
-
        // Does the user have this?
-       if ($count == 1) {
+       if (countSumTotalData(bigintval($earningId), 'user_earning', 'id', 'earning_id', TRUE, ' AND `earning_userid`=' . getMemberId()) == 1) {
                // Then update it
                $status = updateMemberEarning($earningId, $dailyAmount, $isActive);
        } else {
@@ -106,9 +96,6 @@ function doMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
                $status = insertMemberEarning($earningId, $dailyAmount, $isActive);
        }
 
-       // Free result
-       SQL_FREERESULT($result);
-
        // Return status
        return $status;
 }