Would an array do the trick?

[Barand]

view column would hold the $perms in the above example.

 

When a user logs in, get and store their $userlevel.

 

In the query

 

SELECT ... WHERE view && $userlevel

[penguin0]

Oh, now I get it.  I thought at the top you were adding them.  Now I see thats where you declare who can view it.

[penguin0]

If you are a pageman with a level of 16 can you view things that require:

 

$menuman

or

$userman

or

$rateman

[Barand]

Oh, now I get it.  I thought at the top you were adding them.  Now I see thats where you declare who can view it.

 

Both.

 

[pre]

admin    =  32  = 100000

pageman  =  16  = 010000

menuman  =  8  = 001000

userman  =  4  = 000100

rateman  =  2  = 000010

user    =  1  = 000001

[/pre]

 

if perms is admins, pagemans and menumans only then perms = 111000

 

So you only have permission if your particular "1" is in there

[penguin0]

what would I actually store in the db as the users perms?  Should it just be 32, 16 or somthing else?

[Barand]

The sum of the userlevels of those allowed to view it

 

If it's users and admins only, then 33 (32 + 1)

 

If everyone then 32+16+8+4+2+1 = 63

 

 

Correction to previous post (just a single "&"):

 

SELECT ... WHERE view & $userlevel