blubrry

machouinard

<p>By populating a MySQL database table with all the information about the podcasts you can automatically create the posts needed for podcasting with the <a href="https://wordpress.org/extend/plugins/powerpress/" title="WordPress Podcasting" rel="ugc">Blubrry PowerPress plugin</a>. This will allow you to post as draft or published and switch between the two as well as delete posts.  Probably not useful to actual Podcasters, but it works for what I needed.</p>
<p>Information required from the database:</p>
<ul>
<li>Host</li>
<li>Database Name</li>
<li>Database Table Name</li>
<li>Database Username</li>
<li>Database Password</li>
</ul>
<p>Also field names from the database which will be used for the following:</p>
<ul>
<li>Primary Key Field</li>
<li>Title</li>
<li>Category</li>
<li>Post Body</li>
<li>Featured Image(URL to an image)</li>
<li>Media URL</li>
<li>Media size</li>
<li>Media type</li>
<li>Date posted</li>
</ul>
<p>Your categories need to be setup prior to using this.</p>
<h4>Example database table for importing from</h4>
<p>You may use the following database table as an example template for your database.</p>
<pre><code>CREATE TABLE episodes (
  episode_id int(11) NOT NULL,
  episode_title varchar(255) NOT NULL,
  episode_category varchar(255) NOT NULL,
  episode_body text NOT NULL,
  episode_image_url varchar(4000) NOT NULL,
  episode_url varchar(4000) NOT NULL,
  episode_length int(11) NOT NULL,
  episode_content_type varchar(20) NOT NULL,
  episode_date date NOT NULL,
  PRIMARY KEY (episode_id)
) DEFAULT CHARSET=utf8;
</code></pre>
<p>Note: You must have at least one record in the database table before you can enter the database column fields in this plugin.</p>


PowerPress Posts From MySQL addon

Have a bunch of podcasts stored on your server and aren't excited about creating each post manually? This can help.

Angelo Mandato

Plugins Podcast

<p>Remove the query string ?<em>=1 added by WordPress adds to media URLs in HTML5 audio and video mediaelement.js players. It will match any digit that follows the equals sign, e.g. ?</em>=42 will be removed.</p>
<h4>This plugin is ideal for the following reasons</h4>
<ul>
<li>Page Loading Performance: Improve page speed scores with services like PageSpeed, YSlow, Pingdoom and GTmetrix.</li>
<li>Caching: Links with query string parameters such as “?” followed by name=value pairs separated by ‘&’ in the URL are typically not cacheable</li>
<li>Statistics and Analytics: Prevent statistics and analytics services from including the query string in reporting.</li>
<li>Google?s Accelerated Mobile Pages (AMP): Removes the possibility of links to media files being detected as AMP errors.</li>
</ul>
<h4>Compatible Media Plugins</h4>
<ul>
<li><a href="https://wordpress.org/plugins/powerpress/" rel="ugc">Blubrry PowerPress podcasting plugin</a></li>
</ul>
<p>If this plugin works with your favorite media plugin, please contact me and I will add it to the list.</p>


Remove Query Arg from Media URLs ?_=1

Remove the query string ?_=1 added by WordPress adds to media URLs in HTML5 audio and video mediaelement.js players.

PowerPress Posts From MySQL addon vs Remove Query Arg from Media URLs ?_=1