Missing URL blacklist tabled (re-)added

[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 9b9f607cfc1b827a4d623ae8439336f1c228a6c4..8fbcba686af6ccf4d3c846405723f71d1857e2e0 100644 (file)
--- a/inc/modules/member/what-payout.php
+++ b/inc/modules/member/what-payout.php
@@ -40,7 +40,6 @@ if (!defined('__SECURITY')) {
        // Not logged in
        LOAD_URL("modules.php?module=index");
 } elseif ((!EXT_IS_ACTIVE("payout")) && (!IS_ADMIN())) {
-       // Extension "payout" is not active
        ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "payout");
        return;
 }
@@ -50,17 +49,22 @@ ADD_DESCR("member", __FILE__);
 
 $result_depths = SQL_QUERY("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths ORDER BY level", __FILE__, __LINE__);
 $TPTS = 0;
-while (list($lvl, $per) = SQL_FETCHROW($result_depths))
-{
+while (list($lvl, $per) = SQL_FETCHROW($result_depths)) {
        // Load referal points
        $result_points = SQL_QUERY_ESC("SELECT points FROM "._MYSQL_PREFIX."_user_points WHERE userid=%s AND ref_depth=%d LIMIT 1",
-        array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result_points) == 1)
-       {
+               array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
+
+       // Entry found?
+       if (SQL_NUMROWS($result_points) == 1) {
+               // Load points
                list($points) = SQL_FETCHROW($result_points);
-               SQL_FREERESULT($result_points);
+
+               // Add them to total
                $TPTS += $points;
        }
+
+       // Free result
+       SQL_FREERESULT($result_points);
 }
 
 // Free memory
@@ -192,7 +196,7 @@ ORDER BY p.payout_timestamp DESC",
                                define('PAYOUT_POINTS_VALUE', $PAYOUT);
 
                                // Subtract points from member's account
-                               SUB_POINTS($GLOBALS['userid'], $PAYOUT);
+                               SUB_POINTS("payout", $GLOBALS['userid'], $PAYOUT);
 
                                // Add entry to his tranfer history
                                if ($allow == "Y")