Lines Matching +full:join +full:- +full:group -(+path:inc +path:lang) -(+path:lib +path:plugins +path:lang) -(+path:lib +path:tpl +path:dokuwiki +path:lang)
64 * %{dgroup} default group name
68 JOIN users AS u ON u.uid=ug.uid
69 JOIN groups AS g ON g.gid=ug.gid
91 * member of. The plugin accesses the group name as 'group' so an alias
97 $conf['plugin']['authmysql']['getGroups'] = "SELECT name as `group`
119 * %{group} in FilterGroup group name
123 LEFT JOIN usergroup AS ug ON u.uid=ug.uid
124 LEFT JOIN groups AS g ON ug.gid=g.gid";
128 $conf['plugin']['authmysql']['FilterGroup'] = "name LIKE '%{group}'";
148 SUBSTRING_INDEX('%{name}',' ', -1))";
150 /* This statement should add a group to the database.
152 * %{group} group name
155 VALUES ('%{group}')";
157 /* This statement should connect a user to a group (a user become member
158 * of that group).
162 * %{group} group name
163 * %{gid} id of a group dataset
168 /* This statement should remove a group fom the database.
170 * %{group} group name
171 * %{gid} id of a group dataset
198 /* This statement should remove all connections from a user to any group
226 lastname=SUBSTRING_INDEX('%{name}',' ', -1)";
230 * group (a user quits membership of that group).
235 * %{group} group name
236 * %{gid} id of a group dataset
242 /* This statement should return the database index of a given group name.
247 * %{group} group name
251 WHERE name='%{group}'";