".CATEGORY_ALREADY_EXISTS.""; } // Free memory SQL_FREERESULT($result); // Display message LOAD_TEMPLATE("admin_settings_saved", false, $content); } elseif ((IS_FORM_SENT()) && (REQUEST_ISSET_POST(('id'))) && (is_array(REQUEST_POST('id')))) { // Change or delete categories... $TEXT = ""; foreach (REQUEST_POST('id') as $id => $cat) { // Secure ID $id = bigintval($id); // Is the entry set? if (!empty($cat)) { switch (REQUEST_GET('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, REQUEST_POST('vis', $id), REQUEST_POST('sort', $id), $id ), __FILE__, __LINE__); $TEXT = 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 = CATEGORIES_DELETED; break; } } else { // Entry not saved $TEXT .= sprintf(CATEGORY_NOT_SAVED, $id); } } if (isset($TEXT)) { // Display message LOAD_TEMPLATE("admin_settings_saved", false, $TEXT); } } elseif ((REQUEST_ISSET_POST('del')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) { // Delete categories $OUT = ""; $SW = 2; foreach (REQUEST_POST('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); SQL_FREERESULT($result); // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $id, 'cat' => $cat, ); // Load row template and switch colors $OUT .= LOAD_TEMPLATE("admin_del_cats_row", true, $content); $SW = 3 - $SW; } define('__CAT_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_del_cats"); } elseif ((REQUEST_ISSET_POST('edit')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) { // Edit categories $OUT = ""; $SW = 2; foreach (REQUEST_POST('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' => ADD_SELECTION("yn", $vis, "vis", $id), 'sort' => $sort, ); // Load row template and switch colors $OUT .= LOAD_TEMPLATE("admin_edit_cats_row", true, $content); $SW = 3 - $SW; } define('__CAT_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_edit_cats"); } else { // Init variable here $CATS = ""; // Load all categories $result = SQL_QUERY("SELECT id, cat, visible, sort FROM `{!_MYSQL_PREFIX!}_cats` ORDER BY `sort`", __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'] = TRANSLATE_YESNO($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 .= LOAD_TEMPLATE("admin_config_cats_row", true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); // @TODO Rewrite this constant define('__CAT_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_config_cats"); } // @TODO Rewrite this constant define('CATS', $CATS); // Form to add a new category LOAD_TEMPLATE("admin_add_cat"); } // ?>