query("UPDATE challenges SET chal_id='$ord' WHERE id='$id'"); } form_ajax_response(0); exit(); case 'add': /* Create a new age challenge */ $q = $mysqli->query("SELECT MAX(chal_id) FROM challenges WHERE year='{$config['year']}'"); if($q->num_rows > 0) { $r = $q->fetch_row(); $max_chal_id = $r[0] + 1; } else { $max_chal_id = 1; } $mysqli->real_query("INSERT INTO challenges(`chal_id`,`name`,`shortform`,`year`) VALUES('$max_chal_id','New Challenge','N','{$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'); $shortform = $mysqli->real_escape_string($shortform); $name = $mysqli->real_escape_string($name); $mysqli->real_query("UPDATE challenges SET `shortform`='$shortform',`name`='$name' WHERE id='$id'"); form_ajax_response(array('status'=>0, 'location'=>'c_config_challenges.php')); exit(); case 'del': /* Delete by id (not cid) and year just to be safe */ $id = (int)$_POST['id']; $mysqli->real_query("DELETE FROM challenges 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_challenge'; $help = '

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

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

Edit Age Challenge:

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

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

New Challenge