Updated copyright year.

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

diff --git a/inc/libs/earning_functions.php b/inc/libs/earning_functions.php
index 2507db9257217a797418e675f9a86386c586fdbe..fb4da0bf6818445a927bab00251e69062ad784e2 100644 (file)
--- a/inc/libs/earning_functions.php
+++ b/inc/libs/earning_functions.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 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 *
@@ -79,7 +79,7 @@ function generateMemberEarningDataTable ($earningProvider) {
        $filterData = runFilterChain('member_earning_table_data', $filterData);
 
        // Load the proper template and return it
-       $output = loadTemplate('member_earning_data_' . strtolower($filterData['earning_group']), true, $filterData);
+       $output = loadTemplate('member_earning_data_' . strtolower($filterData['earning_group']), TRUE, $filterData);
 
        // Return it
        return $output;
@@ -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;
 }
@@ -116,7 +103,7 @@ function doMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
 // Insert member earning entry
 function insertMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
        // Insert the record
-       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_earning` (`earning_id`,`earning_userid`,`earning_daily_amount`,`earning_active`) VALUES(%s,%s,%s,'%s')",
+       sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_user_earning` (`earning_id`, `earning_userid`, `earning_daily_amount`, `earning_active`) VALUES(%s,%s,%s,'%s')",
                array(
                        bigintval($earningId),
                        getMemberId(),
@@ -126,7 +113,7 @@ function insertMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
 
        // Prepare content
        $content = array(
-               'insert_id'    => SQL_INSERTID(),
+               'insert_id'    => getSqlInsertId(),
                'earning_id'   => bigintval($earningId),
                'daily_amount' => bigintval($dailyAmount),
                'is_active'    => $isActive
@@ -142,7 +129,7 @@ function insertMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
        sendAdminNotification('{--ADMIN_EARNING_INSERTED_SUBJECT--}', 'admin_earning_added', $content, getMemberId());
 
        // Return status
-       return ($content['insert_id'] > 0);
+       return isValidId($content['insert_id']);
 }
 
 // Update a given earning amount
@@ -157,7 +144,7 @@ function updateMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
        } // END - if
 
        // Update database record
-       SQL_QUERY_ESC("UPDATE
+       sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_user_earning`
 SET
        `earning_daily_amount`=%s,
@@ -173,11 +160,11 @@ LIMIT 1", array(
                getMemberId()
        ), __FUNCTION__, __LINE__);
 
-       // Determine wether something has changed
-       $status = (!SQL_HASZEROAFFECTED());
+       // Determine whether something has changed
+       $status = (!ifSqlHasZeroAffectedRows());
 
        // Has the record changed?
-       if ($status === true) {
+       if ($status === TRUE) {
                // Prepare content
                $content = array(
                        'earning_id'   => bigintval($earningId),