Opps, not all elements for sprintf() has been set.

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

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index f079c6a35385d7d9792558575fe62d9325af531b..4fb906fc38f5fbff16367ef929eb10afa6cf1bb2 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -50,11 +50,11 @@ function addRefbackPoints ($userid, $ref, $points, $ref_points) {
        $return = $ref_points;
 
        // Get all ref levels
-       $result_refs = SQL_QUERY('SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level` > 0 ORDER BY `level` ASC',
+       $result_refs = sqlQuery('SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level` > 0 ORDER BY `level` ASC',
                __FUNCTION__, __LINE__);
 
        // "Walk" through all level
-       while ($content = SQL_FETCHARRAY($result_refs)) {
+       while ($content = sqlFetchArray($result_refs)) {
                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'level=' . $content['level'] . ',percents=' . $content['percents'] . ' - LOOP START!');
                // Reset ref depths
                initReferralSystem();
@@ -81,7 +81,7 @@ function addRefbackPoints ($userid, $ref, $points, $ref_points) {
                                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'points=' . $points . ',percents=' . $content['percents'] . ',refback_percents=' . $content['refback_percents'] . ',level=' . $content['level'] . ',refback_points=' . $refbackPoints);
 
                                // Update refback table ('refid' and 'userid' must be exchanged!)
-                               SQL_QUERY_ESC('UPDATE
+                               sqlQueryEscaped('UPDATE
        `{?_MYSQL_PREFIX?}_user_refs`
 SET
        `refback_points`=`refback_points`+%s
@@ -96,14 +96,14 @@ LIMIT 1',
                                        ), __FUNCTION__, __LINE__);
 
                                // Something must have been updated
-                               if (SQL_HASZEROAFFECTED()) {
+                               if (ifSqlHasZeroAffectedRows()) {
                                        // Please report this bug
                                        reportBug(__FUNCTION__, __LINE__, 'Nothing has been updated in user_refs,userid=' . $userid . ',refid=' . convertNullToZero($refid) . ',refbackPoints=' . $refbackPoints);
                                } // END - if
 
                                // Add points again, but only directly
-                               //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refbackPoints=' . $refbackPoints . ',userid=' . $userid . ',ref=' . $ref . ',refid=' . convertNullToZero($refid) . ' - REFBACK-UPDATE! (' . SQL_AFFECTEDROWS() . ')');
-                               addPointsThroughReferralSystem(sprintf("refback:%s", $refid), $userid, $refbackPoints);
+                               //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refbackPoints=' . $refbackPoints . ',userid=' . $userid . ',ref=' . $ref . ',refid=' . convertNullToZero($refid) . ' - REFBACK-UPDATE! (' . sqlAffectedRows() . ')');
+                               addPointsThroughReferralSystem(sprintf('refback:%s', $refid), $userid, $refbackPoints);
 
                                // Reduce points if refid is found
                                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',refid=' . $refid . ',ref=' . $ref . ' - REDUCING?');
@@ -117,7 +117,7 @@ LIMIT 1',
        } // END - while
 
        // Free result
-       SQL_FREERESULT($result_refs);
+       sqlFreeResult($result_refs);
 
        // Restore ref depth
        $GLOBALS['ref_level'] = $GLOBALS['refback_depth'][$userid][$ref];
@@ -150,13 +150,13 @@ function getRefbackPercents ($userid, $refid) {
                $GLOBALS['refback_percents'][$userid][$refid] = '0';
 
                // Get percents from database
-               $result = SQL_QUERY_ESC("SELECT `refback_percents` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `refid`=%s LIMIT 1",
+               $result = sqlQueryEscaped("SELECT `refback_percents` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `refid`=%s LIMIT 1",
                        array($userid, $refid), __FUNCTION__, __LINE__);
 
                // Entry found? (Should be!)
-               if (SQL_NUMROWS($result) == 1) {
+               if (sqlNumRows($result) == 1) {
                        // Fetch percents
-                       list($GLOBALS['refback_percents'][$userid][$refid]) = SQL_FETCHROW($result);
+                       list($GLOBALS['refback_percents'][$userid][$refid]) = sqlFetchRow($result);
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',refid=' . $refid . ',percents=' . $GLOBALS['refback_percents'][$userid][$refid]);
                } else {
                        // Please report all findings
@@ -164,7 +164,7 @@ function getRefbackPercents ($userid, $refid) {
                }
 
                // Free result
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } // END - if
 
        // Return percents
@@ -179,7 +179,7 @@ function getArrayFromRefbackLevel ($refid, $level) {
        $userIds = array();
 
        // Look for all
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `userid`
 FROM
        `{?_MYSQL_PREFIX?}_user_refs`
@@ -191,17 +191,17 @@ ORDER BY
                array($refid, $level), __FUNCTION__, __LINE__);
 
        // Entries found?
-       //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'numRows=' . SQL_NUMROWS($result));
-       if (!SQL_HASZERONUMS($result)) {
+       //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'numRows=' . sqlNumRows($result));
+       if (!ifSqlHasZeroNums($result)) {
                // Add all
-               while ($content = SQL_FETCHARRAY($result)) {
+               while ($content = sqlFetchArray($result)) {
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refid=' . convertNullToZero($refid) . ',level=' . $level . ',userid=' . $content['userid']);
                        array_push($userIds, $content['userid']);
                } // END - while
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return array
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refid=' . convertNullToZero($refid) . ',userIds()=' . count($userIds) . ' - EXIT!');
@@ -215,7 +215,7 @@ function getArrayFromRefbackUserRefs ($userid, $level) {
        $refs = array();
 
        // Get refs from database
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `r`.`id`,
        `r`.`refid`,
        `r`.`refback_percents`,
@@ -239,17 +239,11 @@ ORDER BY
                array(bigintval($userid), bigintval($level)), __FUNCTION__, __LINE__);
 
        // Are there some entries?
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNums($result)) {
                // Fetch all entries
-               while ($row = SQL_FETCHARRAY($result)) {
-                       // Init click rate
-                       $row['click_rate'] = '0';
-
-                       // Does he have received some mails?
-                       if ($row['emails_received'] > 0) {
-                               // Calculate click rate
-                               $row['click_rate'] = ($row['mails_confirmed'] / $row['emails_received'] * 100);
-                       } // END - if
+               while ($row = sqlFetchArray($result)) {
+                       // Calculate click rate
+                       $row['click_rate'] = calculatePercentageRate($row['mails_confirmed'], $row['emails_received']);
 
                        // Add row
                        $refs[$row['id']] = $row;
@@ -257,7 +251,7 @@ ORDER BY
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return result
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . $level . ',refs()=' . count($refs) . ' - EXIT!');
@@ -274,17 +268,17 @@ function getArrayFromUserRefbackData ($id) {
        $id = bigintval($id);
 
        // Get entry from database
-       $result = SQL_QUERY_ESC("SELECT `id`, `userid`, `refid`, `refback_percents`, `level`, `refback_points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `id`, `userid`, `refid`, `refback_percents`, `level`, `refback_points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array($id, getMemberId()), __FUNCTION__, __LINE__);
 
        // Is there an entry?
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Fetch data
-               $data = SQL_FETCHARRAY($result);
+               $data = sqlFetchArray($result);
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return entry
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $id . ',data()=' . count($data) . ' - EXIT!');
@@ -316,7 +310,7 @@ function updateMemberRefbackPercents ($id, $percents, $note) {
        $content = getArrayFromUserRefbackData($id);
 
        // Is this valid?
-       if (count($content) == 0) {
+       if (!isFilledArray($content)) {
                // id does not belong to user!
                $status['message'] = 'MEMBER_REFBACK_ERROR_ID_MISMATCH';
                return $status;
@@ -326,7 +320,7 @@ function updateMemberRefbackPercents ($id, $percents, $note) {
        $percents = convertCommaToDot($percents);
 
        // Update entry
-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `refback_percents`='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
+       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `refback_percents`='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array(
                        $percents,
                        $id,
@@ -334,7 +328,7 @@ function updateMemberRefbackPercents ($id, $percents, $note) {
                ), __FUNCTION__, __LINE__);
 
        // Entry updated?
-       if (SQL_HASZEROAFFECTED()) {
+       if (ifSqlHasZeroAffectedRows()) {
                // Entry not updated!
                $status['message'] = 'MEMBER_REFBACK_ERROR_NOT_UPDATED';
                return $status;