location image avatar

Hello everybody, someone can help me? ... I need to know on the structure of database where can i find the current image avatar, when the avatar is a photo uploaded by the user?

Thanks in advance

Not sure if this is what you need but the avatars are put here after processing..

/modules/boonex/avatar/data/images

 Hi, thanks for your response but I need to know in what table is located this image, and wich is the relation with the profile, because I require to show this information on a php block.

 Perhaps Prashank25 will see this and help you. He's very good at this as well as a few other members, it's still early post so I'm sure you will get a solution soon.

Thanks, I find the solution, the table name is profile and the value of avatar field  is the name of photo like avatar, and this photo is located on /modules/boonex/photos/data/files

Maybe someone needed this information :D

The table Profiles has a avatar field which will contain the ID of the image stored in this table.

bx_photos_main

If you just need the avatar of the member. Then you can just do this in a php block.

$oT = new BxTemplFunctions();
$sSmallAvatar = '<img border="0" src="' . $oT -> getMemberAvatar((int)$_COOKIE['memberID'], 'small') . '">';
$sMediumAvatar = '<img border="0" src="' . $oT -> getMemberAvatar((int)$_COOKIE['memberID'], 'medium') . '">';

echo $sSmallAvatar;
echo $sMediumAvatar;




The small avatar is 32x32px and the Medium is 64x64px

Its nice you got your solution, i wasn't here was out to buy my new lappy...

 Great answer!!

However, what's the similiar solution when I need to show the photo (located on modules/photos) that was set as avatar?

Because with this solution show me the avatar on small or medium size, but the photo was set as avatar is big size and is located in other path. What can I do to access to that photo?

Thanks in advance.

I do not know of any built-in function to do that. I must have misunderstood your original request. I thought you wanted the avatar image and not the original photo that was used to create the avatar with.

I do not believe there is a built-in function for that, and i believe i know the reason.

During the creation of an avatar there is a checkbox that can be unchecked and if it is the photo uploaded to create the avatar with will not be copied to the photo album.

So given that, even if a member has an avatar set, there may not be a full size photo for it. So it cannot be relied on.

At present i do not know of a solution.

I think you can accomplish this by adding a column in the profiles table with the name of the uploaded image. You have to modify avatar module to do that and remove the checkbox "copy this file to profile album" make it mandatory. Once you know that name of the image it shouldn't be a very big problem to obtain it when needed. Its not that easy so you can hire someone or give it a try yourself it will help you learn.

 That idea sounds great, but I try to access directly the photo with the physical path http://mydomain/modules/boonex/photos/data/files/image1.jpg but this don't work, it display page not found.

When I try to access the paht http://mydomain/modules/boonex/avatar/data/images/image2.jpg, in this case it works.
Image1.jpg and Image2.jpg exist on the path , but the first image I can't to access directly.

Do you have any idea to try?

I didn't did confirm this, but I think your looking for 

http://mydomain/modules/boonex/avatar/data/images/2.jpg