Show sourcecode
The following files exists in this folder. Click to view.
admin.php
bilder/
checkUpdates.php
confirmPassword.php
confirmSignIn.php
createadmin.php
endScreen.php
getBoard.php
getChat.php
getHand.php
getTurnPlayer.php
lobbies.php
logIn.php
play.php
playCard.php
signIn.php
start.php
startsida.php
style.css
tables.php
update.php
updatePassword.php
waitInfo.php
waitingRoom.php
admin.php
165 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
<?php
/** @var PDO $dbconn */
include ("start.php");
// Omdirigera till inloggningssidan om användaren inte är en admin
if ($_COOKIE["type"] != "admin") {
header("location: logIn.php");
}
// Om ett spel valts för att raderas, radera den
if (isset($_POST["gameid"]) && !empty($_POST["gameid"])) {
deleteGame($dbconn, $_POST["gameid"]);
}
?>
<table class="table"><caption><strong>Konton</strong></caption>
<tr>
<td>ID</td>
<td>Username</td>
<td>Password</td>
<td>E-mail</td>
<td>Type</td>
<td>Disabled</td>
</tr>
<?php
// Skriv ut alla användare i en tabell
$sql = "SELECT * FROM JassPlayers";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$id = $res["playerid"];
$user = $res["username"];
$pwd = $res["password"];
$mail = $res["mail"];
$type = $res["type"];
$disabled = "False";
if ($res["disabled"] != 0) {
$disabled = "True";
}
// Skriv ut ID
echo "<tr><td>$id</td>";
// Skriv ut användarnamnet
echo "<td>$user</td>";
// Skriv ut lösenordet
echo "<td>$pwd</td>";
// Skriv ut mailen
echo "<td>$mail</td>";
// Skriv ut typ
echo "<td>$type</td>";
// Skriv ut disabled
echo "<td>$disabled</td>";
// Skapa en knapp för att uppdatera
echo "<td><form method='post' action='update.php'>
<input type='hidden' value='$id' name='playerid'>
<input type='submit' value='Uppdatera'>
</form></td></tr>";
}
?>
</table>
<table class="table"><caption><strong>Spel</strong></caption>
<tr>
<td>ID</td>
<td>Max players</td>
<td>Trumf</td>
<td>Turnplayer ID</td>
<td>Private?</td>
<td>Owner ID</td>
<td>Code</td>
<td></td>
</tr>
<?php
// Skriv ut alla spel i en tabell
$sql = "SELECT * FROM JassGames";
$games = $dbconn->prepare($sql);
$data = array();
$games->execute($data);
while ($res = $games->fetch(PDO::FETCH_ASSOC)) {
$id = $res["gameid"];
$maxplayers = $res["maxplayers"];
$trumf = $res["trumf"];
$turnplayerid = $res["turnplayerid"];
$isprivate = $res["isprivate"];
$ownerid = $res["ownerid"];
$code = $res["code"];
// Skriv ut id
echo "<tr><td>$id</td>";
// Skriv ut max antal spelare
echo "<td>$maxplayers</td>";
// Skriv ut trumf
echo "<td>$trumf</td>";
// Skriv ut turspelarens id
echo "<td>$turnplayerid</td>";
// Skriv ut om lobbyn är privat
echo "<td>$isprivate</td>";
// Skriv ut om ägarens id
echo "<td>$ownerid</td>";
// Skriv ut om koden
echo "<td>$code</td>";
// Skapa en knapp för att ta bort ett konto
echo "<td><form method='post'>
<input type='hidden' value='$id' name='gameid'>
<input type='submit' name='delete' value='Ta Bort'>
</form></td></tr>";
}
?>
</table>
<table class="table"><caption><strong>Spel</strong></caption>
<tr>
<td>ID</td>
<td>Game ID</td>
<td>Player ID</td>
</tr>
<?php
// Skriv ut alla spelare som är i ett spel i en tabell
$sql = "SELECT * FROM GamePlayers";
$gameplayers = $dbconn->prepare($sql);
$data = array();
$gameplayers->execute($data);
while ($res = $gameplayers->fetch(PDO::FETCH_ASSOC)) {
$id = $res["gameplayerid"];
$gameid = $res["gameid"];
$playerid = $res["playerid"];
// Skriv ut id
echo "<tr><td>$id</td>";
echo "<td>$gameid</td>";
echo "<td>$playerid</td></tr>";
}
?>
</table>
<!-- Länkar -->
<a href="startsida.php">Startsida</a> <br>
<a href="tables.php">Create/delete tables</a> <br>
</body>
</html>
</html>