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

Allowing Admin/Moderator to see IP in conversation

Discussion in 'XenForo Questions and Support' started by brlong, Aug 22, 2015.

  1. brlong

    brlong New Member

    Hello,

    Maybe I am missing it but is there a way for an admin/moderator to see the IP address of the user in the conversation that was started and\or includes them?

    Thanks,
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    The IP of a user is logged when they reply, but it isn't exposed in the UI.
     
  3. brlong

    brlong New Member

    Hello,

    How would I go about accessing that?
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    It's not really trivial...
    Code:
    SELECT ip_id, user_id, content_type,
        content_id, action, log_date,
        INET_NTOA(CONV(HEX(ip), 16, 10)) AS ip
    FROM xf_ip
    WHERE content_type = 'conversation_message'
    AND content_id = 1
    You would need to change the content_id from 1 to whatever the message ID of the message is that you want to know the IP for. You can find the message ID by hovering over the date the message was posted.
     
    brlong likes this.
  5. brlong

    brlong New Member

    Chris,

    Thanks for you help!
     
  6. Xon

    Xon Well-Known Member

Share This Page