Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index fd1c866ba4bf07b83604fd39a1a71d7b3d508793..4e312104a49ad68fe62b0580d1d75380edcbe135 100644 (file)
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -44,7 +44,7 @@ if (!defined('__SECURITY')) {
 // @TODO Lame description
 function generateDoublerTable ($userid = NULL, $done = 'N', $ref = 'N', $sort = 'ASC') {
        $add = ''; $DT_MODE = '0';
-       if (isValidUserId($userid)) {
+       if (isValidId($userid)) {
                // Load entries only from a single user
                $add = sprintf(" AND `userid`=%s", bigintval($userid));
                $mode = 'member'; $COLS = 4; $DT_MODE = 2;
@@ -67,8 +67,11 @@ function generateDoublerTable ($userid = NULL, $done = 'N', $ref = 'N', $sort =
        }
 
        // List entries
-       $result = SQL_QUERY_ESC("SELECT
-       `userid`,`refid`,`points`,`timemark`
+       $result = sqlQueryEscaped("SELECT
+       `userid`,
+       `refid`,
+       `points`,
+       `timemark`
 FROM
        `{?_MYSQL_PREFIX?}_doubler`
 WHERE
@@ -85,10 +88,10 @@ LIMIT %s",
                        $limit
                ), __FUNCTION__, __LINE__);
 
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNums($result)) {
                // List entries
                $OUT = '';
-               while ($content = SQL_FETCHARRAY($result)) {
+               while ($content = sqlFetchArray($result)) {
                        // Rewrite userid/refid only if admin is in
                        // @TODO Can't this be moved into EL?
                        if (isAdmin()) {
@@ -97,53 +100,51 @@ LIMIT %s",
                                $content['refid']  = '---';
 
                                // Set links to admin area
-                               if (isValidUserId($content['userid'])) $content['userid'] = generateUserProfileLink($content['userid']);
-                               if (isValidUserId($content['refid']))  $content['refid']  = generateUserProfileLink($content['refid']);
+                               if (isValidId($content['userid'])) $content['userid'] = generateUserProfileLink($content['userid']);
+                               if (isValidId($content['refid']))  $content['refid']  = generateUserProfileLink($content['refid']);
                        } // END - if
 
                        // Prepare data for the row template
                        $content['timemark'] = generateDateTime($content['timemark'], $DT_MODE);
 
                        // Load template and switch color
-                       $OUT .= loadTemplate($mode . '_doubler_list_rows', true, $content);
+                       $OUT .= loadTemplate($mode . '_doubler_list_rows', TRUE, $content);
                } // END - while
 
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } else {
                // List no entries
                $OUT = '<tr>
   <td colspan="' . $COLS . '" align="center" class="bottom">
-    ' . displayMessage($message, true) . '
+    ' . displayMessage($message, TRUE) . '
   </td>
 </tr>';
        }
 
        // Return template
-       return loadTemplate($mode . '_doubler_list', true, $OUT);
+       return loadTemplate($mode . '_doubler_list', TRUE, $OUT);
 }
 
 // Get total points left in doubler pot
+// @TODO This could be rewritten to a filter
 function getDoublerTotalPointsLeft() {
        // Initialize variables
        $points = '0';
 
        if (getConfig('doubler_own') == 'Y') {
                // Take points from doubler's own account
-               $points += getConfig('doubler_points') - getConfig('doubler_used');
+               $points += getDoublerPoints() - getConfig('doubler_used');
        } // END - if
 
        if ((getConfig('doubler_jackpot') == 'Y') && (isExtensionActive('jackpot'))) {
-               // Load jackpot
-               $jackpot = getJackpotPoints();
-
-               if (!empty($jackpot)) $points += $jackpot;
+               // Get+add jackpot points
+               $points += getJackpotPoints();
        } // END - if
 
-       if (isValidUserId(getConfig('doubler_userid'))) {
+       if (isValidId(getDoublerUserid())) {
                // Get user's points
-               $user = getTotalPoints(getConfig('doubler_userid'));
-               $points += $user;
+               $points += getTotalPoints(getDoublerUserid());
        } // END - if
 
        // Return value
@@ -168,7 +169,7 @@ function getDoublerUserid () {
 
 // "Getter" for doubler_timeout
 function getDoublerTimeout () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_timeout');
@@ -180,7 +181,7 @@ function getDoublerTimeout () {
 
 // "Getter" for doubler_send_mode
 function getDoublerSendMode () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_send_mode');
@@ -192,7 +193,7 @@ function getDoublerSendMode () {
 
 // "Getter" for doubler_ref
 function getDoublerRef () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_ref');
@@ -204,7 +205,7 @@ function getDoublerRef () {
 
 // "Getter" for doubler_points
 function getDoublerPoints () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_points');
@@ -216,7 +217,7 @@ function getDoublerPoints () {
 
 // "Getter" for doubler_min
 function getDoublerMin () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_min');
@@ -228,7 +229,7 @@ function getDoublerMin () {
 
 // "Getter" for doubler_max
 function getDoublerMax () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_max');
@@ -240,7 +241,7 @@ function getDoublerMax () {
 
 // "Getter" for doubler_counter
 function getDoublerCounter () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_counter');
@@ -252,7 +253,7 @@ function getDoublerCounter () {
 
 // "Getter" for doubler_charge
 function getDoublerCharge () {
-       // Do we have cache?
+       // Is there cache?
        if (!isset($GLOBALS[__FUNCTION__])) {
                // Determine it
                $GLOBALS[__FUNCTION__] = getConfig('doubler_charge');
@@ -262,5 +263,17 @@ function getDoublerCharge () {
        return $GLOBALS[__FUNCTION__];
 }
 
+// "Getter" for doubler_max_sent
+function getDoublerMaxSent () {
+       // Is there cache?
+       if (!isset($GLOBALS[__FUNCTION__])) {
+               // Determine it
+               $GLOBALS[__FUNCTION__] = getConfig('doubler_max_sent');
+       } // END - if
+
+       // Return cache
+       return $GLOBALS[__FUNCTION__];
+}
+
 // [EOF]
 ?>