+ 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')");
+ }
+
+ for( $p=$call_re; $p<120; $p+=30)
+ {
+ if( $contra>=$p )
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'made$p')");
+ }
+ }
+
+ /* point in case contra won */
+ if($winning_party=="contra")
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
+ }
+
+ /* 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;
+
+ if($re>$p-$offset)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')");
+ }
+ /* re called something and won */
+ foreach(array(0,30,60,90,120) as $p)
+ {
+ 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;
+
+ 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')");
+ }
+ }
+
+
+ /* 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";
+
+ $session = DB_get_session_by_gameid($gameid);
+ $score = generate_score_table($session);
+ /* convert html to ascii */
+ $score = str_replace("<div class=\"scoretable\">\n<table class=\"score\">\n <tr>\n","",$score);
+ $score = str_replace("</table></div>\n","",$score);
+ $score = str_replace("\n","",$score);
+ $score = str_replace(array("<tr>","</tr>","<td>","</td>"),array("","\n","","|"),$score);
+ $score = explode("\n",$score);
+
+ $header = array_slice($score,0,1);
+ $header = explode("|",$header[0]);
+ for($i=0;$i<sizeof($header);$i++)
+ $header[$i]=str_pad($header[$i],6," ",STR_PAD_BOTH);
+ $header = implode("|",$header);
+ $header.= "\n------+------+------+------+------+\n";
+ if(sizeof($score)>5) $header.= " ... \n";
+
+ if(sizeof($score)>5) $score = array_slice($score,-5,5);
+ for($i=0;$i<sizeof($score);$i++)
+ {
+ $line = explode("|",$score[$i]);
+ for($j=0;$j<sizeof($line);$j++)
+ $line[$j]=str_pad($line[$j],6," ",STR_PAD_LEFT);
+ $score[$i] = implode("|",$line);
+ }
+
+ $score = implode("\n",$score);
+ $score = $header.$score;