\n";
+ $show = 1;
+ for($mypos=1;$mypos<5;$mypos++)
+ {
+ $usersick = DB_get_sickness_by_pos_and_gameid($mypos,$gameid);
+ if($usersick!=NULL)
+ {
+ echo "
\n Vorbehalt
"; + if($show) + echo " $usersick
"; + echo "
\n";
+
+ if($mygametype == $usersick)
+ $show = 0;
+ }
+ }
+ echo " "; + if($show) + echo " $usersick
"; + echo "
![\"table\"](\"pics/arrow".($pos-1).".png\")
\n";
}
- echo "";
+ echo "
\n";
+ echo "\n ".$comment."\n";
+ echo " \n";
/*check if we still have cards left, else set status to gameover */
if(sizeof(DB_get_hand($me))==0)
@@ -1440,8 +1473,9 @@ else if(myisset("me"))
$message = "A card has been played in game ".DB_format_gameid($gameid).".\n\n".
"It's your turn now.\n".
- "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
- mymail($email,$EmailName."a card has been played in game ".DB_format_gameid($gameid),$message);
+ "Use this link to play a card: ".$HOST.$INDEX."?me=".$next_hash."\n\n" ;
+ if( DB_get_email_pref_by_uid($who)!="emailaddict" )
+ mymail($email,$EmailName."a card has been played in game ".DB_format_gameid($gameid),$message);
}
else /* send out final email */
{
@@ -1478,8 +1512,13 @@ else if(myisset("me"))
else if($r[0] == "contra")
$contra = $r[1];
}
- /* save score in database */
- // get calls from re/contra
+
+ /*
+ * save score in database
+ *
+ */
+
+ /* get calls from re/contra */
$call_re = NULL;
$call_contra = NULL;
foreach($userids as $user)
@@ -1508,85 +1547,150 @@ else if(myisset("me"))
}
}
}
- // no call, check 120:120
- if($call_re == NULL && $call_contra==NULL)
- if($re==120)
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
- // no call or one call do scoring
- if($call_re != NULL && $call_contra!=NULL)
- {
- // two calls: not sure what to do yet
- }
+ /* figure out who one */
+ $winning_party = NULL;
+
+ if($call_re == NULL && $call_contra==NULL)
+ if($re>120)
+ $winning_party="re";
+ else
+ $winning_party="contra";
else
{
- $offset = 0;
+ if($call_re)
+ {
+ $offset = 120 - $call_re;
+ if($call_re == 0)
+ $offset--; /* since we use a > in the next equation */
+
+ if($re > 120+$offset)
+ $winning_party="re";
+ else if ( $call_contra == NULL )
+ $winning_party="contra";
+ }
- if($call_re!=NULL)
- $offset = 120 - $call_re;
- else if($call_contra!=NULL)
- $offset = -1*(120 - $call_contra)-1;
+ if($call_contra)
+ {
+ $offset = 120 - $call_contra;
+ if($call_contra == 0)
+ $offset--; /* since we use a > in the next equation */
+
+ if($contra > 120+$offset)
+ $winning_party="contra";
+ else if ( $call_contra == NULL )
+ $winning_party="re";
+ }
+ }
- if($call_re==0)
- $offset -= 1;
+ /* one point for each call of the other party in case the other party didn't win
+ * and one point each in case the party made more than points than one of the calls
+ */
+ if($winning_party!="contra" && $call_contra!=NULL)
+ {
+ for( $p=$call_contra;$p<=120; $p+=30 )
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'against$p')");
+ }
- if($call_contra==0)
- $offset += 1;
+ for( $p=$call_contra; $p<120; $p+=30)
+ {
+ if( $re >= $p )
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'made$p')");
+ }
+ }
+ if($winning_party!="re" and $call_re!=NULL)
+ {
+ for( $p=$call_re;$p<=120; $p+=30 )
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'against$p')");
+ }
- if($re > 120 + $offset)
+ for( $p=$call_re; $p<120; $p+=30)
{
- /* re won */
+ if( $contra>=$p )
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'made$p')");
+ }
+ }
- /* normal win */
- foreach(array(120,150,180,210,240) as $p)
- {
- $offset = 0;
- if($p==240)
- $offset = 1;
+ /* point in case contra won */
+ if($winning_party=="contra")
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
+ }
- if($re>$p-$offset)
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')");
- }
+ /* one point each for winning and each 30 points + calls */
+ if($winning_party=="re")
+ {
+ foreach(array(120,150,180,210,240) as $p)
+ {
+ $offset = 0;
+ if($p==240 || $call_contra!=NULL)
+ $offset = 1;
- /* re called something and won */
- if($call_re!=NULL)
- foreach(array(0,30,60,90,120) as $p)
- {
- if($call_re<$p+1)
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'call$p')");
- }
+ if($re>$p-$offset)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')");
}
- else
+ /* re called something and won */
+ foreach(array(0,30,60,90,120) as $p)
{
- /* contra won */
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
+ if($call_re!=NULL && $call_re<$p+1)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'call$p')");
+ }
+ }
+ else if( $winning_party=="contra")
+ {
+ foreach(array(120,150,180,210,240) as $p)
+ {
+ $offset = 0;
+ if($p==240 || $call_re!=NULL)
+ $offset = 1;
- /* normal win */
- foreach(array(120,150,180,210,240) as $p)
- {
- $offset = 0;
- if($p==240)
- $offset = 1;
+ if($contra>$p-$offset)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'".(240-$p)."')");
+ }
+ /* re called something and won */
+ foreach(array(0,30,60,90,120) as $p)
+ {
+ if($call_contra!=NULL && $call_contra<$p+1)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'call$p')");
+ }
+ }
- if($re>$p-$offset)
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'".(240-$p)."')");
- }
- /* contra called something and won */
- if($call_contra!=NULL)
- foreach(array(0,30,60,90,120) as $p)
- {
- if($call_contra<$p+1)
- mysql_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'call$p')");
- }
- }
+ /* add score points to email */
+ $message .= "\n";
+ $Tpoint = 0;
+ $message .= " Points Re: \n";
+ $queryresult = mysql_query("SELECT score FROM Score ".
+ " WHERE game_id=$gameid AND party='re'".
+ " ");
+ while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+ {
+ $message .= " ".$r[0]."\n";
+ $Tpoint ++;
+ }
+ $message .= " Points Contra: \n";
+ $queryresult = mysql_query("SELECT score FROM Score ".
+ " WHERE game_id=$gameid AND party='contra'".
+ " ");
+ while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+ {
+ $message .= " ".$r[0]."\n";
+ $Tpoint --;
}
+ $message .= " Total Points (from the Re point of view): $Tpoint\n";
+ $message .= "\n";
+
/* send out final email */
$all = array();
@@ -1602,8 +1706,10 @@ else if(myisset("me"))
$To = DB_get_email_by_userid($user);
$hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
- $link = "Use this link to have a look at game ".DB_format_gameid($gameid).": ".$host."?me=".$hash."\n\n" ;
- mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 2(2)",$link);
+ $link = "Use this link to have a look at game ".DB_format_gameid($gameid).": ".
+ $HOST.$INDEX."?me=".$hash."\n\n" ;
+ if( DB_get_email_pref_by_uid($user) != "emailaddict" )
+ mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 2(2)",$link);
}
}
}
@@ -1638,7 +1744,7 @@ else if(myisset("me"))
" GROUP BY User.fullname" );
while( $r = mysql_fetch_array($result,MYSQL_NUM))
echo " \n ";
/* display comments */
display_card($card,$PREF["cardset"]);
if($comment!="")
- echo " ".$comment."\n";
- echo "
\n".
- " ".$r[2]."
".$r[1]."\n". + "
\n";
echo " \n \n"; /* end div trick, end li trick */
@@ -1711,7 +1817,7 @@ else if(myisset("me"))
/* check if game is over, display results */
if(DB_get_game_status_by_gameid($gameid)=='play')
{
- echo "the game is over for you.. other people still need to play though";
+ echo "The game is over for you.. other people still need to play though";
}
else
{
@@ -1726,8 +1832,26 @@ else if(myisset("me"))
echo "".$r[1]."\n". + "
".$r[2]."
".$r[1]."
\n".
" ".$r[1]."
Totals:
\n"; while( $r = mysql_fetch_array($result,MYSQL_NUM)) echo " ".$r[0]." ".$r[1]."
\n"; + + echo "
\n";
+
+
}
break;
default:
@@ -1844,7 +1968,7 @@ else if( myisset("email","password") || isset($_SESSION["name"]) )
echo "N.B. You tried this already $number times during the last day and it will only work ".
" 5 times during a day.\n"; while( $r = mysql_fetch_array($result,MYSQL_NUM)) echo " ".$r[0]." ".$r[1]."
\n"; + + echo "
\n Points Re:
\n"; + $queryresult = mysql_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='re'". + " "); + while($r = mysql_fetch_array($queryresult,MYSQL_NUM) ) + echo " ".$r[0]."
\n"; echo "
\n";
+ echo "\n"; + $queryresult = mysql_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='re'". + " "); + while($r = mysql_fetch_array($queryresult,MYSQL_NUM) ) + echo " ".$r[0]."
\n"; echo "
\n Points Contra:
\n"; + $queryresult = mysql_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='contra'". + " "); + while($r = mysql_fetch_array($queryresult,MYSQL_NUM) ) + echo " ".$r[0]."
\n"; + echo "
\n";
+
+ echo "\n"; + $queryresult = mysql_query("SELECT score FROM Score ". + " WHERE game_id=$gameid AND party='contra'". + " "); + while($r = mysql_fetch_array($queryresult,MYSQL_NUM) ) + echo " ".$r[0]."
\n"; + echo "
"; echo "The new password will be valid for one day, make sure you reset it to something else.
"; - echo "Back to the main page."; + echo "Back to the main page."; $TIME = (string) time(); /* to avoid collisions */ $hash = md5("Anewpassword".$email.$TIME); @@ -1864,18 +1988,18 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) { echo "Sorry you already tried 5 times during the last 24h.
". "You need to use one of those passwords or wait to get a new one.
"; - echo "Back to the main page."; + echo "Back to the main page."; } } else { if($email=="") echo "You need to give me an email address!
". - "Please try again."; + "Please try again."; else echo "Couldn't find a player with this email!
". "Please contact Arun, if you think this is a mistake
". - "or else try again."; + "or else try again."; } } else @@ -1891,6 +2015,10 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) if($ok) { + $myname = DB_get_name_by_email($email); + $_SESSION["name"] = $myname; + output_status(); + DB_get_PREF($myid); if(myisset("setpref")) @@ -1910,6 +2038,18 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) DB_quote_smart($setpref).")"); echo "Ok, changed you preferences for the cards.\n"; break; + case "emailaddict": + case "emailnonaddict": + $result = mysql_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='email'" ); + if( mysql_fetch_array($result,MYSQL_NUM)) + $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref). + " WHERE user_id='$myid' AND pref_key='email'" ); + else + $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','email',". + DB_quote_smart($setpref).")"); + echo "Ok, changed you preferences for sending out emails.\n"; + break; } } else if(myisset("passwd")) @@ -1951,24 +2091,9 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) } else /* output default user page */ { - $time = DB_get_user_timestamp($myid); - $unixtime = strtotime($time); - - $offset = DB_get_user_timezone($myid); - $zone = return_timezone($offset); - date_default_timezone_set($zone); - - $myname = DB_get_name_by_email($email); - $_SESSION["name"] = $myname; - - if(isset($_SESSION["name"])) - output_status($_SESSION["name"]); - /* display links to settings */ output_user_settings(); - echo "
last login: ".date("r",$unixtime)."
";
-
DB_update_user_timestamp($myid);
display_user_menu();
@@ -2002,14 +2127,14 @@ else if( myisset("email","password") || isset($_SESSION["name"]) )
}
if($r[4]=='pre')
{
- echo "\n p ";
+ echo "\n p ";
}
else if ($r[4]=='gameover')
- echo "\n F ";
+ echo "\n F ";
else
{
- echo "\n P ";
+ echo "\n P ";
}
if($r[4] != 'gameover')
{
@@ -2025,13 +2150,13 @@ else if( myisset("email","password") || isset($_SESSION["name"]) )
if(DB_get_reminder($r[3],$gameid)==0)
if(time()-strtotime($r[2]) > 60*60*24*7)
echo "".
- "Send a reminder.";
+ "Send a reminder.";
echo "(it's $name's turn)\n";
};
}
if(time()-strtotime($r[2]) > 60*60*24*30)
echo "".
- "Cancel?".
+ "Cancel?".
" (clicking here is final and can't be restored)";
}
@@ -2045,7 +2170,7 @@ else if( myisset("email","password") || isset($_SESSION["name"]) )
}
else
{
- echo "Sorry email and password don't match. Please try again. "; + echo ""; } }; output_footer();