View Single Post
  #11 (permalink)  
Old 06-30-09, 10:44
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
Quote:
Originally Posted by sqlguru
Can you give an example of this (or a link)?
Quick SQL Server example
Code:
/*
2  = can edit posts
4  = can move posts
8  = can delete posts
16 = can ban users
*/

DECLARE @permissions int

DECLARE @edit_posts   bit
      , @move_posts   bit
      , @delete_posts bit
      , @ban_users    bit
      
SET @edit_posts   = 0
SET @move_posts   = 1
SET @delete_posts = 0
SET @ban_users    = 1

SET @permissions = Power(2 * @edit_posts  , 1)
                 + Power(2 * @move_posts  , 2)
                 + Power(2 * @delete_posts, 3)
                 + Power(2 * @ban_users   , 4)

PRINT @permissions 

IF 2  & @permissions = 2  PRINT 'Can Edit Posts' 
IF 4  & @permissions = 4  PRINT 'Can Move Posts' 
IF 8  & @permissions = 8  PRINT 'Can Delete Posts' 
IF 16 & @permissions = 16 PRINT 'Can Ban Users'
__________________
George
Twitter | Blog
Reply With Quote