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