Bug #2447

getRights in Admin/perm/DB_simple far too complex

Details

Submitted	2004-10-04 20:05 UTC
From	pkamps at probusiness dot de
Assigned	dufuz
Status	Closed
Package	LiveUser
PHP Version	4.3.1
OS	debian
Roadmaps	(Not assigned)

Comments

[2004-10-04 20:05 UTC] pkamps at probusiness dot de

Description:
------------
call this method and following sql statement is querying the db server. (My db server is missing a lot of needed tables
for this query. And the query really does not look simple ;-)

SELECT rights.right_id AS right_id, rights.area_id AS area_id, areas.application_id AS application_id, userrights.perm_user_id AS user_id, rights.right_define_name AS define_name, rights.has_implied AS has_implied, rights.has_level AS has_level, rights.has_scope AS has_scope, translations.name AS name, translations.description AS description FROM liveuser_rights rights, liveuser_areas areas, liveuser_applications applications, liveuser_userrights userrights, liveuser_translations translations WHERE userrights.perm_user_id = 1 AND userrights.right_id = rights.right_id AND rights.area_id = areas.area_id AND rights.right_id = translations.section_id AND translations.section_type = 5 AND translations.language_id = 0 GROUP BY rights.right_id, rights.area_id, areas.application_id,userrights.perm_user_id ,rights.right_define_name, rights.has_implied, rights.has_level, rights.has_scope, translations.name, translations.description ORDER BY rights.area_id ASC