MyBB Community Forums

Full Version: simultaneously delete avatar in SQL and AVATAR FOLDER
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Bots are keep on registering to our forum and they upload 50x50 image size.

I really dont know if something went wrong if I'm going to delete only the images in avatar folders. Huh
if you intend to delete the bot and the image then it will be fine. If you don't want them to add an avatar disable the upload avatar option from the registered group and just let them pick one from the gallery.
(2014-05-15, 05:54 PM)Leefish Wrote: [ -> ]if you intend to delete the bot and the image then it will be fine. If you don't want them to add an avatar disable the upload avatar option from the registered group and just let them pick one from the gallery.

Sir, how about deleting only the images in avatar folder? (registered bot banned only) do I need to execute command in SQL? like delete/update? Huh
If you delete the image and not the bot then the avatar image will be broken, so you need an SQL query. I will try and find you one.

Try this:

UPDATE `mybb_users` SET `avatar` = './images/avatars/default.gif' WHERE `usergroup` = '7' 

Then you can delete the avatars from the folder
thank you sir!

I just want to ask why is it,

Quote:./images/avatars/default.gif

when I try to visit that it is not found http://www.mybb.ml/images/avatars/default.gif Huh
Maybe you deleted it from your server?

http://mybb.ml/images/avatars/php.gif exists.