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
LOAD_TEMPLATE("admin_edit_email");
}
elseif (!empty($_POST['save']))
{
// Save changes
if (!empty($SQL))
{
$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_pool SET
subject='%s',
text='%s',
url='%s'
WHERE id=%s LIMIT 1",
array(
addslashes($_POST['subj']),
addslashes($_POST['text']),
addslashes($_POST['url']),
bigintval($_POST['id']),
), __FILE__, __LINE__);
if (SQL_AFFECTEDROWS() == 1)
{
$content = "".SETTINGS_SAVED."";
}
else
{
$content = "".SETTINGS_NOT_SAVED."";
}
}
else
{
$content = "".SETTINGS_NOT_SAVED."";
}
// Display message
LOAD_TEMPLATE("admin_settings_saved", false, $content);
}
else
{
// There are mail orders available
$SW = 2; $OUT = "";
while (list($id, $sender, $subj, $pay, $cat) = SQL_FETCHROW($result))
{
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $id,
'subj' => $subj,
'uid' => ADMIN_USER_PROFILE_LINK($sender),
'pay' => GET_PAYMENT($pay),
'cat' => GET_CATEGORY($cat),
);
// Load row template and switch colors
$OUT .= LOAD_TEMPLATE("admin_edit_email_row", true, $content);
$SW = 3 - $SW;
}
// Free memory
SQL_FREERESULT($result);
define('__EMAIL_SELECT_ROWS', $OUT);
// Load email template
LOAD_TEMPLATE("admin_edit_email_select");
}
} else {
// No mail orders left in pool
OUTPUT_HTML("".ADMIN_NO_MAILS_IN_POOL."");
}
//
?>