<?php
# do-categories.php.txt
# copy textpattern categories to wordpress
# assumes you've already created wordpress categories of the same name
# change the table names
#
# joe auricchio, 2008
# public domain

    require_once( dirname(__FILE__) . '/wp-config.php');

    # First do category1
    $sql = 'SELECT `Title` , `Category1` , txp.Category2 , wp.ID , wp.post_title , wpterm1.term_id AS term_1_id , wpterm1.name AS term_1_name FROM `txp_textpattern` AS txp JOIN `wp_zw50dp_posts` AS wp ON wp.post_title = txp.Title JOIN `wp_zw50dp_terms` AS wpterm1 ON wpterm1.slug = txp.Category1 WHERE txp.Category1 != \'uncategorized\'';
    $res = $wpdb->get_results($sql, ARRAY_A);

    foreach($res as $row)
    {
        echo "wp_set_post_categories(".$row['ID'].", array(".$row['term_1_id']."));\n";
        wp_set_post_categories($row['ID'], array($row['term_1_id']));
    }

    # Then append category2
    $sql = 'SELECT `Title` , `Category1` , txp.Category2 , wp.ID , wp.post_title , wpterm2.term_id AS term_2_id , wpterm2.name AS term_2_name FROM `txp_textpattern` AS txp JOIN `wp_zw50dp_posts` AS wp ON wp.post_title = txp.Title JOIN `wp_zw50dp_terms` AS wpterm2 ON wpterm2.slug = txp.Category2 WHERE txp.Category2 != \'uncategorized\'';
    $res = $wpdb->get_results($sql, ARRAY_A);

    foreach($res as $row)
    {
        echo "wp_set_post_categories(".$row['ID'].", array(".$row['term_2_id']."), true);\n";
        wp_set_post_categories($row['ID'], array($row['term_2_id']), true);
    }

?>