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