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; }
$relayID; $query = "SELECT max(relayID) FROM relays WHERE EventID = {$event}"; if ($result = $conn->query($query)) { $relayID = $result->fetch_row()[0] + 1; //Increment EventID by 1 } else { die("Latest RelayID could not be determined!"); } //Set track count to 0 $trackCount = 0; //Set default name $relayName = "Lag " . $relayID; } //Get runner info and format $Runners = "<option value='none'>Löpare \"+ abc + \"</option>"; foreach (GetAllRunnerData($conn, $event) as $key => $track) { foreach ($track as $key => $runner) { $Runners .= "<option value='" . $runner["ID"] . "'>" . $runner["FirstName"] . " " . $runner["LastName"] . "</option>"; } } //Select Template $selectTemplate = "\n\t\t\t<select name='row\" + rowcount + abc +\"' class='form-control'>\n\t\t\t\t{$Runners}\n\t\t\t</select>\n\t"; $selectTemplate = preg_replace("/[\r\n]*/", "", $selectTemplate); //Put template on one line //Row Template $rowTemplate = "\n\t\t\t<h4>Sträcka \" + parseInt(i + 1) + \"</h4>\n\t\t\t<div class='col-sm-2'>\n\t\t\t\t{$selectTemplate}\n\t\t\t</div>\n\t\t\t<div id='lastCol\" + i + \"' class='col-sm-2'>\n\t\t\t\t<div class='addCol' data-colcount='1'><span class='glyphicon glyphicon-plus'></span> Lägg till parallelsträcka</div>\n\t\t\t</div>\n\t"; $rowTemplate = preg_replace("/[\r\n]*/", "", $rowTemplate); //Put template on one line //Check for password $unlockEdit = isset($_GET["unlockEdit"]) ? $_GET['unlockEdit'] : ''; if ($password = $conn->query("SELECT Password FROM event WHERE EventID = {$event}")->fetch_object()->Password) {
} else { if ($_POST["que"] != $authphrase) { die(header("Location: anmal")); } else { setcookie("administrator", "auth", time() + 3600); } } } } else { header("Location: anmal"); } $whatis = "listall"; if (isset($_GET["event"]) && !isset($_GET["track"])) { $e = GetEventData($conn, $_GET["event"]); $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)) {
<?php //Conn include 'php/config.php'; $Events = GetAllEventData($conn); //User events $MyEvents = "<ul class='list-group'>"; foreach (array_reverse($Events) as $key => $event) { foreach (GetAllRunnerData($conn, $event["EventID"]) as $key => $track) { foreach ($track as $key => $runner) { if ($userID === $runner["UserID"]) { $MyEvents .= "<li class='list-group-item'><h5><a href='anmal?event=" . $event["EventID"] . "'>" . $event["Name"] . "</a> - " . $runner["FirstName"] . " " . $runner["LastName"] . "</h5></li>"; } } } } $MyEvents .= "</ul>"; //Confirm relays $relaysToConfirm = false; $ConfirmRelays = "<div class='list-group'>"; foreach ($Events as $key => $event) { foreach (GetAllRelayData($conn, $event["EventID"]) as $key => $relay) { if ($relay["Public"]) { $ConfirmRelays .= "<a href='bekrafta?event=" . $event["EventID"] . "&relay=" . $relay["RelayID"] . "' class='list-group-item list-group-item-info'>\n\t\t\t\t\tBekräfta laguppställning för " . $event["Name"] . " - " . $relay["RelayName"] . "</a>"; $relaysToConfirm = true; } } } $ConfirmRelays .= "</div>"; include 'php/views/header.php'; ?>