Users recent activity in database

[KidCactus]

Where in the database is it logged when a user changes their avatar?

 

[Chris D]

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/

 

[Syndol]

In addition to what Chris said, the info is also stored in the news_feed table but those get deleted after 7 days.

 

[KidCactus]

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?

 

[Syndol]

That's correct. Also the news feed does not show when an avatar is removed.

 

[KidCactus]

Ok, then I know, thanks.