XF 1.1 Search by IP

[tekgirl]

How can I search IP addresses to find users?

Thanks

 

[AndyB]

Ask your web provider to install phpmyadmin. With that you can do all sorts of searches and database maintenance.

 

[tekgirl]

Thanks Andy...I ahve phpAdmin..just need the sql query to do the search...

 

[AndyB]

Looks like you need to search is the xf_ip table. The ip field is stored in a long2ip format. Here's a thread that should help.

http://xenforo.com/community/thread...ow-to-convert-them-to-ipv4-dotted-quad.26279/

 

[tekgirl]

Thanks Andy...

 

[Mike]

You can search by IP address from the "find users" page in the admin CP.

 

[tekgirl]

Thanks Mike...I guess I was having a duh moment I didn't try...thought that field was only for usernames...