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]

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]

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 1280080983 at 1280080983 ---------------

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

[borbole]

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

--------------- Added 1280080983 at 1280080983 ---------------

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.

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]

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]

It also stores ips in the post table.

Yes, I had already included that above :)

[carsafety]

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?