X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-reflist.php;h=456c45fb0bc73c174721f94b22e91302b96f3648;hp=0ebafb38c36c80b710f6ada254b9cae9f8cc18a0;hb=155492a5b96cec674846973a8524238b0365a848;hpb=aa63aed07428a99ea09002c8d072990677700080 diff --git a/inc/modules/member/what-reflist.php b/inc/modules/member/what-reflist.php index 0ebafb38c3..456c45fb0b 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__); +// Load all referral levels +$result = sqlQuery('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) { +if (!ifSqlHasZeroNums($result)) { // List all levels $OUT = ''; - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result)) { // Init variables $rows = ''; - $counter = 0; - $SW = 2; + $counter = '0'; // Check for users ref in this level - foreach (GET_USER_REF_POINTS(getUserId(), $content['level']) as $refRow) { + foreach (getUserReferralPoints(getMemberId(), $content['level']) as $refRow) { // Add/"translate" more content - $refRow['sw'] = $SW; - $refRow['points'] = TRANSLATE_COMMA($refRow['points']); - $refRow['status'] = TRANSLATE_STATUS($refRow['status']); - $refRow['unconfirmed'] = TRANSLATE_COMMA($refRow['unconfirmed']); - $refRow['clickrate'] = TRANSLATE_COMMA($refRow['clickrate'], true, 1); - if (empty($refRow['nickname'])) $refRow['nickname'] = '---'; + $refRow['click_rate'] = translateComma($refRow['click_rate'], TRUE, 1); // Load row template - $rows .= LOAD_TEMPLATE("member_ref_list_row", true, $refRow); + $rows .= loadTemplate('member_list_referral_row', TRUE, $refRow); // Count this ref and switch color $counter++; - $SW = 3 - $SW; } // END - foreach // Remember the content - $content['counter'] = TRANSLATE_COMMA($counter); - $content['percents'] = TRANSLATE_COMMA($content['percents'], true, 1); + $content['counter'] = $counter; + $content['percents'] = translateComma($content['percents'], TRUE, 1); $content['rows'] = $rows; // Load level template - $OUT .= LOAD_TEMPLATE("member_ref_list_level", true, $content); + $OUT .= loadTemplate('member_list_referral_level', TRUE, $content); } // END - while // Load main template - LOAD_TEMPLATE("member_ref_list", false, $OUT); + loadTemplate('member_list_referral', FALSE, $OUT); } else { // No entries - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('MEMBER_REFBACK_NO_ENTRIES')); + displayMessage('{--MEMBER_REFBACK_NO_ENTRIES--}'); } // Free result -SQL_FREERESULT($result); +sqlFreeResult($result); -// +// [EOF] ?>