public function batch_enable()
{
if (!isset($_REQUEST['episode_asset'])) {
return;
}
$podcast = Model\Podcast::get();
$asset = Model\EpisodeAsset::find_by_id($_REQUEST['episode_asset']);
$episodes = Model\Episode::all();
foreach ($episodes as $episode) {
$post_id = $episode->post_id;
$post = get_post($post_id);
// skip deleted podcasts
if (!in_array($post->post_status, array('pending', 'draft', 'publish', 'future'))) {
continue;
}
// skip versions
if ($post->post_type != 'podcast') {
continue;
}
$file = Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
if ($file === NULL) {
$file = new Model\MediaFile();
$file->episode_id = $episode->id;
$file->episode_asset_id = $asset->id;
$file->save();
}
}
$this->redirect('index', NULL, array('message' => 'media_file_batch_enabled_notice'));
}
private function get_raw_chapters_string()
{
$asset_assignment = Model\AssetAssignment::get_instance();
$cache_key = 'podlove_chapters_string_' . $this->episode->id;
if (($chapters_string = get_transient($cache_key)) !== FALSE) {
return $chapters_string;
} else {
if ($asset_assignment->chapters == 'manual') {
return $this->episode->chapters;
} else {
if (!($chapters_asset = Model\EpisodeAsset::find_one_by_id($asset_assignment->chapters))) {
return '';
}
if (!($chapters_file = Model\MediaFile::find_by_episode_id_and_episode_asset_id($this->episode->id, $chapters_asset->id))) {
return '';
}
$chapters_string = wp_remote_get($chapters_file->get_file_url());
if (is_wp_error($chapters_string)) {
return '';
}
set_transient($cache_key, $chapters_string['body'], 60 * 60 * 24 * 365);
// 1 year, we devalidate manually
return $chapters_string['body'];
}
}
}
function podlove_handle_media_file_download()
{
$download_media_file = podlove_get_query_var('download_media_file');
if (!$download_media_file) {
return;
}
// tell WP Super Cache to not cache download links
if (!defined('DONOTCACHEPAGE')) {
define('DONOTCACHEPAGE', true);
}
// use this hook to short-circuit the download logic
if (apply_filters('podlove_pre_media_file_download', false, $download_media_file)) {
exit;
}
$media_file_id = (int) $download_media_file;
$media_file = Model\MediaFile::find_by_id($media_file_id);
if (!$media_file) {
status_header(404);
exit;
}
$episode_asset = $media_file->episode_asset();
if (!$episode_asset || !$episode_asset->downloadable) {
status_header(404);
exit;
}
do_action('podlove_download_file', $media_file);
// build redirect url
$location = $media_file->add_ptm_parameters($media_file->get_file_url(), ['source' => trim(podlove_get_query_var('ptm_source')), 'context' => trim(podlove_get_query_var('ptm_context'))]);
header("HTTP/1.1 301 Moved Permanently");
header("Location: " . $location);
exit;
}
public static function create()
{
$episode_id = (int) $_REQUEST['episode_id'];
$episode_asset_id = (int) $_REQUEST['episode_asset_id'];
if (!$episode_id || !$episode_asset_id) {
die;
}
if (isset($_REQUEST['slug'])) {
self::simulate_temporary_episode_slug($_REQUEST['slug']);
}
$file = MediaFile::find_or_create_by_episode_id_and_episode_asset_id($episode_id, $episode_asset_id);
Ajax::respond_with_json(array('file_id' => $file->id, 'file_size' => $file->size, 'file_url' => $file->get_file_url()));
}
private static function get_downloads_per_hour_for_episode($episode_id)
{
global $wpdb;
$sql = "\n\t\t\tSELECT\n\t\t\t \tCOUNT(*) downloads, DATE_FORMAT(accessed_at, '%%Y-%%m-%%d %%H') AS access_hour\n\t\t\tFROM\t\t\n\t\t\t\t\t`" . \Podlove\Model\DownloadIntentClean::table_name() . "` di \n\t\t\t\t\tINNER JOIN `" . \Podlove\Model\MediaFile::table_name() . "` mf ON mf.id = di.media_file_id\n\t\t\t\t\tWHERE episode_id = %d\n\t\t\tGROUP BY access_hour\n\t\t\tORDER BY access_hour\n\t\t\tLIMIT %d\n\t\t";
$data = $wpdb->get_results($wpdb->prepare($sql, $episode_id, self::HOURS_TO_CALCULATE), ARRAY_A);
$release_date = $wpdb->get_var($wpdb->prepare("SELECT post_date FROM {$wpdb->posts} p JOIN " . \Podlove\Model\Episode::table_name() . " e ON e.post_id = p.ID WHERE e.id = %d", $episode_id));
if ($data) {
$missing_hours = self::add_missing_hours($data, $release_date);
array_splice($missing_hours, self::HOURS_TO_CALCULATE);
return array_column($missing_hours, 'downloads');
} else {
return array();
}
}
private function get_chapters_object()
{
global $wpdb;
// Get all posible assets with a chapter file format
$chapter_assets = Model\EpisodeAsset::find_all_by_sql("SELECT ea.*, ft.mime_type\n\t\t\t FROM {$wpdb->prefix}podlove_episodeasset AS ea\n\t\t\t INNER JOIN {$wpdb->prefix}podlove_filetype AS ft ON ft.id = ea.file_type_id\n\t\t\t WHERE ft.type = 'chapters'\n\t\t\t ORDER BY position ASC");
// Get IDs
$chapter_assets_id_to_mimetype = array();
foreach ($chapter_assets as $chapter_asset) {
$chapter_assets_id_to_mimetype[$chapter_asset->id] = $chapter_asset->mime_type;
}
// Try to find attached chapter file to this episode
$chapter_assets_ids = implode(',', array_keys($chapter_assets_id_to_mimetype));
$chapters_file = Model\MediaFile::find_one_by_where(sprintf("episode_id = %d\n\t\t\t AND episode_asset_id IN (%s)\n\t\t\t ORDER BY FIELD(episode_asset_id, %s)", $this->episode->id, $chapter_assets_ids, $chapter_assets_ids));
// Fallback to manual entry if no file was attached
if (null === $chapters_file) {
return Parser\Mp4chaps::parse($this->episode->chapters);
}
// Get mimetype for attached chapter file
$mime_type = $chapter_assets_id_to_mimetype[$chapters_file->episode_asset_id];
// Get chapters object for mine type
switch ($mime_type) {
case 'application/xml':
$contents = $this->get_raw_chapters_string($chapters_file);
$chapters = Parser\PSC::parse($contents);
break;
case 'application/json':
$contents = $this->get_raw_chapters_string($chapters_file);
$chapters = Parser\JSON::parse($contents);
break;
case 'text/plain':
$contents = $this->get_raw_chapters_string($chapters_file);
switch ($contents[0]) {
case '[':
case '{':
$chapters = Parser\JSON::parse($contents);
break;
case '<':
$chapters = Parser\PSC::parse($contents);
break;
default:
$chapters = Parser\Mp4chaps::parse($contents);
break;
}
break;
default:
$chapters = '';
}
// Apply filter
return apply_filters('podlove_get_chapters_object', '' === $chapters || null === $chapters ? new Chapters() : $chapters, $mime_type, $chapters_file, $this);
}
public static function content()
{
global $wpdb;
$sql = "\n\t\tSELECT\n\t\t\tp.post_status,\n\t\t\tmf.episode_id,\n\t\t\tmf.episode_asset_id,\n\t\t\tmf.size,\n\t\t\tmf.id media_file_id\n\t\tFROM\n\t\t\t`" . Model\MediaFile::table_name() . "` mf\n\t\t\tJOIN `" . Model\Episode::table_name() . "` e ON e.id = mf.`episode_id`\n\t\t\tJOIN `" . $wpdb->posts . "` p ON e.`post_id` = p.`ID`\n\t\tWHERE\n\t\t\tp.`post_type` = 'podcast'\n\t\t\tAND p.post_status in ('private', 'draft', 'publish', 'pending', 'future')\n\t\t";
$rows = $wpdb->get_results($sql, ARRAY_A);
$media_files = [];
foreach ($rows as $row) {
if (!isset($media_files[$row['episode_id']])) {
$media_files[$row['episode_id']] = ['post_status' => $row["post_status"]];
}
$media_files[$row['episode_id']][$row['episode_asset_id']] = ['size' => $row['size'], 'media_file_id' => $row['media_file_id']];
}
$podcast = Model\Podcast::get();
$episodes = $podcast->episodes();
$assets = Model\EpisodeAsset::all();
$header = [__('Episode', 'podlove')];
foreach ($assets as $asset) {
$header[] = $asset->title;
}
$header[] = __('Status', 'podlove');
\Podlove\load_template('settings/dashboard/file_validation', ['episodes' => $episodes, 'assets' => $assets, 'media_files' => $media_files, 'header' => $header]);
}
/**
* Fetch form data for EpisodeAssets multiselect.
*
* @param \Podlove\Model\Episode $episode
* @return array
*/
public static function episode_assets_form($episode)
{
$episode_assets = Model\EpisodeAsset::all();
// field to generate option list
$asset_options = array();
// values for option list
$asset_values = array();
foreach ($episode_assets as $asset) {
if (!($file_type = $asset->file_type())) {
continue;
}
// get formats configured for this show
$asset_options[$asset->id] = $asset->title;
// find out which formats are active
$asset_values[$asset->id] = NULL !== Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
}
// FIXME: empty checkbox -> no file id
// solution: when one checks the box, an AJAX request has to create and validate the file
$episode_assets_form = array('label' => __('Media Files', 'podlove'), 'description' => '', 'options' => $asset_options, 'default' => true, 'multi_values' => $asset_values, 'multiselect_callback' => function ($asset_id) use($episode) {
$asset = \Podlove\Model\EpisodeAsset::find_by_id($asset_id);
$format = $asset->file_type();
$file = \Podlove\Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
$attributes = array('data-template' => $asset->url_template, 'data-extension' => $format->extension, 'data-size' => is_object($file) ? $file->size : 0, 'data-episode-asset-id' => $asset->id, 'data-episode-id' => $episode->id);
if ($file) {
$attributes['data-id'] = $file->id;
}
$out = '';
foreach ($attributes as $key => $value) {
$out .= sprintf('%s="%s" ', $key, $value);
}
return $out;
});
if (empty($asset_options)) {
$episode_assets_form['description'] = sprintf('<span style="color: red">%s</span>', __('You need to configure feeds for this show. No feeds, no fun.', 'podlove')) . ' ' . sprintf('<a href="%s">%s</a>', admin_url('admin.php?page=podlove_shows_settings_handle&action=edit&show=' . $show->id), __('Edit this show', 'podlove'));
}
return $episode_assets_form;
}
public function refetch_files()
{
$valid_files = array();
foreach (EpisodeAsset::all() as $asset) {
if ($file = MediaFile::find_by_episode_id_and_episode_asset_id($this->id, $asset->id)) {
$file->determine_file_size();
$file->save();
if ($file->is_valid()) {
$valid_files[] = $file->id;
}
}
}
if (empty($valid_files) && get_post_status($this->post_id) == 'publish') {
Log::get()->addAlert('All assets for this episode are invalid!', array('episode_id' => $this->id));
}
}
public static function cleanup_download_intents()
{
global $wpdb;
$sql = "INSERT INTO `" . Model\DownloadIntentClean::table_name() . "` (`id`, `user_agent_id`, `media_file_id`, `request_id`, `accessed_at`, `source`, `context`, `geo_area_id`, `lat`, `lng`, `httprange`, `hours_since_release`)\n\t\tSELECT\n\t\t\tdi.id, `user_agent_id`, `media_file_id`, `request_id`, `accessed_at`, `source`, `context`, `geo_area_id`, `lat`, `lng`, `httprange`,\n\t\t\tTIMESTAMPDIFF(HOUR, p.post_date_gmt, accessed_at)\n\t\tFROM\n\t\t\t`" . Model\DownloadIntent::table_name() . "` di\n\t\t\tINNER JOIN " . Model\MediaFile::table_name() . " mf ON mf.id = di.media_file_id -- filter dead intents\n\t\t\tINNER JOIN " . Model\Episode::table_name() . " e ON episode_id = e.id\n\t\t\tINNER JOIN {$wpdb->posts} p ON e.post_id = p.ID\n\t\tWHERE\n\t\t\tdi.accessed_at > p.post_date_gmt -- ignore pre-release intents\n\t\t\tAND user_agent_id NOT IN (SELECT id FROM `" . Model\UserAgent::table_name() . "` WHERE bot) -- filter out bots\n\t\t\tAND di.id > %d\n\t\tGROUP BY media_file_id, request_id, DATE_FORMAT(accessed_at, '%%Y-%%m-%%d %%H') -- deduplication\n\t\t";
$wpdb->query($wpdb->prepare($sql, self::get_last_insert_id()));
}
<?php
use Podlove\Model;
// devalidate caches when media file has changed
add_action('podlove_media_file_content_has_changed', function ($media_file_id) {
if ($media_file = Model\MediaFile::find_by_id($media_file_id)) {
if ($episode = $media_file->episode()) {
$episode->delete_caches();
}
}
});
// devalidate caches when episode content has changed
add_action('podlove_episode_content_has_changed', function ($episode_id) {
if ($episode = Model\Episode::find_by_id($episode_id)) {
$episode->delete_caches();
}
});
function override_feed_entry($hook, $podcast, $feed, $format)
{
add_action($hook, function () use($podcast, $feed, $format) {
global $post;
$episode = \Podlove\Model\Episode::find_one_by_post_id($post->ID);
$asset = $feed->episode_asset();
$file = \Podlove\Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
if (!$file) {
return;
}
$enclosure_duration = $episode->duration;
$enclosure_file_size = $file->size;
$file_slug = $episode->slug;
$cover_art_url = $episode->get_cover_art();
// fall back to podcast cover image
if (!$cover_art_url) {
$cover_art_url = $podcast->cover_image;
}
$enclosure_url = $episode->enclosure_url($feed->episode_asset());
echo apply_filters('podlove_feed_enclosure', '', $enclosure_url, $enclosure_file_size, $format->mime_type);
$duration = sprintf('<itunes:duration>%s</itunes:duration>', $enclosure_duration);
echo apply_filters('podlove_feed_itunes_duration', $duration);
$author = sprintf('<itunes:author>%s</itunes:author>', $podcast->author_name);
echo apply_filters('podlove_feed_itunes_author', $author);
$subtitle = sprintf('<itunes:subtitle>%s</itunes:subtitle>', htmlspecialchars(strip_tags($episode->subtitle)));
echo apply_filters('podlove_feed_itunes_subtitle', $subtitle);
$summary = sprintf('<itunes:summary>%s</itunes:summary>', htmlspecialchars(strip_tags($episode->summary)));
echo apply_filters('podlove_feed_itunes_summary', $summary);
if ($cover_art_url) {
$cover_art = sprintf('<itunes:image href="%s" />', $cover_art_url);
} else {
$cover_art = '';
}
echo apply_filters('podlove_feed_itunes_image', $cover_art);
});
}
public function validate_url()
{
$file_url = $_REQUEST['file_url'];
$info = \Podlove\Model\MediaFile::curl_get_header_for_url($file_url);
$header = $info['header'];
$reachable = $header['http_code'] >= 200 && $header['http_code'] < 300;
$validation_cache = get_option('podlove_migration_validation_cache', array());
$validation_cache[$file_url] = $reachable;
update_option('podlove_migration_validation_cache', $validation_cache);
self::respond_with_json(array('file_url' => $file_url, 'reachable' => $reachable, 'file_size' => $header['download_content_length']));
}
/**
* Hook into post deletion and remove associated episode.
*
* @param int $post_id
*/
public function delete_trashed_episodes($post_id)
{
$episode = Model\Episode::find_one_by_post_id($post_id);
if (!$episode) {
return;
}
if ($media_files = Model\MediaFile::find_all_by_episode_id($episode->id)) {
foreach ($media_files as $media_file) {
$media_file->delete();
}
}
$episode->delete();
}
public function dashoard_template()
{
?>
<style type="text/css">
#podlove-log {
height: 500px;
overflow: auto;
font-family: monospace;
font-size: 14px;
line-height: 18px;
padding: 5px;
}
.log-level-200 { }
.log-level-400 { color: #95002B; }
.log-level-550 { background: #95002B; color: #FAD4AF; }
.log-level-550 a { color: #F4E6AD; }
</style>
<script type="text/javascript">
jQuery(function($) {
$(document).ready(function() {
// scroll down
$("#podlove-log").scrollTop($("#podlove-log")[0].scrollHeight);
});
});
</script>
<?php
if ($timezone = get_option('timezone_string')) {
date_default_timezone_set($timezone);
}
?>
<div id="podlove-log">
<?php
foreach (LogTable::find_all_by_where("time > " . strtotime("-1 week")) as $log_entry) {
?>
<div class="log-entry log-level-<?php
echo $log_entry->level;
?>
">
<span class="log-date">
[<?php
echo date('Y-m-d H:i:s', $log_entry->time);
?>
]
</span>
<span class="log-message">
<?php
echo $log_entry->message;
?>
</span>
<span class="log-extra">
<?php
$data = json_decode($log_entry->context);
if (isset($data->media_file_id)) {
if ($media_file = Model\MediaFile::find_by_id($data->media_file_id)) {
if ($episode = $media_file->episode()) {
if ($asset = $media_file->episode_asset()) {
echo sprintf('<a href="%s">%s/%s</a>', get_edit_post_link($episode->post_id), $episode->slug, $asset->title);
}
}
}
}
if (isset($data->error)) {
echo sprintf(' "%s"', $data->error);
}
if (isset($data->episode_id)) {
if ($episode = Model\Episode::find_by_id($data->episode_id)) {
echo sprintf(' <a href="%s">%s</a>', get_edit_post_link($episode->post_id), get_the_title($episode->post_id));
}
}
if (isset($data->http_code)) {
echo " HTTP Status: " . $data->http_code;
}
if (isset($data->mime_type) && isset($data->expected_mime_type)) {
echo " Expected: {$data->expected_mime_type}, but found: {$data->mime_type}";
}
if (isset($data->type) && $data->type == 'twig') {
echo sprintf('in template "%s" line %d', $data->template, $data->line);
}
?>
</span>
</div>
<?php
}
?>
</div>
<?php
}
function create_file()
{
$episode_id = $_REQUEST['episode_id'];
$episode_asset_id = $_REQUEST['episode_asset_id'];
if (!$episode_id || !$episode_asset_id) {
die;
}
$file = Model\MediaFile::find_or_create_by_episode_id_and_episode_asset_id($episode_id, $episode_asset_id);
$result = array();
$result['file_id'] = $file->id;
$result['file_size'] = $file->size;
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
echo json_encode($result);
die;
}
function migrate_post($post_id)
{
$post = get_post($post_id);
$migration_settings = get_option('podlove_migration', array());
$post_content = $post->post_content;
if ($migration_settings['cleanup']['player']) {
$post_content = preg_replace('/\\[(powerpress|podloveaudio|podlovevideo|display_podcast)[^\\]]*\\]/', '', $post_content);
}
$new_post = array('menu_order' => $post->menu_order, 'comment_status' => $post->comment_status, 'ping_status' => $post->ping_status, 'post_author' => $post->post_author, 'post_content' => $post_content, 'post_excerpt' => $post->post_excerpt, 'post_mime_type' => $post->post_mime_type, 'post_parent' => $post_id, 'post_password' => $post->post_password, 'post_status' => 'pending', 'post_title' => $post->post_title, 'post_type' => 'podcast', 'post_date' => $post->post_date, 'post_date_gmt' => get_gmt_from_date($post->post_date));
$new_slug = NULL;
switch ($migration_settings['post_slug']) {
case 'wordpress':
$new_slug = $post->post_name;
break;
case 'file':
$new_slug = Assistant::get_file_slug($post);
break;
case 'number':
$new_slug = Assistant::get_number_slug($post);
break;
}
$override_slug = function ($data, $postarr) use($new_slug) {
if ($new_slug) {
$data['post_name'] = $new_slug;
}
return $data;
};
add_filter('wp_insert_post_data', $override_slug, 10, 2);
$new_post_id = wp_insert_post($new_post);
remove_filter('wp_insert_post_data', $override_slug, 10, 2);
$new_post = get_post($new_post_id);
// update guid
update_post_meta($new_post_id, '_podlove_guid', $post->guid);
// add redirect from previous url
add_post_meta($new_post_id, 'podlove_alternate_url', get_permalink($post_id));
// prevent adn module from triggering a post
update_post_meta($new_post_id, '_podlove_episode_was_published', true);
// migrate taxonomies
$taxonomies = get_object_taxonomies(get_post_type($post_id));
foreach ($taxonomies as $tax) {
$terms = wp_get_object_terms($post_id, $tax);
$term = array();
foreach ($terms as $t) {
$term[] = $t->slug;
}
wp_set_object_terms($new_post_id, $term, $tax);
}
$post_data = new Legacy_Post_Parser($post_id);
$episode = Model\Episode::find_or_create_by_post_id($new_post_id);
$episode->slug = Assistant::get_episode_slug($post, $migration_settings['slug']);
$episode->duration = $post_data->get_duration();
$episode->subtitle = $post_data->get_subtitle();
$episode->summary = $post_data->get_summary();
$episode->save();
foreach (Model\EpisodeAsset::all() as $asset) {
Model\MediaFile::find_or_create_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
}
// copy all meta
$meta = get_post_meta($post_id);
foreach ($meta as $key => $values) {
if (!in_array($key, array('enclosure', '_podPressPostSpecific', '_podPressMedia')) || !$migration_settings['cleanup']['enclosures']) {
foreach ($values as $value) {
add_post_meta($new_post_id, $key, $value);
}
}
}
// copy all comments
$comments_map = array();
// map old comment IDs to new comment IDs
foreach (get_comments(array('post_id' => $post_id, 'order' => 'ASC')) as $comment) {
$old_comment_id = $comment->comment_ID;
$comment->comment_post_ID = $new_post_id;
if ($comment->comment_parent && isset($comments_map[$comment->comment_parent])) {
$comment->comment_parent = $comments_map[$comment->comment_parent];
}
$new_comment_id = wp_insert_comment((array) $comment);
$comments_map[$old_comment_id] = $new_comment_id;
}
return $new_post_id;
}
/**
* Provides shortcode to display web player.
*
* Right now there is only audio support.
*
* Usage:
* [podlove-web-player]
*
* @param array $options
* @return string
*/
function webplayer_shortcode($options)
{
global $post;
$episode = Model\Episode::find_or_create_by_post_id($post->ID);
$podcast = Model\Podcast::get_instance();
$formats_data = get_option('podlove_webplayer_formats');
if (!count($formats_data)) {
return;
}
$available_formats = array();
$audio_formats = array('mp3', 'mp4', 'ogg');
foreach ($audio_formats as $audio_format) {
$episode_asset = Model\EpisodeAsset::find_by_id($formats_data['audio'][$audio_format]);
if (!$episode_asset) {
continue;
}
$media_file = Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $episode_asset->id);
if ($media_file) {
$available_formats[] = sprintf('%s="%s"', $audio_format, $media_file->get_file_url());
}
}
$chapters = '';
if ($episode->chapters) {
$chapters = 'chapters="_podlove_chapters"';
}
return do_shortcode('[podloveaudio ' . implode(' ', $available_formats) . ' ' . $chapters . ']');
}
function override_feed_entry($hook, $podcast, $feed, $format)
{
add_action($hook, function () use($podcast, $feed, $format) {
global $post;
$cache = \Podlove\Cache\TemplateCache::get_instance();
echo $cache->cache_for('feed_item_' . $feed->slug . '_' . $post->ID, function () use($podcast, $feed, $format, $post) {
$xml = "";
$episode = Model\Episode::find_one_by_post_id($post->ID);
$asset = $feed->episode_asset();
$file = Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
$asset_assignment = Model\AssetAssignment::get_instance();
if (!$file) {
return;
}
$enclosure_file_size = $file->size;
$cover_art_url = "";
if ($cover_art = $episode->cover_art()) {
$cover_art_url = $cover_art->url();
}
if (isset($_REQUEST['tracking']) && $_REQUEST['tracking'] == 'no') {
$enclosure_url = $episode->enclosure_url($feed->episode_asset(), null, null);
} else {
$enclosure_url = $episode->enclosure_url($feed->episode_asset(), "feed", $feed->slug);
}
$deep_link = Model\Feed::get_link_tag(array('prefix' => 'atom', 'rel' => 'http://podlove.org/deep-link', 'type' => '', 'title' => '', 'href' => get_permalink() . "#"));
$xml .= apply_filters('podlove_deep_link', $deep_link, $feed);
$xml .= apply_filters('podlove_feed_enclosure', '', $enclosure_url, $enclosure_file_size, $format->mime_type, $file);
$duration = sprintf('<itunes:duration>%s</itunes:duration>', $episode->get_duration('HH:MM:SS'));
$xml .= apply_filters('podlove_feed_itunes_duration', $duration);
$author = apply_filters('podlove_feed_content', $podcast->author_name);
$author = sprintf('<itunes:author>%s</itunes:author>', $author);
$xml .= apply_filters('podlove_feed_itunes_author', $author);
$subtitle = apply_filters('podlove_feed_content', \Podlove\PHP\escape_shortcodes(strip_tags($episode->subtitle)));
$subtitle = sprintf('<itunes:subtitle>%s</itunes:subtitle>', $subtitle);
$xml .= apply_filters('podlove_feed_itunes_subtitle', $subtitle);
$summary = apply_filters('podlove_feed_content', \Podlove\PHP\escape_shortcodes(strip_tags($episode->summary)));
$summary = sprintf('<itunes:summary>%s</itunes:summary>', $summary);
$xml .= apply_filters('podlove_feed_itunes_summary', $summary);
if (\Podlove\get_setting('metadata', 'enable_episode_explicit')) {
$itunes_explicit = apply_filters('podlove_feed_content', $episode->explicit_text());
$itunes_explicit = sprintf('<itunes:explicit>%s</itunes:explicit>', $itunes_explicit);
$xml .= apply_filters('podlove_feed_itunes_explicit', $itunes_explicit);
}
if ($cover_art_url) {
$cover_art = sprintf('<itunes:image href="%s" />', $cover_art_url);
} else {
$cover_art = '';
}
$xml .= apply_filters('podlove_feed_itunes_image', $cover_art);
if ($feed->embed_content_encoded) {
add_filter('the_content_feed', function ($content, $feed_type) {
return preg_replace('#<style(.*?)>(.*?)</style>#is', '', $content);
}, 10, 2);
$content_encoded = '<content:encoded><![CDATA[' . get_the_content_feed('rss2') . ']]></content:encoded>';
$xml .= apply_filters('podlove_feed_content_encoded', $content_encoded);
}
ob_start();
do_action('podlove_append_to_feed_entry', $podcast, $episode, $feed, $format);
$xml .= ob_get_contents();
ob_end_clean();
return $xml;
}, 15 * MINUTE_IN_SECONDS);
}, 11);
}
public static function find_by_episode_id_and_episode_asset_id($episode_id, $episode_asset_id)
{
$where = sprintf('episode_id = "%s" AND episode_asset_id = "%s"', $episode_id, $episode_asset_id);
return MediaFile::find_one_by_where($where);
}
/**
* Find and run migration for given version number.
*
* @todo move migrations into separate files
*
* @param int $version
*/
function run_migrations_for_version($version)
{
global $wpdb;
switch ($version) {
case 10:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `summary` TEXT', \Podlove\Model\Episode::table_name());
$wpdb->query($sql);
break;
case 11:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `downloadable` INT', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 12:
$sql = sprintf('UPDATE `%s` SET `downloadable` = 1', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 13:
$opus = array('name' => 'Opus Audio', 'type' => 'audio', 'mime_type' => 'audio/opus', 'extension' => 'opus');
$f = new \Podlove\Model\FileType();
foreach ($opus as $key => $value) {
$f->{$key} = $value;
}
$f->save();
break;
case 14:
$sql = sprintf('ALTER TABLE `%s` RENAME TO `%s`', $wpdb->prefix . 'podlove_medialocation', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 15:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_location_id` `episode_asset_id` INT', \Podlove\Model\MediaFile::table_name());
$wpdb->query($sql);
break;
case 16:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_location_id` `episode_asset_id` INT', \Podlove\Model\Feed::table_name());
$wpdb->query($sql);
break;
case 17:
$sql = sprintf('ALTER TABLE `%s` RENAME TO `%s`', $wpdb->prefix . 'podlove_mediaformat', \Podlove\Model\FileType::table_name());
$wpdb->query($sql);
break;
case 18:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_format_id` `file_type_id` INT', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 19:
\Podlove\Model\Template::build();
break;
case 20:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `suffix` VARCHAR(255)', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `url_template`', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 21:
$podcast = Model\Podcast::get();
$podcast->url_template = '%media_file_base_url%%episode_slug%%suffix%.%format_extension%';
$podcast->save();
break;
case 22:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `redirect_http_status` INT AFTER `redirect_url`', Model\Feed::table_name());
$wpdb->query($sql);
break;
case 23:
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `show_description`', Model\Feed::table_name());
$wpdb->query($sql);
break;
case 24:
$podcast = Model\Podcast::get();
update_option('podlove_asset_assignment', array('image' => $podcast->supports_cover_art, 'chapters' => $podcast->chapter_file));
break;
case 25:
// rename meta podlove_guid to _podlove_guid
$episodes = Model\Episode::all();
foreach ($episodes as $episode) {
$post = get_post($episode->post_id);
// skip revisions
if ($post->post_status == 'inherit') {
continue;
}
$guid = get_post_meta($episode->post_id, 'podlove_guid', true);
if (!$guid) {
$guid = $post->guid;
}
delete_post_meta($episode->post_id, 'podlove_guid');
update_post_meta($episode->post_id, '_podlove_guid', $guid);
}
break;
case 26:
$wpdb->query(sprintf('ALTER TABLE `%s` MODIFY COLUMN `subtitle` TEXT', Model\Episode::table_name()));
break;
case 27:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `record_date` DATETIME AFTER `chapters`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `publication_date` DATETIME AFTER `record_date`', Model\Episode::table_name()));
break;
case 28:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `position` FLOAT AFTER `downloadable`', Model\EpisodeAsset::table_name()));
$wpdb->query(sprintf('UPDATE `%s` SET position = id', Model\EpisodeAsset::table_name()));
break;
case 29:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `embed_content_encoded` INT AFTER `limit_items`', Model\Feed::table_name()));
break;
case 30:
$wpdb->query(sprintf('ALTER TABLE `%s` MODIFY `autoinsert` VARCHAR(255)', Model\Template::table_name()));
break;
case 32:
flush_rewrite_rules();
break;
case 33:
$apd = array('name' => 'Auphonic Production Description', 'type' => 'metadata', 'mime_type' => 'application/json', 'extension' => 'json');
$f = new \Podlove\Model\FileType();
foreach ($apd as $key => $value) {
$f->{$key} = $value;
}
$f->save();
break;
case 34:
$options = get_option('podlove', array());
if (!array_key_exists('episode_archive', $options)) {
$options['episode_archive'] = 'on';
}
if (!array_key_exists('episode_archive_slug', $options)) {
$options['episode_archive_slug'] = '/podcast/';
}
if (!array_key_exists('use_post_permastruct', $options)) {
$options['use_post_permastruct'] = 'off';
}
if (!array_key_exists('custom_episode_slug', $options)) {
$options['custom_episode_slug'] = '/podcast/%podcast%/';
} else {
$options['custom_episode_slug'] = preg_replace('#/+#', '/', '/' . str_replace('#', '', $options['custom_episode_slug']));
}
update_option('podlove', $options);
break;
case 35:
Model\Feed::build_indices();
Model\FileType::build_indices();
Model\EpisodeAsset::build_indices();
Model\MediaFile::build_indices();
Model\Episode::build_indices();
Model\Template::build_indices();
break;
case 36:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `etag` VARCHAR(255)', Model\MediaFile::table_name()));
break;
case 37:
\Podlove\Modules\Base::activate('asset_validation');
break;
case 38:
\Podlove\Modules\Base::activate('logging');
break;
case 39:
// migrate previous template autoinsert settings
$assignments = Model\TemplateAssignment::get_instance();
$results = $wpdb->get_results(sprintf('SELECT * FROM `%s`', Model\Template::table_name()));
foreach ($results as $template) {
if ($template->autoinsert == 'beginning') {
$assignments->top = $template->id;
} elseif ($template->autoinsert == 'end') {
$assignments->bottom = $template->id;
}
}
$assignments->save();
// remove template autoinsert column
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `autoinsert`', \Podlove\Model\Template::table_name());
$wpdb->query($sql);
break;
case 40:
$wpdb->query(sprintf('UPDATE `%s` SET position = id WHERE position IS NULL', Model\EpisodeAsset::table_name()));
break;
case 41:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `position` FLOAT AFTER `slug`', Model\Feed::table_name()));
$wpdb->query(sprintf('UPDATE `%s` SET position = id', Model\Feed::table_name()));
break;
case 42:
$wpdb->query('DELETE FROM `' . $wpdb->options . '` WHERE option_name LIKE "%podlove_chapters_string_%"');
break;
case 43:
$podlove_options = get_option('podlove', array());
$podlove_website = array('merge_episodes' => isset($podlove_options['merge_episodes']) ? $podlove_options['merge_episodes'] : false, 'hide_wp_feed_discovery' => isset($podlove_options['hide_wp_feed_discovery']) ? $podlove_options['hide_wp_feed_discovery'] : false, 'use_post_permastruct' => isset($podlove_options['use_post_permastruct']) ? $podlove_options['use_post_permastruct'] : false, 'custom_episode_slug' => isset($podlove_options['custom_episode_slug']) ? $podlove_options['custom_episode_slug'] : '/episode/%podcast%', 'episode_archive' => isset($podlove_options['episode_archive']) ? $podlove_options['episode_archive'] : false, 'episode_archive_slug' => isset($podlove_options['episode_archive_slug']) ? $podlove_options['episode_archive_slug'] : '/podcast/', 'url_template' => isset($podlove_options['url_template']) ? $podlove_options['url_template'] : '%media_file_base_url%%episode_slug%%suffix%.%format_extension%');
$podlove_metadata = array('enable_episode_record_date' => isset($podlove_options['enable_episode_record_date']) ? $podlove_options['enable_episode_record_date'] : false, 'enable_episode_publication_date' => isset($podlove_options['enable_episode_publication_date']) ? $podlove_options['enable_episode_publication_date'] : false);
$podlove_redirects = array('podlove_setting_redirect' => isset($podlove_options['podlove_setting_redirect']) ? $podlove_options['podlove_setting_redirect'] : array());
add_option('podlove_website', $podlove_website);
add_option('podlove_metadata', $podlove_metadata);
add_option('podlove_redirects', $podlove_redirects);
break;
case 44:
$wpdb->query('DELETE FROM `' . $wpdb->postmeta . '` WHERE meta_key = "last_validated_at"');
break;
case 45:
delete_transient('podlove_auphonic_user');
delete_transient('podlove_auphonic_presets');
break;
case 46:
if (\Podlove\Modules\Base::is_active('contributors')) {
// manually trigger activation if the old module was active
$module = \Podlove\Modules\Contributors\Contributors::instance();
$module->was_activated('contributors');
// then, migrate existing contributors
// register old taxonomy so it can be queried
$args = array('hierarchical' => false, 'labels' => array(), 'show_ui' => true, 'show_tagcloud' => true, 'query_var' => true, 'rewrite' => array('slug' => 'contributor'));
register_taxonomy('podlove-contributors', 'podcast', $args);
$contributor_settings = get_option('podlove_contributors', array());
$contributors = get_terms('podlove-contributors', array('hide_empty' => 0));
if ($contributors && !is_wp_error($contributors) && \Podlove\Modules\Contributors\Model\Contributor::count() == 0) {
foreach ($contributors as $contributor) {
// create new contributor
$new = new \Podlove\Modules\Contributors\Model\Contributor();
$new->publicname = $contributor->name;
$new->realname = $contributor->name;
$new->slug = $contributor->slug;
$new->showpublic = true;
if (isset($contributor_settings[$contributor->term_id]['contributor_email'])) {
$email = $contributor_settings[$contributor->term_id]['contributor_email'];
if ($email) {
$new->privateemail = $email;
$new->avatar = $email;
}
}
$new->save();
// create contributions
$query = new \WP_Query(array('posts_per_page' => -1, 'post_type' => 'podcast', 'tax_query' => array(array('taxonomy' => 'podlove-contributors', 'field' => 'slug', 'terms' => $contributor->slug))));
while ($query->have_posts()) {
$post = $query->next_post();
$contribution = new \Podlove\Modules\Contributors\Model\EpisodeContribution();
$contribution->contributor_id = $new->id;
$contribution->episode_id = Model\Episode::find_one_by_post_id($post->ID)->id;
$contribution->save();
}
}
}
}
break;
case 47:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `protected` TINYINT(1) NULL', \Podlove\Model\Feed::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `protection_type` TINYINT(1)', \Podlove\Model\Feed::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `protection_user` VARCHAR(60)', \Podlove\Model\Feed::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `protection_password` VARCHAR(64)', \Podlove\Model\Feed::table_name()));
break;
case 48:
$podcast = Model\Podcast::get();
$podcast->limit_items = '-1';
$podcast->save();
break;
case 49:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `explicit` TINYINT', Model\Episode::table_name()));
break;
case 50:
$podcast = Model\Podcast::get();
$podcast->license_type = 'other';
$podcast->save();
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_type` VARCHAR(255) AFTER `publication_date`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_name` TEXT AFTER `license_type`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_url` TEXT AFTER `license_name`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_cc_allow_modifications` TEXT AFTER `license_url`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_cc_allow_commercial_use` TEXT AFTER `license_cc_allow_modifications`', Model\Episode::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `license_cc_license_jurisdiction` TEXT AFTER `license_cc_allow_commercial_use`', Model\Episode::table_name()));
break;
case 51:
if (\Podlove\Modules\Base::is_active('contributors')) {
\Podlove\Modules\Contributors\Model\ContributorGroup::build();
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `group_id` VARCHAR(255) AFTER `role_id`', \Podlove\Modules\Contributors\Model\EpisodeContribution::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `group_id` VARCHAR(255) AFTER `role_id`', \Podlove\Modules\Contributors\Model\ShowContribution::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `paypal` VARCHAR(255) AFTER `flattr`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `bitcoin` VARCHAR(255) AFTER `paypal`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `litecoin` VARCHAR(255) AFTER `bitcoin`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` DROP COLUMN `permanentcontributor`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` DROP COLUMN `role`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
}
break;
case 52:
if (\Podlove\Modules\Base::is_active('contributors')) {
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `jobtitle` VARCHAR(255) AFTER `department`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
}
break;
case 53:
// set all Episode as published (fix for ADN Module)
$episodes = Model\Episode::all();
foreach ($episodes as $episode) {
$post = get_post($episode->post_id);
if ($post->post_status == 'publish') {
update_post_meta($episode->post_id, '_podlove_episode_was_published', true);
}
}
break;
case 54:
if (\Podlove\Modules\Base::is_active('contributors')) {
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `googleplus` TEXT AFTER `ADN`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` CHANGE COLUMN `showpublic` `visibility` TINYINT(1)', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
}
break;
case 55:
if (\Podlove\Modules\Base::is_active('contributors')) {
\Podlove\Modules\Contributors\Model\DefaultContribution::build();
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `comment` TEXT AFTER `position`', \Podlove\Modules\Contributors\Model\EpisodeContribution::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `comment` TEXT AFTER `position`', \Podlove\Modules\Contributors\Model\ShowContribution::table_name()));
}
break;
case 56:
// migrate Podcast Contributors to Default Contributors
if (\Podlove\Modules\Base::is_active('contributors')) {
$podcast_contributors = \Podlove\Modules\Contributors\Model\ShowContribution::all();
foreach ($podcast_contributors as $podcast_contributor_key => $podcast_contributor) {
$new = new \Podlove\Modules\Contributors\Model\DefaultContribution();
$new->contributor_id = $podcast_contributor->contributor_id;
$new->group_id = $podcast_contributor->group_id;
$new->role_id = $podcast_contributor->role_id;
$new->position = $podcast_contributor->positon;
$new->save();
}
}
break;
case 57:
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `append_name_to_podcast_title` TINYINT(1) NULL AFTER `embed_content_encoded`', \Podlove\Model\Feed::table_name()));
break;
case 58:
// if contributors module is active, activate social module
if (\Podlove\Modules\Base::is_active('contributors')) {
\Podlove\Modules\Base::activate('social');
}
break;
case 59:
if (\Podlove\Modules\Base::is_active('bitlove')) {
$wpdb->query(sprintf("ALTER TABLE `%s` ADD COLUMN `bitlove` TINYINT(1) DEFAULT '0'", \Podlove\Model\Feed::table_name()));
}
break;
case 60:
\Podlove\Modules\Base::activate('oembed');
\Podlove\Modules\Base::activate('feed_validation');
break;
case 61:
$wpdb->query(sprintf('ALTER TABLE `%s` DROP COLUMN `publication_date`', Model\Episode::table_name()));
break;
case 62:
// rename column
$wpdb->query(sprintf('ALTER TABLE `%s` CHANGE COLUMN `record_date` `recording_date` DATETIME', Model\Episode::table_name()));
// update settings
$meta = get_option('podlove_metadata');
if (isset($meta['enable_episode_publication_date'])) {
unset($meta['enable_episode_publication_date']);
}
if (isset($meta['enable_episode_record_date'])) {
$meta['enable_episode_recording_date'] = $meta['enable_episode_record_date'];
unset($meta['enable_episode_record_date']);
}
update_option('podlove_metadata', $meta);
break;
case 63:
if (\Podlove\Modules\Base::is_active('social')) {
$tumblr_service = \Podlove\Modules\Social\Model\Service::find_one_by_property('title', 'Tumblr');
$tumblr_service->url_scheme = 'http://%account-placeholder%.tumblr.com/';
$tumblr_service->save();
}
break;
case 64:
if (\Podlove\Modules\Base::is_active('social')) {
$services = array(array('title' => '500px', 'type' => 'social', 'description' => '500px Account', 'logo' => '500px-128.png', 'url_scheme' => 'https://500px.com/%account-placeholder%'), array('title' => 'Last.fm', 'type' => 'social', 'description' => 'Last.fm Account', 'logo' => 'lastfm-128.png', 'url_scheme' => 'https://www.lastfm.de/user/%account-placeholder%'), array('title' => 'OpenStreetMap', 'type' => 'social', 'description' => 'OpenStreetMap Account', 'logo' => 'openstreetmap-128.png', 'url_scheme' => 'https://www.openstreetmap.org/user/%account-placeholder%'), array('title' => 'Soup', 'type' => 'social', 'description' => 'Soup Account', 'logo' => 'soup-128.png', 'url_scheme' => 'http://%account-placeholder%.soup.io'));
foreach ($services as $service_key => $service) {
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = $service['title'];
$c->type = $service['type'];
$c->description = $service['description'];
$c->logo = $service['logo'];
$c->url_scheme = $service['url_scheme'];
$c->save();
}
}
break;
case 65:
if (\Podlove\Modules\Base::is_active('social')) {
$flattr_service = \Podlove\Modules\Social\Model\Service::find_one_by_where("`title` = 'Flattr' AND `type` = 'donation'");
if ($flattr_service) {
$contributor_flattr_donations_accounts = \Podlove\Modules\Social\Model\ContributorService::find_all_by_property('service_id', $flattr_service->id);
foreach ($contributor_flattr_donations_accounts as $contributor_flattr_donations_account) {
$contributor = \Podlove\Modules\Contributors\Model\Contributor::find_by_id($contributor_flattr_donations_account->contributor_id);
if ($contributor && is_null($contributor->flattr)) {
$contributor->flattr = $contributor_flattr_donations_account->value;
$contributor->save();
}
$contributor_flattr_donations_account->delete();
}
$flattr_service->delete();
}
}
break;
case 66:
// Temporary add license_type and CC license fields to episode model
\Podlove\Model\Episode::property('license_type', 'VARCHAR(255)');
\Podlove\Model\Episode::property('license_cc_allow_modifications', 'VARCHAR(255)');
\Podlove\Model\Episode::property('license_cc_allow_commercial_use', 'VARCHAR(255)');
\Podlove\Model\Episode::property('license_cc_license_jurisdiction', 'VARCHAR(255)');
$podcast = \Podlove\Model\Podcast::get();
$episodes = \Podlove\Model\Episode::all();
// Migration for Podcast
if ($podcast->license_type == 'cc' && $podcast->license_cc_allow_commercial_use !== '' && $podcast->license_cc_allow_modifications !== '' && $podcast->license_cc_license_jurisdiction !== '') {
$license = array('version' => '3.0', 'commercial_use' => $podcast->license_cc_allow_commercial_use, 'modification' => $podcast->license_cc_allow_modifications, 'jurisdiction' => $podcast->license_cc_license_jurisdiction);
$podcast->license_url = \Podlove\Model\License::get_url_from_license($license);
$podcast->license_name = \Podlove\Model\License::get_name_from_license($license);
$podcast->save();
}
// Migration for Episodes
foreach ($episodes as $episode) {
if ($episode->license_type == 'other' || $episode->license_cc_allow_commercial_use == '' || $episode->license_cc_allow_modifications == '' || $episode->license_cc_license_jurisdiction == '') {
continue;
}
$license = array('version' => '3.0', 'commercial_use' => $episode->license_cc_allow_commercial_use, 'modification' => $episode->license_cc_allow_modifications, 'jurisdiction' => $episode->license_cc_license_jurisdiction);
$episode->license_url = \Podlove\Model\License::get_url_from_license($license);
$episode->license_name = \Podlove\Model\License::get_name_from_license($license);
$episode->save();
}
break;
case 67:
if (\Podlove\Modules\Base::is_active('social')) {
$instagram_service = \Podlove\Modules\Social\Model\Service::find_one_by_where("`title` = 'Instagram' AND `type` = 'social'");
if ($instagram_service) {
$instagram_service->url_scheme = 'https://instagram.com/%account-placeholder%';
$instagram_service->save();
}
}
break;
case 68:
// Do that ADN module fix again, as we forgot to mark all episodes as published if the ADN module is activated
$episodes = Model\Episode::all();
foreach ($episodes as $episode) {
$post = get_post($episode->post_id);
if ($post->post_status == 'publish' && !get_post_meta($episode->post_id, '_podlove_episode_was_published', true)) {
update_post_meta($episode->post_id, '_podlove_episode_was_published', true);
}
}
break;
case 69:
if (\Podlove\Modules\Base::is_active('app_dot_net')) {
$adn = \Podlove\Modules\AppDotNet\App_Dot_Net::instance();
if ($adn->get_module_option('adn_auth_key')) {
$adn->update_module_option('adn_automatic_announcement', 'on');
}
}
break;
case 70:
\Podlove\Model\DownloadIntent::build();
\Podlove\Model\UserAgent::build();
break;
case 71:
// update for everyone, so even those with inactive service tables get updated
$wpdb->query(sprintf('ALTER TABLE `%s` CHANGE COLUMN `type` `category` VARCHAR(255)', \Podlove\Modules\Social\Model\Service::table_name()));
$wpdb->query(sprintf("ALTER TABLE `%s` ADD COLUMN `type` VARCHAR(255) AFTER `category`", \Podlove\Modules\Social\Model\Service::table_name()));
$services = \Podlove\Modules\Social\Model\Service::all();
foreach ($services as $service) {
$service->type = strtolower($service->title);
$service->save();
}
break;
case 72:
if (\Podlove\Modules\Base::is_active('social')) {
$services = array(array('title' => 'Vimeo', 'type' => 'vimeo', 'category' => 'social', 'description' => 'Vimeo Account', 'logo' => 'vimeo-128.png', 'url_scheme' => 'http://vimeo.com/%account-placeholder%'), array('title' => 'about.me', 'type' => 'about.me', 'category' => 'social', 'description' => 'about.me Account', 'logo' => 'aboutme-128.png', 'url_scheme' => 'http://about.me/%account-placeholder%'), array('title' => 'Gittip', 'type' => 'gittip', 'category' => 'donation', 'description' => 'Gittip Account', 'logo' => 'gittip-128.png', 'url_scheme' => 'https://www.gittip.com/%account-placeholder%'));
foreach ($services as $service_key => $service) {
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = $service['title'];
$c->type = $service['type'];
$c->category = $service['category'];
$c->description = $service['description'];
$c->logo = $service['logo'];
$c->url_scheme = $service['url_scheme'];
$c->save();
}
}
break;
case 73:
if (\Podlove\Modules\Base::is_active('social')) {
$jabber_service = \Podlove\Modules\Social\Model\Service::find_one_by_where("`type` = 'jabber' AND `category` = 'social'");
if ($jabber_service) {
$jabber_service->url_scheme = 'jabber:%account-placeholder%';
$jabber_service->save();
}
}
break;
case 74:
Model\GeoArea::build();
Model\GeoAreaName::build();
\Podlove\Geo_Ip::register_updater_cron();
break;
case 75:
$tracking = get_option('podlove_tracking');
$tracking['mode'] = 0;
update_option('podlove_tracking', $tracking);
break;
case 76:
set_transient('podlove_needs_to_flush_rewrite_rules', true);
break;
case 77:
// delete empty user agents
$userAgentTable = Model\UserAgent::table_name();
$downloadIntentTable = Model\DownloadIntent::table_name();
$sql = "SELECT\n\t\t\t\tdi.id\n\t\t\tFROM\n\t\t\t\t{$downloadIntentTable} di\n\t\t\t\tJOIN {$userAgentTable} ua ON ua.id = di.user_agent_id\n\t\t\tWHERE\n\t\t\t\tua.user_agent IS NULL";
$ids = $wpdb->get_col($sql);
if (is_array($ids) && count($ids)) {
$sql = "UPDATE {$downloadIntentTable} SET user_agent_id = NULL WHERE id IN (" . implode(",", $ids) . ")";
$wpdb->query($sql);
$sql = "DELETE FROM {$userAgentTable} WHERE user_agent IS NULL";
$wpdb->query($sql);
}
break;
case 78:
if (\Podlove\Modules\Base::is_active('social')) {
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = 'Auphonic Credits';
$c->category = 'donation';
$c->type = 'auphonic credits';
$c->description = 'Auphonic Account';
$c->logo = 'auphonic-128.png';
$c->url_scheme = 'https://auphonic.com/donate_credits?user=%account-placeholder%';
$c->save();
}
break;
case 79:
set_transient('podlove_needs_to_flush_rewrite_rules', true);
$cache = \Podlove\Cache\TemplateCache::get_instance();
$cache->setup_purge();
break;
case 80:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `httprange` VARCHAR(255)', \Podlove\Model\DownloadIntent::table_name());
$wpdb->query($sql);
break;
case 81:
// remove all caches with old namespace
$wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE \"_transient_podlove_cache%\"");
break;
case 82:
// set all redirect entries to active
$redirect_settings = \Podlove\get_setting('redirects', 'podlove_setting_redirect');
foreach ($redirect_settings as $index => $data) {
$redirect_settings[$index]['active'] = 'active';
}
update_option('podlove_redirects', array('podlove_setting_redirect' => $redirect_settings));
break;
case 83:
\Podlove\Model\DownloadIntentClean::build();
$alterations = array('ALTER TABLE `%s` ADD COLUMN `bot` TINYINT', 'ALTER TABLE `%s` ADD COLUMN `client_name` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `client_version` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `client_type` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `os_name` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `os_version` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `device_brand` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `device_model` VARCHAR(255)');
foreach ($alterations as $sql) {
$wpdb->query(sprintf($sql, Model\UserAgent::table_name()));
}
Model\UserAgent::reparse_all();
break;
case 84:
delete_option('podlove_tpl_cache_keys');
break;
case 85:
add_option('podlove_tracking_delete_head_requests', 1);
break;
case 86:
if (\Podlove\Modules\Base::is_active('social')) {
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = 'Foursquare';
$c->category = 'social';
$c->type = 'foursquare';
$c->description = 'Foursquare Account';
$c->logo = 'foursquare-128.png';
$c->url_scheme = 'https://foursquare.com/%account-placeholder%';
$c->save();
$services = array(array('title' => 'ResearchGate', 'name' => 'researchgate', 'category' => 'social', 'description' => 'ResearchGate URL', 'logo' => 'researchgate-128.png', 'url_scheme' => '%account-placeholder%'), array('title' => 'ORCiD', 'name' => 'orcid', 'category' => 'social', 'description' => 'ORCiD', 'logo' => 'orcid-128.png', 'url_scheme' => 'https://orcid.org/%account-placeholder%'), array('title' => 'Scopus', 'name' => 'scous', 'category' => 'social', 'description' => 'Scopus Author ID', 'logo' => 'scopus-128.png', 'url_scheme' => 'https://www.scopus.com/authid/detail.url?authorId=%account-placeholder%'));
foreach ($services as $service_key => $service) {
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = $service['title'];
$c->category = $service['category'];
$c->type = $service['name'];
$c->description = $service['description'];
$c->logo = $service['logo'];
$c->url_scheme = $service['url_scheme'];
$c->save();
}
}
break;
case 87:
if (\Podlove\Modules\Base::is_active('app_dot_net')) {
$adn = \Podlove\Modules\AppDotNet\App_Dot_Net::instance();
if ($adn->get_module_option('adn_auth_key')) {
$adn->update_module_option('adn_poster_image_fallback', 'on');
}
}
break;
case 88:
$service = new \Podlove\Modules\Social\Model\Service();
$service->title = 'Email';
$service->category = 'social';
$service->type = 'email';
$service->description = 'Email';
$service->logo = 'email-128.png';
$service->url_scheme = 'mailto:%account-placeholder%';
$service->save();
break;
case 89:
$email_service = \Podlove\Modules\Social\Model\Service::find_one_by_type('email');
foreach (\Podlove\Modules\Contributors\Model\Contributor::all() as $contributor) {
if (!$contributor->publicemail) {
continue;
}
$contributor_service = new \Podlove\Modules\Social\Model\ContributorService();
$contributor_service->contributor_id = $contributor->id;
$contributor_service->service_id = $email_service->id;
$contributor_service->value = $contributor->publicemail;
$contributor_service->save();
}
break;
case 90:
\Podlove\Modules\Base::activate('subscribe_button');
break;
case 91:
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = 'Miiverse';
$c->category = 'social';
$c->type = 'miiverse';
$c->description = 'Miiverse Account';
$c->logo = 'miiverse-128.png';
$c->url_scheme = 'https://miiverse.nintendo.net/users/%account-placeholder%';
$c->save();
break;
case 92:
$c = new \Podlove\Modules\Social\Model\Service();
$c->title = 'Prezi';
$c->category = 'social';
$c->type = 'prezi';
$c->description = 'Prezis';
$c->logo = 'prezi-128.png';
$c->url_scheme = 'http://prezi.com/user/%account-placeholder%';
$c->save();
break;
case 93:
// podlove_init_user_agent_refresh();
// do nothing instead, because see 94 below
break;
case 94:
// this is a duplicate of migration 83 but it looks like that didn't work.
Model\DownloadIntentClean::build();
$alterations = array('ALTER TABLE `%s` ADD COLUMN `bot` TINYINT', 'ALTER TABLE `%s` ADD COLUMN `client_name` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `client_version` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `client_type` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `os_name` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `os_version` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `device_brand` VARCHAR(255)', 'ALTER TABLE `%s` ADD COLUMN `device_model` VARCHAR(255)');
foreach ($alterations as $sql) {
$wpdb->query(sprintf($sql, Model\UserAgent::table_name()));
}
podlove_init_user_agent_refresh();
// manually trigger intent cron after user agents are parsed
// parameter to make sure WP does not skip it due to 10 minute rule
wp_schedule_single_event(time() + 120, 'podlove_cleanup_download_intents', ['really' => true]);
// manually trigger average cron after intents are calculated
wp_schedule_single_event(time() + 240, 'recalculate_episode_download_average', ['really' => true]);
break;
case 95:
// add missing flattr column
$wpdb->query(sprintf('ALTER TABLE `%s` ADD COLUMN `flattr` VARCHAR(255) AFTER `avatar`', \Podlove\Modules\Contributors\Model\Contributor::table_name()));
break;
case 96:
\Podlove\DeleteHeadRequests::init();
break;
case 97:
// recalculate all downloads average data
$wpdb->query(sprintf('DELETE FROM `%s` WHERE `meta_key` LIKE "_podlove_eda%%"', $wpdb->postmeta));
break;
case 98:
delete_transient('podlove_dashboard_stats_contributors');
break;
case 99:
// Activate network module for migrating users.
// Core modules are automatically activated for _new_ setups and
// whenever modules change. Since this can't be guaranteed for
// existing setups, it must be triggered manually.
\Podlove\Modules\Networks\Networks::instance()->was_activated();
break;
case 101:
// add patreon
if (\Podlove\Modules\Social\Model\Service::table_exists()) {
\Podlove\Modules\Social\RepairSocial::fix_missing_services();
}
break;
case 102:
// update logos
if (\Podlove\Modules\Social\Model\Service::table_exists()) {
\Podlove\Modules\Social\Social::update_existing_services();
}
break;
case 103:
$assignment = get_option('podlove_template_assignment', []);
if ($assignment['top'] && is_numeric($assignment['top'])) {
$assignment['top'] = Model\Template::find_by_id($assignment['top'])->title;
}
if ($assignment['bottom'] && is_numeric($assignment['bottom'])) {
$assignment['bottom'] = Model\Template::find_by_id($assignment['bottom'])->title;
}
update_option('podlove_template_assignment', $assignment);
break;
case 104:
\Podlove\unschedule_events(\Podlove\Cache\TemplateCache::CRON_PURGE_HOOK);
break;
case 105:
// activate flattr plugin
\Podlove\Modules\Base::activate('flattr');
// migrate flattr data
$podcast = Model\Podcast::get();
$settings = get_option('podlove_flattr', []);
$settings['account'] = $podcast->flattr;
$settings['contributor_shortcode_default'] = 'yes';
update_option('podlove_flattr', $settings);
break;
case 106:
podlove_init_user_agent_refresh();
break;
case 107:
// skipped
break;
case 108:
podlove_init_user_agent_refresh();
break;
case 109:
\podlove_init_capabilities();
break;
case 110:
if (\Podlove\Modules\Social\Model\Service::table_exists()) {
\Podlove\Modules\Social\Social::update_existing_services();
\Podlove\Modules\Social\Social::build_missing_services();
}
break;
case 111:
if (\Podlove\Modules\Social\Model\Service::table_exists()) {
\Podlove\Modules\Social\Social::update_existing_services();
\Podlove\Modules\Social\Social::build_missing_services();
}
break;
}
}
public function init()
{
add_settings_section('podlove_settings_episode', __('', 'podlove'), function () {
echo '<h3>' . __('Download Tracking & Analytics Settings', 'podlove') . '</h3>';
?>
<style type="text/css">
.form-table .aligned-radio { display: table; margin-bottom: 10px; }
.form-table .aligned-radio .row { display: table-row; }
.form-table .aligned-radio .row > div { display: table-cell; }
</style>
<?php
}, Settings::$pagehook);
add_settings_field('podlove_setting_tracking', sprintf('<label for="mode">%s</label>', __('Tracking Mode', 'podlove')), function () {
?>
<label class="aligned-radio">
<div class="row">
<div>
<input name="podlove_tracking[mode]" type="radio" value="0" <?php
checked(\Podlove\get_setting('tracking', 'mode'), 0);
?>
/>
</div>
<div>
<?php
echo sprintf('<div><strong>%s</strong><br>%s</div>', __('No Tracking', 'podlove'), __('Original file URLs are presented to users and clients. No download-data is tracked.', 'podlove'));
?>
</div>
</div>
</label>
<label class="aligned-radio">
<div class="row">
<div>
<input name="podlove_tracking[mode]" type="radio" value="ptm" <?php
checked(\Podlove\get_setting('tracking', 'mode'), 'ptm');
?>
/>
</div>
<div>
<?php
echo sprintf('<div><strong>%s</strong><br>%s</div>', __('Tracking URL Parameters', 'podlove'), __('Original file URLs are extended by tracking parameters before presenting them to users and clients.
This is useful if you are using your server log files for download analytics.
No download-data is tracked.', 'podlove'));
?>
</div>
</div>
</label>
<label class="aligned-radio">
<div class="row">
<div>
<input name="podlove_tracking[mode]" type="radio" value="ptm_analytics" <?php
checked(\Podlove\get_setting('tracking', 'mode'), 'ptm_analytics');
?>
/>
</div>
<div>
<?php
echo sprintf('<div><strong>%s</strong><br>%s</div>', __('Tracking URL Parameters & Analytics', 'podlove'), __('Instead of the original file URLs, users and clients see a link that points to the Publisher.
The Publisher logs the download intent and redirects the user to the original file.
That way the Publisher is able to generate download statistics. ', 'podlove'));
?>
</div>
</div>
</label>
<?php
}, Settings::$pagehook, 'podlove_settings_episode');
add_settings_field('podlove_status_location_database', sprintf('<label for="mode">%s</label>', __('Geolocation Lookup', 'podlove')), function () {
$file = \Podlove\Geo_Ip::get_upload_file_path();
\Podlove\Geo_Ip::register_updater_cron();
?>
<?php
if (file_exists($file)) {
?>
<p>
<?php
echo __("Geolocation database", "podlove");
?>
:
<code><?php
echo $file;
?>
</code>
</p>
<p>
<?php
echo __("Last modified", "podlove");
?>
:
<?php
echo date(get_option('date_format') . ' ' . get_option('time_format'), filemtime($file));
?>
</p>
<p>
<?php
echo sprintf(__("The database is updated automatically once a month. Next scheduled update: %s", "podlove"), date(get_option('date_format') . ' ' . get_option('time_format'), wp_next_scheduled('podlove_geoip_db_update')));
?>
</p>
<p>
<button name="update_geo_database" class="button button-primary" value="1"><?php
echo __("Update Now", "podlove");
?>
</button>
</p>
<?php
} else {
?>
<p>
<?php
echo __("You need to download a geolocation-database for lookups to work.", "podlove");
?>
</p>
<p>
<button name="update_geo_database" class="button button-primary" value="1"><?php
echo __("Download Now", "podlove");
?>
</button>
</p>
<?php
}
?>
<p>
<!-- This snippet must be included, as stated here: http://dev.maxmind.com/geoip/geoip2/geolite2/ -->
<em>
This product includes GeoLite2 data created by MaxMind, available from
<a href="http://www.maxmind.com">http://www.maxmind.com</a>.
</em>
</p>
<?php
}, Settings::$pagehook, 'podlove_settings_episode');
add_settings_field('podlove_debug_tracking', sprintf('<label for="mode">%s</label>', __('Debug Tracking', 'podlove')), function () {
if (!\get_option('permalink_structure')) {
?>
<div class="error">
<p>
<b><?php
echo __('Please Change Permalink Structure', 'podlove');
?>
</b>
<?php
echo sprintf(__('You are using the default WordPress permalink structure.
This may cause problems with some podcast clients when you activate tracking.
Go to %s and set it to anything but default (for example "Post name") before activating Tracking.', 'podlove'), '<a href="' . admin_url('options-permalink.php') . '">' . __('Permalink Settings') . '</a>');
?>
</p>
</div>
<?php
}
$media_file = Model\MediaFile::find_example();
if (!$media_file) {
return;
}
$episode = $media_file->episode();
if (!$episode) {
return;
}
$public_url = $media_file->get_public_file_url("debug");
$actual_url = $media_file->get_file_url();
?>
<h4>Example Episode</h4>
<p>
<?php
echo $episode->full_title();
?>
</p>
<h4>Media File</h4>
<p>
<h5>Actual Location</h5>
<code><?php
echo $actual_url;
?>
</code>
</p>
<p>
<h5>Public URL</h5>
<code><?php
echo $public_url;
?>
</code>
</p>
<p>
<h5>Validations</h5>
<ul>
<li>
<!-- check rewrite rules -->
<?php
if (\Podlove\Tracking\Debug::rewrites_exist()) {
?>
✔ Rewrite Rules Exist
<?php
} else {
?>
✘ <strong>Rewrite Rules Missing</strong>
<!-- todo: repair button -->
<?php
}
?>
</li>
<li>
<?php
if (\Podlove\Tracking\Debug::url_resolves_correctly($public_url, $actual_url)) {
?>
✔ URL resolves correctly
<?php
} else {
?>
✘ <strong>URL does not resolve correctly</strong>
<?php
}
?>
</li>
<li>
<!-- check http/https consistency -->
<?php
if (\Podlove\Tracking\Debug::is_consistent_https_chain($public_url, $actual_url)) {
?>
✔ Consistent protocol chain
<?php
} else {
?>
✘ <strong>Protocol chain is inconsistent</strong>: Your site uses SSL but the files are not served with SSL.
Many clients will not allow to download episodes. To fix this, serve files via SSL or deactivate tracking.
<?php
}
?>
</li>
<!-- todo: check regularly and spit user in his face if it blows up -->
</ul>
</p>
<?php
}, Settings::$pagehook, 'podlove_settings_episode');
register_setting(Settings::$pagehook, 'podlove_tracking', function ($args) {
if (isset($_REQUEST['update_geo_database'])) {
\Podlove\Geo_Ip::update_database();
}
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
return $args;
});
}
/**
* Get playable files for player, based on episode and player assignments.
*
* @param array $formats array of formats like mp3, mp3, ogg, opus, webm
* @param string $media_type audio or video
* @return array of \Podlove\Model\MediaFile
*/
private function get_playable_files($formats, $media_type)
{
$playable_files = array();
foreach ($formats as $format) {
if (!isset($this->player_format_assignments[$media_type][$format])) {
continue;
}
$episode_asset = EpisodeAsset::find_by_id($this->player_format_assignments[$media_type][$format]);
if (!$episode_asset) {
continue;
}
$media_file = MediaFile::find_by_episode_id_and_episode_asset_id($this->episode->id, $episode_asset->id);
if ($media_file && $media_file->is_valid()) {
$playable_files[] = $media_file;
}
}
return $playable_files;
}
/**
* Find and run migration for given version number.
*
* @todo move migrations into separate files
*
* @param int $version
*/
function run_migrations_for_version($version)
{
global $wpdb;
switch ($version) {
case 2:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `chapters` TEXT AFTER `cover_art`', \Podlove\Model\Release::table_name());
$wpdb->query($sql);
break;
case 3:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `format` VARCHAR(255) AFTER `slug`', \Podlove\Model\Feed::table_name());
$wpdb->query($sql);
break;
case 4:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `title` VARCHAR(255) AFTER `id`', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 5:
\Podlove\Modules\Base::activate('podlove_web_player');
break;
case 6:
// title column is "int" for some people. this migration fixes that
$sql = sprintf('SHOW COLUMNS FROM `wp_podlove_medialocation` WHERE Field = "title"', \Podlove\Model\EpisodeAsset::table_name());
$row = $wpdb->get_row($sql);
if (strtolower(substr($row->Type, 0, 3)) === 'int') {
$wpdb->query(sprintf('UPDATE `%s` SET title = NULL', \Podlove\Model\EpisodeAsset::table_name()));
$wpdb->query(sprintf('ALTER TABLE `%s` MODIFY COLUMN `title` VARCHAR(255)', \Podlove\Model\EpisodeAsset::table_name()));
}
break;
case 7:
// move language from feed to show
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `language` VARCHAR(255) AFTER `summary`', \Podlove\Model\Show::table_name());
$wpdb->query($sql);
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `language`', \Podlove\Model\Feed::table_name());
$wpdb->query($sql);
break;
case 8:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `supports_cover_art` INT', \Podlove\Model\Show::table_name());
$wpdb->query($sql);
break;
case 9:
// huge architecture migration
// assume first show will be blueprint for the podcast
$show = $wpdb->get_row(sprintf('SELECT * FROM %s LIMIT 1', $wpdb->prefix . 'podlove_show'), ARRAY_A);
$show_id = $show['id'];
// On my local machine the migration runs twice.
// This is a quick fix. caveat: someone who has no show defined
// will need to uninstall the plugin. That seems acceptable.
if (!$show_id) {
return;
}
// all releases of this show will be converted to episodes
$releases = $wpdb->get_results(sprintf('
SELECT
E.post_id, R.episode_id, R.active, R.enable, R.slug, R.duration, R.cover_art, R.chapters
FROM
%s R
INNER JOIN %s E ON R.episode_id = E.id
WHERE
R.show_id = "%s"
', $wpdb->prefix . 'podlove_release', $wpdb->prefix . 'podlove_episode', $show_id), ARRAY_A);
// write show settings to podcast
$podcast = \Podlove\Model\Podcast::get_instance();
foreach ($show as $key => $value) {
$podcast->{$key} = $value;
}
$podcast->save();
// rebuild show table
\Podlove\Model\Show::destroy();
\Podlove\Model\Show::build();
// rebuild episodes table
\Podlove\Model\Episode::destroy();
\Podlove\Model\Episode::build();
foreach ($releases as $release) {
$episode = new \Podlove\Model\Episode();
foreach ($release as $key => $value) {
if (!in_array($key, array('episode_id'))) {
$episode->{$key} = $value;
}
}
$episode->save();
}
// clean feed table
$sql = sprintf('DELETE FROM `%s` WHERE `show_id` != "%s"', \Podlove\Model\Feed::table_name(), $show_id);
$wpdb->query($sql);
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `show_id`', \Podlove\Model\Feed::table_name());
$wpdb->query($sql);
// fix mediafile table
$sql = sprintf('ALTER TABLE `%s` CHANGE `release_id` `episode_id` INT', \Podlove\Model\MediaFile::table_name());
$wpdb->query($sql);
// remove suffix
$sql = sprintf('ALTER TABLE `%s` DROP COLUMN `suffix`', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
// add more default formats
$default_formats = array(array('name' => 'PDF Document', 'type' => 'ebook', 'mime_type' => 'application/pdf', 'extension' => 'pdf'), array('name' => 'ePub Document', 'type' => 'ebook', 'mime_type' => 'application/epub+zip', 'extension' => 'epub'), array('name' => 'PNG Image', 'type' => 'image', 'mime_type' => 'image/png', 'extension' => 'png'), array('name' => 'JPEG Image', 'type' => 'image', 'mime_type' => 'image/jpeg', 'extension' => 'jpg'));
foreach ($default_formats as $format) {
$f = new Model\FileType();
foreach ($format as $key => $value) {
$f->{$key} = $value;
}
$f->save();
}
// update assistant
$assistant = \Podlove\Modules\EpisodeAssistant\Episode_Assistant::instance();
$template = $assistant->get_module_option('title_template');
$template = str_replace('%show_slug%', '%podcast_slug%', $template);
$assistant->update_module_option('title_template', $template);
// update media locations
$media_locations = \Podlove\Model\EpisodeAsset::all();
foreach ($media_locations as $media_location) {
$media_location->url_template = str_replace('%suffix%', '', $media_location->url_template);
$media_location->save();
}
break;
case 10:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `summary` TEXT', \Podlove\Model\Episode::table_name());
$wpdb->query($sql);
break;
case 11:
$sql = sprintf('ALTER TABLE `%s` ADD COLUMN `downloadable` INT', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 12:
$sql = sprintf('UPDATE `%s` SET `downloadable` = 1', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 13:
$opus = array('name' => 'Opus Audio', 'type' => 'audio', 'mime_type' => 'audio/opus', 'extension' => 'opus');
$f = new \Podlove\Model\FileType();
foreach ($opus as $key => $value) {
$f->{$key} = $value;
}
$f->save();
break;
case 14:
$sql = sprintf('ALTER TABLE `%s` RENAME TO `%s`', $wpdb->prefix . 'podlove_medialocation', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
case 15:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_location_id` `episode_asset_id` INT', \Podlove\Model\MediaFile::table_name());
$wpdb->query($sql);
break;
case 16:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_location_id` `episode_asset_id` INT', \Podlove\Model\Feed::table_name());
$wpdb->query($sql);
break;
case 17:
$sql = sprintf('ALTER TABLE `%s` RENAME TO `%s`', $wpdb->prefix . 'podlove_mediaformat', \Podlove\Model\FileType::table_name());
$wpdb->query($sql);
break;
case 18:
$sql = sprintf('ALTER TABLE `%s` CHANGE `media_format_id` `file_type_id` INT', \Podlove\Model\EpisodeAsset::table_name());
$wpdb->query($sql);
break;
}
}
/**
* Fetch form data for EpisodeAssets multiselect.
*
* @param \Podlove\Model\Episode $episode
* @return array
*/
public static function episode_assets_form($episode)
{
$episode_assets = Model\EpisodeAsset::all();
// field to generate option list
$asset_options = array();
// values for option list
$asset_values = array();
foreach ($episode_assets as $asset) {
if (!($file_type = $asset->file_type())) {
continue;
}
// get formats configured for this show
$asset_options[$asset->id] = $asset->title;
// find out which formats are active
$asset_values[$asset->id] = NULL !== Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
}
// FIXME: empty checkbox -> no file id
// solution: when one checks the box, an AJAX request has to create and validate the file
$episode_assets_form = array('label' => __('Media Files', 'podlove'), 'description' => '', 'options' => $asset_options, 'default' => true, 'multi_values' => $asset_values, 'before' => function () {
?>
<table class='media_file_table' border="0" cellspacing="0">
<tr>
<th><?php
echo __('Enable', 'podlove');
?>
</th>
<th><?php
echo __('Asset', 'podlove');
?>
</th>
<th><?php
echo __('Asset File Name', 'podlove');
?>
</th>
<th><?php
echo __('Filesize', 'podlove');
?>
</th>
<th><?php
echo __('Status', 'podlove');
?>
</th>
<th></th>
</tr>
<?php
}, 'after' => function () {
?>
</table>
<p>
<span class="description">
<?php
echo __('Media File Base URL', 'podlove') . ': ' . \Podlove\Model\Podcast::get()->media_file_base_uri;
?>
</span>
</p>
<?php
}, 'around_each' => function ($callback) {
?>
<tr class="media_file_row">
<td class="enable">
</td>
<td class="asset">
<?php
call_user_func($callback);
?>
</td>
<td class="url"></td>
<td class="size"></td>
<td class="status"></td>
<td class="update"></td>
</tr>
<?php
}, 'multiselect_callback' => function ($asset_id) use($episode) {
$asset = \Podlove\Model\EpisodeAsset::find_by_id($asset_id);
$format = $asset->file_type();
$file = \Podlove\Model\MediaFile::find_by_episode_id_and_episode_asset_id($episode->id, $asset->id);
$size = is_object($file) ? (int) $file->size : 0;
if ($size === 1) {
$size = "unknown";
}
$attributes = array('data-template' => \Podlove\Model\Podcast::get()->get_url_template(), 'data-size' => $size, 'data-episode-asset-id' => $asset->id, 'data-episode-id' => $episode->id, 'data-file-url' => is_object($file) ? $file->get_file_url() : '');
if ($file) {
$attributes['data-id'] = $file->id;
}
$out = '';
foreach ($attributes as $key => $value) {
$out .= sprintf('%s="%s" ', $key, $value);
}
return $out;
});
if (empty($asset_options)) {
$episode_assets_form['description'] = sprintf('<span style="color: red">%s</span>', __('You need to configure assets for this show. No assets, no fun.', 'podlove')) . ' ' . sprintf('<a href="%s">%s</a>', admin_url('admin.php?page=podlove_episode_assets_settings_handle'), __('Configure Assets', 'podlove'));
}
return $episode_assets_form;
}
/**
* Get playable files for player, based on episode and player assignments.
*
* @param array $formats array of formats like mp3, mp3, ogg, opus, webm
* @param string $media_type audio or video
* @return array of \Podlove\Model\MediaFile
*/
private function get_playable_files($formats, $media_type)
{
$playable_files = [];
$player_format_assignments = get_option('podlove_webplayer_formats');
if (empty($player_format_assignments)) {
error_log(print_r("Podlove Web Player: No assets are assigned.", true));
return [];
}
foreach ($formats as $format) {
if (!isset($player_format_assignments[$media_type][$format])) {
continue;
}
$episode_asset = EpisodeAsset::find_by_id($player_format_assignments[$media_type][$format]);
if (!$episode_asset) {
continue;
}
$media_file = MediaFile::find_by_episode_id_and_episode_asset_id($this->episode->id, $episode_asset->id);
if ($media_file && $media_file->is_valid()) {
$playable_files[] = $media_file;
}
}
return $playable_files;
}
