X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fmember%2Fwhat-points.php;h=19514c45178d4d78a94315db9bc2e7b5772181ca;hb=4001187f22197f55e5a1f211fc8defcc180f7c32;hp=2f3a853add8871ef51022e261003b46cd4f5498d;hpb=b8c86fa12322603c24a88ea2b0fd3dbeba612752;p=mailer.git

diff --git a/inc/modules/member/what-points.php b/inc/modules/member/what-points.php
index 2f3a853add..19514c4517 100644
--- a/inc/modules/member/what-points.php
+++ b/inc/modules/member/what-points.php
@@ -46,6 +46,7 @@ $result_depths = SQL_QUERY("SELECT level, percents FROM `{!_MYSQL_PREFIX!}_refde
 $depths = SQL_NUMROWS($result_depths);
 
 // Add many more rows for the login/turbo/ref/order bonus
+// @TODO Should we rewrite this to a filter?
 if (!EXT_IS_ACTIVE("bonus")) $depths += 1;
 if (GET_EXT_VERSION("bonus") >= "0.2.2") $depths += 6;
 if (GET_EXT_VERSION("bonus") >= "0.4.4") $depths += 4;
@@ -57,12 +58,12 @@ define('__ROWS_VALUE', ($depths*2+15));
 $TPTS = 0; $TREF = 0; $TLOCK = 0; $OUT = "";
 
 // Load ref levels
-while (list($lvl, $per) = SQL_FETCHROW($result_depths)) {
+while ($content = SQL_FETCHARRAY($result_depths)) {
 	// Initialize ref-count
 	$REFS = 0;
 
 	// Load referal points
-	$result_points = SQL_QUERY_ESC("SELECT points, locked_points FROM `{!_MYSQL_PREFIX!}_user_points` WHERE userid=%s AND ref_depth=%d LIMIT 1", array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
+	$result_points = SQL_QUERY_ESC("SELECT points, locked_points FROM `{!_MYSQL_PREFIX!}_user_points` WHERE userid=%s AND ref_depth=%d LIMIT 1", array($GLOBALS['userid'], bigintval($content['level'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_points) == 1) {
 		list($points, $locked) = SQL_FETCHROW($result_points);
 		SQL_FREERESULT($result_points);
@@ -74,7 +75,7 @@ while (list($lvl, $per) = SQL_FETCHROW($result_depths)) {
 
 	// Load referal counts
 	$result_refs = SQL_QUERY_ESC("SELECT counter FROM `{!_MYSQL_PREFIX!}_refsystem` WHERE userid=%s AND level='%s' LIMIT 1",
-		array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
+		array($GLOBALS['userid'], bigintval($content['level'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_refs) == 1) {
 		list($REFS) = SQL_FETCHROW($result_refs);
 		SQL_FREERESULT($result_refs);
@@ -85,8 +86,8 @@ while (list($lvl, $per) = SQL_FETCHROW($result_depths)) {
 
 	// Transfer data to array for template
 	$content = array(
-		'lvl'    => $lvl,
-		'per'    => TRANSLATE_COMMA($per),
+		'lvl'    => $content['level'],
+		'per'    => TRANSLATE_COMMA($content['percents']),
 		'points' => TRANSLATE_COMMA($points),
 		'refs'   => TRANSLATE_COMMA($REFS),
 	);