0) {
if (isFormSent()) {
// Make mail editable...
$result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
array(bigintval(postRequestElement('id'))), __FILE__, __LINE__);
list($subj, $text, $url) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
// Prepare constant for template
$content['id'] = bigintval(postRequestElement('id'));
$content['url'] = $url;
$content['subject'] = $subj;
$content['text'] = $text;
// Load template
loadTemplate('admin_edit_email', false, $content);
} elseif (isPostRequestElementSet('save')) {
// Save changes
SQL_QUERY_ESC("UPDATE
`{?_MYSQL_PREFIX?}_pool`
SET
`subject`='%s',
`text`='%s',
`url`='%s'
WHERE
`id`=%s
LIMIT 1",
array(
postRequestElement('subject'),
postRequestElement('text'),
postRequestElement('url'),
bigintval(postRequestElement('id')),
), __FILE__, __LINE__);
if (SQL_AFFECTEDROWS() == 1) {
$content = getMessage('SETTINGS_SAVED');
} else {
$content = "{--SETTINGS_NOT_SAVED--}";
}
// Display message
loadTemplate('admin_settings_saved', false, $content);
} else {
// There are mail orders available
$OUT = ''; $SW = 2;
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $content['id'],
'subject' => $content['subject'],
'userid' => generateUserProfileLink($content['sender']),
'pay' => getPaymentTitlePrice($content['payment_id']),
'cat' => getCategory($content['cat_id']),
);
// Load row template and switch colors
$OUT .= loadTemplate('admin_edit_email_row', true, $content);
$SW = 3 - $SW;
}
// Free memory
SQL_FREERESULT($result);
// Load email template
loadTemplate('admin_edit_email_select', false, $OUT);
}
} else {
// No mail orders left in pool
loadTemplate('admin_settings_saved', false, "{--ADMIN_NO_MAILS_IN_POOL--}");
}
// [EOF]
?>