{
				echo $MSG_LANG["black"];
				$tmpFrom = "black";
				$ratingL = $tmpGame['ratingWhite'];
				$ratingW = $tmpGame['ratingBlack'];
			}

            if ($tmpGame['oficial'] == "1")
                $oficial = $MSG_LANG["official"];
            else $oficial = $MSG_LANG["notofficial"];

            echo "<td>".$oficial."</td>";

            if ($tmpGame['oficial'] == "1"){
               $xpw = getXPW($ratingW,$ratingL,getPV($id));
               $xpl = getXPL($ratingL,$ratingW,getPV($id));
            }else{
                $xpl=0;
                $xpw=0;
            }

			$dificuldade = getDifficult($_SESSION['playerID'],$id);
			
            echo "<td>$dificuldade</td>\n";
			echo "<td><i>+$xpw / -$xpl</i></td>\n";

            /* Response */
			echo ("</td><td align='center'>");
			echo ("<input type='button' value='".$MSG_LANG["accept"]."' onclick=\"sendResponse('accepted', '".$tmpFrom."', ".$tmpGame['gameID'].")\">");
			echo ("<input type='button' value='".$MSG_LANG["reject"]."' onclick=\"sendResponse('declined', '".$tmpFrom."', ".$tmpGame['gameID'].")\">");
function create_games($id) {

global $_SESSION;

$t = mysql_query("SELECT * FROM tournaments WHERE id = '$id'");
$t = mysql_fetch_array($t);

if ($t['players'] == 4)
{

$games = array(
          1 => array('whitePlayer' => $t['player1'], 'blackPlayer' => $t['player2']),
          2 => array('whitePlayer' => $t['player1'], 'blackPlayer' => $t['player3']),
          3 => array('whitePlayer' => $t['player1'], 'blackPlayer' => $t['player4']),

          4 => array('whitePlayer' => $t['player2'], 'blackPlayer' => $t['player1']),
          5 => array('whitePlayer' => $t['player2'], 'blackPlayer' => $t['player3']),
          6 => array('whitePlayer' => $t['player2'], 'blackPlayer' => $t['player4']),

          7 => array('whitePlayer' => $t['player3'], 'blackPlayer' => $t['player1']),
          8 => array('whitePlayer' => $t['player3'], 'blackPlayer' => $t['player2']),
          9 => array('whitePlayer' => $t['player3'], 'blackPlayer' => $t['player4']),

         10 => array('whitePlayer' => $t['player4'], 'blackPlayer' => $t['player1']),
         11 => array('whitePlayer' => $t['player4'], 'blackPlayer' => $t['player2']),
         12 => array('whitePlayer' => $t['player4'], 'blackPlayer' => $t['player3']));

         while (list($key, $val) = each($games))
         {

                 $query = "INSERT INTO {$db_prefix}games (timelimit, gameMessage,messageFrom, whitePlayer, blackPlayer, dateCreated,
                 lastMove, ratingWhite, ratingBlack,ratingWhiteM,ratingBlackM,PVBlack,PVWhite,tournament,oficial,thematic)
                 VALUES (";

                 $white = $games[$key]['whitePlayer'];
        $black = $games[$key]['blackPlayer'];

                 $query .= "".$t['days'].", '', '', $white, $black, NOW(), NOW(),".getRating($white).",".getRating($black).",".getRatingMonth($white).",".getRatingMonth($black).",".getPV($black).",".getPV($white).", '$id', '".$t['official']."','".$t['thematic']."')";

                 mysql_query($query);

                 echo mysql_error();

         } // while

         $query = mysql_query("SELECT game_id FROM {$db_prefix}games WHERE tournament = '$id'");

    while ($g = mysql_fetch_array($query))
    {
                 if (!function_exists('createNewGame'))
                 {
                    include 'newgame.php';
                 }

                 $_SESSION['gameID'] = $g['gameID'];
        createNewGame($_SESSION['gameID']);
        saveGame();

         } // while

} // 4 players

}
     }
     break;
 case 'responseToInvite':
     if ($_POST['response'] == 'accepted') {
         /* update game data */
         $playb = mysql_query("SELECT * FROM games WHERE gameID='" . $_POST['gameID'] . "'");
         $bl = mysql_fetch_array($playb);
         if ($bl['whitePlayer'] == "0") {
             $white = $_SESSION['playerID'];
             $black = $bl['blackPlayer'];
             $tmpQuery = "UPDATE games SET ratingWhite = " . getRating($white) . ", ratingBlack = " . getRating($black) . ", ratingWhiteM = " . getRatingMonth($white) . ", ratingBlackM = " . getRatingMonth($black) . ", PVWhite = " . getPV($white) . ", PVBlack = " . getPV($black) . ", gameMessage = '', messageFrom = '', whitePlayer = '" . $_SESSION['playerID'] . "' WHERE gameID = " . $_POST['gameID'];
             mysql_query($tmpQuery);
         } elseif ($bl['blackPlayer'] == "0") {
             $white = $bl['whitePlayer'];
             $black = $_SESSION['playerID'];
             $tmpQuery = "UPDATE games SET ratingWhite = " . getRating($white) . ", ratingBlack = " . getRating($black) . ", ratingWhiteM = " . getRatingMonth($white) . ", ratingBlackM = " . getRatingMonth($black) . ", PVWhite = " . getPV($white) . ", PVBlack = " . getPV($black) . ", gameMessage = '', messageFrom = '', blackPlayer = '" . $_SESSION['playerID'] . "' WHERE gameID = " . $_POST['gameID'];
             mysql_query($tmpQuery);
         } else {
         }
         /* setup new board */
         $_SESSION['gameID'] = $_POST['gameID'];
         createNewGame($_POST['gameID']);
         saveGame();
     } else {
         $tmpQuery = "UPDATE games SET gameMessage = 'inviteDeclined', messageFrom = '" . $_POST['messageFrom'] . "' WHERE gameID = " . $_POST['gameID'];
         mysql_query($tmpQuery);
     }
     break;
 case 'WithdrawRequest':
     /* get opponent's player ID */
     $tmpOpponentID = mysql_query("SELECT whitePlayer FROM games WHERE gameID = " . $_POST['gameID']);
    $pvs[] = "0";
    $datas[] = "";
    $pvs[] = "0";
} else {
    while ($row = mysql_fetch_array($rs)) {
        $rail[] = 100;
        $c = explode(":", $row[criado]);
        $datas[] = $c[0];
        if ($row[whitePlayer] == $playerID) {
            $pvs[] = $row[PVWhite];
        } else {
            $pvs[] = $row[PVBlack];
        }
    }
}
$pvs[] = getPV($playerID);
$datas[] = date("b d");
$total = count($pvs);
$graph = new Graph(400, 160, "auto");
//$graph->SetShadow();
$graph->SetScale("textlin", 0, 100);
$graph->title->Set("% Victories Evolution");
//$graph->subtitle->Set("aa");
$graph->title->SetFont(FF_FONT1, FS_BOLD);
$graph->xaxis->SetFont(FF_FONT1, FS_NORMAL, 5);
$graph->yaxis->SetFont(FF_FONT1, FS_NORMAL, 5);
//$graph->xaxis->SetLabelAngle(45);
$graph->img->SetMargin(40, 15, 20, 30);
$graph->xaxis->SetTextTickInterval(ceil($total / 5));
//$graph->xaxis->SetTextLabelInterval(floor($total/4));
$graph->xaxis->SetTickLabels($datas);
/css/page-message.css?<?php 
echo date('YmdHis');
?>
" />
<script type="text/javascript" src="<?php 
echo get_stylesheet_directory_uri();
?>
/js/page-message.js?<?php 
echo date('YmdHis');
?>
"></script>
<script>
</script>
</head>
<body class="<?php 
echo getPV("meimei_lang_class");
?>
">
<p class="thumbnail"><?php 
the_post_thumbnail();
?>
</p>
<header class="entry-header"><h2 id="headerTitle" class="entry-title"><span class="orange nowrap"><?php 
echo getXmlMsg('meimeiTitleSakaiMei');
?>
</span> <span class="yellow nowrap"><?php 
echo getXmlMsg('meimeiTitleForm');
?>
</span></h2>
</header><!-- .entry-header -->
<article class="main">
function create_match_games($match_id){
   //load up all signed up players and arrange in order
   $tmp_teams = mysql_query("SELECT * FROM matches WHERE match_id = '$match_id'");
   $teams = db_result_to_array($tmp_teams);
   $team1 = $teams[0][1];
   $team2 = $teams[0][2];
   $boards = $teams[0][6];
   //load up player IDs for team 1
   $tmp_players = mysql_query("SELECT playerID FROM match_players WHERE match_id = '$match_id' AND teamID = '$team1'");
   $team1_players = db_result_to_array($tmp_players);
   for ($i=0;$i<$boards;$i++){
      $tmp_player_info = mysql_query("SELECT rating FROM {$db_prefix}players WHERE playerID = ".$team1_players[$i][0]);
      $tmp_rating = mysql_fetch_array($tmp_player_info);
      $rating=$tmp_rating[0];
      $team1_players[$i][1] = $rating;
#      echo "Player team 1, player $i: ".$team1_players[$i][0]." rating = ".$team1_players[$i][1]."<br>";
   }
   usort ($team1_players, 'compare');//sort in rank order

   //load up player IDs for team 2
   $tmp_players = mysql_query("SELECT playerID FROM match_players WHERE match_id = '$match_id' AND teamID = '$team2'");
   $team2_players = db_result_to_array($tmp_players);
   for ($i=0;$i<$boards;$i++){
      $tmp_player_info = mysql_query("SELECT rating FROM {$db_prefix}players WHERE playerID = ".$team2_players[$i][0]);
      $tmp_rating = mysql_fetch_array($tmp_player_info);
      $rating=$tmp_rating[0];
      $team2_players[$i][1] = $rating;
#      echo "Player team 2, player $i: ".$team2_players[$i][0]." rating = ".$team2_players[$i][1]."<br>";
   }
   usort ($team2_players, 'compare');//sort in rank order

   //debug line
#   echo "<br>".$team1_players[0][0]." : ".$team1_players[0][1]."<br>".$team1_players[1][0]." : ".$team1_players[1][1]."<br>".$team2_players[0][0]." : ".$team2_players[0][1]."<br>".$team2_players[1][0]." : ".$team2_players[1][1];


//for each pair, create first game
$tmpColor = 'white';//set first team 1 player to white
for ($i=0;$i<$boards;$i++){
   $tmpQuery = "INSERT INTO {$db_prefix}games (white_player, black_player, status, message_from, dateCreated, lastMove, ratingWhite, ratingBlack, ratingWhiteM, ratingBlackM, oficial, PVBlack, PVWhite, timelimit, teamMatch, team) VALUES (";
   if ($tmpColor == 'white'){
      $white = $team1_players[$i][0];
      $black = $team2_players[$i][0];
      $tmpColor = 'black';
   }else{
      $white = $team2_players[$i][0];
        $black = $team1_players[$i][0];
        $tmpColor = 'white';
    }
   $tmpQuery .= "$white, $black, '', '', NOW(), NOW(),".getRating($white).",".getRating($black).",".getRatingMonth($white).",".getRatingMonth($black).",'1',".getPV($black).",".getPV($white).",".getMatchTimeLimit($match_id).",'1',$match_id)";
   mysql_query($tmpQuery);

   /* if email notification is activated... */
#   if ($CFG_USEEMAILNOTIFICATION){
#      /* if opponent is using email notification... */
#      $tmpOpponentEmail = mysql_query("SELECT value FROM ch_preferences WHERE playerID = ".$_POST['opponent']." AND preference = 'emailNotification'");
#      if (mysql_num_rows($tmpOpponentEmail) > 0){
#         $opponentEmail = mysql_result($tmpOpponentEmail, 0);
#         if ($opponentEmail != ''){
#            /* notify opponent of invitation via email */
#            webchessMail('invitation', $opponentEmail, '', $_SESSION['nick']);
#         }
#      }
#   }

   // setup new board
   $game_id = mysql_insert_id();//   get ID of new game
   $_SESSION['game_id'] = $game_id;
   createNewGame($game_id);
   saveGame();
}
//for each pair, create second game
$tmpColor = 'black';//set first team 1 player to white
for ($i=0;$i<$boards;$i++){
   $tmpQuery = "INSERT INTO {$db_prefix}games (white_player, black_player, status, message_from, dateCreated, lastMove, ratingWhite, ratingBlack, ratingWhiteM, ratingBlackM, oficial, PVBlack, PVWhite, timelimit, teamMatch, team) VALUES (";
   if ($tmpColor == 'black'){
      $black = $team1_players[$i][0];
      $white = $team2_players[$i][0];
      $tmpColor = 'white';
   }else{
      $black = $team2_players[$i][0];
        $white = $team1_players[$i][0];
        $tmpColor = 'black';
    }
    $tmpQuery .= "$white, $black, '', '', NOW(), NOW(),".getRating($white).",".getRating($black).",".getRatingMonth($white).",".getRatingMonth($black).",'1',".getPV($black).",".getPV($white).",".getMatchTimeLimit($match_id).",'1',$match_id)";
   mysql_query($tmpQuery);

   /* if email notification is activated... */
#   if ($CFG_USEEMAILNOTIFICATION){
#      /* if opponent is using email notification... */
#      $tmpOpponentEmail = mysql_query("SELECT value FROM ch_preferences WHERE playerID = ".$_POST['opponent']." AND preference = 'emailNotification'");
#      if (mysql_num_rows($tmpOpponentEmail) > 0){
#         $opponentEmail = mysql_result($tmpOpponentEmail, 0);
#         if ($opponentEmail != ''){
#            /* notify opponent of invitation via email */
#            webchessMail('invitation', $opponentEmail, '', $_SESSION['nick']);
#         }
#      }
#   }

   // setup new board
   $game_id = mysql_insert_id();//   get ID of new game
   $_SESSION['game_id'] = $game_id;
   createNewGame($game_id);
   saveGame();
}
  //update match table
   mysql_query("UPDATE matches SET status = '' WHERE match_id = '$match_id'");
}
                    init_srand();

                if ($_POST['color'] == 'random')
                    $tmpColor = (rand(0,1) == 1) ? "white" : "black";
                else
                    $tmpColor = $_POST['color'];

                $tmpQuery = "INSERT INTO games (timelimit, whitePlayer, blackPlayer, gameMessage, messageFrom, dateCreated, lastMove, ratingWhite, ratingBlack,ratingWhiteM, ratingBlackM,oficial,PVBlack,PVWhite,thematic) VALUES (";
                if ($tmpColor == 'white'){
                    $white = $_SESSION['playerID'];
                    $black = $_POST['opponent'];
                }else{
                    $white = $_POST['opponent'];
                    $black = $_SESSION['playerID'];
                }
                $tmpQuery .= "$_POST[timelimit], $white, $black, 'playerInvited', '".$tmpColor."', NOW(), NOW(),".getRating($white).",".getRating($black).",".getRatingMonth($white).",".getRatingMonth($black).",'".$_POST['oficial']."',".getPV($black).",".getPV($white).",'".$_POST['thematic']."')";
                mysql_query($tmpQuery);

                /* if email notification is activated... */
                if ($CFG_USEEMAILNOTIFICATION)
                {
                    /* if opponent is using email notification... */
                    $tmpOpponentEmail = mysql_query("SELECT value FROM preferences WHERE playerID = ".$_POST['opponent']." AND preference = 'emailNotification'");
                    if (mysql_num_rows($tmpOpponentEmail) > 0)
                    {
                        $opponentEmail = mysql_result($tmpOpponentEmail, 0);
                        if ($opponentEmail != '')
                        {
                            /* notify opponent of invitation via email */
                            webchessMail('invitation', $opponentEmail, '', $_SESSION['firstName']);
                        }
		elseif (getRating($row['playerID']) == 0 && !$isme)
 			{
			echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["challengethisplayer"]."</td><td style='text-align:left'><input type='button' style='font-size:11' value='$MSG_LANG[challengethisplayer]' onClick=\"javascript:newuserchallenge(".$row['playerID'].")\">                 </td></td></tr>";				
            }				
		elseif (!$isme)
			{
			echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["challengethisplayer"]."</td><td style='text-align:left'><input type='button' style='font-size:11' value='$MSG_LANG[challengethisplayer]' onClick=\"javascript:challenge(".$row['playerID'].")\">                 </td></td></tr>";
			}
		echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["level"]."</td><td style='text-align:left'>".$nivel."</td></tr>";
		echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["rating"]."/".$MSG_LANG["max"]."</td><td style='text-align:left'>$row[rating]/$row[rating_max] (<B>".$MSG_LANG["nextlevel"].":</b> ".getXPmax($nivel).")</td></tr>";

        if (!$isme){

            $xpw = getXPW(getRating($_SESSION['playerID']),$row['rating'],getPV($_SESSION['playerID']));
            $xpl = getXPL($row['rating'],getRating($_SESSION['playerID']),getPV($_GET['cod']));

            echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["challengerate"]."</td><td style='text-align:left'>$dificuldade (<i>".$MSG_LANG["ifwin"].": +$xpw ".$MSG_LANG["iflose"].": -$xpl</i>)</td></tr>";
			echo "<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["lastseen"]."</td><td style='text-align:left' width=50%>".date("d/m/y H:i",$row[lastUpdate])."</td></tr>";
        }
		echo "<tr><td nowrap width='20%' style='text-align:left'><B>".$MSG_LANG["finishedgames"]."</td><td style='text-align:left'>$total</td></tr>
		<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["victories"]."</td><td style='text-align:left'>$vitorias ($PV%)</td></tr>
		<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["defeats"]."</td><td style='text-align:left'>$derrotas</td></tr>
		<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["draw"]."</td><td style='text-align:left'>$empates</td></tr>
		<tr><td width='20%' style='text-align:left'><B>".$MSG_LANG["activegames"]."</td><td style='text-align:left'><a href=games_user.php?cod=$player>$ativos games</a></td></tr>";
		if (mysql_num_rows($t2) >0)
		echo "<tr><td width='20%' style='text-align:left'><B>TEAM</td><td style='text-align:left'><a href='stats_team.php?cod=".$rt[fk_team]."'><b>".$teamName."</b></a></td></tr><br>";
		else 		
		echo "<tr><td width='20%' style='text-align:left'><B>TEAM</td><td style='text-align:left'><a href='teams.php'><b>".$MSG_LANG['chooseateamtojoin']."</b></a></td></tr><br>";