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
lobbies.php
51 lines ASCII Windows (CRLF)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<!-- Lista av alla quiz -->
<?php
/** @var PDO $dbconn */
include "../dbconnection.php";
$sql = "SELECT * FROM JassGames
LEFT JOIN JassPlayers ON JassGames.ownerid = JassPlayers.playerid
WHERE isprivate=?";
$stmt = $dbconn->prepare($sql);
$data = array(0);
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$id = $res["gameid"];
$maxplayers = $res["maxplayers"];
$owner = $res["username"];
$sql = "SELECT * FROM GamePlayers WHERE gameid=?";
$players = $dbconn->prepare($sql);
$data = array($res["gameid"]);
$players->execute($data);
$playeramount = 0;
while ($players->fetch(PDO::FETCH_ASSOC)) {
$playeramount++;
}
$lobbyValue = "$owner's room: $playeramount/$maxplayers";
echo
'<form method="post" action="waitingRoom.php">
<input type="hidden" name="id" value="' . $id . '">
<input type="submit" name="join" value="' . $lobbyValue . '">
</form>
<br>';
}
?>
</body>
</html>