PDA

View Full Version : Simple Request, Need help.


JC
07-17-2004, 05:30 AM
Okay,

I want to set an entire user groups forum permisssions back to DEFAULT, is this possible ?

The reason being : Some of my regular users within the REGISTERED user group have permissions to things they shouldn't - yet I have no idea which of 1600 they are. I need to set them all back to default so none of them are seeing what they shouldn't be, feel me ?

Is this possible, how ?

Thanks so much.

assassingod
07-17-2004, 07:40 AM
You can run this query (I don't know if there is a simpler way, but this way works)


UPDATE usergroup SET
passwordexpires = '0',
passwordhistory = '0',
pmquota = '50',
pmsendmax = '5',
canoverride = '5',
ispublicgroup = '0',
forumpermissions = '127487',
pmpermissions = '3',
calendarpermissions = '19',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '2626759',
genericoptions = '30',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535'
WHERE usergroupid = '2'


This will set all the registered users usergroup permissions to default (How they start in vB)

JC
07-17-2004, 08:11 PM
Thank you sir, much appreciated.