/View/webchs/chessdb.php

<?php 

// $Id: chessdb.php,v 1.10 2010/08/14 16:57:54 sandking Exp $



/*

    This file is part of WebChess. http://webchess.sourceforge.net

	Copyright 2010 Jonathan Evraire, Rodrigo Flores



    WebChess is free software: you can redistribute it and/or modify

    it under the terms of the GNU General Public License as published by

    the Free Software Foundation, either version 3 of the License, or

    (at your option) any later version.



    WebChess is distributed in the hope that it will be useful,

    but WITHOUT ANY WARRANTY; without even the implied warranty of

    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    GNU General Public License for more details.



    You should have received a copy of the GNU General Public License

    along with WebChess.  If not, see <http://www.gnu.org/licenses/>.

*/



	/* these functions are used to interact with the DB */

	function updateTimestamp()

	{

		global $CFG_TABLE;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		mysql_query("UPDATE " . $CFG_TABLE[games] . " SET ga_lastmove = NOW() WHERE ga_gameid = ".$_SESSION['gameID']);

	}



	function loadHistory()

	{

		global $CFG_TABLE;

		global $history, $numMoves;

		

		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		$allMoves = mysql_query("SELECT * FROM " . $CFG_TABLE[history] . " WHERE hi_gameid = ".$_SESSION['gameID']." ORDER BY hi_timeofmove");



		$numMoves = -1;

		while ($thisMove = mysql_fetch_array($allMoves, MYSQL_ASSOC))

		{

			$numMoves++;

			$history[$numMoves] = $thisMove;

		}

	}



	function savePromotion()

	{

		global $CFG_TABLE;

		global $history, $numMoves, $isInCheck;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		if ($isInCheck)

		{

			$tmpIsInCheck = 1;

			$history[$numMoves]['isInCheck'] = 1;

		}

		else

			$tmpIsInCheck = 0;



		$history[$numMoves]['promotedTo'] = getPieceName($_POST['promotion']);



		$tmpQuery = "UPDATE " . $CFG_TABLE[history] . " SET hi_promotedto = '".getPieceName($_POST['promotion'])."', hi_isIncheck = ".$tmpIsInCheck." WHERE hi_gameid = ".$_SESSION['gameID']." AND hi_timeofmove = '".$history[$numMoves]['timeOfMove']."'";

		mysql_query($tmpQuery);



		updateTimestamp();

	

		/* if email notification is activated and move does not result in a pawn's promotion... */

		if ($CFG_USEEMAILNOTIFICATION && ! $_SESSION['isSharedPC'])

		{

			if ($history[$numMoves]['replaced'] == null)

				$tmpReplaced = '';

			else

				$tmpReplaced = $history[$numMoves]['replaced'];



			/* get opponent's color */

			if (($numMoves == -1) || ($numMoves % 2 == 1))

				$oppColor = "black";

			else

				$oppColor = "white";

			

			/* get opponent's player ID */

			if ($oppColor == 'white')

				$tmpOpponentID = mysql_query("SELECT ga_whiteplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

			else

				$tmpOpponentID = mysql_query("SELECT ga_blackplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

			

			$opponentID = mysql_result($tmpOpponentID, 0);

			

			/* if opponent is using email notification... */

			$tmpOpponentEmail = mysql_query("SELECT value FROM " . $CFG_TABLE[preferences] . " WHERE playerID = ".$opponentID." AND preference = 'emailNotification'");

			if (mysql_num_rows($tmpOpponentEmail) > 0)

			{

				$opponentEmail = mysql_result($tmpOpponentEmail, 0);

				if ($opponentEmail != '')

				{

					/* get opponent's nick */

					$tmpOpponentNick = mysql_query("SELECT nick FROM " . $CFG_TABLE[players] . " WHERE playerID = ".$_SESSION['playerID']);

					$opponentNick = mysql_result($tmpOpponentNick, 0);

					

					/* get opponent's prefered history type */

					$tmpOpponentHistory = mysql_query("SELECT value FROM " . $CFG_TABLE[preferences] . " WHERE playerID = ".$opponentID." AND preference = 'history'");

					

					/* default to PGN */

					if (mysql_num_rows($tmpOpponentHistory) > 0)

						$opponentHistory = mysql_result($tmpOpponentHistory, 0);

					else

						$opponentHistory = 'pgn';

					

					/* notify opponent of move via email */

					if ($opponentHistory == 'pgn')

						webchessMail('move', $opponentEmail, moveToPGNString($history[$numMoves]['curColor'], $history[$numMoves]['curPiece'], $history[$numMoves]['fromRow'], $history[$numMoves]['fromCol'], $history[$numMoves]['toRow'], $history[$numMoves]['toCol'], $tmpReplaced, $history[$numMoves]['promotedTo'], $isInCheck), $opponentNick, $_SESSION['gameID']);

					else

						webchessMail('move', $opponentEmail, moveToVerbousString($history[$numMoves]['curColor'], $history[$numMoves]['curPiece'], $history[$numMoves]['fromRow'], $history[$numMoves]['fromCol'], $history[$numMoves]['toRow'], $history[$numMoves]['toCol'], $tmpReplaced, $history[$numMoves]['promotedTo'], $isInCheck), $opponentNick, $_SESSION['gameID']);

				}

			}

		}

	}

	

	function saveHistory()

	{

		global $CFG_TABLE;

		global $board, $isPromoting, $history, $numMoves, $isInCheck, $CFG_USEEMAILNOTIFICATION;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		/* set destination row for pawn promotion */

		if ($board[$_POST['fromRow']][$_POST['fromCol']] & BLACK)

			$targetRow = 0;

		else

			$targetRow = 7;

		

		/* determine if move results in pawn promotion */

		if ((($board[$_POST['fromRow']][$_POST['fromCol']] & COLOR_MASK) == PAWN) && ($_POST['toRow'] == $targetRow))

			$isPromoting = true;

		else

			$isPromoting = false;



		/* determine who's playing based on number of moves so far */

		if (($numMoves == -1) || ($numMoves % 2 == 1))

		{

			$curColor = "white";

			$oppColor = "black";

		}

		else

		{

			$curColor = "black";

			$oppColor = "white";

		}



		/* add move to history */

		$numMoves++;

		$history[$numMoves]['gamedID'] = $_SESSION['gameID'];

		$history[$numMoves]['curPiece'] = getPieceName($board[$_POST['fromRow']][$_POST['fromCol']]);

		$history[$numMoves]['curColor'] = $curColor;

		$history[$numMoves]['fromRow'] = $_POST['fromRow'];

		$history[$numMoves]['fromCol'] = $_POST['fromCol'];

		$history[$numMoves]['toRow'] = $_POST['toRow'];

		$history[$numMoves]['toCol'] = $_POST['toCol'];

		$history[$numMoves]['promotedTo'] = null;



		if ($isInCheck)

			$history[$numMoves]['isInCheck'] = 1;

		else

			$history[$numMoves]['isInCheck'] = 0;



		if (DEBUG)

		{

			if ($history[$numMoves]['curPiece'] == '')

				echo ("WARNING!!!  missing piece at ".$_POST['fromRow'].", ".$_POST['fromCol'].": ".$board[$_POST['fromRow']][$_POST['fromCol']]."<p>\n");

		}



		if ($board[$_POST['toRow']][$_POST['toCol']] == 0)

		{

			$tmpQuery = "INSERT INTO " . $CFG_TABLE[history] . " (hi_timeofmove, hi_gameid, hi_curpiece, hi_curcolor, hi_fromrow, hi_fromcol, hi_torow, hi_tocol, hi_replaced, hi_promotedto, hi_isIncheck) VALUES (Now(), ".$_SESSION['gameID'].", '".getPieceName($board[$_POST['fromRow']][$_POST['fromCol']])."', '$curColor', ".$_POST['fromRow'].", ".$_POST['fromCol'].", ".$_POST['toRow'].", ".$_POST['toCol'].", null, null, ".$history[$numMoves]['isInCheck'].")"; 

			$history[$numMoves]['replaced'] = null;

			$tmpReplaced = "";

		}

		else

		{

			$tmpQuery = "INSERT INTO " . $CFG_TABLE[history] . " (hi_timeofmove, hi_gameid, hi_curpiece, hi_curcolor, hi_fromrow, hi_fromcol, hi_torow, hi_tocol, hi_replaced, hi_promotedto, hi_isIncheck) VALUES (Now(), ".$_SESSION['gameID'].", '".getPieceName($board[$_POST['fromRow']][$_POST['fromCol']])."', '$curColor', ".$_POST['fromRow'].", ".$_POST['fromCol'].", ".$_POST['toRow'].", ".$_POST['toCol'].", '".getPieceName($board[$_POST['toRow']][$_POST['toCol']])."', null, ".$history[$numMoves]['isInCheck'].")"; 



			$history[$numMoves]['replaced'] = getPieceName($board[$_POST['toRow']][$_POST['toCol']]);

			$tmpReplaced = $history[$numMoves]['replaced'];

		}



		mysql_query($tmpQuery);



		/* if email notification is activated and move does not result in a pawn's promotion... */

		/* NOTE: moves resulting in pawn promotion are handled by savePromotion() above */

		if ($CFG_USEEMAILNOTIFICATION && !$isPromoting && ! $_SESSION['isSharedPC'])

		{

			/* get opponent's player ID */

			if ($oppColor == 'white')

				$tmpOpponentID = mysql_query("SELECT ga_whiteplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

			else

				$tmpOpponentID = mysql_query("SELECT ga_blackplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

			

			$opponentID = mysql_result($tmpOpponentID, 0);

		}

	}



	function loadGame()

	{

		global $CFG_TABLE;

		global $board, $playersColor;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		/* clear board data */

		for ($i = 0; $i < 8; $i++)

			for ($j = 0; $j < 8; $j++)

				$board[$i][$j] = 0;



		/* get data from database */

		$pieces = mysql_query("SELECT * FROM " . $CFG_TABLE[pieces] . " WHERE pi_gameid= ".$_SESSION['gameID']);



		/* setup board */

		while ($thisPiece = mysql_fetch_array($pieces, MYSQL_ASSOC))

		{

			$board[$thisPiece["pi_row"]][$thisPiece["pi_col"]] = getPieceCode($thisPiece["pi_color"], $thisPiece["pi_piece"]);

		}

		

		/* get current player's color */

		$tmpQuery = "SELECT ga_whiteplayer, ga_blackplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID'];

		$tmpTurns = mysql_query($tmpQuery);

		$tmpTurn = mysql_fetch_array($tmpTurns, MYSQL_ASSOC);



		if ($tmpTurn['ga_whiteplayer'] == $_SESSION['playerID'])

			$playersColor = "white";

		else

			$playersColor = "black";

	}



	function saveGame()

	{

		global $CFG_TABLE;

		global $board, $playersColor;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		/* clear old data */

		mysql_query("DELETE FROM " . $CFG_TABLE[pieces] . " WHERE pi_gameid = ".$_SESSION['gameID']);



		/* save new game data */

		/* for each row... */

		for ($i = 0; $i < 8; $i++)

		{

			/* for each col... */

			for ($j = 0; $j < 8; $j++)

			{

				/* if there's a piece at that pos on the board */

				if ($board[$i][$j] != 0)

				{

					/* updated the database */

					if ($board[$i][$j] & BLACK)

						$tmpColor = "black";

					else

						$tmpColor = "white";



					$tmpPiece = getPieceName($board[$i][$j]);

					mysql_query("INSERT INTO " . $CFG_TABLE[pieces] . " (pi_gameid, pi_color, pi_piece, pi_row, pi_col) VALUES (".$_SESSION['gameID'].", '$tmpColor', '$tmpPiece', $i, $j)");

				}

			}

		}



		/* update lastMove timestamp */

		updateTimestamp();

	}



	function processMessages()

	{

		global $CFG_TABLE;

		global $isUndoRequested, $isDrawRequested, $isUndoing, $isGameOver, $isCheckMate, $playersColor, $numMoves, $statusMessage, $CFG_USEEMAILNOTIFICATION;



		/* old PHP versions don't have _POST, _GET and _SESSION as auto_globals */

		if (!minimum_version("4.1.0"))

			global $_POST, $_GET, $_SESSION;

		

		if (DEBUG)

			echo("Entering processMessages()<br>\n");



		$isUndoRequested = false;

		$isGameOver = false;

		

		/* find out which player (black or white) we are serving */

		/* NOTE: When playing in the same computer $playersColor is always the player who logged in first */

		if (DEBUG)

			echo("SharedPC..." . $_SESSION['isSharedPC'] . "<br>\n");

		if ($_SESSION['isSharedPC'])	// Only the player to move is active in this case

			if( ( (($numMoves == -1) || (($numMoves % 2) == 1)) && ($playersColor == "white")) ||

				((($numMoves % 2) == 0) && ($playersColor == "black")) )

				$currentPlayer = $playersColor;

			else						// The player who logged in later is to move

				if($playersColor == "white")

					$currentPlayer = "black";

				else

					$currentPlayer = "white";

		else 							// The players are on different computers

			$currentPlayer = $playersColor;



		if ($currentPlayer == "white")

			$opponentColor = "black";

		else

			$opponentColor = "white";



		/* *********************************************** */

		/* queue user generated (ie: using forms) messages */

		/* *********************************************** */

		if (DEBUG)

			echo("Processing user generated (ie: form) messages...<br>\n");



		/* queue a request for an undo */

		if ($_POST['requestUndo'] == "yes")

		{

			/* if the two players are on the same system, execute undo immediately */

			/* NOTE: assumes the two players discussed it live before undoing */

			if ($_SESSION['isSharedPC'])

				$isUndoing = true;

			else

			{

				$tmpQuery = "INSERT INTO messages (me_gameid, me_msgtype, me_msgstatus, me_destination) VALUES (".$_SESSION['gameID'].", 'undo', 'request', '".$opponentColor."')";

				mysql_query($tmpQuery);

                                // ToDo: Mail an undo request notice to other player??

			}

			

			updateTimestamp();

		}

		

		/* queue a request for a draw */

		if ($_POST['requestDraw'] == "yes")

		{

			/* if the two players are on the same system, execute Draw immediately */

			/* NOTE: assumes the two players discussed it live before declaring the game a draw */

			if ($_SESSION['isSharedPC'])

			{

				$tmpQuery = "UPDATE games SET ga_gamemessage = 'draw', ga_messagefrom = '".$currentPlayer."' WHERE ga_gameid = ".$_SESSION['gameID'];

				mysql_query($tmpQuery);

			}

			else

			{

				$tmpQuery = "INSERT INTO messages (me_gameid, me_msgtype, me_msgstatus, me_destination) VALUES (".$_SESSION['gameID'].", 'draw', 'request', '".$opponentColor."')";

				mysql_query($tmpQuery);

			}



			updateTimestamp();

		}



		/* response to a request for an undo */

		if (isset($_POST['undoResponse']))

		{

			if ($_POST['isUndoResponseDone'] == 'yes')

			{

				if ($_POST['undoResponse'] == "yes")

				{

					$tmpStatus = "approved";

					$isUndoing = true;

				}

				else

					$tmpStatus = "denied";

			

				$tmpQuery = "UPDATE messages SET me_msgstatus = '".$tmpStatus."', me_destination = '".$opponentColor."' WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'undo' AND me_msgstatus = 'request' AND me_destination = '".$currentPlayer."'";

				mysql_query($tmpQuery);

			

				updateTimestamp();

			}

		}

		

		/* response to a request for a draw */

		if (isset($_POST['drawResponse']))

		{

			if ($_POST['isDrawResponseDone'] == 'yes')

			{

				if ($_POST['drawResponse'] == "yes")

				{

					$tmpStatus = "approved";

					$tmpQuery = "UPDATE games SET ga_gameMmssage = 'draw', ga_messagefrom = '".$currentPlayer."' WHERE ga_gameid = ".$_SESSION['gameID'];

					mysql_query($tmpQuery);

				}

				else

					$tmpStatus = "denied";

			

				$tmpQuery = "UPDATE messages SET me_msgstatus = '".$tmpStatus."', me_destination = '".$opponentColor."' WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'draw' AND me_msgstatus = 'request' AND me_destination = '".$currentPlayer."'";

				mysql_query($tmpQuery);



				updateTimestamp();

			}

		}

		

		/* resign the game */

		if ($_POST['resign'] == "yes")

		{

			$tmpQuery = "UPDATE " . $CFG_TABLE[games] . " SET ga_gamemessage = 'playerResigned', ga_messagefrom = '".$currentPlayer."' WHERE ga_gameid = ".$_SESSION['gameID'];

			mysql_query($tmpQuery);



			updateTimestamp();



			/* if email notification is activated... */

			if ($CFG_USEEMAILNOTIFICATION && ! $_SESSION['isSharedPC'])

			{

				/* get opponent's player ID */

				if ($currentPlayer == 'white')

					$tmpOpponentID = mysql_query("SELECT ga_blackplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

				else

					$tmpOpponentID = mysql_query("SELECT ga_whiteplayer FROM " . $CFG_TABLE[games] . " WHERE ga_gameid = ".$_SESSION['gameID']);

				

				$opponentID = mysql_result($tmpOpponentID, 0);

			

				$tmpOpponentEmail = mysql_query("SELECT value FROM " . $CFG_TABLE[preferences] . " WHERE playerID = ".$opponentID." AND preference = 'emailNotification'");

				

				/* if opponent is using email notification... */

				if (mysql_num_rows($tmpOpponentEmail) > 0)

				{

					$opponentEmail = mysql_result($tmpOpponentEmail, 0);

					if ($opponentEmail != '')

					{

						/* notify opponent of resignation via email */

						webchessMail('resignation', $opponentEmail, '', $_SESSION['nick'], $_SESSION['gameID']);

					}

				}

			}

		}

		

		

		/* ******************************************* */

		/* process queued messages (ie: from database) */

		/* ******************************************* */

		$tmpQuery = "SELECT * FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_destination = '".$currentPlayer."'";

		$tmpMessages = mysql_query($tmpQuery);



		while($tmpMessage = mysql_fetch_array($tmpMessages, MYSQL_ASSOC))

		{

			switch($tmpMessage['msgType'])

			{

				case 'undo':

					switch($tmpMessage['msgStatus'])

					{

						case 'request':

							$isUndoRequested = true;

							break;

						case 'approved':

							$tmpQuery = "DELETE FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'undo' AND me_msgstatus = 'approved' AND me_destination = '".$currentPlayer."'";

							mysql_query($tmpQuery);

							$statusMessage .= "Undo approved";

							break;

						case 'denied':

							$isUndoing = false;

							$tmpQuery = "DELETE FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'undo' AND me_msgstatus = 'denied' AND me_destination = '".$currentPlayer."'";

							mysql_query($tmpQuery);

							$statusMessage .= "Undo denied";

							break;

					}

					break;

				

				case 'draw':

					switch($tmpMessage['msgStatus'])

					{

						case 'request':

							$isDrawRequested = true;

							break;

						case 'approved':

							$tmpQuery = "DELETE FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'draw' AND me_msgstatus = 'approved' AND me_destination = '".$currentPlayer."'";

							mysql_query($tmpQuery);

							$statusMessage .= "Draw approved";

							break;

						case 'denied':

							$tmpQuery = "DELETE FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgtype = 'draw' AND me_msgstatus = 'denied' AND me_destination = '".$currentPlayer."'";

							mysql_query($tmpQuery);

							$statusMessage .= "Draw denied";

							break;

					}

					break;

			}

		}



		/* requests pending */

		$tmpQuery = "SELECT * FROM messages WHERE me_gameid = ".$_SESSION['gameID']." AND me_msgstatus = 'request' AND me_destination = '".$opponentColor."'";

		$tmpMessages = mysql_query($tmpQuery);



		while($tmpMessage = mysql_fetch_array($tmpMessages, MYSQL_ASSOC))

		{

			switch($tmpMessage['msgType'])

			{

				case 'undo':

					$statusMessage .= "Your undo request is pending";

					break;

				case 'draw':

					$statusMessage .= "Your request for a draw is pending";

					break;

			}

		}	

		

		/* game level status: draws, resignations and checkmate */

		/* if checkmate, update games table */

		if ($_POST['isCheckMate'] == 'true')

			mysql_query("UPDATE games SET ga_gamemessage = 'checkMate', ga_messagefrom = '".$currentPlayer."' WHERE ga_gameid = ".$_SESSION['gameID']);

                        // ToDo: Mail checkmate notification to opponent



		$tmpQuery = "SELECT ga_gamemessage, ga_messagefrom FROM games WHERE ga_gameid = ".$_SESSION['gameID'];

		$tmpMessages = mysql_query($tmpQuery);

		$tmpMessage = mysql_fetch_array($tmpMessages, MYSQL_ASSOC);

		

		if ($tmpMessage['ga_gamemessage'] == "draw")

		{

			$statusMessage .= "Game ended in a draw";

			$isGameOver = true;

		}



		if ($tmpMessage['ga_gamemessage'] == "playerResigned")

		{

			$statusMessage .= $tmpMessage['ga_messagefrom']." has resigned the game";

			$isGameOver = true;

		}



		if ($tmpMessage['ga_gamemessage'] == "checkMate")

		{

			$statusMessage .= "Checkmate! ".$tmpMessage['ga_messagefrom']." has won the game";

			$isGameOver = true;

			$isCheckMate = true;

		}

	}

?>