<span>
<?php
echo $clubname . " Page";
?>
</span>
</div>
<div class="nav">
<ul>
<a href="index.php"><li>Home</li></a>
<a><li class="active">About Us</li></a>
<a><li>Events</li></a>
<a id="club_join_button">
<li><?php
$isPart = $isLeader = 0;
if (isset($_SESSION['user'])) {
$isPart = isPartOfClub($_SESSION['user'], $clubId, $conn);
$isLeader = isHeadOfClub($_SESSION['user'], $clubId, $conn) | isAdmin($conn);
}
if ($isLeader == 1) {
echo "Edit Club";
} else {
if ($isPart == 0) {
echo "Join Club";
} else {
echo "Leave Club";
}
}
?>
</li>
</a>
<a class="login_nav_bar"><li>
if (isset($_GET['v'])) {
$username = "";
if (isset($_SESSION['user'])) {
$username = sanatizeInput($_SESSION['user']);
}
$value = sanatizeInput($_GET['v']);
$query = "SELECT c.id as id, c.name as name, c.mission_statement as mission, CONCAT_WS(', ', GROUP_CONCAT(DISTINCT leader.preferred_name, ' ', leader.last_name SEPARATOR ', ')) as leader_name, advisor.preferred_name as advisor_first, advisor.last_name as advisor_last\n FROM taftclubs.club as c\n INNER JOIN sgstudents.seniors_data as advisor\n ON c.advisor = advisor.id\n INNER JOIN taftclubs.clubjoiners as j\n ON c.id = j.clubId\n INNER JOIN sgstudents.seniors_data as leader\n ON leader.id = j.userId\n INNER JOIN taftclubs.clubcategories as category\n ON c.category = category.id\n WHERE j.hasLeft = 0 AND j.isLeader = 1 AND c.approved = 1 AND c.status = 5";
$result = "";
if ($value == 'All') {
$result = $conn->query($query . $endOfQuery);
} else {
$result = $conn->query($query . " AND c.name LIKE '%{$value}%'" . $endOfQuery);
}
if ($result->num_rows > 0) {
while ($item = $result->fetch_assoc()) {
echo constructCatSearchWidgetString($item['name'], $item['id'], $item['leader_name'], $item['advisor_first'], $item['advisor_last'], $item['mission'], isPartOfClub($username, $item['id'], $conn));
}
} else {
echo "Oops, There doesn't seem to be anything here yet! Try creating a club with this name!";
}
} else {
echo 'FATAL ERROR: MALFORMED QUERY->VALUE NOT SET';
}
} else {
echo "FATAL ERROR: MALFORMED QUERY->VALUE NOT SET";
}
}
}
}
$conn->close();
}
session_start();
$session = isset($_SESSION['user']);
$sessionUser = "";
if ($session) {
$sessionUser = $_SESSION['user'];
}
$action = "";
$value = "";
$response = array("success" => 0, "sqlError" => "");
if (isset($_GET['action'])) {
$conn = getSQLConnectionFromConfig();
$action = sanatizeInput($_GET['action']);
if ($action == "isPartOfClub" && $session && isset($_GET['value'])) {
$username = $sessionUser;
$value = sanatizeInput($_GET['value']);
$response['success'] = isPartOfClub($username, $value, $conn);
} else {
if ($action == "joinClub" && $session && isset($_GET['value'])) {
$username = $sessionUser;
$value = sanatizeInput($_GET['value']);
joinClub($username, $value, $conn);
$response['success'] = 1;
} else {
if ($action == "leaveClub" && $session && isset($_GET['value'])) {
$username = $sessionUser;
$value = sanatizeInput($_GET['value']);
leaveClub($username, $value, $conn);
$response['success'] = 1;
echo json_encode($response);
} else {
if ($action == "doesClubNameExist" && isset($_GET['value'])) {
