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 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_pool` SET subject='%s', text='%s', url='%s' WHERE id=%s LIMIT 1", array( $_POST['subj'], $_POST['text'], $_POST['url'], bigintval($_POST['id']), ), __FILE__, __LINE__); if (SQL_AFFECTEDROWS() == 1) { $content = SETTINGS_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.""); } // ?>