Lines Matching +full:update +full:- +full:user +full:- +full:pass -(+path:inc +path:lang) -(+path:lib +path:plugins +path:lang) -(+path:lib +path:tpl +path:dokuwiki +path:lang)
10 * uid login pass firstname lastname email
27 $conf['plugin']['authmysql']['user'] = '';
51 /* Basic SQL statements for user authentication (required) */
56 * of the user. If the result table is empty or contains more than one
59 * The plugin accesses the password as 'pass' so an alias might be necessary.
62 * %{user} user name
63 * %{pass} encrypted or clear text password (depends on 'encryptPass')
66 $conf['plugin']['authmysql']['checkPass'] = "SELECT pass
70 WHERE login='%{user}'
74 * information about one user. The field needed are:
75 * 'pass' containing the encrypted or clear text password
76 * 'name' the user's full name
77 * 'mail' the user's email address
83 * %{user} user name
85 $conf['plugin']['authmysql']['getUserInfo'] = "SELECT pass, CONCAT(firstname,' ',lastname) AS name, email AS mail
87 WHERE login='%{user}'";
89 /* This statement is used to get all groups a user is member of. The
90 * result should be a table containing all groups the given user is
95 * %{user} user name
101 AND u.login='%{user}'";
104 /* Additional minimum SQL statements to use the user manager */
107 /* This statement should return a table containing all user login names
110 * Important is that this list contains no double entries for a user. Each
111 * user name is only allowed once in the table.
113 * The login name will be accessed as 'user' to an alias might be necessary.
116 * %{user} in FilterLogin user's login name
117 * %{name} in FilterName user's full name
118 * %{email} in FilterEmail user's email address
121 $conf['plugin']['authmysql']['getUsers'] = "SELECT DISTINCT login AS user
125 $conf['plugin']['authmysql']['FilterLogin'] = "login LIKE '%{user}'";
132 /* Additional SQL statements to add new users with the user manager */
135 /* This statement should add a user to the database. Minimum information
139 * %{user} user's login name
140 * %{pass} password (encrypted or clear text, depends on 'encryptPass')
142 * %{name} user's full name
145 (login, pass, email, firstname, lastname)
146 VALUES ('%{user}', '%{pass}', '%{email}',
148 SUBSTRING_INDEX('%{name}',' ', -1))";
157 /* This statement should connect a user to a group (a user become member
160 * %{user} user's login name
161 * %{uid} id of a user dataset
176 /* This statement should return the database index of a given user name.
180 * %{user} user name
184 WHERE login='%{user}'";
187 /* Additional SQL statements to delete users with the user manager */
190 /* This statement should remove a user fom the database.
192 * %{user} user's login name
193 * %{uid} id of a user dataset
198 /* This statement should remove all connections from a user to any group
199 * (a user quits membership of all groups).
201 * %{uid} id of a user dataset
207 /* Additional SQL statements to modify users with the user manager */
210 /* This statements should modify a user entry in the database. The
215 * %{user} user's login name
216 * %{pass} password (encrypted or clear text, depends on 'encryptPass')
218 * %{name} user's full name
219 * %{uid} user id that should be updated
221 $conf['plugin']['authmysql']['updateUser'] = "UPDATE users SET";
222 $conf['plugin']['authmysql']['UpdateLogin'] = "login='%{user}'";
223 $conf['plugin']['authmysql']['UpdatePass'] = "pass='%{pass}'";
226 lastname=SUBSTRING_INDEX('%{name}',' ', -1)";
229 /* This statement should remove a single connection from a user to a
230 * group (a user quits membership of that group).
233 * %{user} user's login name
234 * %{uid} id of a user dataset