Delete All IP logs?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • thenewuser
    Senior Member
    • Mar 2005
    • 260

    Delete All IP logs?

    How can this be done? Maybe an SQL command? (plz don't send me to the .org...)

    If you know how plz say so my members need to be anon.
  • feldon23
    Senior Member
    • Nov 2001
    • 11291
    • 3.7.x

    #2
    UPDATE post SET ipaddress='';
    UPDATE moderatorlog SET ipaddress='';
    UPDATE adminlog SET ipaddress='';
    UPDATE search SET ipaddress='';
    UPDATE user SET ipaddress='';

    May not be complete.

    Don't forget to delete server logs. Apache, Webalizer, etc. produce copious, detailed logs.

    Comment

    • thenewuser
      Senior Member
      • Mar 2005
      • 260

      #3
      Thanks!

      Comment

      • persianforum
        New Member
        • May 2006
        • 4

        #4
        user id set only one user:

        UPDATE post SET ipaddress = '127.0.0.1' WHERE userid = '1';

        __________________
        www.mypersianforum.com
        Last edited by persianforum; Sun 17 Aug '08, 1:43pm.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...