From 88aaf2c34d0b3cc7eff994955a144a8d27b67c7a Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Fri, 12 Jan 2007 10:49:29 +0000
Subject: small bug in displaying the score
---
index.php | 2 ++
1 file changed, 2 insertions(+)
(limited to 'index.php')
diff --git a/index.php b/index.php
index e25b720..605a94b 100644
--- a/index.php
+++ b/index.php
@@ -526,6 +526,7 @@ else if(myisset("me"))
$result = mysql_query("SELECT fullname, SUM(score) FROM Score".
" LEFT JOIN Hand ON Hand.id=hand_id".
" LEFT JOIN User ON Hand.user_id=User.id".
+ " WHERE Hand.game_id=$gameid".
" GROUP BY fullname" );
$message = "The game is over. Thanks for playing :)\n";
while( $r = mysql_fetch_array($result,MYSQL_NUM))
@@ -647,6 +648,7 @@ else if(myisset("me"))
$result = mysql_query("SELECT fullname, SUM(score) FROM Score".
" LEFT JOIN Hand ON Hand.id=hand_id".
" LEFT JOIN User ON Hand.user_id=User.id".
+ " WHERE Hand.game_id=$gameid".
" GROUP BY fullname" );
while( $r = mysql_fetch_array($result,MYSQL_NUM))
echo " FINAL SCORE: ".$r[0]." ".$r[1]."<br />";
--
cgit v1.2.3-18-g5258