diff options
author | arun <arun@nubati.net> | 2006-12-12 11:25:47 +0000 |
---|---|---|
committer | arun <arun> | 2006-12-12 11:25:47 +0000 |
commit | 6af8e19b862bc37a5a34239d53953d9dc5786d7c (patch) | |
tree | c1ec7808986fe2c5389e473779b49a375c80c1d6 /db.php | |
parent | 11bc256437ae08976ca1b65fcab39f9e326c760f (diff) | |
download | e-DoKo-6af8e19b862bc37a5a34239d53953d9dc5786d7c.tar.gz e-DoKo-6af8e19b862bc37a5a34239d53953d9dc5786d7c.tar.bz2 e-DoKo-6af8e19b862bc37a5a34239d53953d9dc5786d7c.zip |
small bugfixes to get comments for examples comments working
Diffstat (limited to 'db.php')
-rw-r--r-- | db.php | 5 |
1 files changed, 4 insertions, 1 deletions
@@ -264,11 +264,14 @@ function DB_set_sickness_by_hash($me,$sickness) function DB_get_current_trickid($gameid) { + $trickid = NULL; + $sequence = NULL; + $result = mysql_query("SELECT Trick.id,MAX(Play.sequence) FROM Play ". "LEFT JOIN Trick ON Play.trick_id=Trick.id ". "WHERE Trick.game_id=".DB_quote_smart($gameid)." ". "GROUP BY Trick.id"); - while( $r = mysql_fetch_array($result,MYSQL_NUM) ) + while( $r = mysql_fetch_array($result,MYSQL_NUM) ) { $trickid = $r[0]; $sequence = $r[1]; |