{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}';
}
} elseif (isPostRequestParameterSet('bid')) {
// Update pool
SQL_QUERY_ESC("UPDATE
`{?_MYSQL_PREFIX?}_bonus`
SET
`subject`='%s',
`text`='%s',
`url`='%s'
WHERE
`id`=%s
LIMIT 1",
array(
postRequestParameter('subject'),
postRequestParameter('text'),
postRequestParameter('url'),
bigintval(postRequestParameter('bid')),
), __FILE__, __LINE__);
if (!SQL_HASZEROAFFECTED()) {
$content = '{--ADMIN_EMAIL_CHANGES_SAVED--}';
} else {
$content = '{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}';
}
} else {
// No valid action
$content = '{--ADMIN_EDIT_EMAIL_FAILED--}';
}
// Display message
displayMessage($content);
} else {
// Query the pool
$result = SQL_QUERY('SELECT
`id`,`sender` AS `userid`,`subject`,`payment_id`,`cat_id`
FROM
`{?_MYSQL_PREFIX?}_pool`
ORDER BY
`timestamp` ASC', __FILE__, __LINE__);
// Entries found?
if (!SQL_HASZERONUMS($result)) {
// 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
displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}');
}
}
// [EOF]
?>