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
endScreen.php
84 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
<?php
/** @var PDO $dbconn */
include ("start.php");
$userid = $_COOKIE["playerid"];
$sql = "SELECT * FROM GamePlayers
LEFT JOIN JassGames ON GamePlayers.gameid=JassGames.gameid
WHERE GamePlayers.playerid=?";
$stmt = $dbconn->prepare($sql);
$data = array($userid);
$stmt->execute($data);
if ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$gameid = $res["gameid"];
$playerid = $res["playerid"];
$trumf = $res["trumf"];
$ownerid = $res["ownerid"];
$sql = "SELECT * FROM GamePlayers
LEFT JOIN JassPlayers ON GamePlayers.playerid=JassPlayers.playerid
WHERE GamePlayers.gameid=?";
$stmt = $dbconn->prepare($sql);
$stmt->execute(array($gameid));
$currentPlayer = 1;
while ($gameplayer = $stmt->fetch(PDO::FETCH_ASSOC)) {
$id = $gameplayer["playerid"];
$name = $gameplayer["username"];
$sql = "SELECT * FROM JassPlayerCards WHERE playerid=?";
$cardStmt = $dbconn->prepare($sql);
$cardStmt->execute(array($id));
$value = 0;
while ($card = $cardStmt->fetch(PDO::FETCH_ASSOC)) {
if ($card["value"] == "9" && $card["color"] == $trumf) {
// Om kortet är trumf 9(nell) är den värd 14 poäng
$value += 14;
}
else if ($card["value"] == "11") {
// Trumf knäckt(bauer) är värd 21 poäng. Andra knäcktar är värda 1
if ($card["color"] == $trumf) {
$value += 21;
} else {
$value++;
}
} else if ($card["value"] == "10") {
// Tior är värda 10 poäng
$value += 10;
} else if ($card["value"] == "12") {
// Damer är värda 2 poäng
$value += 2;
} else if ($card["value"] == "13") {
// Kungar är värda 3 poäng
$value += 3;
} else if ($card["value"] == "14") {
// Ess är värda 11 poäng
$value += 11;
}
}
echo "<div id='result$currentPlayer' class='result'>
$name: $value poäng
</div>";
$currentPlayer++;
}
if ($userid == $ownerid) {
echo "<form method='post' action='startsida.php''>
<input type='hidden' name='gameid' value='$gameid'>
<button type='submit' name='deletegame'>End game</button>
</form>";
} else {
echo "<a href='startsida.php'>Return to home</a>";
}
}
?>
</body>
</html>