Discussion in 'XenForo Questions and Support' started by KidCactus, Jan 17, 2013.
Where in the database is it logged when a user changes their avatar?
If you just need to know when, you could check the "avatar_date" field in the xf_user table.
The datestamp can be converted to a real date using this tool: http://www.epochconverter.com/
In addition to what Chris said, the info is also stored in the news_feed table but those get deleted after 7 days.
Yeah, I know that only contains the last week, and the avatar_date field says 0. I guess it does that if an avatar has been removed but no new one is set?
That's correct. Also the news feed does not show when an avatar is removed.
Ok, then I know, thanks.
Separate names with a comma.