All in One SEO Pack Importer
All in One SEO Pack Data
get_var($wpdb->prepare("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='_aioseop_title';"));
$aioseopdesccount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='_aioseop_description';"));
$aioseopkeywordscount = $wpdb->get_var($wpdb->prepare("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($wpdb->prepare("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='thesis_title';"));
$thesisdesccount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $wpdb->postmeta WHERE meta_key='thesis_description';"));
$thesiskeywordscount = $wpdb->get_var($wpdb->prepare("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 "