How would I set a Default Avatar using PHPMyAdmin?

[Greg Winston]

Hello everyone,

I read this thread: http://community.mybb.com/thread-90299.html

However, I've never really used PHPMyAdmin, so I'm not sure if what I will do is right or wrong.

Could anyone explain where exactly to click and run the query? I've clicked on the 'Query' tab up the top. Would I then just submit the query in that textfield box?

[Arbaz]

Yes, just insert the query inside the text box and hit submit or I believe run but remember to select your database then click the query option on the top and then run the query.

[Greg Winston]

It has an error saying "You have to choose at least one column to display"

[Arbaz]

My bad. You have to click on SQL after you select your database then run the query. I've provided a screenshot below

Screenshot: http://puu.sh/3IuOK.png

[Jambuster]

This query will set the avatar of the user with the ID of 1 to an image at the following location:

Image Location (change the location to suit your needs)

images/avatars/default.png

Query to change user ID 1

UPDATE `mybb_users` SET `avatar`= "images/avatars/default.png" WHERE `uid` = "1"

If you want to set all users with the same avatar run this query:
Query to change ALL USERS

UPDATE `mybb_users` SET `avatar`= "images/avatars/default.png" WHERE `uid`