Deleting a user does not update link category count

[TimButterfield]

I created an administrator user, logged in as that user, created a link category, and then created four pages assigned to that category. Later, when I deleted the user (not reassigning to admin), the links were deleted, but the link category still showed the count of four. The link category should have been decremented by the count of deleted links.

FYI: This was with version 2.6.2, though that was not available in the version drop-down for creating the ticket.

The fix for this is to modify wp-admin\includes\user.php. In the wp_delete_user function, replace this code:

		// Clean links
		$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->links WHERE link_owner = %d", $id) );

with this code:

		// Clean links
		$link_ids = $wpdb->get_col( $wpdb->prepare("SELECT LINK_ID FROM $wpdb->links WHERE link_owner = %d", $id) );

		if ($link_ids) {
			foreach ($link_ids as $link_id)
				wp_delete_link($link_id);
		}

Still present in r10963 but the above patch sorts it. I've added it as a diff.

(In [10975]) Use API to delete links when deleting a user. Props TimButterfield, scohoust. fixes #7774