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