Show sourcecode
The following files exists in this folder. Click to view.
bacon-egg-pizza.php
cquiz.php
create-account.php
create-account111.php
create-quiz.php
create-quiz2.php
createaccount.php
delete-quiz.php
drop-rps-tables.php
legacy-code-rps.php
legacy-index.php
login.php
logincheck.php
newpassword-verify.php
newpassword.php
potential-code.txt
quiz-db-init.php
quizhub.php
quizhub2.php
results.php
rpsaccount-ajax-user-search.php
rpsaccount.php
rpsbetting-ajax-match-finder.php
rpsbetting.php
rpsbettingleaderboard.php
rpschangepassword.php
rpschangepassword.txt
rpsgame-ajax.php
rpsgame.php
rpsgameresults.php
rpshostnewgame.php
rpshub.php
rpsleaderboard.php
rpslib.php
rpslogin.php
rpsmaininclude.php
rpsproject/
rpsusersearch.php
table-init.php
verification.php
rpslib.php
560 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560
<?php
function getUserInfo($user){
require("../incl/dbconnection.php");
$userInfo=[];
$userinfocolumns = ['username','pass','email','wins','losses','ratio','bettingpoints'];
$sql = "SELECT * FROM rpsusers WHERE username = ?";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute([$user]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
foreach($userinfocolumns as $type){
array_push($userInfo,$res["$type"]);
}
}
return $userInfo;
}
function getMatches($dbconn){
$sql = "SELECT * FROM matches WHERE player2id IS NULL";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute();
echo "<h2>matcher:</h2>";
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$key = $res['matchid'];
echo '<a href="rpsgame.php?matchid='.$key.'">gå med!</a><br>';
}
//ADD ASYNC
/*sleep(1);
getMatches($dbconn);
*/
}
function matchActiveCheck($dbconn, $matchid){
$sql = "SELECT isactive FROM matches WHERE matchid = ?";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute([$matchid]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['isactive']==0){
return false;
}
else{
return true;
}
}
}
class RPSgame{
}
function joinGame($dbconn, $matchkey){
$_SESSION['hasMadeMove'] = false;
$sql = "SELECT * FROM matches WHERE matchid = ?";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute([$matchkey]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['player2id']==null AND $res['player1id']!=$_SESSION['userid']){
$ukey = $_SESSION['userid'];
$sql = "UPDATE matches SET player2id = ? WHERE matchid = ?";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute([$ukey, $matchkey]);
}
}
}
function sendMove($dbconn, $matchkey, $move) {
// Securely obtain the current user from session
$userkey = $_SESSION['userid'];
// Retrieve the current round (default is 1 if no moves exist)
$sql = "SELECT round FROM moves WHERE matchkey = ? ORDER BY round DESC LIMIT 1";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
$currentround = 1;
if ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$currentround = $res['round'];
echo "Round number acquired: " . $currentround."<br>";
}
// Check how many moves have been made in the current round
$sql = "SELECT userid FROM moves WHERE matchkey = ? AND round = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $currentround]);
$useridArrayCurrentRound = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
// If both players have moved, start a new round
if (count($useridArrayCurrentRound) == 2) {
$currentround++;
}
// Check if this user has already made a move in the current round
$sql = "SELECT COUNT(*) AS total FROM moves WHERE matchkey = ? AND round = ? AND userid = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $currentround, $userkey]);
$res = $stmt->fetch(PDO::FETCH_ASSOC);
if ($res['total'] == 0) {
// Insert the move if not already made
$sql = "INSERT INTO moves (matchkey, userid, round, rps) VALUES (?, ?, ?, ?)";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $userkey, $currentround, $move]);
} else {
echo "move already made<br>";
}
checkMoveStatus($dbconn,$matchkey,$currentround);
}
function sendMoveV2($dbconn, $matchkey, $move){
if($_SESSION['hasMadeMove']==false){
//get user id
$userkey = $_SESSION['userid'];
//get current round number
$sql = "SELECT * FROM moves WHERE matchkey = ? ORDER BY round DESC LIMIT 1";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
if ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$_SESSION['currentround'] = $res['round'];
echo "Round number acquired: " . $_SESSION['currentround']."<br>";
}
$sql = "INSERT INTO moves (matchkey, userid, round, rps) VALUES (?, ?, ?, ?)";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $userkey, $_SESSION['currentround'], $move]);
/*
// Check how many moves have been made in the current round
$sql = "SELECT userid FROM moves WHERE matchkey = ? AND round = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $_SESSION['currentround']]);
$useridArrayCurrentRound = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
// If both players have moved, start a new round
if (count($useridArrayCurrentRound) == 2) {
$_SESSION['currentround']++;
}
*/
$_SESSION['hasMadeMove']=true;
checkMoveStatusV1V2($dbconn,$matchkey,$_SESSION['currentround']);
}
else{
echo "wait for opponent";
}
}
function creatematch($dbconn,$roundnum){
$userid = $_SESSION['userid'];
//creates match
$sql= "INSERT INTO matches (roundAmount, player1id, p1points, p2points, isactive, datestarted) VALUES (?,?,?,?,?,?)";
$stmt = $dbconn->prepare($sql);
$data = [$roundnum,$userid,0,0,1,time()];
$stmt->execute($data);
//finds created match
$sql = "SELECT matchid FROM matches WHERE player1id = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$userid]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$matchkey=$res['matchid'];
}
//sends match creator to created match
header("Location:rpsgame.php?matchid=$matchkey");
}
function checkMoveStatus($dbconn,$matchkey,$currentround){
$sql = "SELECT COUNT(*) AS total FROM moves WHERE matchkey = ? AND round = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $currentround]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['total']==2){
$sql="SELECT * FROM moves WHERE matchkey=? AND round=? /*AND NOT userid=?*/";
$stmt = $dbconn->prepare($sql);
$data=[$matchkey,$currentround/*,$_SESSION['userid']*/];
$stmt->execute($data);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['userid']!=$_SESSION['userid']){
echo "opponent: ".$res['rps'].'<br>';
}
else if($res['userid']==$_SESSION['userid']){
echo "your move: ".$res['rps']."<br>";
}
}
}
else if($res['total']==1){
echo "waiting for opponent";
}
else if($res['total']==0){
echo $_SESSION['rpsmove']."<br>";
}
$sql="SELECT roundAmount FROM matches WHERE matchid = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['roundAmount']==$currentround){
header("Location:rpsgameresults.php?matchkey=$matchkey");
$_SESSION['isInGame'] = false;
}
}
}
}
function checkMoveStatusV2($dbconn,$matchkey,$currentround){
$sql = "SELECT COUNT(*) AS total FROM moves WHERE matchkey = ? AND round = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $currentround]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['total']==2){
$sql="SELECT * FROM moves WHERE matchkey=? AND round=? /*AND NOT userid=?*/";
$stmt = $dbconn->prepare($sql);
$data=[$matchkey,$currentround/*,$_SESSION['userid']*/];
$stmt->execute($data);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['userid']!=$_SESSION['userid']){
echo "opponent: ".$res['rps'].'<br>';
}
else if($res['userid']==$_SESSION['userid']){
echo "your move: ".$res['rps']."<br>";
}
}
$_SESSION['currentround']++;
$_SESSION['hasMadeMove']=false;
}
else if($res['total']==1){
echo "waiting for opponent";
}
else if($res['total']==0){
echo $_SESSION['rpsmove']."<br>";
}
}
$sql="SELECT roundAmount FROM matches WHERE matchid = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['roundAmount']==$_SESSION['currentround']){
header("Location:rpsgameresults.php?matchkey=$matchkey");
$_SESSION['isInGame'] = false;
}
}
}
function checkMoveStatusV1V2($dbconn,$matchkey,$currentround){
$sql = "SELECT
m.matchid,
m.player1id,
m.player2id,
u1.userid AS p1id,
u2.userid AS p2id,
u1.rps AS u1move,
u2.rps AS u2move
FROM matches AS m
INNER JOIN moves AS u1 ON m.player1id = u1.userid
INNER JOIN moves AS u2 ON m.player2id = u2.userid
WHERE matchid = ?";
$stmt = $dbconn->prepare($sql);
$data=[$matchkey];
$stmt->execute($data);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
//echo $res[];
}
$sql = "SELECT COUNT(*) AS total FROM moves WHERE matchkey = ? AND round = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey, $currentround]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['total']==2){
$sql="SELECT * FROM moves WHERE matchkey=? AND round=? /*AND NOT userid=?*/";
$stmt = $dbconn->prepare($sql);
$data=[$matchkey,$currentround/*,$_SESSION['userid']*/];
$stmt->execute($data);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['userid']!=$_SESSION['userid']){
echo "opponent: ".$res['rps'].'<br>';
}
else if($res['userid']==$_SESSION['userid']){
echo "your move: ".$res['rps']."<br>";
}
}
}
else if($res['total']==1){
echo "waiting for opponent or you";
}
else if($res['total']==0){
echo $_SESSION['rpsmove']."<br>";
}
$sql="SELECT roundAmount FROM matches WHERE matchid = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['roundAmount']==$currentround){
header("Location:rpsgameresults.php?matchkey=$matchkey");
$_SESSION['isInGame'] = false;
exit;
}
}
echo "<hr><strong>All Moves in Match:</strong><br>";
$sql = "SELECT round, userid, rps FROM moves WHERE matchkey = ? ORDER BY round ASC, userid ASC";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$matchkey]);
$currentRound = -1;
while ($move = $stmt->fetch(PDO::FETCH_ASSOC)) {
// New round header
if ($currentRound != $move['round']) {
$currentRound = $move['round'];
echo "<br><strong>Round " . $currentRound . ":</strong><br>";
}
// Identify if it's the current user or opponent
$label = ($move['userid'] == $_SESSION['userid']) ? "You" : "Opponent";
echo $label . ": " . htmlspecialchars($move['rps']) . "<br>";
}
}
}
function changePassword($dbconn,$oldpass,$newpass){
$sql = "SELECT * FROM rpsusers WHERE userid = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute([$_SESSION['userid']]);
while($res=$stmt->fetch(PDO::FETCH_ASSOC)){
if($res['lastpasswordchangedtime']+60*15<=time()){
if(password_verify($oldpass,$res['pass'])){
$sql ="UPDATE rpsusers SET pass=?, lastpasswordchangedtime=? WHERE userid = ?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([password_hash($newpass,PASSWORD_DEFAULT),time(),$_SESSION['userid']]);
header("Location:rpshub.php");
}
else{
echo "fel lösenord";
}
}
else{
echo "vänta lite till innan du ändrar lösenord";
}
}
}
function getMatchResult($dbconn,$matchkey){
//define variables
$roundamount=null;
$player1id = null;
$player2id = null;
$player1name=null;
$player2name=null;
//get match info
$sql = "SELECT
m.matchid,
m.roundAmount,
m.player1id,
m.player2id,
u1.userid AS p1id,
u1.username AS player1name,
u2.userid AS p2id,
u2.username AS player2name
FROM matches AS m
INNER JOIN rpsusers AS u1 ON m.player1id = u1.userid
INNER JOIN rpsusers AS u2 ON m.player2id = u2.userid
WHERE m.matchid=?";
$stmt = $dbconn -> prepare($sql);
$stmt->execute([$matchkey]);
while($res=$stmt->fetch(PDO::FETCH_ASSOC)){
$roundamount=$res['roundAmount'];
$player1id=$res['p1id'];
$player1name=$res['player1name'];
$player2id=$res['p2id'];
$player2name=$res['player2name'];
}
//remove match from active matches
$sql="UPDATE matches SET isactive=0 WHERE matchid=?";
$stmt = $dbconn -> prepare($sql);
if(isset($_GET['matchkey'])){
$stmt -> execute([$_GET['matchkey']]);
}
else{
$stmt -> execute([$matchkey]);
}
//get number of moves
$sql = "SELECT count(*) AS total FROM moves WHERE matchkey=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$_GET['matchkey']]);
//create associative array
$matchResultsArray = [];
$p1moves=[];
$p1score=[];
$p2moves=[];
$p2score=[];
//check if correct number of moves have been made
if($res= $stmt->fetch(PDO::FETCH_ASSOC)){
if($res['total']==$roundamount*2){
//get all moves from match
$sql = "SELECT * FROM moves WHERE matchkey=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$matchkey]);
while($res=$stmt->fetch(PDO::FETCH_ASSOC)){
/*
$matchResultsArray[]=$res['round'];
$matchResultsArray[$res['round']][]=$res['userid'];
$matchResultsArray[$res['round']][$res['userid']][] = $res['rps'];
*/
//add moves to array
if($res['userid']==$player1id){
array_push($p1moves,$res['rps']);
}
else if($res['userid']==$player2id){
array_push($p2moves,$res['rps']);
}
}
//calculate scores
$x=0;
while($x<$roundamount){
if($p1moves[$x]=="rock"){
if($p2moves[$x]=="rock"){
//does nothing
}
else if($p2moves[$x]=="paper"){
array_push($p2score,1);
}
else if($p2moves[$x]=="scissors"){
array_push($p1score,1);
}
}
else if($p1moves[$x]=="paper"){
if($p2moves[$x]=="rock"){
array_push($p1score,1);
}
else if($p2moves[$x]=="paper"){
//does nothing
}
else if($p2moves[$x]=="scissors"){
array_push($p2score,1);
}
}
else if($p1moves[$x]=="scissors"){
if($p2moves[$x]=="rock"){
array_push($p2score,1);
}
else if($p2moves[$x]=="paper"){
array_push($p1score,1);
}
else if($p2moves[$x]=="scissors"){
//does nothing
}
}
$x++;
}
$p1score=count($p1score);
$p2score=count($p2score);
//show scores
echo "<br>$player1name: $p1score poäng<br>";
echo "$player2name: $p2score poäng<br>";
if($p1score>$p2score){
echo "$player1name vann";
$sql = "UPDATE matches SET p1points=? WHERE matchid=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$p1score,$matchkey]);
//update bet with p1 win
updateBets($dbconn,$player1id,$matchkey);
}
else if($p1score==$p2score){
echo "oavgjort";
}
else if($p1score<$p2score){
echo "$player2name vann";
$sql = "UPDATE matches SET p2points=? WHERE matchid=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$p2score,$matchkey]);
//update bet with p2 win
updateBets($dbconn,$player2id,$matchkey);
}
updateWinLoss($dbconn);
}
else{
//echo "wait";
//sleep(1);
getMatchResult($dbconn,$matchkey);
}
}
}
function updateWinLoss($dbconn){
$uid=$_SESSION['userid'];
$sql="SELECT * FROM matches WHERE player1id=? OR player2id=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$uid,$uid]);
$tempWins=0;
$tempLosses=0;
$ratio=0;
while($res=$stmt->fetch(PDO::FETCH_ASSOC)){
if($res['player1id']==$uid){
if($res['p1points']>$res['p2points']){
$tempWins++;
}
else if($res['p1points']<$res['p2points']){
$tempLosses++;
}
}
else if($res['player2id']==$uid){
if($res['p2points']>$res['p1points']){
$tempWins++;
}
else if($res['p2points']<$res['p1points']){
$tempLosses++;
}
}
}
if($tempWins != 0 AND $tempLosses != 0){
$ratio = $tempWins/$tempLosses;
}
$sql="UPDATE rpsusers SET wins=?, losses=?, ratio=? WHERE userid=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$tempWins,$tempLosses,$ratio,$uid]);
}
function updateBets($dbconn,$winningplayerid,$matchid){
$sql = "SELECT
b.beton, b.totalbet, b.userid AS buid,
u.bettingpoints, u.userid AS nuid
FROM bets AS b
INNER JOIN rpsusers AS u ON b.userid = u.userid
WHERE matchid = ?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$matchid]);
while($res=$stmt->fetch(PDO::FETCH_ASSOC)){
$bet=$res['totalbet'];
$betwinnings=$bet*2;
$currentuserid = $res['buid'];
$bettingpoints=$res['bettingpoints'];
$newBettingPoints = $bettingpoints+$betwinnings;
if($res['beton']==$winningplayerid){
$sql="UPDATE rpsusers SET bettingpoints=? WHERE userid=?";
$stmt=$dbconn->prepare($sql);
$stmt->execute([$newBettingPoints,$currentuserid]);
}
}
}
?>