/** * Displays a post and its comments * * @param $id * @param $slug * * @return \Phalcon\Http\ResponseInterface */ public function viewAction($id, $slug) { $id = (int) $id; $usersId = $this->session->get('identity'); if (!$this->request->isPost()) { /** * Find the post using get */ $post = Posts::findFirstById($id); if (!$post) { $this->flashSession->error('The tip does not exist'); return $this->response->redirect(); } if ($post->deleted) { $this->flashSession->error('The tip is deleted'); return $this->response->redirect(); } $ipAddress = $this->request->getClientAddress(); $parameters = array('posts_id = ?0 AND ipaddress = ?1', 'bind' => array($id, $ipAddress)); $viewed = PostsViews::count($parameters); /** * A view is stored by ipaddress */ if (!$viewed) { /** * Increase the number of views in the post */ $post->number_views++; if ($post->users_id != $usersId) { $post->user->increaseKarma(Karma::VISIT_ON_MY_POST); if ($usersId > 0) { /** @var Users $user */ $user = Users::findFirstById($usersId); if ($user) { if ($user->moderator == 'Y') { $user->increaseKarma(Karma::MODERATE_VISIT_POST); } else { $user->increaseKarma(Karma::VISIT_POST); } $user->save(); } } } $postView = new PostsViews(); $postView->post = $post; $postView->ipaddress = $ipAddress; if (!$postView->save()) { foreach ($postView->getMessages() as $message) { $this->flash->error($message); } } } if (!$usersId) { /** * Enable cache */ $this->view->cache(array('key' => 'post-' . $id)); /** * Check for a cache */ if ($this->viewCache->exists('post-' . $id)) { return; } } /** * Generate cannonical meta */ $this->view->canonical = 'discussion/' . $post->id . '/' . $post->slug; $this->view->author = $post->user; } else { if (!$this->checkTokenPost()) { return $this->response->redirect(); } if (!$usersId) { $this->flashSession->error('You must be logged in first to add a comment'); return $this->response->redirect(); } /** * Find the post using POST */ $post = Posts::findFirstById($this->request->getPost('id')); if (!$post) { $this->flashSession->error('The tip does not exist'); return $this->response->redirect(); } if ($post->deleted) { $this->flashSession->error('The tip is deleted'); return $this->response->redirect(); } $content = $this->request->getPost('content', 'trim'); if ($content) { /** * Check if the question can have a bounty before add the reply */ $canHaveBounty = $post->canHaveBounty(); $user = Users::findFirstById($usersId); if (!$user) { $this->flashSession->error('You must be logged in first to add a comment'); return $this->response->redirect(); } /** * Only update the number of replies if the user that commented isn't the same that posted */ if ($post->users_id != $usersId) { $post->number_replies++; $post->modified_at = time(); $post->user->increaseKarma(Karma::SOMEONE_REPLIED_TO_MY_POST); $user->increaseKarma(Karma::REPLY_ON_SOMEONE_ELSE_POST); $user->save(); } $postReply = new PostsReplies(); $postReply->post = $post; $postReply->in_reply_to_id = $this->request->getPost('reply-id', 'int'); $postReply->users_id = $usersId; $postReply->content = $content; if ($postReply->save()) { if ($post->users_id != $usersId && $canHaveBounty) { $bounty = $post->getBounty(); $postBounty = new PostsBounties(); $postBounty->posts_id = $post->id; $postBounty->users_id = $usersId; $postBounty->posts_replies_id = $postReply->id; $postBounty->points = $bounty['value']; if (!$postBounty->save()) { foreach ($postBounty->getMessages() as $message) { $this->flash->error($message); } } } $href = 'discussion/' . $post->id . '/' . $post->slug . '#C' . $postReply->id; return $this->response->redirect($href); } foreach ($postReply->getMessages() as $message) { $this->flash->error($message); } } } /** * Set the post name as title - escaping it first */ $this->tag->setTitle($this->escaper->escapeHtml($post->title) . ' - Tip'); $this->view->post = $post; }
/** * Displays a post and its comments * * @param int $id Post ID * @param string $slug Post slug * * @return \Phalcon\Http\ResponseInterface */ public function viewAction($id, $slug) { $id = (int) $id; // Check read / unread topic if ($usersId = $this->session->get('identity')) { $check_topic = new TopicTracking(); $check_topic->user_id = $usersId; $check_topic->topic_id = $id; if ($check_topic->create() == false) { $check_topic->updateTracking($id, $usersId); } } $this->gravatar->setSize(48); if (!$this->request->isPost()) { // Find the post using get $post = Posts::findFirstById($id); if (!$post) { $this->flashSession->error('The discussion does not exist'); return $this->response->redirect(); } if ($post->deleted) { $this->flashSession->error('The discussion is deleted'); return $this->response->redirect(); } $ipAddress = $this->request->getClientAddress(); $parameters = ['posts_id = ?0 AND ipaddress = ?1', 'bind' => [$id, $ipAddress]]; $viewed = PostsViews::count($parameters); // A view is stored by ip address if (!$viewed) { // Increase the number of views in the post $post->number_views++; if ($post->users_id != $usersId) { $post->user->increaseKarma(Karma::VISIT_ON_MY_POST); if ($usersId > 0) { $user = Users::findFirstById($usersId); if ($user) { if ($user->moderator == 'Y') { $user->increaseKarma(Karma::MODERATE_VISIT_POST); } else { $user->increaseKarma(Karma::VISIT_POST); } $user->save(); } } } $postView = new PostsViews(); $postView->post = $post; $postView->ipaddress = $ipAddress; if (!$postView->save()) { foreach ($postView->getMessages() as $message) { $this->flash->error($message); } } } if (!$usersId) { // Enable cache $this->view->cache(['key' => 'post-' . $id]); // Check for a cache if ($this->viewCache->exists('post-' . $id)) { return; } } // Generate canonical meta $this->view->setVars(['canonical' => 'discussion/' . $post->id . '/' . $post->slug, 'author' => $post->user]); } else { if (!$this->checkTokenPost()) { return $this->response->redirect(); } if (!$usersId) { $this->flashSession->error('You must be logged in first to add a comment'); return $this->response->redirect(); } // Find the post using POST $post = Posts::findFirstById($this->request->getPost('id')); if (!$post) { $this->flashSession->error('The discussion does not exist'); return $this->response->redirect(); } if ($post->deleted) { $this->flashSession->error('The discussion is deleted'); return $this->response->redirect(); } $content = $this->request->getPost('content', 'trim'); if ($content) { // Check if the question can have a bounty before add the reply $canHaveBounty = $post->canHaveBounty(); $user = Users::findFirstById($usersId); if (!$user) { $this->flashSession->error('You must be logged in first to add a comment'); return $this->response->redirect(); } // Only update the number of replies if the user that commented isn't the same that posted if ($post->users_id != $usersId) { $post->number_replies++; $post->modified_at = time(); $post->user->increaseKarma(Karma::SOMEONE_REPLIED_TO_MY_POST); $user->increaseKarma(Karma::REPLY_ON_SOMEONE_ELSE_POST); $user->save(); } $postReply = new PostsReplies(); $postReply->post = $post; $postReply->in_reply_to_id = $this->request->getPost('reply-id', 'int'); $postReply->users_id = $usersId; $postReply->content = $content; if ($postReply->save()) { if ($post->users_id != $usersId && $canHaveBounty) { $bounty = $post->getBounty(); $postBounty = new PostsBounties(); $postBounty->posts_id = $post->id; $postBounty->users_id = $usersId; $postBounty->posts_replies_id = $postReply->id; $postBounty->points = $bounty['value']; if (!$postBounty->save()) { foreach ($postBounty->getMessages() as $message) { $this->flash->error($message); } } } $href = 'discussion/' . $post->id . '/' . $post->slug . '#C' . $postReply->id; return $this->response->redirect($href); } foreach ($postReply->getMessages() as $message) { $this->flash->error($message); } } } /** * Set the post name as title - escaping it first */ $this->tag->setTitle($this->escaper->escapeHtml($post->title) . ' - Discussion'); $this->view->setVar('post', $post); }
/** * Displays a post and its comments * * @param int $id Post ID * @param string $slug Post slug [Optional] */ public function viewAction($id, $slug = '') { $id = (int) $id; // Check read / unread topic if ($usersId = $this->session->get('identity')) { $check_topic = new TopicTracking(); $check_topic->user_id = $usersId; $check_topic->topic_id = $id; if ($check_topic->create() == false) { $check_topic->updateTracking($id, $usersId); } } $this->gravatar->setSize(48); if (!$this->request->isPost()) { // Find the post using get if (!($post = Posts::findFirstById($id))) { $this->flashSession->error('The discussion does not exist'); $this->response->redirect(); return; } if ($post->deleted) { $this->flashSession->error('The discussion is deleted'); $this->response->redirect(); return; } $ipAddress = $this->request->getClientAddress(); $parameters = ['posts_id = ?0 AND ipaddress = ?1', 'bind' => [$id, $ipAddress]]; // A view is stored by ip address if (!($viewed = PostsViews::count($parameters))) { // Increase the number of views in the post $post->number_views++; if ($post->users_id != $usersId) { $post->user->increaseKarma(Karma::VISIT_ON_MY_POST); if ($user = Users::findFirstById($usersId)) { $user->increaseKarma($user->moderator == 'Y' ? Karma::MODERATE_VISIT_POST : Karma::VISIT_POST); $user->save(); } } $postView = new PostsViews(); $postView->post = $post; $postView->ipaddress = $ipAddress; if (!$postView->save()) { $this->flash->error(join('<br>', $postView->getMessages())); } } if (!$usersId) { // Enable cache $this->view->cache(['key' => 'post-' . $id]); // Check for a cache if ($this->viewCache->exists('post-' . $id)) { return; } } // Generate canonical meta $this->view->setVars(['canonical' => "discussion/{$post->id}/{$post->slug}", 'author' => $post->user]); } else { if (!$this->checkTokenPost()) { $this->response->redirect(); return; } if (!$usersId) { $this->flashSession->error('You must be logged in first to add a comment'); $this->response->redirect(); return; } // Find the post using POST if (!($post = Posts::findFirstById($this->request->getPost('id')))) { $this->flashSession->error('The discussion does not exist'); $this->response->redirect(); return; } if ($post->deleted) { $this->flashSession->error('The discussion is deleted'); $this->response->redirect(); return; } if ($content = $this->request->getPost('content', 'trim')) { // Check if the question can have a bounty before add the reply $canHaveBounty = $post->canHaveBounty(); if (!($user = Users::findFirstById($usersId))) { $this->flashSession->error('You must be logged in first to add a comment'); $this->response->redirect(); return; } // Only update the number of replies if the user that commented isn't the same that posted if ($post->users_id != $usersId) { $post->number_replies++; $post->modified_at = time(); $post->user->increaseKarma(Karma::SOMEONE_REPLIED_TO_MY_POST); $user->increaseKarma(Karma::REPLY_ON_SOMEONE_ELSE_POST); $user->save(); } $postReply = new PostsReplies(); $postReply->post = $post; $postReply->in_reply_to_id = $this->request->getPost('reply-id', 'int'); $postReply->users_id = $usersId; $postReply->content = $content; if ($postReply->save()) { if ($post->users_id != $usersId && $canHaveBounty) { $bounty = $post->getBounty(); $postBounty = new PostsBounties(); $postBounty->posts_id = $post->id; $postBounty->users_id = $usersId; $postBounty->posts_replies_id = $postReply->id; $postBounty->points = $bounty['value']; if (!$postBounty->save()) { $this->flash->error(join('<br>', $postBounty->getMessages())); } } $this->response->redirect("discussion/{$post->id}/{$post->slug}#C{$postReply->id}"); return; } $this->flash->error(join('<br>', $postReply->getMessages())); } } $voting = []; if ($post->hasPoll()) { $totalVotes = $post->getPollVotes()->count(); $votesCount = PostsPollVotes::count(['posts_id = ?0', 'group' => 'options_id', 'bind' => [$post->id]]); foreach ($votesCount as $row) { /** @var \Phalcon\Mvc\Model\Row $row */ $voting[$row->offsetGet('options_id')] = round($row->offsetGet('rowcount') * 100 / $totalVotes, 1); } } // Set the post name as title - escaping it first $this->tag->setTitle($this->escaper->escapeHtml($post->title) . ' - Discussion'); $this->view->setVars(['post' => $post, 'voted' => $post->isParticipatedInPoll($usersId), 'voting' => $voting]); }