addYouAreHereLink('member', __FILE__);
if ((!isExtensionActive('payout')) && (!isAdmin())) {
addYouAreHereLink('member', __FILE__);
if ((!isExtensionActive('payout')) && (!isAdmin())) {
- `id`, `type`, `rate`, `min_points`, `allow_url`
+ `id`,`type`,`rate`,`min_points`,`allow_url`
- $result = SQL_QUERY_ESC("SELECT `type`, `rate`, `min_points`, `allow_url` AS allow FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+ $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(getRequestParameter('payout'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
array(bigintval(getRequestParameter('payout'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Ok, he can get be paid
if ((isFormSent()) && ($points <= $PAY_MAX) && ($points >= $content['min_points'])) {
// Remember points in array
setPostRequestParameter('payout_points', $points);
setPostRequestParameter('type' , $content['type']);
// Ok, he can get be paid
if ((isFormSent()) && ($points <= $PAY_MAX) && ($points >= $content['min_points'])) {
// Remember points in array
setPostRequestParameter('payout_points', $points);
setPostRequestParameter('type' , $content['type']);
subtractPoints('payout', getMemberId(), $points);
// Add entry to his tranfer history
if ($content['allow'] == 'Y') {
// Banner/textlink ordered
subtractPoints('payout', getMemberId(), $points);
// Add entry to his tranfer history
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`)
+ 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(),
VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')",
array(
getMemberId(),
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_payouts` (`userid`, `payout_total`, `target_account`, `target_bank`, `payout_id`, `payout_timestamp`, `status`, `password`)
+ 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(),
VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')",
array(
getMemberId(),
sendAdminNotification('{--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $admin_tpl, postRequestArray(), getMemberId());
// Load template and output it
sendAdminNotification('{--ADMIN_PAYOUY_REQUEST_SUBJECT--}', $admin_tpl, postRequestArray(), getMemberId());
// Load template and output it