vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=247274

how to delete the IP history
by BlackHoster
25 Jul 2010 17:28

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 25 Jul 2010 17:43

Quote:

Originally Posted by BlackHoster (Post 2074324)
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 25 Jul 2010 17:52

Quote:

Originally Posted by borbole (Post 2074332)
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 25 Jul 2010 at 18:03 ---------------

https://www.vbulletin.org/forum/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 25 Jul 2010 18:15

Quote:

Originally Posted by BlackHoster (Post 2074335)
Yea something like that
i wish i could delete all the IP addresses of all Users which were saved in the forum database

--------------- Added 25 Jul 2010 at 18:03 ---------------

https://www.vbulletin.org/forum/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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


This will delete all the ip addresses from the moderator log



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


This will delete all the ip addresses from the posts



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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 25 Jul 2010 18:21

thank you very much really appreciated :)

borbole 25 Jul 2010 20:30

Quote:

Originally Posted by BlackHoster (Post 2074348)
thank you very much really appreciated :)

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

high6 26 Jul 2010 00:40

It also stores ips in the post table.

borbole 26 Jul 2010 11:32

Quote:

Originally Posted by high6 (Post 2074488)
It also stores ips in the post table.

Yes, I had already included that above :)

carsafety 01 Jan 2020 21:43

Quote:

Originally Posted by borbole (Post 2074343)
Go to phpmyadmin and run this queries at the SQL box.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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?


All times are GMT. The time now is 04:42.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.