X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=26ae46ee72716ddb11b0ab73a2c1736c23219205;hb=34db702d004b245e5528b0ba20c6de441f61820a;hp=246e0e31402819f3977cc7501045cbc250ec5919;hpb=32fed28f469610c8bfdec7f18089cceea9e15df0;p=mailer.git diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index 246e0e3140..26ae46ee72 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -54,17 +54,8 @@ if ((!isExtensionActive('payout')) && (!isAdmin())) { return; } // END - if -// Get total points -$totalPoints = countSumTotalData(getMemberId(), 'user_points', 'points'); - -// Get used points -$usedPoints = countSumTotalData(getMemberId(), 'user_data', 'used_points'); - // Translate point into comma -$totalPoints = ($totalPoints - $usedPoints); - -// Sanity check... -if (empty($totalPoints)) $totalPoints = '0.00000'; +$totalPoints = getTotalPoints(getMemberId()); if (!isGetRequestParameterSet('payout')) { // Load payout types @@ -77,13 +68,13 @@ WHERE ORDER BY `type` ASC", array($totalPoints), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Free memory SQL_FREERESULT($result); // Check for his payouts $result_payouts = SQL_QUERY_ESC("SELECT - p.id, p.payout_total, p.target_account, p.target_bank, t.type, p.payout_timestamp, p.status, t.allow_url AS allow, p.target_url AS url, p.link_text AS alt, p.banner_url AS banner + p.id, p.payout_total, p.target_account, p.target_bank, t.type, p.payout_timestamp, p.status, t.allow_url AS allow, p.target_url AS url, p.link_text, p.banner_url AS banner FROM `{?_MYSQL_PREFIX?}_user_payouts` AS p LEFT JOIN @@ -95,36 +86,25 @@ WHERE ORDER BY p.payout_timestamp DESC", array(getMemberId()), __FILE__, __LINE__); - if (SQL_NUMROWS($result_payouts) > 0) { + if (!SQL_HASZERONUMS($result_payouts)) { // List all his requests $OUT = ''; while ($content = SQL_FETCHARRAY($result_payouts)) { - // Translate status - $content['status'] = translatePayoutStatus(); - $content['status'] = '