//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-->
