From f7d4bc84b3a802374ee9449356d94a71965a570e Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Mon, 4 Jul 2011 01:48:17 +0000
Subject: [PATCH] Fix #1002

---
 inc/modules/member/what-points.php | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

diff --git a/inc/modules/member/what-points.php b/inc/modules/member/what-points.php
index 87f69f4207..2741f08b74 100644
--- 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?
-- 
2.39.2