Set avatar to those who don't have
#1
This user has been denied support. This user has been denied support.
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
<snip - no referral links>
Reply
#2
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.
Reply
#3
This user has been denied support. This user has been denied support.
It will just change the avatar image for those who DO NOT have and image.
<snip - no referral links>
Reply
#4
This user has been denied support. This user has been denied support.
very nice dear
Reply
#5
This user has been denied support. This user has been denied support.
Thank you!
<snip - no referral links>
Reply
#6
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
[Image: sundi3yansyah@github.jpg]
Reply
#7
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.
The only infinite thing is the universe and human stupidity, but the universe is not for sure

Plugins 1.6.x

Plugins 1.8.x

Reply
#8
awesome
thanks bro xD

what if one wants to do SQL commands at once? Big Grin
[Image: sundi3yansyah@github.jpg]
Reply
#9
(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.
Reply
#10
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?
[Image: sundi3yansyah@github.jpg]
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)