Редакция 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 | ?> |