1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Users recent activity in database

Discussion in 'XenForo Questions and Support' started by KidCactus, Jan 17, 2013.

  1. KidCactus

    KidCactus Member

    Where in the database is it logged when a user changes their avatar?
  2. Chris D

    Chris D XenForo Developer Staff Member

    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/
  3. Syndol

    Syndol Guest

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

    KidCactus Member

    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?
  5. Syndol

    Syndol Guest

    That's correct. Also the news feed does not show when an avatar is removed.
    erich37 likes this.
  6. KidCactus

    KidCactus Member

    Ok, then I know, thanks. :)

Share This Page