1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 How can stored IP addresses be deleted?

Discussion in 'XenForo Questions and Support' started by Thee, Feb 9, 2012.

  1. Thee

    Thee Active Member

    Hey everyone,

    I'd like to wipe the stored IP addresses on my board, but I can't find a way to do this. Is there an option in the ACP somewhere to delete logged IP addresses or does anyone know a workaround to make this happen?

    Thanks!
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query:

    Code:
    TRUNCATE TABLE xf_ip;
    
     
    dutchbb, Luxus, principia and 2 others like this.
  3. vbresults

    vbresults Well-Known Member

    What if the xf_ip table was changed to BLACKHOLE?
     
  4. ragtek

    ragtek Guest

    then you'll get an error while saving the ip:p
     
    M@rc likes this.
  5. vbresults

    vbresults Well-Known Member

    Darn, I guess I'll just have to do something with the model. :p
     
  6. ragtek

    ragtek Guest

    yes, that's what i'm doing...
     
  7. DFI

    DFI Active Member

    How can i delete the IP log of a particular Member ?
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    DELETE
    FROM xf_ip
    WHERE user_id = 1
    
    Specify the user_id.
     
    RoldanLT, Mr Lucky and DFI like this.
  9. DFI

    DFI Active Member

    And what if i need to replace it with another IP. I am talking about Content IP.
     
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    UPDATE xf_ip
    SET ip = INET_ATON('12.34.56.78')
    WHERE user_id = 1
    
     
  11. BamBam

    BamBam Active Member

    Hello Jake,

    Is there any Chance to make a 24 Hours Cron with this Query? Or is there a Addon who delete the IP`s? Thx!!
     
  12. principia

    principia Well-Known Member

    This is core in 1.2x
     
  13. BamBam

    BamBam Active Member

    Hm? Dont know what do you mean, where are the Settings for this? :/

    // Ah i found it. Can i run this Setting Manual too?
     
    Last edited: Sep 30, 2013
  14. Mr Lucky

    Mr Lucky Well-Known Member

    This looks very useful. I'm not very experienced with MySQL and a bit nervous.

    Is there anything I need to be wary of when running this query? (obviously I will have the database backed up)
    After running it are there any specific tests to make sure nothing went wrong?
     
  15. RoldanLT

    RoldanLT Well-Known Member

    Thanks Jake :)
     

Share This Page