[wpmu-trac] [WordPress MU Trac] #1157: Deleting a user also deletes any links that user created

[WordPress MU Trac]

#1157: Deleting a user also deletes any links that user created
------------------------+---------------------------------------------------
 Reporter:  xyzzy       |       Owner:  somebody
     Type:  defect      |      Status:  new     
 Priority:  normal      |   Milestone:          
Component:  component1  |     Version:          
 Severity:  normal      |    Keywords:          
------------------------+---------------------------------------------------

Comment(by xyzzy):

 I was using the "delete" button on: wp-admin/wpmu-users.php

 This fires off code on line 458 of wp-admin/wpmu-edit.php

 {{{
  foreach( $users as $blogid => $user_id ) {
  $wpdb->query( "UPDATE {$wpdb->base_prefix}{$blogid}_posts SET post_author
 = '{$user_id}' WHERE post_author = '{$id}'" );
  }
 }}}

 However, in wp-includes/wpmu-functions.php, a better query is issued.

 Line 730


 {{{
 if( $reassign != '' ) {
  $reassign = (int) $reassign;
  $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_author = %d
 WHERE post_author = %d", $reassign, $user_id) );
  $wpdb->query( $wpdb->prepare("UPDATE $wpdb->links SET link_owner = %d
 WHERE link_owner = %d", $reassign, $user_id) );
  }
 }}}

 Note, this one handles links, while the one in wpmu-edit.php does not.

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/1157#comment:1>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser