Get all IP addresses for one member

[hawksfan]

I don't think there is any way to do this outside of a SQL statement, but I thought that I'd give it a shot. Is there any way to get all of the ip addresses associated with one member out of the ACP? Right now I'm on 3.4 but will be migrating to version 4 in a few weeks. If it can only be done via SQL, can someone help with the statement needed? I know enough SQL to be dangerous.

[AndyF]

There are some tools built in to show IP's used by an individual member. Please see screenshots:

 

[hawksfan]

Yeah I see that. What I'd like is to be able to export them into a csv or txt file.

We have a banned member that just won't leave the site alone. I have toyed with the idea of entering all of his IP addresses into .htaccess & blocking him that way, but I can't figure out a way to easily get all of his IP addresses out in a format that I can work with, other than manually entering them in the file.

It seems like the ACP makes cross-matching IP addresses that might be used by more than one account cumbersome, & the registration process doesn't pick up an IP that exists in the banned user's profile. So even if he's on an IP address that is in his banned profile, he can still register under a different email. I would have to go through & manually enter every IP address into the global ban filters in order to make it work. That's difficult when this person has over 300 in their history.

I've contacted Kevin about potentially making this work with his Rules app (which I will likely end up using for other things on the site), that might be the way to do this. Does your IP Addresses app make this type of management easier?

[bassangler]

In ACP, go to the member, then click "unban".  You'll get a popup.  Scroll down the popup, and you'll see all the IP's.  You can select them individually or all to ban them.

Definitely check first before doing this, to make sure other members aren't using the same IP's.  You don't want to accidentally ban legit members.

[hawksfan]

16 hours ago, bassangler said:

In ACP, go to the member, then click "unban".  You'll get a popup.  Scroll down the popup, and you'll see all the IP's.  You can select them individually or all to ban them.

....

That helps, thank you. Do you know if there is an easy way to see all of their IPs that are used by other members in one spot? Like a list or report for that member that would show all IP addresses that are used by other members. It looks like I have to click into each IP individually to see that. That's a pain when the member has several hundred in their history.