From 9c20000fb8871437dafb41ec830afbf56a746a57 Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Sun, 9 Jun 2013 01:03:03 -0500
Subject: Attempting to remove the multiple calls to getChat(); however, I seem
 to have broken chat...

---
 includes/chats.php | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

(limited to 'includes/chats.php')

diff --git a/includes/chats.php b/includes/chats.php
index 7db4c58..f55ce35 100644
--- a/includes/chats.php
+++ b/includes/chats.php
@@ -44,12 +44,17 @@ function addChat($userID, $message) {
 	
 	$ID = $stmt->insert_id;
 	$stmt->close();
+	
+	//Turnicate messages.
+	$deleteFromID = $ID - CHAT_ROWS_TO_KEEP;
+	$mysqli->query("DELETE FROM `chat` WHERE `ID` < $deleteFromID");
+	$mysqli->close();
+	
 	return $ID;
 }
 
 function getChat($startID = 0) {
 	global $mysqli;
-	$array = array();
 
 	if (!is_numeric($startID))	return false;
 	
@@ -68,7 +73,7 @@ function getChat($startID = 0) {
 		LEFT JOIN `users`
 			ON chat.userID = users.ID
 	WHERE chat.ID > '$startID'
-	ORDER BY chat.ID ASC
+	ORDER BY chat.dateSent ASC, chat.ID ASC
 	");
 	$array = array();
 	if ($res->num_rows == 0) {
@@ -77,16 +82,11 @@ function getChat($startID = 0) {
 	}
 	while ($response = $res->fetch_assoc()) {
 		$array[] = $response;
-		$lastID = $response['ID'];
 	}
 	$res->close();
+	$mysqli->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;
 }
-- 
cgit v1.2.3