how to delete the IP history

[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.