BUGFIX: output call only after game started; move after game comments to right menu
[e-DoKo.git] / index.php
1 <?php
2 error_reporting(E_ALL);
3
4 include_once("config.php");      
5 include_once("output.php");      /* html output only */
6 include_once("db.php");          /* database only */
7 include_once("functions.php");   /* the rest */
8
9 config_check();
10
11 if(DB_open()<0)
12   {
13     output_header();
14     echo "Database error, can't connect... Please wait a while and try again. ".
15       "If the problem doesn't go away feel free to contact $ADMIN_NAME at $ADMIN_EMAIL.";
16     output_footer(); 
17     exit(); 
18   }
19
20 /* start a session, if it is not already running */
21 session_start();
22
23 /* done major error checking, output header of HTML page */
24 output_header();
25
26 /* check if we want to start a new game */
27 if(myisset("logout"))
28   {
29     session_unset();
30     session_destroy();
31     $_SESSION = array();
32     echo "you are now logged out!";
33   }
34 else if(myisset("new"))
35   {
36     if( isset($_SESSION["name"]) )
37       {
38         $names = DB_get_all_names();
39         output_form_for_new_game($names);
40       }
41     else
42       {
43         echo "Please log in.";
44       }
45   }
46 /*check if everything is ready to set up a new game */
47  else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD","dullen","schweinchen","call" ))
48   {
49     $PlayerA = $_REQUEST["PlayerA"];
50     $PlayerB = $_REQUEST["PlayerB"];
51     $PlayerC = $_REQUEST["PlayerC"];
52     $PlayerD = $_REQUEST["PlayerD"];
53
54     $dullen      = $_REQUEST["dullen"];
55     $schweinchen = $_REQUEST["schweinchen"];
56     $call        = $_REQUEST["call"];
57
58     $EmailA  = DB_get_email_by_name($PlayerA);
59     $EmailB  = DB_get_email_by_name($PlayerB);
60     $EmailC  = DB_get_email_by_name($PlayerC);
61     $EmailD  = DB_get_email_by_name($PlayerD);
62     
63     if($EmailA=="" || $EmailB=="" || $EmailC=="" || $EmailD=="")
64       {
65         echo "couldn't find one of the names, please start a new game";
66         output_footer();
67         DB_close();
68         exit();
69       }
70     
71     $useridA  = DB_get_userid_by_name($PlayerA);
72     $useridB  = DB_get_userid_by_name($PlayerB);
73     $useridC  = DB_get_userid_by_name($PlayerC);
74     $useridD  = DB_get_userid_by_name($PlayerD);
75     
76     /* create random numbers */
77     $randomNR       = create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD);
78     $randomNRstring = join(":",$randomNR);
79         
80     /* create game */
81     $followup = NULL;
82     if(myisset("followup") )
83       {
84         $followup= $_REQUEST["followup"];
85         $session = DB_get_session_by_gameid($followup);
86         $ruleset = DB_get_ruleset_by_gameid($followup); /* just copy ruleset from old game, 
87                                                          this way no manipulation is possible */
88         if($session)
89           mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',".
90                       "'$ruleset','$session' ,NULL)");
91         else
92           {
93             /* get max session */
94             $max = DB_get_max_session();
95             $max++;
96             mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup));
97             mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',".
98                         "'$ruleset','$max' ,NULL)");
99           }
100       }
101     else
102       {
103         /* get ruleset information or create new one */
104         $ruleset = DB_get_ruleset($dullen,$schweinchen,$call);
105         if($ruleset <0) 
106           {
107             myerror("Error defining ruleset: $ruleset");
108             output_footer();
109             DB_close();
110             exit();
111           };
112         /* get max session */
113         $max = DB_get_max_session();
114         $max++;
115         
116         mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre', ".
117                   "'$ruleset','$max' ,NULL)");
118       }
119     $game_id = mysql_insert_id();
120     
121     /* create hash */
122     $TIME  = (string) time(); /* to avoid collisions */
123     $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA.$TIME);
124     $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB.$TIME);
125     $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC.$TIME);
126     $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD.$TIME);
127     
128     /* create hands */
129     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridA).
130                 ", ".DB_quote_smart($hashA).", 'start','1',NULL,NULL,NULL,NULL)");
131     $hand_idA = mysql_insert_id();                                                             
132     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridB).
133                 ", ".DB_quote_smart($hashB).", 'start','2',NULL,NULL,NULL,NULL)");
134     $hand_idB = mysql_insert_id();                                                             
135     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridC).
136                 ", ".DB_quote_smart($hashC).", 'start','3',NULL,NULL,NULL,NULL)");
137     $hand_idC = mysql_insert_id();                                                             
138     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridD).
139                 ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,NULL)");
140     $hand_idD = mysql_insert_id();
141     
142     /* save cards */
143     for($i=0;$i<12;$i++)
144       mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idA', '".$randomNR[$i]."', 'false')");
145     for($i=12;$i<24;$i++)
146       mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idB', '".$randomNR[$i]."', 'false')");
147     for($i=24;$i<36;$i++)
148       mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idC', '".$randomNR[$i]."', 'false')");
149     for($i=36;$i<48;$i++)
150       mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idD', '".$randomNR[$i]."', 'false')");
151     
152     /* send out email, TODO: check for error with email */
153     $message = "\n".
154       "you are invited to play a game of DoKo (that is to debug the program ;).\n".
155       "Place comments and bug reports here:\n".
156       "http://wiki.nubati.net/index.php?title=EmailDoko\n\n".
157       "The whole round would consist of the following players:\n".
158       "$PlayerA\n".
159       "$PlayerB\n".
160       "$PlayerC\n".
161       "$PlayerD\n\n".
162       "If you want to join this game, please follow this link:\n\n".
163       "".$host."?me=";
164     
165     mymail($EmailA,"You are invited to a game of DoKo","Hello $PlayerA,\n".$message.$hashA);
166     mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
167     mymail($EmailC,"You are invited to a game of DoKo","Hello $PlayerC,\n".$message.$hashC);
168     mymail($EmailD,"You are invited to a game of DoKo","Hello $PlayerD,\n".$message.$hashD);
169     
170     echo "You started a new game. The emails have been sent out!";    
171   }    /* end set up a new game */
172 /* cancle a game, if nothing has happend in the last N minutes */
173 else if(myisset("cancle","me"))
174   {
175     $me = $_REQUEST["me"];
176     
177     /* test for valid ID */
178     $myid = DB_get_userid_by_hash($me);
179     if(!$myid)
180       {
181         echo "Can't find you in the database, please check the url.<br />\n";
182         echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
183         output_footer();
184         DB_close();
185         exit();
186       }
187     
188     DB_update_user_timestamp($myid);
189     
190     /* get some information from the DB */
191     $gameid   = DB_get_gameid_by_hash($me);
192     $myname   = DB_get_name_by_hash($me);
193
194     /* check if game really is old enough */
195     $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
196     $r = mysql_fetch_array($result,MYSQL_NUM);
197     if(time()-strtotime($r[0]) > 60*60*24*30) /* = 1 month */
198       {
199         $message = "Hello, \n\n".
200           "Game ".DB_format_gameid($gameid)." has been cancled since nothing happend for a while and $myname requested it.\n";
201         
202         $userids = DB_get_all_userid_by_gameid($gameid);
203         foreach($userids as $user)
204           {
205             $To = DB_get_email_by_userid($user);
206             mymail($To,$EmailName."game ".DB_format_gameid($gameid)." cancled (timed out)",$message);
207           }
208         
209         /* delete everything from the dB */
210         DB_cancel_game($me);
211         
212         echo "<p style=\"background-color:red\";>Game ".DB_format_gameid($gameid)." has been cancled.<br /><br /></p>";
213       }
214     else
215       echo "<p>You need to wait longer before you can cancle a game...</p>\n";
216   }
217 /* handle request from one specific player for one game,
218  * (the hash is set on a per game base) */
219 else if(myisset("me"))
220   {
221     $me = $_REQUEST["me"];
222     
223     /* test for valid ID */
224     $myid = DB_get_userid_by_hash($me);
225     if(!$myid)
226       {
227         echo "Can't find you in the database, please check the url.<br />\n";
228         echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
229         output_footer();
230         DB_close();
231         exit();
232       }
233
234     if(isset($_SESSION["name"]))
235       output_status($_SESSION["name"]);
236
237     /* the user had done something, update the timestamp */
238     DB_update_user_timestamp($myid);
239     
240     /* get some information from the DB */
241     $gameid   = DB_get_gameid_by_hash($me);
242     $myname   = DB_get_name_by_hash($me);
243     $mystatus = DB_get_status_by_hash($me);
244     $mypos    = DB_get_pos_by_hash($me);
245     $myhand   = DB_get_handid_by_hash($me);
246     $session  = DB_get_session_by_gameid($gameid);
247
248     /* get prefs and save them */
249     DB_get_PREF($myid);
250     /* end set pref */
251       
252     /* get rule set for this game */
253     $result = mysql_query("SELECT * FROM Rulesets".
254                           " LEFT JOIN Game ON Game.ruleset=Rulesets.id ".
255                           " WHERE Game.id='$gameid'" );
256     $r      = mysql_fetch_array($result,MYSQL_NUM);
257
258     $RULES["dullen"]      = $r[2];
259     $RULES["schweinchen"] = $r[3];
260     $RULES["call"]        = $r[4];
261
262     /* get some infos about the game */
263     $gametype   = DB_get_gametype_by_gameid($gameid);
264     $gamestatus = DB_get_game_status_by_gameid($gameid);
265     $GT         = $gametype;
266     if($gametype=="solo")
267       {
268         $gametype = DB_get_solo_by_gameid($gameid);
269         $GT  = $gametype." ".$GT;
270       }
271     
272     /* does anyone have both foxes */
273     $GAME["schweinchen"]=0; 
274     for($i=1;$i<5;$i++)
275       {
276         $hash  = DB_get_hash_from_game_and_pos($gameid,$i);
277         $cards = DB_get_all_hand($hash);
278         if( in_array("19",$cards) && in_array("20",$cards) )
279           {
280             $GAME["schweinchen"]=1;
281             $GAME["schweinchen-who"]=$hash;
282           }
283       };
284
285     /* put everyting in a form */
286     echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
287
288     /* output left menu */
289
290     display_user_menu();
291
292     /* output right menu */
293
294       /* display rule set for this game */
295     echo "<div class=\"gameinfo\">\n";
296
297     if($gamestatus != 'pre')
298       echo " Gametype: $GT <br />\n";
299     
300     echo "Rules: <br />\n";
301     echo "10ofhearts : ".$RULES["dullen"]      ."<br />\n";
302     echo "schweinchen: ".$RULES["schweinchen"] ."<br />\n";
303     echo "call:        ".$RULES["call"]        ."<br />\n";
304
305     echo "<hr />\n";
306     if($gamestatus == 'play' )
307       output_form_calls($me);
308
309     /* get time from the last action of the game */
310     $result  = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
311     $r       = mysql_fetch_array($result,MYSQL_NUM);
312     $gameend = time() - strtotime($r[0]);
313     
314     if($gamestatus == 'play' || $gameend < 60*60*24*7)
315       {
316         echo "<br />\nA short comment:<input name=\"comment\" type=\"text\" size=\"15\" maxlength=\"100\" />\n";
317         echo "<hr />";
318       }
319
320     echo "<input type=\"submit\" value=\"submit\" />\n";
321
322
323     if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
324       {
325         echo "<hr />\n";
326         
327         $session = DB_get_session_by_gameid($gameid);
328         $result  = mysql_query("SELECT id,create_date FROM Game".
329                                " WHERE session=$session".
330                                " ORDER BY create_date DESC".
331                                " LIMIT 1");
332         $r = -1;
333         if($result)
334           $r = mysql_fetch_array($result,MYSQL_NUM);
335         
336         if(!$session || $gameid==$r[0])
337           {
338             /* suggest a new game with the same people in it, just rotated once (unless last game was solo) */
339             $names = DB_get_all_names_by_gameid($gameid);
340             $type  = DB_get_gametype_by_gameid($gameid);
341             
342             if($type=="solo")
343               output_ask_for_new_game($names[0],$names[1],$names[2],$names[3],$gameid);
344             else
345               output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
346           }
347       }
348
349     echo "</div>\n";
350
351     /* output game */
352
353     /* output extra division in case this game is part of a session */
354     if($session)
355       {
356         echo "<div class=\"session\">\n".
357           "This game is part of session $session: \n";
358         $hashes = DB_get_hashes_by_session($session,$myid);
359         $i = 1;
360         foreach($hashes as $hash)
361           {
362             if($hash == $me)
363               echo "$i ";
364             else 
365               echo "<a href=\"".$host."?me=".$hash."\">$i</a> ";
366             $i++;
367           }
368         echo "</div>\n";
369       }
370       
371     /* display the table and the names */
372     display_table();
373
374     /* mystatus gets the player through the different stages of a game.
375      * start:    yes/no
376      * init:     check values from start,
377      *           check for sickness
378      * check:    check for return values from init
379      * poverty:  handle poverty, wait here until all player have reached this state
380      *           display sickness and move on to game
381      * play:     game in progress
382      * gameover: are we revisiting a game
383      */
384     switch($mystatus)
385       {
386       case 'start':
387         if( !myisset("in") )
388           {
389             output_check_want_to_play($me);
390             break;
391           }
392         else
393           {
394             /* move on to the next stage*/
395             DB_set_hand_status_by_hash($me,'init');
396           }
397       case 'init':
398         /* first check if everything went ok  in the last step
399          * if not, send user back, if yes, check what he did
400          */
401         if( !myisset("in") )
402           {
403             echo "<p> You need to answer the <a href=\"$host?me=$me\">question</a>.</p>";
404             DB_set_hand_status_by_hash($me,'start');
405           }
406         else
407           {
408             if($_REQUEST["in"] == "no")
409               {
410                 /* cancel the game */
411                 $message = "Hello, \n\n".
412                   "the game has been canceled due to the request of one of the players.\n";
413                 
414                 $userids = DB_get_all_userid_by_gameid($gameid);
415                 foreach($userids as $user)
416                   {
417                     $To = DB_get_email_by_userid($user);
418                     mymail($To,$EmailName."game ".DB_format_gameid($gameid)." canceled",$message);
419                   }
420                 
421                 /* delete everything from the dB */
422                 DB_cancel_game($me);
423               }
424             else
425               {
426                 $mycards = DB_get_hand($me);
427                 sort($mycards);
428
429                 output_check_for_sickness($me,$mycards);
430                 
431                 echo "<p class=\"mycards\">your cards are: <br />\n";
432                 foreach($mycards as $card) 
433                   display_card($card,$PREF["cardset"]);
434                 echo "</p>\n";   
435                 
436                 /* move on to the next stage*/
437                 DB_set_hand_status_by_hash($me,'check');
438               }
439           }
440         break;
441
442     case 'check':
443       /* ok, user is in the game, saw his cards and selected his vorbehalt
444        * so first we check what he selected
445        */
446       if(!myisset("solo","wedding","poverty","nines") )
447         {
448           /* all these variables have a pre-selected default,
449            * so we should never get here,
450            * unless a user tries to cheat ;)
451            * can also happen if user reloads the page!
452            */
453           echo "<p> You need to answer the <a href=\"$host?me=$me&in=yes\">questions</a>.</p>";
454           DB_set_hand_status_by_hash($me,'init');
455         }
456       else
457         {
458           echo "Processing what you selected in the last step...<br />";
459       
460           /* check if this sickness needs to be handled first */
461           $gametype    = DB_get_gametype_by_gameid($gameid);
462           $startplayer = DB_get_startplayer_by_gameid($gameid);
463           
464           if( $_REQUEST["solo"]!="No")
465             {
466               /* user wants to play a solo */
467
468               /* store the info in the user's hand info */
469               DB_set_solo_by_hash($me,$_REQUEST["solo"]);
470               DB_set_sickness_by_hash($me,"solo");
471
472               echo "<br />Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.<br />\n";
473               
474               if($gametype == "solo" && $startplayer<$mypos)
475                 {}/* do nothing, since someone else already is playing solo */
476               else
477                 {
478                   /* this solo comes first 
479                    * store info in game table
480                    */
481                   DB_set_gametype_by_gameid($gameid,"solo");
482                   DB_set_startplayer_by_gameid($gameid,$mypos);
483                   DB_set_solo_by_gameid($gameid,$_REQUEST["solo"]);
484                 };
485             }
486           else if($_REQUEST["wedding"] == "yes")
487             {
488               /* TODO: add silent solo somewhere*/
489               echo "Ok, you don't want to play a silent solo...wedding was chosen.<br />\n";
490               DB_set_sickness_by_hash($me,"wedding");
491             }
492           else if($_REQUEST["poverty"] == "yes")
493             {
494               echo "Don't think you can win with just a few trump...? ok, poverty chosen <br />\n";
495               DB_set_sickness_by_hash($me,"poverty");
496             }
497           else if($_REQUEST["nines"] == "yes")
498             {
499               echo "What? You just don't want to play a game because you have a few nines? Well, if no one".
500                 " is playing solo, this game will be canceled.<br />\n";
501               DB_set_sickness_by_hash($me,"nines");
502             }
503           
504           echo " Ok, done with checking, please go to the <a href=\"$host?me=$me\">next step of the setup</a>.<br />";
505           
506           /* move on to the next stage*/
507           DB_set_hand_status_by_hash($me,'poverty');
508           
509           /* check if everyone has reached this stage, send out email */
510           $userids = DB_get_all_userid_by_gameid($gameid);
511           $ok = 1;
512           foreach($userids as $user)
513             {
514               $userstat = DB_get_hand_status_by_userid_and_gameid($user,$gameid);
515               if($userstat!='poverty' && $userstat!='play')
516                 {
517                   $ok = 0;
518                   DB_set_player_by_gameid($gameid,$user);
519                 }
520             };
521           if($ok)
522             {
523               /* reset player = everyone has to do something now */
524               DB_set_player_by_gameid($gameid,NULL);
525               
526               foreach($userids as $user)
527                 {
528                   $To       = DB_get_email_by_userid($user);
529                   $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
530                   if($userhash != $me)
531                     {
532                       $message = "Everyone finish the questionary in game ".DB_format_gameid($gameid).", ".
533                         "please visit this link now to continue: \n".
534                         " ".$host."?me=".$userhash."\n\n" ;
535                       mymail($To,$EmailName." finished setup in game ".DB_format_gameid($gameid),$message);
536                     }
537                 };
538             };
539         };
540
541       break;
542
543     case 'poverty':
544       /* here we need to check if there is a solo or some other form of sickness.
545        * If so, which one is the most important one
546        * set that one in the Game table
547        * tell people about it.
548        */
549       echo "<br /> Checking if someone else selected solo, nines, wedding or poverty.<br />";
550       
551       /* check if everyone has reached this stage */
552       $userids = DB_get_all_userid_by_gameid($gameid);
553       $ok = 1;
554       foreach($userids as $user)
555         {
556           $userstat = DB_get_hand_status_by_userid_and_gameid($user,$gameid);
557           if($userstat!='poverty' && $userstat!='play')
558             $ok = 0;
559         };
560
561       if(!$ok)
562         {
563           echo "This step can only be handled after everyone finished the last step. ".
564                "Seems like this is not the case, so you need to wait a bit... ".
565                "you will get an email once that is the case, please use the link in ".
566                "that email to continue the game.<br />";
567         }
568       else
569         {
570           echo "Everyone has finished checking their cards, let's see what they said...<br />";
571
572           /* check what kind of game we are playing,  in case there are any solos this already 
573            *will have the correct information in it */
574           $gametype    = DB_get_gametype_by_gameid($gameid);
575           $startplayer = DB_get_startplayer_by_gameid($gameid);
576
577           /* check for different sickness and just output a general info */
578           $nines   = 0;
579           $poverty = 0;
580           $wedding = 0;
581           $solo    = 0;
582           foreach($userids as $user)
583             {
584               $name     = DB_get_name_by_userid($user);
585               $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
586               if($usersick == 'nines')
587                 {
588                   $nines = $user;
589                   echo "$name has a Vorbehalt. <br />";
590                   break;
591                 }
592               else if($usersick == 'poverty')
593                 {
594                   $poverty++;
595                   echo "$name has a Vorbehalt. <br />";
596                 }
597               else if($usersick == 'wedding')
598                 {
599                   $wedding=$user;
600                   echo "$name has a Vorbehalt. <br />"  ;
601                 }
602               else if($usersick == 'solo')
603                 {
604                   $solo++;
605                   echo "$name has a Vorbehalt. <br />"  ;
606                 }
607             }
608
609           /* now check which sickness comes first and set the gametype to it */
610
611           if($gametype == "solo")
612             {
613               /* do nothing */
614             }
615           else if($nines)
616             {
617               /* cancel game */
618               /* TODO: should we keep statistics of this? */
619               $message = "Hello, \n\n".
620                 " the game has been canceled because ".DB_get_name_by_userid($nines).
621                 " has five or more nines and nobody is playing solo.\n\n".
622                 " To redeal either start a new game or, in case the game was part of a tournament, \n".
623                 " go to the last game and use the link at the bottom of the page to redeal.";
624               
625               $userids = DB_get_all_userid_by_gameid($gameid);
626               foreach($userids as $user)
627                 {
628                   $To = DB_get_email_by_userid($user);
629                   mymail($To,$EmailName."game ".DB_format_gameid($gameid)." canceled",$message);
630                 }
631               
632               /* delete everything from the dB */
633               DB_cancel_game($me);
634               
635               echo "The game has been canceled because ".DB_get_name_by_userid($nines).
636                 " has five or more nines and nobody is playing solo.\n";
637               output_footer();
638               DB_close();
639               exit();
640             }
641           else if($poverty==1) /* one person has poverty */
642             {
643               DB_set_gametype_by_gameid($gameid,"poverty");
644               $gametype = "poverty";
645               $who      = DB_get_sickness_by_gameid($gameid);
646               if(!$who)
647                 {
648                   $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
649                   if($firstsick == "poverty")
650                     DB_set_sickness_by_gameid($gameid,2); /* who needs to be asked first */
651                   else
652                     DB_set_sickness_by_gameid($gameid,1); /* who needs to be asked first */
653                 }
654             }
655           else if($poverty==2) /* two people have poverty */
656             {
657               DB_set_gametype_by_gameid($gameid,"dpoverty");
658               $gametype = "dpoverty";
659               $who      = DB_get_sickness_by_gameid($gameid);
660               if(!$who)
661                 {
662                   $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
663                   if($firstsick == "poverty")
664                     {
665                       $seconsick = DB_get_sickness_by_pos_and_gameid(1,$gameid);
666                       if($secondsick == "poverty")
667                         DB_set_sickness_by_gameid($gameid,30); /* who needs to be asked first */
668                       else
669                         DB_set_sickness_by_gameid($gameid,20); /* who needs to be asked first */
670                     }
671                   else
672                     DB_set_sickness_by_gameid($gameid,10); /* who needs to be asked first */
673                 }
674             }
675           else if($wedding> 0)
676             {
677               DB_set_gametype_by_gameid($gameid,"wedding");
678               DB_set_sickness_by_gameid($gameid,'-1'); /* wedding not resolved yet */
679               $gametype = "wedding";
680             };
681
682           echo "<br />\n";
683
684           /* now the gametype is set correctly (shouldn't matter that this is calculated for every user)
685            * output what kind of game we have */
686           
687           $poverty = 0;
688           foreach($userids as $user)
689             {
690               /* userids are sorted by position... 
691                * so output whatever the first one has, then whatever the next one has
692                * stop when the sickness is the same as the gametype 
693                */
694               
695               $name     = DB_get_name_by_userid($user);
696               $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
697
698               if($usersick)
699                 echo "$name has $usersick. <br />"; /*TODO: perhaps save this in a string and store in Game? */
700
701               if($usersick=="poverty")
702                 $poverty++;
703               if($usersick == "wedding" && $gametype =="wedding")
704                 break;
705               if($usersick == "poverty" && $gametype =="poverty")
706                 break;
707               if($usersick == "poverty" && $gametype =="dpoverty" && $poverty==2)
708                 break;
709               if($usersick == "solo" && $gametype =="solo")
710                 break;
711             };
712
713           /* output Schweinchen in case the rules need it */
714           if( $gametype != "solo")
715             if($GAME["schweinchen"] && $RULES["schweinchen"]=="both" )
716               echo DB_get_name_by_hash($GAME["schweinchen-who"])." has Schweinchen. <br />";
717           
718           echo "<br />\n";
719           
720           /* finished the setup, set re/contra parties if possible, go to next stage unless there is a case of poverty*/
721           switch($gametype)
722             {
723             case "solo":
724               /* are we the solo player? set us to re, else set us to contra */
725               $pos = DB_get_pos_by_hash($me);
726               if($pos == $startplayer)
727                 DB_set_party_by_hash($me,"re");
728               else
729                 DB_set_party_by_hash($me,"contra");
730               DB_set_hand_status_by_hash($me,'play');
731               break;
732
733             case "wedding":
734               /* set person with the wedding to re, do the rest during the game */
735               $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
736               if($usersick == "wedding")
737                 DB_set_party_by_hash($me,"re");
738               else
739                 DB_set_party_by_hash($me,"contra");
740               
741               echo "Whoever will make the first trick will be on the re team. <br />\n";
742               echo " Ok, the game can start now, please finish <a href=\"$host?me=$me\">the setup</a>.<br />";       
743               DB_set_hand_status_by_hash($me,'play');
744               break;
745
746             case "normal":
747               $hand = DB_get_all_hand($me);
748               
749               if(in_array('3',$hand)||in_array('4',$hand))
750                 DB_set_party_by_hash($me,"re");
751               else
752                 DB_set_party_by_hash($me,"contra");
753               DB_set_hand_status_by_hash($me,'play');
754               break;
755             case "poverty":
756             case "dpoverty":
757               /* check if poverty resolved (e.g. DB.Game who set to NULL)
758                *   yes? =>trump was taken, start game; break; 
759                */
760               $who = DB_get_sickness_by_gameid($gameid);
761               if($who<0)
762                 { /* trump has been taken */
763                   DB_set_hand_status_by_hash($me,'play');
764                   break;
765                 };
766               
767               if($who>9) /*= two people still have trump on the table*/
768                 $add = 10;
769               else
770                 $add = 1;
771
772               /* check if we are being asked now
773                *    no? display wait message, e.g. player X is asked at the moment 
774                */
775               $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
776               if(myisset("trump") && $_REQUEST["trump"]=="no" && ($who==$mypos || $who==$mypos*10))
777                 {
778                   /* user doesn't want to take trump */
779                   /* set next player who needs to be asked */
780                   $firstsick  = (string) DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid);
781                   $secondsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid);
782                   
783                   if($firstsick=="poverty")
784                     {
785                       if($secondsick=="poverty")
786                         DB_set_sickness_by_gameid($gameid,$who+$add*3);
787                       else
788                         DB_set_sickness_by_gameid($gameid,$who+$add*2);
789                     }
790                   else
791                     DB_set_sickness_by_gameid($gameid,$who+$add);
792
793                   /* email next player */
794                   $who = DB_get_sickness_by_gameid($gameid);
795                   if($who>9) $who = $who/10;
796                   
797                   if($who<=4)
798                     {
799                       $To       = DB_get_email_by_pos_and_gameid($who,$gameid);
800                       $userhash = DB_get_hash_from_game_and_pos($gameid,$who);
801                       DB_set_player_by_gameid($gameid,$who);
802
803                       $message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:".
804                         " ".$host."?me=".$userhash."\n\n" ;
805                       mymail($To,$EmailName." poverty (game ".DB_format_gameid($gameid).")",$message);
806                     }
807
808                   /* this user is done */
809                   DB_set_hand_status_by_hash($me,'play');
810                   break;                
811                 }
812               else if(myisset("trump") && !myisset("exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10))
813                 {
814                   /* user wants to take trump */
815                   $trump = $_REQUEST["trump"];
816
817                   /* get hand id for user $trump */
818                   $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump);
819                   /* copy trump from player A to B */
820                   $result = mysql_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" );
821                   
822                   /* add hidden button with trump in it to get to the next point */
823                   echo "<div class=\"poverty\">\n";
824                   echo "  <input type=\"hidden\" name=\"exchange\" value=\"-1\" />\n";
825                   echo "  <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
826                   echo "  <input type=\"submit\" class=\"submitbutton\" value=\"select cards to give back\" />\n";
827                   echo "</div>\n";
828                 }
829               else if(myisset("trump","exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10))
830                 {
831                   $trump    = $_REQUEST["trump"];
832                   $exchange = $_REQUEST["exchange"];
833                   $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump);
834
835                   /* if exchange is set to a value>0, exchange that card back to user $trump */
836                   if($exchange >0)
837                     {
838                       $result = mysql_query("UPDATE Hand_Card SET hand_id='$userhand'".
839                                             " WHERE hand_id='$myhand' AND card_id='$exchange'" );
840                     };
841                   
842                   /* if number of cards == 12, set status to play for both users */
843                   $result = mysql_query("SELECT COUNT(*) FROM Hand_Card  WHERE hand_id='$myhand'" );
844                   $r      = mysql_fetch_array($result,MYSQL_NUM);
845                   if(!$r)
846                     {
847                       myerror("error in poverty");
848                       die();
849                     };
850                   if($r[0]==12)
851                     {
852                       if($gametype=="poverty" || $who<9)
853                         {
854                           DB_set_sickness_by_gameid($gameid,-1); /* done with poverty */                          
855                         }
856                       else /* reduce poverty count by one, that is go to single digits $who */
857                         {
858                           $add = 1;
859                           $who = $who/10;
860
861                           /* whom to ask next */
862                           $firstsick  = DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid);
863                           $secondsick = DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid);
864
865                           if($firstsick!="poverty")
866                             DB_set_sickness_by_gameid($gameid,$who+$add);
867                           else
868                             {
869                               if($secondsick!="poverty")
870                                 DB_set_sickness_by_gameid($gameid,$who+$add*2);
871                               else
872                                 DB_set_sickness_by_gameid($gameid,$who+$add*3);
873                             };
874
875                           /* email next player */
876                           $who = DB_get_sickness_by_gameid($gameid);
877                           if($who<=4)
878                             {
879                               $To       = DB_get_email_by_pos_and_gameid($who,$gameid);
880                               $userhash = DB_get_hash_from_game_and_pos($gameid,$who);
881                               DB_set_player_by_gameid($gameid,$who);
882
883                               $message = "Someone has poverty, it's your turn to decide, ".
884                                          "if you want to take the trump. Please visit:".
885                                          " ".$host."?me=".$userhash."\n\n" ;
886                               mymail($To,$EmailName." poverty (game ".DB_format_gameid($gameid).")",$message);
887                             }
888                         }
889                       
890                       /* this user is done */
891                       DB_set_hand_status_by_hash($me,'play');
892                       /* and so is his partner */
893                       $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump);
894                       DB_set_hand_status_by_hash($hash,'play');
895
896                       /* set party to re, unless we had dpoverty, in that case check if we need to set re/contra*/
897                       $re_set = 0;
898                       foreach($userids as $user)
899                         {
900                           $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
901                           $party    = DB_get_party_by_hash($userhash);
902                           if($party=="re")
903                             $re_set = 1;
904                         }
905                       if($re_set)
906                         {
907                           DB_set_party_by_hash($me,"contra");
908                           DB_set_party_by_hash($hash,"contra");
909                         }
910                       else
911                         {
912                           foreach($userids as $user)
913                             {
914                               $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
915                               if($userhash==$hash||$userhash==$me)
916                                 DB_set_party_by_hash($userhash,"re");
917                               else
918                                 DB_set_party_by_hash($userhash,"contra");
919                             }
920                         }
921
922
923                       break;
924                     }
925                   else
926                     {
927                       /* else show all trump, have lowest card pre-selected, have hidden setting for */
928                       echo "<div class=\"poverty\"> you need to get rid of a few cards</div>\n";
929                       
930                       set_gametype($gametype); /* this sets the $CARDS variable */
931                       $mycards = DB_get_hand($me);
932                       $mycards = mysort($mycards,$gametype);
933
934                       $type="exchange";
935                       echo "<div class=\"mycards\">Your cards are: <br />\n";
936                       foreach($mycards as $card) 
937                         display_link_card($card,$PREF["cardset"],$type);
938                       echo "  <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
939                       echo "  <input type=\"submit\" class=\"submitbutton\" value=\"select one card to give back\" />\n";
940                       echo "</div>\n";
941                     }
942                 }
943               else if($who == $mypos || $who == $mypos*10)
944                 {
945                   echo "<div class=\"poverty\">\n";
946                   foreach($userids as $user)
947                     {
948                       $name     = DB_get_name_by_userid($user);
949                       $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
950                       
951                       if($usersick=="poverty")
952                         {
953                           $hash    = DB_get_hash_from_gameid_and_userid($gameid,$user);
954                           $cards   = DB_get_hand($hash);
955                           $nrtrump = count_trump($cards);
956                           /* count trump */
957                           if($nrtrump<4)
958                             echo "Player $name has $nrtrump trump. Do you want to take them?".
959                               "<a href=\"index.php?me=$me&amp;trump=$user\">yes</a> <br />\n";
960                         }
961                     }
962                   echo "<a href=\"index.php?me=$me&amp;trump=no\">No,way I take those trump...</a> <br />\n";
963                   echo "</div>\n";
964                   
965                   echo "Your cards are: <br />\n";
966                   $mycards = DB_get_hand($me);
967                   sort($mycards);
968                   echo "<p class=\"mycards\">your cards are: <br />\n";
969                   foreach($mycards as $card) 
970                     display_card($card,$PREF["cardset"]);
971                   echo "</p>\n";   
972                 }
973               else
974                 {
975                   $mysick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
976                   if($mysick=="poverty")
977                     echo "The others are asked if they want to take your trump, you have to wait (you'll get an email).";
978                   else
979                     echo "it's not your turn yet to decide if you want to take the trump or not.";
980                 }
981             };
982           /* check if no one wanted to take trump, in that case the gamesickness would be set to 5 or 50 */
983           $who = DB_get_sickness_by_gameid($gameid);
984           if($who==5 || $who==50)
985             {
986               $message = "Hello, \n\n".
987                 "Game ".DB_format_gameid($gameid)." has been cancled since nobody wanted to take the trump.\n";
988               
989               $userids = DB_get_all_userid_by_gameid($gameid);
990               foreach($userids as $user)
991                 {
992                   $To = DB_get_email_by_userid($user);
993                   mymail($To,$EmailName."game ".DB_format_gameid($gameid)." cancled (poverty not resolved)",$message);
994                 }
995               
996               /* delete everything from the dB */
997               DB_cancel_game($me);
998               
999               echo "<p style=\"background-color:red\";>Game ".DB_format_gameid($gameid)." has been cancled.<br /><br /></p>";
1000               output_footer();
1001               DB_close();
1002               exit();
1003             }
1004           
1005           /* check if all players are ready to play */
1006           $ok = 1;
1007           foreach($userids as $user)
1008             if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='play')
1009               {
1010                 $ok = 0;
1011                 DB_set_player_by_gameid($gameid,$user);
1012               }
1013           
1014           if($ok)
1015             {
1016               /* only set this after all poverty, etc. are handled*/
1017               DB_set_game_status_by_gameid($gameid,'play');
1018               
1019               /* email startplayer */
1020               $startplayer = DB_get_startplayer_by_gameid($gameid);
1021               $email       = DB_get_email_by_pos_and_gameid($startplayer,$gameid);
1022               $hash        = DB_get_hash_from_game_and_pos($gameid,$startplayer);
1023               $who         = DB_get_userid_by_email($email);
1024               DB_set_player_by_gameid($gameid,$who);
1025               
1026               if($hash!=$me)
1027                 {
1028                   /* email startplayer) */
1029                   $message = "It's your turn now in game ".DB_format_gameid($gameid).".\n".
1030                     "Use this link to play a card: ".$host."?me=".$hash."\n\n" ;
1031                   mymail($email,$EmailName."ready, set, go... (game ".DB_format_gameid($gameid).") ",$message);
1032                 }
1033               else
1034                 echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";      
1035             }
1036           else
1037             echo "\n <br />";    
1038         }
1039       break;
1040     case 'play':
1041     case 'gameover': 
1042       /* both entries here,  so that the tricks are visible for both.
1043        * in case of 'play' there is a break later that skips the last part
1044        */
1045       
1046       /* figure out what kind of game we are playing, 
1047        * set the global variables $CARDS["trump"],$CARDS["diamonds"],$CARDS["hearts"],
1048        * $CARDS["clubs"],$CARDS["spades"],$CARDS["foxes"]
1049        * accordingly
1050        */
1051       
1052       $gametype = DB_get_gametype_by_gameid($gameid);
1053       $GT       = $gametype;
1054       if($gametype=="solo")
1055         {
1056           $gametype = DB_get_solo_by_gameid($gameid);
1057           $GT       = $gametype." ".$GT;
1058         }
1059       else
1060         $gametype = "normal";
1061       
1062       set_gametype($gametype); /* this sets the $CARDS variable */
1063       
1064       /* get some infos about the game */
1065       $gamestatus = DB_get_game_status_by_gameid($gameid);
1066       
1067       /* has the game started? No, then just wait here...*/
1068       if($gamestatus == 'pre')
1069         {
1070           echo "You finished the setup, but not everyone else finished it... ".
1071                "so you need to wait for the others. Just wait for the an email... <br />";
1072           break; /* not sure this works... the idea is that you can 
1073                   * only  play a card after everyone is ready to play */
1074         }
1075
1076       /* get time from the last action of the game */
1077       $result  = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
1078       $r       = mysql_fetch_array($result,MYSQL_NUM);
1079       $gameend = time() - strtotime($r[0]);
1080
1081       /* handel comments in case player didn't play a card, allow comments a week after the end of the game */
1082       if( (!myisset("card") && $mystatus=='play') || ($mystatus=='gameover' && ($gameend < 60*60*24*7)) )
1083         if(myisset("comment"))
1084           {
1085             $comment = $_REQUEST["comment"];
1086             $playid = DB_get_current_playid($gameid);
1087             
1088             if($comment != "")
1089               DB_insert_comment($comment,$playid,$myid);
1090           };  
1091
1092       /* get everything relevant to display the tricks */
1093       $result = mysql_query("SELECT Hand_Card.card_id as card,".
1094                             "       Hand.position as position,".
1095                             "       Play.sequence as sequence, ".
1096                             "       Trick.id, ".
1097                             "       GROUP_CONCAT(CONCAT('<span>',User.fullname,': ',Comment.comment,'</span>') SEPARATOR '\n' ), ".
1098                             "       Play.create_date, ".
1099                             "       Hand.user_id ".
1100                             "FROM Trick ".
1101                             "LEFT JOIN Play ON Trick.id=Play.trick_id ".
1102                             "LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ".
1103                             "LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ".
1104                             "LEFT JOIN Comment ON Play.id=Comment.play_id ".
1105                             "LEFT JOIN User On User.id=Comment.user_id ".
1106                             "WHERE Trick.game_id='".$gameid."' ".
1107                             "GROUP BY Trick.id, sequence ".
1108                             "ORDER BY Trick.id, sequence  ASC");
1109       $trickNR   = 1;
1110       $lasttrick = DB_get_max_trickid($gameid);
1111       
1112       $play = array(); /* needed to calculate winner later  */
1113       $seq  = 1;          
1114       $pos  = DB_get_startplayer_by_gameid($gameid)-1; 
1115       $firstcard = ""; /* first card in a trick */
1116       
1117       echo "\n<ul class=\"tricks\">\n";
1118       echo "  <li class=\"nohighlight\"> Game ".DB_format_gameid($gameid).": </li>\n";
1119       
1120       while($r = mysql_fetch_array($result,MYSQL_NUM))
1121         {
1122           $pos     = $r[1];
1123           $seq     = $r[2];
1124           $trick   = $r[3];
1125           $comment = $r[4];
1126           $timeplayed = strtotime($r[5]);
1127           $user    = $r[6];
1128
1129           $offset = DB_get_user_timezone($user);
1130           $zone   = return_timezone($offset);
1131           date_default_timezone_set($zone);
1132
1133           /* check if first schweinchen has been played */
1134           if($r[0] == 19 || $r[0] == 20 )
1135             $GAME["schweinchen"]++;
1136           
1137           /* save card to be able to find the winner of the trick later */
1138           $play[$seq] = array("card"=>$r[0],"pos"=>$pos); 
1139           
1140           if($seq==1)
1141             {
1142               /* first card in a trick, output some html */
1143               if($trick!=$lasttrick)
1144                 {
1145                   /* start of an old trick? */
1146                   echo "  <li onclick=\"hl('$trickNR');\" class=\"old\"><a href=\"#\">Trick $trickNR</a>\n".
1147                     "    <div class=\"trick\" id=\"trick".$trickNR."\">\n".
1148                     "      <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
1149                 }
1150               else if($trick==$lasttrick)
1151                 {
1152                   /* start of a last trick? */
1153                   echo "  <li onclick=\"hl('$trickNR');\" class=\"current\"><a href=\"#\">Trick $trickNR</a>\n".
1154                     "    <div class=\"trick\" id=\"trick".$trickNR."\">\n".
1155                     "      <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
1156                 };
1157               
1158               /* remember first card, so that we are able to check, what cards can be played */
1159               $firstcard = $r[0];
1160             };
1161           
1162           /* display card */
1163           echo "      <div class=\"card".($pos-1)."\">\n";
1164           
1165           /* display comments */
1166           if($comment!="")
1167             echo "        <span class=\"comment\">".$comment."</span>\n";
1168           
1169           echo "        ";
1170           display_card($r[0],$PREF["cardset"]);
1171           
1172           echo "      </div>\n"; /* end div card */
1173           
1174           /* end of trick? */
1175           if($seq==4)
1176             {
1177               $trickNR++;
1178               echo "    </div>\n  </li>\n";  /* end div trick, end li trick */
1179             }
1180         }
1181             
1182       /* whos turn is it? */
1183       if($seq==4)
1184         {
1185           $winner    = get_winner($play,$gametype); /* returns the position */
1186           $next      = $winner;
1187           $firstcard = ""; /* new trick, no first card */
1188         }
1189       else
1190         {
1191           $next = $pos+1;
1192           if($next==5) $next = 1;
1193         }
1194       
1195       /* my turn?, display cards as links, ask for comments*/
1196       if(DB_get_pos_by_hash($me) == $next)
1197         $myturn = 1;
1198       else
1199         $myturn = 0;
1200
1201       /* do we want to play a card? */
1202       if(myisset("card") && $myturn)
1203         {
1204           $card   = $_REQUEST["card"];
1205           $handid = DB_get_handid_by_hash($me); 
1206           
1207           /* check if we have card and that we haven't played it yet*/
1208           /* set played in hand_card to true where hand_id and card_id*/
1209           $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ".
1210                                 "hand_id='$handid' AND card_id=".DB_quote_smart($card));
1211           $r = mysql_fetch_array($result,MYSQL_NUM);
1212           $handcardid = $r[0];
1213           
1214           if($handcardid) /* everything ok, play card  */
1215             {
1216               /* update Game timestamp */
1217               DB_update_game_timestamp($gameid);
1218
1219               /* check if a call was made, must do this before we set the card status to played */
1220               if(myisset("call120") && $_REQUEST["call120"] == "yes" && can_call(120,$me))
1221                 $result = mysql_query("UPDATE Hand SET point_call='120' WHERE hash='$me' ");
1222               if(myisset("call90")  && $_REQUEST["call90"]  == "yes" && can_call(90,$me))
1223                 $result = mysql_query("UPDATE Hand SET point_call='90'  WHERE hash='$me' ");
1224               if(myisset("call60")  && $_REQUEST["call60"]  == "yes" && can_call(60,$me))
1225                 $result = mysql_query("UPDATE Hand SET point_call='60'  WHERE hash='$me' ");
1226               if(myisset("call30")  && $_REQUEST["call30"]  == "yes" && can_call(30,$me))
1227                 $result = mysql_query("UPDATE Hand SET point_call='30'  WHERE hash='$me' ");
1228               if(myisset("call0")   && $_REQUEST["call0"]   == "yes" && can_call(0,$me))
1229                 $result = mysql_query("UPDATE Hand SET point_call='0'   WHERE hash='$me' ");
1230                 
1231               /* mark card as played */
1232               mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
1233                           DB_quote_smart($card));
1234
1235               /* get trick id or start new trick */
1236               $a = DB_get_current_trickid($gameid);
1237               $trickid  = $a[0];
1238               $sequence = $a[1];
1239               $tricknr  = $a[2];
1240               
1241               $playid = DB_play_card($trickid,$handcardid,$sequence);
1242
1243               /* check for schweinchen */
1244               if($card == 19 || $card == 20 )
1245                 {
1246                   $GAME["schweinchen"]++;
1247                   if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" )
1248                     DB_insert_comment("Schweinchen! ",$playid,$myid);
1249                   if($RULES["schweinchen"]=="both" )
1250                     DB_insert_comment("Schweinchen! ",$playid,$myid);
1251                   if ($debug) 
1252                     echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
1253                 }
1254
1255               /* if sequence == 4 check who one in case of wedding */
1256               if($sequence == 4 && $GT == "wedding") 
1257                 {
1258                   /* is wedding resolve */
1259                   $resolved = DB_get_sickness_by_gameid($gameid); 
1260                   if($resolved<0)
1261                     {
1262                       /* who has wedding */
1263                       $userids = DB_get_all_userid_by_gameid($gameid);
1264                       foreach($userids as $user)
1265                         {
1266                           $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
1267                           if($usersick == "wedding")
1268                             $whosick = $user;
1269                         }
1270                       /* who won the trick */
1271                       $play     = DB_get_cards_by_trick($trickid);
1272                       $winner   = get_winner($play,$gametype); /* returns the position */
1273                       $winnerid = DB_get_userid_by_gameid_and_position($gameid,$winner);
1274                       /* is tricknr <=3 */
1275                       if($tricknr <=3 && $winnerid!=$whosick)
1276                         {
1277                           /* set resolved at tricknr*/
1278                           $resolved = DB_set_sickness_by_gameid($gameid,$tricknr); 
1279                           /* set partner */
1280                           $whash = DB_get_hash_from_gameid_and_userid($gameid,$winnerid);
1281                           DB_set_party_by_hash($whash,"re");
1282                         }
1283                       if($tricknr == 3 && $winnerid==$whosick)
1284                         {
1285                           /* set resolved at tricknr*/
1286                           $resolved = DB_set_sickness_by_gameid($gameid,'3'); 
1287                         }
1288                     }
1289                 }
1290
1291               /* if sequence == 4, set winner of the trick, count points and set the next player */
1292               if($sequence==4)
1293                 {
1294                   $play   = DB_get_cards_by_trick($trickid);
1295                   $winner = get_winner($play,$gametype); /* returns the position */
1296
1297                   if($winner>0)
1298                     mysql_query("UPDATE Trick SET winner='$winner' WHERE id='$trickid'");
1299                   else
1300                     echo "ERROR during scoring";
1301
1302                   if($debug)
1303                     echo "DEBUG: position $winner won the trick <br />";
1304
1305                   /* who is the next player? */
1306                   $next = $winner;
1307                 }
1308               else
1309                 {
1310                   $next = DB_get_pos_by_hash($me)+1;
1311                 }
1312               if($next==5) $next=1;
1313
1314               /* check for coment */
1315               if(myisset("comment"))
1316                 {
1317                   $comment = $_REQUEST["comment"];
1318                   if($comment != "")
1319                     DB_insert_comment($comment,$playid,$myid);
1320                 };  
1321               
1322               /* display played card */
1323               $pos = DB_get_pos_by_hash($me);
1324               if($sequence==1)
1325                 {
1326                   echo "  <li onclick=\"hl('".($tricknr)."');\" class=\"current\"><a href=\"#\">Trick ".($tricknr)."</a>\n".
1327                     "    <div class=\"trick\" id=\"trick".($tricknr)."\">\n".
1328                     "      <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
1329                 }
1330               
1331               echo "<div class=\"card".($pos-1)."\">";
1332               /* display comments */
1333               display_card($card,$PREF["cardset"]);
1334               if($comment!="")
1335                 echo "  <span class=\"comment\"> ".$comment."</span>\n";
1336               echo "</div></div></li>\n";
1337               
1338               /*check if we still have cards left, else set status to gameover */
1339               if(sizeof(DB_get_hand($me))==0)
1340                 {
1341                   DB_set_hand_status_by_hash($me,'gameover');
1342                   $mystatus='gameover';
1343                 }
1344               
1345               /* if all players are done, set game status to game over, 
1346                * get the points of the last trick and send out an email 
1347                * to all players
1348                */
1349               $userids = DB_get_all_userid_by_gameid($gameid);
1350               
1351               $done=1;
1352               foreach($userids as $user)
1353                 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
1354                   $done=0;
1355               
1356               if($done)
1357                 DB_set_game_status_by_gameid($gameid,"gameover");
1358
1359               /* email next player, if game is still running */
1360               if(DB_get_game_status_by_gameid($gameid)=='play')
1361                 {
1362                   $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
1363                   $email     = DB_get_email_by_hash($next_hash);
1364                   $who       = DB_get_userid_by_email($email);
1365                   DB_set_player_by_gameid($gameid,$who);
1366                   
1367                   $message = "A card has been played in game ".DB_format_gameid($gameid).".\n\n".
1368                     "It's your turn  now.\n".
1369                     "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
1370                   mymail($email,$EmailName."a card has been played in game ".DB_format_gameid($gameid),$message);
1371                 }
1372               else /* send out final email */
1373                 {
1374                   /* individual score */
1375                   $result = mysql_query("SELECT User.fullname, IFNULL(SUM(Card.points),0), Hand.party FROM Hand".
1376                                 " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
1377                                 " LEFT JOIN User ON User.id=Hand.user_id".
1378                                 " LEFT JOIN Play ON Trick.id=Play.trick_id".
1379                                 " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
1380                                 " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
1381                                 " WHERE Hand.game_id='$gameid'".
1382                                 " GROUP BY User.fullname" );
1383                   $message  = "The game is over. Thanks for playing :)\n";
1384                   $message .= "Final score:\n";
1385                   while( $r = mysql_fetch_array($result,MYSQL_NUM))
1386                     $message .= "   ".$r[0]."(".$r[2].") ".$r[1]."\n";
1387
1388                   $result = mysql_query("SELECT  Hand.party, IFNULL(SUM(Card.points),0) FROM Hand".
1389                                 " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
1390                                 " LEFT JOIN User ON User.id=Hand.user_id".
1391                                 " LEFT JOIN Play ON Trick.id=Play.trick_id".
1392                                 " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
1393                                 " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
1394                                 " WHERE Hand.game_id='$gameid'".
1395                                 " GROUP BY Hand.party" );
1396                   $message .= "\nTotals:\n";
1397                   while( $r = mysql_fetch_array($result,MYSQL_NUM))
1398                     $message .= "    ".$r[0]." ".$r[1]."\n";
1399                   
1400                   /* send out final email */
1401                   $all = array();
1402
1403                   foreach($userids as $user)
1404                     $all[] = DB_get_email_by_userid($user);
1405                   $To = implode(",",$all);
1406
1407                   $help = "\n\n (you can use reply all on this email to reach all the players.)\n";
1408                   mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 1(2)",$message.$help);
1409
1410                   foreach($userids as $user)
1411                     {
1412                       $To   = DB_get_email_by_userid($user);
1413                       $hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
1414                       
1415                       $link = "Use this link to have a look at game ".DB_format_gameid($gameid).": ".$host."?me=".$hash."\n\n" ;
1416                       mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 2(2)",$link);
1417                     }
1418                 }
1419             }
1420           else
1421             {
1422               echo "can't find that card?! <br />\n";
1423             }
1424         }
1425       else if(myisset("card") && !$myturn )
1426         {
1427           echo "please wait until it's your turn! <br />\n";
1428         }
1429
1430       if($seq!=4 && $trickNR>1) 
1431         echo "    </div>\n  </li>\n";  /* end div trick, end li trick */
1432
1433       /* display points in case game is over */
1434       if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
1435         {
1436           echo "  <li onclick=\"hl('13');\" class=\"current\"><a href=\"#\">Score</a>\n".
1437             "    <div class=\"trick\" id=\"trick13\">\n";
1438           /* add pic for re/contra
1439            "      <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";*/
1440           
1441           $result = mysql_query("SELECT User.fullname, IFNULL(SUM(Card.points),0), Hand.party,Hand.position FROM Hand".
1442                                 " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
1443                                 " LEFT JOIN User ON User.id=Hand.user_id".
1444                                 " LEFT JOIN Play ON Trick.id=Play.trick_id".
1445                                 " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
1446                                 " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
1447                                 " WHERE Hand.game_id='$gameid'".
1448                                 " GROUP BY User.fullname" );
1449           while( $r = mysql_fetch_array($result,MYSQL_NUM))
1450             echo "      <div class=\"card".($r[3]-1)."\">\n".
1451                  "        <span class=\"score\">".$r[2]."<br /> ".$r[1]."</span>\n".
1452                  "      </div>\n";
1453           
1454           echo "    </div>\n  </li>\n";  /* end div trick, end li trick */
1455         }
1456
1457       
1458       echo "</ul>\n"; /* end ul tricks*/
1459       
1460       $mycards = DB_get_hand($me);
1461       $mycards = mysort($mycards,$gametype);
1462       echo "<div class=\"mycards\">\n";
1463       
1464       if($myturn && !myisset("card") && $mystatus=='play' )
1465         {
1466           echo "Hello ".$myname.", it's your turn!  <br />\n";
1467           echo "Your cards are: <br />\n";
1468           
1469           /* do we have to follow suite? */
1470           $followsuit = 0;
1471           if(have_suit($mycards,$firstcard))
1472             $followsuit = 1;
1473           
1474           foreach($mycards as $card) 
1475             {
1476               if($followsuit && !same_type($card,$firstcard))
1477                 display_card($card,$PREF["cardset"]);
1478               else
1479                 display_link_card($card,$PREF["cardset"]);
1480             }
1481         }
1482       else if($mystatus=='play' )
1483         {         
1484           echo "Your cards are: <br />\n";
1485           foreach($mycards as $card) 
1486             display_card($card,$PREF["cardset"]);
1487         }
1488       else if($mystatus=='gameover')
1489         {
1490           $oldcards = DB_get_all_hand($me);
1491           $oldcards = mysort($oldcards,$gametype);
1492           echo "Your cards were: <br />\n";
1493           foreach($oldcards as $card) 
1494             display_card($card,$PREF["cardset"]);
1495           
1496           $userids = DB_get_all_userid_by_gameid($gameid);
1497           foreach($userids as $user)
1498             {
1499               $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
1500               
1501               if($userhash!=$me)
1502                 {
1503                   echo "<br />";
1504                   
1505                   $name = DB_get_name_by_userid($user);
1506                   $oldcards = DB_get_all_hand($userhash);
1507                   $oldcards = mysort($oldcards,$gametype);
1508                   echo "$name's cards were: <br />\n";
1509                   foreach($oldcards as $card)
1510                     display_card($card,$PREF["cardset"]);
1511                 }
1512             };
1513         }
1514       echo "</div>\n";
1515       
1516       /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
1517       if($mystatus=='play')
1518         break;
1519
1520       /* the following happens only when the gamestatus is 'gameover' */
1521       /* check if game is over, display results */
1522       if(DB_get_game_status_by_gameid($gameid)=='play')
1523         {
1524           echo "the game is over for you.. other people still need to play though";
1525         }
1526       else
1527         {
1528           $result = mysql_query("SELECT Hand.party, IFNULL(SUM(Card.points),0) FROM Hand".
1529                                 " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
1530                                 " LEFT JOIN User ON User.id=Hand.user_id".
1531                                 " LEFT JOIN Play ON Trick.id=Play.trick_id".
1532                                 " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
1533                                 " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
1534                                 " WHERE Hand.game_id='$gameid'".
1535                                 " GROUP BY Hand.party" );
1536           echo "<div class=\"total\"> Totals:<br />\n";
1537           while( $r = mysql_fetch_array($result,MYSQL_NUM))
1538             echo "  ".$r[0]." ".$r[1]."<br />\n";
1539           echo "</div>\n";
1540           
1541         }
1542       break;
1543     default:
1544       myerror("error in testing the status");
1545     }
1546     echo "</form>\n";
1547     output_footer();
1548     DB_close();
1549     exit();
1550  } 
1551 /* user status page */ 
1552 else if( myisset("email","password") || isset($_SESSION["name"]) )
1553    {
1554      /* test id and password, should really be done in one step */
1555      if(!isset($_SESSION["name"]))
1556        {
1557          $email     = $_REQUEST["email"];
1558          $password  = $_REQUEST["password"];
1559        }
1560      else
1561        {
1562          $name = $_SESSION["name"];
1563          $email     = DB_get_email_by_name($name);
1564          $password  = DB_get_passwd_by_name($name);
1565        };
1566      
1567      if(myisset("forgot"))
1568        {
1569          $ok = 1;
1570
1571          $myid = DB_get_userid_by_email($email);
1572          if(!$myid)
1573            $ok = 0;
1574          
1575          if($ok)
1576            {
1577              /* check how many entries in recovery table */
1578              $number = DB_get_number_of_passwords_recovery($myid);
1579              
1580              /* if less than N recent ones, add a new one and send out email */
1581              if( $number < 5 )
1582                {
1583                  echo "Ok, I send you a new password. <br />";
1584                  if($number >1)
1585                    echo "N.B. You tried this already $number times during the last day and it will only work ".
1586                      " 5 times during a day.<br />";
1587                  echo "The new password will be valid for one day, make sure you reset it to something else.<br />";
1588                  echo "Back to the  <a href=\"$host\">main page</a>.";
1589                  
1590                  $TIME  = (string) time(); /* to avoid collisions */
1591                  $hash  = md5("Anewpassword".$email.$TIME);
1592                  $newpw = substr($hash,1,8);
1593                  
1594                  $message = "Someone (hopefully you) requested a new password. \n".
1595                    "You can use this email and the following password: \n".
1596                    "   $newpw    \n".
1597                    "to log into the server. The new password is valid for 24h, so make\n".
1598                    "sure you reset your password to something new. Your old password will\n".
1599                    " also still be valid until you set a new one\n";
1600                  mymail($email,$EmailName."recovery ",$message);
1601                  
1602                  DB_set_recovery_password($myid,md5($newpw));
1603                }
1604              else
1605                {
1606                  echo "Sorry you already tried 5 times during the last 24h.<br />".
1607                    "You need to use one of those passwords or wait to get a new one.<br />";
1608                  echo "Back to the <a href=\"$host\">main page</a>.";
1609                }
1610            }
1611          else
1612            {
1613              if($email=="")
1614                echo "You need to give me an email address! <br />".
1615                  "Please try <a href=\"$host\">again</a>.";
1616              else
1617                echo "Couldn't find a player with this email! <br />".
1618                  "Please contact Arun, if you think this is a mistake <br />".
1619                  "or else try <a href=\"$host\">again</a>.";
1620            } 
1621        }
1622      else 
1623      {
1624        /* verify password and email */
1625        if(strlen($password)!=32)
1626          $password = md5($password);
1627        
1628        $ok  = 1;
1629        $myid = DB_get_userid_by_email_and_password($email,$password);
1630        if(!$myid)
1631          $ok = 0;
1632        
1633        if($ok)
1634          {
1635            DB_get_PREF($myid);
1636
1637            if(myisset("setpref"))
1638              {
1639                $setpref=$_REQUEST["setpref"];
1640                switch($setpref)
1641                  {
1642                  case "germancards":
1643                  case "englishcards":
1644                    $result = mysql_query("SELECT * from User_Prefs".
1645                                          " WHERE user_id='$myid' AND pref_key='cardset'" );
1646                    if( mysql_fetch_array($result,MYSQL_NUM))
1647                      $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref).
1648                                            " WHERE user_id='$myid' AND pref_key='cardset'" );
1649                    else
1650                      $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','cardset',".
1651                                            DB_quote_smart($setpref).")");
1652                    echo "Ok, changed you preferences for the cards.\n";
1653                    break;
1654                  }
1655              }
1656            else if(myisset("passwd"))
1657              {
1658                if( $_REQUEST["passwd"]=="ask" )
1659                  {
1660                    /* reset password form*/
1661                    output_password_recovery($email,$password);         
1662                  }
1663                else if($_REQUEST["passwd"]=="set")
1664                  {
1665                    /* reset password */
1666                    $ok = 1;
1667
1668                    /* check if old password matches */
1669                    $oldpasswd = md5($_REQUEST["password0"]);
1670                    if(!( ($password == $oldpasswd) || DB_check_recovery_passwords($oldpasswd,$email) ))
1671                      $ok = -1;
1672                    /* check if new passwords are types the same twice */
1673                    if($_REQUEST["password1"] != $_REQUEST["password2"] )
1674                      $ok = -2;
1675                    
1676                    switch($ok)
1677                      {
1678                      case '-2':
1679                        echo "The new passwords don't match. <br />";
1680                        break;
1681                      case '-1':
1682                        echo "The old password is not correct. <br />";
1683                        break;
1684                      case '1':
1685                        echo "Changed the password.<br />";
1686                        mysql_query("UPDATE User SET password='".md5($_REQUEST["password1"]).
1687                                    "' WHERE id=".DB_quote_smart($myid));
1688                        break;
1689                      }
1690                    /* set password */
1691                  }
1692              }
1693            else /* output default user page */
1694              {
1695                $time     = DB_get_user_timestamp($myid);
1696                $unixtime = strtotime($time);
1697                
1698                $offset   = DB_get_user_timezone($myid);
1699                $zone     = return_timezone($offset);
1700                date_default_timezone_set($zone);
1701
1702                $myname = DB_get_name_by_email($email);
1703                $_SESSION["name"] = $myname;
1704
1705                if(isset($_SESSION["name"]))
1706                  output_status($_SESSION["name"]);
1707                
1708                /* display links to settings */
1709                output_user_settings($email,$password);
1710                
1711                echo "<div style=\"position:absolute; font-size:smaller; top:0; left:0; \">last login: ".date("r",$unixtime)."</div>";
1712                
1713                DB_update_user_timestamp($myid);
1714              
1715                display_user_menu();
1716   
1717                echo "<h4>These are all your games:</h4>\n";
1718                echo "<p>Session: <br />\n";
1719                echo "<span class=\"gamestatuspre\"> p </span> =  pre-game phase ";
1720                echo "<span class=\"gamestatusplay\">P </span> =  game in progess ";
1721                echo "<span class=\"gamestatusover\">F </span> =  game finished <br />";
1722                echo "</p>\n";
1723                
1724                $output = array();
1725                $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date,Game.player,Game.status from Hand".
1726                                      " LEFT JOIN Game ON Game.id=Hand.game_id".
1727                                      " WHERE user_id='$myid'".
1728                                      " ORDER BY Game.session,Game.create_date" );
1729                $gamenrold = -1;
1730                echo "<table>\n <tr><td>\n";
1731                while( $r = mysql_fetch_array($result,MYSQL_NUM))
1732                  {
1733                    $game = DB_format_gameid($r[1]);
1734                    $gamenr = (int) $game;
1735                    if($gamenrold < $gamenr)
1736                      {
1737                        if($gamenrold!=-1)
1738                          echo "</td></tr>\n <tr> <td>$gamenr:</td><td> ";
1739                        else
1740                          echo "$gamenr:</td><td> ";
1741                        $gamenrold = $gamenr;
1742                      }
1743                    if($r[4]=='pre')
1744                      {
1745                        echo "\n   <span class=\"gamestatuspre\"><a href=\"".$host."?me=".$r[0]."\">p </a></span> ";
1746
1747                      }
1748                    else if ($r[4]=='gameover')
1749                      echo "\n   <span class=\"gamestatusover\"><a href=\"".$host."?me=".$r[0]."\">F </a></span> ";
1750                    else
1751                      {
1752                        echo "\n   <span class=\"gamestatusplay\"><a href=\"".$host."?me=".$r[0]."\">P </a></span> ";
1753                      }
1754                    if($r[4] != 'gameover')
1755                      {
1756                        echo "</td><td>\n    ";
1757                        if($r[3])
1758                          {
1759                            if($r[3]==$myid)
1760                              echo "(it's <strong>your</strong> turn)\n";
1761                            else
1762                              {
1763                                $name = DB_get_name_by_userid($r[3]);
1764                                echo "(it's $name's turn)\n";
1765                              };
1766                          }
1767                        if(time()-strtotime($r[2]) > 60*60*24*30)
1768                          echo " The game has been running for over a month.".
1769                            " Do you want to cancel it? <a href=\"$host?cancle=1&amp;me=".$r[0]."\">yes</a>".
1770                            " (clicking here is final and can't be restored)";
1771
1772                      }
1773                  }
1774                echo "</td></tr>\n</table>\n";
1775                $names = DB_get_all_names();
1776                echo "<h4>Registered players:</h4>\n<p>\n";
1777                echo implode(", ",$names)."\n";
1778                echo "</p>\n";
1779              }
1780          }
1781        else
1782          {
1783            echo "Sorry email and password don't match. Please <a href=\"$host\">try again</a>. <br />";
1784          }
1785      };
1786      output_footer();
1787      DB_close();
1788      exit();
1789    }
1790 /* default login page */
1791  else
1792    { 
1793      $pre[0]=0;$game[0]=0;$done[0]=0;
1794      $r=mysql_query("SELECT COUNT(id) FROM Game GROUP BY status");
1795      if($r) {
1796        $pre  = mysql_fetch_array($r,MYSQL_NUM);     
1797        $game = mysql_fetch_array($r,MYSQL_NUM);     
1798        $done = mysql_fetch_array($r,MYSQL_NUM);     
1799      }
1800
1801      $r=mysql_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' ");
1802      if($r)
1803        $avgage= mysql_fetch_array($r,MYSQL_NUM);     
1804      else
1805        $avgage[0]=0;
1806
1807      output_home_page($pre[0],$game[0],$done[0],$avgage[0]);
1808    }
1809
1810 output_footer();
1811
1812 DB_close();
1813
1814 /*
1815  *Local Variables: 
1816  *mode: php
1817  *mode: hs-minor
1818  *End:
1819  */
1820 ?>
1821
1822