Several minor rewrites, getter GET_JACKPOT_POINTS() added
[mailer.git] / inc / libs / doubler_functions.php
index a6b0d5159428682c49d90fb0d6340fda4ae84594..27c33d2582e679feee938c337aeb5fda5fecafcf 100644 (file)
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
        require($INC);
 }
 
 // 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;
+       $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');
        }
@@ -78,26 +78,26 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
 
        if (SQL_NUMROWS($result) > 0) {
                // List entries
-               $OUT = ""; $SW = 2;
+               $OUT = ''; $SW = 2;
                while ($content = SQL_FETCHARRAY($result)) {
                        // 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;
                }
 
@@ -107,13 +107,13 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
                // List no entries
                $OUT = "<tr>
   <td colspan=\"".$COLS."\" align=\"center\" class=\"doubler_big_row bottom2\">
-    ".LOAD_TEMPLATE("admin_settings_saved", true, $NOT_FOUND)."
+    ".LOAD_TEMPLATE('admin_settings_saved', true, $NOT_FOUND)."
   </td>
 </tr>\n";
        }
 
        // Return template
-       return LOAD_TEMPLATE($MODE."_doubler_list", true, $OUT);
+       return LOAD_TEMPLATE($mode . '_doubler_list', true, $OUT);
 }
 
 //
@@ -121,23 +121,21 @@ function DOUBLER_GET_TOTAL_POINTS_LEFT() {
        // Initialize variables
        $points = 0;
 
-       if (getConfig('doubler_own') == "Y") {
+       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") {
+       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;
        }