<?
/*
 * addChat, getChat functions
*/
include_once('sqlEmbedded.php');

define('CHAT_ROWS_TO_KEEP', 75);


function isMuted($userID) {
	global $mysqli;
	
	$sql = "SELECT `dateChatGaggedUntil` FROM `users` 
	WHERE `ID` = ?
	AND `dateChatGaggedUntil` > NOW()";
	$stmt = $mysqli->prepare($sql);
	$stmt->bind_param("i", $userID);
	$stmt->execute();
	$stmt->bind_result($date);
	$stmt->fetch();
	if ($date) return $date;
	else return false;
}

function muteUser($userID, $numMinutes) {
	global $mysqli;
	$stmt = $mysqli->prepare("UPDATE `users` 
	SET `dateChatGaggedUntil` = ADDDATE(NOW(), INTERVAL ? MINUTE) 
	WHERE `ID` = ?");
	$stmt->bind_param('ii', $numMinutes, $userID);
	$stmt->execute();
	return;
}

function addChat($userID, $message) {
	global $mysqli;
	if ($message == '') return;
	
	$stmt = $mysqli->prepare("INSERT INTO `chat`
		(`userID`, `message`)
	VALUES (?, ?)");
	$stmt->bind_param('is', $userID, $message);
	$stmt->execute();
	
	$ID = $stmt->insert_id;
	$stmt->close();
	return $ID;
}

function getChat($startID = 0) {
	global $mysqli;
	$array = array();

	if (!is_numeric($startID))	return false;
	
	//Not sure why this happens; but just return nothing..
	if (!is_object($mysqli)) die("mysqli is not an object");
	
	$res = $mysqli->query("
	SELECT 
		chat.ID, chat.userID, chat.message, chat.dateSent,
		users.displayName,
		users.displayColor,
		users.wallColor,
		users.wallEmblem,
		users.wallOrientation
	FROM `chat`
		LEFT JOIN `users`
			ON chat.userID = users.ID
	WHERE chat.ID > '$startID'
	ORDER BY chat.ID ASC
	");
	$array = array();
	if ($res->num_rows == 0) {
		$res->close();
		return false;
	}
	while ($response = $res->fetch_assoc()) {
		$array[] = $response;
		$lastID = $response['ID'];
	}
	$res->close();
	
	if (count($array) < 1) return false;

	//Turnicate messages.
	$deleteFromID = $lastID - CHAT_ROWS_TO_KEEP;
	$mysqli->query("DELETE FROM `chat` WHERE `ID` < $deleteFromID");
	$mysqli->close();
	
	return $array;
}


?>