public function approve()
{
$identity = Zend_Auth::getInstance()->getIdentity();
$db = Zend_Registry::get('db');
$approved = array('approved' => 1, 'reviewer_id' => $identity->getId(), 'date_revised' => new Zend_Db_Expr('NOW()'));
$db->update('PageRev', $approved, 'revision_id = ' . $this->getId());
$page = new SxCms_Page();
$page->setId($this->getPageId())->loadState();
$page->setLanguage($this->getLanguage())->setTitle($this->getTitle())->setTitleFallback($this->hasTitleFallback())->setSummary($this->getSummary())->setSummaryFallback($this->hasSummaryFallback())->setContent($this->getContent())->setContentFallback($this->hasContentFallback())->setSource($this->getSource())->setSourceFallback($this->hasSourceFallback())->setLink($this->getLink())->setInvisible($this->getInvisible())->setSeoTitle($this->getSeoTitle())->setSeoTags($this->getSeoTags())->setSeoDescription($this->getSeoDescription());
$page->publish();
}
