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

last visited timestamp

Discussion in 'XenForo Development Discussions' started by kratos, Sep 6, 2014.

  1. kratos

    kratos Member

    I am attempting to create a cron job that will identify user inactivity and email me a list of inactive users. It's all functional other than i'm not sure what in the database I need to read for checking the last time a logged in user viewed the website. I have identified a couple things i may be able to use:

    last_activity and lastactivity

    What purpose do each of these serve?

    What I am looking for is basically the "last visited timestamp" to tell me the last time that user viewed the website.
  2. Chris D

    Chris D XenForo Developer Staff Member

    lastactivity doesn't look like a XenForo field. The naming convention of columns in XF would usually make it last_activity

    What table was lastactivity in?
  3. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    I couldn't find any column named 'lastactivity' may be this column is related to an add-on?
    Btw, the field you are looking for is 'last_activity' in the 'xf_user' table. :)

Share This Page