Quote:
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.
Code:
UPDATE adminlog SET ipaddress = '';
This will delete all the ip addresses when checking the logs in the Acp
Code:
UPDATE moderatorlog SET ipaddress = '';
This will delete all the ip addresses from the moderator log
Code:
UPDATE post SET ipaddress = '';
This will delete all the ip addresses from the posts
Code:
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.