Редакция 5 | Редакция 20 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
| Редакция | Автор | № строки | Строка |
|---|---|---|---|
| 5 | alex-w | 1 | <?php |
| 2 | |||
| 3 | /** |
||
| 4 | * KBase |
||
| 5 | * http://alex-w.org.ru/p/kbase/ |
||
| 6 | * |
||
| 7 | * Copyright (c) 2009 Alexander Wolf |
||
| 8 | * Dual licensed under the MIT and GNU LGPL licenses. |
||
| 9 | * http://alex-w.org.ru/p/kbase/license |
||
| 10 | * |
||
| 11 | */ |
||
| 12 | |||
| 13 | class Core { |
||
| 17 | alex-w | 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 | } |
||
| 5 | alex-w | 91 | } |
| 92 | |||
| 93 | ?> |