X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=8db1add8eec3f395088e332ae3afecb487848b6a;hp=246e0e31402819f3977cc7501045cbc250ec5919;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=cf3765c38cf0a76f396aca291f71858936e92956 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index 246e0e3140..8db1add8ee 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -14,11 +14,9 @@ * $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 * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -47,43 +45,34 @@ if (!defined('__SECURITY')) { } // Add description as navigation point -addMenuDescription('member', __FILE__); +addYouAreHereLink('member', __FILE__); if ((!isExtensionActive('payout')) && (!isAdmin())) { - loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('payout')); + displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=payout%}'); 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'; +$payoutPoints = getPayoutPoints(getMemberId()); if (!isGetRequestParameterSet('payout')) { // Load payout types $result = SQL_QUERY_ESC("SELECT - `id`, `type`, `rate`, `min_points`, `allow_url` + `id`,`type`,`rate`,`min_points`,`allow_url` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE %s >= `min_points` ORDER BY `type` ASC", - array($totalPoints), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + array($payoutPoints), __FILE__, __LINE__); + 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 +84,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'] = '
' . $content['status'] . '
'; - // Nothing entered must be secured in member/what-payputs.php ! if ($content['allow'] == 'Y') { // Banner/Textlink views/clicks request if (!empty($content['banner'])) { // Banner - $content['target_account'] = '' . $content['alt'] . ''; + $content['target_account'] = '' . $content['link_text'] . ''; } else { // Textlink - $content['target_account'] = $content['alt']; + $content['target_account'] = $content['link_text']; } $content['target_bank'] = '{--CLICK_HERE--}'; } // END - if // Prepare data for the template - $content = array( - 'target_account' => $content['target_account'], - 'payout_total' => $content['payout_total'], - 'target_bank' => $content['target_bank'], - 'payout_timestamp' => generateDateTime($content['payout_timestamp'], 2), - 'status' => $content['status'], - 'type' => $content['type'], - ); + $content['payout_timestamp'] = generateDateTime($content['payout_timestamp'], 2); // Load row template and switch colors $OUT .= loadTemplate('member_payout_row', true, $content); @@ -138,14 +116,14 @@ ORDER BY SQL_FREERESULT($result_payouts); // Output payout list - outputPayoutList($totalPoints); + outputPayoutList($payoutPoints); } else { // No payout types setup - loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}'); + displayMessage('{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}'); } } else { // Chedk if he can get paid by selected type - $result = SQL_QUERY_ESC("SELECT `type`, `rate`, `min_points`, `allow_url` AS allow FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `type`,`rate`,`min_points`,`allow_url` AS allow FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1", array(bigintval(getRequestParameter('payout'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { @@ -153,7 +131,7 @@ ORDER BY $content = SQL_FETCHARRAY($result); // Calculate maximum value - $max = round($totalPoints * $content['rate'] - 0.5); + $max = round($payoutPoints * $content['rate'] - 0.5); $PAY_MAX = '0'; // Calulcate points from submitted amount @@ -164,27 +142,27 @@ ORDER BY } // Has enougth points to payout? - if ($totalPoints >= $content['min_points']) { + if ($payoutPoints >= $content['min_points']) { // Ok, he can get be paid if ((isFormSent()) && ($points <= $PAY_MAX) && ($points >= $content['min_points'])) { // Remember points in array - setPostRequestParameter('payout_points', translateComma($points)); + setPostRequestParameter('payout_points', $points); setPostRequestParameter('type' , $content['type']); - // Subtract points from member's account + // Subtract points from member's account and ignore return status subtractPoints('payout', getMemberId(), $points); // Add entry to his tranfer history if ($content['allow'] == 'Y') { // Banner/textlink ordered - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_payouts` (`userid`, `payout_total`, `payout_id`, `payout_timestamp`, `status`, `target_url`, `link_text`, `banner_url`) + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_payouts` (`userid`,`payout_total`,`payout_id`,`payout_timestamp`,`status`,`target_url`,`link_text`,`banner_url`) VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", array( getMemberId(), bigintval(postRequestParameter('payout')), bigintval(getRequestParameter('payout')), postRequestParameter('turl'), - postRequestParameter('alt'), + postRequestParameter('link_text'), postRequestParameter('banner') ), __FILE__, __LINE__); @@ -197,7 +175,7 @@ VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", } } else { // e-currency payout requested - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_payouts` (`userid`, `payout_total`, `target_account`, `target_bank`, `payout_id`, `payout_timestamp`, `status`, `password`) + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_payouts` (`userid`,`payout_total`,`target_account`,`target_bank`,`payout_id`,`payout_timestamp`,`status`,`password`) VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", array( getMemberId(), @@ -205,7 +183,7 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", bigintval(postRequestParameter('account')), postRequestParameter('bank'), bigintval(getRequestParameter('payout')), - postRequestParameter('pass') + postRequestParameter('password') ), __FILE__, __LINE__); // Load templates @@ -229,7 +207,7 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", sendAdminNotification('{--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $admin_tpl, postRequestArray(), getMemberId()); // Load template and output it - loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_REQUEST_SENT--}'); + displayMessage('{--MEMBER_PAYOUT_REQUEST_SENT--}'); } elseif ($content['allow'] == 'Y') { // Prepare content $content = array( @@ -253,11 +231,11 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", } } else { // Not enougth points - loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_POINTS_NOT_ENOUGTH--}'); + displayMessage('{--MEMBER_PAYOUT_POINTS_NOT_ENOUGTH--}'); } } else { // id is invalid - loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_ID_INVALID--}'); + displayMessage('{--MEMBER_PAYOUT_ID_INVALID--}'); } // Free result