[wp-hackers] select all users with role X

[Ryan Boren]

On Tue, 2005-12-27 at 14:25 -0500, Owen Winkler wrote:
> Ryan Boren wrote:
> > Someone could propose a schema and implement a replacement WP_User class
> > for everyone to argue over.  We could abstract these queries with
> > get_users_with_role() and get_users_with_cap() while we're at it.
> 
> Rather than creating a whole new table mess (this wasn't actually 
> suggested, was it?), just store the capabilities in multiple rows 
> instead of a serialized array.
> 
> SELECT * FROM wp_usermeta WHERE meta_key = 'wp_caps_granted';
> SELECT * FROM wp_usermeta WHERE meta_key = 'wp_caps_denied';
> 
> Any plugin that implements caching/selecting users based on role could 
> use this schema.  Hopefully it could be tested and adopted, since it's a 
> bit more flexible.

That's what I'm playing with right now, but it does not allow us to set
caps to false so that they can override inherited role caps.

Ryan