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( $GAME["schweinchen"] && ($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($GAME["schweinchen"] && ($card == 19 || $card == 20) )
1234                 {
1235                   $GAME["schweinchen"]++; // count how many have been played including this one
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