From 68e916d4e488f110dcdab69d7827e8b2f4129cd4 Mon Sep 17 00:00:00 2001 From: arun Date: Fri, 12 Jan 2007 08:43:28 +0000 Subject: server keeps score now, several small bugfixes --- db.php | 33 +++++++++++++++++++++--- functions.php | 2 +- index.php | 82 ++++++++++++++++++++++++++++++++++++++++++++++++++++------- output.php | 2 +- 4 files changed, 105 insertions(+), 14 deletions(-) diff --git a/db.php b/db.php index 6da3bd9..88be2a3 100644 --- a/db.php +++ b/db.php @@ -59,6 +59,17 @@ function DB_get_email_by_name($name) return ""; } +function DB_get_email_by_userid($id) +{ + $result = mysql_query("SELECT email FROM User WHERE id=".DB_quote_smart($id).""); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return ""; +} + function DB_get_email_by_hash($hash) { $result = mysql_query("SELECT User.email FROM User LEFT JOIN Hand ON Hand.user_id=User.id WHERE Hand.hash=".DB_quote_smart($hash).""); @@ -122,6 +133,19 @@ function DB_get_handid_by_hash($hash) return 0; } +function DB_get_handid_by_gameid_and_position($gameid,$pos) +{ + $result = mysql_query("SELECT id FROM Hand WHERE game_id=". + DB_quote_smart($gameid)." AND position=". + DB_quote_smart($pos)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return -1; +} + function DB_get_userid_by_hash($hash) { $result = mysql_query("SELECT user_id FROM Hand WHERE hash=".DB_quote_smart($hash)); @@ -270,14 +294,17 @@ function DB_get_hand($me) function DB_get_cards_by_trick($id) { $cards = array(); - $cards[0]=0; /* need to return index 1-4 */ - + $i = 1; + $result = mysql_query("SELECT card_id FROM Play LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id ". "LEFT JOIN Hand ON Hand.id=Hand_Card.hand_id ". "WHERE trick_id=". DB_quote_smart($id)." ORDER BY position ASC"); while($r = mysql_fetch_array($result,MYSQL_NUM)) - $cards[]=$r[0]; + { + $cards[$i]=$r[0]; + $i++; + } return $cards; } diff --git a/functions.php b/functions.php index e9ead78..e4f7c60 100644 --- a/functions.php +++ b/functions.php @@ -364,7 +364,7 @@ function card_value($card) case 48: return 0; default: - echo "something went wrong, please contact the admin. ErrorCode: 2
"; + echo "something went wrong, please contact the admin. ErrorCode: 2 - $card
"; return 0; } } diff --git a/index.php b/index.php index 6ee8df8..e25b720 100644 --- a/index.php +++ b/index.php @@ -185,7 +185,9 @@ else if(myisset("me")) break; case 'check': - echo "checking for solo...
if you have a wedding or poverty you need to play a normal game,sorry...
". + echo "checking for solo...
". + " if you have a wedding, please send an email to the other players.
". + " if you have poverty you need to play a normal game,sorry...
". " At the moment you need to reload this page to finish the setup.
"; if(!myisset("solo","wedding","poverty","nines") ) { @@ -204,7 +206,7 @@ else if(myisset("me")) { DB_set_solo_by_hash($me,$_REQUEST["solo"]); DB_set_sickness_by_hash($me,"solo"); - echo "Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.\n"; + echo "
Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.
\n"; if($gametype == "solo" && $startplayer<$mypos) {}/* do nothing */ @@ -244,7 +246,8 @@ else if(myisset("me")) * set that one in the Game table, delete other ones form Hand table * tell people about it. */ - echo "
poverty not handeled at the moment... you need to play a normal game
"; + echo "
poverty not handeled at the moment... you need to play a normal game
". + "reload this page to finish the setup
"; /* only set this after all poverty, etc. are handeled*/ DB_set_hand_status_by_hash($me,'play'); @@ -461,7 +464,9 @@ else if(myisset("me")) if($handcardid) { - mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".DB_quote_smart($card)); + /* mark card as played */ + mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=". + DB_quote_smart($card)); /* get trick id or start new trick */ $a = DB_get_current_trickid($gameid); @@ -470,17 +475,17 @@ else if(myisset("me")) $playid = DB_play_card($trickid,$handcardid,$sequence); - /*check for coment */ + /* check for coment */ if(myisset("comment")) { DB_insert_comment($_REQUEST["comment"],$playid,$myid); }; + /* display played card */ echo "
"; echo " you played
"; display_card($card); echo "
\n"; - /*check if we still have cards left, else set status to gameover */ if(sizeof(DB_get_hand($me))==0) @@ -489,16 +494,51 @@ else if(myisset("me")) $mystatus='gameover'; } - /* if all players are done, set game status to game over */ + /* if all players are done, set game status to game over, + * get the points of the last trick and send out an email + * to all players + */ $userids = DB_get_all_userid_by_gameid($gameid); + $done=1; foreach($userids as $user) if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover') $done=0; if($done) - DB_set_game_status_by_gameid($gameid,"gameover"); + { + DB_set_game_status_by_gameid($gameid,"gameover"); + /* get score for last trick + * all other tricks are handled a few lines further down*/ + $play = DB_get_cards_by_trick($trickid); + $winner = get_winner($play,$gametype); /* returns the position */ + /* get points of last trick and save it */ + $points = 0; + foreach($play as $card) + $points = $points + card_value($card); + $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner); + if($winnerid>0) + mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')"); + else + echo "ERROR during scoring"; + + /* email all players */ + $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". + " GROUP BY fullname" ); + $message = "The game is over. Thanks for playing :)\n"; + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n"; + $message .= "\nIf your not in the list above your score is zero...\n"; + foreach($userids as $user) + { + $To = DB_get_email_by_userid($user); + mymail($To,"[DoKo] game over",$message); + } + } + /* email next player */ if(DB_get_game_status_by_gameid($gameid)=='play') { @@ -506,6 +546,23 @@ else if(myisset("me")) { $play = DB_get_cards_by_trick($trickid); $winner = get_winner($play,$gametype); /* returns the position */ + + /* get points of last trick and save it, last trick is handled + * a few lines further up */ + $points = 0; + foreach($play as $card) + $points = $points + card_value($card); + + $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner); + if($winnerid>0) + mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')"); + else + echo "ERROR during scoring"; + + if($debug) + echo "DEBUG: $winner got $points
"; + + /* who is the next player? */ $next = $winner; } else @@ -585,8 +642,15 @@ else if(myisset("me")) } else { - echo "the game is over now... guess the final score should be displayed here...
\n"; + echo "the game is over now...
\n"; + $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". + " GROUP BY fullname" ); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + echo " FINAL SCORE: ".$r[0]." ".$r[1]."
"; + /* suggest a new game with the same people in it, just rotated once */ $names = DB_get_all_names_by_gameid($gameid); output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid); diff --git a/output.php b/output.php index 726eb43..21ce2fc 100644 --- a/output.php +++ b/output.php @@ -123,7 +123,7 @@ function display_link_card($card) function check_for_sickness($me,$mycards) { ?> -

nothing implemented so far, but give it a try anyway ;)

+

Solo will work, but the first player will not change. Nothing else implemented.

-- cgit v1.2.3-18-g5258