{--CATEGORY_ALREADY_EXISTS--}'; } // Free memory SQL_FREERESULT($result); // Display message loadTemplate('admin_settings_saved', false, $content); } elseif ((isFormSent()) && (isPostRequestParameterSet('id')) && (is_array(postRequestParameter('id')))) { // Change or delete categories... $TEXT = ''; foreach (postRequestParameter('id') as $id => $cat) { // Secure id $id = bigintval($id); // Is the entry set? if (!empty($cat)) { switch (getRequestParameter('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, postRequestParameter('visible', $id), postRequestParameter('sort', $id), $id ), __FILE__, __LINE__); $TEXT = '{--ADMIN_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 = '{--ADMIN_CATEGORIES_DELETED--}'; break; } // END - switch } else { // Entry not saved $TEXT .= getMaskedMessage('ADMIN_CATEGORY_NOT_SAVED', $id); } } // END - foreach if (isset($TEXT)) { // Display message loadTemplate('admin_settings_saved', false, $TEXT); } // END - if } elseif ((isFormSent('del')) && (ifPostContainsSelections())) { // Delete categories $OUT = ''; foreach (postRequestParameter('sel') as $id => $value) { // Load row template and switch colors $OUT .= loadTemplate('admin_del_cats_row', true, $id); } // END - foreach // Load main template loadTemplate('admin_del_cats', false, $OUT); } elseif ((isFormSent('edit')) && (ifPostContainsSelections())) { // Edit categories $OUT = ''; foreach (postRequestParameter('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('form_submit_cats_row', true, $content); } // END - foreach // Load main template loadTemplate('form_submit_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_config_cats_row', true, $content); } // 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] ?>