3 class JeromesKeyword_Import {
6 echo '<div class="wrap">';
7 echo '<h2>'.__('Import Jerome’s Keywords').'</h2>';
8 echo '<p>'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'<br /><br /></p>';
16 echo '<div class="narrow">';
17 echo '<p>'.__('Howdy! This imports tags from Jerome’s Keywords into WordPress tags.').'</p>';
18 echo '<p>'.__('This is suitable for Jerome’s Keywords version 1.x and 2.0a.').'</p>';
19 echo '<p><strong>'.__('All existing Jerome’s Keywords will be removed after import.').'</strong></p>';
20 echo '<p><strong>'.__('Don’t be stupid - backup your database before proceeding!').'</strong></p>';
21 echo '<form action="admin.php?import=jkw&step=1" method="post">';
22 wp_nonce_field('import-jkw');
23 echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.__('Import Version 1.x').'" /></p>';
25 echo '<form action="admin.php?import=jkw&step=3" method="post">';
26 wp_nonce_field('import-jkw');
27 echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.__('Import Version 2.0a').'" /></p>';
33 if ( empty($_GET['step']) )
36 $step = absint($_GET['step']);
46 check_admin_referer('import-jkw');
47 $this->check_V1_post_keyword( true );
50 check_admin_referer('import-jkw');
51 $this->check_V1_post_keyword( false );
54 check_admin_referer('import-jkw');
55 $this->check_V2_post_keyword( true );
58 check_admin_referer('import-jkw');
59 $this->check_V2_post_keyword( false );
62 check_admin_referer('import-jkw');
63 $this->cleanup_V2_import();
74 function check_V1_post_keyword($precheck = true) {
77 echo '<div class="narrow">';
78 echo '<p><h3>'.__('Reading Jerome’s Keywords Tags…').'</h3></p>';
80 // import Jerome's Keywords tags
81 $metakeys = $wpdb->get_results("SELECT post_id, meta_id, meta_key, meta_value FROM $wpdb->postmeta WHERE $wpdb->postmeta.meta_key = 'keywords'");
82 if ( !is_array($metakeys)) {
83 echo '<p>' . __('No Tags Found!') . '</p>';
86 $count = count($metakeys);
87 echo '<p>' . sprintf( __ngettext('Done! <strong>%s</strong> post with tags were read.', 'Done! <strong>%s</strong> posts with tags were read.', $count), $count ) . '<br /></p>';
89 foreach ( $metakeys as $post_meta ) {
90 if ( $post_meta->meta_value != '' ) {
91 $post_keys = explode(',', $post_meta->meta_value);
92 foreach ( $post_keys as $keyword ) {
93 $keyword = addslashes(trim($keyword));
94 if ( '' != $keyword ) {
95 echo '<li>' . $post_meta->post_id . ' - ' . $keyword . '</li>';
97 wp_add_post_tags($post_meta->post_id, $keyword);
102 delete_post_meta($post_meta->post_id, 'keywords');
107 echo '<form action="admin.php?import=jkw&step='.($precheck? 2:6).'" method="post">';
108 wp_nonce_field('import-jkw');
109 echo '<p class="submit"><input type="submit" name="submit" value="'.__('Next').'" /></p>';
114 function check_V2_post_keyword($precheck = true) {
117 echo '<div class="narrow">';
118 echo '<p><h3>'.__('Reading Jerome’s Keywords Tags…').'</h3></p>';
120 // import Jerome's Keywords tags
121 $tablename = $wpdb->prefix . substr(get_option('jkeywords_keywords_table'), 1, -1);
122 $metakeys = $wpdb->get_results("SELECT post_id, tag_name FROM $tablename");
123 if ( !is_array($metakeys) ) {
124 echo '<p>' . __('No Tags Found!') . '</p>';
127 $count = count($metakeys);
128 echo '<p>' . sprintf( __ngettext('Done! <strong>%s</strong> tag were read.', 'Done! <strong>%s</strong> tags were read.', $count), $count ) . '<br /></p>';
130 foreach ( $metakeys as $post_meta ) {
131 $keyword = addslashes(trim($post_meta->tag_name));
132 if ( $keyword != '' ) {
133 echo '<li>' . $post_meta->post_id . ' - ' . $keyword . '</li>';
135 wp_add_post_tags($post_meta->post_id, $keyword);
140 echo '<form action="admin.php?import=jkw&step='.($precheck? 4:5).'" method="post">';
141 wp_nonce_field('import-jkw');
142 echo '<p class="submit"><input type="submit" name="submit" value="'.__('Next').'" /></p>';
147 function cleanup_V2_import() {
150 /* options from V2.0a (jeromes-keywords.php) */
151 $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');
153 $wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . substr(get_option('jkeywords_keywords_table'), 1, -1));
155 foreach ( $options as $o )
156 delete_option('jkeywords_' . $o);
162 echo '<div class="narrow">';
163 echo '<p><h3>'.__('Import Complete!').'</h3></p>';
167 function JeromesKeyword_Import() {
172 // create the import object
173 $jkw_import = new JeromesKeyword_Import();
175 // add it to the import page!
176 register_importer('jkw', 'Jerome’s Keywords', __('Import Jerome’s Keywords into WordPress tags.'), array($jkw_import, 'dispatch'));