Is it possible to turn on a default avatar image? So that when a user hasn't uploaded his individual avatar yet, that there is a standard picture for everyone who hasn't done so?
Probably the easiest way would be to alter the defaults for a few values in the w3t_Users table. I'd suggest doing a database backup before doing this:
ALTER TABLE w3t_Users CHANGE U_Picture U_Picture varchar(150) not null default '#url_to_image#', CHANGE U_PicWidth U_PicWidth int(4) not null default '#width#', CHANGE U_PicHeight U_PicHeight int(4) not null default '#height#'
You'd need to replace #url_to_image# with the full url to the image. Also change #width# and #height# to the actual number of pixels of the image. This should make it so anyone without a pic right now, gets one, and any new members will get it as well.
Like I said, make sure you do a backup first, at least of the w3t_Users table that is getting altered.
But this would not overwrite people's individuals avatars (if they HAVE already uploaded their own avatar), would it? Because that's not what I want... only for people who have not uploaded their own image.
Also, do I write the full path like this
CHANGE U_Picture U_Picture varchar(150) not null default '#http://www.something.com/image.gif#', - is this correct?
Anyone that has an existing avatar wouldn't be changed, only those that don't have one. You're correct on your change, just leave out the # signs. I put them in just to designate what needs to be changed <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />
[]Probably the easiest way would be to alter the defaults for a few values in the w3t_Users table. [/]
Eh, I'm sorry but where exactly do I find this table? I assumed it would be in my MySQL database. The prefixes for UBBthreads are ubb_threads and the only table I can find that I could imagine would suit, is this one: ubb_threads_Users
But where exactly is the w3t_Users table? I am really no very familiar with MySQL. Sorry.
I am so sorry for being such an amateur but I have to ask another question. I know all these "Beginner questions" can be annoying but this would be really helpful for me.
I located the table now and opened it with mysqladmin (because that's the only way I know) and the screen looks like this (please see attachment).
Now I'm quite confused where I need to enter the URL for the picture.
Or do I need to get there in a different mode. I'm really sorry for all these questions but I don't know anything about MySQL.
Thanks for your help. It is very much appreciated.
The simplest way is to go into the Control Panel on the forums. Click the Database Tools link in the menu, then go to the SQL command tab, then you'd enter the sql commands in that box.
JC, that wouldn't cover when looking at his profile or showthreaded. Didn't want to have him editing any code, so the sql command above would cover every instance where the avatarr is shown.