Give all users with no avatar an default avatar?

[Superdaantje]

Give all users with no avatar an default avatar? What is the fastest way to do that ? (for the all ready registerd users)

And how do I give all new registered users a default avatar

Thanks for the info and help

[Oldiesmann]

UPDATE smf_members SET avatar='somedefaultimage.gif' WHERE avatar = '';

I think that will work, but I'm not sure. Let me know if it doesn't.

[Superdaantje]

Oke thanks I will give it a try later this day

Edit: It works Thanks

And is there a way to give new users also a default avatar by regitration.
Edit: found this.
I will give this first a try
http://www.simplemachines.org/community/index.php?topic=19500.0

Or when there is somthing else? So Please inform me

Thanks