X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-reflist.php;h=d4b3e97f5e450ded54fe9d46a9c01706b612535a;hb=968b5160ae624519f1a9491f00e0aeadf25729fb;hp=b49e0bd75161b353b12da40c23480e374d981425;hpb=1ebf518b9552f71ee95de6f4b80e6de3a27716d1;p=mailer.git diff --git a/inc/modules/member/what-reflist.php b/inc/modules/member/what-reflist.php index b49e0bd751..d4b3e97f5e 100644 --- a/inc/modules/member/what-reflist.php +++ b/inc/modules/member/what-reflist.php @@ -1,7 +1,7 @@ 0 -ORDER BY r.level ASC", -array(getUserId()), __FILE__, __LINE__); +$result = SQL_QUERY('SELECT + `level`, `percents` +FROM + `{?_MYSQL_PREFIX?}_refdepths` +WHERE + `level` > 0 +ORDER BY + `level` ASC', __FILE__, __LINE__); // Are there some entries? (Shall be!) if (SQL_NUMROWS($result) > 0) { @@ -61,29 +65,22 @@ if (SQL_NUMROWS($result) > 0) { while ($content = SQL_FETCHARRAY($result)) { // Init variables $rows = ''; - $counter = 0; - $SW = 2; + $counter = '0'; // Check for users ref in this level - foreach (getUserReferalPoints(getUserId(), $content['level']) as $refRow) { + foreach (getUserReferalPoints(getMemberId(), $content['level']) as $refRow) { // Add/"translate" more content - $refRow['sw'] = $SW; - $refRow['points'] = translateComma($refRow['points']); - $refRow['status'] = translateUserStatus($refRow['status']); - $refRow['unconfirmed'] = translateComma($refRow['unconfirmed']); $refRow['clickrate'] = translateComma($refRow['clickrate'], true, 1); - if (empty($refRow['nickname'])) $refRow['nickname'] = '---'; // Load row template $rows .= loadTemplate('member_ref_list_row', true, $refRow); // Count this ref and switch color $counter++; - $SW = 3 - $SW; } // END - foreach // Remember the content - $content['counter'] = translateComma($counter); + $content['counter'] = $counter; $content['percents'] = translateComma($content['percents'], true, 1); $content['rows'] = $rows; @@ -95,11 +92,11 @@ if (SQL_NUMROWS($result) > 0) { loadTemplate('member_ref_list', false, $OUT); } else { // No entries - loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_NO_ENTRIES')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_REFBACK_NO_ENTRIES--}'); } // Free result SQL_FREERESULT($result); -// +// [EOF] ?>