X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fpayout_functions.php;h=1447dda5b4bef0ca9aaf100b3d27897c07d46e9b;hb=b941cf55d76e1349c7e9c29e116fbf708664a06b;hp=8cdac37d2bfad5492290452371209a3943d99795;hpb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;p=mailer.git diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php index 8cdac37d2b..1447dda5b4 100644 --- a/inc/libs/payout_functions.php +++ b/inc/libs/payout_functions.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * 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 * * it under the terms of the GNU General Public License as published by * @@ -47,16 +45,22 @@ 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_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { + // Init output + $OUT = ''; + // Now let's check while ($content = SQL_FETCHARRAY($result)) { // Are these points enougth? @@ -65,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_saved', false, '
{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}
'); + loadTemplate('admin_settings_unsaved', FALSE, '{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}'); } // Free memory SQL_FREERESULT($result); } else { // Points is empty - loadTemplate('admin_settings_saved', false, '
{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}
'); + loadTemplate('admin_settings_unsaved', FALSE, '{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}'); } } @@ -90,6 +94,19 @@ function translatePayoutStatus ($status) { $message = '{--PAYOUT_STATUS_' . strtoupper($status) . '--}'; // Return it + return $message; +} + +// "Getter" for payoutable user points +function getPayoutPoints ($userid) { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__][$userid])) { + // Determine it + $GLOBALS[__FUNCTION__][$userid] = countSumTotalData($userid, 'user_points', 'points') - getUserUsedPoints($userid); + } // END - if + + // Return it + return $GLOBALS[__FUNCTION__][$userid]; } // [EOF]