X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=8cc6bc730de05b1ba390de38456cdb85673b2830;hp=edb05b80424fb096c29798ba73caf3bcfb007072;hb=61621983cc6d7195fcc7eab29b5f6080ff283b34;hpb=30ae22f62ae87c53a56baf0d134569ba91011111 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index edb05b8042..8cc6bc730d 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.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 - 2016 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 * @@ -40,152 +38,161 @@ // Some security stuff... if (!defined('__SECURITY')) { // Don't call this directly! - die(); + exit(); } elseif (!isMember()) { // Not logged in redirectToIndexMemberOnlyModule(); } // 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); +$payoutPoints = getPayoutPoints(getMemberId()); -// Sanity check... -if (empty($totalPoints)) $totalPoints = '0.00000'; +// Output amount +displayMessage('{%message,MEMBER_TOTAL_PAYOUT_POINTS=' . $payoutPoints . '%}'); -if (!isGetRequestParameterSet('payout')) { +// GET parameter set? +if (!isGetRequestElementSet('payout')) { // Load payout types - $result = SQL_QUERY_ESC("SELECT - `id`, `type`, `rate`, `min_points`, `allow_url` + $result = sqlQueryEscaped('SELECT + `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_HASZERONUMS($result)) { - // Free memory - SQL_FREERESULT($result); + `type` ASC', + array($payoutPoints), __FILE__, __LINE__); + // Some entries found? + if (!ifSqlHasZeroNumRows($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 + $result_payouts = sqlQueryEscaped('SELECT + `p`.`id`, + `p`.`payout_total`, + `p`.`target_account`, + `p`.`target_bank`, + `t`.`type`, + `p`.`payout_timestamp`, + `p`.`status`, + `t`.`allow_url`, + `p`.`target_url`, + `p`.`link_text`, + `p`.`banner_url` FROM - `{?_MYSQL_PREFIX?}_user_payouts` AS p + `{?_MYSQL_PREFIX?}_user_payouts` AS `p` LEFT JOIN - `{?_MYSQL_PREFIX?}_payout_types` AS t + `{?_MYSQL_PREFIX?}_payout_types` AS `t` ON - p.payout_id = t.id + `p`.`payout_id`=`t`.`id` WHERE - p.userid = %s + `p`.`userid`=%s ORDER BY - p.payout_timestamp DESC", + `p`.`payout_timestamp` DESC', array(getMemberId()), __FILE__, __LINE__); - if (!SQL_HASZERONUMS($result_payouts)) { + if (!ifSqlHasZeroNumRows($result_payouts)) { // List all his requests $OUT = ''; - while ($content = SQL_FETCHARRAY($result_payouts)) { - // Translate status - $content['status'] = translatePayoutStatus(); - $content['status'] = '
' . $content['status'] . '
'; - + while ($content = sqlFetchArray($result_payouts)) { // Nothing entered must be secured in member/what-payputs.php ! - if ($content['allow'] == 'Y') { + if ($content['allow_url'] == '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--}'; + $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); + $OUT .= loadTemplate('member_payout_row', TRUE, $content); } // END - while // Load template - loadTemplate('member_payout', false, $OUT); + loadTemplate('member_payout', FALSE, $OUT); } // END - if // Free memory - SQL_FREERESULT($result_payouts); + sqlFreeResult($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_LOW_POINTS--}'); } + + // Free memory + sqlFreeResult($result); } 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", - array(bigintval(getRequestParameter('payout'))), __FILE__, __LINE__); + $result = sqlQueryEscaped('SELECT + `type`, + `rate`, + `min_points`, + `allow_url` +FROM + `{?_MYSQL_PREFIX?}_payout_types` +WHERE + `id`=%s +LIMIT 1', + array(bigintval(getRequestElement('payout'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // id is valid so load the data - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($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 $points = '0'; - if (isPostRequestParameterSet('payout')) { - $points = bigintval(postRequestParameter('payout')) / $content['rate']; + if (isPostRequestElementSet('payout')) { + $points = bigintval(postRequestElement('payout')) / $content['rate']; $PAY_MAX = $max / $content['rate']; - } + } // END - if // 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('type' , $content['type']); + setPostRequestElement('payout_points', $points); + setPostRequestElement('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') { + if ($content['allow_url'] == '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`) + sqlQueryEscaped("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('banner') + bigintval(postRequestElement('payout')), + bigintval(getRequestElement('payout')), + postRequestElement('turl'), + postRequestElement('link_text'), + postRequestElement('banner') ), __FILE__, __LINE__); // Load templates @@ -197,15 +204,15 @@ 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`) + sqlQueryEscaped("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(), - bigintval(postRequestParameter('payout')), - bigintval(postRequestParameter('account')), - postRequestParameter('bank'), - bigintval(getRequestParameter('payout')), - postRequestParameter('pass') + bigintval(postRequestElement('payout')), + bigintval(postRequestElement('account')), + postRequestElement('bank'), + bigintval(getRequestElement('payout')), + postRequestElement('password') ), __FILE__, __LINE__); // Load templates @@ -229,39 +236,39 @@ 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--}'); - } elseif ($content['allow'] == 'Y') { + displayMessage('{--MEMBER_PAYOUT_REQUEST_SENT--}'); + } elseif ($content['allow_url'] == 'Y') { // Prepare content $content = array( 'max' => $max, 'type' => $content['type'], - 'payout' => bigintval(getRequestParameter('payout')) + 'payout' => bigintval(getRequestElement('payout')) ); // Generate banner order form - loadTemplate('member_payout_form_banner', false, $content); + loadTemplate('member_payout_form_banner', FALSE, $content); } else { // Prepare content $content = array( 'max' => $max, 'type' => $content['type'], - 'payout' => bigintval(getRequestParameter('payout')) + 'payout' => bigintval(getRequestElement('payout')) ); // Generate normal form - loadTemplate('member_payout_form', false, $content); + loadTemplate('member_payout_form', FALSE, $content); } } 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 - SQL_FREERESULT($result); + sqlFreeResult($result); } // [EOF]