Forums | Mahara Community

Developers /
Updating file quota allowance for a whole group


anonymous profile picture
Account deleted
Posts: 33

16 May 2011, 16:37

Hi there,
We are wanting to update the allowed file quota allowance for all students in a group. We have tested on our testing system the below query and it seems to work fine. Can you please check and advise this should be fine to apply on the live system and it will not break anything else?
update usr set quota = '209715200'
where id in
(
   select usr.id from usr, group_member
   where group_member.member = usr.id
   and group_member.group = [group ID from group table]
)
Many thanks,
Heidi
1 result