Advertisement
Guest User

Specific User Permission List

a guest
Apr 19th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. SELECT users.UserID, users.Name,
  2. IF((BIT_OR(uc.Permissions) & (1 << 0) = (1 << 0)),'True','False') AS 'Super Admin',
  3. IF((BIT_OR(uc.PermissionsHigh) & (1 << (97-64)) = (1 << (97-64))),'True','False')
  4. AS 'Plugin Manager'
  5. FROM users
  6. LEFT JOIN userclasses uc
  7. ON FIND_IN_SET(uc.ClassID, users.ClientID)
  8. Group BY users.UserID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement