From 1b40945878f33ab4b8af8089ea6c5be02b9d0761 Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Tue, 14 Jan 2014 02:59:16 -0800
Subject: Channellist preperations. - Fixes with regards to close() which
 apparently means DESTROY or something retarded.

---
 includes/chats.php | 77 +++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 file changed, 74 insertions(+), 3 deletions(-)

(limited to 'includes/chats.php')

diff --git a/includes/chats.php b/includes/chats.php
index f55ce35..0e48ecf 100644
--- a/includes/chats.php
+++ b/includes/chats.php
@@ -32,6 +32,8 @@ function muteUser($userID, $numMinutes) {
 	return;
 }
 
+
+
 function addChat($userID, $message) {
 	global $mysqli;
 	if ($message == '') return;
@@ -48,7 +50,6 @@ function addChat($userID, $message) {
 	//Turnicate messages.
 	$deleteFromID = $ID - CHAT_ROWS_TO_KEEP;
 	$mysqli->query("DELETE FROM `chat` WHERE `ID` < $deleteFromID");
-	$mysqli->close();
 	
 	return $ID;
 }
@@ -61,7 +62,7 @@ function getChat($startID = 0) {
 	//Not sure why this happens; but just return nothing..
 	if (!is_object($mysqli)) die("mysqli is not an object");
 	
-	$res = $mysqli->query("
+	if ($res = $mysqli->query("
 	SELECT 
 		chat.ID, chat.userID, chat.message, chat.dateSent,
 		users.displayName,
@@ -74,6 +75,76 @@ function getChat($startID = 0) {
 			ON chat.userID = users.ID
 	WHERE chat.ID > '$startID'
 	ORDER BY chat.dateSent ASC, chat.ID ASC
+	")) {
+		$array = array();
+		if ($res->num_rows == 0) {
+			$res->close();
+			return false;
+		}
+		while ($response = $res->fetch_assoc()) {
+			$array[] = $response;
+		}
+		$res->close();
+		if (count($array) < 1) return false;
+		return $array;
+	} else { 
+		printf("DError: %s\n", $mysqli->error); 
+		return false;
+	}
+
+}
+
+
+
+//Enters a user into a channel
+function enterChannel($userID, $channel = 1) {
+	global $mysqli;
+	$stmt = $mysqli->prepare("INSERT INTO `chatUsers`
+		(`userID`, `channel`, `dateEntered`, `isHere`)
+	VALUES (?, ?, NOW(), true)
+			
+	ON DUPLICATE KEY UPDATE `isHere` = true
+	");
+	$stmt->bind_param('ii', $userID, $channel);
+	$stmt->execute();
+	$stmt->close();
+	return;
+}
+
+//User leaves the channel
+function exitChannel($userID, $channel = 1) {
+	global $mysqli;
+	$stmt = $mysqli->prepare("UPDATE `chatUsers` 
+	SET `isHere` = false
+	WHERE `userID` = ? AND `channel` = ?");
+	$stmt->bind_param('ii', $userID, $channel);
+	$stmt->execute();
+	return;
+}
+
+//Get a list of users in channel
+function getChannelList($channel = 1) {
+	global $mysqli;
+
+	if (!is_numeric($channel))	return false;
+
+	$res = $mysqli->query("
+	SELECT 
+		chatUsers.userID, 
+		chatUsers.dateEntered,
+		chatUsers.dateLastActive,
+		chatUsers.isAdmin,
+		chatUsers.isMod,
+		
+		users.displayName,
+		users.displayColor,
+		users.wallColor,
+		users.wallEmblem,
+		users.wallOrientation
+	FROM `chatUsers`
+		LEFT JOIN `users`
+			ON chatUsers.userID = users.ID
+	ORDER BY chatUsers.isMod DESC, chatUsers.dateEntered DESC
 	");
 	$array = array();
 	if ($res->num_rows == 0) {
@@ -87,10 +158,10 @@ function getChat($startID = 0) {
 	$mysqli->close();
 	
 	if (count($array) < 1) return false;
-	
 	return $array;
 }
 
+
 function filterStringForBadLanguage($chat) {
    //cuss words
    $chat = str_ireplace("fuck you", "i am moron", $chat);
-- 
cgit v1.2.3