\n"; echo "perhaps the game has been canceled, check by login in here."; output_footer(); DB_close(); exit(); } /* user might get here by clicking on the link in an email, so session might not be set */ if(isset($_SESSION["name"])) output_status($_SESSION["name"]); /* the user had done something, update the timestamp */ DB_update_user_timestamp($myid); /* get some information from the DB */ $gameid = DB_get_gameid_by_hash($me); $myname = DB_get_name('hash',$me); $mystatus = DB_get_status_by_hash($me); $mypos = DB_get_pos_by_hash($me); $myhand = DB_get_handid('hash',$me); $session = DB_get_session_by_gameid($gameid); /* get prefs and save them */ DB_get_PREF($myid); /* get rule set for this game */ $result = mysql_query("SELECT * FROM Rulesets". " LEFT JOIN Game ON Game.ruleset=Rulesets.id ". " WHERE Game.id='$gameid'" ); $r = mysql_fetch_array($result,MYSQL_NUM); $RULES["dullen"] = $r[2]; $RULES["schweinchen"] = $r[3]; $RULES["call"] = $r[4]; /* get some infos about the game */ $gametype = DB_get_gametype_by_gameid($gameid); $gamestatus = DB_get_game_status_by_gameid($gameid); $GT = $gametype; if($gametype=="solo") { $gametype = DB_get_solo_by_gameid($gameid); $GT = $gametype." ".$GT; } /* does anyone have both foxes */ $GAME["schweinchen"]=0; for($i=1;$i<5;$i++) { $hash = DB_get_hash_from_game_and_pos($gameid,$i); $cards = DB_get_all_hand($hash); if( in_array("19",$cards) && in_array("20",$cards) ) { $GAME["schweinchen"]=1; $GAME["schweinchen-who"]=$hash; } }; /* put everyting in a form */ echo "