<?php
/************************************************************************
- * MXChange v0.2.1 Start: 04/12/2004 *
- * ================ Last change: 12/01/2008 *
+ * Mailer v0.2.1-FINAL Start: 04/12/2004 *
+ * =================== Last change: 12/01/2008 *
* *
* -------------------------------------------------------------------- *
* File : what-payout.php *
} // END - if
$result_depths = SQL_QUERY("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY level", __FILE__, __LINE__);
-$totalPoints = 0;
+$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(getUserId(), bigintval($content['level'])), __FILE__, __LINE__);
+ array(getMemberId(), bigintval($content['level'])), __FILE__, __LINE__);
// Entry found?
if (SQL_NUMROWS($result_points) == 1) {
SQL_FREERESULT($result_depths);
// Get used points
-$usedPoints = countSumTotalData(getUserId(), 'user_data', 'used_points');
+$usedPoints = countSumTotalData(getMemberId(), 'user_data', 'used_points');
// Translate point into comma
$totalPoints = ($totalPoints - $usedPoints);
p.userid = %s
ORDER BY
p.payout_timestamp DESC",
- array(getUserId()), __FILE__, __LINE__);
+ array(getMemberId()), __FILE__, __LINE__);
if (SQL_NUMROWS($result_payouts) > 0) {
// List all his requests
$OUT = ''; $SW = 2;
}
// Prepare data for the template
- // @TODO Rewritings: acc->target_account,bank->target_bank in templates
$content = array(
- 'sw' => $SW,
- 'acc' => $content['target_account'],
- 'points' => translateComma($content['payout_total']) . ' ' . $content['type'],
- 'bank' => $content['target_bank'],
- 'stamp' => generateDateTime($content['payout_timestamp'], 2),
- 'status' => $content['status']
+ 'sw' => $SW,
+ 'target_account' => $content['target_account'],
+ 'points' => translateComma($content['payout_total']) . ' ' . $content['type'],
+ 'target_bank' => $content['target_bank'],
+ 'payout_timestamp' => generateDateTime($content['payout_timestamp'], 2),
+ 'status' => $content['status']
);
// Load row template and switch colors
// Calculate maximum value
$max = round($totalPoints * $content['rate'] - 0.5);
- $PAY_MAX = 0;
+ $PAY_MAX = '0';
// Calulcate points from submitted amount
- $points = 0;
+ $points = '0';
if (isPostRequestElementSet('payout')) {
$points = bigintval(postRequestElement('payout')) / $content['rate'];
$PAY_MAX = $max / $content['rate'];
setRequestPostElement('type' , $content['type']);
// Subtract points from member's account
- subtractPoints('payout', getUserId(), $points);
+ subtractPoints('payout', getMemberId(), $points);
// Add entry to his tranfer history
if ($content['allow'] == 'Y') {
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(
- getUserId(),
+ getMemberId(),
bigintval(postRequestElement('payout')),
bigintval(getRequestElement('payout')),
postRequestElement('turl'),
), __FILE__, __LINE__);
// Load templates
- $message_mem = loadEmailTemplate('member_payout_request_banner', postRequestArray(), getUserId());
+ $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(), getUserId());
+ $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`)
VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')",
array(
- getUserId(),
+ getMemberId(),
bigintval(postRequestElement('payout')),
bigintval(postRequestElement('account')),
postRequestElement('bank'),
), __FILE__, __LINE__);
// Load templates
- $message_mem = loadEmailTemplate('member_payout_request', postRequestArray(), getUserId());
- $message_adm = loadEmailTemplate('admin_payout_request', postRequestArray(), getUserId());
+ $message_mem = loadEmailTemplate('member_payout_request', postRequestArray(), getMemberId());
+ $message_adm = loadEmailTemplate('admin_payout_request', postRequestArray(), getMemberId());
$admin_tpl = '';
// @TODO Rewrite this to a filter
}
// Generate task
- createNewTask('[payout:] {--PAYOUT_REQUEST_ADMIN--}', $message_adm, 'PAYOUT_REQUEST', getUserId());
+ createNewTask('[payout:] {--PAYOUT_REQUEST_ADMIN--}', $message_adm, 'PAYOUT_REQUEST', getMemberId());
// Send out mails
- sendEmail(getUserId(), getMessage('PAYOUT_REQUEST_MEMBER'), $message_mem);
+ sendEmail(getMemberId(), getMessage('PAYOUT_REQUEST_MEMBER'), $message_mem);
// To admin(s)
- sendAdminNotification(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, postRequestArray(), getUserId());
+ sendAdminNotification(getMessage('PAYOUT_REQUEST_ADMIN'), $admin_tpl, postRequestArray(), getMemberId());
// Load template and output it
loadTemplate('admin_settings_saved', false, getMessage('PAYOUT_REQUEST_SENT'));