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(getUserId(), bigintval($content['level'])), __FILE__, __LINE__);
+ array(getUserId(), bigintval($content['level'])), __FILE__, __LINE__);
// Entry found?
if (SQL_NUMROWS($result_points) == 1) {
FROM `{!_MYSQL_PREFIX!}_payout_types`
WHERE %s >= min_points
ORDER BY type ASC",
- array(convertCommaToDot($TPTS)), __FILE__, __LINE__);
+ array(convertCommaToDot($TPTS)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// Free memory
SQL_FREERESULT($result);
ON p.payout_id = t.id
WHERE p.userid = %s
ORDER BY p.payout_timestamp DESC",
- array(getUserId()), __FILE__, __LINE__);
+ array(getUserId()), __FILE__, __LINE__);
if (SQL_NUMROWS($result_payouts) > 0) {
// List all his requests
$OUT = ''; $SW = 2;
} 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(REQUEST_GET('payout'))), __FILE__, __LINE__);
+ array(bigintval(REQUEST_GET('payout'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// ID is valid so load the data
// 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(
- getUserId(),
- 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(), getUserId());
// 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(),
- 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(), getUserId());
// 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,
- getUserId()
-), __FILE__, __LINE__);
+ array(
+ $msg_adm,
+ getUserId()
+ ), __FILE__, __LINE__);
// Send out mails
sendEmail(getUserId(), getMessage('PAYOUT_REQUEST_MEMBER'), $msg_mem);