Lines Matching +full:select +full:- +full:groups -(+path:inc +path:lang) -(+path:lib +path:plugins +path:lang) -(+path:lib +path:tpl +path:dokuwiki +path:lang)
12 * TABLE groups
48 $conf['plugin']['authmysql']['TablesToLock']= array("users", "users AS u","groups", "groups AS g", "usergroup", "usergroup AS ug");
66 $conf['plugin']['authmysql']['checkPass'] = "SELECT pass
69 JOIN groups AS g ON g.gid=ug.gid
85 $conf['plugin']['authmysql']['getUserInfo'] = "SELECT pass, CONCAT(firstname,' ',lastname) AS name, email AS mail
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
97 $conf['plugin']['authmysql']['getGroups'] = "SELECT name as `group`
98 FROM groups g, users u, usergroup ug
121 $conf['plugin']['authmysql']['getUsers'] = "SELECT DISTINCT login AS user
124 LEFT JOIN groups AS g ON ug.gid=g.gid";
148 SUBSTRING_INDEX('%{name}',' ', -1))";
154 $conf['plugin']['authmysql']['addGroup'] = "INSERT INTO groups (name)
173 $conf['plugin']['authmysql']['delGroup'] = "DELETE FROM groups
182 $conf['plugin']['authmysql']['getUserID'] = "SELECT uid AS id
199 * (a user quits membership of all groups).
226 lastname=SUBSTRING_INDEX('%{name}',' ', -1)";
249 $conf['plugin']['authmysql']['getGroupID'] = "SELECT gid AS id
250 FROM groups