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);
}
