function startApplication($user_id, $club_id) { $user_id = escape($user_id); $club_id = escape($club_id); if (isApplicationStarted($user_id, $club_id)) { //already present return -1; } //if it's a club, verify existence if ($club_id != 0 && !clubExists($club_id)) { return -2; } //make sure it is available at this time if (!isAvailableWindow($club_id)) { return -3; } //subscribe to the club, since we're applying to it anyway if ($club_id != 0) { addSubscription($user_id, $club_id); } //add to applications table first mysql_query("INSERT INTO applications (user_id, club_id, submitted) VALUES ('{$user_id}', '{$club_id}', '')"); $application_id = mysql_insert_id(); //now insert blank answers to answers table if ($club_id == 0) { $result = mysql_query("SELECT id FROM baseapp WHERE category != '0' AND category != '-1'"); } else { $result = mysql_query("SELECT id FROM supplements WHERE club_id='{$club_id}'"); } while ($row = mysql_fetch_array($result)) { $question_id = escape($row['id']); mysql_query("INSERT INTO answers (application_id, var_id, val) VALUES ('{$application_id}', '{$question_id}', '')"); } return 0; }
if(substr($side_display[$i], 0, 10) == "supplement" && isset($_SESSION['user_id'])) { //display all the supplements this user is working on $styleClubsApplied = getUserClubsApplied($_SESSION['user_id']); echo "<ul>"; foreach($styleClubsApplied as $styleItem) { $style_club_id = $styleItem[0]; $style_club_name = $styleItem[1]; echo "<li class=\"sidenav1\"><a href=\"app.php?club_id=$style_club_id&action=view\">$style_club_name</a></li>"; } echo "</ul>"; } else if(substr($side_display[$i], 0, 4) == "base" && isset($_SESSION['user_id'])) { //display the general application categories include_once($basePath . "/include/apply_submit.php"); if(isApplicationStarted($_SESSION['user_id'], 0)) { $styleCategoryList = listCategories(); echo "<ul>"; foreach($styleCategoryList as $styleItem) { $style_cat_id = $styleItem[0]; $style_cat_name = $styleItem[1]; echo "<li class=\"sidenav1\"><a href=\"app.php?club_id=0&cat_id=$style_cat_id&action=view\">$style_cat_name</a></li>"; } echo "</ul>"; } } else if(substr($side_display[$i], 0, 17) == "root_cat.php?cat=") { $nav_cat = urldecode(substr($side_display[$i], 17)); } if(isset($nav_cat)) {