how to delete the IP history
 

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?

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] ---------------

https://vborg.vbsupport.ru/external/2010/07/19.jpg

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.

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



This will delete all the ip addresses from the moderator log



This will delete all the ip addresses from the posts



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.

thank you very much really appreciated :)

You are welcome. Glad to have been of help :)

It also stores ips in the post table.

Yes, I had already included that above :)

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?