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
"; } ?>