Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT users.UserID, users.Name,
- IF((BIT_OR(uc.Permissions) & (1 << 0) = (1 << 0)),'True','False') AS 'Super Admin',
- IF((BIT_OR(uc.PermissionsHigh) & (1 << (97-64)) = (1 << (97-64))),'True','False')
- AS 'Plugin Manager'
- FROM users
- LEFT JOIN userclasses uc
- ON FIND_IN_SET(uc.ClassID, users.ClientID)
- Group BY users.UserID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement