* -------------------------------------------------------------------- *
* Kurzbeschreibung : Werbebuchungen aendern (z.B. umleiten der URL) *
* -------------------------------------------------------------------- *
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Werbebuchungen aendern (z.B. umleiten der URL) *
* -------------------------------------------------------------------- *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
REQUEST_UNSET_POST('ok');
}
$result = SQL_QUERY("SELECT id, sender, subject, payment_id, cat_id FROM `{!_MYSQL_PREFIX!}_pool` ORDER BY timestamp", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
REQUEST_UNSET_POST('ok');
}
$result = SQL_QUERY("SELECT id, sender, subject, payment_id, cat_id FROM `{!_MYSQL_PREFIX!}_pool` ORDER BY timestamp", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
- $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1",
- array(bigintval(REQUEST_POST('id'))), __FILE__, __LINE__);
+ $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{!_MYSQL_PREFIX!}_pool` WHERE `id`=%s LIMIT 1",
+ array(bigintval(REQUEST_POST('id'))), __FILE__, __LINE__);
list($subj, $text, $url) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
// @TODO More constants to rewrite
list($subj, $text, $url) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
// @TODO More constants to rewrite
-WHERE id=%s LIMIT 1",
- array(
- REQUEST_POST('subj'),
- REQUEST_POST('text'),
- REQUEST_POST('url'),
- bigintval(REQUEST_POST('id')),
-), __FILE__, __LINE__);
+WHERE `id`=%s LIMIT 1",
+ array(
+ REQUEST_POST('subj'),
+ REQUEST_POST('text'),
+ REQUEST_POST('url'),
+ bigintval(REQUEST_POST('id')),
+ ), __FILE__, __LINE__);
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
// @TODO Rewritings: subj->subject in template
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
// @TODO Rewritings: subj->subject in template
- 'uid' => ADMIN_USER_PROFILE_LINK($content['sender']),
- 'pay' => GET_PAYMENT($content['payment_id']),
- 'cat' => GET_CATEGORY($content['cat_id']),
+ 'uid' => generateUserProfileLink($content['sender']),
+ 'pay' => getPaymentTitlePrice($content['payment_id']),
+ 'cat' => getCategory($content['cat_id']),
- LOAD_TEMPLATE("admin_settings_saved", false, "<span class=\"admin_failed\">{--ADMIN_NO_MAILS_IN_POOL--}</span>");
+ LOAD_TEMPLATE('admin_settings_saved', false, "<span class=\"admin_failed\">{--ADMIN_NO_MAILS_IN_POOL--}</span>");