public static function ajax_delete()
{
global $wpdb;
$send_response = function ($todo) use($wpdb) {
if (!$todo) {
// free disk space
$wpdb->query('OPTIMIZE TABLE ' . \Podlove\Model\DownloadIntent::table_name());
// clear caches
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
// mark migration as done
delete_option('podlove_tracking_delete_head_requests');
}
\Podlove\AJAX\Ajax::respond_with_json(array('todo' => $todo));
};
// get user agent IDs to delete
$sql = "\n\t\t\tSELECT\n\t\t\t\tid \n\t\t\tFROM\n\t\t\t\t" . \Podlove\Model\UserAgent::table_name() . " ua\n\t\t\tWHERE\n\t\t\t\tuser_agent LIKE \"libwww-perl/%\" \n\t\t\t\tOR user_agent LIKE \"curl/%\" \n\t\t\t\tOR user_agent LIKE \"PritTorrent/%\"\n\t\t";
$user_agent_ids = $wpdb->get_col($sql);
if (!count($user_agent_ids)) {
$send_response(0);
}
// delete
$sql = "\n\t\tDELETE\n\t\t\tFROM " . \Podlove\Model\DownloadIntent::table_name() . "\n\t\t\tWHERE user_agent_id IN (" . implode(",", $user_agent_ids) . ")\n\t\t\tLIMIT 25000\n\t\t";
$wpdb->query($sql);
$sql = "\n\t\tDELETE\n\t\t\tFROM " . \Podlove\Model\DownloadIntentClean::table_name() . "\n\t\t\tWHERE user_agent_id IN (" . implode(",", $user_agent_ids) . ")\n\t\t\tLIMIT 25000\n\t\t";
$wpdb->query($sql);
// see how much is left to delete
$sql = "\n\t\tSELECT\n\t\t\tCOUNT(*) \n\t\tFROM\n\t\t\t" . \Podlove\Model\DownloadIntent::table_name() . " \n\t\tWHERE\n\t\t\tuser_agent_id IN (" . implode(",", $user_agent_ids) . ")\n\t\t";
$send_response($wpdb->get_var($sql));
}
public function import()
{
// It might not look like it, but it is actually compatible to
// uncompressed files.
$gzFileHandler = gzopen($this->file, 'r');
Model\DownloadIntent::delete_all();
Model\DownloadIntentClean::delete_all();
$batchSize = 1000;
$batch = array();
while (!gzeof($gzFileHandler)) {
$line = gzgets($gzFileHandler);
list($id, $user_agent_id, $media_file_id, $request_id, $accessed_at, $source, $context, $geo_area_id, $lat, $lng) = explode(",", $line);
$batch[] = array($user_agent_id, $media_file_id, $request_id, $accessed_at, $source, $context, $geo_area_id, $lat, $lng);
if (count($batch) >= $batchSize) {
self::save_batch_to_db($batch);
$batch = [];
}
}
gzclose($gzFileHandler);
// save last batch to db
self::save_batch_to_db($batch);
\Podlove\Analytics\DownloadIntentCleanup::cleanup_download_intents();
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
wp_redirect(admin_url('admin.php?page=podlove_imexport_migration_handle&status=success'));
exit;
}
public static function print_styles()
{
header('Content-type: text/css');
echo \Podlove\Cache\TemplateCache::get_instance()->cache_for("podlove_admin_menu_style_covers", function () {
return self::get_styles();
}, HOUR_IN_SECONDS);
exit;
}
public function the_open_graph_metadata()
{
$cache_key = 'opgv2' . get_the_ID() . get_permalink();
$cache = \Podlove\Cache\TemplateCache::get_instance();
echo $cache->cache_for($cache_key, function () {
return (string) \Podlove\Modules\OpenGraph\Open_Graph::get_open_graph_metadata();
});
}
/**
* Feed list, ready for subscribe button.
*
* @return array list of prepared feed data-objects
*/
private function feeds()
{
return TemplateCache::get_instance()->cache_for('podlove_subscribe_button_feeds', function () {
return array_map(function ($feed) {
$file_type = $feed->episode_asset()->file_type();
return ['type' => $file_type->type, 'format' => self::feed_format($file_type->extension), 'url' => $feed->get_subscribe_url(), 'variant' => 'high'];
}, $this->discoverable_feeds());
});
}
public function __construct($handle)
{
self::$pagehook = add_submenu_page($handle, __('Templates', 'podlove'), __('Templates', 'podlove'), 'administrator', 'podlove_templates_settings_handle', array($this, 'page'));
$this->init_page_documentation(self::$pagehook);
add_action('admin_init', array($this, 'scripts_and_styles'));
register_setting(Templates::$pagehook, 'podlove_template_assignment', function ($args) {
// when changing the assignment, clear caches
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
return $args;
});
}
public function prepare_items()
{
global $wpdb;
// number of items per page
$per_page = 20;
// define column headers
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
$data = \Podlove\Cache\TemplateCache::get_instance()->cache_for('podlove_analytics_downloads_table', function () {
global $wpdb;
// retrieve data
$subSQL = function ($start = null, $end = null) {
$strToMysqlDate = function ($s) {
return date('Y-m-d', strtotime($s));
};
if ($start && $end) {
$timerange = " AND di2.accessed_at BETWEEN '{$strToMysqlDate($start)}' AND '{$strToMysqlDate($end)}'";
} elseif ($start) {
$timerange = " AND DATE(di2.accessed_at) = '{$strToMysqlDate($start)}'";
} else {
$timerange = "";
}
return "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tCOUNT(di2.id) downloads\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . Model\MediaFile::table_name() . " mf2\n\t\t\t\t\t\tLEFT JOIN " . Model\DownloadIntentClean::table_name() . " di2 ON di2.media_file_id = mf2.id\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tmf2.episode_id = e.id\n\t\t\t\t\t\t{$timerange}\n\t\t\t\t";
};
$sql = "\n\t\t\t\tSELECT\n\t\t\t\t\te.id,\n\t\t\t\t\tp.post_title title,\n\t\t\t\t\tp.post_date post_date,\n\t\t\t\t\tCOUNT(di.id) downloads,\n\t\t\t\t\t(" . $subSQL('28 days ago', 'now') . ") downloadsMonth,\n\t\t\t\t\t(" . $subSQL('7 days ago', 'now') . ") downloadsWeek,\n\t\t\t\t\t(" . $subSQL('1 day ago') . ") downloadsYesterday,\n\t\t\t\t\t(" . $subSQL('now') . ") downloadsToday\n\t\t\t\tFROM\n\t\t\t\t\t" . Model\Episode::table_name() . " e\n\t\t\t\t\tJOIN " . $wpdb->posts . " p ON e.post_id = p.ID\n\t\t\t\t\tJOIN " . Model\MediaFile::table_name() . " mf ON e.id = mf.episode_id\n\t\t\t\t\tLEFT JOIN " . Model\DownloadIntentClean::table_name() . " di ON di.media_file_id = mf.id\n\t\t\t\tWHERE\n\t\t\t\t\tp.post_status IN ('publish', 'private')\n\t\t\t\tGROUP BY\n\t\t\t\t\te.id\n\t\t\t";
return $wpdb->get_results($sql, ARRAY_A);
}, HOUR_IN_SECONDS);
$valid_order_keys = array('post_date', 'downloads', 'downloadsMonth', 'downloadsWeek', 'downloadsYesterday', 'downloadsToday');
// look for order options
if (isset($_GET['orderby']) && in_array($_GET['orderby'], $valid_order_keys)) {
$orderby = $_GET['orderby'];
} else {
$orderby = 'post_date';
}
// look how to sort
if (isset($_GET['order'])) {
$order = strtoupper($_GET['order']) == 'ASC' ? SORT_ASC : SORT_DESC;
} else {
$order = SORT_DESC;
}
array_multisort(\array_column($data, $orderby), $order, $data);
// get current page
$current_page = $this->get_pagenum();
// get total items
$total_items = count($data);
// extrage page for current page only
$data = array_slice($data, ($current_page - 1) * $per_page, $per_page);
// add items to table
$this->items = $data;
// register pagination options & calculations
$this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil($total_items / $per_page)));
}
public function init()
{
add_settings_section('podlove_settings_episode', __('', 'podlove'), function () {
echo '<h3>' . __('WebPlayer Settings', 'podlove') . '</h3>';
}, Settings::$pagehook);
register_setting(Settings::$pagehook, 'podlove_webplayer_formats');
register_setting(Settings::$pagehook, 'podlove_webplayer_settings', function ($setting) {
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
return $setting;
});
}
function podlove_init_deprecation_checker()
{
// dashboard only
if (filter_input(INPUT_GET, 'page') !== 'podlove_settings_handle') {
return;
}
$cache = \Podlove\Cache\TemplateCache::get_instance();
$deprecations = $cache->cache_for('podlove_template_deprecations', function () {
return podlove_get_deprecations();
});
podlove_render_deprecations($deprecations);
}
/**
* Feed list, ready for subscribe button.
*
* @return array list of prepared feed data-objects
*/
private function feeds()
{
return TemplateCache::get_instance()->cache_for('podlove_subscribe_button_feeds', function () {
$feeds = array_map(function ($feed) {
$file_type = $feed->episode_asset()->file_type();
return ['type' => $file_type->type, 'format' => self::feed_format($file_type->extension), 'url' => $feed->get_subscribe_url(), 'variant' => 'high'];
}, $this->discoverable_feeds());
$itunes_feed = Feed::find_one_by_where('itunes_feed_id > 0');
if ($itunes_feed) {
// @todo verify the url is valid
$feeds[] = ['type' => 'itunes-url', 'url' => 'https://itunes.apple.com/podcast/id' . $itunes_feed->itunes_feed_id];
}
return $feeds;
});
}
/**
* Provides shortcode to display episode template.
*
* Usage:
*
* [podlove-template template="Template Title"]
*
* Parameters:
* template: (required) Title of template to render.
* autop: (optional) Wraps blocks of text in p tags. 'yes' or 'no'. Default: 'yes'
*
* @param array $attributes
* @return string
*/
function template_shortcode($attributes)
{
$defaults = array('title' => '', 'id' => '', 'template' => '', 'autop' => false);
$attributes = array_merge($defaults, $attributes);
if ($attributes['title'] !== '') {
_deprecated_argument(__FUNCTION__, '1.3.14-alpha', 'The "title" attribute for [podlove-template] shortcode is deprecated. Use "id" instead.');
}
if ($attributes['id'] !== '') {
_deprecated_argument(__FUNCTION__, '2.1.0', 'The "id" attribute for [podlove-template] shortcode is deprecated. Use "template" instead.');
}
// backward compatibility
if ($attributes['template']) {
$template_id = $attributes['template'];
} elseif ($attributes['id']) {
$template_id = $attributes['id'];
} else {
$template_id = $attributes['title'];
}
$permalink = get_permalink();
/**
* Cache key must be unique for *every permutation* of the content.
* Meaning: If there are context based conditionals, the key must reflect them.
*/
$tag_permutation = implode('', array_map(function ($tag) {
return $tag() ? "1" : "0";
}, \Podlove\Template\TwigFilter::$template_tags));
/**
* Cache key must change for any custom parameters.
*/
$attr_permutation = implode('', array_map(function ($a) {
return (string) $a;
}, array_values($attributes)));
$cache_key = $template_id . $permalink . $tag_permutation . $attr_permutation;
$cache_key = apply_filters('podlove_template_shortcode_cache_key', $cache_key, $template_id);
$cache = \Podlove\Cache\TemplateCache::get_instance();
return $cache->cache_for($cache_key, function () use($template_id, $attributes) {
if (!($template = Model\Template::find_one_by_title_with_fallback($template_id))) {
return sprintf(__('Podlove Error: Whoops, there is no template with id "%s"', 'podlove'), $template_id);
}
$html = apply_filters('podlove_template_raw', $template->title, $attributes);
// apply autop and shortcodes
if (in_array($attributes['autop'], array('yes', 1, 'true'))) {
$html = wpautop($html);
}
return do_shortcode($html);
});
}
public static function update()
{
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$title = filter_input(INPUT_POST, 'title');
$content = filter_input(INPUT_POST, 'content');
if (!$id || !$title) {
Ajax::respond_with_json(array("success" => false));
}
$template = Template::find_by_id($id);
$template->title = $title;
$template->content = $content;
$template->save();
if (is_network_admin()) {
\Podlove\Cache\TemplateCache::get_instance()->setup_purge_in_all_blogs();
}
Ajax::respond_with_json(array("success" => true));
}
/**
* Adds feed discover links to WordPress head.
*/
function podlove_add_feed_discoverability()
{
if (is_admin()) {
return;
}
if (!function_exists('\\Podlove\\Feeds\\prepare_for_feed')) {
require_once \Podlove\PLUGIN_DIR . 'lib/feeds/base.php';
}
$cache = \Podlove\Cache\TemplateCache::get_instance();
echo $cache->cache_for('feed_discoverability', function () {
$feeds = \Podlove\Model\Podcast::get()->feeds();
$html = '';
foreach ($feeds as $feed) {
if ($feed->discoverable) {
$html .= '<link rel="alternate" type="' . $feed->get_content_type() . '" title="' . \Podlove\Feeds\prepare_for_feed($feed->title_for_discovery()) . '" href="' . $feed->get_subscribe_url() . "\" />\n";
}
}
return $html;
});
}
public static function numbers()
{
$episode = Model\Episode::find_one_by_id((int) $_REQUEST['episode']);
$cache = \Podlove\Cache\TemplateCache::get_instance();
echo $cache->cache_for('podlove_analytics_episode' . $episode->id, function () use($episode) {
$post = get_post($episode->post_id);
$releaseDate = new \DateTime($post->post_date);
$releaseDate->setTime(0, 0, 0);
$diff = $releaseDate->diff(new \DateTime());
$daysSinceRelease = $diff->days;
$downloads = array('total' => Model\DownloadIntentClean::total_by_episode_id($episode->id, "1000 years ago", "now"), 'month' => Model\DownloadIntentClean::total_by_episode_id($episode->id, "28 days ago", "yesterday"), 'week' => Model\DownloadIntentClean::total_by_episode_id($episode->id, "7 days ago", "yesterday"), 'yesterday' => Model\DownloadIntentClean::total_by_episode_id($episode->id, "1 day ago"), 'today' => Model\DownloadIntentClean::total_by_episode_id($episode->id, "now"));
$peak = Model\DownloadIntentClean::peak_download_by_episode_id($episode->id);
ob_start();
?>
<div class="analytics-metric-box">
<span class="analytics-description">Average</span>
<span class="analytics-value"><?php
echo number_format_i18n($downloads['total'] / ($daysSinceRelease + 1), 1);
?>
</span>
<span class="analytics-subtext">Downloads per Day</span>
</div>
<div class="analytics-metric-box">
<span class="analytics-description">Peak</span>
<span class="analytics-value"><?php
echo number_format_i18n($peak['downloads']);
?>
</span>
<span class="analytics-subtext">Downloads<br>on <?php
echo mysql2date(get_option('date_format'), $peak['theday']);
?>
</span>
</div>
<div class="analytics-metric-box">
<span class="analytics-description">Total</span>
<span class="analytics-value"><?php
echo number_format_i18n($downloads['total']);
?>
</span>
<span class="analytics-subtext">Downloads</span>
</div>
<div class="analytics-metric-box">
<table>
<tbody>
<tr>
<td>28 Days</td>
<td><?php
echo number_format_i18n($downloads['month']);
?>
</td>
</tr>
<tr>
<td>7 Days</td>
<td><?php
echo number_format_i18n($downloads['week']);
?>
</td>
</tr>
<tr>
<td>Yesterday</td>
<td><?php
echo number_format_i18n($downloads['yesterday']);
?>
</td>
</tr>
<tr>
<td>Today</td>
<td><?php
echo number_format_i18n($downloads['today']);
?>
</td>
</tr>
</tbody>
</table>
</div>
<style type="text/css">
.analytics-metric-box {
text-align: center;
float: left;
margin: 20px 0 20px 20px;
}
.analytics-metric-box > span {
font-size: 23px;
line-height: 23px;
display: block;
}
.analytics-metric-box .analytics-value {
font-weight: bold;
line-height: 40px;
}
.analytics-metric-box .analytics-description,
.analytics-metric-box .analytics-subtext {
font-size: 14px;
line-height: 16px;
color: #666;
}
</style>
<div class="clear"></div>
<?php
$html = ob_get_contents();
ob_end_clean();
return $html;
}, 600);
// 10 minutes
}
/**
* @todo episode should not know about cache; better: $cache->delete_for($episode)
*/
public function delete_caches()
{
// delete caches for current episode
delete_transient('podlove_chapters_string_' . $this->id);
// delete caches for revisions of this episode
if ($revisions = wp_get_post_revisions($this->post_id)) {
foreach ($revisions as $revision) {
if ($revision_episode = Episode::find_one_by_post_id($revision->ID)) {
delete_transient('podlove_chapters_string_' . $revision_episode->id);
}
}
}
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
}
public function generate_resized_copy()
{
$image = wp_get_image_editor($this->original_file());
if (is_wp_error($image)) {
return;
}
$image->resize($this->width, $this->height, $this->crop);
$image->save($this->resized_file());
// when a new image size is created, Templace Cache must be cleared
TemplateCache::get_instance()->setup_global_purge();
}
private static function clear_podlove_cache()
{
$cache = \Podlove\Cache\TemplateCache::get_instance();
$cache->setup_purge();
self::add_to_repair_log(__('Podlove cache cleared', 'podlove'));
}
/**
* 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 inject_widget($content)
{
global $post;
if ('podcast' !== get_post_type()) {
return $content;
}
if (is_feed()) {
return $content;
}
$cache = \Podlove\Cache\TemplateCache::get_instance();
$bitlove_html = $cache->cache_for('bitlove_' . get_permalink($post->ID), function () use($post) {
$episode = Model\Episode::find_or_create_by_post_id($post->ID);
$media_files = $episode->media_files();
$downloads = array();
$content = '';
foreach ($media_files as $media_file) {
$episode_asset = $media_file->episode_asset();
if (!$episode_asset->downloadable) {
continue;
}
$file_type = $episode_asset->file_type();
$download_link_name = str_replace(" ", " ", $episode_asset->title);
$downloads[] = array('enclosure_guid' => RssExtension::get_enclosure_guid($media_file), 'name' => $download_link_name, 'size' => \Podlove\format_bytes($media_file->size, 0), 'file' => $media_file);
}
$content .= '<script type="text/javascript">';
$content .= ' /* <!-- */';
foreach ($downloads as $download) {
$content .= <<<EOF
jQuery(function(\$) {
\ttorrentByEnclosure("{$download['enclosure_guid']}", function(info) {
\t if (info) {
\t var url = info.sources[0].torrent,
\t title = "Torrent: {$download['name']}";
\t // select-style download-widget
\t jQuery("#post-{$post->ID} [name='download_media_file']").append("<option value='" + url + "' data-raw-url='" + url + "'>" + title + "</option>")
\t // button-stile download-widget
\t jQuery("#post-{$post->ID} .episode_download_list").append("<li><a href='" + url + "'>" + title + "<span class='size'></span></a></li>")
\t }
\t});
});
EOF;
}
$content .= ' /* --> */';
$content .= '</script>';
return $content;
});
return $content . $bitlove_html;
}
public function analytics_total_downloads_per_day()
{
$cache_key = 'podlove_analytics_tdphx';
$cache = \Podlove\Cache\TemplateCache::get_instance();
$content = $cache->cache_for($cache_key, function () {
global $wpdb;
$sql = "SELECT\n\t\t\t\t\t\tCOUNT(*) downloads,\n\t\t\t\t\t\tUNIX_TIMESTAMP(accessed_at) AS access_date,\n\t\t\t\t\t\tDATE_FORMAT(accessed_at, '%Y-%m-%d') AS date_day,\n\t\t\t\t\t\tmf.episode_asset_id asset_id,\n\t\t\t\t\t\tclient_name,\n\t\t\t\t\t\tos_name AS system,\n\t\t\t\t\t\tsource,\n\t\t\t\t\t\tcontext\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . Model\DownloadIntentClean::table_name() . " di\n\t\t\t\t\t\tINNER JOIN " . Model\MediaFile::table_name() . " mf ON mf.id = di.media_file_id\n\t\t\t\t\t\tINNER JOIN " . Model\UserAgent::table_name() . " ua ON ua.id = di.user_agent_id\n\t\t\t\t\tWHERE accessed_at >= STR_TO_DATE('" . date("Y-m-d", strtotime("-30 days")) . "','%Y-%m-%d')\n\t\t\t\t\tGROUP BY date_day, asset_id, client_name, system, source, context";
$results = $wpdb->get_results($sql, ARRAY_N);
$csv = '"downloads","date","asset_id","client","system","source","context"' . "\n";
foreach ($results as $row) {
$row[4] = '"' . $row[4] . '"';
$row[5] = '"' . $row[5] . '"';
$csv .= implode(",", $row) . "\n";
}
return $csv;
}, 3600);
$etag = md5($content);
header("Etag: {$etag}");
header("Last-Modified: " . gmdate("D, d M Y H:i:s", $cache->expiration_for($cache_key)) . " GMT");
$etagHeader = isset($_SERVER['HTTP_IF_NONE_MATCH']) ? trim($_SERVER['HTTP_IF_NONE_MATCH']) : false;
if ($etagHeader == $etag) {
header("HTTP/1.1 304 Not Modified");
exit;
}
\Podlove\Feeds\check_for_and_do_compression('text/plain');
echo $content;
ob_end_flush();
exit;
}
private static function fetch_contributors_for_dashboard_statistics()
{
return \Podlove\Cache\TemplateCache::get_instance()->cache_for('podlove_dashboard_stats_contributors', function () {
return (new Model\ContributionGenderStatistics())->get();
}, 3600);
}
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;
});
}
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);
}
/**
* Setup complete purge, depending on if we are a Multisite
*/
public function setup_global_purge()
{
if (is_multisite()) {
TemplateCache::get_instance()->setup_purge_in_all_blogs();
} else {
TemplateCache::get_instance()->setup_purge();
}
}
public function __construct()
{
$errors =& $this->errors;
$notices =& $this->notices;
$this->fields = array('site' => array('title' => 'Website', 'callback' => function () {
return get_site_url();
}), 'php_version' => array('title' => 'PHP Version', 'callback' => function () {
return phpversion();
}), 'wp_version' => array('title' => 'WordPress Version', 'callback' => function () {
return get_bloginfo('version');
}), 'podlove_version' => array('title' => 'Publisher Version', 'callback' => function () {
return \Podlove\get_plugin_header('Version');
}), 'player_version' => array('title' => 'Web Player Version', 'callback' => function () {
if (!defined('PODLOVEWEBPLAYER_DIR')) {
return 'no web player found';
}
$pwp_file = PODLOVEWEBPLAYER_DIR . 'podlove-web-player.php';
if (!is_readable($pwp_file)) {
return 'not readable';
}
$plugin_data = \get_plugin_data($pwp_file);
return $plugin_data['Version'];
}), 'twig_version' => array('title' => 'Twig Version', 'callback' => function () {
return \Twig_Environment::VERSION;
}), 'open_basedir' => array('callback' => function () use(&$notices) {
$open_basedir = trim(ini_get('open_basedir'));
if ($open_basedir != '.') {
$notices[] = 'The PHP setting "open_basedir" is not empty. This is incompatible with curl, a library required by Podlove Publisher. We have a workaround in place but it is preferred to fix the issue. Please ask your hoster to unset "open_basedir".';
}
if ($open_basedir) {
return $open_basedir;
} else {
return 'ok';
}
}), 'curl' => array('title' => 'curl Version', 'callback' => function () use(&$errors) {
$module_loaded = in_array('curl', get_loaded_extensions());
$function_disabled = stripos(ini_get('disable_functions'), 'curl_exec') !== false;
$out = '';
if ($module_loaded) {
$curl = curl_version();
$out .= $curl['version'];
} else {
$out .= 'EXTENSION MISSING';
$errors[] = 'curl extension is not loaded';
}
if ($function_disabled) {
$out .= ' | curl_exec is disabled';
$errors[] = 'curl_exec is disabled';
}
return $out;
}), 'iconv' => array('callback' => function () use(&$errors) {
$iconv_available = function_exists('iconv');
if (!$iconv_available) {
$errors[] = 'You need to install/activate php5-iconv';
}
return $iconv_available ? "available" : "MISSING";
}), 'simplexml' => array('callback' => function () use(&$errors) {
if (!($simplexml = in_array('SimpleXML', get_loaded_extensions()))) {
$errors[] = 'You need to install/activate the PHP SimpleXML module';
}
return $simplexml ? 'ok' : 'missing!';
}), 'max_execution_time' => array('callback' => function () {
return ini_get('max_execution_time');
}), 'upload_max_filesize' => array('callback' => function () {
return ini_get('upload_max_filesize');
}), 'memory_limit' => array('callback' => function () {
return ini_get('memory_limit');
}), 'disable_classes' => array('callback' => function () {
return ini_get('disable_classes');
}), 'disable_functions' => array('callback' => function () {
return ini_get('disable_functions');
}), 'permalinks' => array('callback' => function () use(&$errors) {
$permalinks = \get_option('permalink_structure');
if (!$permalinks) {
$errors[] = sprintf(__('You are using the default WordPress permalink structure. This may cause problems with some podcast clients. Go to %s and set it to anything but default (for example "Post name").', 'podlove'), admin_url('options-permalink.php'));
return __("\"non-pretty\" Permalinks: Please change permalink structure", 'podlove');
}
return "ok ({$permalinks})";
}), 'podlove_permalinks' => array('callback' => function () use(&$errors) {
if (\Podlove\get_setting('website', 'use_post_permastruct') == 'on') {
return 'ok';
}
if (stristr(\Podlove\get_setting('website', 'custom_episode_slug'), '%podcast%') === FALSE) {
$website_options = get_option('podlove_website');
$website_options['use_post_permastruct'] = 'on';
update_option('podlove_website', $website_options);
}
return 'ok';
}), 'podcast_settings' => array('callback' => function () use(&$errors) {
$out = '';
$podcast = Model\Podcast::get();
if (!$podcast->title) {
$error = __('Your podcast needs a title.', 'podlove');
$errors[] = $error;
$out .= $error;
}
if (!$podcast->media_file_base_uri) {
$error = __('Your podcast needs an upload location for file storage.', 'podlove');
$errors[] = $error;
$out .= $error;
}
if (!$out) {
$out = "ok";
}
return $out;
}), 'web_player' => array('callback' => function () use(&$errors) {
foreach (get_option('podlove_webplayer_formats', array()) as $_ => $media_types) {
foreach ($media_types as $extension => $asset_id) {
if ($asset_id) {
return "ok";
}
}
}
$error = __('You need to assign at least one asset to the web player.', 'podlove');
$errors[] = $error;
return $error;
}), 'podlove_cache' => array('callback' => function () {
return \Podlove\Cache\TemplateCache::is_enabled() ? 'on' : 'off';
}), 'assets' => array('callback' => function () {
$assets = array();
foreach (\Podlove\Model\EpisodeAsset::all() as $asset) {
$file_type = $asset->file_type();
$assets[] = array('extension' => $file_type->extension, 'mime_type' => $file_type->mime_type);
}
return "\n\t" . implode("\n\t", array_map(function ($asset) {
return str_pad($asset['extension'], 7) . $asset['mime_type'];
}, $assets));
}));
$this->fields = apply_filters('podlove_system_report_fields', $this->fields);
$this->run();
}
