hawksfan Posted January 17, 2016 Posted January 17, 2016 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 Posted January 17, 2016 Posted January 17, 2016 There are some tools built in to show IP's used by an individual member. Please see screenshots:
hawksfan Posted January 17, 2016 Author Posted January 17, 2016 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 Posted January 18, 2016 Posted January 18, 2016 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 Posted January 18, 2016 Author Posted January 18, 2016 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.