MyBB Community Forums

Full Version: Set avatar to those who don't have
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Hi,
I will show you how to add avatar to those who don't have avatar image.

1) Go to your CPanel
2) Find and click on phpMyAdmin
[Image: somee.PNG]

3) In phpMyAdmin choose the database that is used by your forum
[Image: add.PNG]

4) Run Query:
[Image: axx.PNG]

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

Change:
./images/avatars/default.gif
with the avatar URL

Thread: http://wb-dev.net/showthread.php?tid=142
Will this change the avatar only for members without avatars? I don't want it to interfere with the default profile plugin I have running.
It will just change the avatar image for those who DO NOT have and image.
very nice dear
Thank you!
what if you want to replace the avatar using SQL commands
this URL
http://www.domain.com/images/default_avatar.gif
replace with
http://www.domain.com/images/avatar/default_avatar.gif
UPDATE mybb_users SET avatar = './images/avatar/default_avatar.gif' WHERE avatar = './images/default_avatar.gif'

Cheers, another way has to add a css stylization but better with an SQL command xD.
awesome
thanks bro xD

what if one wants to do SQL commands at once? Big Grin
(2013-10-25, 09:02 AM)SunDi3yansyah Wrote: [ -> ]awesome
thanks bro xD

what if one wants to do SQL commands at once? Big Grin
If you're using phpMyAdmin, then just put one on one line, another on another line, etc.
give an example to make the command more than 1 in phpMyAdmin

example:

Quote:if there is a new member then he immediately obtain the following avatar
http://www.domain.com/images/avatar/default_avatar.gif
if there are members who have registered then they upload avatar following
http://www.domain.com/images/ava.gif
want to replace the following avatar
http://www.domain.com/images/avatar/default_avatar.gif

how the SQL commands myphpadmin, simultaneously?
Pages: 1 2