TalkPHP - View Single Post

Enfernikus · 06-29-2009, 03:11 PM

I currently have a system which employs cascading user levels there is first the Group User levels and their associated rules than there are the User Specific "rules" with the ladder over riding the former.

Currently I'm employing 2 queries to check for the User and exit out or the Group, how ever I was wondering if it could be done in one.

Currently employed queries

sql Code:

SELECT DISTINCT ea_acl_options.`handler`, 
         ea_acl_options.`page`, 
         ea_acl_options.`limit`,  
         ea_acl_options.isgroup,
         ea_acl_options.`allowed`,  
         ea_acl_options.`guid` AS gid,  
         ea_user_levels.sort
FROM ea_acl_options 
JOIN ea_user_belongs
LEFT JOIN ea_user_levels ON ea_user_levels.id = ea_user_belongs.g_id
WHERE guid=2 OR guid=0 AND isgroup=0

sql Code:

SELECT DISTINCT ea_acl_options.`handler`, 
          ea_acl_options.`page`, 
          ea_acl_options.`limit`,
          ea_acl_options.`isgroup`,
          ea_acl_options.`allowed`,
          ea_acl_options.`guid` AS gid,  
          ea_user_levels.sort
FROM ea_acl_options 
JOIN ea_user_belongs ON ea_acl_options.guid = ea_user_belongs.g_id
JOIN ea_user_levels ON ea_user_belongs.g_id = ea_user_levels.id 
WHERE ea_user_belongs.u_id = 2 AND ea_acl_options.isgroup = 1

It differs by the last three lines. I might need to rethink my database design...

Perchance could anyone tell me what I could do? I was thinking of using the UNION statement but then there are possibilities of a group and a user having the same id.

06-29-2009, 03:11 PM	#1 (permalink)
Enfernikus The Addict Join Date: Jun 2008 Posts: 335 Thanks: 2	Advanced Query I currently have a system which employs cascading user levels there is first the Group User levels and their associated rules than there are the User Specific "rules" with the ladder over riding the former. Currently I'm employing 2 queries to check for the User and exit out or the Group, how ever I was wondering if it could be done in one. Currently employed queries sql Code: SELECT DISTINCT ea_acl_options.`handler`, ea_acl_options.`page`, ea_acl_options.`limit`, ea_acl_options.isgroup, ea_acl_options.`allowed`, ea_acl_options.`guid` AS gid, ea_user_levels.sort FROM ea_acl_options JOIN ea_user_belongs LEFT JOIN ea_user_levels ON ea_user_levels.id = ea_user_belongs.g_id WHERE guid=2 OR guid=0 AND isgroup=0 sql Code: SELECT DISTINCT ea_acl_options.`handler`, ea_acl_options.`page`, ea_acl_options.`limit`, ea_acl_options.`isgroup`, ea_acl_options.`allowed`, ea_acl_options.`guid` AS gid, ea_user_levels.sort FROM ea_acl_options JOIN ea_user_belongs ON ea_acl_options.guid = ea_user_belongs.g_id JOIN ea_user_levels ON ea_user_belongs.g_id = ea_user_levels.id WHERE ea_user_belongs.u_id = 2 AND ea_acl_options.isgroup = 1 It differs by the last three lines. I might need to rethink my database design... Perchance could anyone tell me what I could do? I was thinking of using the UNION statement but then there are possibilities of a group and a user having the same id. __________________ My Blog Last edited by Enfernikus : 06-29-2009 at 03:41 PM.