Support » Plugin: Related Posts for WordPress » FIX – Bad Order

  • I fixed the problem of a relation from the field “POSITION2” that always returned “0”,
    caused by the removal of the record before saving it.

    File MICROKIDS-RELATED-POSTS.PHP

    line 296
    MRP_delete_relationships( $post_id );

    in
    // MRP_delete_relationships( $post_id );

    line 315
    $left_q = "post1_id=".$post_id;

    in
    $left_q = "post1_id=".$v->post1_id;

    line 316
    $right_q = "post1_id=".$v->post1_id;

    in
    $right_q = "post2_id=".$post_id;

    Bye 😉

    http://wordpress.org/plugins/microkids-related-posts/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Here is the complete code to replace the file MICROKIDS-RELATED POSTS.PHP

    <?php
    /*
    Plugin Name: Microkid's Related Posts
    Plugin URI: http://www.microkid.net/wordpress/related-posts/
    Description: Display a set of manually selected related items with your posts
    Author: Microkid
    Version: 4.0.3
    Author URI: http://www.superinteractive.com
    
    This software is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    */
    
    define('MRP_DB_VERSION', '4.0.2');
    
    # Run at activation
    register_activation_hook( __FILE__, 'MRP_activate' );
    
    # Check for database upgrade
    add_action('admin_init', 'MRP_upgrade');
    
    # Add custom box on edit page
    add_action('admin_menu', 'MRP_add_custom_box');
    
    # Add options page
    add_action('admin_menu', 'MRP_add_options_page');
    
    # Save related posts
    add_action('save_post', 'MRP_save_postdata'); 
    
    # Listen for AJAX search call
    add_action('admin_init', 'MRP_ajax_listener');
    
    # Include default CSS styles
    add_action('wp_head','MRP_load_default_css');
    
    # Include javascript and css files
    add_action('admin_head','MRP_load_admin_includes');
    
    # Remove related posts
    add_action("delete_post", "MRP_delete_relationships");
    
    # Load widgets
    add_action("widgets_init", "MRP_load_widget");
    
    # Automatically add related posts list to post content
    add_filter('the_content', 'MRP_auto_related_posts');
    
    # Add [related-posts] shortcode support
    add_shortcode('related-posts', 'MRP_shortcode');
    
    # Load internationalization files
    if( is_admin() ){
        load_plugin_textdomain( 'microkids-related-posts', WP_PLUGIN_DIR . '/' .dirname(plugin_basename(__FILE__)) . '/languages', dirname(plugin_basename(__FILE__)) . '/languages' );
    }
    
    # Include the widget class
    require( "microkids-related-posts-widget.php" );
    
    /**
     * MRP_activate - Run when the plugin is first installed and after an upgrade
     */
    function MRP_activate() {
    	global $wpdb;
    	# Check if post_relationships table exists, if not, create it
    	$query = "SHOW TABLES LIKE '".$wpdb->prefix."post_relationships'";
    	if( !count( $wpdb->get_results( $query ) ) ) {
    		$query = "CREATE TABLE ".$wpdb->prefix."post_relationships (
    					post1_id bigint(60) unsigned NOT NULL,
    					post2_id bigint(60) unsigned NOT NULL,
    					position1 int(10) unsigned DEFAULT 0,
    					position2 int(10) unsigned DEFAULT 0,
    					PRIMARY KEY  (post1_id,post2_id)
    				)";
    		$create = $wpdb->query( $query );
    	}
    	else {
    		$query = "SHOW COLUMNS FROM ".$wpdb->prefix."post_relationships LIKE 'position1'";
    		$check_column_exist = $wpdb->get_results($query);
    		if(!$check_column_exist){
    			// Upgrading to 4.0
    		 	$query1 = "ALTER TABLE <code>&quot;.$wpdb->prefix.&quot;post_relationships</code> ADD COLUMN <code>position1</code> BIGINT(60) UNSIGNED NULL DEFAULT 0  AFTER <code>post2_id</code>";
    			$add_ordering1 = $wpdb->query( $query );
    			$query2 = "ALTER TABLE <code>&quot;.$wpdb->prefix.&quot;post_relationships</code> ADD COLUMN <code>position2</code> BIGINT(60) UNSIGNED NULL DEFAULT 0  AFTER <code>post2_id</code>";
    			$add_ordering2 = $wpdb->query( $query );
    			// Add new ordering settings
    			$options = get_option("MRP_options");
    			$options['order_type'] = "auto";
    			update_option("MRP_options", $options);
    		}
    	}
    
    	$options = get_option("MRP_options");
    	# Create default settings
    	if( !$options ) {
    		$defaults = array();
    		$defaults['display_auto'] = 1;
    		$defaults['display_reciprocal'] = 1;
    		$defaults['title'] = "Related Posts";
    		$defaults['header_element'] = "h2";
    		$defaults['default_css'] = 1;
    		$defaults['hide_if_empty'] = 0;
    		$defaults['text_if_empty'] = "None";
    		$defaults['order_type'] = "manual";
    		$defaults['order'] = "date_desc";
    		$defaults['post_types'] = "post,page";
    		if( $custom_post_types = get_post_types( array( '_builtin' => false ) ) ) {
     		    foreach( $custom_post_types as $custom_post_type ) {
     		        $defaults['post_types'] .= ",$custom_post_type";
     		    }
     		}
     		$defaults['combine_post_types'] = 1;
     		$defaults['show_thumbnails'] = 1;
     		$defaults['thumbnail_size'] = "thumbnail";
     		$options['hide_donate'] = 0;
            update_option( "MRP_options", $defaults );
    	}
    	# This occurs when upgrading to v3.0
    	elseif( !isset($options['post_types'] ) ) {
    	    $options['post_types'] = "post,page";
    	    foreach( get_post_types( array( '_builtin' => false ) ) as $custom_post_type ) {
    	        $options['post_types'] .= ",$custom_post_type";
    	    }
    	    $options['combine_post_types'] = 1;
    	    $options['order'] = "date_desc";
    	    $options['hide_donate'] = 0;
    	    update_option( "MRP_options", $options );
    	}
    	# This occurs when upgrading to 4.0
    	elseif( !isset($options['order_type'] ) ) {
    		// Modificato
    		// $options['order_type'] = "auto";
    	    $options['order_type'] = "manual";
    	    $options['hide_donate'] = 0;
    	    update_option( "MRP_options", $options );
    	}
    }
    
    /**
    * MRP_upgrade() - Check if plugin is being upgraded
    * 				  This should be made a little more sophisticated in the future
    */
    function MRP_upgrade() {
    
    	$current_version = get_option('MRP_current_db_version');
    
    	if(version_compare($current_version, MRP_DB_VERSION, '==')) {
    		return;
    	}
    
    	if(!$current_version || version_compare($current_version, MRP_DB_VERSION, '<')) {
    		// Upgrading to 4.0.2
    		MRP_activate();
    		update_option('MRP_current_db_version', MRP_DB_VERSION);
    	}
    }
    
    /**
     * MRP_add_custom_box - Add the related posts custom box to the post add/edit screen
     */
    function MRP_add_custom_box() {
    	foreach( MRP_get_supported_post_types() as $post_type ) {
    	    add_meta_box( 'MRP_sectionid', __( 'Related items', 'microkids-related-posts' ), 'MRP_inner_custom_box', $post_type, 'normal' );
    	}
     }
    
    /**
     * MRP_load_admin_includes - Load admin javascript and css files for admin
     */
    function MRP_load_admin_includes() {
    	echo '<script type="text/javascript" src="'.get_option('siteurl').'/wp-content/plugins/microkids-related-posts/microkids-related-posts.js?v=4.0.1"></script>';
    	echo '<link rel="stylesheet" type="text/css" href="'.get_option('siteurl').'/wp-content/plugins/microkids-related-posts/microkids-related-posts-admin.css?v=4.0.1" />';
    }
    
    /**
     * MRP_load_default_css - Load default CSS styles for theme
     */
    function MRP_load_default_css() {
    	$options = get_option("MRP_options");
    	if($options['default_css'] == 1) {
    		echo '<link rel="stylesheet" type="text/css" href="'.WP_PLUGIN_URL.'/microkids-related-posts/microkids-related-posts-default.css" />';
    	}
    }
    
    /**
     * MRP_inner_custom_box - Load the insides
     */
    function MRP_inner_custom_box() {
    	global $post_ID;
    	$options = get_option("MRP_options");
    	$post_types = MRP_get_supported_post_types();
    	$order_class = ($options['order_type'] == 'manual') ? ' class="MRP_manual_order"' : '';
    	echo '<div id="MRP_relatedposts"'.$order_class.'>';
    	$n = 1;
    	echo '<div id="MRP_tabs">';
    	$related_posts = array();
    	# Create tabs
    	foreach($post_types as $post_type) {
    	    $related_posts[$post_type] = MRP_get_related_posts( $post_ID, 1, 0, $post_type );
    	    $ext = "-".$n;
    	    $post_type_details = array_shift(get_post_types(array('name' => $post_type), 'objects'));
    	    $current = ($n==1) ? ' MRP_current_tab' : '';
    	    $related_posts_count = count($related_posts[$post_type]);
    	    echo '<div class="MRP_tab'.$current.'"><a href="javascript:void(0)" rel="MRP_post_type'.$ext.'">'.__( $post_type_details->labels->name, 'microkids-related-posts' ).' (<span id="MRP_related_count'.$ext.'" class="MRP_related_count">'.$related_posts_count.'</span>)</a></div>';
    	    $n++;
    	}
    	echo '</div>';
    	$n = 1;
    	# Loop through post types and create form elements for each
    	foreach($post_types as $post_type) {
    	    $ext = "-".$n;
    	    $current = ($n==1) ? ' MRP_current' : '';
    	    echo '<div id="MRP_post_type'.$ext.'" class="MRP_post_type'.$current.'">';
    	    echo '<label id="MRP_relatedposts_list_label'.$ext.'" class="MRP_relatedposts_list_label">'.__( 'Related', 'microkids-related-posts' ).':</label>';
    		echo '<ul id="MRP_relatedposts_list'.$ext.'" class="MRP_relatedposts_list">';
    		if( $post_ID ) {
    			if( count($related_posts[$post_type]) > 0 ) {
    				foreach( $related_posts[$post_type] as $related_post ) {
    			        $post_title = MRP_truncate( $related_post->post_title, 80);
    					if( $related_post->post_status != 'publish' ) {
    						$post_title = $post_title . ' ('.$related_post->post_status.')';
    					}
    					echo '<li id="related-post_'.$related_post->ID.'"><span class="MPR_moovable"><strong>'.$post_title.' </strong> <span class="MRP_related_post_options"><a href="'.get_permalink( $related_post->ID ).'" title="View this post" class="MRP_view_post" target="_blank">&rsaquo;</a><a class="MRP_deletebtn" onclick="MRP_remove_relationship(\'related-post_'.$related_post->ID.'\')">X</a></span></span>';
    					echo '<input type="hidden" name="MRP_related_posts[MRP_post_type-'.$n.'][]" value="'.$related_post->ID.'" /></li>';
    				}
    			}
    			else {
    				echo '<li id="MRP_related_posts_replacement'.$ext.'" class="MRP_related_posts_replacement howto"><span>'.__( 'Use the search box below to select related items', 'microkids-related-posts' ).'</span></li>';
    			}
    		}
    		else {
    			echo '<li id="MRP_related_posts_replacement'.$ext.'" class="MRP_related_posts_replacement"><em>'.__( 'Use the search box below to select related items', 'microkids-related-posts' ).'</em></li>';
    		}
    		echo '</ul>';
    
            echo '<input type="hidden" name="MRP_post_type_name'.$ext.'" id="MRP_post_type_name'.$ext.'" value="'.$post_type.'"/>';
    		echo '<div id="MRP_add_related_posts'.$ext.'" class="MRP_add_related_posts"><label for="MRP_search" id="MRP_search_label'.$ext.'" class="MRP_search_label">'.__( 'Search items', 'microkids-related-posts' ).':</label> <input type="text" id="MRP_search'.$ext.'" class="MRP_search" name="MRP_search'.$ext.'" value="" size="16" />';
    		echo '<div id="MRP_scope'.$ext.'" class="MRP_scope"><label for="MRP_scope_1'.$ext.'"><input type="radio" name="MRP_scope'.$ext.'" id="MRP_scope_1'.$ext.'" class="MRP_scope_1" value="1"> '.__( 'Title', 'microkids-related-posts' ).'</label> <label for="MRP_scope_2'.$ext.'"><input type="radio" name="MRP_scope'.$ext.'" id="MRP_scope_2'.$ext.'" class="MRP_scope_2" value="2"> '.__( 'Content', 'microkids-related-posts' ).'</label> <label for="MRP_scope_3'.$ext.'"><input type="radio" name="MRP_scope'.$ext.'" id="MRP_scope_3'.$ext.'" class="MRP_scope_3" value="3" checked="checked"> <strong>'.__( 'Both', 'microkids-related-posts' ).'</strong></label></div>';
    		echo '<div id="MRP_loader'.$ext.'" class="MRP_loader">&nbsp;</div>';
    		echo '<div id="MRP_results'.$ext.'" class="ui-tabs-panel MRP_results"></div></div>';
    		echo '</div>';
    		$n++;
    	}
    	echo '<input type="hidden" name="MRP_noncename" id="MRP_noncename" value="'.wp_create_nonce( plugin_basename(__FILE__) ).'" />';
    	?>
    		<script type="text/javascript">
    		var MPR_CRs_count = <?php echo ($n-1); ?>;
     		</script>
    	<?php
    	echo '</div>';
    }
    
    /**
     * MRP_save_postdata - Prepare to save the selected relations
     *
     * @param int   $post_id - The id of the post being saved
     */
    function MRP_save_postdata( $post_id ) {
        if( !isset($_POST['MRP_noncename'])) {
            return $post_id;
        }
        if ( !wp_verify_nonce( $_POST['MRP_noncename'], plugin_basename(__FILE__) )) {
    		return $post_id;
    	}
    	if ( 'page' == $_POST['post_type'] ) {
    		if ( !current_user_can( 'edit_page', $post_id )) {
    			return $post_id;
    		}
    	}
    	else {
    		if ( !current_user_can( 'edit_post', $post_id ) ) {
    			return $post_id;
    		}
    	}
        # Do not create a relationship with the revisions and autosaves in WP 2.6
    	if( function_exists("wp_is_post_revision") ) {
    		if( wp_is_post_revision( $post_id ) || wp_is_post_autosave( $post_id ) ) {
    			return $post_id;
    		}
    	}
    	MRP_save_relationships( $post_id, $_POST['MRP_related_posts'] );
    }
    
    /**
     * MRP_save_relationships - Save the relations
     *
     * @param int   $post_id - The id of the post being saved
     * @param array $related_posts - A list of post_id's
     */
     function MRP_save_relationships( $post_id, $related_posts ) {
    	global $wpdb;
        # First delete the relationships that were there before
    	//MRP_delete_relationships( $post_id ); *FAMI*
        # Now add/update the relations
    	if( $related_posts ) {
    		$options = get_option("MRP_options");
    		if($options['display_reciprocal']) {
    			$query = "SELECT * FROM ".$wpdb->prefix."post_relationships WHERE post1_id=".$post_id." OR post2_id=".$post_id.";";
    			$existing_ones = $wpdb->get_results( $query );
    			$query="";
    			foreach($related_posts as $rel_cct_list){
    				$order_counter = 0;
    				foreach($rel_cct_list as $rel_post){
    					$not_updatable = true;
    					foreach($existing_ones AS $k=>$v){
    						if($rel_post == $v->post1_id OR $rel_post == $v->post2_id){
    							if($v->post1_id == $post_id){
    								$left_q = "post1_id=".$post_id;
    								$right_q = "post2_id=".$v->post2_id;
    								$relation_order = "position1=".$order_counter;
    							} else {
    								$left_q = "post1_id=".$v->post1_id; // *FAMI*
    								$right_q = "post2_id=".$post_id; // *FAMI*
    								$relation_order = "position2=".$order_counter;
    							}
    							$query = "UPDATE ".$wpdb->prefix."post_relationships SET $relation_order WHERE $left_q AND $right_q;";
    							$result = $wpdb->query( $query );
    							$existing_ones[$k]->remains = true;
    							$not_updatable = false;
    							break;
    						} else {
    							$not_updatable = true;
    						}
    					}
    					if($not_updatable){
    						$query = "INSERT INTO ".$wpdb->prefix."post_relationships VALUES ($post_id,$rel_post,$order_counter,0);";
    						$result = $wpdb->query( $query );
    					}
    					$order_counter++;
    				}
    			}
    			foreach($existing_ones AS $k=>$v){
    				if(!$v->remains){
    					if($v->post1_id==$post_id){
    						$side = "post1_id";
    						$post_in_relation = "post2_id=".$v->post2_id;
    					} else {
    						$side = "post2_id";
    						$post_in_relation = "post1_id=".$v->post1_id;
    					}
    					$query = "DELETE FROM ".$wpdb->prefix."post_relationships WHERE ".$side."=".$post_id." AND ".$post_in_relation.";";
    					$result = $wpdb->query( $query );
    				}
    			}
    		} else {
    			MRP_delete_relationships($post_id);
    			foreach( $related_posts as $related_post_sub_list ) {
    				$counter = 0;
    				foreach($related_post_sub_list AS $related_post){
    					$related_post = (int) $related_post;
    					$new_count = $counter++;
    					$query = "INSERT INTO ".$wpdb->prefix."post_relationships VALUES( $post_id, $related_post , $new_count, $new_count )";
    					//$query = "INSERT INTO ".$wpdb->prefix."post_relationships VALUES( $post_id, $related_post , 0, $new_count )";
    					$result = $wpdb->query( $query );
    				}
    			}
    
    		}
    	}
    }
    
    /**
     * MRP_delete_relationships - Delete all relationships for a post
     *
     * @param int   $post_id - The id of the post for which the relationships are deleted
     */
     function MRP_delete_relationships( $post_id ) {
    	global $wpdb;
    	$options = get_option("MRP_options");
    	if($options['display_reciprocal']) {
    		$query = "DELETE FROM ".$wpdb->prefix."post_relationships WHERE post1_id = $post_id OR post2_id = $post_id";
    	}
    	else {
    		$query = "DELETE FROM ".$wpdb->prefix."post_relationships WHERE post1_id = $post_id";
    	}
    	$delete = $wpdb->query( $query );
    }
    
    /**
     * MRP_get_related_posts - Get the related posts for a post
     *
     * @param int       $post_id - The id of the post
     * @param bool      $return_object - Whether to return the related posts as an object
     *                  If false it will return the posts as an array $related_posts[related_post_id] => related_post_title
     * @param bool      $hide_unpublished - When false drafts will be included
     * @param string    $post_type - The post type of the related posts to return i.e. post, page, or any custom post types
     *                  When null all post types will be returned
    */
    function MRP_get_related_posts( $post_id, $return_object = false, $hide_unpublished = true, $post_type = null ) {
    	global $wpdb;
    	$options = get_option("MRP_options");
    	$post_status = array( "'publish'" );
    	# Display private posts for users with the correct permissions
    	if( current_user_can( "read_private_posts" ) ) {
    		$post_status[] = "'private'";
    	}
    	# Generate order SQL based on plugin settings
    	$order = " ORDER BY ";
    	if($options['order_type'] == "manual") {
    	    $order .= " <code>position_unified</code> ASC, <code>post_date</code> ASC "; //sort by date related items inside all posts with unspecified ordering
    	}
    	else {
        	switch( $options['order'] ) {
        	    case 'random' :
        	        $order .= " RAND() ";
        	    break;
        	    case 'date_asc' :
        	        $order .= " post_date ASC ";
        	    break;
        	    case 'title_desc' :
        	        $order .= " post_title DESC ";
        	    break;
        	    case 'title_asc' :
        	        $order .= " post_title ASC ";
        	    break;
        	    default: // date_desc
        	        $order .= " post_date DESC ";
        	    break;
    
        	}
        }
    	if($options['display_reciprocal']) {
    		# Reciprocal query by Peter Raganitsch @ http://blog.oracleapex.at)
    		$query = "
    		SELECT * FROM (
    		SELECT position1 as position_unified, wp.*, wpr.* ".
    			"FROM ".$wpdb->prefix."post_relationships	wpr ".
    			",".$wpdb->prefix."posts					wp ".
    			"WHERE wpr.post1_id = $post_id ".
    			"AND wp.id = wpr.post2_id ";
    		# Hide unpublished?
    		if( $hide_unpublished ) {
    			$query .= " AND wp.post_status IN (".implode( ",", $post_status ).") ";
    		}
    		# Show only specified post type?
    		if( isset( $post_type ) ) {
    		    if( is_array( $post_type ) ) {
    		        $query .= " AND wp.post_type IN (".implode( ",", $post_type ).") ";
    		    }
    		    else {
    		        $query .= " AND wp.post_type = '$post_type' ";
    		    }
    		}
    		//$query .= $order;
    		$query .= ") AS tab1 UNION ALL ".
    			"SELECT * FROM (".
    			"SELECT position2 as position_unified, wp.*, wpr.* ".
    			"FROM ".$wpdb->prefix."post_relationships	wpr ".
    			",".$wpdb->prefix."posts					wp ".
    			"WHERE wpr.post2_id = $post_id ".
    			"AND wp.id = wpr.post1_id ";
    		# Hide unpublished?
    		if( $hide_unpublished ) {
    			$query .= "AND wp.post_status IN (".implode( ",", $post_status ).") ";
    		}
    		# Show only specified post type?
    		if( isset( $post_type ) ) {
    		    if( is_array( $post_type ) ) {
    		        $query .= " AND wp.post_type IN (".implode( ",", $post_type ).") ";
    		    }
    		    else {
    		        $query .= " AND wp.post_type = '$post_type' ";
    		    }
    		}
    		$query.= ") AS tab2";
    		# Add order SQL
    		$query .= $order;
    		//echo $query;die();
    	}
    	# Not reciprocal
    	else {
    		$query = "SELECT *, position1 AS position_unified ".
    			"FROM ".$wpdb->prefix."post_relationships	wpr ".
    			" JOIN ".$wpdb->prefix."posts				wp ".
    			"	ON wpr.post2_id = wp.ID ".
    			"WHERE wpr.post1_id = $post_id";
    		# Hide unpublished?
    		if( $hide_unpublished) {
    			$query .= " AND wp.post_status IN (".implode( ",", $post_status ).") ";
    		}
    		# Show only specified post type?
    		if( isset( $post_type ) ) {
    		    if( is_array( $post_type ) ) {
    		        $query .= " AND wp.post_type IN (".implode( ",", $post_type ).") ";
    		    }
    		    else {
    		        $query .= " AND wp.post_type = '$post_type' ";
    		    }
    		}
    		$query .= $order;
    	}
        # Run query
    	$results = $wpdb->get_results( $query );
    	if( $results ) {
    		if( $return_object ) {
    		    # Return the complete results set as an object
    			return $results;
    		}
    		else {
    		    # Create array (legacy)
    			$related_posts = array();
    			foreach( $results as $result ) {
    				$related_posts[$result->ID] = $result->post_title;
    			}
    			return $related_posts;
    		}
    	}
    	return null;
    }
    
    /**
    * MRP_ajax_listener - Listen for AJAX call from search box
    */
    function MRP_ajax_listener() {
        if( is_admin() && isset( $_GET['mrp_s'] ) ) {
            MRP_ajax_search_results();
            exit;
        }
        return;
    }
    
    /**
    * MRP_ajax_search_results - Display AJAX search results
    *
    */
    function MRP_ajax_search_results() {
    	global $wpdb;
    	$s = $wpdb->escape( rawurldecode( $_GET['mrp_s'] ) );
    	$scope = (int) $_GET['mrp_scope'];
    	$post_type = $wpdb->escape( $_GET['mrp_post_type'] );
    	$regexp = "[[:<:]]" . $s;
    	$where = "";
    	switch( $scope ) {
    		case 1 :
    			$where = "post_title REGEXP '$regexp'";
    			break;
    		case 2 :
    			$where = "post_content REGEXP '$regexp'";
    			break;
    		default :
    			$where = "( post_title REGEXP '$regexp' OR post_content REGEXP '$regexp' )";
    			break;
    	}
    	$query = "SELECT ID, post_title, post_type, post_status FROM $wpdb->posts WHERE $where AND post_type = '$post_type' ";
    	if( $_GET['mrp_id'] ) {
    		$this_id = (int) $_GET['mrp_id'];
    		$query .= " AND ID != $this_id ";
    	}
    	$query .= " AND post_status NOT IN ('inherit', 'auto-draft')";
    	$query .= " ORDER BY post_date DESC LIMIT 50";
    	$results = $wpdb->get_results( $query );
    	if( $results ) {
    	    echo "<ul>";
    		$n = 1;
    		foreach( $results as $result ) {
    			echo '<li';
    			echo ( $n % 2 ) ? ' class="alt"' : '';
    			echo '> <a href="javascript:void(0)" id="result-'.$result->ID.'" class="MRP_result">';
        		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++;
    		}
    		echo "</ul>";
        }
    }
    
    /**
     * MRP_show_related_posts - Display the related posts for the current post
     */
    function MRP_show_related_posts() {
    	global $post;
    	if( $post ) {
    		echo MRP_get_related_posts_html( $post->ID );
    	}
    }
    
    /**
     * MRP_auto_related_posts - Called by the_content filter, automatically add the
     *                          related posts at the bottom of the content
     *
     * @param string    $content - The text/content of the post
     */
    function MRP_auto_related_posts( $content ) {
    	if( is_single() || is_page() ) {
    		$options = get_option("MRP_options");
    		if( $options['display_auto'] ) {
    			global $post;
    			if( $post ) {
    				$related_posts_html = MRP_get_related_posts_html( $post->ID );
    			}
    			$content .= $related_posts_html;
    		}
    	}
    	return $content;
    }
    
    /**
     * MRP_get_related_posts_html - Generate the related posts HTML for a post and return it as a string
     *
     * @param int       $post_id - The id of the post
     * @param bool      $hide_unpublished - When false drafts will be included
     * @param string    $post_type - The post type of the related posts to return i.e. post, page, or any custom post types
     *                  When null all post types will be returned
     */
    function MRP_get_related_posts_html( $post_id, $hide_unpublished = true, $post_type = null ) {
        # Get plugin settings
        $options = get_option("MRP_options");
        # Get the supported post types (selected in plugin settings)
    	$supported_post_types = MRP_get_supported_post_types();
    	if(!$supported_post_types) {
    	    return false;
    	}
    	$related_posts = array();
    	# If only related posts for specified post type are needed
    	if( isset( $post_type ) ) {
    	    $related_posts[$post_type] = MRP_get_related_posts( $post_id, true, $hide_unpublished, $post_type );
    	}
    	# If we need related posts from all post types
    	else {
    	    # First get the entire set of related posts for all post types
    	    $all_related_posts = MRP_get_related_posts( $post_id, true, $hide_unpublished, null );
    	    # If related posts should be displayed as one list
    	    if( $options['combine_post_types'] == 1 ) {
                $related_posts['MRP_all'] = $all_related_posts;
    		}
    		# If related posts should be grouped by post types
    		else {
    		    if( $all_related_posts ) {
    		        foreach( $all_related_posts as $related_post ) {
                        $related_posts[$related_post->post_type][] = $related_post;
    		        }
    		    }
    		}
    	}
    	# Start HTML output
    	$output = "<div class=\"related-posts\">\n";
    	# Loop through different post types
        foreach( $related_posts as $post_type => $post_type_related_posts ) {
            # This filters %posttype% from the title
            $title = MRP_get_title( __($options['title'], 'microkids-related-posts'), $post_type );
            if( count( $post_type_related_posts ) ) {
    			$output .= "<div id=\"related-posts-$post_type\" class=\"related-posts-type\">\n";
    			# Create the title with the selected HTML header
    			$output .= "<".$options['header_element'].">".$title."</".$options['header_element'].">\n";
    			$output .= "<ul>\n";
    			# Add related posts
    			foreach( $post_type_related_posts as $related_post ) {
    				$output .= "<li>";
    				if($options['show_thumbnails'] && has_post_thumbnail($related_post->ID)) {
    				    $output .= "<a href=\"".get_permalink($related_post->ID)."\">";
    				    $output .= get_the_post_thumbnail($related_post->ID, $options['thumbnail_size']);
    				    $output .= "</a>";
    				}
    				$output .= "<a href=\"".get_permalink( $related_post->ID )."\">".$related_post->post_title."</a>";
    				$output .= "</li>\n";
    			}
    			$output .= "</ul></div>\n";
    	    }
    	    # If there are no related posts for this post type
    	    else {
    			if( !$options['hide_if_empty'] ) {
    			    $output .= "<div id=\"related-posts-$post_type\" class=\"related-posts-type\">\n";
    				$output .= "<".$options['header_element'].">".$title."</".$options['header_element'].">\n";
    				$output .= "<p>".$options['text_if_empty']."</p>\n";
    				$output .= "</div>";
    			}
    			else {
    			    # Show nothing
    			    return "";
    			}
    		}
    	}
    	$output .= "</div>";
    	return $output;
    }
    
    /**
     * MRP_get_title - Replaces %posttype% from the title with the name/label of the post type
     *
     * @param string    $title - The title as set on the plugin options page
     * @param string    $post_type_name - The name/label of the post type
     */
    function MRP_get_title( $title, $post_type_name = null ) {
        if( $post_type_name != 'MRP_all' ) {
            $post_type = array_shift( get_post_types( array( 'name' => $post_type_name ), 'object' ) );
            $title = str_replace( '%posttype%', __( $post_type->label, 'microkids-related-posts' ), $title );
        }
        else {
            $title = str_replace( '%posttype%', __( 'Posts' ), $title );
        }
        return $title;
    }
    
    /**
     * MRP_shortcode - Add [related-post] shortcode support through standard Worpress API
     *
     * @param array    $atts - An array of attributes given to the shortcode i.e. [related-posts posttype=page]
     */
    function MRP_shortcode( $atts ) {
    	global $post;
    	$post_type = null;
    	if( $post->ID ) {
    	    if( $atts ) {
    	        $post_type = esc_attr( $atts['posttype'] );
    	    }
    		return MRP_get_related_posts_html( $post->ID, true, $post_type );
    	}
    }
    
    /**
     * MRP_load_widget - Register the Related Posts widget
     */
    function MRP_load_widget() {
    	register_widget("wp_widget_related_posts");
    }
    
    /**
     * MRP_add_options_page - Generate the options page
     */
    function MRP_add_options_page() {
    	add_options_page("Settings for Microkid's Related Posts", "Related Posts", "manage_options", __FILE__, "MRP_options_page");
    }
    
    /**
     * MRP_get_supported_post_types - Get the post types that can display and be related posts
     *                                Thanks to Michael Girouard at Migimedia for contributing
     *
     * @param bool  $details -  Whether to return the entire object for each post type,
     *                          if false only an array of names will be returned
     */
    function MRP_get_supported_post_types($details = false) {
        $options = get_option('MRP_options');
        $post_types = explode(',', $options['post_types']);
        if (false === $details) {
            return $post_types;
        }
        $details = array();
        foreach ($post_types as $post_type) {
            $post_type_details = get_post_types(array('name' => $post_type), 'object');
            $details[$post_type] = $post_type_details[$post_type];
        }
        return $details;
    }
    
    /**
     * MRP_options_page - Generate the plugin options page
     *                    Thanks to Michael Girouard at Migimedia for contributing
     */
    function MRP_options_page() {
        # Get current options
    	$options = get_option('MRP_options');
    	# Save new settings
    	if( isset( $_POST['MRP_options_submit'] ) ) {
    	    if( ! empty($_POST['MRP_custom_post_types'] ) ) {
    	        $_POST['MRP_custom_post_types'] = array_map( 'trim', $_POST['MRP_custom_post_types'] );
                $_POST['MRP_custom_post_types'] = implode( ',', $_POST['MRP_custom_post_types'] );
    	    }
    	    # Create array with new settings
    	    $new_options = array();
    		$new_options['display_auto'] = (int) $_POST['MRP_display_auto'];
    		$new_options['display_reciprocal'] = (int) $_POST['MRP_display_reciprocal'];
    		$new_options['title'] = esc_attr( $_POST['MRP_title'] );
    		$new_options['header_element'] = esc_attr( $_POST['MRP_header_element'] );
    		$new_options['hide_if_empty'] = (int) $_POST['MRP_hide_if_empty'];
    
    		if(isset($_POST['MRP_show_thumbnails']) && $_POST['MRP_show_thumbnails'] == 1) {
    		    $new_options['show_thumbnails'] = 1;
    		    $new_options['thumbnail_size'] = esc_attr($_POST['MRP_thumbnail_size']);
    		}
    		else {
    			$new_options['show_thumbnails'] = 0;
    		}
    
    		$new_options['default_css'] = (int) $_POST['MRP_default_css'];
    
    		if($_POST['MRP_order_type'] == "manual") {
    		    $new_options['order_type'] = "manual";
    		}
    		else {
    	        $new_options['order_type'] = "auto";
    	        $new_options['order'] = $_POST['MRP_order'];
    		}
    
    		if( isset($_POST['MRP_custom_post_types'])) {
                $new_options['post_types'] = esc_attr( $_POST['MRP_custom_post_types'] );
            }
            else {
                $new_options['post_types'] = "";
            }
    		if( isset( $_POST['MRP_text_if_empty'] ) ) {
    			$new_options['text_if_empty'] = esc_attr( $_POST['MRP_text_if_empty'] );
    		}
    		else {
    			$new_options['text_if_empty'] = $options['text_if_empty'];
    		}
    		$new_options['combine_post_types'] = (int) $_POST['MRP_combine'];
    		$new_options['hide_donate'] = $options['hide_donate'];
    		# Save options in wp_options tabl
    		update_option('MRP_options', $new_options);
    		$options = $new_options;
    		echo '<div id="message" class="updated fade"><p><strong>'.__( 'Settings saved', 'microkids-related-posts' ).'</strong></div>';
    	}
    	# Hide the donation message
    	elseif( isset($_GET['hide_donate'] ) ) {
    	    $new_options = $options;
    	    $new_options['hide_donate'] = 1;
    	    update_option( 'MRP_options', $new_options );
    	    echo '<div id="message" class="updated fade"><p><strong>'.__( 'Donation message hidden', 'microkids-related-posts' ).'</strong></div>';
    	}
    ?>
    <script type="text/javascript">
    function MRP_disable_empty_text() {
    	document.getElementById('MRP_text_if_empty').disabled = ( document.getElementById('MRP_hide_if_empty_true').checked ) ? "disabled" : "";
    }
    </script>
    <div class="wrap">
        <h2><?php _e( 'Related posts settings', 'microkids-related-posts' ); ?></h2>
        <form method="post" action="options-general.php?page=microkids-related-posts/microkids-related-posts.php">
            <input type="hidden" id="_wpnonce" name="_wpnonce" value="abcab64052" />
            <p><?php printf( __('These settings let you customize the presentation of the list of related posts. If you\'re using a theme that supports it, you can also use the Related Posts <a%s>widget</a>.', 'microkids-related-posts' ), ' href="widgets.php"' ); ?></p>
            <table class="form-table">
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Display related posts automatically underneath the post content?', 'microkids-related-posts' ); ?></th>
                <td>
                	<input name="MRP_display_auto" type="radio" id="MRP_display_true" value="1"<?php if( $options['display_auto'] ) : ?> checked="checked"<?php endif; ?> /> <label for="MRP_display_true"><?php _e( 'Yes', 'microkids-related-posts' ); ?></label><br/>
                	<input name="MRP_display_auto" type="radio" id="MRP_display_false" value="0"<?php if( !$options['display_auto'] ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_display_false"><?php _e( 'No, I will use the widget, the shortcode or implement the necessary PHP code in my theme file(s).', 'microkids-related-posts' ); ?></label>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Should related posts be reciprocal? If so, the link will appear on both pages. If not, it will only appear on the post/page where it was selected.', 'microkids-related-posts' ); ?></th>
                <td>
                	<input name="MRP_display_reciprocal" type="radio" id="MRP_reciprocal_true" value="1"<?php if( $options['display_reciprocal'] ) : ?> checked="checked"<?php endif; ?> /> <label for="MRP_reciprocal_true"><?php _e( 'Yes, include the link on both pages', 'microkids-related-posts' ); ?></label><br/>
                	<input name="MRP_display_reciprocal" type="radio" id="MRP_reciprocal_false" value="0"<?php if( !$options['display_reciprocal'] ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_reciprocal_false"><?php _e( 'No, only show the link on one page', 'microkids-related-posts' ); ?></label>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'What title should be displayed?', 'microkids-related-posts' ); ?></th>
                <td>
                	<input name="MRP_title" type="text" id="MRP_title" value="<?php echo $options['title']?>" />
                	<div style="margin: 10px 0 10px 0;">
                    	<label for="MRP_header_element"><?php _e( 'Using HTML header element' , 'microkids-related-posts'); ?>: </label>
                		<select name="MRP_header_element" id="MRP_header_element" style="font-size: 80%">
                			<option value="h1" <?php if( $options['header_element'] == 'h1' ) : ?>selected="selected"<?php endif; ?>><h1></option>
                			<option value="h2" <?php if( $options['header_element'] == 'h2' ) : ?>selected="selected"<?php endif; ?>><h2></option>
                			<option value="h3" <?php if( $options['header_element'] == 'h3' ) : ?>selected="selected"<?php endif; ?>><h3></option>
                			<option value="h4" <?php if( $options['header_element'] == 'h4' ) : ?>selected="selected"<?php endif; ?>><h4></option>
                			<option value="h5" <?php if( $options['header_element'] == 'h5' ) : ?>selected="selected"<?php endif; ?>><h5></option>
                			<option value="h6" <?php if( $options['header_element'] == 'h6' ) : ?>selected="selected"<?php endif; ?>><h6></option>
                		</select>
                    </div>
                	<p class="MRP_help"><?php _e( '<strong>Note:</strong> if you choose to display different post types as seperate lists, you can place <strong>%posttype%</strong> in the title to display the label of the post type.', 'microkids-related-posts' ); ?></p>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'What should be displayed when there are no related posts?', 'microkids-related-posts' ); ?></th>
                <td>
                	<input name="MRP_hide_if_empty" type="radio" id="MRP_hide_if_empty_true" value="1"<?php if( $options['hide_if_empty'] ) : ?>checked="checked"<?php endif; ?> onclick="MRP_disable_empty_text()" /> <label for="MRP_hide_if_empty_true" onclick="MRP_disable_empty_text()"><?php _e( 'Nothing', 'microkids-related-posts' ); ?></label><br/>
            		<input name="MRP_hide_if_empty" type="radio" id="MRP_hide_if_empty_false" value="0"<?php if( !$options['hide_if_empty'] ) : ?>checked="checked"<?php endif; ?> onclick="MRP_disable_empty_text()" /> <label for="MRP_hide_if_empty_false" onclick="MRP_disable_empty_text()"><?php _e( 'Show this text', 'microkids-related-posts' ); ?>:</label>
            		<input type="text" name="MRP_text_if_empty" id="MRP_text_if_empty" value="<?php echo $options['text_if_empty']; ?>" <?php if( $options['hide_if_empty'] ) : ?>disabled="disabled"<?php endif; ?> style="width:250px;" />
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Would you like to display thumbnails with your related posts?', 'microkids-related-posts' ); ?></th>
                <td>
                    <?php if(current_theme_supports('post-thumbnails')) : ?>
                        <input name="MRP_show_thumbnails" type="radio" id="MRP_show_thumbnails_true" value="1"<?php if( $options['show_thumbnails'] ) : ?>checked="checked"<?php endif; ?> onclick="MRP_disable_empty_text()" /> <label for="MRP_show_thumbnails_true"><?php _e( 'Yes, display thumbnails with this size:', 'microkids-related-posts' ); ?></label>
                        <select name="MRP_thumbnail_size">
                            <?php global $_wp_additional_image_sizes; foreach ($_wp_additional_image_sizes as $size_name => $size_attrs): ?>
                                <option value="<?php echo $size_name ?>"<?php if($options['thumbnail_size'] == $size_name) : ?>selected="selected"<?php endif ?>><?php echo $size_name ?> (<?php echo $size_attrs['width'] ?> x <?php echo $size_attrs['height'] ?>)</option>
                            <?php endforeach; ?>
                        </select>
                        <br/>
                		<input name="MRP_show_thumbnails" type="radio" id="MRP_show_thumbnails_false" value="0"<?php if( !$options['show_thumbnails'] ) : ?>checked="checked"<?php endif; ?> onclick="MRP_disable_empty_text()" /> <label for="MRP_show_thumbnails_false"><?php _e( 'No', 'microkids-related-posts' ); ?></label>
                		<p class="MRP_help"><?php _e( sprintf('<strong>Note:</strong> You can only select sizes that are supported by your theme. See the <a href="%s">WordPress Codex</a> on how to add thumbnail sizes.', 'http://codex.wordpress.org/Function_Reference/add_image_size'), 'microkids-related-posts' ); ?></p>
                	<?php else : ?>
                	    <p class="MRP_thumbnails_no_support"><?php _e(sprintf('Thumbnails are not supported by current theme. Please check <a href="%s">the WordPress Codex</a> for more information about activating thumbnail support.', 'http://codex.wordpress.org/Post_Thumbnails'), 'microkids-related-posts');?>
                	<?php endif; ?>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Would you like to use the default CSS provided for some basic styling of your related posts?', 'microkids-related-posts' ); ?></th>
                <td>
                	<input name="MRP_default_css" type="radio" id="MRP_default_css_true" value="1"<?php if( $options['default_css'] ) : ?> checked="checked"<?php endif; ?> /> <label for="MRP_default_css_true"><?php _e( 'Yes, load the default CSS file', 'microkids-related-posts' ); ?></label><br/>
                	<input name="MRP_default_css" type="radio" id="MRP_default_css_false" value="0"<?php if( !$options['default_css'] ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_default_css_false"><?php _e( 'No, I will add my own CSS styles', 'microkids-related-posts' ); ?></label>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'How would you like to order your related posts?', 'microkids-related-posts' ); ?></th>
                <td>
            		<input name="MRP_order_type" type="radio" id="MRP_order_type_manual" value="manual"<?php if( $options['order_type'] == "manual" ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_order_type_manual"><?php _e( 'Manually', 'microkids-related-posts' ); ?></label>
                    <br/>
                    <input name="MRP_order_type" type="radio" id="MRP_order_type_auto" value="auto"<?php if( $options['order_type'] == "auto" ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_order_type_auto"><?php _e( 'Automatically', 'microkids-related-posts' ); ?> </label>
        		    <select name="MRP_order" id="MRP_order">
                	    <option value="date_desc"<?php if($options['order'] == 'date_desc') : ?> selected="selected"<?php endif; ?>><?php _e( 'by date, new to old', 'microkids-related-posts' ); ?></option>
            	        <option value="date_asc"<?php if($options['order'] == 'date_asc') : ?> selected="selected"<?php endif; ?>><?php _e( 'by date, old to new', 'microkids-related-posts' ); ?></option>
            	        <option value="title_asc"<?php if($options['order'] == 'title_asc') : ?> selected="selected"<?php endif; ?>><?php _e( 'alphabetically A→Z', 'microkids-related-posts' ); ?></option>
            	        <option value="title_desc"<?php if($options['order'] == 'title_desc') : ?> selected="selected"<?php endif; ?>><?php _e( 'alphabetically Z→A', 'microkids-related-posts' ); ?></option>
            	        <option value="random"<?php if($options['order'] == 'random') : ?> selected="selected"<?php endif; ?>><?php _e( 'randomly', 'microkids-related-posts' ); ?></option>
            	    <select>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Which post types can have related items?', 'microkids-related-posts' ); ?></th>
                <td>
                    <?php $registered_post_types = explode(',', $options['post_types']) ?>
                    <?php /* Builtin Post types */ ?>
                    <input <?php if (in_array('post', $registered_post_types)): ?>checked="checked"<?php endif ?> type="checkbox" name="MRP_custom_post_types[]" value="post" id="MRP_custom_type-post" />
                    <label for="MRP_custom_type-post"><?php _e('Posts'); ?></label><br/>
    
                    <input <?php if (in_array('page', $registered_post_types)): ?>checked="checked"<?php endif ?> type="checkbox" name="MRP_custom_post_types[]" value="page" id="MRP_custom_type-page" />
                    <label for="MRP_custom_type-page"><?php _e('Pages'); ?></label><br/>
    
                    <?php foreach (get_post_types(array('_builtin' => false), 'object') as $post_type => $details): ?>
                        <input <?php if (in_array($post_type, $registered_post_types)): ?>checked="checked"<?php endif ?> type="checkbox" name="MRP_custom_post_types[]" value="<?php echo $post_type ?>" id="MRP_custom_type-<?php echo $post_type ?>" />
                        <label for="MRP_custom_type-<?php echo $post_type ?>"><?php echo $details->label ?></label><br/>
                    <?php endforeach ?>
                </td>
            </tr>
            <tr valign="top">
                <th scope="row" style="width:300px;"><?php _e( 'Would you like to display different post types as seperate lists or combine them into one related posts list?', 'microkids-related-posts' ); ?></th>
                <td>
                    <input name="MRP_combine" type="radio" id="MRP_combine_false" value="0"<?php if( !$options['combine_post_types'] ) : ?> checked="checked"<?php endif; ?> /> <label for="MRP_combine_false"><?php _e( 'Display as seperate lists', 'microkids-related-posts' ); ?></label><br/>
                	<input name="MRP_combine" type="radio" id="MRP_combine_true" value="1"<?php if( $options['combine_post_types'] ) : ?>checked="checked"<?php endif; ?> /> <label for="MRP_combine_true"><?php _e( 'Combine into one list', 'microkids-related-posts' ); ?></label>
                </td>
            </tr>
            </table>
            <p class="submit">
                <input name="MRP_options_submit" class="button-primary" value="<?php _e( 'Save Changes', 'microkids-related-posts' ); ?>" type="submit" />
            </p>
            <p><small><?php printf( __('Note: If you need even more customization options, there are several <a%s>API functions</a> available.', 'microkids-related-posts', 'microkids-related-posts' ), ' href="http://www.microkid.net/wordpress/related-posts/#API" target="_blank"'); ?></small></p>
    
        </form>
        <?php if( ! isset( $options['hide_donate'] ) && ! isset( $_GET['hide_donate'] ) ) : ?>
        <div id="donate" class="extra" style="-moz-border-radius: 4px;-webkit-border-radius: 4px;border-radius: 4px;margin: 0 0 2em 0; background: #eee; font-size: 11px;padding: 10px; float: left">
            <h3 style="margin: 0 0 1em 0"><?php _e( 'Donate!', 'microkids-related-posts' ); ?></h3>
    		<p><?php _e( 'Has this plugin saved your day? Are you using it for a commercial project? Cool! But please consider a donation for my work:', 'microkids-related-posts' ); ?></p>
    		<form action="http://www.paypal.com/cgi-bin/webscr" method="post"><input id="cmd" name="cmd" value="_donations" type="hidden" style="float: left; margin: 0 0 1em 0;">
    		    <div style="width: 70%;float: left;">
        		    <p class="donate_amount">
            		<select name="amount" id="amount" style="float: left;">
            			<option value="10">€ 10</option>
            			<option value="25">€ 25</option>
            			<option value="50">€ 50</option>
            			<option value="100">€ 100</option>
            			<option value="250">€ 250</option>
            		</select>
            		<input src="https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif" name="submit" alt="" border="0" type="image" style="float: left; margin: 0 0 0 4px">
            		<img alt="" src="https://www.paypal.com/en_US/i/scr/pixel.gif" border="0" width="1" height="1">
            		</p>
            		<input name="notify_url" value="http://www.microkid.net/wp-content/plugins/donate-plus/paypal.php" type="hidden">
            		<input name="item_name" value="Has my work helped you out? Please consider a donation!" type="hidden">
            		<input name="business" value="bastiaanvandreunen@gmail.com" type="hidden">
            		<input name="lc" value="US" type="hidden">
            		<input name="no_note" value="1" type="hidden">
            		<input name="no_shipping" value="1" type="hidden">
            		<input name="rm" value="1" type="hidden">
            		<input name="return" value="http://www.microkid.net/thank-you/" type="hidden">
            		<input name="currency_code" value="EUR" type="hidden">
            		<input name="bn" value="PP-DonationsBF:btn_donateCC_LG.gif:NonHosted" type="hidden">
            	</div>
        		<div style="float: right; text-align: right; font-size: 11px;width: 25%; padding: 20px 0 0 0"><a href="options-general.php?page=microkids-related-posts/microkids-related-posts.php&hide_donate=1"><?php _e('Hide this message', 'microkids-related-posts' ); ?></a></div>
    		</form>
    	</div>
    	<?php endif; ?>
    </div>
    <?php
    }
    
    /**
     * MRP_truncate- Truncates text.
     *
     * Cuts a string to the length of $length and replaces the last characters
     * with the ending if the text is longer than length.
     *
     * http://dodona.wordpress.com/2009/04/05/how-do-i-truncate-an-html-string-without-breaking-the-html-code/
     *
     * @param string  $text String to truncate.
     * @param integer $length Length of returned string, including ellipsis.
     * @param string  $ending Ending to be appended to the trimmed string.
     * @param boolean $exact If false, $text will not be cut mid-word
     * @param boolean $considerHtml If true, HTML tags would be handled correctly
     * @return string Trimmed string.
     */
    function MRP_truncate($text, $length = 100, $ending = '...', $exact = true, $considerHtml = false) {
        if ($considerHtml) {
            // if the plain text is shorter than the maximum length, return the whole text
            if (strlen(preg_replace('/<.*?>/', '', $text)) <= $length) {
                return $text;
            }
            // splits all html-tags to scanable lines
            preg_match_all('/(<.+?>)?([^<>]*)/s', $text, $lines, PREG_SET_ORDER);
            $total_length = strlen($ending);
            $open_tags = array();
            $truncate = '';
            foreach ($lines as $line_matchings) {
                // if there is any html-tag in this line, handle it and add it (uncounted) to the output
                if (!empty($line_matchings[1])) {
                    // if it's an "empty element" with or without xhtml-conform closing slash (f.e. <br/>)
                    if (preg_match('/^<(\s*.+?\/\s*|\s*(img|br|input|hr|area|base|basefont|col|frame|isindex|link|meta|param)(\s.+?)?)>$/is', $line_matchings[1])) {
                        // do nothing
                    // if tag is a closing tag (f.e. </b>)
                    } else if (preg_match('/^<\s*\/([^\s]+?)\s*>$/s', $line_matchings[1], $tag_matchings)) {
                        // delete tag from $open_tags list
                        $pos = array_search($tag_matchings[1], $open_tags);
                        if ($pos !== false) {
                            unset($open_tags[$pos]);
                        }
                    // if tag is an opening tag (f.e. <b>)
                    } else if (preg_match('/^<\s*([^\s>!]+).*?>$/s', $line_matchings[1], $tag_matchings)) {
                        // add tag to the beginning of $open_tags list
                        array_unshift($open_tags, strtolower($tag_matchings[1]));
                    }
                    // add html-tag to $truncate'd text
                    $truncate .= $line_matchings[1];
                }
                // calculate the length of the plain text part of the line; handle entities as one character
                $content_length = strlen(preg_replace('/&[0-9a-z]{2,8};|&#[0-9]{1,7};|[0-9a-f]{1,6};/i', ' ', $line_matchings[2]));
                if ($total_length+$content_length> $length) {
                    // the number of characters which are left
                    $left = $length - $total_length;
                    $entities_length = 0;
                    // search for html entities
                    if (preg_match_all('/&[0-9a-z]{2,8};|&#[0-9]{1,7};|[0-9a-f]{1,6};/i', $line_matchings[2], $entities, PREG_OFFSET_CAPTURE)) {
                        // calculate the real length of all entities in the legal range
                        foreach ($entities[0] as $entity) {
                            if ($entity[1]+1-$entities_length <= $left) {
                                $left--;
                                $entities_length += strlen($entity[0]);
                            } else {
                                // no more characters left
                                break;
                            }
                        }
                    }
                    $truncate .= substr($line_matchings[2], 0, $left+$entities_length);
                    // maximum lenght is reached, so get off the loop
                    break;
                } else {
                    $truncate .= $line_matchings[2];
                    $total_length += $content_length;
                }
                // if the maximum length is reached, get off the loop
                if($total_length>= $length) {
                    break;
                }
            }
        } else {
            if (strlen($text) <= $length) {
                return $text;
            } else {
                $truncate = substr($text, 0, $length - strlen($ending));
            }
        }
        // if the words shouldn't be cut in the middle...
        if (!$exact) {
            // ...search the last occurance of a space...
            $spacepos = strrpos($truncate, ' ');
            if (isset($spacepos)) {
                // ...and cut the text in this position
                $truncate = substr($truncate, 0, $spacepos);
            }
        }
        // add the defined ending to the text
        $truncate .= $ending;
        if($considerHtml) {
            // close all unclosed html-tags
            foreach ($open_tags as $tag) {
                $truncate .= '</' . $tag . '>';
            }
        }
        return $truncate;
    }
    ?>

    This still didn’t seem to work for me. I replaced the code in that file with what you have above, and now instead of just not saving the order I placed them in it deletes all items once saved.

    sleim – that seems to work so thanks for saving my skin!

    Not sure how it keeps getting updated out of the plugin though as i had this exact problem just before a launch last year…

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘FIX – Bad Order’ is closed to new replies.