[1.7 / 1.7.1] Changes in user permissions might update a usergroup the user in

[V@no]

This bug accur only when a member was added into a usergroup and then admin update/change that member's permissions, in some cases it will update/change the usergroup permissions as well.
To test it do the following:
1) register a new account on register.php page (not in ACP!)
2) in ACP set any permission in one category to "Private"
3) create a new usergroup "test"
4) in ACP find the new user account and add it to "test" usergroup
5) edit permissions for the user, and change any of the available permissions.
6) edit usergroup "test", the changes saved from user's permissions (step 5) affected the permissions of this usergroup.

To fix that do the following:

In admin/usergroups.php find:

Code:  [Select]  [Expand]  [Hide line numbers]

1	WHERE gm.user_id = $user_id AND g.group_id = gm.group_id";

Replace with:

Code:  [Select]  [Expand]  [Hide line numbers]

1	WHERE gm.user_id = $user_id AND g.group_id = gm.group_id AND g.group_type = ".GROUPTYPE_SINGLE;

[8o8o8.com]

thankx