All in One SEO Pack Importer

All in One SEO Pack Data

get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='_aioseop_title';"); $aioseopdesccount = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='_aioseop_description';"); $aioseopkeywordscount = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='_aioseop_keywords';"); echo "
Posts with Titles: " . $aioseoptitlecount; echo "
Posts with Descriptions: " . $aioseopdesccount; echo "
Posts with Keywords: " . $aioseopkeywordscount; ?>

Thesis Data

get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='thesis_title';"); $thesisdesccount = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='thesis_description';"); $thesiskeywordscount = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='thesis_keywords';"); echo "
Posts with Titles: " . $thesistitlecount; echo "
Posts with Descriptions: " . $thesisdesccount; echo "
Posts with Keywords: " . $thesiskeywordscount; ?>

query( "UPDATE $wpdb->postmeta SET meta_key='_aioseop_title' WHERE meta_key='thesis_title'"); $wpdb->query( "UPDATE $wpdb->postmeta SET meta_key='_aioseop_description' WHERE meta_key='thesis_description'"); $wpdb->query( "UPDATE $wpdb->postmeta SET meta_key='_aioseop_keywords' WHERE meta_key='thesis_keywords'"); echo "
SEO DATA UPDATED
"; } ?>