0) { // Add option for events $adminsList = generateOptionList('admins', 'id', 'login', '', 'email'); $SW = 2; $rowNameS = ''; foreach (postRequestElement('sel') as $template => $sel) { // First of all load data from DB $result = SQL_QUERY_ESC("SELECT `admin_id`, `id` FROM `{?_MYSQL_PREFIX?}_admins_mails` WHERE `mail_template`='%s' ORDER BY `id` ASC", array($template), __FILE__, __LINE__); $OUT = ''; $adminId2 = 0; while ($content = SQL_FETCHARRAY($result)) { // @TODO Can this be rewritten??? $OUT .= " $SW, 'id' => $id, 'id2' => $id2, 'tpl' => $template, 'admins' => $adminsList ); if ($adminId2 > 0) { // Add form for an additional admin $OUT .= loadTemplate('admin_admins_mails_edit_form', true, $content); } // END - if // Save full rendered content $content['content'] = $OUT; // Start outputing line $rowNameS .= loadTemplate('admin_admins_mails_edit_row', true, $content); $SW = 3 - $SW; } // Edit checked entries loadTemplate('admin_admins_mails_edit', false, $rowNameS); } else { // Nothing selected loadTemplate('admin_settings_saved', false, getMessage('ADMINS_NO_MAIL_CHECKED')); } } else { // Load all assigned mails $result = SQL_QUERY("SELECT m.id, m.admin_id, a.login, m.mail_template FROM `{?_MYSQL_PREFIX?}_admins_mails` AS m LEFT JOIN `{?_MYSQL_PREFIX?}_admins` AS a ON m.admin_id=a.id WHERE (m.admin_id=a.id OR m.admin_id < 1) AND m.mail_template != '' ORDER BY m.admin_id ASC, m.mail_template ASC", __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Shall I change entries? if (isPostRequestElementSet('change')) { // Init SQLs initSqls(); // Ok, update database foreach (postRequestElement('admin_id') as $id => $content['admin_id']) { // Secure IDs $id = bigintval($id); $content['admin_id'] = bigintval($content['admin_id']); // Update entry addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admins_mails` SET admin_id=%s WHERE `id`=%s ORDER BY `id` LIMIT 1", array($content['admin_id'], $id), __FILE__, __LINE__, false)); if (($content['admin_id'] < 1) && (isPostRequestElementSet('template', $id))) { // Remove any other admin entries addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admins_mails` WHERE mail_template='%s' AND id != '%s'", array(postRequestElement('template', $id), $id), __FILE__, __LINE__, false)); } // END - if if (postRequestElement('admin_new', postRequestElement('template', $id)) > 0) { // Add new admin addSql(SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_admins_mails` (admin_id, mail_template) VALUES ('%s','%s')", array($content['admin_id'], postRequestElement('template', $id)), __FILE__, __LINE__, false)); } // END - if } // END - foreach // Run all queries runFilterChain('run_sqls'); // Query again... $result = SQL_QUERY("SELECT m.id, m.admin_id, a.login, m.mail_template FROM `{?_MYSQL_PREFIX?}_admins_mails` AS m, `{?_MYSQL_PREFIX?}_admins` AS a WHERE m.admin_id=a.id OR m.admin_id < 1 ORDER BY m.admin_id", __FILE__, __LINE__); } // END - if // List found entries $OUT = ''; $SW = 2; while ($data = SQL_FETCHARRAY($result)) { // Prepare content $content = array( 'sw' => $SW, 'id' => $data['id'], 'tpl' => $data['mail_template'], 'alnk' => generateAdminLink($data['admin_id']) ); // Load row template $OUT .= loadTemplate('admin_admins_mails_list_row', true, $content); $SW = 3 - $SW; } // END - while // Free result SQL_FREERESULT($result); // Load template loadTemplate('admin_admins_mails_list', false, $OUT); } else { // No entries found loadTemplate('admin_settings_saved', false, getMessage('ADMINS_MAILS_NO_ENTRIES')); } } // [EOF] ?>