X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=5c6e5e2c9ec04fa73a8f350ea070b36f6ba03ca6;hp=ad4ef86afc75992b5b0f290c25fd112eb8f3fc10;hb=5071030af40e69ca4284642f44758964e18f5be8;hpb=b8c86fa12322603c24a88ea2b0fd3dbeba612752 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index ad4ef86afc..5c6e5e2c9e 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Auszahlungsanfragen * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -34,25 +39,25 @@ // Some security stuff... if (!defined('__SECURITY')) { // Don't call this directly! - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } elseif (!IS_MEMBER()) { // Not logged in - LOAD_URL("modules.php?module=index"); -} elseif ((!EXT_IS_ACTIVE("payout")) && (!IS_ADMIN())) { - addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "payout"); + redirectToUrl('modules.php?module=index'); +} elseif ((!EXT_IS_ACTIVE('payout')) && (!IS_ADMIN())) { + addFatalMessage(__FILE__, __LINE__, sprintf(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), 'payout')); return; } // Add description as navigation point -ADD_DESCR("member", __FILE__); +ADD_DESCR('member', __FILE__); $result_depths = SQL_QUERY("SELECT level, percents FROM `{!_MYSQL_PREFIX!}_refdepths` ORDER BY level", __FILE__, __LINE__); $TPTS = 0; -while (list($lvl, $per) = SQL_FETCHROW($result_depths)) { +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=%d LIMIT 1", - array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__); + array(getUserId(), bigintval($content['level'])), __FILE__, __LINE__); // Entry found? if (SQL_NUMROWS($result_points) == 1) { @@ -71,10 +76,10 @@ while (list($lvl, $per) = SQL_FETCHROW($result_depths)) { SQL_FREERESULT($result_depths); // Get used points -$USED = GET_TOTAL_DATA($GLOBALS['userid'], "user_data", "used_points"); +$USED = GET_TOTAL_DATA(getUserId(), "user_data", "used_points"); // Translate point into comma -$TPTS = TRANSLATE_COMMA($TPTS - $USED); +$TPTS = translateComma($TPTS - $USED); // Sanity check... if (empty($TPTS)) $TPTS = "0.00000"; @@ -84,59 +89,63 @@ if (!REQUEST_ISSET_GET(('payout'))) { $result = SQL_QUERY_ESC("SELECT id, type, rate, min_points, allow_url FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE %s >= min_points -ORDER BY type", array(REVERT_COMMA($TPTS)), __FILE__, __LINE__); +ORDER BY type ASC", + array(convertCommaToDot($TPTS)), __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Free memory SQL_FREERESULT($result); // Check for his payouts - $result_payouts = SQL_QUERY_ESC("SELECT DISTINCT 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 bannerm + $result_payouts = SQL_QUERY_ESC("SELECT DISTINCT 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 FROM `{!_MYSQL_PREFIX!}_user_payouts` AS p LEFT JOIN `{!_MYSQL_PREFIX!}_payout_types` AS t ON p.payout_id = t.id WHERE p.userid = %s ORDER BY p.payout_timestamp DESC", - array($GLOBALS['userid']), __FILE__, __LINE__); + array(getUserId()), __FILE__, __LINE__); if (SQL_NUMROWS($result_payouts) > 0) { // List all his requests - $SW = 2; $OUT = ""; - while (list($pid, $total, $account, $bank, $type, $tstamp, $status, $allow, $url, $alt, $banner) = SQL_FETCHROW($result_payouts)) { + $OUT = ''; $SW = 2; + while ($content = SQL_FETCHARRAY($result_payouts)) { // Translate status - $status = constant('PAYOUT_MEMBER_STATUS_'.strtoupper($status).''); - $status = "
".$status."
"; + $content['status'] = getMessage('PAYOUT_MEMBER_STATUS_'.strtoupper($content['status']).''); + $content['status'] = "
".$content['status']."
"; // Nothing entered must be secured in member/what-payputs.php ! - if ($allow == "Y") { + if ($content['allow'] == 'Y') { // Banner/Textlink views/clicks request - if (!empty($banner)) { + if (!empty($content['banner'])) { // Banner - $account = "\"".$alt."\""; + $content['target_account'] = "\"".$content['alt']."\""; } else { // Textlink - $account = $alt; + $content['target_account'] = $content['alt']; } - $bank = "{--CLICK_HERE--}"; + $content['target_bank'] = "{--CLICK_HERE--}"; } else { // e-currency payout request - if (empty($account)) $account = "---"; - if (empty($bank)) $bank = "---"; + if (empty($content['target_account'])) $content['target_account'] = '---'; + if (empty($content['target_bank'])) $content['target_bank'] = '---'; } // Prepare data for the template + // @TODO Rewritings: acc->target_account,bank->target_bank in templates $content = array( 'sw' => $SW, - 'acc' => $account, - 'points' => TRANSLATE_COMMA($total)." ".COMPILE_CODE($type), - 'bank' => $bank, - 'stamp' => MAKE_DATETIME($tstamp, "2"), - 'status' => $status + 'acc' => $content['target_account'], + 'points' => translateComma($content['payout_total'])." ".COMPILE_CODE($content['type']), + 'bank' => $content['target_bank'], + 'stamp' => generateDateTime($content['payout_timestamp'], '2'), + 'status' => $content['status'] ); + // Load row template and switch colors $OUT .= LOAD_TEMPLATE("member_payout_row", true, $content); $SW = 3 - $SW; } // Remember rows in constant + // @TODO Rewrite this constant define('__PAYOUT_ROWS', $OUT); // Load template @@ -151,77 +160,80 @@ ORDER BY p.payout_timestamp DESC", } } else { // Chedk if he can get paid by selected type - $result = SQL_QUERY_ESC("SELECT type, rate, min_points, allow_url FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1", - array(bigintval(REQUEST_GET('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(REQUEST_GET('payout'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { - // ID is valid - list($type, $rate, $min, $allow) = SQL_FETCHROW($result); + // ID is valid so load the data + $content = SQL_FETCHARRAY($result); SQL_FREERESULT($result); // Calculate maximum value - $max = round($TPTS * $rate - 0.5); + $max = round($TPTS * $content['rate'] - 0.5); // Calulcate points from submitted amount $PAYOUT = 0; if (REQUEST_ISSET_POST(('payout'))) { - $PAYOUT = bigintval(REQUEST_POST('payout')) / $rate; - $PAY_MAX = $max / $rate; + $PAYOUT = bigintval(REQUEST_POST('payout')) / $content['rate']; + $PAY_MAX = $max / $content['rate']; } // Move variables into constants for templates + // @TODO Rewrite these constants define('PAYOUT_MAX_VALUE' , $max); - define('PAYOUT_TYPE_VALUE', COMPILE_CODE($type)); + define('PAYOUT_TYPE_VALUE', COMPILE_CODE($content['type'])); - if (REVERT_COMMA($TPTS) >= $min) { + if (convertCommaToDot($TPTS) >= $content['min_points']) { // Ok, he can get be paid - if ((IS_FORM_SENT()) && ($PAYOUT <= $PAY_MAX) && ($PAYOUT >= $min)) { + if ((IS_FORM_SENT()) && ($PAYOUT <= $PAY_MAX) && ($PAYOUT >= $content['min_points'])) { // Calculate exact value + // @TODO Rewrite this constant define('PAYOUT_POINTS_VALUE', $PAYOUT); // Subtract points from member's account - SUB_POINTS("payout", $GLOBALS['userid'], $PAYOUT); + SUB_POINTS('payout', getUserId(), $PAYOUT); // Add entry to his tranfer history - if ($allow == "Y") { + 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) VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", - array( - $GLOBALS['userid'], - bigintval(REQUEST_POST('payout')), - bigintval(REQUEST_GET('payout')), - REQUEST_POST('turl'), - REQUEST_POST('alt'), - REQUEST_POST('banner') -), __FILE__, __LINE__); + array( + getUserId(), + bigintval(REQUEST_POST('payout')), + bigintval(REQUEST_GET('payout')), + REQUEST_POST('turl'), + REQUEST_POST('alt'), + REQUEST_POST('banner') + ), __FILE__, __LINE__); // Load templates - $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request_banner", array(), $GLOBALS['userid']); - if (GET_EXT_VERSION("admins") >= "0.4.1") { + $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request_banner", array(), getUserId()); + if (GET_EXT_VERSION('admins') >= '0.4.1') { $adm_tpl = "admin_payout_request_banner"; } else { - $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", array(), $GLOBALS['userid']); + $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", array(), getUserId()); } } 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) VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", - array( - $GLOBALS['userid'], - bigintval(REQUEST_POST('payout')), - bigintval(REQUEST_POST('account')), - REQUEST_POST('bank'), - bigintval(REQUEST_GET('payout')), - REQUEST_POST('pass') -), __FILE__, __LINE__); + array( + getUserId(), + bigintval(REQUEST_POST('payout')), + bigintval(REQUEST_POST('account')), + REQUEST_POST('bank'), + bigintval(REQUEST_GET('payout')), + REQUEST_POST('pass') + ), __FILE__, __LINE__); // Load templates - $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request", array(), $GLOBALS['userid']); - $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request", array(), $GLOBALS['userid']); - $admin_tpl = ""; - if (GET_EXT_VERSION("admins") >= "0.4.1") - { + $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request", array(), getUserId()); + $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request", array(), getUserId()); + $admin_tpl = ''; + + // @TODO Rewrite this to a filter + if (GET_EXT_VERSION('admins') >= '0.4.1') { $admin_tpl = "admin_payout_request"; } } @@ -229,33 +241,43 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", // Generate task SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_task_system` (assigned_admin, status, task_type, subject, text, task_created, userid) VALUES (0, 'NEW','PAYOUT_REQUEST','[payout:] {--PAYOUT_REQUEST_ADMIN--}','%s', UNIX_TIMESTAMP(), %s)", - array( - $msg_adm, - $GLOBALS['userid'] -), __FILE__, __LINE__); + array( + $msg_adm, + getUserId() + ), __FILE__, __LINE__); // Send out mails - SEND_EMAIL($GLOBALS['userid'], getMessage('PAYOUT_REQUEST_MEMBER'), $msg_mem); + sendEmail(getUserId(), getMessage('PAYOUT_REQUEST_MEMBER'), $msg_mem); // To admin(s) - SEND_ADMIN_NOTIFICATION(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, array(), $GLOBALS['userid']); + sendAdminNotification(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, array(), getUserId()); // Load template and output it - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_REQUEST_SENT')); - } elseif ($allow == "Y") { + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('PAYOUT_REQUEST_SENT')); + } elseif ($content['allow'] == 'Y') { + // Prepare content + $content = array( + 'payout' => bigintval(REQUEST_GET('payout')) + ); + // Generate banner order form - LOAD_TEMPLATE("member_payout_form_banner"); + LOAD_TEMPLATE("member_payout_form_banner", false, $content); } else { + // Prepare content + $content = array( + 'payout' => bigintval(REQUEST_GET('payout')) + ); + // Generate normal form - LOAD_TEMPLATE("member_payout_form"); + LOAD_TEMPLATE("member_payout_form", false, $content); } } else { // Not enougth points - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_POINTS_NOT_ENOUGTH')); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('PAYOUT_POINTS_NOT_ENOUGTH')); } } else { // ID is invalid - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_ID_INVALID')); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('PAYOUT_ID_INVALID')); } }