Can you get a User Avatar direct from an SQL statement (no PHP)
By Andy on Tuesday, 30 December 2014
Posted in Tips & Tricks (Not Supported)
Replies 4
Likes 0
Views 838
Votes 0
I see from the documentation how to use PHP to pull a given user's avatar.

Is it possible to do this direct with SQL? I have an SQL query which will bring in a User ID.. can I create a column in my SQL result set that would contain the appropriate <img src=> avatar html code hyperlinked to that user's profile page?

Thanks!
Hello Andy,

You should take a look at the libraries which we use to retrieve the user avatar and try to understand the logics there.
Mark
·
Tuesday, 30 December 2014 23:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks.. By 'Libraries' do you mean the EasySocial developer documentation?
Andy
·
Wednesday, 31 December 2014 00:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Aha... I've found the ES database table that holds the avatar file names so I think I can go from there.... Thanks!
Andy
·
Wednesday, 31 December 2014 01:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Andy, glad that your issues are resolved now
Mark
·
Wednesday, 31 December 2014 02:26
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post