{--CATEGORY_ALREADY_EXISTS--}'; } // Free memory SQL_FREERESULT($result); // Display message displayMessage($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('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); } 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_HASZERONUMS($result)) { // Init variables $OUT = ''; // List already existing categories for editing while ($content = SQL_FETCHARRAY($result)) { // Put cat descriptions into variable for the selection box $cat = $content['cat']; if (strlen($cat) > 40) $cat = substr($cat, 0, 37) . '...'; $CATS .= '' . $cat . ''; // Load row template and switch color $OUT .= loadTemplate('admin_list_cats_row', true, $content); } // END - while // Free memory SQL_FREERESULT($result); // Load main template loadTemplate('admin_list_cats', false, $OUT); } // END - if // Remember in array $content['cats'] = $CATS; // Form to add a new category loadTemplate('admin_add_cat', false, $content); } // [EOF] ?>