/**
* Save a comment object to the database
*
* @param SxCms_Comment $comment
* @return mixed
*/
public function save(SxCms_Comment $comment)
{
$db = Zend_Registry::get('db');
$author = $comment->getCommenter();
$data = array('page_id' => $comment->getPage()->getId(), 'comment' => $comment->getMessage(), 'datePosted' => date('Y-m-d H:i:s'), 'author_name' => $author->getName(), 'author_email' => $author->getEmail(), 'author_link' => $author->getWebsite(), 'approved' => $comment->isApproved(), 'dateApproved' => $comment->getDateApproved());
if (!$comment->getId()) {
$result = $db->insert('PageComment', $data);
$comment->setId($db->lastInsertId());
return $result;
}
return $db->update('PageComment', $data, 'comment_id = ' . $comment->getId());
}
public function commentDeleteAction()
{
SxCms_Acl::requireAcl('news', 'news.comments.delete');
$comment = new SxCms_Comment();
$comment->setId($this->_getParam('id'));
$mapper = new SxCms_Comment_DataMapper();
$mapper->delete($comment);
$flashMessenger = $this->_helper->getHelper('FlashMessenger');
$flashMessenger->addMessage($this->admin_tmx->_('messagedeletedsuccess'));
$this->_helper->redirector->gotoSimple('comments', 'page');
}
