would anyone here know how to mass delete members avatars via a mysql command
for this admincp/index.php?loc=user.php%3Fdo%3Dedit%26u%3D
Here is my scenario: I impex'ed over about 40,000 members and for some reason it created blank avatars that are stuck on and look ugly. To fix this. I need to do a mass delete function that would perform the same result as if the member actually removed it from their profile settings.
I know, I know.... your thinking.... however, removing the gif file from the /customavatars directory then rebuilding the forum doesn't fix the problem. The only way to fix this is if I can perform something like above that will act as if the member logged in and performed it themselves.
It gets more complicated. I only want to perform this for the members with avatar sizes of a set number. 105 bytes to be exact. If someone has the answer, I would really appreciate the help.
__DEFINE_LIKE_SHARE__
|