MyBB

IMPAQ · 05-24-2006, 04:00 PM

Is there a way to specify an avatar when the user has no selected one yet?

Kimmo · 05-24-2006, 04:13 PM

you could change the default-setting in phpmyadmin to some value that you wish to have as a avatar?

DrPoodle · 05-24-2006, 05:41 PM

Here you go:

http://mods.mybboard.com/view.php?did=216

IMPAQ · 05-24-2006, 06:46 PM

DrPoodle Wrote:Here you go:

http://mods.mybboard.com/view.php?did=216

Thanks, DrPoodle!

Perfect for new users. Now just have to figure out how to find/replace if no avatar is present for current members.

Thanks again.

Martin M. · (This post was last modified: 05-24-2006 07:09 PM by Martin M..)

Save this script to an file

PHP Code:

<?php
require "./global.php";

$url = "http://www.homepage.com/avatar.jpg";
$db->query("UPDATE ".TABLE_PREFIX."users SET avatar='".addslashes($url)."' WHERE avatar=''");
?>

And upload it and run it through your browser.
Hope it works. Not tried.

zaher1988 · 05-24-2006, 07:03 PM

You can also run this query in the phpmyadmin

PHP Code:

UPDATE mybb_users SET avatar='http://blabla' WHERE avatar='' 

IMPAQ · 05-24-2006, 07:04 PM

require "./general.php"; ??

Do you mean global.php?

Thanks for all the help guys.

Martin M. · (This post was last modified: 05-24-2006 07:10 PM by Martin M..)

ops. sorry. I use general for my page so I mixes them up. *fixes*
oh wasn't really necessary with all that queries =P

IMPAQ · 05-24-2006, 07:11 PM

zaher1988 Wrote:You can also run this query in the phpmyadmin

PHP Code:

UPDATE mybb_users SET avatar='http://blabla' WHERE avatar=''

Worked great.

Thanks again.

DrPoodle · 05-24-2006, 07:37 PM

Couldn't he just put that query into the global.php so it runs constantly, to save him from running the file again and again? Or will that affect the actual changing of a avatar in the User CP?