how to delete the IP history

[BlackHoster]

hi guys
i have a question please

how could i delete completely the IP history that stored of any member from the database of even from the Control Panel ??? ,,by the way I'm using VB4.0.5

Regards

[borbole]

Originally Posted by BlackHoster

hi guys
i have a question please

how could i delete completely the IP history that stored of any member from the database of even from the Control Panel ??? ,,by the way I'm using VB4.0.5

Regards

Do you want to delete the ip addresses of all users in all the posts?

[BlackHoster]

Originally Posted by borbole

Do you want to delete the ip addresses of all users in all the posts?

Yea something like that
i wish i could delete all the IP addresses of all Users which were saved in the forum database

--------------- Added [DATE]1280080983[/DATE] at [TIME]1280080983[/TIME] ---------------



how could i delete all these IP's i wanna delete them all something like make my forum start fresh without these IP's

[borbole]

Originally Posted by BlackHoster

Yea something like that
i wish i could delete all the IP addresses of all Users which were saved in the forum database

--------------- Added [DATE]1280080983[/DATE] at [TIME]1280080983[/TIME] ---------------



how could i delete all these IP's i wanna delete them all something like make my forum start fresh without these IP's

Go to phpmyadmin and run this queries at the SQL box.

UPDATE adminlog SET ipaddress = '';

This will delete all the ip addresses when checking the logs in the Acp

UPDATE moderatorlog SET ipaddress = '';

This will delete all the ip addresses from the moderator log

UPDATE post SET ipaddress = '';

This will delete all the ip addresses from the posts

UPDATE user SET ipaddress = '';

This will delete all the ip addresses from the user table

These are where the ipaddresses are stored off the top of my head. If your db tables use a prefix, append it to the table name when running the queries. Hope it helps.

P.s. Note that this will delete the ip''s for everyone. But all the posts, mod/admin actions made in the future will store their ip''s. To delete them anytime a post is made or when an admin or mod does moderation etc you will need a custom mod.

[BlackHoster]

thank you very much really appreciated

[borbole]

Originally Posted by BlackHoster

thank you very much really appreciated

You are welcome. Glad to have been of help

[high6]

It also stores ips in the post table.

[borbole]

Originally Posted by high6

It also stores ips in the post table.

Yes, I had already included that above

[carsafety]

Originally Posted by borbole

Go to phpmyadmin and run this queries at the SQL box.

UPDATE post SET ipaddress = '';

This will delete all the ip addresses from the posts

Old post, I apologize, but is there a simply query that could perform the removal of IP addresses only on posts made before a certain date, or those older than a certain number of days/months/years?