diff options
| author | arun <arun@nubati.net> | 2007-06-07 18:09:08 +0000 |
|---|---|---|
| committer | arun <arun> | 2007-06-07 18:09:08 +0000 |
| commit | e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541 (patch) | |
| tree | 2854695034eba9e832ba486bc8443ffa3a4383a2 /db.php | |
| parent | 337229f87e4507dd1ea9fa80cfc981f19822b726 (diff) | |
| download | e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.tar.gz e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.tar.bz2 e-DoKo-e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541.zip | |
* FIX: added extra check for calling 120, etc. so that people can't cheat
* NEW: display sessions
* NEW: display who's turn it is on the userpage (change in DB)
* NEW: different ways when to say 90, 60, etc. (change in DB)
* MISC: some clean up, e.g. display of final score
Diffstat (limited to 'db.php')
| -rw-r--r-- | db.php | 32 |
1 files changed, 32 insertions, 0 deletions
@@ -629,6 +629,24 @@ function DB_set_startplayer_by_gameid($id,$p) return; } +function DB_get_player_by_gameid($id) +{ + $result = mysql_query("SELECT player FROM Game WHERE id=".DB_quote_smart($id)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return 0; +} +function DB_set_player_by_gameid($id,$p) +{ + mysql_query("UPDATE Game SET player='".DB_quote_smart($p)."' WHERE id=".DB_quote_smart($id)); + return; +} + + + function DB_get_ruleset_by_gameid($id) { $result = mysql_query("SELECT ruleset FROM Game WHERE id=".DB_quote_smart($id)); @@ -662,6 +680,20 @@ function DB_get_max_session() return 0; } +function DB_get_hashes_by_session($session,$user) +{ + $r = array(); + + $result = mysql_query("SELECT Hand.hash FROM Hand". + " LEFT JOIN Game ON Game.id=Hand.game_id ". + " WHERE Game.session=".DB_quote_smart($session). + " AND Hand.user_id=".DB_quote_smart($user)); + while($t = mysql_fetch_array($result,MYSQL_NUM)) + $r[] = $t[0]; + + return $r; +} + function DB_get_ruleset($dullen,$schweinchen) { $r = array(); |