-$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) {
- if (isset($_POST['ok'])) {
- // Make mail editable...
- $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1",
- array(bigintval($_POST['id'])), __FILE__, __LINE__);
- list($subj, $text, $url) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
- define('__ID_VALUE' , $_POST['id']);
- define('__URL_VALUE' , $url);
- define('__SUBJ_VALUE', $subj);
- define('__TEXT_VALUE', $text);
+ // Load template
+ loadTemplate('admin_edit_email', FALSE, $content);
+} elseif ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) {
+ // Make also this email editable
+ $result = sqlQueryEscaped('SELECT
+ `id`,
+ `subject`,
+ `text`,
+ `url`
+FROM
+ `{?_MYSQL_PREFIX?}_bonus`
+WHERE
+ `id`=%s
+LIMIT 1',
+ array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);