Announcement

Collapse
No announcement yet.

Delete All IP logs?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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


    • #3
      Thanks!

      Comment


      • #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...
        X