X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fgame.php;h=4c7710d96932baeae22ac897a123e960f5ec4cc3;hp=b509de36f63021dcaab08ff8813cb4e0c5e7673b;hb=c85a02555f543be61a122001bd430070dc45ba1d;hpb=b0430639c8bb809dc46252ad240bb883a0937527 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: