Several minor rewrites, getter GET_JACKPOT_POINTS() added

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

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index f08adfbccdf4810ff063ac6074df7efde12673c7..27c33d2582e679feee938c337aeb5fda5fecafcf 100644 (file)
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -44,27 +44,27 @@ if (!defined('__SECURITY')) {
 
 // Generates a HTML table based on given data
 // @TODO Lame description
-function DOUBLER_GENERATE_TABLE ($uid="0", $done='N', $ref='N', $sort="ASC") {
+function DOUBLER_GENERATE_TABLE ($uid = '0', $done = 'N', $ref = 'N', $sort = 'ASC') {
        if (empty($cnt)) $cnt = 0;
        $add = ''; $DT_MODE = 0;
        if ($uid > 0) {
                // Load entries only from a single user
-               $add = " AND userid='".bigintval($uid)."'";
-               $MODE = 'member'; $COLS = "4"; $DT_MODE = "2";
+               $add = " AND `userid`='".bigintval($uid)."'";
+               $mode = 'member'; $COLS = '4'; $DT_MODE = '2';
                $NOT_FOUND = getMessage('DOUBLER_MEMBER_NO_ENTRIES_FOUND');
        } else {
                // Guest mode!
-               $MODE = 'guest'; $COLS = "3"; $DT_MODE = "3";
+               $mode = 'guest'; $COLS = '3'; $DT_MODE = '3';
                $NOT_FOUND = getMessage('DOUBLER_GUEST_NO_ENTRIES_FOUND');
        }
 
-       if (($done == 'Y') && ($sort == "ASC")) {
+       if (($done == 'Y') && ($sort == 'ASC')) {
                // Already payed out points (latest payouts first)
                $limit = getConfig('doubler_display_old');
-       } elseif ($sort == "ASC") {
+       } elseif ($sort == 'ASC') {
                // List entries which will receive their payout soon
                $limit = getConfig('doubler_display_pay');
-       } elseif ($sort == "DESC") {
+       } elseif ($sort == 'DESC') {
                // Newest entries
                $limit = getConfig('doubler_display_new');
        }
@@ -83,21 +83,21 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
                        // Rewrite userid/refid only if admin is in
                        if (IS_ADMIN()) {
                                // Set links to admin area
-                               if ($content['userid'] > 0) { $content['userid'] = ADMIN_USER_PROFILE_LINK($content['userid']); } else { $content['userid'] = "---"; }
-                               if ($content['refid'] > 0)  { $content['refid']  = ADMIN_USER_PROFILE_LINK($content['refid']);  } else { $content['refid']  = "---"; }
+                               if ($content['userid'] > 0) { $content['userid'] = generateUserProfileLink($content['userid']); } else { $content['userid'] = '---'; }
+                               if ($content['refid'] > 0)  { $content['refid']  = generateUserProfileLink($content['refid']);  } else { $content['refid']  = '---'; }
                        } // END - if
 
                        // Prepare data for the row template
                        $content = array(
                                'uid'    => $content['userid'],
                                'rid'    => $content['refid'],
-                               'points' => TRANSLATE_COMMA($content['points']),
-                               'stamp'  => MAKE_DATETIME($content['timemark'], $DT_MODE),
+                               'points' => translateComma($content['points']),
+                               'stamp'  => generateDateTime($content['timemark'], $DT_MODE),
                                'sw'     => $SW,
                        );
 
                        // Load template and switch color
-                       $OUT .= LOAD_TEMPLATE($MODE."_doubler_list_rows", true, $content);
+                       $OUT .= LOAD_TEMPLATE($mode . '_doubler_list_rows', true, $content);
                        $SW = 3 - $SW;
                }
 
@@ -113,7 +113,7 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
        }
 
        // Return template
-       return LOAD_TEMPLATE($MODE."_doubler_list", true, $OUT);
+       return LOAD_TEMPLATE($mode . '_doubler_list', true, $OUT);
 }
 
 //
@@ -124,20 +124,18 @@ function DOUBLER_GET_TOTAL_POINTS_LEFT() {
        if (getConfig('doubler_own') == 'Y') {
                // Take points from doubler's own account
                $points += getConfig('doubler_points') - getConfig('doubler_used');
-       }
+       } // END - if
 
        if (getConfig('doubler_jackpot') == 'Y') {
                // Load jackpot
-               $result = SQL_QUERY("SELECT points FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FUNCTION__, __LINE__);
-               list($jackpot) = SQL_FETCHROW($result);
-               SQL_FREERESULT($result);
+               $jackpot = GET_JACKPOT_POINTS();
 
                if (!empty($jackpot)) $points += $jackpot;
        }
 
        if (getConfig('doubler_uid') > 0) {
                // Get user's points
-               $user = GET_TOTAL_DATA(getConfig('doubler_uid'), "user_points", "points");
+               $user = GET_TOTAL_DATA(getConfig('doubler_uid'), 'user_points', 'points');
                $points += $user;
        }