Avatars/Signatures/Profile Pictures

[grrlburn]

I need help.

I need to remove all the signatures of a particular usergroup.

I need to remove all the profile pictures of a particular usergroup.

I need to remove the custom title.

I need to remove all the custom avatars of a particular usergroup and set it to a default avatar, until they choose another avatar from the avatar list we host.

I have searched the boards but haven't found anything that fits this particular request. If it is on here, please point me in the right direction.

Thanks

[hiiped]

USERGROUP PERMISSION

Can Use Signatures Yes No
Can Use Custom Title Yes No
Can Upload Profile Pictures Yes No


etc etc.....

[grrlburn]

Thanks for the information but this will not help me. I have 5000 users in a current usergroup. They have ability to post signatures, custom avatars, profile fields and custom usertitles. I can take away that ability via the usergroup permissions as you suggested BUT it only applies to new users, the 5000 old users still have their signatures, custome avatars, profile fields and custom usertitles. I believe I have to go through the backend to remove these features and set them manually.

This appears fairly easy with the custom title I have come up with the sql statement because that info is housed in the user table.

BUT with signatures, profile pics and custom avatars those are housed in seperate tables and are linked via the userid and NOT the usergroup id, which is what I am trying to figure out.

I need to say something like

Set custom avatar to null where usergroupid = 13

But because this information is housed in two different tables I can't quite figure out how to get that. See the user table contains the usergroupid, but the avatar table references only the userid. So you see my dilemna, which I still haven't resolved and hope someone will help me out.

Thanks