summaryrefslogtreecommitdiffstats
path: root/db.php
diff options
context:
space:
mode:
Diffstat (limited to 'db.php')
-rw-r--r--db.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/db.php b/db.php
index 7f47c66..bf82544 100644
--- a/db.php
+++ b/db.php
@@ -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];