How to rebuild avatar for vBulletin 4 | Moving all user avatars to default

[irfan72]

Hello
Can someone please tell me how can I rebuild user avatars back as default avatar?
Thanks

[kh99]

You could user an sql query to set the avatar field of the user table to 0 for all users. If you've allowed custom avatars, then you would also want to truncate the customavatar. And if you have your forum set to save avatars in the file system, you'd need to remove those files yourself.

As always, you should make a backup of your database before attempting anything like this.

[irfan72]

May I know that sql query Please ?
Thanks