/Control/DeclineGameRequest.php

<?php



$Id = $_GET['Id'];



require '../Model/Connect.php';

require 'SendNotification.php';

require_once('RegisterLogic.php');

ob_start();



if(!empty($Id)) {

	if(DeleteGame($Id)) {

		echo 'req is deleted';

	} else {

		echo 'fail';

	}

}



function DeleteGame($Id) {

	$SelectQuery = "SELECT * FROM games WHERE ga_gameid =".$Id." ";

	$RunSelectQuery = mysql_query($SelectQuery);

	if($RunSelectQuery) {

		//send the message to the sender 

		while($Info = mysql_fetch_array($RunSelectQuery)) {

			$Notify = new Notification();

			$ToID = $Info['ga_whiteplayer'];

			$To = GetUserName($ToID);

			$InvitedPlayerID = $Info['ga_blackplayer'];

			$InvitedPlayerName = GetPlayerName($InvitedPlayerID);

			$From = 'Site Administrator';

			$Message = 'Please notice that your game request to '.$InvitedPlayerName.' has been declined. Thank You';

			//echo $To = GetUserName($Sender);

			$MessageID = GetMaxMID();

			

			$Result = $Notify->SendMessage($To,$From,$Message,$MessageID,time());

			if($Result) { 

				echo '  send';

			} else {

				echo ' not send';

			}

		}

		

		$Query = "DELETE FROM games WHERE ga_gameid = ".$Id." ";

		if($QueryRun = mysql_query($Query)) {

			//send a message to the request sender saying that his/her req has been declined by the reciever

			return true;

		} else {

			return false;

		}

	}

}

function GetFullName($FullName) {

	$GetUsernameTo = "SELECT mp_fullName FROM memberprofile WHERE mp_userName = '".$FullName."' ";

	$ResultUsernameTo = mysql_query($GetUsernameTo);

	if ($ResultUsernameTo) {

		$rows = mysql_num_rows($ResultUsernameTo); 

		while($info = mysql_fetch_assoc( $ResultUsernameTo)) {

			return $info['mp_fullName'];

		}

	}

}



function GetUserName($PlayerID) {

	$GetUsername = "SELECT us_username FROM user WHERE playerID = '".$PlayerID."' ";

	$ResultUsername = mysql_query($GetUsername);

	if ($ResultUsername) {

		$rows = mysql_num_rows($ResultUsername); 

		while($info = mysql_fetch_assoc( $ResultUsername)) {

			return $info['us_username'];

		}

	}

}

    

function GetMaxMID() {

	$sql = "SELECT max(no_ID)+1 AS x FROM notify ";

    $ResultSql = mysql_query($sql);

    if ($ResultSql) {

    	$rows = mysql_num_rows($ResultSql); 

    	while($info = mysql_fetch_assoc( $ResultSql)) {

    		return $info['x'];

    	}

    } 

}



function GetPlayerName($PlayerID) {

    $Player = mysql_query("SELECT DISTINCT m.mp_fullname FROM memberprofile m,user u WHERE u.playerID = ".$PlayerID." AND u.us_username = m.mp_username");

    $ChessPlayer = mysql_result($Player, 0);

   	return $ChessPlayer;

}

?>