Avatars/Signatures/Profile Pictures

[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