X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=edb05b80424fb096c29798ba73caf3bcfb007072;hb=30ae22f62ae87c53a56baf0d134569ba91011111;hp=00e3bc455354379624680eb245462575e35646f3;hpb=1bf7c189fda17ce6c702f600c0eb084b681a307b;p=mailer.git diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index 00e3bc4553..edb05b8042 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -18,6 +18,7 @@ * 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 * * * * This program is free software; you can redistribute it and/or modify * @@ -53,28 +54,8 @@ if ((!isExtensionActive('payout')) && (!isAdmin())) { return; } // END - if -$result_depths = SQL_QUERY("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY level", __FILE__, __LINE__); -$totalPoints = '0'; -while ($content = SQL_FETCHARRAY($result_depths)) { - // Load referal points - $result_points = SQL_QUERY_ESC("SELECT `points` FROM `{?_MYSQL_PREFIX?}_user_points` WHERE `userid`=%s AND `ref_depth`='%s' LIMIT 1", - array(getMemberId(), bigintval($content['level'])), __FILE__, __LINE__); - - // Entry found? - if (SQL_NUMROWS($result_points) == 1) { - // Load points - list($points) = SQL_FETCHROW($result_points); - - // Add them to total - $totalPoints += $points; - } // END - if - - // Free result - SQL_FREERESULT($result_points); -} // END - while - -// Free memory -SQL_FREERESULT($result_depths); +// Get total points +$totalPoints = countSumTotalData(getMemberId(), 'user_points', 'points'); // Get used points $usedPoints = countSumTotalData(getMemberId(), 'user_data', 'used_points'); @@ -85,7 +66,7 @@ $totalPoints = ($totalPoints - $usedPoints); // Sanity check... if (empty($totalPoints)) $totalPoints = '0.00000'; -if (!isGetRequestElementSet('payout')) { +if (!isGetRequestParameterSet('payout')) { // Load payout types $result = SQL_QUERY_ESC("SELECT `id`, `type`, `rate`, `min_points`, `allow_url` @@ -96,7 +77,7 @@ WHERE ORDER BY `type` ASC", array($totalPoints), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Free memory SQL_FREERESULT($result); @@ -114,12 +95,12 @@ 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 = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result_payouts)) { // Translate status - $content['status'] = getMessage('PAYOUT_MEMBER_STATUS_'.strtoupper($content['status']).''); + $content['status'] = translatePayoutStatus(); $content['status'] = '
' . $content['status'] . '
'; // Nothing entered must be secured in member/what-payputs.php ! @@ -127,36 +108,31 @@ ORDER BY // Banner/Textlink views/clicks request if (!empty($content['banner'])) { // Banner - $content['target_account'] = "\"".$content['alt']."\""; + $content['target_account'] = '' . $content['alt'] . ''; } else { // Textlink $content['target_account'] = $content['alt']; } - $content['target_bank'] = "{--CLICK_HERE--}"; - } else { - // e-currency payout request - if (empty($content['target_account'])) $content['target_account'] = '---'; - if (empty($content['target_bank'])) $content['target_bank'] = '---'; - } + $content['target_bank'] = '{--CLICK_HERE--}'; + } // END - if // Prepare data for the template $content = array( - 'sw' => $SW, 'target_account' => $content['target_account'], - 'points' => translateComma($content['payout_total']) . ' ' . $content['type'], + 'payout_total' => $content['payout_total'], 'target_bank' => $content['target_bank'], 'payout_timestamp' => generateDateTime($content['payout_timestamp'], 2), - 'status' => $content['status'] + 'status' => $content['status'], + 'type' => $content['type'], ); // Load row template and switch colors $OUT .= loadTemplate('member_payout_row', true, $content); - $SW = 3 - $SW; - } + } // END - while // Load template loadTemplate('member_payout', false, $OUT); - } + } // END - if // Free memory SQL_FREERESULT($result_payouts); @@ -165,12 +141,12 @@ ORDER BY outputPayoutList($totalPoints); } else { // No payout types setup - loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_NO_PAYOUT_TYPES')); + loadTemplate('admin_settings_saved', false, '{--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", - array(bigintval(getRequestElement('payout'))), __FILE__, __LINE__); + $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) { // id is valid so load the data @@ -182,8 +158,8 @@ ORDER BY // Calulcate points from submitted amount $points = '0'; - if (isPostRequestElementSet('payout')) { - $points = bigintval(postRequestElement('payout')) / $content['rate']; + if (isPostRequestParameterSet('payout')) { + $points = bigintval(postRequestParameter('payout')) / $content['rate']; $PAY_MAX = $max / $content['rate']; } @@ -192,8 +168,8 @@ ORDER BY // Ok, he can get be paid if ((isFormSent()) && ($points <= $PAY_MAX) && ($points >= $content['min_points'])) { // Remember points in array - setRequestPostElement('payout_points', translateComma($points)); - setRequestPostElement('type' , $content['type']); + setPostRequestParameter('payout_points', translateComma($points)); + setPostRequestParameter('type' , $content['type']); // Subtract points from member's account subtractPoints('payout', getMemberId(), $points); @@ -205,16 +181,16 @@ ORDER BY VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", array( getMemberId(), - bigintval(postRequestElement('payout')), - bigintval(getRequestElement('payout')), - postRequestElement('turl'), - postRequestElement('alt'), - postRequestElement('banner') + bigintval(postRequestParameter('payout')), + bigintval(getRequestParameter('payout')), + postRequestParameter('turl'), + postRequestParameter('alt'), + postRequestParameter('banner') ), __FILE__, __LINE__); // Load templates $message_mem = loadEmailTemplate('member_payout_request_banner', postRequestArray(), getMemberId()); - if (getExtensionVersion('admins') >= '0.4.1') { + if (isExtensionInstalledAndNewer('admins', '0.4.1')) { $adm_tpl = 'admin_payout_request_banner'; } else { $message_adm = loadEmailTemplate('admin_payout_request_banner', postRequestArray(), getMemberId()); @@ -225,11 +201,11 @@ VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", array( getMemberId(), - bigintval(postRequestElement('payout')), - bigintval(postRequestElement('account')), - postRequestElement('bank'), - bigintval(getRequestElement('payout')), - postRequestElement('pass') + bigintval(postRequestParameter('payout')), + bigintval(postRequestParameter('account')), + postRequestParameter('bank'), + bigintval(getRequestParameter('payout')), + postRequestParameter('pass') ), __FILE__, __LINE__); // Load templates @@ -238,28 +214,28 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", $admin_tpl = ''; // @TODO Rewrite this to a filter - if (getExtensionVersion('admins') >= '0.4.1') { + if (isExtensionInstalledAndNewer('admins', '0.4.1')) { $admin_tpl = 'admin_payout_request'; } // END - if } - // Generate task - createNewTask('[payout:] {--PAYOUT_REQUEST_ADMIN--}', $message_adm, 'PAYOUT_REQUEST', getMemberId()); + // Generate task (we ignore the task id here) + createNewTask('[payout:] {--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $message_adm, 'PAYOUT_REQUEST', getMemberId()); // Send out mails - sendEmail(getMemberId(), getMessage('PAYOUT_REQUEST_MEMBER'), $message_mem); + sendEmail(getMemberId(), '{--MEMBER_PAYOUT_REQUEST_SUBJECT--}', $message_mem); // To admin(s) - sendAdminNotification(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, postRequestArray(), getMemberId()); + sendAdminNotification('{--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $admin_tpl, postRequestArray(), getMemberId()); // Load template and output it - loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_REQUEST_SENT')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_REQUEST_SENT--}'); } elseif ($content['allow'] == 'Y') { // Prepare content $content = array( 'max' => $max, 'type' => $content['type'], - 'payout' => bigintval(getRequestElement('payout')) + 'payout' => bigintval(getRequestParameter('payout')) ); // Generate banner order form @@ -269,7 +245,7 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", $content = array( 'max' => $max, 'type' => $content['type'], - 'payout' => bigintval(getRequestElement('payout')) + 'payout' => bigintval(getRequestParameter('payout')) ); // Generate normal form @@ -277,11 +253,11 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", } } else { // Not enougth points - loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_POINTS_NOT_ENOUGTH')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_POINTS_NOT_ENOUGTH--}'); } } else { // id is invalid - loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_ID_INVALID')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_PAYOUT_ID_INVALID--}'); } // Free result