Going back to default avatar

[Devil Woman]

Is there anyway that I can update everyones avatar to a defualt one in bulk?

The reason I am asking is I have recently changed the way the usergroups work and I am wanting to make it so that all members can only use the avatars provided on the forum, am I able to do a bulk update to update and change all current avatars?

Thanks

[snakes1100]

This uses two different table's, customavatars and user, you would need to empty the customavatar table, then mass update the user table with the proper value for avatarid column

UPDATE user SET avatarid ='X';

avatarid will be based off what avatars you have in the "avatar" table, get the avatarid and replace X in the SQL query above.

MAKE SURE YOU BACKUP THE DB BEFORE PLAYING!

[Devil Woman]

Thanks alot, I will give that a try