Хранилища Subversion kbase

Сравнить редакции

Не учитывать пробелы Редакция 16 → Редакция 17

/trunk/libs/auth.php
23,7 → 23,7
if ($request->numRows()==0) {
return 0;
} else {
$request->fetchInto($get, DB_FETCHMODE_ASSOC);
$request->fetchInto($get);
return $get["user_id"];
}
}
33,12 → 33,16
* $dblink - link to database
* @access public
* @return UserInfo (array)
* UserInfo[UserID] - ID user
* UserInfo[RealName] - real name of user
* UserInfo[Status] - user status
* UserInfo[Registered] - date of registered
*/
function getUserInfo($UserID, $dblink) {
$result = array();
$request =& $dblink->query("SELECT * FROM members WHERE user_id='$UserID'");
if ($request->numRows()!=0) {
$request->fetchInto($get, DB_FETCHMODE_ASSOC);
$request->fetchInto($get);
$result["UserID"] = $get["user_id"];
$result["RealName"] = $get["realname"];
$result["Status"] = $get["status"];
65,7 → 69,7
* $status - user status
* $dblink - link to database
* @access public
* @return ErrCode (string)
* @return ErrMsg (string)
*/
function registerUser($login, $passhash, $realname, $status, $dblink) {
$request =& $dblink->query("INSERT INTO members SET login='$login', passwd='$passhash', realname='$realname', status='$status', registered=NOW()");
/trunk/libs/core.php
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";
}
}
}
 
?>