XF 1.5 Remove a IP from the IP log

[CabCon]

Hello,
I was wondering if it's possible to delete one selected IP from the IP log of the members? That you can not see anymore this ip in shared accounts and in the acp.

Regards,
CabCon.

 

[Paul B]

The only way to do that would be by manually editing the database.

 

[CabCon]

The only way to do that would be by manually editing the database.

Is there a example SQL command for doing that?

 

[Jake Bunce]

Get the hex value of the IP in question:

http://ncalculators.com/digital-computation/ip-address-hex-decimal-binary.htm

Then run this query with that value to remove all instances of it from the IP log:

DELETE
FROM xf_ip
WHERE ip = X'1342a2a8'

 

[CabCon]

Get the hex value of the IP in question:

http://ncalculators.com/digital-computation/ip-address-hex-decimal-binary.htm

Then run this query with that value to remove all instances of it from the IP log:

DELETE
FROM xf_ip
WHERE ip = X'1342a2a8'

Thank you I will try that out!