CSS Tips & Tricks

The WordPress Featured Video Plugin is a very useful and powerful feature to add in your wordpress blog.
* It  reads and displays a video in your wordpress blog post.
* All you need is tag the video HTML code as follows:
[youtube:url to your video] (e.g. [youtube:http://www.youtube.com/watch?v=7o84PE871BE]) or taggged [googlevideo:url] (e.g. [googlevideo:http://video.google.com/googleplayer.swf?docid=8577255250907450469])

* It would display a video in a “Featured Video” section or the sidebar of your blog.
I have used it quite a few times during the cutsomization process of some of my clients’ blog using themes from Revolution News/Magazine
However when using it in the “Revolution News” theme, the Featued Video seems to be displaying the same video on the featured video section despite the fact that my customer has

Solution:
* open the “featuredvideo.php” file in your wordpress plugins folder /wp-content/plugins/FeaturedVideo
* add ORDER BY post_date DESC to the $sql varible which becomes:

 $sql = "SELECT distinct ID, post_title, post_date, post_content                         
            FROM {$prefix}posts, {$prefix}term_relationships, {$prefix}term_taxonomy
            WHERE {$prefix}posts.ID = {$prefix}term_relationships.object_id
            AND {$prefix}term_relationships.term_taxonomy_id = {$prefix}term_taxonomy.term_taxonomy_id
            AND {$prefix}term_taxonomy.taxonomy = 'category'
            {$catsql}
            AND post_status = 'publish'
            AND post_type != 'page'
   ORDER BY post_date DESC";

 * save and upload that file to your blog at the same location (/wp-content/plugins/FeaturedVideo/featuredvideo.php)

Just as with any other plugin, you need to activate it in your blog admin panel and set the options offered.
Then “Featured Video Plugin” will now located the latest youtube or googlevideo file used in your posts and display it in the Featured Video section of your choice. Just be sure to have to call vsf_show_video() in order to get the job done

This entry was posted on Saturday, July 26th, 2008 at 12:33 pm and is filed under CSS Tips & Tricks, WordPress Blog, Wordpress plugins. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.