From c85a02555f543be61a122001bd430070dc45ba1d Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 13 Sep 2008 09:43:25 -0700 Subject: LAYOUT: removed some overlapping areas the total points and the game points for re/contra now only show up on the "score" trick. This way they don't overlap with graphics when looking at older tricks. Signed-off-by: Arun Persaud --- include/game.php | 75 +++++++++++++++++++++++++++----------------------------- 1 file changed, 36 insertions(+), 39 deletions(-) (limited to 'include/game.php') diff --git a/include/game.php b/include/game.php index b509de3..4c7710d 100644 --- a/include/game.php +++ b/include/game.php @@ -1808,6 +1808,42 @@ switch($mystatus) "
".$r[2]."
".$r[1]."
\n". " \n"; + /* display totals */ + $result = DB_query("SELECT Hand.party, IFNULL(SUM(Card.points),0) FROM Hand". + " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id". + " LEFT JOIN User ON User.id=Hand.user_id". + " LEFT JOIN Play ON Trick.id=Play.trick_id". + " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id". + " LEFT JOIN Card ON Card.id=Hand_Card.card_id". + " WHERE Hand.game_id='$gameid'". + " GROUP BY Hand.party" ); + echo "
\n Totals:
\n"; + while( $r = DB_fetch_array($result)) + echo " ".$r[0]." ".$r[1]."
\n"; + + $queryresult = DB_query("SELECT timediff(mod_date,create_date) ". + " FROM Game WHERE id='$gameid'"); + $r = DB_fetch_array($queryresult); + echo "

This game took ".$r[0]." hours.

\n"; + + echo "
\n Points Re:
\n"; + $queryresult = DB_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='re'". + " "); + while($r = DB_fetch_array($queryresult) ) + echo " ".$r[0]."
\n"; + echo "
\n"; + + echo "
\n Points Contra:
\n"; + $queryresult = DB_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='contra'". + " "); + while($r = DB_fetch_array($queryresult) ) + echo " ".$r[0]."
\n"; + echo "
\n"; + + echo "
\n"; + echo " \n \n"; /* end div trick, end li trick */ } @@ -1883,45 +1919,6 @@ switch($mystatus) if(DB_get_game_status_by_gameid($gameid)=='play') { echo "The game is over for you.. other people still need to play though"; - } - else - { - $result = DB_query("SELECT Hand.party, IFNULL(SUM(Card.points),0) FROM Hand". - " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id". - " LEFT JOIN User ON User.id=Hand.user_id". - " LEFT JOIN Play ON Trick.id=Play.trick_id". - " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id". - " LEFT JOIN Card ON Card.id=Hand_Card.card_id". - " WHERE Hand.game_id='$gameid'". - " GROUP BY Hand.party" ); - echo "
Totals:
\n"; - while( $r = DB_fetch_array($result)) - echo " ".$r[0]." ".$r[1]."
\n"; - - $queryresult = DB_query("SELECT timediff(mod_date,create_date) ". - " FROM Game WHERE id='$gameid'"); - $r = DB_fetch_array($queryresult); - echo "

This game took ".$r[0]." hours.

"; - - echo "
\n Points Re:
\n"; - $queryresult = DB_query("SELECT score FROM Score ". - " WHERE game_id=$gameid AND party='re'". - " "); - while($r = DB_fetch_array($queryresult) ) - echo " ".$r[0]."
\n"; - echo "
\n"; - - echo "
\n Points Contra:
\n"; - $queryresult = DB_query("SELECT score FROM Score ". - " WHERE game_id=$gameid AND party='contra'". - " "); - while($r = DB_fetch_array($queryresult) ) - echo " ".$r[0]."
\n"; - echo "
\n"; - - echo "
\n"; - - } break; default: -- cgit v1.2.3-18-g5258