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