/*
Plugin Name: Example Custom Post
Plugin URI: http://www.kieranoshea.com
Description: Allows the demonstration of custom posts
Author: Kieran O'Shea
Author URI: http://www.kieranoshea.com
Version: 1.0
*/

function create_post_type() {
  register_post_type( 'calendar_event',
    array(
      'labels' => array(
        'name' => __( 'Events' ),
        'singular_name' => __( 'Event' ),
        'add_new' => __('Add New'),
        'add_new_item' => __('Add New Event'),
        'edit_item' => __('Edit Event')
      ),
      'public' => true,
      'has_archive' => true,
      'rewrite' => array('slug' => 'events') 
    )
  );
}
add_action( 'init', 'create_post_type' );

function my_rewrite_flush() {
  create_post_type();
  flush_rewrite_rules();
}
register_activation_hook(__FILE__, 'my_rewrite_flush');

/*
A quick command line script to migrate a table of data to custom posts
*/

// Turn off errors as we're sort of outside wordpress 
// and the browser and that can cause warnings
define('WP_DEBUG', false);

// Require the standard WordPress header
require(dirname(__FILE__).'/wp-blog-header.php');

// Tell the user what we're about to do
echo 'Migrating table WP_CALENDAR to custom post type CALENDAR_EVENT 
';

// We need some of the WordPress globals to proceed
global $wpdb;

// Get all our events
$events = $wpdb->get_results("SELECT * FROM wp_calendar");

// How many are there?
echo sizeof($events).' events will be imported...

';

// Loop through 'em and load 'em to WordPress
if (!empty($events))
  {
    foreach ($events as $event)
      {
        $ent['post_type']    = 'calendar_event';
        $ent['post_content'] = $event->event_desc;
        $ent['post_parent']  = 0;
        $ent['post_author']  = 1;
        $ent['post_status']  = 'publish';
        $ent['post_title']   = $event->event_title;
        $entid = wp_insert_post ($ent);
        if ($entid == 0) { 
          echo 'Failed to migrate event "'.$event->event_title.'"
          '; 
        } else { 
          echo 'Migrated event "'.$event->event_title.'"
          '; }
      }
    }

// Tell the user we're all done
echo '
Done!
';