0) { // Load entries only from a single user $add = sprintf(" AND `userid`=%s", bigintval($userid)); $mode = 'member'; $COLS = 4; $DT_MODE = 2; $message = getMessage('DOUBLER_MEMBER_NO_ENTRIES_FOUND'); } else { // Guest mode! $mode = 'guest'; $COLS = 3; $DT_MODE = 3; $message = getMessage('DOUBLER_GUEST_NO_ENTRIES_FOUND'); } if (($done == 'Y') && ($sort == 'ASC')) { // Already payed out points (latest payouts first) $limit = getConfig('doubler_display_old'); } elseif ($sort == 'ASC') { // List entries which will receive their payout soon $limit = getConfig('doubler_display_pay'); } elseif ($sort == 'DESC') { // Newest entries $limit = getConfig('doubler_display_new'); } // List entries $result = SQL_QUERY("SELECT `userid`, `refid`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_doubler` WHERE `completed`='".$done."' AND `is_ref`='".$ref."'".$add." ORDER BY `timemark` ".$sort." LIMIT ".$limit, __FUNCTION__, __LINE__); if (SQL_NUMROWS($result) > 0) { // List entries $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { // Rewrite userid/refid only if admin is in if (isAdmin()) { // Set links to admin area if ($content['userid'] > 0) { $content['userid'] = generateUserProfileLink($content['userid']); } else { $content['userid'] = '---'; } if ($content['refid'] > 0) { $content['refid'] = generateUserProfileLink($content['refid']); } else { $content['refid'] = '---'; } } // END - if // Prepare data for the row template $content = array( 'userid' => $content['userid'], 'rid' => $content['refid'], 'points' => translateComma($content['points']), 'timemark' => generateDateTime($content['timemark'], $DT_MODE), 'sw' => $SW, ); // Load template and switch color $OUT .= loadTemplate($mode . '_doubler_list_rows', true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); } else { // List no entries $OUT = "