[wp-trac] [WordPress Trac] #43442: Add tools for anonymizing of commenters

[WordPress Trac]

#43442: Add tools for anonymizing of commenters
------------------------------------------+------------------
 Reporter:  azaozz                        |       Owner:
     Type:  enhancement                   |      Status:  new
 Priority:  normal                        |   Milestone:  5.0
Component:  General                       |     Version:
 Severity:  normal                        |  Resolution:
 Keywords:  gdpr has-patch needs-testing  |     Focuses:
------------------------------------------+------------------

Comment (by azaozz):

 Looking at 43442.diff, thinking we may be better off doing a custom db
 query. Updating each comment in a loop would be very ineffective. Perhaps
 something like:
 {{{
 $anon = __( 'Anonymous' );

 $wpdb->query(
     $wpdb->prepare( "UPDATE $wpdb->comments SET comment_agent = '',
 comment_author = '$anon', comment_author_email = '', comment_author_IP =
 '0.0.0.0', comment_author_url = '', user_id = 0 WHERE comment_author_email
 = '$email'" )
 );
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/43442#comment:7>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform