Trying to remove avatars from a certain user group...
 

I have a user group that is for sponsors and when their sponsorship runs out, they are no longer allowed to have an avatar. Well, I ran the query below and still see an avatar by the person name that is no longer a sponsor...

UPDATE user SET avatar=0 WHERE usergroupid=2

Any idea what I need to do?

Thanks,

Jason

goto the usergroup you dont give them avatar option,

Usergroups > Usergroup Manager > choose a usergroup > Scroll down through the options searching for a title called : Picture Uploading Permissions , when u find this just select no for each of the follwing. Can Upload Custom Avatars - Can Upload Animated Avatar.

I checked that and everything is turned off.

Whenever I try to run the following sql statement, it says...

Output from SQL command update user set avatarid='0' where usergroupid='2'; ..
No data returned

Is this not the right query:

UPDATE user SET avatarid=0 WHERE usergroupid=2

The number two is my registered user group and this is the group I want removed from avatars.

Thanks for the help!

Jason