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