XF 1.1 How can stored IP addresses be deleted?

[Thee]

Hey everyone,

I'd like to wipe the stored IP addresses on my board, but I can't find a way to do this. Is there an option in the ACP somewhere to delete logged IP addresses or does anyone know a workaround to make this happen?

Thanks!

 

[Jake Bunce]

Run this query:

TRUNCATE TABLE xf_ip;

 

[vbresults]

What if the xf_ip table was changed to BLACKHOLE?

 

[ragtek]

then you'll get an error while saving the ip

What if the xf_ip table was changed to BLACKHOLE?

 

[vbresults]

then you'll get an error while saving the ip

Darn, I guess I'll just have to do something with the model.

 

[ragtek]

...something with the model.

yes, that's what i'm doing...

 

[DFI]

Run this query:

TRUNCATE TABLE xf_ip;

How can i delete the IP log of a particular Member ?

 

[Jake Bunce]

How can i delete the IP log of a particular Member ?

DELETE
FROM xf_ip
WHERE user_id = 1

Specify the user_id.

 

[DFI]

And what if i need to replace it with another IP. I am talking about Content IP.

 

[Jake Bunce]

And what if i need to replace it with another IP. I am talking about Content IP.

UPDATE xf_ip
SET ip = INET_ATON('12.34.56.78')
WHERE user_id = 1

 

[BamBam]

Run this query:

TRUNCATE TABLE xf_ip;

Hello Jake,

Is there any Chance to make a 24 Hours Cron with this Query? Or is there a Addon who delete the IP`s? Thx!!

 

[principia]

Hello Jake,

Is there any Chance to make a 24 Hours Cron with this Query? Or is there a Addon who delete the IP`s? Thx!!

This is core in 1.2x

 

[BamBam]

This is core in 1.2x

Hm? Dont know what do you mean, where are the Settings for this? :/

// Ah i found it. Can i run this Setting Manual too?

 

[Mr Lucky]

DELETE
FROM xf_ip
WHERE user_id = 1

Specify the user_id.

This looks very useful. I'm not very experienced with MySQL and a bit nervous.

Is there anything I need to be wary of when running this query? (obviously I will have the database backed up)
After running it are there any specific tests to make sure nothing went wrong?

 

[rdn]

DELETE
FROM xf_ip
WHERE user_id = 1

Specify the user_id.

Thanks Jake

14965 rows deleted. (Query took 0.6219 seconds.)

 

[Onlyme]

@Jake Bunce would you be able to help me with the query to remove a single IP from a user please.

 

[Jake Bunce]

@Jake Bunce would you be able to help me with the query to remove a single IP from a user please.

https://xenforo.com/community/threads/remove-a-ip-from-the-ip-log.120928/#post-1098691