list of avatars

[pablo]

when I moved forums, i put all the avatars in the right folders, i used to have some listed in some ubb folder hierachy ! now is there a simple SQL statement I can run and reset the list of avatars , as deleting my current list of over 800 is not an option.

[pablo]

i got it done

delete from 'avatars' where avatarid != 1

now I can't get them to display at all at all on the editavatar page of the profile.