* -------------------------------------------------------------------- *
* Kurzbeschreibung : Bestaetigung von Mails *
* -------------------------------------------------------------------- *
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Bestaetigung von Mails *
* -------------------------------------------------------------------- *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// @TODO Improve check on $data['type'], empty() is not very much ...
if ((isValidId($data['userid'])) && (isValidId($data['id'])) && (!empty($data['type'])) && (!ifFatalErrorsDetected())) {
// @TODO Improve check on $data['type'], empty() is not very much ...
if ((isValidId($data['userid'])) && (isValidId($data['id'])) && (!empty($data['type'])) && (!ifFatalErrorsDetected())) {
// Is 'do' still "frames"?
if ($data['do'] == 'frames') {
// This is a frameset module
$GLOBALS['frameset_mode'] = TRUE;
} // END - if
// Is 'do' still "frames"?
if ($data['do'] == 'frames') {
// This is a frameset module
$GLOBALS['frameset_mode'] = TRUE;
} // END - if
- $result_main = SQL_QUERY_ESC("SELECT `id` AS `link_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
+ $result_main = sqlQueryEscaped("SELECT `id` AS `link_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
array($data['id'], $data['userid']), __FILE__, __LINE__);
break;
case 'bonus':
array($data['id'], $data['userid']), __FILE__, __LINE__);
break;
case 'bonus':
- $result_main = SQL_QUERY_ESC("SELECT `id` AS `link_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
+ $result_main = sqlQueryEscaped("SELECT `id` AS `link_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
array($data['id'], $data['userid']), __FILE__, __LINE__);
break;
array($data['id'], $data['userid']), __FILE__, __LINE__);
break;
- $result_mailid = SQL_QUERY_ESC("SELECT `pool_id`, `userid` AS `sender` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
+ $result_mailid = sqlQueryEscaped("SELECT `pool_id`, `userid` AS `sender`, `url` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
- $result_mailid = SQL_QUERY_ESC("SELECT `id` AS `pool_id`, `is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+ $result_mailid = sqlQueryEscaped("SELECT `id` AS `pool_id`, `is_notify`, `url` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
// Correct notification switch in non-bonus mails
if ((!isset($data['is_notify'])) || (!in_array($data['is_notify'], array('Y', 'N')))) {
// Correct notification switch in non-bonus mails
if ((!isset($data['is_notify'])) || (!in_array($data['is_notify'], array('Y', 'N')))) {
- if (SQL_NUMROWS($result) == 1) {
- $data = merge_array($data, SQL_FETCHARRAY($result));
+ if (sqlNumRows($result) == 1) {
+ $data = merge_array($data, sqlFetchArray($result));
$data['time'] = getPaymentTime($data['payment_id']);
$data['payment'] = getPaymentPayment($data['payment_id']);
$isValid = TRUE;
} // END - if
// Free memory...
$data['time'] = getPaymentTime($data['payment_id']);
$data['payment'] = getPaymentPayment($data['payment_id']);
$isValid = TRUE;
} // END - if
// Free memory...
- $result = SQL_QUERY_ESC("SELECT `time`, `points` AS `payment` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+ $result = sqlQueryEscaped("SELECT `time`, `points` AS `payment` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
- if (SQL_NUMROWS($result) == 1) {
- $data = merge_array($data, SQL_FETCHARRAY($result));
+ if (sqlNumRows($result) == 1) {
+ $data = merge_array($data, sqlFetchArray($result));