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