/**
* @access public
* @param integer PageID
* @param integer Revision 0 = HEAD
* @return boolean Is true on success
*/
function LoadPageFromRevision($PageID, $Revision)
{
if (!is_numeric($Revision) || !is_numeric($PageID)) {
return false;
}
// It is the HEAD-revision, we won't find it in the history data
if ($Revision == 0) {
return $this->LoadPage($PageID);
}
$sql = 'SELECT text.text_page_text
FROM (' . DB_PREFIX . 'pages_history page
LEFT JOIN ' . DB_PREFIX . 'pages_text_history text ON text.page_id = page.id )
WHERE page.page_id=' . $PageID . '
ORDER BY page.page_date ASC
LIMIT ' . ($Revision - 1) . ',1';
$pageDataResult = $this->_SqlConnection->SqlQuery($sql);
if ($pageData = mysql_fetch_object($pageDataResult)) {
$this->HTML = TextActions::ConvertToPreHtml($pageData->text_page_text);
$this->Text = $pageData->text_page_text;
return true;
}
return false;
}
