Changeset 152347

Timestamp:

09/05/2009 09:46:43 PM (16 years ago)

Author:

microkid

Message:

Adding version 2.4

• You can now add drafts and planned posts as related posts, without them appearing on your site before they are properly published.
• Added shortcode support - you can now place the [related-posts] shortcode within the content of your post to display the related posts anywhere you want.
• (For advanced users) Added a parameter to the MRP_get_related_posts function to optionally get the related posts in an object, so you can easily use it in other plugins or your own custom way of displaying the list of related posts. For documentation on this, see ​http://www.microkid.net/wordpress/related-posts/#API

Location:

microkids-related-posts

Files:

• tags/2.3 (added)
• tags/2.3/images (copied) (copied from microkids-related-posts/trunk/images)
• tags/2.3/microkids-related-posts.css (copied) (copied from microkids-related-posts/trunk/microkids-related-posts.css)
• tags/2.3/microkids-related-posts.js (copied) (copied from microkids-related-posts/trunk/microkids-related-posts.js)
• tags/2.3/microkids-related-posts.php (copied) (copied from microkids-related-posts/trunk/microkids-related-posts.php)
• tags/2.3/mrp-search.php (copied) (copied from microkids-related-posts/trunk/mrp-search.php)
• tags/2.3/readme.txt (copied) (copied from microkids-related-posts/trunk/readme.txt)
• tags/2.3/screenshot-1.png (copied) (copied from microkids-related-posts/trunk/screenshot-1.png)
• tags/2.3/screenshot-2.png (copied) (copied from microkids-related-posts/trunk/screenshot-2.png)
• tags/2.3/screenshot-3.png (copied) (copied from microkids-related-posts/trunk/screenshot-3.png)
• tags/2.4 (added)
• tags/2.4/images (added)
• tags/2.4/images/link.png (added)
• tags/2.4/microkids-related-posts.css (added)
• tags/2.4/microkids-related-posts.js (added)
• tags/2.4/microkids-related-posts.php (added)
• tags/2.4/mrp-search.php (added)
• tags/2.4/readme.txt (added)
• tags/2.4/screenshot-1.png (added)
• tags/2.4/screenshot-2.png (added)
• tags/2.4/screenshot-3.png (added)
• trunk/microkids-related-posts.php (modified) (9 diffs)
• trunk/mrp-search.php (modified) (2 diffs)
• trunk/readme.txt (modified) (4 diffs)
• trunk/screenshot-1.png (modified) (previous)
• trunk/screenshot-2.png (modified) (previous)
• trunk/screenshot-3.png (modified) (previous)

microkids-related-posts/trunk/microkids-related-posts.php

@@ -3 +3 @@
 Plugin Name: Microkid's Related Posts
 Plugin URI: http://www.microkid.net/wordpress/related-posts/
-Description: Manually add related posts
+Description: Display a set of manually selected related items with your posts
 Author: Microkid
-Version: 2.3
+Version: 2.4
 Author URI: http://www.microkid.net/
 
@@ -79 +79 @@
     
     }
+
     function MRP_inner_custom_box() {
 
@@ -90 +91 @@
         if( $post_ID ) {
         
-            if( $related_posts = MRP_get_related_posts( $post_ID ) ) {
-            
-                foreach( $related_posts as $related_post_id => $related_post_title ) {
-                
-                    echo '<li id="related-post-'.$related_post_id.'"><span>'.$related_post_title.'</span><span><a class="MRP_deletebtn" onclick="MRP_remove_relationship(\'related-post-'.$related_post_id.'\')">X</a></span>';
-                    echo '<input type="hidden" name="MRP_related_posts[]" value="'.$related_post_id.'" /></li>';
+            if( $related_posts = MRP_get_related_posts( $post_ID, 1, 0 ) ) {
+                
+                foreach( $related_posts as $related_post ) {
+                
+                    $post_title = $related_post->post_title;
+                    if( $related_post->post_type == 'page' ) {
+                        $post_title = "[Page] " . $post_title;
+                    }
+                    if( $related_post->post_status != 'publish' ) {
+                        $post_title = $post_title . ' ('.$related_post->post_status.')';
+                    }
+                    echo '<li id="related-post-'.$related_post->ID.'"><span>'.$post_title.'</span><span><a class="MRP_deletebtn" onclick="MRP_remove_relationship(\'related-post-'.$related_post->ID.'\')">X</a></span>';
+                    echo '<input type="hidden" name="MRP_related_posts[]" value="'.$related_post->ID.'" /></li>';
                 
                 }           
@@ -197 +205 @@
         $related_posts[related_post_id] => related_post_title
     */
-    function MRP_get_related_posts( $post_id ) {
-    
+    function MRP_get_related_posts( $post_id, $return_object = false, $hide_unpublished = true ) {
+
         global $wpdb;
-        
+
         $options = get_option("MRP_options");
-        
+
         if($options['display_reciprocal']) {
-        
+
             //
-            // Newer, faster (and definitely more SQL like) way to fetch related postings
-            // (Thanks Peter Raganitsch @ http://blog.oracleapex.at)
-            // 
-            $query = "SELECT wp.ID ".
-                      ", wp.post_title ".
-                   "FROM ".$wpdb->prefix."post_relationships    wpr ".
-                       ",".$wpdb->prefix."posts                     wp ".
-                  "WHERE wpr.post1_id = $post_id ".
-                    "AND wp.id = wpr.post2_id " .
-                 "UNION ALL ".
-                 "SELECT wp.ID ".
-                      ", wp.post_title ".
-                   "FROM ".$wpdb->prefix."post_relationships    wpr ".
-                       ",".$wpdb->prefix."posts                     wp ".
-                  "WHERE wpr.post2_id = $post_id ".
-                    "AND wp.id = wpr.post1_id ";
-      }
-      else {
-        $query = "SELECT wp.ID ".
-                         ", wp.post_title ".
-                     "FROM ".$wpdb->prefix."post_relationships  wpr ".
-                         " JOIN ".$wpdb->prefix."posts          wp ".
-                         "  ON wpr.post2_id = wp.ID ".
-                     "WHERE wpr.post1_id = $post_id";
+            // Newer, faster (and definitely more SQL like) way to fetch related postings
+            // (Thanks Peter Raganitsch @ http://blog.oracleapex.at)
+            // 
+            $query = "SELECT * ".
+                "FROM ".$wpdb->prefix."post_relationships   wpr ".
+                ",".$wpdb->prefix."posts                    wp ".
+                "WHERE wpr.post1_id = $post_id ".
+                "AND wp.id = wpr.post2_id ";
+            if( $hide_unpublished ) {
+                $query .= "AND wp.post_status = 'publish'";
+            }
+            $query .= "UNION ALL ".
+                "SELECT * ".
+                "FROM ".$wpdb->prefix."post_relationships   wpr ".
+                ",".$wpdb->prefix."posts                    wp ".
+                "WHERE wpr.post2_id = $post_id ".
+                "AND wp.id = wpr.post1_id ";
+            if( $hide_unpublished ) {
+                $query .= "AND wp.post_status = 'publish'";
+            }
+        }
+        else {
+            $query = "SELECT * ".
+                "FROM ".$wpdb->prefix."post_relationships   wpr ".
+                " JOIN ".$wpdb->prefix."posts               wp ".
+                "   ON wpr.post2_id = wp.ID ".
+                "WHERE wpr.post1_id = $post_id";
+            if( $hide_unpublished ) {
+                $query .= " AND wp.post_status = 'publish'";
+            }
         }
 
@@ -235 +249 @@
 
         if( $results ) {
-            $related_posts = array();
-            foreach( $results as $result ) {
-                $related_posts[$result->ID] = $result->post_title;
-            }
-            return $related_posts;
+            if( $return_object ) {
+                return $results;
+            }
+            else {
+                $related_posts = array();
+                foreach( $results as $result ) {
+                    $related_posts[$result->ID] = $result->post_title;
+                }
+                return $related_posts;
+            }
         }
         return false;
@@ -300 +319 @@
         $options = get_option("MRP_options");
         
-        $related_posts = MRP_get_related_posts( $post_id );
+        $related_posts = MRP_get_related_posts( $post_id, 1, 1 );
                 
         if( $related_posts ) {
@@ -309 +328 @@
             $output .= "<ul>\n";
 
-            foreach( $related_posts as $related_post_id => $related_post_title  ) {
-                $output .= "<li><a href=\"".get_permalink( $related_post_id )."\" title=\"$related_post_title\">".$related_post_title."</a></li>\n";
+            foreach( $related_posts as $related_post  ) {
+                $output .= "<li><a href=\"".get_permalink( $related_post->ID )."\" title=\"$related_post_title\">".$related_post->post_title."</a></li>\n";
             }
             
@@ -410 +429 @@
         <input type="hidden" id="MRP_submit" name="MRP_submit" value="1" />
     <?php
+    }
+    
+    
+    function MRP_shortcode($atts) {
+        global $post;
+        if( $post->ID ) {
+            return MRP_get_related_posts_html( $post->ID );
+        }
     }
     
@@ -535 +562 @@
     add_filter('the_content', 'MRP_auto_related_posts');
     
+    add_shortcode('related-posts', 'MRP_shortcode');
+    
+    
 
 ?>

microkids-related-posts/trunk/mrp-search.php

@@ -38 +38 @@
     }
     
-    $query = "SELECT ID, post_title, post_type FROM $wpdb->posts WHERE $where AND ( post_type = 'post' OR post_type = 'page' ) AND post_status = 'publish' ";
+    $query = "SELECT ID, post_title, post_type, post_status FROM $wpdb->posts WHERE $where AND ( post_type = 'post' OR post_type = 'page' ) ";
     if( $_GET['mrp_id'] ) {
         $this_id = (int) $_GET['mrp_id'];
@@ -58 +58 @@
                 echo "<strong>[Page]</strong> - ";
             }
-            echo $result->post_title.'</a> <a href="'.get_permalink( $result->ID ).'" title="View this post" class="MRP_view_post" target="_blank">&rsaquo;</a></li>';
+            echo $result->post_title;
+            if( $result->post_status != 'publish') {
+                echo ' ('.$result->post_status.')';
+            }
+            echo '</a> <a href="'.get_permalink( $result->ID ).'" title="View this post" class="MRP_view_post" target="_blank">&rsaquo;</a></li>';
             $n++;
         }

microkids-related-posts/trunk/readme.txt

@@ -1 +1 @@
 === Microkid's Related Posts ===
 Contributors: microkid
-Tags: related, posts, seo, content, articles, relevant
+Tags: related, posts, seo, content, articles, relevant, similar
 Requires at least: 2.5
-Tested up to: 2.7
+Tested up to: 2.8.4
 Stable tag: trunk
 
@@ -18 +18 @@
 = Features =
 
-* Manually search and add related posts
 * Easily find posts or pages that might be related to the one you are writing with an integrated AJAX powered search utility
 * Easily add and remove relations with a single click. No page reloads, no pop-ups
@@ -40 +39 @@
 
 = Does this plugin work with Wordpress versions < 2.5? =
-No, unfortunately it is not yet backward compatible with Wordpress version older than 2.5.
+No, it is not yet backward compatible with Wordpress version older than 2.5.
 
 = What will be displayed if there are no related posts? =
 You can use a custom message, or display nothing at all (no text, no code).
 
-= Is there any way to grab the related posts in PHP, so I can display them somewhere else instead of underneath my post? =
-Yes, there is a set of [API functions](http://www.microkid.net/wordpress/related-posts/#API "Microkids Related Posts API functions") available to help you do this.
+= How can I customize the way the related posts are displayed? =
+There is a set of [API functions](http://www.microkid.net/wordpress/related-posts/#API "Microkids Related Posts API functions") available you can use in your themes.
 
 = I'm having trouble using this plugin. How can I reach you? =
@@ -58 +57 @@
 
 == Change Log ==
+
+= 2.4 =
+* You can now add drafts and planned posts as related posts, without them appearing on your site before they are properly published.
+* Added shortcode support - you can now place the [related-posts] shortcode within the content of your post to display the related posts anywhere you want.
+* (For advanced users) Added a parameter to the MRP_get_related_posts function to optionally get the related posts in an object, so you can easily use it in other plugins or your own custom way of displaying the list of related posts. For documentation on this, see [the API section](http://www.microkid.net/wordpress/related-posts/#API "Microkids Related Posts API functions").
 
 = 2.3 =