/**
* 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 $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;
}
/**
* This implements an inbound webhook from MandrillApp to reply to posts using emails
*
*/
public function mailReplyAction()
{
$response = new Response();
if ($this->request->isPost()) {
if (!isset($this->config->mandrillapp->secret)) {
return $response;
}
if ($this->config->mandrillapp->secret != $this->request->getQuery('secret')) {
return $response;
}
$events = @json_decode($this->request->getPost('mandrill_events'), true);
if (!is_array($events)) {
return $response;
}
foreach ($events as $event) {
if (!isset($event['event'])) {
continue;
}
$type = $event['event'];
if ($type != 'inbound') {
continue;
}
if (!isset($event['msg'])) {
continue;
}
$msg = $event['msg'];
if (!isset($msg['dkim'])) {
continue;
}
if (!isset($msg['from_email'])) {
continue;
}
if (!isset($msg['email'])) {
continue;
}
if (!isset($msg['text'])) {
continue;
}
$content = $msg['text'];
if (!trim($content)) {
continue;
}
$user = Users::findFirstByEmail($msg['from_email']);
if (!$user) {
continue;
}
$email = $msg['email'];
if (!preg_match('#^reply-i([0-9]+)-([0-9]+)@phosphorum.com$#', $email, $matches)) {
continue;
}
$post = Posts::findFirst($matches[1]);
if (!$post) {
continue;
}
if ($post->deleted) {
continue;
}
/**
* Process replies to remove the base message
*/
$str = array();
$firstNoBaseReplyLine = false;
foreach (array_reverse(preg_split('/\\r\\n|\\n/', trim($content))) as $line) {
if (!$firstNoBaseReplyLine) {
if (substr($line, 0, 1) == '>') {
continue;
} else {
$firstNoBaseReplyLine = true;
}
}
if (preg_match('/^[0-9]{4}\\-[0-9]{2}\\-[0-9]{2} [0-9]{2}:[0-9]{2} GMT([\\-\\+][0-9]{2}:[0-9]{2})? ([^:]*):$/u', $line)) {
continue;
}
if (preg_match('/^On [A-Za-z]{3} [0-9]{1,2}, [0-9]{4} [0-9]{1,2}:[0-9]{2} [AP]M, ([^:]*):$/u', $line)) {
continue;
}
$str[] = $line;
}
$content = join("\r\n", array_reverse($str));
/**
* Check if the question can have a bounty before add the reply
*/
$canHaveBounty = $post->canHaveBounty();
/**
* Only update the number of replies if the user that commented isn't the same that posted
*/
if ($post->users_id != $user->id) {
$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->users_id = $user->id;
$postReply->content = $content;
if ($postReply->save()) {
if ($post->users_id != $user->id && $canHaveBounty) {
$bounty = $post->getBounty();
$postBounty = new PostsBounties();
$postBounty->posts_id = $post->id;
$postBounty->users_id = $users->id;
$postBounty->posts_replies_id = $postReply->id;
$postBounty->points = $bounty['value'];
if (!$postBounty->save()) {
foreach ($postBounty->getMessages() as $message) {
$this->flash->error($message);
}
}
}
}
}
}
return $response;
}
/**
* 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]);
}
$option->title = htmlspecialchars($opt, ENT_QUOTES);
if (!$option->save()) {
echo join(PHP_EOL, $option->getMessages()), PHP_EOL;
$database->rollback();
die;
}
$log->info('Option: ' . $option->title);
}
}
$log->info('Post: ' . $post->title);
}
$database->commit();
$postIds = Posts::find(['columns' => 'id'])->toArray();
$database->begin();
for ($i = 0; $i <= 1000; $i++) {
$reply = new PostsReplies();
$reply->content = $faker->paragraph();
$postRandId = array_rand($postIds);
$reply->posts_id = $postIds[$postRandId]['id'];
$userRandId = array_rand($userIds);
$reply->users_id = $userIds[$userRandId]['id'];
if (!$reply->save()) {
$database->rollback();
die(join(PHP_EOL, $reply->getMessages()));
}
$reply->post->number_replies++;
$reply->post->modified_at = time();
$reply->save();
$log->info('Reply to post: ' . $reply->posts_id);
}
$database->commit();