0) {
if (isFormSent()) {
// Make mail editable...
$result = SQL_QUERY_ESC("SELECT `id`, `subject`, `text`, `url` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1",
array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__);
// Fetch row
$content = SQL_FETCHARRAY($result);
// Free result
SQL_FREERESULT($result);
// Load template
loadTemplate('admin_edit_email', false, $content);
} elseif (isPostRequestParameterSet('save')) {
// Save changes
SQL_QUERY_ESC("UPDATE
`{?_MYSQL_PREFIX?}_pool`
SET
`subject`='%s',
`text`='%s',
`url`='%s'
WHERE
`id`=%s
LIMIT 1",
array(
postRequestParameter('subject'),
postRequestParameter('text'),
postRequestParameter('url'),
bigintval(postRequestParameter('id')),
), __FILE__, __LINE__);
if (SQL_AFFECTEDROWS() == 1) {
$content = '{--SETTINGS_SAVED--}';
} else {
$content = '{--SETTINGS_NOT_SAVED--}';
}
// Display message
loadTemplate('admin_settings_saved', false, $content);
} else {
// There are mail orders available
$OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
// Load row template and switch colors
$OUT .= loadTemplate('admin_edit_email_row', true, $content);
} // END - while
// 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]
?>