2 error_reporting(E_ALL);
7 include_once("config.php");
8 include_once("output.php"); /* html output only */
9 include_once("db.php"); /* database only */
10 include_once("functions.php"); /* the rest */
12 /* check if some variables are set in the config file, else set defaults */
13 if(!isset($EmailName))
17 /* in case work has to be done on the database or other section we can
18 * shut down the server and tell people to come back later
23 echo "Working on the database...please check back in a few mintues";
31 echo "Database error, can't connect...";
38 /* check if we want to start a new game */
41 $names = DB_get_all_names();
42 output_form_for_new_game($names);
44 /*check if everything is ready to set up a new game */
45 else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD","dullen","schweinchen" ))
47 $PlayerA = $_REQUEST["PlayerA"];
48 $PlayerB = $_REQUEST["PlayerB"];
49 $PlayerC = $_REQUEST["PlayerC"];
50 $PlayerD = $_REQUEST["PlayerD"];
52 $dullen = $_REQUEST["dullen"];
53 $schweinchen = $_REQUEST["schweinchen"];
55 $EmailA = DB_get_email_by_name($PlayerA);
56 $EmailB = DB_get_email_by_name($PlayerB);
57 $EmailC = DB_get_email_by_name($PlayerC);
58 $EmailD = DB_get_email_by_name($PlayerD);
60 if($EmailA=="" || $EmailB=="" || $EmailC=="" || $EmailD=="")
62 echo "couldn't find one of the names, please start a new game";
67 $useridA = DB_get_userid_by_name($PlayerA);
68 $useridB = DB_get_userid_by_name($PlayerB);
69 $useridC = DB_get_userid_by_name($PlayerC);
70 $useridD = DB_get_userid_by_name($PlayerD);
72 /* create random numbers */
73 $randomNR = create_array_of_random_numbers();
74 $randomNRstring = join(":",$randomNR);
76 /* get ruleset information or create new one */
77 $ruleset = DB_get_ruleset($dullen,$schweinchen);
80 echo "Error defining ruleset: $ruleset";
87 if(myisset("followup") )
89 $followup= $_REQUEST["followup"];
90 $session = DB_get_session_by_gameid($followup);
91 $ruleset = DB_get_ruleset_by_gameid($followup); /* just copy ruleset from old game,
92 this way no manipulation is possible */
94 mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',".
95 "'$ruleset','$session' ,NULL)");
99 $max = DB_get_max_session();
101 mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',".
102 "'$ruleset','$max' ,NULL)");
103 mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup));
107 mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre', ".
108 "'$ruleset',NULL ,NULL)");
109 $game_id = mysql_insert_id();
112 $TIME = (string) time(); /* to avoid collisions */
113 $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA.$TIME);
114 $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB.$TIME);
115 $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC.$TIME);
116 $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD.$TIME);
119 mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridA).
120 ", ".DB_quote_smart($hashA).", 'start','1',NULL,NULL,NULL,'false','false',NULL)");
121 $hand_idA = mysql_insert_id();
122 mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridB).
123 ", ".DB_quote_smart($hashB).", 'start','2',NULL,NULL,NULL,'false','false',NULL)");
124 $hand_idB = mysql_insert_id();
125 mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridC).
126 ", ".DB_quote_smart($hashC).", 'start','3',NULL,NULL,NULL,'false','false',NULL)");
127 $hand_idC = mysql_insert_id();
128 mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridD).
129 ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,'false','false',NULL)");
130 $hand_idD = mysql_insert_id();
134 mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idA', '".$randomNR[$i]."', 'false')");
135 for($i=12;$i<24;$i++)
136 mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idB', '".$randomNR[$i]."', 'false')");
137 for($i=24;$i<36;$i++)
138 mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idC', '".$randomNR[$i]."', 'false')");
139 for($i=36;$i<48;$i++)
140 mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idD', '".$randomNR[$i]."', 'false')");
142 /* send out email, TODO: check for error with email */
144 "you are invited to play a game of DoKo (that is to debug the program ;).\n".
145 "Place comments and bug reports here:\n".
146 "http://wiki.nubati.net/index.php?title=EmailDoko\n\n".
147 "The whole round would consist of the following players:\n".
152 "If you want to join this game, please follow this link:\n\n".
155 mymail($EmailA,"You are invited to a game of DoKo","Hello $PlayerA,\n".$message.$hashA);
156 mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
157 mymail($EmailC,"You are invited to a game of DoKo","Hello $PlayerC,\n".$message.$hashC);
158 mymail($EmailD,"You are invited to a game of DoKo","Hello $PlayerD,\n".$message.$hashD);
160 echo "You started a new game. The emails have been sent out!";
161 } /* end set up a new game */
162 /* cancle a game, if nothing has happend in the last N minutes */
163 else if(myisset("cancle","me"))
165 $me = $_REQUEST["me"];
167 /* test for valid ID */
168 $myid = DB_get_userid_by_hash($me);
171 echo "Can't find you in the database, please check the url.<br />\n";
172 echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
177 DB_update_user_timestamp($myid);
179 /* get some information from the DB */
180 $gameid = DB_get_gameid_by_hash($me);
181 $myname = DB_get_name_by_hash($me);
183 /* check if game really is old enough */
184 $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
185 $r = mysql_fetch_array($result,MYSQL_NUM);
186 if(time()-strtotime($r[0]) > 60*60*24*30) /* = 1 month */
188 $message = "Hello, \n\n".
189 "Game $gameid has been cancled since nothing happend for a while and $myname requested it.\n";
191 $userids = DB_get_all_userid_by_gameid($gameid);
192 foreach($userids as $user)
194 $To = DB_get_email_by_userid($user);
195 mymail($To,$EmailName."game cancled (timed out)",$message);
198 /* delete everything from the dB */
201 echo "<p style=\"background-color:red\";>Game $gameid has been cancled.<br /><br /></p>";
204 echo "<p>You need to wait longer before you can cancle a game...</p>\n";
206 /* handle request from one specific player for one game,
207 * (the hash is set on a per game base) */
208 else if(myisset("me"))
210 $me = $_REQUEST["me"];
212 /* test for valid ID */
213 $myid = DB_get_userid_by_hash($me);
216 echo "Can't find you in the database, please check the url.<br />\n";
217 echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
222 /* the user had done something, update the timestamp */
223 DB_update_user_timestamp($myid);
225 /* get some information from the DB */
226 $gameid = DB_get_gameid_by_hash($me);
227 $myname = DB_get_name_by_hash($me);
228 $mystatus = DB_get_status_by_hash($me);
229 $mypos = DB_get_pos_by_hash($me);
230 $myhand = DB_get_handid_by_hash($me);
232 /* get prefs and save them */
233 $result = mysql_query("SELECT value from User_Prefs".
234 " WHERE user_id='$myid' AND pref_key='cardset'" );
235 $r = mysql_fetch_array($result,MYSQL_NUM);
238 if($r[0]=="germancards" && (time()-strtotime( "2009-12-31 23:59:59")<0) ) /* licence only valid until then */
239 $PREF["cardset"]="altenburg";
241 $PREF["cardset"]="english";
244 $PREF["cardset"]="english";
247 /* get rule set for this game */
248 $result = mysql_query("SELECT * FROM Rulesets".
249 " LEFT JOIN Game ON Game.ruleset=Rulesets.id ".
250 " WHERE Game.id='$gameid'" );
251 $r = mysql_fetch_array($result,MYSQL_NUM);
253 $RULES["dullen"] = $r[2];
254 $RULES["schweinchen"] = $r[3];
256 /* get some infos about the game */
257 $gametype = DB_get_gametype_by_gameid($gameid);
258 $gamestatus = DB_get_game_status_by_gameid($gameid);
260 if($gametype=="solo")
262 $gametype = DB_get_solo_by_gameid($gameid);
263 $GT = $gametype." ".$GT;
266 /* display rule set for this game */
267 echo "<div class=\"ruleset\">\n";
269 if($gamestatus != 'pre')
270 echo " Gametype: $GT <br />\n";
272 echo "Rules: <br />\n";
273 echo "10ofhearts : ".$r[2]."<br />\n";
274 echo "schweinchen: ".$r[3]."<br />\n";
277 /* does anyone have both foxes */
278 $GAME["schweinchen"]=0;
281 $hash = DB_get_hash_from_game_and_pos($gameid,$i);
282 $cards = DB_get_all_hand($hash);
283 if( in_array("19",$cards) && in_array("20",$cards) )
285 $GAME["schweinchen"]=1;
286 $GAME["schweinchen-who"]=$hash;
290 /* mystatus gets the player through the different stages of a game.
292 * init: check values from start,
294 * check: check for return values from init
295 * poverty: handle poverty, wait here until all player have reached this state
296 * display sickness and move on to game
297 * play: game in progress
298 * gameover: are we revisiting a game
303 check_want_to_play($me);
304 /* move on to the next stage*/
305 DB_set_hand_status_by_hash($me,'init');
308 /* first check if everything went ok in the last step
309 * if not, send user back, if yes, check what he did
313 echo "<p> you need to answer the <a href=\"$host?me=$me\">question</a>.</p>";
314 DB_set_hand_status_by_hash($me,'start');
318 if($_REQUEST["in"] == "no")
320 /* cancle the game */
321 $message = "Hello, \n\n".
322 "the game has been canceled due to the request of one of the players.\n";
324 $userids = DB_get_all_userid_by_gameid($gameid);
325 foreach($userids as $user)
327 $To = DB_get_email_by_userid($user);
328 mymail($To,$EmailName."game canceled",$message);
331 /* delete everything from the dB */
336 echo "thanks for joining the game...";
338 $mycards = DB_get_hand($me);
340 echo "<p class=\"mycards\" style=\"margin-top:8em;\">your cards are: <br />\n";
341 foreach($mycards as $card)
342 display_card($card,$PREF["cardset"]);
345 check_for_sickness($me,$mycards);
347 /* move on to the next stage*/
348 DB_set_hand_status_by_hash($me,'check');
354 /* ok, user is in the game, saw his cards and selected his vorbehalt
355 * so first we check what he selected
357 echo "Processing what you selected in the last step...<br />";
359 if(!myisset("solo","wedding","poverty","nines") )
361 /* all these variables have a pre-selected default,
362 * so we should never get here,
363 * unless a user tries to cheat ;) */
364 echo "something went wrong...please contact the admin.";
368 /* check if this sickness needs to be handled first */
369 $gametype = DB_get_gametype_by_gameid($gameid);
370 $startplayer = DB_get_startplayer_by_gameid($gameid);
372 if( $_REQUEST["solo"]!="No")
374 /* user wants to play a solo */
376 /* store the info in the user's hand info */
377 DB_set_solo_by_hash($me,$_REQUEST["solo"]);
378 DB_set_sickness_by_hash($me,"solo");
380 echo "<br />Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.<br />\n";
382 if($gametype == "solo" && $startplayer<$mypos)
383 {}/* do nothing, since someone else already is playing solo */
386 /* this solo comes first
387 * store info in game table
389 DB_set_gametype_by_gameid($gameid,"solo");
390 DB_set_startplayer_by_gameid($gameid,$mypos);
391 DB_set_solo_by_gameid($gameid,$_REQUEST["solo"]);
394 else if($_REQUEST["wedding"] == "yes")
396 /* TODO: add silent solo somewhere*/
397 echo "Ok, you don't want to play a silent solo...wedding was chosen.<br />\n";
398 DB_set_sickness_by_hash($me,"wedding");
400 else if($_REQUEST["poverty"] == "yes")
402 echo "Don't think you can win with just a few trump...? ok, poverty chosen <br />\n";
403 DB_set_sickness_by_hash($me,"poverty");
405 else if($_REQUEST["nines"] == "yes")
407 echo "What? You just don't want to play a game because you have a few nines? Well, if no one".
408 " is playing solo, this game will be canceled.<br />\n";
409 DB_set_sickness_by_hash($me,"nines");
413 echo " Ok, done with checking, please go to the <a href=\"$host?me=$me\">next step of the setup</a>.<br />";
415 /* move on to the next stage*/
416 DB_set_hand_status_by_hash($me,'poverty');
420 /* here we need to check if there is a solo or some other form of sickness.
421 * If so, which one is the most important one
422 * set that one in the Game table
423 * tell people about it.
425 echo "<br /> Checking if someone else selected solo, nines or wedding or poverty.<br />";
427 /* check if everyone has reached this stage */
428 $userids = DB_get_all_userid_by_gameid($gameid);
430 foreach($userids as $user)
432 $userstat = DB_get_hand_status_by_userid_and_gameid($user,$gameid);
433 if($userstat!='poverty' && $userstat!='play')
439 echo "This step can only be handled after everyone finished the last step. ".
440 "Seems like this is not the case, so you need to wait a bit... please check back later....<br />";
444 echo "Everyone has finished checking their cards, let's see what they said...<br />";
446 /* check what kind of game we are playing, in case there are any solos this already
447 *will have the correct information in it */
448 $gametype = DB_get_gametype_by_gameid($gameid);
449 $startplayer = DB_get_startplayer_by_gameid($gameid);
451 /* check for different sickness and just output a general info */
458 foreach($userids as $user)
460 $name = DB_get_name_by_userid($user);
461 $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
462 if($usersick == 'nines')
465 echo "$name has a Vorbehalt. <br />";
468 else if($usersick == 'poverty')
471 echo "$name has a Vorbehalt. <br />";
473 else if($usersick == 'wedding')
476 echo "$name has a Vorbehalt. <br />" ;
478 else if($usersick == 'solo')
481 echo "$name has a Vorbehalt. <br />" ;
485 /* now check which sickness comes first and set the gametype to it */
487 /* gamestatus == normal, => cancel game */
488 if($gametype == "solo")
495 /* TODO: should we keep statistics of this? */
496 $message = "Hello, \n\n".
497 "the game has been canceled because ".DB_get_name_by_userid($nines).
498 " has five or more nines and nobody is playing solo.\n";
500 /* TODO: add info about redeal in case this is a game of a series */
502 $userids = DB_get_all_userid_by_gameid($gameid);
503 foreach($userids as $user)
505 $To = DB_get_email_by_userid($user);
506 mymail($To,$EmailName."game canceled",$message);
509 /* delete everything from the dB */
512 echo "The game has been canceled because ".DB_get_name_by_userid($nines).
513 " has five or more nines and nobody is playing solo.\n";
519 DB_set_gametype_by_gameid($gameid,"poverty");
520 $gametype = "poverty";
521 $who=DB_get_sickness_by_gameid($gameid);
524 $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
525 if($firstsick == "poverty")
526 DB_set_sickness_by_gameid($gameid,2); /* who needs to be asked first */
528 DB_set_sickness_by_gameid($gameid,1); /* who needs to be asked first */
533 DB_set_gametype_by_gameid($gameid,"dpoverty");
534 $gametype = "dpoverty";
535 $who=DB_get_sickness_by_gameid($gameid);
538 $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
539 if($firstsick == "poverty")
541 $seconsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
542 if($secondsick == "poverty")
543 DB_set_sickness_by_gameid($gameid,30); /* who needs to be asked first */
545 DB_set_sickness_by_gameid($gameid,20); /* who needs to be asked first */
548 DB_set_sickness_by_gameid($gameid,10); /* who needs to be asked first */
553 DB_set_gametype_by_gameid($gameid,"wedding");
554 $gametype = "wedding";
559 /* now the gametype is set correctly (shouldn't matter that this is calculated for every user)
560 * output what kind of game we have */
563 foreach($userids as $user)
565 /* userids are sorted by position...
566 * so output whatever the firstone has, then whatever the next one has
567 * stop when the sickness is the same as the gametype
570 $name = DB_get_name_by_userid($user);
571 $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
574 echo "$name has $usersick. <br />"; /*TODO: perhaps save this in a string and store in Game? */
576 if($usersick=="poverty")
578 if($usersick == "wedding" && $gametype =="wedding")
580 if($usersick == "poverty" && $gametype =="poverty")
582 if($usersick == "poverty" && $gametype =="dpoverty" && $poverty==2)
584 if($usersick == "solo" && $gametype =="solo")
588 /* output Schweinchen in case the rules need it */
589 if( $gametype != "solo")
590 if($GAME["schweinchen"] && $RULES["schweinchen"]=="both" )
591 echo DB_get_name_by_hash($GAME["schweinchen-who"])." has Schweinchen. <br />";
595 /* finished the setup, set re/contra parties if possible, go to next stage unless there is a case of poverty*/
599 /* are we the solo player? set us to re, else set us to contra */
600 $pos = DB_get_pos_by_hash($me);
601 if($pos == $startplayer)
602 DB_set_party_by_hash($me,"re");
604 DB_set_party_by_hash($me,"contra");
605 DB_set_hand_status_by_hash($me,'play');
609 /* set person with the wedding to re, do the rest during the game */
610 $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
611 if($usersick == "wedding")
612 DB_set_party_by_hash($me,"re");
614 echo "Don't know who will be Re and Contra, you need to ".
615 "figure that out at the end of the game yourself <br />\n";
616 DB_set_hand_status_by_hash($me,'play');
620 $hand = DB_get_all_hand($me);
622 if(in_array('3',$hand)||in_array('4',$hand))
623 DB_set_party_by_hash($me,"re");
625 DB_set_party_by_hash($me,"contra");
626 DB_set_hand_status_by_hash($me,'play');
630 /* check if poverty resolved (e.g. DB.Game who set to NULL)
631 * yes? =>trump was taken, start game; break;
633 $who=DB_get_sickness_by_gameid($gameid);
635 { /* trump has been taken */
636 DB_set_hand_status_by_hash($me,'play');
640 if($who>9) /*= two people still have trump on the table*/
645 /* check if we are being asked now
646 * no, display wait message, e.g. player X is asked at the moment
648 $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
649 if(myisset("trump") && $_REQUEST["trump"]=="no" && ($who==$mypos || $who==$mypos*10))
651 /* user doesn't want to take trump */
652 /* set next player who needs to be asked */
653 $firstsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid);
654 $secondsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid);
656 if($firstsick=="poverty")
658 if($secondsick=="poverty")
659 DB_set_sickness_by_gameid($gameid,$who+$add*3);
661 DB_set_sickness_by_gameid($gameid,$who+$add*2);
664 DB_set_sickness_by_gameid($gameid,$who+$add);
666 /* this user is done */
667 DB_set_hand_status_by_hash($me,'play');
670 else if(myisset("trump") && !myisset("exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10))
672 /* user wants to take trump */
673 $trump = $_REQUEST["trump"];
675 /* get hand id for user $trump */
676 $userhand=DB_get_handid_by_gameid_and_userid($gameid,$trump);
677 /* copy trump from player A to B */
678 $result = mysql_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" );
680 /* set re/contra, if it is not already set */
681 $party = DB_get_party_by_hash($me);
684 foreach($userids as $user)
686 $hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
687 if($user == $trump || $user == $myid)
688 DB_set_party_by_hash($hash,"re");
690 DB_set_party_by_hash($hash,"contra");
693 /* add hidden button with trump in it to get to the next point */
694 echo "<form action=\"index.php\" method=\"post\">\n";
695 echo " <input type=\"hidden\" name=\"exchange\" value=\"-1\" />\n";
696 echo " <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
697 echo " <input type=\"hidden\" name=\"me\" value=\"".$me."\" />\n";
698 echo " <input type=\"submit\" class=\"submitbutton\" value=\"select cards to give back\" />\n";
701 else if(myisset("trump","exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10))
703 $trump = $_REQUEST["trump"];
704 $exchange = $_REQUEST["exchange"];
705 $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump);
707 /* if exchange is set to a value>0, exchange that card back to user $trump */
710 $result = mysql_query("UPDATE Hand_Card SET hand_id='$userhand'".
711 " WHERE hand_id='$myhand' AND card_id='$exchange'" );
714 /* if number of cards == 12, set status to play for both users */
715 $result = mysql_query("SELECT COUNT(*) FROM Hand_Card WHERE hand_id='$myhand'" );
716 $r = mysql_fetch_array($result,MYSQL_NUM);
719 die("error in poverty");
723 if($gametype=="poverty" || $who<9)
725 DB_set_sickness_by_gameid($gameid,-1); /* done with poverty */
727 else /* reduce poverty count by one, that is go to single digits $who */
732 $firstsick = DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid);
733 $secondsick = DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid);
734 if($firstsick!="poverty")
735 DB_set_sickness_by_gameid($gameid,$who+$add);
738 if($secondsick!="poverty")
739 DB_set_sickness_by_gameid($gameid,$who+$add*2);
741 DB_set_sickness_by_gameid($gameid,$who+$add*3);
745 /* this user is done */
746 DB_set_hand_status_by_hash($me,'play');
747 /* and so is his partner */
748 $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump);
749 DB_set_hand_status_by_hash($hash,'play');
755 /* else show all trump, have lowest card pre-selected, have hidden setting for */
756 echo "you need to get rid of a few cards<br />\n";
758 set_gametype($gametype); /* this sets the $CARDS variable */
759 $mycards = DB_get_hand($me);
760 $mycards = mysort($mycards,$gametype);
762 echo "<form class=\"exchange\" action=\"index.php\" method=\"post\">\n";
764 foreach($mycards as $card)
765 display_link_card($card,$PREF["cardset"],$type);
766 echo " <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
767 echo " <input type=\"hidden\" name=\"me\" value=\"".$me."\" />\n";
768 echo " <input type=\"submit\" class=\"submitbutton\" value=\"select one card to give back\" />\n";
772 else if($who == $mypos || $who == $mypos*10)
774 foreach($userids as $user)
776 $name = DB_get_name_by_userid($user);
777 $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
779 if($usersick=="poverty")
781 $hash =DB_get_hash_from_gameid_and_userid($gameid,$user);
782 $cards=DB_get_hand($hash);
783 $nrtrump=count_trump($cards);
786 echo "Player $name has $nrtrump trump. Do you want to take them?".
787 "<a href=\"index.php?me=$me&trump=$user\">yes</a> <br />";
790 echo "I don't want to take any trump: ".
791 "<a href=\"index.php?me=$me&trump=no\">yes</a> <br />";
795 echo "it's not your turn yet to decide if you want to take the trump or not.";
798 * yes, display number of trump and user's hand, ask if he wants to take it
799 * no, set whom-to-ask to next player, email next player, cancle game if no next player
800 * yes -> link to new page:display all cards, ask for N return cards
806 /* check if noone wanted to take trump, in that case the gamesickness would be set to 5 or 50 */
807 $who=DB_get_sickness_by_gameid($gameid);
808 if($who==5 || $who==50)
810 $message = "Hello, \n\n".
811 "Game $gameid has been cancled since nobody wanted to take the trump.\n";
813 $userids = DB_get_all_userid_by_gameid($gameid);
814 foreach($userids as $user)
816 $To = DB_get_email_by_userid($user);
817 mymail($To,$EmailName."game cancled (poverty not resolved)",$message);
820 /* delete everything from the dB */
823 echo "<p style=\"background-color:red\";>Game $gameid has been cancled.<br /><br /></p>";
828 /* check if all players are ready to play */
830 foreach($userids as $user)
831 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='play')
836 /* only set this after all poverty, etc. are handled*/
837 DB_set_game_status_by_gameid($gameid,'play');
839 /* email startplayer */
840 $startplayer = DB_get_startplayer_by_gameid($gameid);
841 $email = DB_get_email_by_pos_and_gameid($startplayer,$gameid);
842 $hash = DB_get_hash_from_game_and_pos($gameid,$startplayer);
846 /* email startplayer) */
847 $message = "It's your turn now.\n".
848 "Use this link to play a card: ".$host."?me=".$hash."\n\n" ;
849 mymail($email,$EmailName."ready, set, go... ",$message);
852 echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";
855 echo "You finished the setup, at the moment you need to reload this page after everyone else has finished there setup so that the server can figure out vorbehalte... in future this will get an email in case you need to do anything, but this is not implemented yet :( <br />";
860 /* both entries here, so that the tricks are visible for both.
861 * in case of 'play' there is a break later that skips the last part
864 /* figure out what kind of game we are playing,
865 * set the global variables $CARDS["trump"],$CARDS["diamonds"],$CARDS["hearts"],
866 * $CARDS["clubs"],$CARDS["spades"],$CARDS["foxes"]
870 $gametype = DB_get_gametype_by_gameid($gameid);
872 if($gametype=="solo")
874 $gametype = DB_get_solo_by_gameid($gameid);
875 $GT = $gametype." ".$GT;
880 set_gametype($gametype); /* this sets the $CARDS variable */
882 /* get some infos about the game */
883 $gamestatus = DB_get_game_status_by_gameid($gameid);
885 /* display useful things in divs */
887 /* display links to the users status page */
888 $result = mysql_query("SELECT email,password from User WHERE id='$myid'" );
889 $r = mysql_fetch_array($result,MYSQL_NUM);
891 display_links($r[0],$r[1]);
893 /* end display useful things*/
895 /* has the game started? No, then just wait here...*/
896 if($gamestatus == 'pre')
898 echo "You finished the setup, but not everyone else finished it...so you need to wait for the others... <br />";
899 break; /* not sure this works... the idea is that you can
900 * only play a card after everyone is ready to play */
903 /* display the table and the names */
904 $result = mysql_query("SELECT User.fullname as name,".
905 " Hand.position as position, ".
908 "LEFT JOIN User ON User.id=Hand.user_id ".
909 "WHERE Hand.game_id='".$gameid."' ".
910 "ORDER BY position ASC");
912 echo "<div class=\"table\">\n".
913 " <img src=\"pics/table.png\" alt=\"table\" />\n";
914 while($r = mysql_fetch_array($result,MYSQL_NUM))
920 $offset = DB_get_user_timezone($user);
921 $zone = return_timezone($offset);
922 date_default_timezone_set($zone);
924 echo " <span class=\"table".($pos-1)."\">\n";
925 echo " $name <br />\n";
926 echo " local time: ".date("Y-m-d H:i:s")."\n";
932 /* get everything relevant to display the tricks */
933 $result = mysql_query("SELECT Hand_Card.card_id as card,".
934 " Hand.position as position,".
935 " Play.sequence as sequence, ".
939 "LEFT JOIN Play ON Trick.id=Play.trick_id ".
940 "LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ".
941 "LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ".
942 "LEFT JOIN Comment ON Play.id=Comment.play_id ".
943 "WHERE Trick.game_id='".$gameid."' ".
944 "ORDER BY Trick.id,sequence ASC");
947 $lasttrick = DB_get_max_trickid($gameid);
949 $play = array(); /* needed to calculate winner later */
951 $pos = DB_get_startplayer_by_gameid($gameid)-1;
952 $firstcard = ""; /* first card in a trick */
954 echo "\n<ul class=\"tricks\">\n";
955 echo " <li class=\"nohighlight\"> Game $gameid: </li>\n";
957 while($r = mysql_fetch_array($result,MYSQL_NUM))
964 /* check if first schweinchen has been played */
965 if($r[0] == 19 || $r[0] == 20 )
966 $GAME["schweinchen"]++;
968 /* save card to be able to find the winner of the trick later */
969 $play[$seq] = array("card"=>$r[0],"pos"=>$pos);
973 /* first card in a trick, output some html */
974 if($trick!=$lasttrick)
976 /* start of an old trick? */
977 echo " <li onclick=\"hl('$trickNR');\" class=\"old\"><a href=\"#\">Trick $trickNR</a>\n".
978 " <div class=\"trick\" id=\"trick".$trickNR."\">\n".
979 " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
981 else if($trick==$lasttrick)
983 /* start of a last trick? */
984 echo " <li onclick=\"hl('$trickNR');\" class=\"current\"><a href=\"#\">Trick $trickNR</a>\n".
985 " <div class=\"trick\" id=\"trick".$trickNR."\">\n".
986 " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
989 /* remember first card, so that we are able to check, what cards can be played */
994 echo " <div class=\"card".($pos-1)."\">\n";
996 /* display comments */
998 echo " <span class=\"comment\">".$comment."</span>\n";
1001 display_card($r[0],$PREF["cardset"]);
1003 echo " </div>\n"; /* end div card */
1009 echo " </div>\n </li>\n"; /* end div table, end li table */
1013 if($seq!=4 && $trickNR>1)
1014 echo " </div>\n </li>\n"; /* end div table, end li table */
1018 /* whos turn is it? */
1021 $winner = get_winner($play,$gametype); /* returns the position */
1023 $firstcard = ""; /* new trick, no first card */
1028 if($next==5) $next=1;
1031 /* my turn?, display cards as links, ask for comments*/
1032 if(DB_get_pos_by_hash($me) == $next)
1037 /* do we want to play a card? */
1038 if(myisset("card") && $myturn)
1040 $card = $_REQUEST["card"];
1041 $handid = DB_get_handid_by_hash($me);
1043 /* check if we have card and that we haven't played it yet*/
1044 /* set played in hand_card to true where hand_id and card_id*/
1045 $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ".
1046 "hand_id='$handid' AND card_id=".DB_quote_smart($card));
1047 $r = mysql_fetch_array($result,MYSQL_NUM);
1048 $handcardid = $r[0];
1054 /* mark card as played */
1055 mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
1056 DB_quote_smart($card));
1058 /* update Game timestamp */
1059 DB_update_game_timestamp($gameid);
1061 /* check for schweinchen */
1062 //echo "schweinchen = ".$GAME["schweinchen"]." --$card-<br />";
1063 if($card == 19 || $card == 20 )
1065 $GAME["schweinchen"]++;
1066 if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" )
1067 $comment="Schweinchen! ";
1068 if($RULES["schweinchen"]=="both" )
1069 $comment="Schweinchen! ";
1070 echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
1073 /* get trick id or start new trick */
1074 $a = DB_get_current_trickid($gameid);
1078 $playid = DB_play_card($trickid,$handcardid,$sequence);
1080 /* check for coment */
1081 if(myisset("comment"))
1083 $comment.=$_REQUEST["comment"];
1086 DB_insert_comment($comment,$playid,$myid);
1088 /* display played card */
1089 echo "<div class=\"card\">";
1090 echo " you played <br />";
1091 display_card($card,$PREF["cardset"]);
1094 /*check if we still have cards left, else set status to gameover */
1095 if(sizeof(DB_get_hand($me))==0)
1097 DB_set_hand_status_by_hash($me,'gameover');
1098 $mystatus='gameover';
1101 /* if all players are done, set game status to game over,
1102 * get the points of the last trick and send out an email
1105 $userids = DB_get_all_userid_by_gameid($gameid);
1108 foreach($userids as $user)
1109 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
1114 DB_set_game_status_by_gameid($gameid,"gameover");
1115 /* get score for last trick
1116 * all other tricks are handled a few lines further down*/
1117 $play = DB_get_cards_by_trick($trickid);
1118 $winner = get_winner($play,$gametype); /* returns the position */
1119 /* get points of last trick and save it */
1121 foreach($play as $card)
1122 $points = $points + card_value($card["card"]);
1123 $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner);
1125 mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')");
1127 echo "ERROR during scoring";
1129 /* email all players */
1130 /* individual score */
1131 $result = mysql_query("SELECT fullname, SUM(score), Hand.party FROM Score".
1132 " LEFT JOIN Hand ON Hand.id=hand_id".
1133 " LEFT JOIN User ON Hand.user_id=User.id".
1134 " WHERE Hand.game_id=$gameid".
1135 " GROUP BY fullname" );
1136 $message = "The game is over. Thanks for playing :)\n";
1137 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1138 $message .= " FINAL SCORE: ".$r[0]."(".$r[2].") ".$r[1]."\n";
1139 $message .= "\nIf your not in the list above your score is zero...\n\n";
1141 $result = mysql_query("SELECT Hand.party, SUM(score) FROM Score".
1142 " LEFT JOIN Hand ON Hand.id=hand_id".
1143 " LEFT JOIN User ON Hand.user_id=User.id".
1144 " WHERE Hand.game_id=$gameid".
1145 " GROUP BY Hand.party" );
1147 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1148 $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n";
1150 foreach($userids as $user)
1152 $To = DB_get_email_by_userid($user);
1153 mymail($To,$EmailName."game over",$message);
1158 /* email next player */
1159 if(DB_get_game_status_by_gameid($gameid)=='play')
1163 $play = DB_get_cards_by_trick($trickid);
1164 $winner = get_winner($play,$gametype); /* returns the position */
1166 /* get points of last trick and save it, last trick is handled
1167 * a few lines further up */
1169 foreach($play as $card)
1170 $points = $points + card_value($card["card"]);
1172 $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner);
1174 mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')");
1176 echo "ERROR during scoring";
1179 echo "DEBUG: $winner got $points <br />";
1181 /* who is the next player? */
1186 $next = DB_get_pos_by_hash($me)+1;
1188 if($next==5) $next=1;
1190 /* email next player */
1191 $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
1192 $email = DB_get_email_by_hash($next_hash);
1194 $message = "It's your turn now.\n".
1195 "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
1196 mymail($email,$EmailName."a card has been played",$message);
1199 echo "DEBUG:<a href=\"index.php?me=".DB_get_hash_from_game_and_pos($gameid,$next).
1200 "\"> next player </a> <br />\n";
1206 echo "can't find that card?! <br />\n";
1209 else if(myisset("card") && !$myturn )
1211 echo "please wait until it's your turn! <br />\n";
1214 $mycards = DB_get_hand($me);
1215 $mycards = mysort($mycards,$gametype);
1216 echo "<div class=\"mycards\">\n";
1218 if($myturn && !myisset("card"))
1220 echo "Hello ".$myname.", it's your turn! <br />\n";
1221 echo "Your cards are: <br />\n";
1222 echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
1224 /* do we have to follow suite? */
1226 if(have_suit($mycards,$firstcard))
1229 foreach($mycards as $card)
1231 if($followsuit && !same_type($card,$firstcard))
1232 display_card($card,$PREF["cardset"]);
1234 display_link_card($card,$PREF["cardset"]);
1237 echo "<br />\nA short comments:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"50\" />\n";
1238 echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
1239 echo "<input type=\"submit\" value=\"move\" />\n";
1242 else if($mystatus=='play')
1244 echo "Your cards are: <br />\n";
1245 foreach($mycards as $card)
1246 display_card($card,$PREF["cardset"]);
1248 else if($mystatus=='gameover')
1250 $oldcards = DB_get_all_hand($me);
1251 $oldcards = mysort($oldcards,$gametype);
1252 echo "Your cards were: <br />\n";
1253 foreach($oldcards as $card)
1254 display_card($card,$PREF["cardset"]);
1258 /* check if we need to set status to 'gameover' is done during playing of the card */
1259 if($mystatus=='play')
1261 /* the following happens only when the gamestatus is 'gameover' */
1262 /* check if game is over, display results */
1263 if(DB_get_game_status_by_gameid($gameid)=='play')
1265 echo "the game is over for you.. other people still need to play though";
1269 echo "the game is over now...<br />\n";
1271 $result = mysql_query("SELECT fullname, SUM(score), Hand.party FROM Score".
1272 " LEFT JOIN Hand ON Hand.id=hand_id".
1273 " LEFT JOIN User ON Hand.user_id=User.id".
1274 " WHERE Hand.game_id=$gameid".
1275 " GROUP BY fullname" );
1276 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1277 echo " FINAL SCORE: ".$r[0]."(".$r[2].") ".$r[1]."<br />";
1279 $result = mysql_query("SELECT Hand.party, SUM(score) FROM Score".
1280 " LEFT JOIN Hand ON Hand.id=hand_id".
1281 " LEFT JOIN User ON Hand.user_id=User.id".
1282 " WHERE Hand.game_id=$gameid".
1283 " GROUP BY Hand.party" );
1284 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1285 echo " FINAL SCORE: ".$r[0]." ".$r[1]."<br />\n";
1288 $session = DB_get_session_by_gameid($gameid);
1289 $result = mysql_query("SELECT id,create_date FROM Game".
1290 " WHERE session=$session".
1291 " ORDER BY create_date DESC".
1295 $r = mysql_fetch_array($result,MYSQL_NUM);
1297 if(!$session || $gameid==$r[0])
1299 /* suggest a new game with the same people in it, just rotated once */
1300 $names = DB_get_all_names_by_gameid($gameid);
1301 output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
1306 echo "error in testing the status";
1311 /* user status page */
1312 else if(myisset("email","password"))
1314 /* test id and password, should really be done in one step */
1315 $email = $_REQUEST["email"];
1316 $password = $_REQUEST["password"];
1318 if(myisset("forgot"))
1322 $uid = DB_get_userid_by_email($email);
1328 echo "Hmm, you forgot your passwort...nothing I can do at the moment:( ";
1329 echo " you need to email Arun for now... in the future it will be all automated and an ";
1330 echo "email with a new password will go to $email.";
1335 echo "you need to give me an email address!";
1337 echo "couldn't find a player with this email, please contact Arun, if you think this is a mistake";
1342 /* verify password and email */
1343 if(strlen($password)!=32)
1344 $password = md5($password);
1347 $uid = DB_get_userid_by_email_and_password($email,$password);
1353 if(myisset("setpref"))
1355 $setpref=$_REQUEST["setpref"];
1359 case "englishcards":
1360 $result = mysql_query("SELECT * from User_Prefs".
1361 " WHERE user_id='$uid' AND pref_key='cardset'" );
1362 if( mysql_fetch_array($result,MYSQL_NUM))
1363 $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref).
1364 " WHERE user_id='$uid' AND pref_key='cardset'" );
1366 $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$uid','cardset',".DB_quote_smart($setpref).")");
1367 echo "Ok, changed you preferences for the cards.\n";
1371 else /* output default user page */
1373 $time = DB_get_user_timestamp($uid);
1374 $unixtime =strtotime($time);
1376 $offset = DB_get_user_timezone($uid);
1377 $zone = return_timezone($offset);
1378 date_default_timezone_set($zone);
1380 /* display links to settings */
1381 output_user_settings($email,$password);
1383 echo "last login: ".date("r",$unixtime)."<br />";
1385 DB_update_user_timestamp($uid);
1387 echo "<p>these are the games you are playing in:<br />\n";
1388 $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand".
1389 " LEFT JOIN Game On Hand.game_id=Game.id".
1390 " WHERE Hand.user_id='$uid' AND Game.status<>'gameover'" );
1391 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1393 echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a>";
1394 if(time()-strtotime($r[2]) > 60*60*24*30)
1395 echo " The game has been running for over a month.".
1396 " Do you want to cancel it? <a href=\"$host?cancle=1&me=".$r[0]."\">yes</a>".
1397 " (clicking here is final and can't be restored)";
1403 echo "<p>and these are your games that are already done:<br />Game: \n";
1404 $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" );
1405 while( $r = mysql_fetch_array($result,MYSQL_NUM))
1406 echo "<a href=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>, ";
1409 $names = DB_get_all_names();
1410 echo "<p>registered players:<br />\n";
1411 foreach ($names as $name)
1415 echo "<p>Want to start a new game? Visit <a href=\"".$host."?new\">this page.</a></p>";
1420 echo "sorry email and password don't match <br />";
1426 /* page for registration */
1427 else if(myisset("register") )
1431 /* new user wants to register */
1432 else if(myisset("Rfullname","Remail","Rpassword","Rtimezone") )
1435 if(DB_get_userid_by_name($_REQUEST["Rfullname"]))
1437 echo "please chose another name<br />";
1440 if(DB_get_userid_by_email($_REQUEST["Remail"]))
1442 echo "this email address is already used ?!<br />";
1447 $r=mysql_query("INSERT INTO User VALUES(NULL,".DB_quote_smart($_REQUEST["Rfullname"]).
1448 ",".DB_quote_smart($_REQUEST["Remail"]).
1449 ",".DB_quote_smart(md5($_REQUEST["Rpassword"])).
1450 ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL)");
1453 echo " added you to the database";
1455 echo " something went wrong";
1458 /* default login page */
1461 $pre=0;$game=0;$done=0;
1462 $r=mysql_query("SELECT COUNT(id) FROM Game GROUP BY status");
1464 $pre = mysql_fetch_array($r,MYSQL_NUM);
1465 $game = mysql_fetch_array($r,MYSQL_NUM);
1466 $done = mysql_fetch_array($r,MYSQL_NUM);
1468 output_home_page($pre[0],$game[0],$done[0]);