X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-points.php;h=b476f08b1c65fb37314b44cd1b5aa7442b97307d;hp=08e9b396cc1419376a436016ba3428d7e5e6c158;hb=a18efdcd57ba91893f0958a457b5c58639b135c3;hpb=6a0c39a390c28999679d84a7ae5264363b0054dc

diff --git a/inc/modules/member/what-points.php b/inc/modules/member/what-points.php
index 08e9b396cc..b476f08b1c 100644
--- a/inc/modules/member/what-points.php
+++ b/inc/modules/member/what-points.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -45,8 +45,8 @@ if (!defined('__SECURITY')) {
 // Add description as navigation point
 addYouAreHereLink('member', __FILE__);
 
-// Query for referal levels and percents
-$result_depths = SQL_QUERY("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY `level` ASC", __FILE__, __LINE__);
+// Query for referral levels and percents
+$result_depths = SQL_QUERY('SELECT `level`,`percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY `level` ASC', __FILE__, __LINE__);
 
 // Get total depths
 $numDepths = SQL_NUMROWS($result_depths);
@@ -61,26 +61,34 @@ if (isExtensionInstalledAndNewer('bonus', '0.4.4')) $numDepths += 4;
 $content['rowspan'] = ($numDepths * 2 + 15);
 
 // Initialize array elements
-$content['part_points']        = '0.00000';
-$content['part_referals']      = '0';
-$content['part_locked']        = '0.00000';
-$content['part_order']         = '0.00000';
-$content['part_locked_order']  = '0.00000';
-$content['counter']             = '0';
-$content['points']              = '0.00000';
-$content['order_points']        = '0.00000';
-$content['locked_points']       = '0.00000';
-$content['locked_order_points'] = '0.00000';
+$content['part_points']         = '0.00000';
+$content['part_referrals']      = '0';
+$content['part_locked']         = '0.00000';
+$content['part_order']          = '0.00000';
+$content['part_locked_order']   = '0.00000';
 
 // And output variable
 $OUT = '';
 
 // Load ref levels
 while ($data = SQL_FETCHARRAY($result_depths)) {
+	// Init points and counter here
+	$content['counter']             = '0';
+	$content['points']              = '0.00000';
+	$content['order_points']        = '0.00000';
+	$content['locked_points']       = '0.00000';
+	$content['locked_order_points'] = '0.00000';
+
 	// Merge it together
 	$content = merge_array($content, $data);
 
-	// Load referal points
+	// Default for referral level > 0
+	$depth = 'p.`ref_depth`=%s';
+	if (is_null($content['level'])) {
+		$depth = 'p.`ref_depth` IS NULL';
+	} // END - if
+
+	// Load referral points
 	$result_points = SQL_QUERY_ESC("SELECT
 	p.`points`,
 	p.`order_points`,
@@ -96,11 +104,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?
@@ -113,7 +121,7 @@ LIMIT 1",
 		$content['part_order']        += $content['order_points'];
 		$content['part_locked']       += $content['locked_points'];
 		$content['part_locked_order'] += $content['locked_order_points'];
-		$content['part_referals']     += $content['counter'];
+		$content['part_referrals']    += $content['counter'];
 	} // END - if
 
 	// Free result
@@ -150,7 +158,7 @@ if ((isExtensionInstalledAndNewer('bonus', '0.2.2')) && (isExtensionActive('bonu
 } elseif ((isExtensionActive('bonus')) && (!isBonusRallyeActive())) {
 	// Bonus active rallye deactivated
 	$content['special_rows'] = loadTemplate('member_points_bonus_disabled', true);
-} elseif ((isAdmin()) && (isExtensionOlder('bonus', '0.2.2')) && (isExtensionActive('bonus'))) {
+} elseif ((isAdmin()) && (isExtensionInstalledAndOlder('bonus', '0.2.2')) && (isExtensionActive('bonus'))) {
 	// Please upgrade your bonus extension to v0.2.2 or newer!
 	$content['special_rows'] = loadTemplate('member_points_upgrade');
 }
@@ -161,7 +169,7 @@ if (isExtensionActive('user')) {
 	loadTemplate('member_points', false, $content);
 } elseif (isAdmin()) {
 	// Missing extension
-	displayMessage(generateExtensionInactiveNotInstalledMessage('user'));
+	displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=user%}');
 } else {
 	// Message for user
 	displayMessage('{--PROBLEM_POINTS_OVERVIEW_UNAVAILABLE--}');