I found the location where profile pictures are stored, but I was wondering if there is a field in the database indicates the path to a user's picture or just a flag that indicates a user uploaded a picture?  Or does it just check for an image with the proper name and display the default if none exists?

Primarily I am interested in querying the database for users that have not uploaded a picture.  Is this possible?  Thanks!

I'm looking for the same answer! Did you ever get this resolved?

I've also found that AS apparently installs a user profile property called ProfilePicture, of type asProfilePicture, but surprisingly it's not connected to the profile picture shown on the left side of the Profile View. I was hoping to be able to simply query the user's profile for the ProfilePicture property, but no such luck.

I've searched all of the AS data tables and haven't found anything that points to the profile picture from the Profile View.

Can anyone shed any light on this, perhaps even clarify why 2 separate profile picture functions??

Thanks, Marty

The profile property for the AS profile picture is basically just a conduit to upload a photo. The image is stored in the Portals/{id}/activesocial/profile/_icons directory which a filename that denotes the userid. For example, the image pp_2.png is the profile picture for userid 2.

The other profile picture was implemented by DNN after the AS one was created, and the module developer feels that the AS profile picture system has better performance. The default DNN profile picture is stored in the Photo profile property, but is not used by AS.

FWIW, you can also get the image using something like this:

http://warbeats.com/desktopmodules/...=200&w=200

Where the parameters are

PortalID=self explanatory
uid=userid
h=height
w=width

I use this all over my site for grabbing the image in the required size with Helicon Isapi rewrite. This allows me to friendly it up a bit:

http://warbeats.com/avatars/user/3/width/120/image.png

Good tip NFX. I should have thought of that