Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 25 Jul 2010, 17:28
BlackHoster BlackHoster is offline
 
Join Date: Jun 2010
Question 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
Reply With Quote
  #2  
Old 25 Jul 2010, 17:43
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by BlackHoster View Post
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?
__________________
My mods.
Reply With Quote
  #3  
Old 25 Jul 2010, 17:52
BlackHoster BlackHoster is offline
 
Join Date: Jun 2010
Originally Posted by borbole View Post
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 ---------------



how could i delete all these IP's i wanna delete them all something like make my forum start fresh without these IP's

Last edited by BlackHoster; 25 Jul 2010 at 18:03. Reason: Auto-Merged DoublePost
Reply With Quote
  #4  
Old 25 Jul 2010, 18:15
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by BlackHoster View Post
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 ---------------



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.
__________________
My mods.
Reply With Quote
  #5  
Old 25 Jul 2010, 18:21
BlackHoster BlackHoster is offline
 
Join Date: Jun 2010
thank you very much really appreciated
Reply With Quote
  #6  
Old 25 Jul 2010, 20:30
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by BlackHoster View Post
thank you very much really appreciated
You are welcome. Glad to have been of help
__________________
My mods.
Reply With Quote
  #7  
Old 26 Jul 2010, 00:40
high6 high6 is offline
 
Join Date: Jun 2008
It also stores ips in the post table.
Reply With Quote
  #8  
Old 26 Jul 2010, 11:32
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by high6 View Post
It also stores ips in the post table.
Yes, I had already included that above
__________________
My mods.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:52.

Layout Options | Width: Wide Color: