Редакция 5 | Редакция 20 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 5 | Редакция 17 | ||
---|---|---|---|
Строка 9... | Строка 9... | ||
9 | * http://alex-w.org.ru/p/kbase/license
|
9 | * http://alex-w.org.ru/p/kbase/license
|
10 | *
|
10 | *
|
11 | */
|
11 | */
|
12 | 12 | ||
13 | class Core { |
13 | class Core { |
- | 14 | /* Get page ID
|
|
- | 15 | * @param $URL - page URL
|
|
- | 16 | * $dblink - link to database
|
|
- | 17 | * @access public
|
|
- | 18 | * @return PageID (int)
|
|
- | 19 | */
|
|
- | 20 | function getPageID($pageURL, $dblink) { |
|
- | 21 | $URL = parse_url($pageURL); |
|
- | 22 | $pageName = basename($URL["path"], ".html"); |
|
- | 23 | $request =& $dblink->query("SELECT page_id FROM pages WHERE page_url='$pageName'"); |
|
- | 24 | if ($request->numRows()==0) { |
|
- | 25 | return 0; |
|
- | 26 | } else { |
|
- | 27 | $request->fetchInto($get); |
|
- | 28 | return $get["page_id"]; |
|
- | 29 | }
|
|
- | 30 | }
|
|
- | 31 | ||
- | 32 | /* Get page
|
|
- | 33 | * @param $ID - page ID
|
|
- | 34 | * $dblink - link to database
|
|
- | 35 | * @access public
|
|
- | 36 | * @return PageInfo (array)
|
|
- | 37 | * PageInfo[ErrMsg] - Error message
|
|
- | 38 | * PageInfo[Title] - Page title
|
|
- | 39 | * PageInfo[Create] - Page created date
|
|
- | 40 | * PageInfo[FullText] - Page story
|
|
- | 41 | * PageInfo[ShortText] - Page short story
|
|
- | 42 | * PageInfo[OwnerID] - ID page owner
|
|
- | 43 | * PageInfo[EditorID] - ID page editor
|
|
- | 44 | */
|
|
- | 45 | function getPage($pageID, $dblink) { |
|
- | 46 | $result = array(); |
|
- | 47 | $request =& $dblink->query("SELECT * FROM pages WHERE page_id='$pageID'"); |
|
- | 48 | if ($request->numRows()!=0) { |
|
- | 49 | $request->fetchInto($get); |
|
- | 50 | $result["ErrMsg"]="OK"; |
|
- | 51 | $result["Title"] = stripslashes($get["page_title"]); |
|
- | 52 | $result["Create"] = $get["page_create"]; |
|
- | 53 | $result["FullText"] = stripslashes($get["page_text"]); |
|
- | 54 | $result["ShortText"] = stripslashes($get["page_short"]); |
|
- | 55 | $result["OwnerID"] = $get["page_owner"]; |
|
- | 56 | $result["EditorID"] = $get["page_editor"]; |
|
- | 57 | } else { |
|
- | 58 | $result["ErrMsg"]="Not Found"; |
|
- | 59 | }
|
|
- | 60 | return $result; |
|
- | 61 | }
|
|
- | 62 | ||
- | 63 | /* Get page revision
|
|
- | 64 | * @param $ID - page ID
|
|
- | 65 | * $revision - page number of revision
|
|
- | 66 | * $dblink - link to database
|
|
- | 67 | * @access public
|
|
- | 68 | * @return RevisionInfo (array)
|
|
- | 69 | * RevisionInfo[ErrMsg] - Error message
|
|
- | 70 | * RevisionInfo[Title] - Page revision title
|
|
- | 71 | * RevisionInfo[Create] - Revision created date
|
|
- | 72 | * RevisionInfo[ShortText] - Revision short story
|
|
- | 73 | * RevisionInfo[FullText] - Revision story
|
|
- | 74 | * RevisionInfo[EditorID] - ID revision editor
|
|
- | 75 | */
|
|
- | 76 | function getPageRevision($pageID,$revision,$dblink) { |
|
- | 77 | $result = array(); |
|
- | 78 | $request =& $dblink->query("SELECT * FROM pages_revision WHERE page_id='$pageID' AND page_revision='$revision'"); |
|
- | 79 | if ($request->numRows()!=0) { |
|
- | 80 | $request->fetchInto($get); |
|
- | 81 | $result["ErrMsg"] = "OK"; |
|
- | 82 | $result["Title"] = stripslashes($get["page_title"]); |
|
- | 83 | $result["Create"] = $get["page_create"]; |
|
- | 84 | $result["ShortText"] = stripslashes($get["page_short"]); |
|
- | 85 | $result["FullText"] = stripslashes($get["page_text"]); |
|
- | 86 | $result["EditorID"] = $get["page_editor"]; |
|
- | 87 | } else { |
|
- | 88 | $result["ErrMsg"] = "Not Found"; |
|
- | 89 | }
|
|
- | 90 | }
|
|
14 | }
|
91 | }
|
15 | 92 | ||
16 | ?>
|
93 | ?>
|