3
* Jeromes Keyword Plugin Importer
10
* Jeromes Keyword Plugin Importer class
12
* Will convert Jeromes Keyword Plugin tags to WordPress taxonomy tags.
16
class JeromesKeyword_Import {
19
echo '<div class="wrap">';
21
echo '<h2>'.__('Import Jerome’s Keywords').'</h2>';
22
echo '<p>'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'<br /><br /></p>';
30
echo '<div class="narrow">';
31
echo '<p>'.__('Howdy! This imports tags from Jerome’s Keywords into WordPress tags.').'</p>';
32
echo '<p>'.__('This is suitable for Jerome’s Keywords version 1.x and 2.0a.').'</p>';
33
echo '<p><strong>'.__('All existing Jerome’s Keywords will be removed after import.').'</strong></p>';
34
echo '<p><strong>'.__('Don’t be stupid - backup your database before proceeding!').'</strong></p>';
35
echo '<form action="admin.php?import=jkw&step=1" method="post">';
36
wp_nonce_field('import-jkw');
37
echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.esc_attr__('Import Version 1.x').'" /></p>';
39
echo '<form action="admin.php?import=jkw&step=3" method="post">';
40
wp_nonce_field('import-jkw');
41
echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.esc_attr__('Import Version 2.0a').'" /></p>';
47
if ( empty($_GET['step']) )
50
$step = absint($_GET['step']);
60
check_admin_referer('import-jkw');
61
$this->check_V1_post_keyword( true );
64
check_admin_referer('import-jkw');
65
$this->check_V1_post_keyword( false );
68
check_admin_referer('import-jkw');
69
$this->check_V2_post_keyword( true );
72
check_admin_referer('import-jkw');
73
$this->check_V2_post_keyword( false );
76
check_admin_referer('import-jkw');
77
$this->cleanup_V2_import();
88
function check_V1_post_keyword($precheck = true) {
91
echo '<div class="narrow">';
92
echo '<p><h3>'.__('Reading Jerome’s Keywords Tags…').'</h3></p>';
94
// import Jerome's Keywords tags
95
$metakeys = $wpdb->get_results("SELECT post_id, meta_id, meta_key, meta_value FROM $wpdb->postmeta WHERE $wpdb->postmeta.meta_key = 'keywords'");
96
if ( !is_array($metakeys)) {
97
echo '<p>' . __('No Tags Found!') . '</p>';
100
$count = count($metakeys);
101
echo '<p>' . sprintf( _n('Done! <strong>%s</strong> post with tags were read.', 'Done! <strong>%s</strong> posts with tags were read.', $count), $count ) . '<br /></p>';
103
foreach ( $metakeys as $post_meta ) {
104
if ( $post_meta->meta_value != '' ) {
105
$post_keys = explode(',', $post_meta->meta_value);
106
foreach ( $post_keys as $keyword ) {
107
$keyword = addslashes(trim($keyword));
108
if ( '' != $keyword ) {
109
echo '<li>' . $post_meta->post_id . ' - ' . $keyword . '</li>';
111
wp_add_post_tags($post_meta->post_id, $keyword);
116
delete_post_meta($post_meta->post_id, 'keywords');
121
echo '<form action="admin.php?import=jkw&step='.($precheck? 2:6).'" method="post">';
122
wp_nonce_field('import-jkw');
123
echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.esc_attr__('Next').'" /></p>';
128
function check_V2_post_keyword($precheck = true) {
131
echo '<div class="narrow">';
132
echo '<p><h3>'.__('Reading Jerome’s Keywords Tags…').'</h3></p>';
134
// import Jerome's Keywords tags
135
$tablename = $wpdb->prefix . substr(get_option('jkeywords_keywords_table'), 1, -1);
136
$metakeys = $wpdb->get_results("SELECT post_id, tag_name FROM $tablename");
137
if ( !is_array($metakeys) ) {
138
echo '<p>' . __('No Tags Found!') . '</p>';
141
$count = count($metakeys);
142
echo '<p>' . sprintf( _n('Done! <strong>%s</strong> tag were read.', 'Done! <strong>%s</strong> tags were read.', $count), $count ) . '<br /></p>';
144
foreach ( $metakeys as $post_meta ) {
145
$keyword = addslashes(trim($post_meta->tag_name));
146
if ( $keyword != '' ) {
147
echo '<li>' . $post_meta->post_id . ' - ' . $keyword . '</li>';
149
wp_add_post_tags($post_meta->post_id, $keyword);
154
echo '<form action="admin.php?import=jkw&step='.($precheck? 4:5).'" method="post">';
155
wp_nonce_field('import-jkw');
156
echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.esc_attr__('Next').'" /></p>';
161
function cleanup_V2_import() {
164
/* options from V2.0a (jeromes-keywords.php) */
165
$options = array('version', 'keywords_table', 'query_varname', 'template', 'meta_always_include', 'meta_includecats', 'meta_autoheader', 'search_strict', 'use_feed_cats', 'post_linkformat', 'post_tagseparator', 'post_includecats', 'post_notagstext', 'cloud_linkformat', 'cloud_tagseparator', 'cloud_includecats', 'cloud_sortorder', 'cloud_displaymax', 'cloud_displaymin', 'cloud_scalemax', 'cloud_scalemin');
167
$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . substr(get_option('jkeywords_keywords_table'), 1, -1));
169
foreach ( $options as $o )
170
delete_option('jkeywords_' . $o);
176
echo '<div class="narrow">';
177
echo '<p><h3>'.__('Import Complete!').'</h3></p>';
181
function JeromesKeyword_Import() {
186
// create the import object
187
$jkw_import = new JeromesKeyword_Import();
189
// add it to the import page!
190
register_importer('jkw', 'Jerome’s Keywords', __('Import Jerome’s Keywords into WordPress tags.'), array($jkw_import, 'dispatch'));