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