diff options
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/chats.php | 16 |
1 files changed, 8 insertions, 8 deletions
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;
}
|