New functions introduced, several rewrites:

[mailer.git] / inc / modules / member / what-payout.php

diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php
index ba12785779e0d203a637d3240792a3f3711b09c5..48491080937cda2b89571be3261ba9cf144303f2 100644 (file)
--- a/inc/modules/member/what-payout.php
+++ b/inc/modules/member/what-payout.php
@@ -53,28 +53,8 @@ if ((!isExtensionActive('payout')) && (!isAdmin())) {
        return;
 } // END - if
 
-$result_depths = SQL_QUERY("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY level", __FILE__, __LINE__);
-$totalPoints = '0';
-while ($content = SQL_FETCHARRAY($result_depths)) {
-       // Load referal points
-       $result_points = SQL_QUERY_ESC("SELECT `points` FROM `{?_MYSQL_PREFIX?}_user_points` WHERE `userid`=%s AND `ref_depth`='%s' LIMIT 1",
-               array(getMemberId(), bigintval($content['level'])), __FILE__, __LINE__);
-
-       // Entry found?
-       if (SQL_NUMROWS($result_points) == 1) {
-               // Load points
-               list($points) = SQL_FETCHROW($result_points);
-
-               // Add them to total
-               $totalPoints += $points;
-       } // END - if
-
-       // Free result
-       SQL_FREERESULT($result_points);
-} // END - while
-
-// Free memory
-SQL_FREERESULT($result_depths);
+// Get total points
+$totalPoints = countSumTotalData(getMemberId(), 'user_points', 'points');
 
 // Get used points
 $usedPoints = countSumTotalData(getMemberId(), 'user_data', 'used_points');
@@ -120,7 +100,7 @@ ORDER BY
                        while ($content = SQL_FETCHARRAY($result_payouts)) {
                                // Translate status
                                $content['status'] = getMessage('PAYOUT_MEMBER_STATUS_'.strtoupper($content['status']).'');
-                               $content['status'] = "<div class=\"member_failed\">".$content['status']."</div>";
+                               $content['status'] = '<div class="member_failed">' . $content['status'] . '</div>';
 
                                // Nothing entered must be secured in member/what-payputs.php !
                                if ($content['allow'] == 'Y') {
@@ -132,7 +112,7 @@ ORDER BY
                                                // Textlink
                                                $content['target_account'] = $content['alt'];
                                        }
-                                       $content['target_bank'] = "<a href=\"".generateDerefererUrl($content['url'])."\" target=\"_blank\">{--CLICK_HERE--}</a>";
+                                       $content['target_bank'] = '<a href="' . generateDerefererUrl($content['url']) . '" target="_blank">{--CLICK_HERE--}</a>';
                                } else {
                                        // e-currency payout request
                                        if (empty($content['target_account'])) $content['target_account'] = '---';