function DumpEventData($conn, $event, $json)
{
$EventData = [];
foreach (GetEventData($conn, $event) as $key => $value) {
$EventData["Event"][$key] = $value;
}
foreach (GetTrackData($conn, $event) as $key => $value) {
$EventData["Tracks"][$key] = $value;
}
foreach (GetAllRelayData($conn, $event) as $key => $value) {
$EventData["Relays"][$key] = $value;
}
foreach (GetAllRunnerData($conn, $event) as $key => $value) {
$EventData["Runners"][$key] = $value;
}
//Encode data
if ($json == true) {
$EventData = json_encode($EventData);
}
return $EventData;
}
$runnerSex = isset($_POST["sex"]) ? $_POST['sex'] : '';
$runnerSI = isset($_POST["siNumber"]) ? $_POST['siNumber'] : '';
$runnerData = ["Födelsedatum" => $runnerBday, "Kön" => $runnerSex, "SI-Nummer" => $runnerSI];
$runnerData = json_encode($runnerData, JSON_UNESCAPED_UNICODE);
$runnerData = SanitizeInput($runnerData);
//Check if name is empty
if ($runnerFirstName == "") {
$runnerFirstName = "Inget förnamn";
}
if ($runnerLastName == "") {
$runnerLastName = "Inget efternamn";
}
if ($runnerMsg == "") {
$runnerMsg = "";
}
if ($runnerTrack == "none" || !isset($runnerTrack)) {
$trackdata = GetTrackData($conn, $eventID);
if (empty($trackdata)) {
$sql = "INSERT INTO runners (FirstName, LastName, UserID, EventID, Track, RelayConfirm, RelayMessage, RunnerData) \n\t\t\tVALUES ('{$runnerFirstName}', '{$runnerLastName}', '{$userID}', {$eventID}, 1, '', '{$runnerMsg}', '{$runnerData}')";
} else {
die("notrack");
}
} else {
$sql = "INSERT INTO runners (FirstName, LastName, UserID, EventID, Track, RelayConfirm, RelayMessage, RunnerData) \n\t\tVALUES ('{$runnerFirstName}', '{$runnerLastName}', '{$userID}', {$eventID}, {$runnerTrack}, '', '{$runnerMsg}', '{$runnerData}')";
}
//Add to db
if ($conn->query($sql) === TRUE) {
echo "Anmäld!";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$t = GetTrackData($conn, $_GET["event"]);
$r = GetAllRunnerData($conn, $_GET["event"]);
if (empty($e)) {
die(include 'php/views/notfound.php');
}
$whatis = "event";
} elseif (isset($_GET["user"])) {
$e = GetAllEventData($conn);
$u = GetUserRunnersData($conn, $_GET["user"]);
if (empty($e)) {
die(include 'php/views/notfound.php');
}
$whatis = "user";
} elseif (isset($_GET["track"]) && isset($_GET["event"])) {
$e = GetEventData($conn, $_GET["event"]);
$t = GetTrackData($conn, $_GET["event"]);
if (empty($e)) {
die(include 'php/views/notfound.php');
}
//Format track
foreach ($t as $key => $v) {
if ($v["ID"] == $_GET["track"]) {
$t = $v;
}
}
$whatis = "track";
} else {
$e = GetAllEventData($conn);
$whatis = "listall";
}
include 'php/views/header.php';
}
//If closing date has passed
$expired = false;
$hasEndtime = false;
if ($EventData["ClosingDate"] != "2099-01-01 23:59:59") {
$hasEndtime = true;
if (strtotime(date("Y-m-d H:i:s")) > strtotime($EventData["ClosingDate"])) {
$expired = true;
if ($EventData["BlockOnClose"]) {
die(include "php/views/expired.php");
}
}
}
//Get track vars and format
$Tracks = "";
foreach (GetTrackData($conn, $event) as $key => $track) {
if ($track["Name"] == "notracks" && $track["Length"] == "notracks") {
$Tracks .= "<option value='" . $track["TrackID"] . "' selected>Inga banor på detta event</option>";
} else {
$Tracks .= "<option value='" . $track["TrackID"] . "'>" . $track["Name"] . " - " . $track["Length"] . "</option>";
}
}
//User registered tracks
$MyTracks = "";
foreach (UserTracks($conn, $event, $userID) as $key => $track) {
//If there are tracks
if ($track['TrackName'] != "notracks" && $track['TrackLength'] != "notracks") {
$hastracks = " - " . $track["TrackName"] . " " . $track["TrackLength"];
} else {
$hastracks = "";
}
