MyBB Community Forums

Full Version: SQL Querie to change all users avatars?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is there a querie for this?
UPDATE `PREFIX_users` SET `avatar` = 'VALUE'

PREFIX should be replaced with your MyBB tables prefix
VALUE should be replaced with the desired value
I figured out my problem 5 mintues after I posted this but thanks.
Ok so I have a werid problem, I used the query to change all members avatars to default but now I have this problem http://systemfreeze.com/memberlist.php members have different sizes with the avatar, some are streched and some are swuished.