function podPress_update_option($option_name, $option_value)
{
delete_option($option_name);
$result = podPress_add_option($option_name, $option_value);
return $result;
}
function do_legacy_upgrades($current)
{
global $wpdb;
while (TRUE == version_compare(PODPRESS_VERSION, $current, '>=') and TRUE == version_compare('8.8', $current, '>=')) {
settype($current, 'string');
switch ($current) {
case '0':
$current = PODPRESS_VERSION;
break;
case '1.4':
$posts_that_need_upgrades = array();
$posts = $wpdb->get_results("SELECT ID, post_content FROM " . $wpdb->posts);
if ($posts) {
foreach ($posts as $post) {
if (preg_match($this->podcasttag_regexp, $post->post_content, $matches)) {
$podcastTagFileName = $matches[1];
} else {
$podcastTagFileName = false;
}
if ($podcastTagFileName) {
$posts_that_need_upgrades[$post->ID] = $post->post_content;
}
}
reset($posts_that_need_upgrades);
foreach ($posts_that_need_upgrades as $key => $value) {
$wpdb->query("UPDATE " . $wpdb->posts . " SET post_content = '" . preg_replace($this->podcasttag_regexp, '', $value) . "' WHERE ID=" . $key);
if (preg_match($this->podcasttag_regexp, $content, $matches)) {
$podcastTagFileName = $matches[1];
} else {
$podcastTagFileName = false;
}
delete_post_meta($key, 'podPress_podcastStandardAudio');
add_post_meta($key, 'podPress_podcastStandardAudio', $podcastTagFileName, true);
}
}
break;
case '3.8':
$this->settings['audioWebPath'] = get_option('podPress_audioWebPath');
$this->settings['audioFilePath'] = get_option('podPress_audioFilePath');
if ($this->settings['audioWebPath'] == '') {
add_option('podPress_mediaWebPath', $this->settings['audioWebPath'], "Web path to Podcast media files", true);
$this->settings['audioWebPath'] = $this->settings['audioWebPath'];
delete_option('podPress_audioWebPath');
}
if ($this->settings['audioFilePath'] == '') {
add_option('podPress_mediaFilePath', $this->settings['audioFilePath'], "File path to Podcast media files", true);
$this->settings['mediaFilePath'] = $this->settings['audioFilePath'];
delete_option('podPress_audioFilePath');
}
$posts = $wpdb->get_results("SELECT ID FROM " . $wpdb->prefix . "posts");
if ($posts) {
foreach ($posts as $post) {
$sql = "SELECT meta_key, meta_value\n\t\t\t\t\t\t\t\t FROM " . $wpdb->prefix . "postmeta \n\t\t\t\t\t\t\t\t\tWHERE meta_key IN(\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastStandardAudio', \n\t\t\t\t\t\t\t\t\t\t'podPress_podcastStandardAudioSize',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastStandardAudioDuration',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastEnhancedAudio',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastEnhancedAudioSize',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastEnhancedAudioDuration',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastVideo',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastVideoSize',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastVideoDuration',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastVideoDimension',\n\t\t\t\t\t\t\t\t\t\t'podPress_webVideo',\n\t\t\t\t\t\t\t\t\t\t'podPress_webVideoSize',\n\t\t\t\t\t\t\t\t\t\t'podPress_webVideoDuration',\n\t\t\t\t\t\t\t\t\t\t'podPress_webVideoDimension',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastEbook',\n\t\t\t\t\t\t\t\t\t\t'podPress_podcastEbookSize',\n\t\t\t\t\t\t\t\t\t\t'itunes:duration',\n\t\t\t\t\t\t\t\t\t\t'enclosure'\n\t\t\t\t\t\t\t\t\t) AND post_id = " . $post->ID;
$metadata = $wpdb->get_results($sql);
if ($metadata) {
$posts2convert = array();
foreach ($metadata as $stat) {
$posts2convert[$post->ID][$stat->meta_key] = $stat->meta_value;
}
$rssaddedyet = false;
$podPressMedia = array();
foreach ($posts2convert as $key => $val) {
if (isset($val['enclosure'])) {
$encParts = split("\n", $val['enclosure']);
$data = $this->upgrade_convert39to40mediaFile(trim(htmlspecialchars($encParts[0])), trim(htmlspecialchars($encParts[1])));
if (!$rssaddedyet) {
$rssaddedyet = true;
$data['rss'] = 'on';
}
$podPressMedia[] = $data;
}
if (isset($val['podPress_podcastStandardAudio'])) {
$data = $this->upgrade_convert39to40mediaFile($val['podPress_podcastStandardAudio'], $val['podPress_podcastStandardAudioSize'], $val['podPress_podcastStandardAudioDuration']);
if (!$rssaddedyet) {
$rssaddedyet = true;
$data['rss'] = 'on';
}
$podPressMedia[] = $data;
}
if (isset($val['podPress_podcastEnhancedAudio'])) {
$data = $this->upgrade_convert39to40mediaFile($val['podPress_podcastEnhancedAudio'], $val['podPress_podcastEnhancedAudioSize'], $val['podPress_podcastEnhancedAudioDuration']);
if (!$rssaddedyet) {
$rssaddedyet = true;
$data['rss'] = 'on';
}
$podPressMedia[] = $data;
}
if (isset($val['podPress_podcastVideo'])) {
$data = $this->upgrade_convert39to40mediaFile($val['podPress_podcastVideo'], $val['podPress_podcastVideoSize'], $val['podPress_podcastVideoDuration'], $val['podPress_podcastVideoDimension']);
if (!$rssaddedyet) {
$rssaddedyet = true;
$data['rss'] = 'on';
}
$podPressMedia[] = $data;
}
if (isset($val['podPress_webVideo'])) {
$data = $this->upgrade_convert39to40mediaFile($val['podPress_webVideo'], $val['podPress_webVideoSize'], $val['podPress_webVideoDuration'], $val['podPress_webVideoDimension']);
$podPressMedia[] = $data;
}
if (isset($val['podPress_podcastEbook'])) {
$data = $this->upgrade_convert39to40mediaFile($val['podPress_podcastEbook'], $val['podPress_podcastEbookSize']);
if (!$rssaddedyet) {
$rssaddedyet = true;
$data['rss'] = 'on';
}
$podPressMedia[] = $data;
}
}
if (is_array($podPressMedia)) {
delete_post_meta($post->ID, 'podPressMedia');
podPress_add_post_meta($post->ID, 'podPressMedia', $podPressMedia, true);
}
}
}
}
$sql = "UPDATE " . $wpdb->prefix . "postmeta SET meta_key='enclosure_hold' WHERE meta_key='enclosure'";
$wpdb->query($sql);
break;
case '4.2':
$playerOptions['bg'] = str_replace('0x', '#', get_option('podPress_player_bgcolor'));
delete_option('podPress_player_bgcolor');
$playerOptions['text'] = str_replace('0x', '#', get_option('podPress_player_textcolor'));
delete_option('podPress_player_textcolor');
$playerOptions['leftbg'] = str_replace('0x', '#', get_option('podPress_player_leftbgcolor'));
delete_option('podPress_player_leftbgcolor');
$playerOptions['lefticon'] = str_replace('0x', '#', get_option('podPress_player_lefticoncolor'));
delete_option('podPress_player_lefticoncolor');
$playerOptions['rightbg'] = str_replace('0x', '#', get_option('podPress_player_rightbgcolor'));
delete_option('podPress_player_rightbgcolor');
$playerOptions['rightbghover'] = str_replace('0x', '#', get_option('podPress_player_rightbghovercolor'));
delete_option('podPress_player_rightbghovercolor');
$playerOptions['righticon'] = str_replace('0x', '#', get_option('podPress_player_righticoncolor'));
delete_option('podPress_player_righticoncolor');
$playerOptions['righticonhover'] = str_replace('0x', '#', get_option('podPress_player_righticonhovercolor'));
delete_option('podPress_player_righticonhovercolor');
$playerOptions['slider'] = str_replace('0x', '#', get_option('podPress_player_slidercolor'));
delete_option('podPress_player_slidercolor');
$playerOptions['track'] = str_replace('0x', '#', get_option('podPress_player_trackcolor'));
delete_option('podPress_player_trackcolor');
$playerOptions['loader'] = str_replace('0x', '#', get_option('podPress_player_loadercolor'));
delete_option('podPress_player_loadercolor');
$playerOptions['border'] = str_replace('0x', '#', get_option('podPress_player_bordercolor'));
delete_option('podPress_player_bordercolor');
podPress_update_option('podPress_playerOptions', $playerOptions);
break;
case '4.4':
if (!is_array($this->settings['iTunes'])) {
$this->settings['iTunes'] = array();
}
$x = stripslashes(get_option('itunesAdminName'));
delete_option('itunesAdminName');
if (!empty($x)) {
$this->settings['iTunes']['author'] = $x;
}
$this->settings['iTunes']['block'] = 'No';
$this->settings['iTunes']['category'] = array();
$cat1 = get_option('itunesCategory1');
$cat2 = get_option('itunesCategory2');
$cat3 = get_option('itunesCategory3');
if (!empty($cat1)) {
$this->settings['iTunes']['category'][] = $cat1;
}
if (!empty($cat2)) {
$this->settings['iTunes']['category'][] = $cat2;
}
if (!empty($cat3)) {
$this->settings['iTunes']['category'][] = $cat3;
}
$x = stripslashes(get_option('itunesImageBig'));
delete_option('itunesImageBig');
if (!empty($x)) {
$this->settings['iTunes']['image'] = $x;
}
$x = stripslashes(get_option('itunesDefaultExplicit'));
delete_option('itunesDefaultExplicit');
if (!empty($x)) {
$this->settings['iTunes']['explicit'] = $x;
}
$x = stripslashes(get_option('itunesFeedKeywords'));
delete_option('itunesFeedKeywords');
if (!empty($x)) {
$this->settings['iTunes']['keywords'] = $x;
}
$x = stripslashes(get_option('podcastdescription'));
delete_option('podcastdescription');
if (!empty($x)) {
$this->settings['iTunes']['summary'] = $x;
}
$x = stripslashes(get_option('itunesFeedID'));
delete_option('itunesFeedID');
if (!empty($x)) {
$this->settings['iTunes']['FeedID'] = $x;
}
delete_option('itunesUseKeyword');
delete_option('itunesFeedURL');
$x = stripslashes(get_option('itunesImageSmall'));
delete_option('itunesImageSmall');
if (!empty($x)) {
add_option('rss_image', $x);
}
$x = stripslashes(get_option('itunesTTL'));
delete_option('itunesTTL');
if (!empty($x)) {
add_option('rss_ttl', $x);
}
$x = stripslashes(get_option('downloadLinksInRSS'));
delete_option('downloadLinksInRSS');
if (!empty($x)) {
add_option('podPress_rss_showlinks', $x);
}
$x = stripslashes(get_option('channelCat'));
delete_option('channelCat');
if (!empty($x)) {
add_option('podPress_rss_category', $x);
}
delete_option('podPress_iTunes');
podPress_add_option('podPress_iTunes', $this->settings['iTunes']);
$x = podPress_get_option('podPress_playerOptions');
delete_option('podPress_playerOptions');
if (!empty($x)) {
podPress_add_option('podPress_playerSettings', $x);
}
$x = stripslashes(get_option('podPress_BeforeMore'));
delete_option('podPress_BeforeMore');
if (!empty($x)) {
add_option('podPress_contentBeforeMore', $x);
}
$sql = "SELECT media, \n\t\t\t\t\t\t method, \n\t\t\t\t\t\t COUNT(media) as cnt_total, \n\t\t\t\t\t\t COUNT(CASE WHEN method = 'feed' THEN 1 END) as cnt_feed ,\n\t\t\t\t\t\t COUNT(CASE WHEN method = 'web' THEN 1 END) as cnt_web ,\n\t\t\t\t\t\t COUNT(CASE WHEN method = 'play' THEN 1 END) as cnt_play \n\t\t\t\t\t\t FROM " . $wpdb->prefix . "podpress_stats \n\t\t\t\t\t\t GROUP BY media \n\t\t\t\t\t\t ORDER BY cnt_total DESC";
$stats = $wpdb->get_results($sql);
if ($stats) {
$i = 0;
foreach ($stats as $stat) {
++$i;
$sqlI = "INSERT INTO " . $wpdb->prefix . "podpress_statcounts (media, total, feed, web, play) VALUES ('" . $stat->media . "', " . $stat->cnt_total . ", " . $stat->cnt_feed . ", " . $stat->cnt_web . ", " . $stat->cnt_play . ")";
$wpdb->query($sqlI);
}
}
break;
case '4.5':
$x = stripslashes(get_option('channelCat'));
delete_option('channelCat');
if (!empty($x)) {
add_option('podPress_rss_category', $x);
}
break;
case '5.3':
$posts = $wpdb->get_results("SELECT ID FROM " . $wpdb->prefix . "posts");
if ($posts) {
foreach ($posts as $post) {
$x['itunes:subtitle'] = get_post_meta($post->ID, 'itunes:subtitle', true);
delete_post_meta($post->ID, 'itunes:subtitle');
if (!isset($x['itunes:subtitle'])) {
unset($x['itunes:subtitle']);
}
$x['itunes:summary'] = get_post_meta($post->ID, 'itunes:summary', true);
delete_post_meta($post->ID, 'itunes:summary');
if (!isset($x['itunes:summary'])) {
unset($x['itunes:summary']);
}
$x['itunes:keywords'] = get_post_meta($post->ID, 'itunes:keywords', true);
delete_post_meta($post->ID, 'itunes:keywords');
if (!isset($x['itunes:keywords'])) {
unset($x['itunes:keywords']);
}
$x['itunes:author'] = get_post_meta($post->ID, 'itunes:author', true);
delete_post_meta($post->ID, 'itunes:author');
if (!isset($x['itunes:author'])) {
unset($x['itunes:author']);
}
$x['itunes:explicit'] = get_post_meta($post->ID, 'itunes:explicit', true);
delete_post_meta($post->ID, 'itunes:explicit');
if (!isset($x['itunes:explicit'])) {
unset($x['itunes:explicit']);
}
$x['itunes:block'] = get_post_meta($post->ID, 'itunes:block', true);
delete_post_meta($post->ID, 'itunes:block');
if (!isset($x['itunes:block'])) {
unset($x['itunes:block']);
}
if (!empty($x)) {
podPress_add_post_meta($post->ID, 'podPressPostSpecific', $x, true);
}
}
}
break;
case '5.6':
$x = podPress_get_option('podPress_config');
$y = true;
if ($y) {
$newSettings = array();
$newSettings['enableStats'] = get_option('podPress_enableStats');
$newSettings['statMethod'] = get_option('podPress_statMethod');
$newSettings['statLogging'] = get_option('podPress_statLogging');
$newSettings['enablePodTracStats'] = get_option('podPress_enablePodTracStats');
$newSettings['enablePremiumContent'] = get_option('podPress_enablePremiumContent');
$newSettings['enableTorrentCasting'] = get_option('podPress_enableTorrentCasting');
$newSettings['mediaWebPath'] = get_option('podPress_mediaWebPath');
$newSettings['mediaFilePath'] = get_option('podPress_mediaFilePath');
$newSettings['contentBeforeMore'] = get_option('podPress_contentBeforeMore');
$newSettings['contentLocation'] = get_option('podPress_contentLocation');
$newSettings['contentImage'] = get_option('podPress_contentImage');
$newSettings['contentPlayer'] = get_option('podPress_contentPlayer');
$newSettings['contentDownload'] = get_option('podPress_contentDownload');
$newSettings['contentDownloadText'] = get_option('podPress_contentDownloadText');
$newSettings['contentDownloadStats'] = get_option('podPress_contentDownloadStats');
$newSettings['contentDuration'] = get_option('podPress_contentDuration');
$newSettings['rss_showlinks'] = get_option('podPress_rss_showlinks');
$newSettings['rss_category'] = get_option('podPress_rss_category');
$newSettings['enableFooter'] = get_option('podPress_enableFooter');
$newSettings['player'] = podPress_get_option('podPress_playerSettings');
$newSettings['iTunes'] = podPress_get_option('podPress_iTunes');
delete_option('podPress_config');
add_option('podPress_config', $newSettings, "podPress Configuration", true);
}
break;
case '5.7':
// in the next release I will clean up old crap data that is still laying around
delete_option('podPress_enableStats');
delete_option('podPress_statMethod');
delete_option('podPress_statLogging');
delete_option('podPress_enablePodTracStats');
delete_option('podPress_enablePremiumContent');
delete_option('podPress_enableTorrentCasting');
delete_option('podPress_mediaWebPath');
delete_option('podPress_mediaFilePath');
delete_option('podPress_contentBeforeMore');
delete_option('podPress_contentLocation');
delete_option('podPress_contentImage');
delete_option('podPress_contentPlayer');
delete_option('podPress_contentDownload');
delete_option('podPress_contentDownloadText');
delete_option('podPress_contentDownloadStats');
delete_option('podPress_contentDuration');
delete_option('podPress_rss_showlinks');
delete_option('podPress_rss_category');
delete_option('podPress_enableFooter');
delete_option('podPress_iTunes');
delete_option('podPress_playerSettings');
delete_option('podPress_enableLogging');
delete_option('podPress_downloadLinksInRSS');
delete_option('podPress_categoryCasting');
delete_option('podPress_beforeMore');
$sql = "DELETE FROM " . $wpdb->prefix . "postmeta WHERE meta_key='podPressiTunesPostSpecific'";
$wpdb->query($sql);
break;
case '6.3':
$x = podPress_get_option('podPress_config');
$x['iTunes']['category'][0] = podPress_upgradeCategory($x['iTunes']['category'][0]);
if (isset($x['iTunes']['category'][1])) {
$x['iTunes']['category'][1] = podPress_upgradeCategory($x['iTunes']['category'][1]);
}
if (isset($x['iTunes']['category'][2])) {
$x['iTunes']['category'][2] = podPress_upgradeCategory($x['iTunes']['category'][2]);
}
podPress_update_option('podPress_config', $x);
break;
case '6.7':
$create_table = "ALTER TABLE " . $wpdb->prefix . "podpress_statcounts ADD COLUMN postID int(11) NOT NULL DEFAULT 0 FIRST;";
podPress_maybe_add_column($wpdb->prefix . 'podpress_statcounts', 'postID', $create_table);
$sql = 'ALTER TABLE ' . $wpdb->prefix . 'podpress_statcounts ADD PRIMARY KEY (media(255),postID), DROP PRIMARY KEY;';
$wpdb->get_results($sql);
$create_table = "ALTER TABLE " . $wpdb->prefix . "podpress_stats ADD COLUMN postID int(11) NOT NULL DEFAULT 0 AFTER id;";
podPress_maybe_add_column($wpdb->prefix . 'podpress_stats', 'postID', $create_table);
$mappings = array();
$sql = "SELECT * FROM " . $wpdb->prefix . "postmeta WHERE meta_key = 'podPressMedia' ORDER BY meta_id;";
$posts = $wpdb->get_results($sql);
if ($posts) {
foreach ($posts as $post) {
$mediaFiles = unserialize($post->meta_value);
if (is_array($mediaFiles)) {
foreach ($mediaFiles as $mediaFile) {
if (!isset($mappings[$mediaFile['URI']])) {
$filename = podPress_getFileName($mediaFile['URI']);
$mappings[$filename] = $post->post_id;
}
}
}
}
reset($mappings);
foreach ($mappings as $key => $val) {
$wpdb->query('UPDATE ' . $wpdb->prefix . "podpress_statcounts SET postID = '" . $val . "' WHERE media='" . $key . "'");
$wpdb->query('UPDATE ' . $wpdb->prefix . "podpress_stats SET postID = '" . $val . "' WHERE media='" . $key . "'");
}
}
case '7.9':
$create_table = "ALTER TABLE " . $wpdb->prefix . "podpress_stats ADD COLUMN completed TINYINT(1) UNSIGNED DEFAULT 0;";
podPress_maybe_add_column($wpdb->prefix . 'podpress_stats', 'completed', $create_table);
break;
case '8.3':
if ($this->settings['enablePodTracStats']) {
$this->settings['enable3rdPartyStats'] = 'PodTrac';
}
break;
default:
// do nothing
break;
}
if (function_exists('wp_cache_flush')) {
wp_cache_flush();
}
if (version_compare(PODPRESS_VERSION, $current, '>=')) {
update_option('podPress_version', $current);
}
$current = $current + 0.1;
}
}
/**
* edit_category - saves Category Casting and Tag Casting settings (hooked in via the action hook edit_term)
*
* @package podPress
* @since 8.8 (and before)
*
* @param str $term_id - the term id e.g. the ID number of a category
* @param str $tt_id - taxonomy term id
* @param str $taxonomy (optional) - the taxonomy type name e.g. category or post_tag (this parameter is the 3rd one of the action hook edit_term since WP 2.9)
*
*/
function edit_category($term_id, $tt_id, $taxonomy = 'category')
{
global $wp_version;
// because the $taxonomy parameter is only available since WP 2.9, it is necessary to determine the taxonomy name with own measures
if (TRUE == version_compare($wp_version, '2.9', '<')) {
$taxonomy = $this->get_taxonomy_by_ids($term_id, $tt_id);
}
if (!isset($_POST['iTunesFeedID']) or 'post_tag' !== $taxonomy and 'category' !== $taxonomy) {
return;
}
$blog_charset = get_bloginfo('charset');
$data = array();
if ($_POST['categoryCasting'] == 'on') {
$data['categoryCasting'] = 'true';
} else {
$data['categoryCasting'] = 'false';
}
$data['podcastFeedURL'] = clean_url($_POST['podcastFeedURL'], array('http', 'https'), 'db');
$data['iTunesFeedID'] = intval(preg_replace('/[^0-9]/', '', $_POST['iTunesFeedID']));
$data['iTunesNewFeedURL'] = $_POST['iTunesNewFeedURL'];
$data['blognameChoice'] = $_POST['blognameChoice'];
//~ // Attention: $data['blogname'] is here the name of the category
//~ if ( TRUE == version_compare($wp_version, '3.0', '<') ) {
//~ $data['blogname'] = htmlspecialchars(strip_tags(trim($_POST['cat_name'])), ENT_QUOTES, $blog_charset);
//~ } else {
//~ $data['blogname'] = htmlspecialchars(strip_tags(trim($_POST['name'])), ENT_QUOTES, $blog_charset);
//~ }
$data['blogdescriptionChoice'] = $_POST['blogdescriptionChoice'];
$data['iTunesSubtitleChoice'] = $_POST['iTunesSubtitleChoice'];
$data['iTunesSubtitle'] = htmlspecialchars(strip_tags(trim($_POST['iTunesSubtitle'])), ENT_QUOTES, $blog_charset);
$data['iTunesSummaryChoice'] = $_POST['iTunesSummaryChoice'];
$data['iTunesSummary'] = htmlspecialchars(strip_tags(trim($_POST['iTunesSummary'])), ENT_QUOTES, $blog_charset);
$data['iTunesKeywordsChoice'] = $_POST['iTunesKeywordsChoice'];
$data['iTunesKeywords'] = $this->cleanup_itunes_keywords($_POST['iTunesKeywords'], $blog_charset);
$data['iTunesAuthorChoice'] = $_POST['iTunesAuthorChoice'];
$data['iTunesAuthor'] = htmlspecialchars(strip_tags(trim($_POST['iTunesAuthor'])), ENT_QUOTES, $blog_charset);
$data['iTunesAuthorEmailChoice'] = $_POST['iTunesAuthorEmailChoice'];
$data['iTunesAuthorEmail'] = htmlspecialchars(strip_tags(trim($_POST['iTunesAuthorEmail'])), ENT_QUOTES, $blog_charset);
$data['rss_language'] = htmlspecialchars(strip_tags(trim($_POST['rss_language'])), ENT_QUOTES, $blog_charset);
$data['iTunesExplicit'] = $_POST['iTunesExplicit'];
$data['iTunesBlock'] = $_POST['iTunesBlock'];
$data['iTunesImageChoice'] = $_POST['iTunesImageChoice'];
$data['iTunesImage'] = clean_url($_POST['iTunesImage'], array('http', 'https'), 'db');
$data['rss_imageChoice'] = $_POST['rss_imageChoice'];
$data['rss_image'] = clean_url($_POST['rss_image'], array('http', 'https'), 'db');
$data['rss_copyrightChoice'] = $_POST['rss_copyrightChoice'];
$data['rss_copyright'] = htmlspecialchars(strip_tags(trim($_POST['rss_copyright'])), ENT_QUOTES, $blog_charset);
$data['rss_license_url'] = clean_url($_POST['rss_license_url'], array('http', 'https'), 'db');
$data['rss_license_urlChoice'] = $_POST['rss_license_urlChoice'];
$data['iTunesCategory'] = $_POST['iTunesCategory'];
$data['FileTypes'] = $_POST['FileTypes'];
if (isset($_POST['show_only_podPress_podcasts'])) {
$data['show_only_podPress_podcasts'] = TRUE;
} else {
$data['show_only_podPress_podcasts'] = FALSE;
}
delete_option('podPress_' . $taxonomy . '_' . $term_id);
podPress_add_option('podPress_' . $taxonomy . '_' . $term_id, $data);
}
function settings_podango_save()
{
global $wpdb;
if (function_exists('wp_cache_flush')) {
wp_cache_flush();
}
if (isset($_POST['podangdoMigration'])) {
$podangoMediaFiles = $this->podangoAPI->GetMediaFiles();
if (is_array($podangoMediaFiles) && !empty($podangoMediaFiles)) {
foreach ($podangoMediaFiles as $v) {
if (!empty($v['EpisodeID'])) {
$pmf[$v['Filename']] = array('EpisodeID' => $v['EpisodeID'], 'ID' => $v['ID']);
}
}
$sql = "SELECT *\n\t\t\t\t\t FROM " . $wpdb->prefix . "postmeta \n\t\t\t\t\t\t\t\t\tWHERE meta_key = '_podPressMedia'";
$metadata = $wpdb->get_results($sql);
if ($metadata) {
$posts2convert = array();
foreach ($metadata as $v) {
$save = false;
$v->meta_value = unserialize($v->meta_value);
foreach ($v->meta_value as $k => $subv) {
$fn = podpress_getfilename($subv['URI']);
if (isset($pmf[$fn])) {
$v->meta_value[$k]['URI'] = 'Podango:' . $this->settings['podangoDefaultPodcast'] . ':' . $pmf[$fn]['ID'] . ':' . $pmf[$fn]['EpisodeID'] . ':' . $fn;
$save = true;
}
}
if ($save) {
$v->meta_value = serialize($v->meta_value);
$sql = "update " . $wpdb->prefix . "postmeta set meta_value = '" . $v->meta_value . "' where meta_id=" . $v->meta_id;
$wpdb->query($sql);
}
}
}
}
} elseif (isset($_POST['podangoUnMigration'])) {
$sql = "SELECT *\n\t\t\t\t\t FROM " . $wpdb->prefix . "postmeta \n\t\t\t\t\t\t\t\t\tWHERE meta_key = '_podPressMedia'";
$metadata = $wpdb->get_results($sql);
if ($metadata) {
$posts2convert = array();
foreach ($metadata as $v) {
$save = false;
$v->meta_value = unserialize($v->meta_value);
foreach ($v->meta_value as $k => $subv) {
$fn = podpress_getfilename($subv['URI']);
if (isset($fn)) {
$pos = strrpos($fn, ':');
$v->meta_value[$k]['URI'] = substr($fn, $pos);
$save = true;
}
}
if ($save) {
$v->meta_value = serialize($v->meta_value);
$sql = "update " . $wpdb->prefix . "postmeta set meta_value = '" . $v->meta_value . "' where meta_id=" . $v->meta_id;
$wpdb->query($sql);
}
}
}
} else {
if (isset($_post['enablepodangointegration'])) {
$this->settings['enablepodangointegration'] = true;
} else {
$this->settings['enablepodangointegration'] = false;
}
if (isset($_POST['podangoUserKey'])) {
$this->settings['podangoUserKey'] = $_POST['podangoUserKey'];
}
if (isset($_POST['podangoPassKey'])) {
$this->settings['podangoPassKey'] = $_POST['podangoPassKey'];
}
if (isset($_POST['podangoDefaultPodcast']) && $_POST['podangoDefaultPodcast'] !== 0) {
$this->settings['podangoDefaultPodcast'] = $_POST['podangoDefaultPodcast'];
}
if (isset($_POST['podangoDefaultTranscribe'])) {
$this->settings['podangoDefaultTranscribe'] = true;
} else {
$this->settings['podangoDefaultTranscribe'] = false;
}
delete_option('podPress_config');
podPress_add_option('podPress_config', $this->settings);
}
$location = get_option('siteurl') . '/wp-admin/admin.php?page=podpress/podpress_podango.php&updated=true';
header('Location: ' . $location);
exit;
}
function edit_category($cat_ID)
{
global $wp_version;
if (!isset($_POST['iTunesFeedID'])) {
return;
}
$blog_charset = get_bloginfo('charset');
$data = array();
if ($_POST['categoryCasting'] == 'on') {
$data['categoryCasting'] = 'true';
} else {
$data['categoryCasting'] = 'false';
}
$data['podcastFeedURL'] = clean_url($_POST['podcastFeedURL'], array('http', 'https'), 'db');
$data['iTunesFeedID'] = intval(preg_replace('/[^0-9]/', '', $_POST['iTunesFeedID']));
$data['iTunesNewFeedURL'] = $_POST['iTunesNewFeedURL'];
$data['blognameChoice'] = $_POST['blognameChoice'];
//~ // Attention: $data['blogname'] is here the name of the category
//~ if ( TRUE == version_compare($wp_version, '3.0', '<') ) {
//~ $data['blogname'] = htmlspecialchars(strip_tags(trim($_POST['cat_name'])), ENT_QUOTES, $blog_charset);
//~ } else {
//~ $data['blogname'] = htmlspecialchars(strip_tags(trim($_POST['name'])), ENT_QUOTES, $blog_charset);
//~ }
$data['blogdescriptionChoice'] = $_POST['blogdescriptionChoice'];
$data['iTunesSubtitleChoice'] = $_POST['iTunesSubtitleChoice'];
$data['iTunesSubtitle'] = htmlspecialchars(strip_tags(trim($_POST['iTunesSubtitle'])), ENT_QUOTES, $blog_charset);
$data['iTunesSummaryChoice'] = $_POST['iTunesSummaryChoice'];
$data['iTunesSummary'] = htmlspecialchars(strip_tags(trim($_POST['iTunesSummary'])), ENT_QUOTES, $blog_charset);
$data['iTunesKeywordsChoice'] = $_POST['iTunesKeywordsChoice'];
$data['iTunesKeywords'] = $this->cleanup_itunes_keywords($_POST['iTunesKeywords'], $blog_charset);
$data['iTunesAuthorChoice'] = $_POST['iTunesAuthorChoice'];
$data['iTunesAuthor'] = htmlspecialchars(strip_tags(trim($_POST['iTunesAuthor'])), ENT_QUOTES, $blog_charset);
$data['iTunesAuthorEmailChoice'] = $_POST['iTunesAuthorEmailChoice'];
$data['iTunesAuthorEmail'] = htmlspecialchars(strip_tags(trim($_POST['iTunesAuthorEmail'])), ENT_QUOTES, $blog_charset);
$data['rss_language'] = htmlspecialchars(strip_tags(trim($_POST['rss_language'])), ENT_QUOTES, $blog_charset);
$data['iTunesExplicit'] = $_POST['iTunesExplicit'];
$data['iTunesBlock'] = $_POST['iTunesBlock'];
$data['iTunesImageChoice'] = $_POST['iTunesImageChoice'];
$data['iTunesImage'] = clean_url($_POST['iTunesImage'], array('http', 'https'), 'db');
$data['rss_imageChoice'] = $_POST['rss_imageChoice'];
$data['rss_image'] = clean_url($_POST['rss_image'], array('http', 'https'), 'db');
$data['rss_copyrightChoice'] = $_POST['rss_copyrightChoice'];
$data['rss_copyright'] = htmlspecialchars(strip_tags(trim($_POST['rss_copyright'])), ENT_QUOTES, $blog_charset);
$data['rss_license_url'] = clean_url($_POST['rss_license_url'], array('http', 'https'), 'db');
$data['rss_license_urlChoice'] = $_POST['rss_license_urlChoice'];
$data['iTunesCategory'] = $_POST['iTunesCategory'];
$data['FileTypes'] = $_POST['FileTypes'];
if (isset($_POST['show_only_podPress_podcasts'])) {
$data['show_only_podPress_podcasts'] = TRUE;
} else {
$data['show_only_podPress_podcasts'] = FALSE;
}
delete_option('podPress_category_' . $cat_ID);
podPress_add_option('podPress_category_' . $cat_ID, $data);
}