+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ // Display message
+ displayMessage($content);
+} elseif ((isFormSent()) && (ifPostContainsSelections('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('visible', $id),
+ postRequestElement('sort', $id),
+ $id
+ ), __FILE__, __LINE__);
+ $TEXT = '{--ADMIN_CATEGORIES_SAVED--}';
+ break;
+
+ case 'delete': // 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 = '{--ADMIN_CATEGORIES_DELETED--}';
+ break;
+ } // END - switch
+ } else {
+ // Entry not saved
+ $TEXT .= '{%message,ADMIN_CATEGORY_NOT_SAVED=' . $id . '%}';
+ }
+ } // END - foreach
+
+ if (isset($TEXT)) {
+ // Display message
+ displayMessage($TEXT);
+ } // END - if
+} elseif ((isFormSent('delete')) && (ifPostContainsSelections())) {
+ // Delete categories
+ $OUT = '';
+ foreach (postRequestElement('sel') as $id => $value) {
+ // Load row template and switch colors
+ $OUT .= loadTemplate('admin_delete_cats_row', TRUE, $id);
+ } // END - foreach
+
+ // Load main template
+ loadTemplate('admin_delete_cats', FALSE, $OUT);
+} elseif ((isFormSent('edit')) && (ifPostContainsSelections())) {
+ // Edit categories
+ $OUT = '';
+ foreach (postRequestElement('sel') as $id => $value) {
+ // Load data from the category
+ $result = SQL_QUERY_ESC("SELECT `id`, `visible`, `sort` FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ $content = SQL_FETCHARRAY($result);
+
+ // Free result
+ SQL_FREERESULT($result);
+
+ // Prepare data for the row template
+ $content['visible_selection'] = addSelectionBox('yn', $content['visible'], 'visible', $content['id']);
+
+ // Load row template and switch colors
+ $OUT .= loadTemplate('admin_edit_cats_row', TRUE, $content);
+ } // END - foreach
+
+ // Load main template
+ loadTemplate('admin_edit_cats', FALSE, $OUT);