Lines Matching refs:user
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
62 * %{user} user name
70 WHERE login='%{user}'
74 * information about one user. The field needed are:
76 * 'name' the user's full name
77 * 'mail' the user's email address
83 * %{user} user name
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
142 * %{name} user's full name
146 VALUES ('%{user}', '%{pass}', '%{email}',
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
218 * %{name} user's full name
219 * %{uid} user id that should be updated
222 $conf['plugin']['authmysql']['UpdateLogin'] = "login='%{user}'";
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