11,6 → 11,83 |
*/ |
|
class Core { |
/* Get page ID |
* @param $URL - page URL |
* $dblink - link to database |
* @access public |
* @return PageID (int) |
*/ |
function getPageID($pageURL, $dblink) { |
$URL = parse_url($pageURL); |
$pageName = basename($URL["path"], ".html"); |
$request =& $dblink->query("SELECT page_id FROM pages WHERE page_url='$pageName'"); |
if ($request->numRows()==0) { |
return 0; |
} else { |
$request->fetchInto($get); |
return $get["page_id"]; |
} |
} |
|
/* Get page |
* @param $ID - page ID |
* $dblink - link to database |
* @access public |
* @return PageInfo (array) |
* PageInfo[ErrMsg] - Error message |
* PageInfo[Title] - Page title |
* PageInfo[Create] - Page created date |
* PageInfo[FullText] - Page story |
* PageInfo[ShortText] - Page short story |
* PageInfo[OwnerID] - ID page owner |
* PageInfo[EditorID] - ID page editor |
*/ |
function getPage($pageID, $dblink) { |
$result = array(); |
$request =& $dblink->query("SELECT * FROM pages WHERE page_id='$pageID'"); |
if ($request->numRows()!=0) { |
$request->fetchInto($get); |
$result["ErrMsg"]="OK"; |
$result["Title"] = stripslashes($get["page_title"]); |
$result["Create"] = $get["page_create"]; |
$result["FullText"] = stripslashes($get["page_text"]); |
$result["ShortText"] = stripslashes($get["page_short"]); |
$result["OwnerID"] = $get["page_owner"]; |
$result["EditorID"] = $get["page_editor"]; |
} else { |
$result["ErrMsg"]="Not Found"; |
} |
return $result; |
} |
|
/* Get page revision |
* @param $ID - page ID |
* $revision - page number of revision |
* $dblink - link to database |
* @access public |
* @return RevisionInfo (array) |
* RevisionInfo[ErrMsg] - Error message |
* RevisionInfo[Title] - Page revision title |
* RevisionInfo[Create] - Revision created date |
* RevisionInfo[ShortText] - Revision short story |
* RevisionInfo[FullText] - Revision story |
* RevisionInfo[EditorID] - ID revision editor |
*/ |
function getPageRevision($pageID,$revision,$dblink) { |
$result = array(); |
$request =& $dblink->query("SELECT * FROM pages_revision WHERE page_id='$pageID' AND page_revision='$revision'"); |
if ($request->numRows()!=0) { |
$request->fetchInto($get); |
$result["ErrMsg"] = "OK"; |
$result["Title"] = stripslashes($get["page_title"]); |
$result["Create"] = $get["page_create"]; |
$result["ShortText"] = stripslashes($get["page_short"]); |
$result["FullText"] = stripslashes($get["page_text"]); |
$result["EditorID"] = $get["page_editor"]; |
} else { |
$result["ErrMsg"] = "Not Found"; |
} |
} |
} |
|
?> |