How do I search for IP addresses?

Brogan

XenForo moderator
Staff member
There is no way of searching for a user based on IP address.

You could check in the xf_ip table.
 

Jake Bunce

XenForo moderator
Staff member
Here is a query you can run on your database to retrieve a list of all users that have used a particular IP address:

Code:
SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE ip.ip = INET_ATON('xxx.xxx.xxx.xxx')
GROUP BY user.user_id
Replace xxx.xxx.xxx.xxx with the IP you want to search for.
 
Top