{--CATEGORY_ALREADY_EXISTS--}"; } // Free memory SQL_FREERESULT($result); // Display message loadTemplate('admin_settings_saved', false, $content); } elseif ((isFormSent()) && (isPostRequestElementSet('id')) && (is_array(postRequestElement('id')))) { // Change or delete categories... $TEXT = ''; foreach (postRequestElement('id') as $id => $cat) { // Secure id $id = bigintval($id); // Is the entry set? if (!empty($cat)) { switch (getRequestElement('do')) { case 'edit': // Change categories SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_cats` SET cat='%s', `visible`='%s', sort=%s WHERE `id`=%s LIMIT 1", array( $cat, postRequestElement('vis', $id), postRequestElement('sort', $id), $id ), __FILE__, __LINE__); $TEXT = getMessage('CATEGORIES_SAVED'); break; case 'del': // Delete categories SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1", array($id), __FILE__, __LINE__); SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE cat_id=%s", array($id), __FILE__, __LINE__); $TEXT = getMessage('CATEGORIES_DELETED'); break; } } else { // Entry not saved $TEXT .= sprintf(getMessage('CATEGORY_NOT_SAVED'), $id); } } if (isset($TEXT)) { // Display message loadTemplate('admin_settings_saved', false, $TEXT); } } elseif ((isPostRequestElementSet('del')) && (countPostSelection() > 0)) { // Delete categories $OUT = ''; $SW = 2; foreach (postRequestElement('sel') as $id => $value) { // Load data of category $result = SQL_QUERY_ESC("SELECT `cat` FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($cat) = SQL_FETCHROW($result); // Free result SQL_FREERESULT($result); // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $id, 'cat' => $cat, ); // Load row template and switch colors $OUT .= loadTemplate('admin_del_cats_row', true, $content); $SW = 3 - $SW; } // Load main template loadTemplate('admin_del_cats', false, $OUT); } elseif ((isPostRequestElementSet('edit')) && (countPostSelection() > 0)) { // Edit categories $OUT = ''; $SW = 2; foreach (postRequestElement('sel') as $id => $value) { // Load data from the category $result = SQL_QUERY_ESC("SELECT cat, visible, sort FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($cat, $vis, $sort) = SQL_FETCHROW($result); SQL_FREERESULT($result); // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $id, 'cat' => $cat, 'vis' => addSelectionBox('yn', $vis, 'vis', $id), 'sort' => $sort, ); // Load row template and switch colors $OUT .= loadTemplate('admin_edit_cats_row', true, $content); $SW = 3 - $SW; } // Load main template loadTemplate('admin_edit_cats', false, $OUT); } else { // Init variable here $CATS = ''; // Load all categories $result = SQL_QUERY("SELECT `id`, `cat`, `visible`, `sort` FROM `{?_MYSQL_PREFIX?}_cats` ORDER BY `sort` ASC", __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Init variables $OUT = ''; $SW = 2; // List already existing categories for editing while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the row template $content['sw'] = $SW; $content['vis'] = translateYesNo($content['visible']); // Put cat descriptions into variable for the selection box if (strlen($content['cat']) > 20) $content['cat'] = substr($content['cat'], 0, 17)."..."; $CATS .= " ".$content['cat']."\n"; // Load row template and switch color $OUT .= loadTemplate('admin_config_cats_row', true, $content); $SW = 3 - $SW; } // END - while // Free memory SQL_FREERESULT($result); // Load main template loadTemplate('admin_config_cats', false, $OUT); } // END - if // Remember in array $content['cats'] = $CATS; // Form to add a new category loadTemplate('admin_add_cat', false, $content); } // [EOF] ?>