Application: WordPress

WordPress.DynamicMetadataHeader.php

<?php /** INCLUDE IN FUNCTIONS.PHP **/

	function set_metadata() {
		global $post;
		$title = get_post_meta($post->ID, MetaTitle, true);
		$keywords = get_post_meta($post->ID, MetaKeywords, true);
		$description = get_post_meta($post->ID, MetaDescription, true);

		if (!is_home() || !is_front_page()) {
			if (!empty($title)) {
				echo '<meta name="title" content="' . $title . '" />';
			}
			if (!empty($keywords)) {
				echo '<meta name="keywords" content="' . $keywords . '" />';
			}
			if (!empty($description)) {
				echo '<meta name="description" content="' . $description . '" />';
			}
		}

		echo $metatag;
	}

	add_action('wp_head', 'set_metadata');
?>

WordPress.UpdateContentToSSL.sql

UPDATE `wp_posts` 
SET `post_content` = REPLACE(`post_content`, "http://oldurl.com", "https://newurl.com");