XF 1.5 Query to remove ip address from all users?

[Brent W]

While setting up RailGun we briefly had it live where it wasn't forwarding the users ip address but instead our servers ip address. This means that many members show up as sharing our servers ip address. How can I delete that IP address from all users accounts?

 

[Mike]

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

Change 1.2.3.4 as needed.

I haven't tested this yet, so I'd recommend using the SELECT version to confirm it's grabbing what you expect and, as usual, I'd recommend backing up before running this.

 

[Brent W]

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

Change 1.2.3.4 as needed.

I haven't tested this yet, so I'd recommend using the SELECT version to confirm it's grabbing what you expect and, as usual, I'd recommend backing up before running this.

Worked perfectly.

 

[anon666]

The query is valid for XF 2?

 

[KSA]

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

Change 1.2.3.4 as needed.

I haven't tested this yet, so I'd recommend using the SELECT version to confirm it's grabbing what you expect and, as usual, I'd recommend backing up before running this.

I am not able to do this. I get 0 rows affected. (Query took 0.0088 seconds.)

What exactly do I need to replace here

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

 

[KSA]

I am not able to do this. I get 0 rows affected. (Query took 0.0088 seconds.)

What exactly do I need to replace here

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

nvm this worked for me

DELETE
FROM xf_ip
WHERE ip = X'1234567a'

 

[Karelke]

DELETE FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0'));

Change 1.2.3.4 as needed.

I haven't tested this yet, so I'd recommend using the SELECT version to confirm it's grabbing what you expect and, as usual, I'd recommend backing up before running this.

Hi @Mike it seems this query stills work for XenForo 2.2

I want to delete some IP addresses from xf_ip, but was wondering what happens to references? For example, xf_post.ip has no foreign key on xf_ip so if you delete something from xf_ip the post will refer to a non existing record. Is that a problem?