X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=49e1636cf752868ec687fa294ac9e031696cfaa7;hp=1a828cdb9c88d6270c1014e5e83e6ee500a2720c;hb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b;hpb=ae80e170b5d25a4782af90a7c3d81fbb176fa293 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index 1a828cdb9c..49e1636cf7 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -10,9 +10,14 @@ * -------------------------------------------------------------------- * * 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 * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -32,260 +37,257 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) { +if (!defined('__SECURITY')) { // Don't call this directly! - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); -} elseif (!IS_MEMBER()) { + die(); +} elseif (!isMember()) { // Not logged in - LOAD_URL("modules.php?module=index"); -} elseif ((!EXT_IS_ACTIVE("payout")) && (!IS_ADMIN())) { - // Extension "payout" is not active - ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "payout"); - return; + redirectToIndexMemberOnlyModule(); } // Add description as navigation point -ADD_DESCR("member", basename(__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)) -{ - // Load referral points - $result_points = SQL_QUERY_ESC("SELECT points FROM "._MYSQL_PREFIX."_user_points WHERE userid=%s AND ref_depth=%s LIMIT 1", - array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__); - if (SQL_NUMROWS($result_points) == 1) - { +addMenuDescription('member', __FILE__); + +if ((!isExtensionActive('payout')) && (!isAdmin())) { + loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('payout')); + 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); - SQL_FREERESULT($result_points); - $TPTS += $points; - } -} + + // Add them to total + $totalPoints += $points; + } // END - if + + // Free result + SQL_FREERESULT($result_points); +} // END - while // Free memory SQL_FREERESULT($result_depths); -$result = SQL_QUERY_ESC("SELECT used_points FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", - array($GLOBALS['userid']), __FILE__, __LINE__); -list($USED) = SQL_FETCHROW($result); -SQL_FREERESULT($result); +// Get used points +$usedPoints = countSumTotalData(getMemberId(), 'user_data', 'used_points'); // Translate point into comma -$TPTS = TRANSLATE_COMMA($TPTS - $USED); +$totalPoints = ($totalPoints - $usedPoints); // Sanity check... -if (empty($TPTS)) $TPTS = "0.00000"; +if (empty($totalPoints)) $totalPoints = '0.00000'; -if (empty($_GET['payout'])) -{ +if (!isGetRequestElementSet('payout')) { // Load payout types - $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(str_replace(",", ".", $TPTS)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY_ESC("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_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 -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__); - if (SQL_NUMROWS($result_payouts) > 0) - { + $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 +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(getMemberId()), __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 - $evl = "\$status = PAYOUT_MEMBER_STATUS_".strtoupper($status).";"; - eval($evl); - $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."\""; - } - else - { + $content['target_account'] = "\"".$content['alt']."\""; + } else { // Textlink - $account = $alt; + $content['target_account'] = $content['alt']; } - $bank = "".CLICK_HERE.""; - } - else - { + $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']) . ' ' . $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); + $OUT .= loadTemplate('member_payout_row', true, $content); $SW = 3 - $SW; } - // Remember rows in constant - define('__PAYOUT_ROWS', $OUT); - // Load template - LOAD_TEMPLATE("member_payout"); + loadTemplate('member_payout', false, $OUT); } // Free memory SQL_FREERESULT($result_payouts); // Output payout list - PAYOUT_OUTPUT_PAYOUT_LIST($TPTS); + outputPayoutList($totalPoints); + } else { + // No payout types setup + loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_NO_PAYOUT_TYPES')); } -} - else -{ +} 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($_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(getRequestElement('payout'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // ID is valid - list($type, $rate, $min, $allow) = SQL_FETCHROW($result); - SQL_FREERESULT($result); + if (SQL_NUMROWS($result) == 1) { + // id is valid so load the data + $content = SQL_FETCHARRAY($result); // Calculate maximum value - $max = round($TPTS * $rate - 0.5); + $max = round($totalPoints * $content['rate'] - 0.5); + $PAY_MAX = '0'; // Calulcate points from submitted amount - $PAYOUT = 0; - if (!empty($_POST['payout'])) - { - $PAYOUT = bigintval($_POST['payout']) / $rate; - $PAY_MAX = $max / $rate; + $points = '0'; + if (isPostRequestElementSet('payout')) { + $points = bigintval(postRequestElement('payout')) / $content['rate']; + $PAY_MAX = $max / $content['rate']; } - // Move variables into constants for templates - define('PAYOUT_MAX_VALUE' , $max); - define('PAYOUT_TYPE_VALUE', COMPILE_CODE($type)); - - if (str_replace(",", ".", $TPTS) >= $min) - { + // Has enougth points to payout? + if ($totalPoints >= $content['min_points']) { // Ok, he can get be paid - if ((isset($_POST['ok'])) && ($PAYOUT <= $PAY_MAX) && ($PAYOUT >= $min)) - { - // Calculate exact value - define('PAYOUT_POINTS_VALUE', $PAYOUT); + if ((isFormSent()) && ($points <= $PAY_MAX) && ($points >= $content['min_points'])) { + // Remember points in array + setRequestPostElement('payout_points', translateComma($points)); + setRequestPostElement('type' , $content['type']); // Subtract points from member's account - SUB_POINTS($GLOBALS['userid'], $PAYOUT); + subtractPoints('payout', getMemberId(), $points); // Add entry to his tranfer history - if ($allow == "Y") - { + if ($content['allow'] == 'Y') { // Banner/textlink ordered - $result = 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($_POST['payout']), - bigintval($_GET['payout']), - $_POST['turl'], - $_POST['alt'], - $_POST['banner'] -), __FILE__, __LINE__); + 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(postRequestElement('payout')), + bigintval(getRequestElement('payout')), + postRequestElement('turl'), + postRequestElement('alt'), + postRequestElement('banner') + ), __FILE__, __LINE__); // Load templates - $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request_banner", "", $GLOBALS['userid']); - if (GET_EXT_VERSION("admins") >= "0.4.1") - { - $adm_tpl = "admin_payout_request_banner"; + $message_mem = loadEmailTemplate('member_payout_request_banner', postRequestArray(), getMemberId()); + if (getExtensionVersion('admins') >= '0.4.1') { + $adm_tpl = 'admin_payout_request_banner'; + } else { + $message_adm = loadEmailTemplate('admin_payout_request_banner', postRequestArray(), getMemberId()); } - else - { - $msg_adm = addslashes(LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", "", $GLOBALS['userid'])); - } - } - else - { + } else { // e-currency payout requested - $result = 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($_POST['payout']), - bigintval($_POST['account']), - $_POST['bank'], - bigintval($_GET['payout']), - $_POST['pass'] -), __FILE__, __LINE__); + 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(), + bigintval(postRequestElement('payout')), + bigintval(postRequestElement('account')), + postRequestElement('bank'), + bigintval(getRequestElement('payout')), + postRequestElement('pass') + ), __FILE__, __LINE__); // Load templates - $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request", "", $GLOBALS['userid']); - $msg_adm = addslashes(LOAD_EMAIL_TEMPLATE("admin_payout_request", "", $GLOBALS['userid'])); - $admin_tpl = ""; - if (GET_EXT_VERSION("admins") >= "0.4.1") - { - $admin_tpl = "admin_payout_request"; - } + $message_mem = loadEmailTemplate('member_payout_request', postRequestArray(), getMemberId()); + $message_adm = loadEmailTemplate('admin_payout_request', postRequestArray(), getMemberId()); + $admin_tpl = ''; + + // @TODO Rewrite this to a filter + if (getExtensionVersion('admins') >= '0.4.1') { + $admin_tpl = 'admin_payout_request'; + } // END - if } // Generate task - $result = 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__); + createNewTask('[payout:] {--PAYOUT_REQUEST_ADMIN--}', $message_adm, 'PAYOUT_REQUEST', getMemberId()); // Send out mails - SEND_EMAIL($GLOBALS['userid'], PAYOUT_REQUEST_MEMBER, $msg_mem); + sendEmail(getMemberId(), getMessage('PAYOUT_REQUEST_MEMBER'), $message_mem); // To admin(s) - SEND_ADMIN_NOTIFICATION(PAYOUT_REQUEST_ADMIN, $admin_tpl, "", $GLOBALS['userid']); + sendAdminNotification(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, postRequestArray(), getMemberId()); // Load template and output it - LOAD_TEMPLATE("admin_settings_saved", false, PAYOUT_REQUEST_SENT); - } - elseif ($allow == "Y") - { + loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_REQUEST_SENT')); + } elseif ($content['allow'] == 'Y') { + // Prepare content + $content = array( + 'max' => $max, + 'type' => $content['type'], + 'payout' => bigintval(getRequestElement('payout')) + ); + // Generate banner order form - LOAD_TEMPLATE("member_payout_form_banner"); - } - else - { + loadTemplate('member_payout_form_banner', false, $content); + } else { + // Prepare content + $content = array( + 'max' => $max, + 'type' => $content['type'], + 'payout' => bigintval(getRequestElement('payout')) + ); + // Generate normal form - LOAD_TEMPLATE("member_payout_form"); + loadTemplate('member_payout_form', false, $content); } - } - else - { + } else { // Not enougth points - LOAD_TEMPLATE("admin_settings_saved", false, PAYOUT_POINTS_NOT_ENOUGTH); + loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_POINTS_NOT_ENOUGTH')); } + } else { + // id is invalid + loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_ID_INVALID')); } - else - { - // ID is invalid - LOAD_TEMPLATE("admin_settings_saved", false, PAYOUT_ID_INVALID); - } + + // Free result + SQL_FREERESULT($result); } -// + +// [EOF] ?>