\n";
-
- /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
- if($mystatus=='play')
- break;
- /* the following happens only when the gamestatus is 'gameover' */
- /* check if game is over, display results */
- if(DB_get_game_status_by_gameid($gameid)=='play')
- {
- echo "the game is over for you.. other people still need to play though";
- }
- else
- {
- echo "the game is over now...\n";
-
- $result = mysql_query("SELECT fullname, IFNULL(SUM(score),0), Hand.party FROM Hand".
- " LEFT JOIN Score ON Hand.id=Score.hand_id".
- " LEFT JOIN User ON Hand.user_id=User.id".
- " WHERE Hand.game_id=$gameid".
- " GROUP BY fullname" );
- echo "Final Score:\n".
- "