Example #1
0
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;
}
Example #2
0
    $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) {
Example #3
0
        } 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)) {
Example #4
0
<?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';
?>