Deleting All Avatars????

OK, I wanna delete all my avatars and re-upload new ones.. can anyone help me??? See I got all these old avatars, that I dont like, there are about 700.. and I wanna delete them all at once.. can anyone help me out?? plz.... :sleep:

and I also need help with no avatar thing, where ppl have a no avatar.. avatar when they don't have an avatar.. plz help soon!!

[Admin]

DELETE FROM avatar;
UPDATE user SET avatarid=0;

[Webmasta XT]

Thank You firefly, your the best!!!
But can someone tell me how to set a default avatar??? like when someone has no avatar, it should have an avatar saying no avatar.. can someone plz help me???

[TECK]

in functions.php, find:

PHP Code:

        if ($avatarurl=="" or ($bbuserinfo[userid]>0 and !($bbuserinfo[showavatars]))) {
            $post[avatar]="";
        } else {
            eval("\$post[avatar] = \"".gettemplate("postbit_avatar")."\";");
        } 


replace it with

PHP Code:

        if ($avatarurl=="" or ($bbuserinfo[userid]>0 and !($bbuserinfo[showavatars]))) {
            $post[avatar]='<img border="0" src="images/noavatar.gif">';
        } else {
            eval("\$post[avatar] = \"".gettemplate("postbit_avatar")."\";");
        } 


now place a noavatar.gif image in your /images folder.
that should do it.

[Admin]

That won't work nakkid.

You need to replace this:

		if ($avatarurl=="" or ($bbuserinfo[userid]>0 and !($bbuserinfo[showavatars]))) {
			$post[avatar]="";
		} else {
			eval("\$post[avatar] = \"".gettemplate("postbit_avatar")."\";");
		}

with:

		if ($bbuserinfo['userid']>0 and !$bbuserinfo['showavatars']) {
			$post['avatar'] = '';
		} else {
			if (empty($avatarurl)) {
				$avatarurl = '<img border="0" src="images/noavatar.gif">';
			}
			eval("\$post[avatar] = \"".gettemplate("postbit_avatar")."\";");
		}

[Webmasta XT]

nakkid and firefly, thanks a lot man.. owe you big times