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'));