//ADD A NEW SAVED CATEGORY if (isset($_GET['new_category'])) { //if we are adding a new category to DB: $new_category = $_GET['new_category']; $new_category_points = $_GET['new_category_points']; $multiple_choice = $_GET['multiple_choice']; $pool = new Pool(); if (isset($_GET['template_id'])) { //if we are adding a category to a template: $template_id = $_GET['template_id']; $new_category_id = $pool->AddTemplateCategory($template_id, $new_category, $new_category_points, $multiple_choice); //AddTemplateCategory FUNCTION RETURNS CATEGORY ID OF NEWLY ADDED CATEGORY $pool_categories = $pool->GetTemplateCategories($template_id); } else { //if we are not adding a category to a template: $new_category_id = $pool->AddCategory($pool_id, $new_category, $new_category_points, $multiple_choice); //AddCategory FUNCTION RETURNS CATEGORY ID OF NEWLY ADDED CATEGORY $pool_categories = $pool->GetPoolCategoryData($pool_id); } $number_of_saved_categories = count($pool_categories); if ($number_of_saved_categories > 0) { $return_value = Update_Category_List($pool_categories, $multiple_choice); $return_array = array(0 => $return_value, 1 => $new_category_id); echo json_encode($return_array); //return JSON encoded array (this goes to the save_new_category javascript ajax function in the edit_pool.php file) } } //ADD A NEW SAVED CATEGORY CHOICE (FOR MULTIPLE CHOICE POOLS) if (isset($_GET['new_category_choice'])) { //if we are adding a new category to DB: $category_id = $_GET['category_id'];
$pool_id = $_GET['pool_id']; //get pool ID from URL of page $pool = new Pool(); //new instance of the Pool class $pool_fetch_result = $pool->GetPoolData($pool_id); //get pool data based on pool ID that is passed in URL if (isset($pool_fetch_result['Leader ID']) && $_SESSION['Username'] != $pool_fetch_result['Leader ID']) { //if the currently logged in user is not the pool leader, we do not allow them to edit the pool and we return them to the home page: header("Location: home.php"); exit; } //if the page loads after submitting the "Add new category form", we add the new category before generating the array of all the pool categories: if (isset($_POST['new_category'])) { $new_category = $_POST['new_category']; $new_category_pt_value = $_POST['new_category_points']; $pool->AddCategory($pool_fetch_result["Pool ID"], $new_category, $new_category_pt_value); } //create an array of all of the categories for the given pool ($pool_categories) $pool_categories = $pool->GetPoolCategoryData($pool_id); //get the number of saved cateogires $number_of_saved_categories = count($pool_categories); } if ($pool_fetch_result == 0) { //if the pool id passed thru url does not exist in database: ?> <p>Error: pool does not exist</p> <p><a href="home.php">Click here to return to home page</a></p> <?php } else { ?> <!--Jquery script for adding and removing new categories to form-->