// Check for mails
$result_main = SQL_QUERY("SELECT
- `id`,`sender`,`subject`,`payment_id`,`timestamp`,`url`,`target_send`,`cat_id`
+ `id`,
+ `sender`,
+ `subject`,
+ `payment_id`,
+ `timestamp`,
+ `url`,
+ `target_send`,
+ `cat_id`
FROM
`{?_MYSQL_PREFIX?}_pool`
WHERE
$id = bigintval($id);
// Order placed in queue...
- $result = SQL_QUERY_ESC("SELECT
- po.`url`, po.`subject`, po.`sender`, pay.`payment`, po.`payment_id`
+ $result = SQL_QUERY_ESC('SELECT
+ po.`url`,
+ po.`subject`,
+ po.`sender`,
+ pay.`payment`,
+ po.`payment_id`
FROM
`{?_MYSQL_PREFIX?}_pool` AS `po`
INNER JOIN
po.`payment_id`=pay.`id`
WHERE
po.`id`=%s
-LIMIT 1",
+LIMIT 1',
array($id), __FILE__, __LINE__);
// Update wents fine?
$id = bigintval($id);
// Load URL and subject from pool
- $result = SQL_QUERY_ESC("SELECT `url`,`subject`,`sender` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `url`, `subject`, `sender` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
array($id), __FILE__, __LINE__);
// Load data
array($url), __FILE__, __LINE__);
if (SQL_HASZERONUMS($result)) {
// Did not find a record so we can add it... :)
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_url_blacklist` (`url`,`pool_id`) VALUES ('%s',%s)",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_url_blacklist` (`url`, `pool_id`) VALUES ('%s',%s)",
array($url, $id), __FILE__, __LINE__);
} // END - if