query("UPDATE categories SET cat_id='$ord' WHERE id='$id'"); } form_ajax_response(0); exit(); case 'add': /* Create a new age category */ $q = $mysqli->query("SELECT MAX(cat_id) FROM categories WHERE year='{$config['year']}'"); if($q->num_rows > 0) { $r = $q->fetch_row(); $max_cat_id = $r[0] + 1; } else { $max_cat_id = 1; } $mysqli->real_query("INSERT INTO categories(`cat_id`,`name`,`shortform`,`min_grade`,`max_grade`,`year`) VALUES('$max_cat_id','New Category','N','12','13','{$config['year']}')"); $id = $mysqli->insert_id; /* Print the id so the caller can jump to the edit page with the right cat id */ print("$id"); exit(); case 'save': $id = (int)$_POST['id']; post_text($shortform, 'shortform'); post_text($name, 'name'); post_int($min_grade, 'min_grade'); post_int($max_grade, 'max_grade'); $shortform = $mysqli->real_escape_string($shortform); $name = $mysqli->real_escape_string($name); $mysqli->real_query("UPDATE categories SET `shortform`='$shortform',`name`='$name',min_grade='$min_grade',max_grade='$max_grade' WHERE id='$id'"); form_ajax_response(array('status'=>0, 'location'=>'c_config_categories.php')); exit(); case 'del': /* Delete by id (not cid) and year just to be safe */ $id = (int)$_POST['id']; $mysqli->real_query("DELETE FROM categories WHERE `id`='$id' AND `year`='{$config['year']}'"); form_ajax_response(0); exit(); } if(array_key_exists('edit', $_GET)) { $page = 'edit'; } else { $page = ''; } switch($page) { case 'edit': $id = (int)$_GET['edit']; $page_id = 'c_config_edit_category'; $help = '

'; sfiab_page_begin($u, "Edit Categories", $page_id, $help); ?>

&$c) { if($c['id'] == $id) { $category = $cid; } } /* Couldn't find the category */ if($category === NULL) { exit(); } ?>

Edit Age Category:

Cancel '; sfiab_page_begin($u, "Edit Categories", $page_id, $help); ?>

Use the Move button to drag and drop to re-order the categories. The category number always starts at 1 and increases by 1 for each category, and it may be used in the project number (depend on the project number configuration). $c) { ?>
Number ShortForm Name Min Grade Max Grade

New Category