X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=223d0c09d27d64515369d4c937019c49b9b12390;hp=ad4ef86afc75992b5b0f290c25fd112eb8f3fc10;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=b8c86fa12322603c24a88ea2b0fd3dbeba612752 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index ad4ef86afc..223d0c09d2 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -1,7 +1,7 @@ = min_points -ORDER BY type", array(REVERT_COMMA($TPTS)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { - // Free memory - SQL_FREERESULT($result); - + $result = sqlQueryEscaped('SELECT + `id`, + `type`, + `rate`, + `min_points`, + `allow_url` +FROM + `{?_MYSQL_PREFIX?}_payout_types` +WHERE + %s >= `min_points` +ORDER BY + `type` ASC', + array($payoutPoints), __FILE__, __LINE__); + + // Some entries found? + if (!ifSqlHasZeroNumRows($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 = 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` +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 (!ifSqlHasZeroNumRows($result_payouts)) { // List all his requests - $SW = 2; $OUT = ""; - while (list($pid, $total, $account, $bank, $type, $tstamp, $status, $allow, $url, $alt, $banner) = SQL_FETCHROW($result_payouts)) { - // Translate status - $status = constant('PAYOUT_MEMBER_STATUS_'.strtoupper($status).''); - $status = "
".$status."
"; - + $OUT = ''; + while ($content = sqlFetchArray($result_payouts)) { // Nothing entered must be secured in member/what-payputs.php ! - if ($allow == "Y") { + if ($content['allow_url'] == 'Y') { // Banner/Textlink views/clicks request - if (!empty($banner)) { + if (!empty($content['banner'])) { // Banner - $account = "\"".$alt."\""; + $content['target_account'] = '' . $content['link_text'] . ''; } else { // Textlink - $account = $alt; + $content['target_account'] = $content['link_text']; } - $bank = "{--CLICK_HERE--}"; - } else { - // e-currency payout request - if (empty($account)) $account = "---"; - if (empty($bank)) $bank = "---"; - } + $content['target_bank'] = '{--CLICK_HERE--}'; + } // END - if // Prepare data for the template - $content = array( - 'sw' => $SW, - 'acc' => $account, - 'points' => TRANSLATE_COMMA($total)." ".COMPILE_CODE($type), - 'bank' => $bank, - 'stamp' => MAKE_DATETIME($tstamp, "2"), - 'status' => $status - ); - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("member_payout_row", true, $content); - $SW = 3 - $SW; - } + $content['payout_timestamp'] = generateDateTime($content['payout_timestamp'], 2); - // Remember rows in constant - define('__PAYOUT_ROWS', $OUT); + // Load row template and switch colors + $OUT .= loadTemplate('member_payout_row', TRUE, $content); + } // END - while // Load template - LOAD_TEMPLATE("member_payout"); - } + loadTemplate('member_payout', FALSE, $OUT); + } // END - if // Free memory - SQL_FREERESULT($result_payouts); + sqlFreeResult($result_payouts); // Output payout list - PAYOUT_OUTPUT_PAYOUT_LIST($TPTS); + outputPayoutList($payoutPoints); + } else { + // No payout types setup + 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 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); - SQL_FREERESULT($result); + $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 (sqlNumRows($result) == 1) { + // id is valid so load the data + $content = sqlFetchArray($result); // Calculate maximum value - $max = round($TPTS * $rate - 0.5); + $max = round($payoutPoints * $content['rate'] - 0.5); + $PAY_MAX = '0'; // Calulcate points from submitted amount - $PAYOUT = 0; - if (REQUEST_ISSET_POST(('payout'))) { - $PAYOUT = bigintval(REQUEST_POST('payout')) / $rate; - $PAY_MAX = $max / $rate; - } - - // Move variables into constants for templates - define('PAYOUT_MAX_VALUE' , $max); - define('PAYOUT_TYPE_VALUE', COMPILE_CODE($type)); - - if (REVERT_COMMA($TPTS) >= $min) { + $points = '0'; + if (isPostRequestElementSet('payout')) { + $points = bigintval(postRequestElement('payout')) / $content['rate']; + $PAY_MAX = $max / $content['rate']; + } // END - if + + // Has enougth points to payout? + if ($payoutPoints >= $content['min_points']) { // Ok, he can get be paid - if ((IS_FORM_SENT()) && ($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 + setPostRequestElement('payout_points', $points); + setPostRequestElement('type' , $content['type']); - // Subtract points from member's account - SUB_POINTS("payout", $GLOBALS['userid'], $PAYOUT); + // Subtract points from member's account and ignore return status + subtractPoints('payout', getMemberId(), $points); // Add entry to his tranfer history - if ($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( - $GLOBALS['userid'], - bigintval(REQUEST_POST('payout')), - bigintval(REQUEST_GET('payout')), - REQUEST_POST('turl'), - REQUEST_POST('alt'), - REQUEST_POST('banner') -), __FILE__, __LINE__); + array( + getMemberId(), + bigintval(postRequestElement('payout')), + bigintval(getRequestElement('payout')), + postRequestElement('turl'), + postRequestElement('link_text'), + postRequestElement('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") { - $adm_tpl = "admin_payout_request_banner"; + $message_mem = loadEmailTemplate('member_payout_request_banner', postRequestArray(), getMemberId()); + if (isExtensionInstalledAndNewer('admins', '0.4.1')) { + $adm_tpl = 'admin_payout_request_banner'; } else { - $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", array(), $GLOBALS['userid']); + $message_adm = loadEmailTemplate('admin_payout_request_banner', postRequestArray(), getMemberId()); } } 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( - $GLOBALS['userid'], - bigintval(REQUEST_POST('payout')), - bigintval(REQUEST_POST('account')), - REQUEST_POST('bank'), - bigintval(REQUEST_GET('payout')), - REQUEST_POST('pass') -), __FILE__, __LINE__); + array( + getMemberId(), + bigintval(postRequestElement('payout')), + bigintval(postRequestElement('account')), + postRequestElement('bank'), + bigintval(getRequestElement('payout')), + postRequestElement('password') + ), __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") - { - $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 (isExtensionInstalledAndNewer('admins', '0.4.1')) { + $admin_tpl = 'admin_payout_request'; + } // END - if } - // 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__); + // Generate task (we ignore the task id here) + createNewTask('[payout:] {--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $message_adm, 'PAYOUT_REQUEST', getMemberId()); // Send out mails - SEND_EMAIL($GLOBALS['userid'], getMessage('PAYOUT_REQUEST_MEMBER'), $msg_mem); + sendEmail(getMemberId(), '{--MEMBER_PAYOUT_REQUEST_SUBJECT--}', $message_mem); // To admin(s) - SEND_ADMIN_NOTIFICATION(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, array(), $GLOBALS['userid']); + sendAdminNotification('{--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $admin_tpl, postRequestArray(), getMemberId()); // Load template and output it - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_REQUEST_SENT')); - } elseif ($allow == "Y") { + displayMessage('{--MEMBER_PAYOUT_REQUEST_SENT--}'); + } elseif ($content['allow_url'] == 'Y') { + // Prepare content + $content = array( + 'max' => $max, + 'type' => $content['type'], + 'payout' => bigintval(getRequestElement('payout')) + ); + // Generate banner order form - LOAD_TEMPLATE("member_payout_form_banner"); + 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 { // Not enougth points - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_POINTS_NOT_ENOUGTH')); + displayMessage('{--MEMBER_PAYOUT_POINTS_NOT_ENOUGTH--}'); } } else { - // ID is invalid - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('PAYOUT_ID_INVALID')); + // id is invalid + displayMessage('{--MEMBER_PAYOUT_ID_INVALID--}'); } + + // Free result + sqlFreeResult($result); } -// +// [EOF] ?>