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

xf_ip Log Cron 1.5

Prune xf_ip table via cron

  1. MattW

    MattW Well-Known Member

    MattW submitted a new resource:

    Truncate IP Log Cron (version 1.0) - Truncate xf_ip table via cron

    Read more about this resource...
     
    borbole, Fufu and Andy.N like this.
  2. Fufu

    Fufu Well-Known Member

    Thanks for creating this add-on MattW. :cool:
     
    MattW likes this.
  3. MattW

    MattW Well-Known Member

  4. luutruong

    luutruong Active Member

    :confused: I cant extract this File ..
     
  5. MattW

    MattW Well-Known Member

    I've just downloaded it and tried, and it's extracting OK. I'll re-upload just in case.
     
  6. MattW

    MattW Well-Known Member

    luutruong likes this.
  7. oman

    oman Well-Known Member

    How would you find out how big your ip table is? Could you maybe add a feature which shows you how big it is? :)
     
  8. borbole

    borbole Well-Known Member

    Nice work Matt.

    You can check the ip table in the database.
     
  9. MattW

    MattW Well-Known Member

    I've got the MySQL query to do that, so I'll look into building that into this add-on
     
    oman likes this.
  10. MattW

    MattW Well-Known Member

    This do?
    TableSize.PNG

    Just need to tidy it up a bit, but it's working at least
     
    oman likes this.
  11. oman

    oman Well-Known Member

    Awesome! :) Good job.
     
    MattW likes this.
  12. MattW

    MattW Well-Known Member

  13. CyclingTribe

    CyclingTribe Well-Known Member

    Great idea Matt - could it be modified to allow owners to keep the data for a specific number of days and remove anything older?

    Cheers,
    Shaun :D
     
  14. MattW

    MattW Well-Known Member

    Don't see why not (y)
     
    CyclingTribe likes this.
  15. MattW

    MattW Well-Known Member

    CyclingTribe likes this.
  16. MattW

    MattW Well-Known Member

    I've also renamed the add-on, as it's no longer truncating the table.
     
  17. CyclingTribe

    CyclingTribe Well-Known Member

    Excellent - thanks Matt. (y)
     
    MattW likes this.
  18. Dinh Thanh

    Dinh Thanh Well-Known Member

    Cool update.
    Could you also add an option to keep Registration IP? They are important and only one record per one person.
     
    CyclingTribe, luutruong and MattW like this.
  19. MattW

    MattW Well-Known Member

    If Register is important, I can totally exclude it from the DELETE action?
     
    Dinh Thanh and CyclingTribe like this.
  20. CyclingTribe

    CyclingTribe Well-Known Member

    I think that would be best - especially as it's not a culmulative IP like the login ones, so should be low impact on table space. (y)
     
    MattW likes this.

Share This Page