/Control/SendGameRequest.php

<?php

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

require_once('PHPMailer/class.phpmailer.php');

require_once('RegisterLogic.php');

ob_start();



$Id = $_GET['ID'];

$Username = $_SESSION['username'];



if(!empty($Id)) {

	if(AddGameNotification($Username, $Id)) {

		echo 'Success';

	} else {

		echo 'fail';

	}

}



function AddGameNotification($From, $To) {

	$From;

	$To;

	$QueryFrom = "SELECT * FROM `user` WHERE `us_username` ='".$From."'";

	$QueryTo = "SELECT * FROM `user` WHERE `us_username` ='".$To."'";

	

	if($QueryFromRun = mysql_query($QueryFrom)) {

	    if (mysql_num_rows($QueryFromRun) == 1) {

			$FromId = mysql_result ($QueryFromRun, 0, 'us_id');

		}

	}

	

	if($QueryToRun = mysql_query($QueryTo)) {		

		if (mysql_num_rows($QueryToRun) == 1) {

			$ToId = mysql_result ($QueryToRun, 0, 'us_id');

		}

	}

	

	$Sql = "INSERT INTO games VALUES ('','".$FromId."','".$ToId."','playerInvited','white',NOW(),'',1)"; 

	if ($Result = mysql_query($Sql)) {

		return true;

	} else {

		return false;

	}			

}



/*function AddGameNotification($From, $To) {

	$Query = "SELECT * FROM `user` WHERE `us_username` ='".$To."'";

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

	    if (mysql_num_rows($QueryRun) == 1) {

			$Status = mysql_result ($QueryRun, 0, 'us_status');

			if($Status = 'LoggedIn') {

				$sql = "INSERT INTO games VALUES ('','".$From."','".$To."','playerInvited','white',NOW(),'',1)"; 

			} else {

				$sql = "INSERT INTO games VALUES ('','".$From."','".$To."','playerInvited','white',NOW(),'',0)";

			}

			if ($result = mysql_query($sql)) {

				return true;

			} else {

				return false;

			}

		}

	}

}*/





?>