ODLinks Sturcture - Add/Edit Categories

'; switch ($_GET['odlinks_admin_action']){ case "saveCategory": if ($id==0){ $today = date("Y-m-d"); if ($_POST['odlinksdata']['c_hide']=='y'){ $c_hide = "hidden"; }else{$c_hide = "visible";} $position = $wpdb->get_var("SELECT MAX(c_position) FROM {$table_prefix}odcategories")+1; $sql = "INSERT INTO {$table_prefix}odcategories (c_parent, c_name, c_title, c_description, c_keywords, c_position, c_status, c_hide, c_date) values ('".($_POST['odlinksdata']['c_parent']*1)."', '".$wpdb->escape($_POST['odlinksdata']['c_name'])."', '".$wpdb->escape($_POST['odlinksdata']['c_title'])."', '".$wpdb->escape($_POST['odlinksdata']['c_description'])."', '".$wpdb->escape($_POST['odlinksdata']['c_keywords'])."', '".$position."', '".$wpdb->escape($_POST['odlinksdata']['c_status'])."', '".$c_hide."', '".$today."')"; $wpdb->query($sql); } else { if ($_POST['odlinksdata']['c_hide']=='y'){ $c_hide = "hidden"; } else{ $c_hide = "visible"; } $sql = "UPDATE {$table_prefix}odcategories SET c_status = '".$wpdb->escape($_POST['odlinksdata']['c_status'])."', c_hide = '".$c_hide."', c_parent = '".($_POST['odlinksdata']['c_parent']*1)."', c_title = '".$wpdb->escape(stripslashes($_POST['odlinksdata']['c_title']))."', c_name = '".$wpdb->escape(stripslashes($_POST['odlinksdata']['c_name']))."', c_status = '".$wpdb->escape(stripslashes($_POST['odlinksdata']['c_status']))."', c_hide = '".$c_hide."', c_description = '".$wpdb->escape(stripslashes($_POST['odlinksdata']['c_description']))."' WHERE c_id = '".($_GET['c_id']*1)."'"; $wpdb->query($sql); } $msg ="Category Saved."; break; case "editCategory": odl_edit_category($id); $view = false; break; case "deleteCategory": if ($id<>0) { $wpdb->query("DELETE FROM {$table_prefix}odcategories WHERE c_id = '".($id)."'"); $wpdb->query("DELETE FROM {$table_prefix}odlinks WHERE l_c_id = '".($id)."'"); } break; } if ($msg!=''){ ?>

'; } function odl_edit_category($id) { global $_GET, $_POST, $table_prefix, $PHP_SELF, $wpdb; $odlinkssettings = get_option('odlinksdata'); $odCategories = $wpdb->get_row("SELECT * FROM {$table_prefix}odcategories WHERE c_id = '".($id)."'", ARRAY_A); ?>

Edit Category





> -Hide Category?

  

"Open",inactive=>"Closed",readonly=>"Read-Only"); ?>

- delete category, including subcategories and all links within.

Title / Name Number of links Date Delete
get_results("SELECT * FROM {$table_prefix}odcategories WHERE c_parent = '$parent' ORDER BY c_title ASC"); for ($i=0; $iget_row("SELECT * FROM {$table_prefix}odlinks WHERE l_c_id = '".$category->c_id."'", ARRAY_A); $linksNum = count($res); $id = $category->c_id; $title = $category->c_title; $sel = ""; if($id == $selected){$sel = " selected ";} if($id != $exclude){echo "";} $out = odl_list_cats($id, $lev + 1, $exclude, $selected); } return $out; } function odl_main_cats($parent,$lev,$orderby,$how) { global $table_prefix, $wpdb; $out = ""; if($lev == 0){print "\n";} if(!$how){$how = "ASC";} if($orderby <> "c_date"){$orderby = "c_title";} $space = ""; ?> get_results($sql); for ($i=0; $iget_row("SELECT count(l_id) as count FROM {$table_prefix}odlinks WHERE l_c_id = '".$category->c_id."'", ARRAY_A); $linksNum = $linksCnt['count']; $id = $category->c_id; $title = $category->c_title; $name = $category->c_name; $categoy_status = array(active=>"Open",inactive=>"Closed",readonly=>"Read-Only"); $status = $categoy_status[$category->c_status]; echo ''; echo ' ' . $space; ?> (" . $status; echo ($tfs->c_hide=='hidden')?" and Hidden":""; echo ")"; echo '('. $linksNum .')'; echo ''.$category->c_date.''; ?> c_name );?>', '?page=odlinksstructure&odlinks_admin_page_arg=&odlinks_admin_action=deleteCategory&c_id=');">