- $result = SQL_QUERY_ESC("SELECT `id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id` AS `pool_id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
list($pay) = SQL_FETCHROW($result);
$time = getPaymentData($pay, 'time');
$payment = getPaymentData($pay, 'payment');
list($pay) = SQL_FETCHROW($result);
$time = getPaymentData($pay, 'time');
$payment = getPaymentData($pay, 'payment');
if (SQL_NUMROWS($result) == 1) {
list($points, $time) = SQL_FETCHROW($result);
$payment = '0.00000';
if (SQL_NUMROWS($result) == 1) {
list($points, $time) = SQL_FETCHROW($result);
$payment = '0.00000';
default: // Invalid mail type
reportBug(__FILE__, __LINE__, 'Invalid mail type ' . $ltype . ' detected.');
break;
default: // Invalid mail type
reportBug(__FILE__, __LINE__, 'Invalid mail type ' . $ltype . ' detected.');
break;
// If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
if (($time == '0') && ($payment > 0)) {
$url = getUrl();
// If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
if (($time == '0') && ($payment > 0)) {
$url = getUrl();