Just finished the basic perms acp section

5 years ago by k4st

I just finished the basic permissions section on the admin panel. It is a lot less complicated then it sounds. All it does right now is manage permission objects and their permissions.. but none of this stuff actually means anything unless you're doing the code to support those permissions :P

Well, one thing I haven't done is deleting permissions because that will be really annoying. Oh well. :D

Tags: php, acp, admin, perms, permissions
OneLobby
QueryQuery TimeAffected Rows
SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

 0.8728 

 3 

 
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.thread_id=6 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id LIMIT 1

 0.8805 

 1 

 
UPDATE `k4_threads` SET views=186 WHERE thread_id=6

 0.0043 

 1 

 
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=6 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC

 0.8978 

 1