Bouton "Rappel" ne fonctionne plus. [Résolu/Fermé]

function wakeUp( )
{
	if (confirm('Confirmez le mail de rappel.'))
	{
		document.wakeup.submit( );
	}
}

<form name="wakeup" id="wakeup" method="post" action="chess.php" style="display:inline;">
				<?php
					// test for opponents email, and if none, disable the wake up button
					$temp = ('' == $_SESSION['opponent']['p_email']) ? ' disabled="disabled"' : ''; // check the var and disable if no email is found
				?>
				<input type="button" id="btnWakeUp" value="Rappel" onclick="wakeUp( );"<?php echo $temp; ?> />
				<input type="hidden" name="wakeID" value="<?php echo $_SESSION['game_id']; ?>" /><a href="#" class="help" onclick="window.open('./help/wakeup.html','help','resizable,scrollbars,width=550,height=500,top=50,left=50','_blank');return false;">?</a>
			</form>

if ( isset($_POST['wakeID']) && $_SESSION['game_id'] == $_POST['wakeID'] )
{
	call("webchessMail('wakeup',{$_SESSION['opponent']['p_email']},'',{$_SESSION['username']},{$_SESSION['game_id']})");
	$wake_up_sent = webchessMail('wakeup',$_SESSION['opponent']['p_email'],'',$_SESSION['username'],$_SESSION['game_id']);
}

<?php
// get required scripts
require_once 'config.inc.php';

function webchessMail($type, $msgTo, $move, $opponent, $game_id)
{
	global $CFG_MAILADDRESS, $CFG_MAINPAGE, $CFG_USEEMAIL;

	// make sure we can use email
	if ( ! $CFG_USEEMAIL)
	{
		return false;
	}

	// make sure there's an email address given
	if ('' == $msgTo && ! DEBUG)
	{
		return false;
	}
//header('Content-Type: text/html;charset=iso-8859-1');
//header('Content-Type: text/html;charset= utf-8’);
//header('Content-Type: text/html;charset=iso-8859-1');
	// default subject header prefix
	$subject = 'CheckMat: ';

	// load specific message and subject
	switch($type)
	{
		case 'test':
			$subject .= 'Test Message';
			$message = "Félicitations !!\n"
							 . "Si vous voyez ce message, c'est que vous avez réglé avec succès votre notification par email !\n"
							 . "Maintenant, allez à {$CFG_MAINPAGE} pour jouer aux échecs !\n";
			break;
//------------------------------------------------------------------------------
		case 'invitation':
			$subject .= "{$opponent} vous a invité à jouer une nouvelle partie";
			$message = $opponent." vous a invité à jouer une nouvelle partie.\n"
							 . "Allez à {$CFG_MAINPAGE} pour accepter ou décliner cette invitation.\n";
			break;
//------------------------------------------------------------------------------
		case 'withdrawal':
			$subject .= 'Invitation annulée';
			$message = "Votre adversaire, {$opponent} a annulé son invitation à jouer une nouvelle partie.\n"
							 . "Allez à {$CFG_MAINPAGE} pour inviter un joueur, ou poursuivre une partie.\n";
			break;
//------------------------------------------------------------------------------
		case 'resignation':
			$subject .= "{$opponent} a abandonné la partie {$game_id}.";
			$message = "Votre adversaire, {$opponent} a abandonné la partie {$game_id}.\n\n"
							 . "Allez à {$CFG_MAINPAGE} pour commencer une nouvelle partie.\n";
			break;
//------------------------------------------------------------------------------
		case 'move':
			$subject .= "{$opponent} a joué {$move} dans la partie {$game_id}.";
			$message = "Votre adversaire, {$opponent} a joué le coup :\n"
							 . "{$move}\n\n"
							 . "C'est à vous de jouer\n"
							 . "Allez à {$CFG_MAINPAGE} pour jouer.\n";
			break;
//------------------------------------------------------------------------------
		case 'accepted':
			$subject .= 'Invitation acceptée';
			$message = $opponent." a accepté votre invitation à jouer une nouvelle partie.\n"
							 . "Allez à {$CFG_MAINPAGE} pour jouer.\n";
			break;
//------------------------------------------------------------------------------
		case 'declined':
			$subject .= 'Invitation déclinée';
			$message = $opponent." a decliné votre invitation à jouer une nouvelle partie.\n"
							 . "Allez à {$CFG_MAINPAGE} pour annuler votre invitation.\n";
			break;
//------------------------------------------------------------------------------
		case 'deletewarning':
			$subject .= 'Alerte d\'effacement de partie';
			$message = "Votre partie ({$game_id}) va être bientôt effacée.\n"
							 . "Allez à {$CFG_MAINPAGE} pour la revoir.\n";
			break;
//------------------------------------------------------------------------------
		case 'passupdate':
			$subject .= 'Notification de ré-initialisation de mot de passe!!';
			$message = "Votre mot de passe pour CheckMat a été ré-initialisé.\n"
							 . "Votre nouveau de passe est : change!me\n\n"
							 . "Allez à {$CFG_MAINPAGE} pour vous connecter maintenant, selectionnez 'personel' dans le menu,\n"
							 . "et changez votre mot de passe pour quelque chose de plus sécurisé.\n";
			break;
//------------------------------------------------------------------------------
		case 'wakeup':
			$subject .= 'Fonction Réveil';
			$message = "Votre adversaire, {$opponent} vous a adressé un e-mail de réveil.\n"
							 . "C'est à votre tour de jouer dans la partie #{$game_id}.\n\n"
							 . "Allez à {$CFG_MAINPAGE} pour jouer.\n";
			break;
//------------------------------------------------------------------------------
		case 'checkmate':
			$subject .= 'Echec et mat !';
			$message = "Votre adversaire, {$opponent} vous a mis échec et mat.\n"
							 . "Vous aurez plus de chance la prochaine fois.\n\n"
							 . "Allez à {$CFG_MAINPAGE} pour commencer une nouvelle partie.\n";
			break;
		// ToDo: mailmsgundorequest.php ??
	}

	$message .= "\n\n----------------------------------------------\n"
						. "Ce message a été  envoyé  automatiquement\n"
						. 'par CheckMat et ne requiert pas de réponse.';
//$message = htmlentities($message); 
	$headers = "From: CheckMat <{$CFG_MAILADDRESS}>\r\n";
	// Some MTAs may require for you to uncomment the following line. Do so if mail notification doesn't work
//  $headers = "To: {$msgTo}\r\n" . $headers;

	call('---MAIL---');
	call($msgTo);
	call($subject);
	call($message);
	call($headers);

	return mail($msgTo,$subject,$message,$headers);
}

<?php

/* Database settings */
/* ----------------- */
	/*$CFG_HOSTNAME = 'localhost';
	$CFG_USERNAME = 'root';
	$CFG_PASSWORD = '';
	$CFG_DATABASE = 'jeuxechecs_fr';/*
	/*$CFG_HOSTNAME = '127.0.0.1';
	$CFG_USERNAME = 'root';
	$CFG_PASSWORD = '';
	$CFG_DATABASE = 'echecs';*/
	$CFG_HOSTNAME = 'XXXXXX';
	$CFG_USERNAME = 'XXXXXX';
	$CFG_PASSWORD = 'XXXXXX';
	$CFG_DATABASE = 'XXXXXX';

/* Table settings */
/* -------------- */
	$prefix = 'wc2_'; // table name prefix

	define('T_CHAT'      , $prefix . 'chat'); // the in-game chat/personal notes table
	define('T_GAME'      , $prefix . 'game'); // the game data table
	define('T_HISTORY'   , $prefix . 'history'); // the moves history table
	define('T_MESSAGE'   , $prefix . 'message'); // the game message table
	define('T_PLAYER'    , $prefix . 'player'); // the player data table
	define('T_STAT'      , $prefix . 'stat'); // the stats table
	define('T_TALK'      , $prefix . 'talk'); // the player messaging table
	define('T_TALK_GLUE' , $prefix . 'talk_glue'); // the message glue table

/* Root Admin setting */
/* ------------------ */
	$CFG_ROOT_ADMIN = 'mathieu'; // Permanent admin username (case-sensitive)

/* Server / Site settings */
/* ---------------------- */
	/*
		  --- PLEASE READ ---
		this first setting is the color theme for your webchess installation
		look inside the /css directory and you will find several css files with a
		filename like c_{color_name}.css.  pick one, and enter that name here, or you can easily
		create your own, using one of the included styles as a guide.
		if you do create your own, please add a pull request to my repo at
		https://github.com/benjamw/chess/ so that others may have access to it.
	*/

	$CFG_COLOR_CSS      = 'c_new.css'; // the name of the color css file you wish to use (in the /css directory)

	$CFG_MAINPAGE       = 'http://www.jeuxechecs.fr/echecs/'; // The home page of the webchess script (include closing / )

	$CFG_SITENAME       = 'http://www.jeuxechecs.fr'; // The name of your website

	$CFG_SESSIONTIMEOUT = 0; // Number of minutes before session timeout (0 to disable)

	$CFG_EXPIREGAME     = 60; // Number of days before untouched games are deleted (0 to disable)

	$CFG_EXPIREUSERS    = 0; // Number of days before untouched accounts are deleted (0 to disable) <30>

	$CFG_MINAUTORELOAD  = 25; // Minimum number of secs between automatic page reloads (0 to disable)

	$CFG_USEEMAIL       = true; // SMTP operations.  Test it before putting it into production

	$CFG_MAILADDRESS    = 'XXXX@XXXXcom'; // Email address people see when receiving WebChess generated mail
	//Adresse électronique que les gens voient lors de la réception du courrier généré par WebChess

	$CFG_MAXUSERS       = 0; // Maximum number of users allowed (0 to disable)

	$CFG_CHANGEUSERNAME = false; // Whether a user can change their username from the main menu

	$CFG_NEWUSERS       = true; // Whether a new user can register
    
    $CFG_LONGDATE       = ' j / m / Y à \&\n\b\s\p\;G:i '; // PHP date format

	$CFG_SHORTDATE      = 'Y.m.d H:i'; // PHP date format

	$CFG_CHESS960       = true; // Whether users can play Chess960 (Fischer Random Chess) games

	$CFG_RATING_START   = 1500; // the starting ELO rating for new players

	$CFG_RATING_STEP    = 32; // the max ELO rating change allowed per game

	//$CFG_NAVLINKS       = '<a href="/">Accueil</a>'; // your site's nav links

/* MySQL Error / debug settings */
/* ---------------------------- */
	define ('DB_ERR_EMAIL_ERRORS', true); // (true / false) set to true to email errors to TO address below
	define ('DB_ERR_LOG_ERRORS'  , true); // (true / false) set to true to log errors in mysql.err file
	define ('DB_ERR_TO'          , 'XXXXX@XXXXXcom'); // set your TO email address
	define ('DB_ERR_SUBJECT'     , 'CheckMat Query Error'); // don't really need to change this
	define ('DB_ERR_FROM'        , $CFG_MAILADDRESS); // set your FROM email address (can be the same as TO above)
	define ('DB_STATS_LOG'       , true); // (true / false) set to true to log query stats in mysql.err file (or database)
	define ('FILE_PATH_END'      , 'echec/'); // set the name of the directory containing the script (with wrapping / )

/* DEVELOPER USE ONLY */
/* ------------------ */
/* INCLUDE SOME GLOBAL INCLUDES */
require_once 'mysql.class.php';
require_once 'chessgame.inc.php';

// instantiate the class and connect to the database
$mysql = new mysql($CFG_HOSTNAME, $CFG_USERNAME, $CFG_PASSWORD, $CFG_DATABASE);
$mysql->connect_select(__LINE__,__FILE__);
//@mysqli_set_charset($mysql->linkid,'utf8');
@mysqli_set_charset($mysql->linkid,'utf8mb4');
// instantiate the chess class
$chess = new ChessGame( );

define('DEBUG', false); // set to true for output of debugging code
define('JS_DEBUG', 0); // set to 1 for really annoying jvascript debug

if (defined('DEBUG') && DEBUG)
{
	ini_set('display_errors', 'On');
	error_reporting(-1);
	$mysql->error_debug = true; // Allows for error debug output
	$mysql->query_debug = true; // Allows for output of all queries all the time
	$mysql->super_debug = false; // Allows output of ALL debugging output
}

require_once('func.global.php');
require_once('func.array.php');
require_once('func.bitwise.php');
require_once('message.class.php');
require_once('phpass.class.php');

$CFG_SESSIONTIMEOUT *= 60; // convert minutes to seconds
date_default_timezone_set('Europe/Paris');

if(mail('tonadressemail@truc.fr', 'TEST', "Message de test")){
  echo "OK";
}else{
  echo " La fonction mail ne marche pas !";
}

	call('---MAIL---');
	call($msgTo);
	call($subject);
	call($message);
	call($headers);
//print_r(array($msgTo,$subject,$message,$headers));
if(mail('xxxx@xxxx.fr', 'TEST', "Message de test")){
  echo "OK";
}else{
  echo " La fonction mail ne marche pas !";
}
	return mail($msgTo,$subject,$message,$headers);
}

<?php
if(mail('tonadressemail@truc.fr', 'TEST', "Message de test")){
  echo "OK";
}else{
  echo " La fonction mail ne marche pas !";
}
?>

<?php
$parts = pathinfo($_SERVER['REQUEST_URI']);
$path = $parts['dirname'];
if (empty($parts['extension'])) {
	//$path .= '/'.$parts['jeuxechecs_fr'];
	$path .= '/index.php';
}
$path = str_replace('\\', '/', $path).'/';
session_set_cookie_params(time()+365*24*3600, $path);
@session_start( );
require_once 'config.inc.php';
require 'login.inc.php';
require_once 'html.inc.php';
require_once 'html.tables.php';

// reset any shared data we may have collected
$_SESSION['shared'] = false;

// run some things first for the menu and data below
// open the PGN dir
$pgnDir = opendir("./pgn");
$fullFiles = array( );

// collect the game IDs for the games already exported
while (false !== ($file = readdir($pgnDir)))
{
	if (('..' != $file) && ('.' != $file) && ('index.php' != $file))
	{
		// collect the complete filename
		$fullFiles[] = $file;

		// collect just the game id for searching below
		if (preg_match('/game_(\\d++)/i', $file, $match))
		{
			$pgnFiles[] = $match[1];
		}
	}
}

// count the files for menu display
$numFiles = count($fullFiles);

// run a switch so that all the stuff being run here is not run all at once
// when viewing the page, it makes it so that the index page takes FOREVER
// to load

// make sure we have something to look at
$page = (isset($_GET['page'])) ? $_GET['page'] : 'mygames';
switch ($page)
{
// =========================================================================
	case 'mygames' :

		break;

// =========================================================================
	case 'current' :

		//******************************************************************
		//  cleanup dead games
		//******************************************************************

		// if we want to delete old games
		if (0 != $CFG_EXPIREGAME)
		{
			// find out which games are older
			$query = "
				SELECT *
				FROM ".T_GAME."
				WHERE g_last_move < DATE_SUB(NOW( ), INTERVAL {$CFG_EXPIREGAME} DAY)
			";
			$result = $mysql->fetch_array($query, __LINE__, __FILE__);

			// and for every old game...
			foreach ($result as $old_game)
			{
				// if the game is in progress...
				if ('' == $old_game['g_game_message'])
				{
					// find out who's turn it was...
					$query = "
						SELECT COUNT(*)
						FROM ".T_HISTORY."
						WHERE h_game_id = '{$old_game['g_id']}'
					";
					$old_moves = $mysql->fetch_value($query, __LINE__, __FILE__);

					// if it's black's turn...
					if (0 == ($old_moves % 2))
					{
						$player1 = $old_game['g_white_player_id']; // give white a win
						$player2 = $old_game['g_black_player_id']; // give black a loss
					}
					else // it was white's turn...
					{
						$player1 = $old_game['g_black_player_id']; // give black a win
						$player2 = $old_game['g_white_player_id']; // give white a loss
					}

					// require a file
					require_once './includes/chessdb.inc.php';

					adjust_stats($player1, $player2, 1, 0);
				}

				// ...clear the history...
				$query = "
					DELETE FROM ".T_HISTORY."
					WHERE h_game_id = '{$old_game['g_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// ...and the messages...
				$query = "
					DELETE FROM ".T_MESSAGE."
					WHERE m_game_id = '{$old_game['g_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// ...and the chat...
				$query = "
					DELETE FROM ".T_CHAT."
					WHERE c_game_id = '{$old_game['g_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// ...and finally the game itself from the database
				$query = "
					DELETE FROM ".T_GAME."
					WHERE g_id = '{$old_game['g_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);
			}
		}
		

		break;

// =========================================================================
	case 'finished' :
		require_once 'chessutils.inc.php';
		require_once 'gui.inc.php';

		//******************************************************************
		//  Export finished games to PGN directory
		//******************************************************************

		// save the current session vars
		if (isset($_SESSION['game_id']))
		{
			$prevSessionGameID = $_SESSION['game_id'];
		}

		if (isset($_SESSION['id960']))
		{
			$prevSessionId960 = $_SESSION['id960'];
		}

		// save the list to exclude them below
		$pgnFiles = isset($pgnFiles) ? implode(',', $pgnFiles) : '0';

		// get all the games that are finished, but not yet exported to PGN
		$query = "
			SELECT G.*
				, P1.p_username AS white_username
				, P2.p_username AS black_username
			FROM ".T_GAME." AS G
				LEFT JOIN ".T_PLAYER." AS P1
					ON P1.p_id = G.g_white_player_id
				LEFT JOIN ".T_PLAYER." AS P2
					ON P2.p_id = G.g_black_player_id
			WHERE G.g_id NOT IN ({$pgnFiles})
				AND G.g_game_message IN ('Draw','Player Resigned','Checkmate')
			ORDER BY G.g_id
		";
		$result = $mysql->fetch_array($query, __LINE__, __FILE__);

		// save those games to PGN
		foreach ($result as $game)
		{
			$_SESSION['game_id'] = $game['g_id'];
			$_SESSION['id960']   = $game['g_id960'];

			ob_start( );

			// get the FEN data from the database
			$i = 0;
			$query = "
				SELECT h_fen
				FROM ".T_HISTORY."
				WHERE h_game_id = '{$_SESSION['game_id']}'
				ORDER BY h_time
			";
			$result = $mysql->fetch_array($query, __LINE__, __FILE__);

			unset($FENarray);
			foreach ($result as $FEN)
			{
				$FENarray[$i] = $FEN[0];
				$i++;
			}

			FENtomoves( ); // (chessutils.inc.php)

			returnGameInfo($_SESSION['game_id']);
			echo getPGN( ); // (gui.inc.php)

			$pgnFile = "./pgn/WebChess2_Game_{$game['g_id']}_".str_replace('-', '', substr($game['g_last_move'], 0, 10 )).'.pgn';

			$fh = fopen($pgnFile, "w")
				or die("Impossible d\'ouvrir le fichier {$pgnFile}.  Vérifiez les permissions d\'accès au fichier\n");
			fwrite($fh, ob_get_contents( ))
				or die("Impossible d\'écrire dans le fichier $pgnFile. Vérifiez les permissions d\'accès au fichier\n");
			fclose($fh);
			ob_end_clean( );
		}

		// reinstate the saved session vars
		if (isset($prevSessionGameID))
		{
			$_SESSION['game_id'] = $prevSessionGameID;
		}

		if (isset($prevSessionId960))
		{
			$_SESSION['id960'] = $prevSessionId960;
		}
		//*/


		//******************************************************************
		//  send email notice for nearly dead games
		/******************************************************************

		// get 2/3 of expire length
		$targetDate = mktime(0,0,0, date('m'), date('d') - ($CFG_EXPIREGAME * (2/3)), date('Y'));

		$query = "
			SELECT *
			FROM ".T_GAME."
			WHERE g_last_move < '{$targetDate}'
		";
		$result = $mysql->fetch_array($query, __LINE__, __FILE__);

		foreach ($result as $game)
		{
			$query = "
				SELECT p_email
				FROM ".T_PLAYER."
				WHERE p_id = '{$game['g_white_player_id']}'
			";
			$whiteEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

			$query = "
				SELECT p_email
				FROM ".T_PLAYER."
				WHERE p_id = '{$game['g_black_player_id']}'
			";
			$blackEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

			webchessMail("deletewarning",$whiteEmail,0,0,$game['g_id']);
			webchessMail("deletewarning",$blackEmail,0,0,$game['g_id']);
		}
		//*/

		break;

// =========================================================================
	case 'invite' :
		require_once 'newgame.inc.php';
		require_once 'webchessmail.inc.php';

		//******************************************************************
		//  send invitation for a new game
		//******************************************************************

		if (isset($_POST['opponent']))
		{
			// prevent multiple invites from the same originator
			$P = sani($_POST);
			$query = "
				SELECT g_id
				FROM ".T_GAME."
				WHERE g_game_message = 'Player Invited'
					AND
					(
						(
							g_message_from = 'white'
							AND g_white_player_id = '{$_SESSION['player_id']}'
							AND g_black_player_id = '{$P['opponent']}'
						)
						OR
						(
							g_message_from = 'black'
							AND g_white_player_id = '{$P['opponent']}'
							AND g_black_player_id = '{$_SESSION['player_id']}'
						)
					)
			";
			$mysql->query($query, __LINE__, __FILE__);

			if (0 == $mysql->num_rows( ))
			{
				// set the color to a random color if 'random', otherwise, set the color given
				$color = ('random' == $P['color']) ? ((1 == mt_rand(0, 1)) ? 'white' : 'black') : $P['color'];

				$query = "
					INSERT INTO ".T_GAME."
						(g_id960, g_white_player_id, g_black_player_id, g_game_message, g_message_from, g_date_created, g_last_move)
					VALUES ('";

				// set the C960 ID
				if ( ! isset($P['txtId960']) || '' === $P['txtId960'] )
				{
					$query .= "518','";
				}
				else
				{
					$query .= (int) trim($P['txtId960']) . "','";
				}

				// put the players in the right order
				if ('white' == $color)
				{
					$query .= $_SESSION['player_id'] . "','" . $P['opponent'];
				}
				else
				{
					$query .= $P['opponent'] . "','" . $_SESSION['player_id'];
				}

				$query .= "','Player Invited','{$color}',NOW( ),NOW( )) ";
				$mysql->query($query, __LINE__, __FILE__);

				// if email notification is activated...
				if ($CFG_USEEMAIL)
				{
					// if opponent is using email notification...
					$query = "
						SELECT p_email
						FROM ".T_PLAYER."
						WHERE p_id = '{$_POST['opponent']}'
					";
					$opponentEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

					if (0 < $mysql->num_rows( ))
					{
						if ('' != $opponentEmail)
						{
							// notify opponent of invitation via email
							call("webchessMail('invitation',$opponentEmail,'',{$_SESSION['username']},'')");
							webchessMail('invitation',$opponentEmail,'',$_SESSION['username'],'');
						}
					}
				}
			}
		}
		//*/


		//******************************************************************
		//  respond to invitation
		//******************************************************************

		if (isset($_POST['respond']))
		{
			if ('accepted' == $_POST['respond'])
			{
				// update game data
				$query = "
					UPDATE ".T_GAME."
					SET g_game_message = ''
						, g_message_from = ''
					WHERE g_id = '{$_POST['game_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// get the opponents ID for email
				$query = "
					SELECT *
					FROM ".T_GAME."
					WHERE g_id = '{$_POST['game_id']}'
				";
				$game = $mysql->fetch_assoc($query, __LINE__, __FILE__);

				$oppID = ($game['g_white_player_id'] == $_SESSION['player_id']) ? $game['g_black_player_id'] : $game['g_white_player_id'];

				// setup new board
				$_SESSION['game_id'] = $_POST['game_id'];
				createNewGame($_POST['game_id'],$game['g_id960']); // (newgame.inc.php)
#				saveGame( ); // (chessdb.inc.php)

				// if email notification is activated...
				if ($CFG_USEEMAIL)
				{
					// if opponent is using email notification...
					$query = "
						SELECT p_email
						FROM ".T_PLAYER."
						WHERE p_id = '{$oppID}'
					";
					$opponentEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

					if (0 < $mysql->num_rows( ))
					{
						if ('' != $opponentEmail)
						{
							// notify opponent of invitation via email
							call("webchessMail('accepted',$opponentEmail,'',{$_SESSION['username']},'')");
							webchessMail('accepted',$opponentEmail,'',$_SESSION['username'],'');
						}
					}
				}
			}
			else
			{
				$query = "
					UPDATE ".T_GAME."
					SET g_game_message = 'Invite Declined'
						, g_message_from = '{$_POST['message_from']}'
					WHERE g_id = '{$_POST['game_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// get the opponents ID for email
				$query = "
					SELECT *
					FROM ".T_GAME."
					WHERE g_id = '{$_POST['game_id']}'
				";
				$game = $mysql->fetch_assoc($query, __LINE__, __FILE__);
								$oppID = ($game['g_white_player_id'] == $_SESSION['player_id']) ? $game['g_black_player_id'] : $game['g_white_player_id'];

				// if email notification is activated...
				if ($CFG_USEEMAIL)
				{
					// if opponent is using email notification...
					$query = "
						SELECT p_email
						FROM ".T_PLAYER."
						WHERE p_id = '{$oppID}'
					";
					$opponentEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

					if (0 < $mysql->num_rows( ))
					{
						if ('' != $opponentEmail)
						{
							// notify opponent of decline via email
							call("webchessMail('declined',$opponentEmail,'',{$_SESSION['username']},'')");
							webchessMail('declined',$opponentEmail,'',$_SESSION['username'],'');
						}
					}
				}
			}
		}
		//*/


		//******************************************************************
		//  withdraw invitation
		//******************************************************************

		if (isset($_POST['withdrawl']))
		{
			// get opponent's player ID
			$query = "
				SELECT g_white_player_id
				FROM ".T_GAME."
				WHERE g_id = '{$_POST['game_id']}'
			";
			$opponentID = $mysql->fetch_value($query, __LINE__, __FILE__);

			if (0 < $mysql->num_rows( ))
			{
				if ($opponentID == $_SESSION['player_id'])
				{
					$query = "
						SELECT g_black_player_id
						FROM ".T_GAME."
						WHERE g_id = '{$_POST['game_id']}'
					";
					$opponentID = $mysql->fetch_value($query, __LINE__, __FILE__);
				}

				$query = "
					DELETE FROM ".T_GAME."
					WHERE g_id = '{$_POST['game_id']}'
				";
				$mysql->query($query, __LINE__, __FILE__);

				// if email notification is activated...
				if ($CFG_USEEMAIL)
				{
					// if opponent is using email notification...
					$query = "
						SELECT p_email
						FROM ".T_PLAYER."
						WHERE p_id = '{$opponentID}'
					";
					$opponentEmail = $mysql->fetch_value($query, __LINE__, __FILE__);

					if (0 < $mysql->num_rows( ))
					{
						if ($opponentEmail != '')
						{
							// notify opponent of invitation via email
							call("webchessMail('withdrawal', $opponentEmail, '', {$_SESSION['username']}, {$_POST['game_id']})");
							webchessMail('withdrawal', $opponentEmail, '', $_SESSION['username'], $_POST['game_id']);
						}
					}
				}
			}
		}
		//*/

		break;

// =========================================================================
	case 'stats' :
	require_once 'chessutils.inc.php';

		//******************************************************************
		//  run the games data for the stats
		//******************************************************************

		// collect current stats from database
		$query = "
			SELECT s_id
				, s_moves
				, s_days
			FROM ".T_STAT."
			WHERE
				(
					s_moves IS NOT NULL
					AND s_moves != 0
				)
				OR
				(
					s_days IS NOT NULL
					AND s_days != 0
				)
		";
		$statsdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		// parse stats data into an array for easier searching
		foreach ($statsdata as $stat)
		{
			$curstats[$stat['s_id']]['moves'] = $stat['s_moves'];
			$curstats[$stat['s_id']]['days']  = $stat['s_days'];
		}

		// collect any finished game data from the database
		$query = "
			SELECT COUNT(h_game_id) AS moves
				, DATEDIFF(g_last_move, g_date_created) AS days
				, h_game_id AS id
			FROM ".T_HISTORY."
				, ".T_GAME."
			WHERE ".T_HISTORY.".h_game_id = ".T_GAME.".g_id
				AND g_game_message IN ('Draw', 'Player Resigned', 'Checkmate')
			GROUP BY h_game_id
		";
		$gamedata = $mysql->fetch_array($query, __LINE__, __FILE__);

		// parse through each, compare with current, and add stats as needed
		foreach ($gamedata as $game)
		{
			// clear any previous query
			$query = '';

			if ( ! isset($curstats[$game['id']]))
			{
				$query = "
					INSERT INTO ".T_STAT."
						(s_id, s_days, s_moves)
					VALUES
						('{$game['id']}', '{$game['days']}', '{$game['moves']}')
				";
			}
			elseif ($curstats[$game['id']]['moves'] != $game['moves'] || $curstats[$game['id']]['days'] != $game['days'])
			{
				$query = "
					UPDATE ".T_STAT."
					SET s_moves = '{$game['moves']}'
						, s_days  = '{$game['days']}'
					WHERE s_id = '{$game['id']}'
				";
			}

			// run the query
			if ('' != $query)
			{
				$mysql->query($query, __LINE__, __FILE__);
			}
		}
		//*/

		// stats -----------------------------------------------------------

		$query = "
			SELECT distinct concat('#',g_id,'  ',(select p_username from ".T_PLAYER." WHERE p_id = g_white_player_id),' - ',(select p_username from ".T_PLAYER." WHERE p_id = g_black_player_id)) as joueurs
				, s_days
			FROM ".T_STAT."
			JOIN ".T_GAME." ON g_id = s_id
			WHERE s_days IS NOT NULL
			ORDER BY s_days DESC
			LIMIT 0,5
		";

		$daysLdata = $mysql->fetch_array($query, __LINE__, __FILE__);


		$query = "
			SELECT distinct concat('#',g_id,'  ',(select p_username from ".T_PLAYER." WHERE p_id = g_white_player_id),' - ',(select p_username from ".T_PLAYER." WHERE p_id = g_black_player_id)) as joueurs
				, s_days
			FROM ".T_STAT."
			JOIN ".T_GAME." ON g_id = s_id
			WHERE s_days IS NOT NULL
			ORDER BY s_days ASC
			LIMIT 0,5
		";
		$daysSdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		$query = "
			SELECT distinct concat('#',g_id,'  ',(select p_username from ".T_PLAYER." WHERE p_id = g_white_player_id),' - ',(select p_username from ".T_PLAYER." WHERE p_id = g_black_player_id)) as joueurs
				, (s_moves - 1) as s_moves
			FROM ".T_STAT."
			JOIN ".T_GAME." ON g_id = s_id
			WHERE s_moves IS NOT NULL
			ORDER BY s_moves DESC
			LIMIT 0,5
		";
		$movesLdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		$query = "
			SELECT distinct concat('#',g_id,'  ',(select p_username from ".T_PLAYER." WHERE p_id = g_white_player_id),' - ',(select p_username from ".T_PLAYER." WHERE p_id = g_black_player_id)) as joueurs
				,(s_moves - 1) as s_moves
			FROM ".T_STAT."
			JOIN ".T_GAME." ON g_id = s_id
			WHERE s_moves IS NOT NULL
			ORDER BY s_moves ASC
			LIMIT 0,5
		";
		$movesSdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		$query = "
			SELECT s_id
				, MAX(ABS(s_streak)) AS s_streak
				, p_username
			FROM ".T_STAT."
				LEFT JOIN ".T_PLAYER."
					ON p_id = s_id
			WHERE s_streak IS NOT NULL
			GROUP BY s_id
			ORDER BY s_streak DESC
			LIMIT 0,5
		";
		$streakdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		$query = "
			SELECT *
			FROM ".T_PLAYER."
			ORDER BY p_rating DESC
		";
		$playerdata = $mysql->fetch_array($query, __LINE__, __FILE__);

		$query = "
			SELECT p_username,
			(p_wins + p_draws + p_losses) as nb_p
			FROM ".T_PLAYER."
			WHERE p_wins + p_draws + p_losses != 0
			ORDER BY nb_p DESC
			LIMIT 0,5
		";
		$statspartiejouees = $mysql->fetch_array($query, __LINE__, __FILE__);

		break;

// =========================================================================
	case 'messages' :

		if (isset($_POST['action'])) {
			try {
				switch ($_POST['action']) {
					case 'read' :
						$Message->set_message_read($_POST['ids']);
						break;

					case 'unread' :
						$Message->set_message_unread($_POST['ids']);
						break;

					case 'delete' :
						$Message->delete_message($_POST['ids']);
						break;

					default :
						break;
				}
			}
			catch (Exception $e) { }
		}

		break;

// =========================================================================
	case 'send' :

		if (isset($_POST['submit'])) {
			// clean the data
			$subject = $_POST['subject'];
			$message = $_POST['message'];
			$user_ids = (array) ife($_POST['user_ids'], array( ), false);
			$send_date = ife($_POST['send_date'], false, false);
			$expire_date = ife($_POST['expire_date'], false, false);

			try {
				$Message->send_message($subject, $message, $user_ids, $send_date, $expire_date);
			}
			catch (Exception $e) {
			}

			header('Location: index.php?page=messages');
			exit;
		}

		$message = array(
			'subject' => '',
			'message' => '',
		);

		if (isset($_GET['id'])) {
			try {
				if (isset($_GET['type']) && ('fw' == $_GET['type'])) { // forward
					$message = $Message->get_message_forward((int) $_GET['id']);
				}
				elseif (isset($_GET['type']) && ('rs' == $_GET['type'])) { // resend
					$message = $Message->get_message((int) $_GET['id']);
				}
				else { // reply
					$message = $Message->get_message_reply((int) $_GET['id']);
					$reply_flag = true;
				}
			}
			catch (Exception $e) { }
		}

		// grab a list of the players
		$query = "
			SELECT `p_id`
				, `p_username`
			FROM `".T_PLAYER."`
			ORDER BY `p_username`
		";
		$list = $mysql->fetch_array($query);

		$recipient_options = '';
		if (is_array($list)) {
			// send global messages if we can
			if ($_SESSION['is_admin']) {
				$recipient_options .= '<option value="0">GLOBAL</option>';
			}

			$recipient_id = (isset($message['recipients'][0]['from_id']) && ! empty($reply_flag)) ? $message['recipients'][0]['from_id'] : 0;

			foreach ($list as $player) {
			
				// remove ourselves from the list
				if ($player['p_id'] == $_SESSION['player_id']) {
					continue;
				}
					if ($player['p_id'] == 1){ $sel = 'selected';}else{$sel="";} // envoie à l'admin à défaut, il faut un destinataire à défaut.
					$recipient_options .= '<option '.$sel.' value="'.$player['p_id'].'"'.get_selected($recipient_id, $player['p_id']).'>'.$player['p_username'].'</option>';
				
			}
		}

		break;

// =========================================================================
	case 'read' :

		if (isset($_POST['type']) && ('' != $_POST['type'])) {
			switch ($_POST['type']) {
				case 'delete' :
					$Message->delete_message((int) $_POST['message_id']);
					header('Location: index.php?page=messages');
					exit;
					break;

				default :
					break;
			}
		}

		if ( ! isset($_GET['id'])) {
			session_write_close( );
			header('Location: index.php?page=messages');
			exit;
		}

		try {
			$message = $Message->get_message($_GET['id'], $_SESSION['is_admin']);
			$message['message'] = str_replace("\t", '    ', $message['message']);
			$message['message'] = str_replace('  ', '  ', $message['message']);
			$message['message'] = htmlentities($message['message'], ENT_QUOTES, 'UTF-8', false);
			$message['message'] = nl2br($message['message']);

			$message['subject'] = htmlentities($message['subject'], ENT_QUOTES, 'UTF-8', false);

			// find out if we're reading an inbox message, or an outbox message
			if ($message['inbox']) {
				$list = $Message->get_outbox_list( );
			}
			elseif ($message['allowed']) {
				$list = $Message->get_inbox_list( );
			}
			else {
				$list = $Message->get_admin_list( );
			}
		}
		catch (Exception $e) { }

		// grab data for our prev | next links
		$prev = false;
		$next = false;
		$current = false;
		$prev_item = false;
		foreach ($list as $item) {
			if ($current) {
				$current = false;
				$next = $item['message_id'];
			}

			if ($item['message_id'] == $_GET['id']) {
				$current = true;
				$prev = $prev_item['message_id'];
			}

			$prev_item = $item;
		}

		break;

// =========================================================================
	case 'prefs' :

		//******************************************************************
		//  update your preferences
		//******************************************************************

		if (isset($_POST['selHistory']))
		{
			call("UPDATE PREFS");
			// set auto-reload preference
			$reload = (is_numeric($_POST['txtReload']) && ( intval($_POST['txtReload']) >= $CFG_MINAUTORELOAD) ) ? $_POST['txtReload'] : $CFG_MINAUTORELOAD;

			$lastMove = isset($_POST['boxLastMove']) ? 1 : 0;

			// Theme
			$query = "
				UPDATE ".T_PLAYER."
				SET p_theme         = '{$_POST['rdoTheme']}'
					, p_history     = '{$_POST['selHistory']}'
					, p_auto_reload = '".sani($reload)."'
					, p_max_games   = '".sani($_POST['txtmaxGames'])."'
					, p_show_last_move = '{$lastMove}'
				WHERE p_id = '{$_SESSION['player_id']}'
			";
			$mysql->query($query, __LINE__, __FILE__);

			// update current session vars with a page refresh
			header('Location: index.php?page=prefs');
			exit;
		}
		//*/

		break;

// =========================================================================
	case 'personal' :

		//******************************************************************
		//  update your personal information
		//******************************************************************

		if (isset($_POST['txtFirstName']))
		{
			$query = "
				SELECT p_password
				FROM ".T_PLAYER."
				WHERE p_id = '{$_SESSION['player_id']}'
			";
			$dbPassword = $mysql->fetch_value($query, __LINE__, __FILE__);

			if ((isset($_POST['pwdPassword']) && ('' != $_POST['pwdPassword'])) && ! password_test($_POST['pwdOldPassword'], $dbPassword))
			{
				$errMsg = "Désolé, le mot de passe est incorrect!";
			}
			else
			{
				$doUpdate = true;

				if ($CFG_CHANGEUSERNAME)
				{
					$query = "
						SELECT p_id
						FROM ".T_PLAYER."
						WHERE p_username = '".sani($_POST['txtUsername'])."'
							AND p_id != '{$_SESSION['player_id']}'
					";
					$mysql->query($query, __LINE__, __FILE__);

					if (0 < $mysql->num_rows( ))
					{
						$errMsg = "Désolé, ce nom d\'utilisateur est déjà utilisé.";
						$doUpdate = false;
					}
				}

				// if it's set, then it's allowed
				$email = isset($_POST['txtEmail']) ? $_POST['txtEmail'] : '';

				if ($doUpdate)
				{
					// update DB
					$query = "
						UPDATE ".T_PLAYER."
						SET p_first_name  = '".sani($_POST['txtFirstName'])."'
							, p_last_name = '".sani($_POST['txtLastName'])."'
				 			, p_email     = '".sani($email)."'
					"; // continued...

					if (isset($_POST['pwdPassword']) && ('' != $_POST['pwdPassword']))
					{
						$query .= " , p_password = '".password_make($_POST['pwdPassword'])."' "; // continued...
					}

					if ((false != $CFG_CHANGEUSERNAME) && ('' != $_POST['txtUsername']))
					{
						$_SESSION['username'] = $_POST['txtUsername'];
						$query .= " , p_username = '".sani($_POST['txtUsername'])."' "; // continued...
					}

					$query .= " WHERE p_id = '{$_SESSION['player_id']}' ";
					$mysql->query($query, __LINE__, __FILE__);

					// update current session vars with a page refresh
					header('Location: index.php?page=personal');
					exit;
				}
			}
		}
		//*/


		//******************************************************************
		//  test your email address
		//******************************************************************

		if (isset($_POST['testmail']) && (false != $CFG_USEEMAIL))
		{
			webchessMail('test', $_SESSION['email'], '', '', '');
		}
		//*/

		break;

// =========================================================================
	case 'admin' :
		require_once 'webchessmail.inc.php';

		//******************************************************************
		//  run administration functions
		//******************************************************************

		if (isset($_POST))
		{
			// set all admin flags to 0...
			$query = "
				UPDATE ".T_PLAYER."
				SET p_is_admin = '0'
				WHERE 1
			";
			$mysql->query($query, __LINE__, __FILE__);

			// set the current user to admin
			// because if they accessed this, they are admin
			$query = "
				UPDATE ".T_PLAYER."
				SET p_is_admin = '1'
				WHERE p_id = '{$_SESSION['player_id']}'
				LIMIT 1
			";
			$mysql->query($query, __LINE__, __FILE__);

			// update admin before deleting
			if ( isset($_POST['admin']) )
			{
				foreach ( $_POST['admin'] as $user )
				{
					// ...then adminify all the checked ones
					$query = "
						UPDATE ".T_PLAYER."
						SET p_is_admin = '1'
						WHERE p_id = '{$user}'
						LIMIT 1
					";
					$mysql->query($query, __LINE__, __FILE__);
				}
			}

			// reset passwords before deleting as well
			if ( isset($_POST['resetpass']) )
			{
				foreach ( $_POST['resetpass'] as $user )
				{
					// reset the password to change!me
					$pass = password_make('change!me');
					$query = "
						UPDATE ".T_PLAYER."
						SET p_password = '{$pass}'
						WHERE p_id = '{$user}'
						LIMIT 1
					";
					$mysql->query($query, __LINE__, __FILE__);

					// obtenir l'adresse électronique des utilisateurs
					$query = "
						SELECT p_email
						FROM ".T_PLAYER."
						WHERE p_id = '{$user}'
					";
					$email = $mysql->fetch_value($query, __LINE__, __FILE__);

					// envoyer l'utilisateur et leur faire savoir leur mot de passe a été changé
					call("webchessMail('passupdate',$email,'','','')");
					webchessMail('passupdate',$email,'','','');
				}
			}

			$i = 0;
			if ( isset($_POST['delete']) )
			{
				foreach ( $_POST['delete'] as $user )
				{
					$query = "
						SELECT p_username
						FROM ".T_PLAYER."
						WHERE p_id = '{$user}'
					";
					$name = $mysql->fetch_value($query, __LINE__, __FILE__);

					// protect the root admin, just in case
					if ($CFG_ROOT_ADMIN != $name)
					{
						// find all the games that user was playing
						$query = "
							SELECT g_id
							FROM ".T_GAME."
							WHERE g_black_player_id = '{$user}'
								OR g_white_player_id = '{$user}'
						";
						$list = $mysql->fetch_value_array($query, __LINE__, __FILE__);
						call('list');
						$list[] = 0;
						$games = implode(',', $list);

						// delete all database entries related to those games
						$query = "
							DELETE FROM ".T_CHAT."
							WHERE c_game_id IN ({$games})
						";
						$mysql->query($query, __LINE__, __FILE__);

						$query = "
							DELETE FROM ".T_HISTORY."
							WHERE h_game_id IN ({$games})
						";
						$mysql->query($query, __LINE__, __FILE__);

						$query = "
							DELETE FROM ".T_MESSAGE."
							WHERE m_game_id IN ({$games})
						";
						$mysql->query($query, __LINE__, __FILE__);

						$query = "
							DELETE FROM ".T_GAME."
							WHERE g_id IN ({$games})
						";
						$mysql->query($query, __LINE__, __FILE__);


						// supprimer les communications liées à ce joueur
						/*$query = "
							DELETE FROM ".T_TALK."
							WHERE t_from_player_id = '{$user}'
								OR t_to_player_id = '{$user}'
						";
						$mysql->query($query, __LINE__, __FILE__);*/

						// enfin, supprimer le joueur
						$query = "
							DELETE FROM ".T_PLAYER."
							WHERE p_id = {$user}
							LIMIT 1
						";
						$mysql->query($query, __LINE__, __FILE__);
						$i++;
					}
				}
			}
			if ( isset($i) && $i )
			{
				$errMsg = "! {$i} users deleted !";
			}
		}
		//*/

		// admin -----------------------------------------------------------

		$query = "
			SELECT *
				, UNIX_TIMESTAMP(p_created) AS u_created
			FROM ".T_PLAYER."
			WHERE p_id != '{$_SESSION['player_id']}'
				AND p_username != '{$CFG_ROOT_ADMIN}'
			ORDER BY p_username
		";
		$admin = $mysql->fetch_array($query, __LINE__, __FILE__);

		break;

// ====================================================
	default :
		// send them to the login page, if they are logged in
		// it will send them back to the index with proper data
		header('Location: login.php');
		exit;
		break;
} // the big switch


//******************************************************************************
//  run the queries (needed outside for the menu)
//******************************************************************************

// active ------------------------------------------------------------------

$query = "
	SELECT G.*
		, UNIX_TIMESTAMP(G.g_date_created) AS u_date_created
		, UNIX_TIMESTAMP(G.g_last_move) AS u_last_move
		, COUNT(H.h_time) - 1 AS num_moves
		, P1.p_username AS white_username
		, P2.p_username AS black_username
	FROM ".T_GAME." AS G
		LEFT JOIN ".T_HISTORY." AS H
			ON H.h_game_id = G.g_id
		LEFT JOIN ".T_PLAYER." AS P1
			ON P1.p_id = G.g_white_player_id
		LEFT JOIN ".T_PLAYER." AS P2
			ON P2.p_id = G.g_black_player_id
	WHERE G.g_game_message = ''
		AND (
			G.g_white_player_id = '{$_SESSION['player_id']}'
			OR G.g_black_player_id = '{$_SESSION['player_id']}'
		)
	GROUP BY G.g_id
	ORDER BY G.g_date_created
";
$active = $mysql->fetch_array($query, __LINE__, __FILE__);
$numActive = $mysql->num_rows( );


// messages ----------------------------------------------------------------


list($numMsgs, $newMsgs) = Message::get_count($_SESSION['player_id']);


// invites -----------------------------------------------------------------

$query = "
	SELECT G.*
		, UNIX_TIMESTAMP(G.g_date_created) AS u_date_created
		, P1.p_username AS white_username
		, P2.p_username AS black_username
		, 'invite' AS invite
		, 0 AS num_moves
	FROM ".T_GAME." AS G
		LEFT JOIN ".T_PLAYER." AS P1
			ON P1.p_id = G.g_white_player_id
		LEFT JOIN ".T_PLAYER." AS P2
			ON P2.p_id = G.g_black_player_id
	WHERE G.g_game_message = 'Player Invited'
		AND (
			(
				G.g_white_player_id = '{$_SESSION['player_id']}'
				AND G.g_message_from = 'black'
			)
			OR (
				G.g_black_player_id = '{$_SESSION['player_id']}'
				AND G.g_message_from = 'white'
			)
		)
	ORDER BY G.g_date_created
";
$invites = $mysql->fetch_array($query, __LINE__, __FILE__);
$numInvites = $mysql->num_rows( );


// outvites ----------------------------------------------------------------

// if game is marked playerInvited and the invite is from the current player
// OR game is marked inviteDeclined and the response is from the opponent
$query = "
	SELECT G.*
		, UNIX_TIMESTAMP(G.g_date_created) AS u_date_created
		, P1.p_username AS white_username
		, P2.p_username AS black_username
		, 'outvite' AS outvite
		, 0 AS num_moves
	FROM ".T_GAME." AS G
		LEFT JOIN ".T_PLAYER." AS P1
			ON P1.p_id = G.g_white_player_id
		LEFT JOIN ".T_PLAYER." AS P2
			ON P2.p_id = G.g_black_player_id
	WHERE
		(
			G.g_game_message = 'Player Invited'
			AND (
				(
					G.g_white_player_id = '{$_SESSION['player_id']}'
					AND G.g_message_from = 'white'
				)
				OR (
					G.g_black_player_id = '{$_SESSION['player_id']}'
					AND G.g_message_from = 'black'
				)
			)
		)
		OR (
			G.g_game_message = 'Invite Declined'
			AND (
				(
					G.g_white_player_id = '{$_SESSION['player_id']}'
					AND G.g_message_from = 'black'
				)
				OR (
					G.g_black_player_id = '{$_SESSION['player_id']}'
					AND G.g_message_from = 'white'
				)
			)
		)
	ORDER BY G.g_date_created
";

$outvites = $mysql->fetch_array($query, __LINE__, __FILE__);
$numOutvites = $mysql->num_rows( );


// others ------------------------------------------------------------------

// generate a list of games with at least one move in it
$query = "
	SELECT DISTINCT h_game_id
		, COUNT(*) AS h_moves
	FROM ".T_HISTORY."
	GROUP BY h_game_id
";
$result = $mysql->fetch_array($query, __LINE__, __FILE__);

foreach ($result as $game)
{
	$others[] = $game['h_game_id'];
	$count[$game['h_game_id']] = $game['h_moves'];
}

$list = isset($others) ? implode(',',$others) : 0;

// now select all current games from that list
$query = "
	SELECT G.*
		, UNIX_TIMESTAMP(G.g_date_created) AS u_date_created
		, UNIX_TIMESTAMP(G.g_last_move) AS u_last_move
		, COUNT(H.h_time) - 1 AS num_moves
		, P1.p_username AS white_username
		, P2.p_username AS black_username
	FROM ".T_GAME." AS G
		LEFT JOIN ".T_HISTORY." AS H
			ON H.h_game_id = G.g_id
		LEFT JOIN ".T_PLAYER." AS P1
			ON P1.p_id = G.g_white_player_id
		LEFT JOIN ".T_PLAYER." AS P2
			ON P2.p_id = G.g_black_player_id
	WHERE G.g_game_message = ''
		AND G.g_id IN ({$list})
		AND G.g_white_player_id != '{$_SESSION['player_id']}'
		AND G.g_black_player_id != '{$_SESSION['player_id']}'
	GROUP BY G.g_id
	ORDER BY G.g_date_created
";
$others = $mysql->fetch_array($query, __LINE__, __FILE__);
$numOthers = $mysql->num_rows( );


// done --------------------------------------------------------------------

$query = "
	SELECT G.*
		, UNIX_TIMESTAMP(G.g_date_created) AS u_date_created
		, UNIX_TIMESTAMP(G.g_last_move) AS u_last_move
		, COUNT(H.h_time) - 1 AS num_moves
		, P1.p_username AS white_username
		, P2.p_username AS black_username
	FROM ".T_GAME." AS G
		LEFT JOIN ".T_HISTORY." AS H
			ON h_game_id = G.g_id
		LEFT JOIN ".T_PLAYER." AS P1
			ON P1.p_id = G.g_white_player_id
		LEFT JOIN ".T_PLAYER." AS P2
			ON P2.p_id = G.g_black_player_id
	WHERE G.g_game_message NOT IN ('','Player Invited','Invite Declined')
	GROUP BY G.g_id
	ORDER BY G.g_id
";
$done = $mysql->fetch_array($query, __LINE__, __FILE__);
$numDone = $mysql->num_rows( );


// other various bits ------------------------------------------------------

// get number of players
$query = "
	SELECT COUNT(*)
	FROM ".T_PLAYER."
";
$numPlayers = $mysql->fetch_value($query, __LINE__, __FILE__);

// get number of active games
$query = "
	SELECT COUNT(*)
	FROM ".T_GAME."
	WHERE g_game_message = ''
";
$numGames = $mysql->fetch_value($query, __LINE__, __FILE__);

// get number of total games
$query = "
	SELECT MAX(g_id)
	FROM ".T_GAME."
";
$totGames = $mysql->fetch_value($query, __LINE__, __FILE__);

$numMyturn = get_num_mine($active);
//*/

?>

$wake_up_sent = false;
if ( isset($_POST['wakeID']) && $_SESSION['game_id'] == $_POST['wakeID'] )
{
    echo $_POST['wakeID'];
    echo "<br/>";
    echo $_SESSION['game_id'];
    echo "<br/>";
    echo $_POST['wakeID'];
	call("webchessMail('wakeup',{$_SESSION['opponent']['p_email']},'',{$_SESSION['username']},{$_SESSION['game_id']})");
	$wake_up_sent = webchessMail('wakeup',$_SESSION['opponent']['p_email'],'',$_SESSION['username'],$_SESSION['game_id']);
    if ($wake_up_sent) {
        echo "Bonjour";
    }
}

<?php


/** function ife
 *		if-else
 *		This function returns the value if it exists (or is optionally not empty)
 *		or a default value if it does not exist (or is empty)
 *
 * @param mixed var to test
 * @param mixed optional default value
 * @param bool optional allow empty value
 * @param bool optional change the passed reference var
 * @return mixed $var if exists (and not empty) or default otherwise
 */
function ife( & $var, $default = null, $allow_empty = true, $change_reference = false) {
	if ( ! isset($var) || ( ! (bool) $allow_empty && empty($var))) {
		if ((bool) $change_reference) {
			$var = $default; // so it can also be used by reference
		}

		return $default;
	}

	return $var;
}



/** function ifer
 *		if-else reference
 *		This function returns the value if it exists (or is optionally not empty)
 *		or a default value if it does not exist (or is empty)
 *		It also changes the reference var
 *
 * @param mixed var to test
 * @param mixed optional default value
 * @param bool optional allow empty value
 * @action updates/sets the reference var if needed
 * @return mixed $var if exists (and not empty) or default otherwise
 */
function ifer( & $var, $default = null, $allow_empty = true) {
	return ife($var, $default, $allow_empty, true);
}



/** function ifenr
 *		if-else non-reference
 *		This function returns the value if it is not empty
 *		or a default value if it is empty
 *
 * @param mixed var to test
 * @param mixed optional default value
 * @return mixed $var if not empty or default otherwise
 */
function ifenr($var, $default = null) {
	if (empty($var)) {
		return $default;
	}

	return $var;
}



/** function password_make
 *		wrapper function for PasswordHash (PHPass)
 *
 * @param string password
 * @return string hash
 */
function password_make($pass) {
	// bcrypt only uses the first 72 characters,
	// this also prevents DoS attacks
	if (72 < strlen($pass)) {
		return false;
	}

	$PH = new PasswordHash(8, false);
	$hash = $PH->HashPassword($pass);

	if (20 > strlen($hash)) {
		return false;
	}

	return $hash;
}



/** function password_test
 *		wrapper function for PasswordHash (PHPass)
 *
 * @param string password
 * @param string hash
 * @return bool valid password
 */
function password_test($pass, $hash) {
	$PH = new PasswordHash(8, false);
	return $PH->CheckPassword($pass, $hash);
}



/** function call
 *		simple configurable debugging output
 *
 * @param optional mixed
 * @return void
 */
if ( ! function_exists('call')) {
	function call($var = '^^k8)SJ2di!U') {
		if ( ! defined('DEBUG') || (false == DEBUG)) {
			return;
		}

		if ('^^k8)SJ2di!U' === $var) {
			echo '<span style="font-weight:bold;background:white;color:red;">*****</span>';
		}
		else {
			// begin output buffering so we can escape any html
			ob_start( );

			if (is_string($var) && isset($GLOBALS[$var])) {
				echo '$' . $var . ' = ';
				$var = $GLOBALS[$var];
			}

			if (is_bool($var) || is_null($var)) {
				var_dump($var);
			}
			else {
				print_r($var);
			}

			// end output buffering and output the result
			$contents = htmlentities(ob_get_contents( ));
			ob_end_clean( );

			echo '<pre style="background:#FFF;color:#000;font-size:larger;">'.$contents.'</pre>';
		}
	}
}

return mail($msgTo,$subject,$message,$headers);

	$message .= "\n\n----------------------------------------------\n"
						. "Ce message a été  envoyé  automatiquement\n"
						. 'par CheckMat et ne requiert pas de réponse.';
//$message = htmlentities($message); 
	/*$headers = "From: CheckMat <{$CFG_MAILADDRESS}>\r\n";*/
	// Some MTAs may require for you to uncomment the following line. Do so if mail notification doesn't work
  $headers = "To: {$msgTo}\r\n" . $headers;

	call('---MAIL---');
	call($msgTo);
	call($subject);
	call($message);
	call($headers);

	return mail($msgTo,$subject,$message,$headers);
}