function fetch_json_part($part) { if ($this->result) { return json_encode_strip($this->fetch_all_part($part)); } else { return "{}"; } }
} else { if (isset($_POST["post_id"])) { $post_id = $dao->escape($_POST["post_id"]); $query = "SELECT {$properties} FROM post JOIN user ON user.user_id=post.user_id WHERE post_id=\"{$post_id}\" ORDER BY post_time;"; } else { if (isset($selected_user)) { $query = "SELECT {$properties} FROM post JOIN user ON user.user_id=post.user_id WHERE post.group_id=\"-1\" AND post.user_id=\"{$selected_user->user_id}\" ORDER BY post_time DESC {$limit};"; } else { if (isset($selected_group)) { $query = "SELECT {$properties} FROM post JOIN user ON user.user_id=post.user_id WHERE post.group_id=\"{$selected_group->group_id}\" ORDER BY post_time DESC {$limit};"; } else { $query = "SELECT {$properties} FROM post JOIN user ON post.user_id=user.user_id " . "WHERE post.group_id=\"-1\" AND (post.user_id=\"{$user->user_id}\" OR \"{$user->user_id}\" in(SELECT user_id2 FROM connection WHERE user_id1=post.user_id) " . "OR \"{$user->user_id}\" in(SELECT user_id1 FROM connection WHERE user_id2=post.user_id) OR post.user_id=\"1\") " . " ORDER BY post_time DESC {$limit};"; } } } } $dao->myquery($query); $posts = $dao->fetch_all_obj(); foreach ($posts as $post) { if (isset($page_from)) { $post->page = $page_from; } $query = "SELECT comment.comment_id, \n\t\t\t\t\t\t comment.comment_content, \n\t\t\t\t\t\t user.user_name, \n\t\t\t\t\t\t user.user_id, \n\t\t\t\t\t\t user.user_picture, \n\t\t\t\t\t\t comment.comment_time, \n\t\t\t\t\t\t (user.user_id=\"{$user->user_id}\") AS can_delete \n\t\t\t\t\t\t FROM comment JOIN user ON user.user_id=comment.user_id \n\t\t\t\t\t\t WHERE comment.post_id=\"{$post->post_id}\" ORDER BY comment.comment_id ASC;"; $dao->myquery($query); $post->comments = $dao->fetch_all_obj(); foreach ($post->comments as $comment) { $comment->page = $page_from; } } echo json_encode_strip($posts);
} $conversation->messages[$message->msg_id] = $message; } return $conversations; } $dao = new DAO(false); if (isset($_POST["user_id"])) { if ($_POST["user_id"] == "-1") { //Get an array of all the conversations $conversations_query = "(SELECT user_id2 AS user_id FROM chat_msg WHERE user_id1={$user->user_id} GROUP BY user_id2) \n\t\t\t\t\t\t\t\t\tUNION \n\t\t\t\t\t\t\t\t\t(SELECT user_id1 AS user_id FROM chat_msg WHERE user_id2={$user->user_id} GROUP BY user_id1)"; $dao->myquery($conversations_query); $conversation_requests = $dao->fetch_all_part(array("user_id")); $conversations = array(); foreach ($conversation_requests as $request) { $c = get_conversations($dao, $request["user_id"], -1, -1)[$request["user_id"]]; $conversations[$request["user_id"]] = $c; } echo json_encode_strip($conversations); } else { $conversations = get_conversations($dao, $_POST["user_id"], -1, -1)[$_POST["user_id"]]; echo json_encode_strip($conversations); } } else { $conversation_requests = $_POST; $conversations = array(); foreach ($conversation_requests as $request) { $c = get_conversations($dao, $request["user_id"], $request["latest_pulled"], $request["latest_seen_by_u2"])[$request["user_id"]]; $conversations[$request["user_id"]] = $c; } echo json_encode_strip($conversations); }