From eb20bf1a0cae1192eb50c19220e72df8d971d8e7 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 18 Oct 2008 11:33:36 -0700 Subject: NEW FEATURE: make it possible to view games where people played with the same hand had to change a few things and check more often if people are logge in, so that for example personal notes only show up when you are logged in and not when someone else is looking at your cards Signed-off-by: Arun Persaud --- include/db.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'include/db.php') diff --git a/include/db.php b/include/db.php index 1e18f95..514bde2 100644 --- a/include/db.php +++ b/include/db.php @@ -1102,5 +1102,13 @@ function DB_get_exchanged_cards($hash) return $cards; } - +function DB_played_by_others($gameid) +{ + $gameids = array(); + $result = DB_query("SELECT id FROM Game WHERE randomnumbers=(SELECT randomnumbers from Game where id=$gameid) and status='gameover'"); + while($r = DB_fetch_array($result)) + if($r[0]!=$gameid) + $gameids[]=$r[0]; + return $gameids; +} ?> \ No newline at end of file -- cgit v1.2.3-18-g5258