execute(" SELECT clear_chats FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); $row = $db->fetch_array($result); $clear_chats = unserialize($row['clear_chats']); if (!empty($clear_chats)) { if (array_key_exists($chatbox, $clear_chats)) { $time_check = $clear_chats[$chatbox]; } else { $time_check = 0; } } else { $time_check = 0; } $lower_limit = 0; if (!empty($_POST['history']) AND is_numeric($_POST['history'])) { $lower_limit = 20 * ($_POST['history'] - 1); } $result = $db->execute(" SELECT arrowchat.id, arrowchat.from, arrowchat.to, arrowchat.message, arrowchat.sent, arrowchat.read FROM arrowchat WHERE ((arrowchat.to = '" . $db->escape_string($userid) . "' AND arrowchat.from = '" . $db->escape_string($chatbox) . "') OR (arrowchat.from = '" . $db->escape_string($userid) . "' AND arrowchat.to = '" . $db->escape_string($chatbox) . "')) AND (arrowchat.sent > " . $time_check . " OR (arrowchat.user_read = '0' AND arrowchat.to = '" . $db->escape_string($userid) . "')) ORDER BY arrowchat.id DESC LIMIT " . $db->escape_string($lower_limit) . ", 20 "); while ($chat = $db->fetch_array($result)) { $self = 0; $old = 0; if ($chat['from'] == $userid) { $chat['from'] = $chat['to']; $self = 1; $old = 1; } if ($chat['read'] == 1) { $old = 1; } $chat_message = $chat['message']; $chat_message = str_replace("\\'", "'", $chat_message); $chat_message = str_replace('\\"', '"', $chat_message); $chat_message = clickable_links($chat_message); $messages[] = array('id' => $chat['id'], 'from' => $chat['from'], 'message' => $chat_message, 'self' => $self, 'old' => $old, 'sent' => $chat['sent']); $timestamp = $chat['id']; } $db->execute(" UPDATE arrowchat SET arrowchat.user_read = '1' WHERE arrowchat.from = '" . $db->escape_string($chatbox) . "' AND arrowchat.to = '" . $db->escape_string($userid) . "' AND arrowchat.user_read = '0' "); } if (!empty($messages)) { $response['messages'] = array_reverse($messages); } } header('Content-type: application/json; charset=utf-8'); echo json_encode($response); close_session(); exit; ?>