Редакция 17 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 17 | Редакция 20 | ||
---|---|---|---|
Строка 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 Auth { |
13 | class Auth { |
- | 14 | ||
14 | /* Check user and return User_ID (zero if user not exsists)
|
15 | /* Check user and return User_ID (zero if user not exsists)
|
15 | * @param $login - user login
|
16 | * @param $login - user login
|
16 | * $passhash - encrypted user password
|
17 | * $passhash - encrypted user password
|
17 | * $dblink - link to database
|
- | |
18 | * @access public
|
18 | * @access public
|
19 | * @return UserID (int)
|
19 | * @return UserID (int)
|
20 | */
|
20 | */
|
21 | function getUserID($login, $passhash, $dblink) { |
21 | function getUserID($login, $passhash) { |
- | 22 | global $db; |
|
22 | $request =& $dblink->query("SELECT user_id FROM members WHERE login='$login' AND passwd='$passhash'"); |
23 | $request =& $db->query("SELECT user_id FROM members WHERE login='$login' AND passwd='$passhash'"); |
23 | if ($request->numRows()==0) { |
24 | if ($request->numRows()==0) { |
24 | return 0; |
25 | return 0; |
25 | } else { |
26 | } else { |
26 | $request->fetchInto($get); |
27 | $request->fetchInto($get); |
27 | return $get["user_id"]; |
28 | return $get["user_id"]; |
28 | }
|
29 | }
|
29 | }
|
30 | }
|
30 | 31 | ||
31 | /* Get information about user
|
32 | /* Get information about user
|
32 | * @param $UserID - ID user
|
33 | * @param $UserID - ID user
|
33 | * $dblink - link to database
|
- | |
34 | * @access public
|
34 | * @access public
|
35 | * @return UserInfo (array)
|
35 | * @return UserInfo (array)
|
36 | * UserInfo[UserID] - ID user
|
36 | * UserInfo[UserID] - ID user
|
37 | * UserInfo[RealName] - real name of user
|
37 | * UserInfo[RealName] - real name of user
|
38 | * UserInfo[Status] - user status
|
38 | * UserInfo[Status] - user status
|
39 | * UserInfo[Registered] - date of registered
|
39 | * UserInfo[Registered] - date of registered
|
40 | */
|
40 | */
|
41 | function getUserInfo($UserID, $dblink) { |
41 | function getUserInfo($UserID) { |
- | 42 | global $db; |
|
42 | $result = array(); |
43 | $result = array(); |
43 | $request =& $dblink->query("SELECT * FROM members WHERE user_id='$UserID'"); |
44 | $request =& $dblink->query("SELECT * FROM members WHERE user_id='$UserID'"); |
44 | if ($request->numRows()!=0) { |
45 | if ($request->numRows()!=0) { |
45 | $request->fetchInto($get); |
46 | $request->fetchInto($get); |
46 | $result["UserID"] = $get["user_id"]; |
47 | $result["UserID"] = $get["user_id"]; |
Строка 65... | Строка 66... | ||
65 | /* Register new user
|
66 | /* Register new user
|
66 | * @param $login - user login
|
67 | * @param $login - user login
|
67 | * $passhash - encrypted user password
|
68 | * $passhash - encrypted user password
|
68 | * $realname - real name of user
|
69 | * $realname - real name of user
|
69 | * $status - user status
|
70 | * $status - user status
|
70 | * $dblink - link to database
|
- | |
71 | * @access public
|
71 | * @access public
|
72 | * @return ErrMsg (string)
|
72 | * @return ErrMsg (string)
|
73 | */
|
73 | */
|
74 | function registerUser($login, $passhash, $realname, $status, $dblink) { |
74 | function registerUser($login, $passhash, $realname, $status) { |
- | 75 | global $db; |
|
75 | $request =& $dblink->query("INSERT INTO members SET login='$login', passwd='$passhash', realname='$realname', status='$status', registered=NOW()"); |
76 | $request =& $db->query("INSERT INTO members SET login='$login', passwd='$passhash', realname='$realname', status='$status', registered=NOW()"); |
76 | if (PEAR::isError($dblink)) { |
77 | if (PEAR::isError($dblink)) { |
77 | die($result = $dblink->getMessage()); |
78 | die($result = $dblink->getMessage()); |
78 | } else { |
79 | } else { |
79 | $result = "OK"; |
80 | $result = "OK"; |
80 | }
|
81 | }
|