Fix #1002

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

diff --git a/inc/modules/member/what-points.php b/inc/modules/member/what-points.php
index 87f69f4207ea6b375259e8106480d5afca1e2131..2741f08b74ca83fd6d2e740829f73b862b7ddcaf 100644 (file)
--- a/inc/modules/member/what-points.php
+++ b/inc/modules/member/what-points.php
@@ -80,6 +80,12 @@ while ($data = SQL_FETCHARRAY($result_depths)) {
        // Merge it together
        $content = merge_array($content, $data);
 
+       // Default for referal level > 0
+       $depth = 'p.`ref_depth`=%s';
+       if (is_null($content['level'])) {
+               $depth = 'p.`ref_depth` IS NULL';
+       } // END - if
+
        // Load referal points
        $result_points = SQL_QUERY_ESC("SELECT
        p.`points`,
@@ -96,11 +102,11 @@ ON
        p.`ref_depth`=r.`level`
 WHERE
        p.`userid`=%s AND
-       p.`ref_depth`=%s
+       ".$depth."
 LIMIT 1",
                array(
                        getMemberId(),
-                       bigintval($content['level'])
+                       makeZeroToNull($content['level'])
                ), __FILE__, __LINE__);
 
        // Do we have an entry?