X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-refback.php;h=9d1525d2de5059daf4e15fd970968dc165864a63;hb=adb34cea9c14bcac14030f8eb1e6ae2c3231c962;hp=e2fd4870d96086201a4dc31e25952f39d1deecb6;hpb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b;p=mailer.git diff --git a/inc/modules/member/what-refback.php b/inc/modules/member/what-refback.php index e2fd4870d9..9d1525d2de 100644 --- a/inc/modules/member/what-refback.php +++ b/inc/modules/member/what-refback.php @@ -1,7 +1,7 @@ 0 -ORDER BY r.level ASC", -array(getMemberId()), __FILE__, __LINE__); +$result = SQL_QUERY_ESC("SELECT + r.level, r.percents +FROM + `{?_MYSQL_PREFIX?}_refdepths` AS r +WHERE + r.level > 0 +ORDER BY + r.level ASC", + array(getMemberId()), __FILE__, __LINE__); // Are there some entries? (Shall be!) if (SQL_NUMROWS($result) > 0) {