* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// 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?
// @TODO Rewrite these if-blocks to a filter
if ((isExtensionActive('surfbar')) && (getConfig('surfbar_migrate_order') == 'Y')) {
// Then "migrate" the URL to the surfbar
- SURFBAR_ADMIN_MIGRATE_URL($content['url'], $content['sender']);
+ doSurfbarAdminMigrateUrl($content['url'], $content['sender']);
} // END - if
// Check for bonus extension version >= 0.4.4 for the order bonus
$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
} // END - if
// Redirect URL
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `url`='%s', `data_type`='NEW' WHERE `id`=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `url`='%s',`data_type`='NEW' WHERE `id`=%s LIMIT 1",
array(postRequestElement('redirect'), $id),__FILE__, __LINE__);
// Prepare data for the row template
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