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)) {
