public static function from_user($uid, stdClass $config)
{
$where = "";
if (property_exists($config, 'min')) {
$where .= " AND p.id < '{$config->min}'";
}
if (property_exists($config, 'max')) {
$where .= " AND p.id < '{$config->max}'";
}
Phalanx::loadClasses('Posts', 'PostComments', 'PostCategory');
$m = Model::Factory('posts p', true, 120);
$m->fields('DISTINCT p.id AS id', 'p.user_id AS user_id', 'p.content AS content', 'p.date AS date', 'p.title AS title', 'p.like_count AS likes', 'p.dislike_count AS dislikes', 'p.comment_count AS comments', 'p.reply_count AS replies', 'u.name AS name', 'u.login AS user', 'ud.avatar AS avatar');
$m->innerJoin('user u', 'u.id = p.user_id');
$m->leftJoin('user_data ud', 'ud.user_id = p.user_id');
$m->innerJoin('favorites f', 'f.posts_id = p.id');
$m->order('p.date DESC');
$m->where("f.user_id='{$uid}' AND wp_posts_ID IS NULL AND p.status=1 {$where}");
$m->limit(NUMBER_OF_POSTS_LOADED_PER_TIME);
$data = $m->all();
$ret = array();
foreach ($data as $v) {
$o = new stdClass();
$o->date = Date::RelativeTime($v->date);
$o->id = $v->id;
$o->name = $v->name;
$o->title = $v->title;
$o->avatar = $v->avatar;
$o->user_id = $v->user_id;
$o->rating = new stdClass();
$o->rating->megaboga = $v->likes;
$o->rating->whatever = $v->dislikes;
$o->my_rating = Posts::userRating($uid, $v->id);
$o->content = trim($v->content);
$o->comments = $v->comments;
$o->replies = $v->replies;
$o->user = $v->user;
$o->categories = PostCategory::from_post($v->id);
$o->is_favorite = true;
$ret[] = $o;
}
return $ret;
}
public static function build_from_list($uid, $list_id, stdClass $config)
{
Phalanx::loadClasses('Friendship');
$friends_ids = Friendship::get_friend_array($uid);
$friends_ids = implode(', ', $friends_ids);
$where = "";
if (property_exists($config, 'min')) {
$where .= " AND p.id < '{$config->min}'";
}
if (property_exists($config, 'max')) {
$where .= " AND p.id < '{$config->max}'";
}
Phalanx::loadClasses('Lists', 'SocialNetwork', 'Facebook', 'Twitter', 'twitteroauth', 'Instagram', 'PostCategory', 'Favorites', 'Profile');
$list = Lists::from_user($uid, $list_id);
$categories = array();
foreach ($list->categories as $category) {
$categories[] = $category->id;
}
if (sizeof($categories) > 0) {
Phalanx::loadClasses('Posts', 'PostComments');
$categories_ids = implode("', '", $categories);
$custom_tl = array();
$m = Model::Factory('posts p', false, 0);
$m->fields('DISTINCT p.id AS id', 'p.original_posts_id AS original_id', 'p.user_id AS user_id', 'p.content AS content', 'p.date AS date', 'p.title AS title', 'p.promoted AS promoted', 'u.name AS name', 'u.login AS user', 'ud.avatar AS avatar', 'p.like_count AS likes', 'p.dislike_count AS dislikes', 'p.comment_count AS comments', 'p.reblog_count AS reblogs', 'p.reply_count AS replies');
$m->innerJoin('user u', 'u.id = p.user_id');
$m->innerJoin('user_data ud', 'ud.user_id = p.user_id');
$m->innerJoin('posts_has_category phc', 'p.id = phc.posts_id');
$m->where("p.user_id IN({$friends_ids}) AND phc.category_id IN ('{$categories_ids}') {$where} AND u.banned IS NULL AND p.status=1 AND p.date > DATE_SUB(NOW(), INTERVAL 1 MONTH)");
# $m->group("p.original_posts_id");
$m->order('p.id DESC');
$m->limit(NUMBER_OF_POSTS_LOADED_PER_TIME);
$skynerd_posts = $m->all();
foreach ($skynerd_posts as $each) {
$o = new stdClass();
$o->date = Date::RelativeTime($each->date);
$o->id = $each->id;
$o->user = $each->user;
$o->name = $each->name;
$o->title = $each->title;
$o->avatar = $each->avatar;
$o->user_id = $each->user_id;
$o->rating = new stdClass();
$o->rating->megaboga = $each->likes;
$o->rating->whatever = $each->dislikes;
$o->my_rating = Posts::userRating($uid, $each->id);
$o->content = trim($each->content);
$o->comments = $v->comments;
$o->replies = $v->replies;
$o->categories = PostCategory::from_post($each->id);
$o->is_reblogged = Posts::userHasReblogged($each->id, $uid);
$o->is_favorite = Favorites::is_favorite($uid, $each->id);
$o->user_points = Profile::experience($v->user_id);
$o->promoted = (bool) $each->promoted;
if (!empty($o->original_id)) {
//Se o post for um reblog, então o conteúdo dele deve ser o do reblogado, mostrando as ações
$originalPost = Posts::from_user(false, $o->original_id);
$originalPost = reset($originalPost);
$o->content = $originalPost->content;
$o->title = $originalPost->title;
$o->reblogged_from = $originalPost->user;
$o->original_date = $originalPost->date;
$o->rating->reblog_count = $originalPost->rating->reblog_count;
$o->is_reblogged = Posts::userHasReblogged($originalPost->id, $uid);
}
$custom_tl[] = $o;
}
}
return $custom_tl;
}
public function DisplayPost()
{
if ($this->get->username == 'wordpressagent') {
Request::redirect(HOST);
}
Phalanx::loadClasses('Profile', 'Friendship', 'Posts');
$profile_data = Profile::get_profile($this->get->username, 0, 0, 0, 0, 0, 0, 0);
if ($profile_data->banned == 1) {
$this->views->display("profile_banned.phtml");
return;
}
if ($profile_data->active == 0) {
$this->views->display("profile_deactivated.phtml");
return;
}
$friendship_status = Friendship::get_status($this->session->user->id, $profile_data->id);
$this->views->data->friendship_status = $friendship_status;
$this->views->data = $profile_data;
$p = Posts::from_user($profile_data->id, $this->get->post_id);
if (!$p) {
$this->views->display("post_unavailable.phtml");
return;
}
$p = reset($p);
$can_be_displayed = true;
#Verifica se o post é privado.
if ($p->privacy == 1) {
if (!$this->session->user->id) {
$this->views->display("post_unavailable.phtml");
die;
}
if ($this->session->user->id == $p->user_id) {
$can_be_displayed = true;
} else {
$can_be_displayed = Friendship::get_status($this->session->user->id, $p->user_id);
}
}
if (!$can_be_displayed) {
$this->views->display("post_unavailable.phtml");
die;
}
$v = new Views();
$v->title = $p->title;
$v->user = $p->user;
$v->name = $p->name;
$v->content = $p->content;
$v->comments = $p->comments;
$v->comments_array = PostComments::get($this->get->post_id);
$v->replies = $p->replies;
$v->post_id = $p->id;
$v->original_id = $p->original_id;
$v->avatar = $p->avatar;
$v->rating = $p->rating;
$v->promoted = (bool) $p->promoted;
$v->accept_nsfw = Profile::acceptNSFW($this->session->user->id);
$v->when = $p->date;
$v->my_rating = $p->my_rating;
$v->current_user = $this->session->user->login;
$v->categories = PostCategory::from_post($p->id);
$v->its_mine = $profile_data->id == $this->session->user->id ? true : false;
$v->is_favorite = $p->is_favorite;
$v->user_points = $p->user_points;
if (!empty($p->original_id)) {
//Se o post for um reblog, então o conteúdo dele deve ser o do reblogado, mostrando as ações
$originalPost = Posts::from_user(false, $p->original_id);
$originalPost = reset($originalPost);
$v->content = $originalPost->content;
$v->title = $originalPost->title;
$v->reblogged_from = $originalPost->user;
$v->reblog_avatar = $originalPost->avatar;
$v->reblog_points = $originalPost->user_points;
$v->original_date = $originalPost->date;
$v->rating = $originalPost->rating;
$v->comments = $originalPost->comments;
$v->replies = $originalPost->replies;
$v->is_favorite = $originalPost->is_favorite;
$v->categories = PostCategory::from_post($p->original_id);
$v->comments_array = PostComments::get($p->original_id);
$v->id = $p->id;
$v->post_id = $originalPost->id;
}
$content = $v->render("post_body.phtml");
$template = new Template("default");
$template->og = new stdClass();
$template->og->title = $v->user . ': ' . $v->title;
$template->og->description = $p->content;
$template->og->type = FACEBOOK_APPNAMESPACE . ':article_';
$template->og->img = MEDIA_DIR . 'images/avatar/big/' . $p->avatar;
if (!$this->isLoggedIn) {
$template->show_login_bar = true;
}
$this->views = new Views($template);
$this->views->data = $profile_data;
$this->views->data->friendship_status = $friendship_status;
$this->views->data->post = $content;
$this->views->display("single_post_display.phtml");
}
public static function exportFromUser($uid)
{
Phalanx::loadClasses('PostCategory', 'PostComments', 'Favorites');
$m = Model::Factory('posts p', 0);
$m->fields('p.id AS id', 'p.original_posts_id AS original_id', 'p.title AS title', 'p.user_id AS user_id', 'p.content AS content', 'p.date AS date', 'p.public AS privacy', 'p.like_count AS likes', 'p.dislike_count AS dislikes', 'p.reblog_count AS reblogs', 'p.comment_count AS comments', 'p.reply_count AS replies', 'p.promoted AS promoted', 'u.name AS name', 'u.login AS user', 'ud.avatar AS avatar');
$m->innerJoin('user u', 'u.id = p.user_id');
$m->innerJoin('user_data ud', 'ud.user_id = p.user_id');
$m->order('p.id DESC');
$where = array();
$where[] = "p.status=1";
$where[] = "p.original_posts_id IS NULL";
if ($uid) {
$where[] = "p.user_id = '{$uid}'";
}
$where = implode(" AND ", $where);
$m->where($where);
$data = $m->all();
$ret = array();
$Session = new Session();
foreach ($data as $v) {
$o = new stdClass();
$o->date = Date::RelativeTime($v->date);
$o->id = $v->id;
$o->original_id = $v->original_id;
$o->title = $v->title;
$o->user = $v->user;
$o->name = $v->name;
$o->avatar = $v->avatar;
$o->user_id = $v->user_id;
$o->content = trim($v->content);
$o->rating = new stdClass();
$o->rating->whatever = (int) abs($v->dislikes);
$o->rating->megaboga = (int) abs($v->likes);
$o->rating->reblog_count = (int) abs($v->reblogs);
$o->my_rating = self::userRating($Session->user->id, $v->id);
$o->is_reblogged = self::userHasReblogged($o->original_id, $Session->user->id);
$o->categories = PostCategory::from_post($v->id);
$o->comments = $v->comments;
$o->comments_array = PostComments::get($v->id);
$o->replies = $v->replies;
$o->privacy = $v->privacy;
$o->promoted = $v->promoted;
$o->is_favorite = Favorites::is_favorite($uid, $v->id);
$o->user_points = Profile::experience($v->user_id);
if (!empty($o->original_id)) {
//Se o post for um reblog, então o conteúdo dele deve ser o do reblogado, mostrando as ações
$originalPost = self::from_user(false, $o->original_id);
$originalPost = reset($originalPost);
$o->content = $originalPost->content;
$o->title = $originalPost->title;
$o->reblogged_from = $originalPost->user;
$o->original_date = $originalPost->date;
$o->rating->reblog_count = $originalPost->rating->reblog_count;
}
$ret[] = $o;
}
return $ret;
}
