Covert legacy Orbis activities to WordPress taxonomy terms.

index.php

<?php

define( 'WP_USE_THEMES', false );

require '../wp-load.php';

global $wpdb;

$query = "SELECT * FROM $wpdb->orbis_activities;";

$activities = $wpdb->get_results( $query );

foreach( $activities as $activity ) {
	$result = wp_insert_term( $activity->name, 'orbis_timesheets_activity' );

	if ( is_array( $result ) ) {
		$term_id = $result['term_id'];

		$rows_updated = $wpdb->update(
			$wpdb->orbis_activities,
			array( 'term_id' => $term_id ),
			array( 'id' => $activity->id ),
			array( 'term_id' => '%d' ),
			array( 'id' => '%d' )
		);

		echo $activity->id, ' - ', $activity->name, ' - ', $term_id, '<br />';
	}
}

exit;