X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fpayout_functions.php;h=aaadcc95d6854802e629251f7f8f74b8ad6b2691;hb=c0c6d5d58bdecd22bdcf7dfe5b24bec69e1810c7;hp=7dea181c693d4411d0b977de9598bd8964e1884b;hpb=e48301e44eabe4d99982ed87f321db73c23961a6;p=mailer.git diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php index 7dea181c69..aaadcc95d6 100644 --- a/inc/libs/payout_functions.php +++ b/inc/libs/payout_functions.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -45,14 +45,17 @@ function outputPayoutList ($points) { // Enougth points? if ($points > 0) { // Pay this out! - $result = SQL_QUERY_ESC("SELECT - `id`,`type`,`rate`,`min_points` + $result = SQL_QUERY_ESC('SELECT + `id`, + `type`, + `rate`, + `min_points` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE %s >= `min_points` ORDER BY - `type` ASC", + `type` ASC', array($points), __FUNCTION__, __LINE__); if (!SQL_HASZERONUMS($result)) { // Init output @@ -66,22 +69,22 @@ ORDER BY $content['points'] = translateComma($points * $content['rate'] - 0.5); // Load row template - $OUT .= loadTemplate('member_payout_li', true, $content); + $OUT .= loadTemplate('member_payout_li', TRUE, $content); } // END - if } // END - while // Load main template - loadTemplate('member_payout_list', true, $OUT); + loadTemplate('member_payout_list', TRUE, $OUT); } else { // No payout types setup so far - loadTemplate('admin_settings_unsaved', false, '{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}'); + displayErrorMessage('{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}'); } // Free memory SQL_FREERESULT($result); } else { // Points is empty - loadTemplate('admin_settings_unsaved', false, '{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}'); + displayErrorMessage('{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}'); } } @@ -96,10 +99,10 @@ function translatePayoutStatus ($status) { // "Getter" for payoutable user points function getPayoutPoints ($userid) { - // Do we have cache? + // Is there cache? if (!isset($GLOBALS[__FUNCTION__][$userid])) { // Determine it - $GLOBALS[__FUNCTION__][$userid] = countSumTotalData($userid, 'user_points', 'points') - countSumTotalData($userid, 'user_data', 'used_points'); + $GLOBALS[__FUNCTION__][$userid] = countSumTotalData($userid, 'user_points', 'points') - getUserUsedPoints($userid); } // END - if // Return it