PDA

View Full Version : prune IP-Adresses


Kraxell
11-16-2010, 08:41 AM
Hello :)

Is it possible to prune all IP-Adresses of my users? (e.g. via hack oder SQL)

Best Regards

Alfa1
11-21-2010, 01:44 PM
1. To remove IPs from the User registration:

UPDATE user SET ipaddress='';

2. To remove all IPs from posts:

UPDATE post SET ipaddress='';

Note: Those are single quotes, not a double-quote.

Mind to add prefixes if you have those. With thanks to Steve machol.

Kraxell
11-21-2010, 03:08 PM
Thank you very much! Is it possible to include it via cronjob or something else, to make it automaticly?

Best Regards