Fixes for ref-level 0
[mailer.git] / inc / modules / member / what-points.php
index 780d05a23d87c746531fee85396b9a6e98e2cb3a..11a8db0a0e12904f10b9ab8acfa35e66de1fccc7 100644 (file)
@@ -62,7 +62,7 @@ while (list($lvl, $per) = SQL_FETCHROW($result_depths)) {
        $REFS = 0;
 
        // Load referral points
-       $result_points = SQL_QUERY_ESC("SELECT points, locked_points FROM "._MYSQL_PREFIX."_user_points WHERE userid=%s AND ref_depth=%s 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($lvl)), __FILE__, __LINE__);
        if (SQL_NUMROWS($result_points) == 1) {
                list($points, $LOCKED) = SQL_FETCHROW($result_points);
                SQL_FREERESULT($result_points);