if (!mysql_num_rows($result)) { cpg_die(ERROR, $lang_catmgr_php['unknown_cat'], __FILE__, __LINE__); } $del_category = mysql_fetch_array($result); $parent = $del_category['parent']; $result = cpg_db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET parent='{$parent}' WHERE parent = '{$cid}'"); $result = cpg_db_query("UPDATE {$CONFIG['TABLE_ALBUMS']} SET category='{$parent}' WHERE category = '{$cid}'"); $result = cpg_db_query("DELETE FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid='{$cid}' LIMIT 1"); //delete from categorymap cpg_db_query("DELETE FROM {$CONFIG['TABLE_CATMAP']} WHERE cid='{$cid}'"); break; } fix_cat_table(); get_subcat_data(0); if ($CONFIG['categories_alpha_sort'] != 1) { update_cat_order(); } pageheader($lang_catmgr_php['manage_cat']); echo <<<EOT <script language="javascript" type="text/javascript"> function confirmDel(catName) { return confirm("{$lang_catmgr_php['confirm_delete']} (" + catName + ") ?"); } function build(target, category){ if (target.length > 1) return; pos = target.options[0];
if ($cat_name == "") { $error['cat_name'] = 1; } if (empty($error)) { if (!$cat_order) { $sql = "SELECT cat_order\n FROM " . CATEGORIES_TABLE . "\n WHERE cat_parent_id = {$cat_parent_id}\n ORDER BY cat_order DESC\n LIMIT 1"; $catorder = $site_db->query_firstrow($sql); $cat_order = $catorder['cat_order'] + 10; $do_update_cat_order = 0; } else { $do_update_cat_order = 1; } $sql = "UPDATE " . CATEGORIES_TABLE . "\n SET cat_name = '{$cat_name}', cat_description = '{$cat_description}', cat_parent_id = {$cat_parent_id}, cat_order = {$cat_order}, cat_hits = {$cat_hits}, auth_viewcat = {$auth_viewcat}, auth_viewimage = {$auth_viewimage}, auth_download = {$auth_download}, auth_upload = {$auth_upload}, auth_directupload = {$auth_directupload}, auth_vote = {$auth_vote}, auth_sendpostcard = {$auth_sendpostcard}, auth_readcomment = {$auth_readcomment}, auth_postcomment = {$auth_postcomment}\n WHERE cat_id = {$cat_id}"; $result = $site_db->query($sql); if ($result && $do_update_cat_order) { update_cat_order($cat_parent_id); } $msg = $result ? $lang['cat_edit_success'] : $lang['cat_edit_error']; //$action = "modifycats"; forward_to_modify($msg); } else { $msg .= sprintf("<span class=\"marktext\">%s</span>", $lang['lostfield_error']); $action = "editcat"; } } if ($action == "editcat") { if ($msg != "") { printf("<b>%s</b>\n", $msg); } $cat_id = isset($HTTP_POST_VARS['cat_id']) ? intval($HTTP_POST_VARS['cat_id']) : intval($HTTP_GET_VARS['cat_id']); $sql = "SELECT cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment\n FROM " . CATEGORIES_TABLE . "\n WHERE cat_id = {$cat_id}";