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

XF 1.4 Precise time of message being posted?

Discussion in 'XenForo Questions and Support' started by compactabt, Feb 27, 2016.

  1. compactabt

    compactabt Member

    Hello!

    As part of a police enquiry relating to the safety of one of my forum's members I've been asked if I can supply to the time, to the second, that a message was posted on my forum.

    Does anyone know if there's a way of finding this out, either in the normal admin capacity or by accessing the database?

    Thanks in advance!
     
  2. AndyB

    AndyB Well-Known Member

    Use phpMyAdmin.

    table = xf_post

    field = post_date

    post_date is the exact time the post was made in Unix timestamp. Use this link to convert to human readable:

    http://www.epochconverter.com/
     
  3. compactabt

    compactabt Member

    That's so helpful. Thanks very much!
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You can do it with a query using:
    Code:
    SELECT FROM_UNIXTIME(post_date)
    FROM xf_post
    WHERE post_id = 1
    Change the post_id (1) to the actual post.

    The output is in the format yyyy-mm-dd hh:mm:ss
     

Share This Page