K KidCactus Member Jan 17, 2013 #1 Where in the database is it logged when a user changes their avatar?
Chris D XenForo developer Staff member Jan 17, 2013 #2 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/ Upvote 0 Downvote
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/
S Syndol Guest Jan 17, 2013 #3 In addition to what Chris said, the info is also stored in the news_feed table but those get deleted after 7 days. Upvote 0 Downvote
In addition to what Chris said, the info is also stored in the news_feed table but those get deleted after 7 days.
K KidCactus Member Jan 17, 2013 #4 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? Upvote 0 Downvote
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?
S Syndol Guest Jan 17, 2013 #5 That's correct. Also the news feed does not show when an avatar is removed. Upvote 0 Downvote