Allowing Admin/Moderator to see IP in conversation

[brlong]

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,

 

[Chris D]

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

 

[brlong]

Hello,

How would I go about accessing that?

 

[Chris D]

It's not really trivial...

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]

Chris,

Thanks for you help!

 

[Xon]

@brlong I've just updated my addon; Conversation Improvements by Xon to add the 'IP' button in conversations if users have the view IP's permission.