';print_r($result);
						if( empty($result[0]->the_post_id) )
						{
							$TREE .= "    post."?\"; type=\"button\" value=\" - \" style=\"cursor:pointer;\" onclick=\"document.getElementById('ask_del_$i$j$k$c').style.display='block';\">  ";			
							$TREE .= $res->post;
							$TREE .= " Are you sure you want to delete the relation ".$parent_post."-".$res->post."? post."');\"> ";				
						}
					}
					$k++;
				}
				
		       	customPostTypeTree::tree($res->post, $children);
		       	$j++;
		    }
		}
	}
	
	public static function del( $parent_post, $post )
	{
		$WHERE = " WHERE ";
		
		if( !empty($parent_post) )
		{
			$WHERE .= "parent_post='$parent_post' ";
		}
		
		if( !empty($post) )
		{
			$WHERE .= "AND post='$post' ";
		}

		$del = customPostTypeTree::$wpdb->query("DELETE FROM ".customPostTypeTree::$wpdb->prefix."custom_post_type_tree $WHERE" );
		if( $del )
			return true;
			
		return false;
	}

	
	// This function adds a meta box with a callback function of my_metabox_callback()
	public static function setMetaBoxes( $post ) 
	{
		$sql = "SELECT post FROM ".customPostTypeTree::$wpdb->prefix."custom_post_type_tree WHERE parent_post='".$post."'";

		$resultados = customPostTypeTree::$wpdb->get_results( $sql );

		if( !empty($resultados) )
		{
			foreach ($resultados as $res)
			{
				$args = array(
						'post_type'	 =>	$res->post,
						'post_status' => 'publish'
					);
				$loop = new WP_Query($args);
				$array = array();

				foreach( $loop->posts as $tree_custom_posts)				
				{
					$tree_custom_post_id = $tree_custom_posts->ID;

					$array[] = array("the_post_tree_parent"=>$res->post,"the_post_tree_title"=>get_the_title($tree_custom_post_id),"the_post_tree_thumbnail"=>get_the_post_thumbnail($tree_custom_post_id, 'cemXcem'), "the_post_tree_id"=>$tree_custom_post_id, "the_post_tree_name"=>'tree_metabox_'.$res->post);
							
					add_meta_box( 
				           'tree_metabox_'.$res->post,
				           $res->post,
				           'customPostTypeTree::metaboxesCallback',
				           $post,
				           'normal',
		           		   'low'
				           ,$array
				      );
				}
			}
		}
	}
	
	// $post is an object containing $_POST data
	// $metabox is an array with metabox id, title, callback, and args elements. 
	// The args element is an array containing your passed $callback_args variables.
	public static function metaboxesCallback ( $post, $metabox ) 
	{
		global $customPostTypeTree;
		
		$t = 0;
		$d = 0;
		foreach ($metabox['args'] as $args)
		{
			$img = customPostTypeTree::$plugins_url."/ajax_load.gif";
			$url = customPostTypeTree::$plugins_url."/ajax.php";
			$checked = "";
			
			$sql = "SELECT parent_post,post,this_post_id FROM ".customPostTypeTree::$wpdb->prefix."custom_post_type_tree WHERE parent_post='".$metabox['title']."' AND post='".$args['the_post_tree_title']."' AND the_post_id='".$post->ID."'";
			
			$resultados = customPostTypeTree::$wpdb->get_results( $sql );
			if( !empty($resultados) )
			{
				foreach ($resultados as $res)
				{
					if( !empty($res->post) )
					{	
						$checked = "checked=\"checked\"";
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['thumbnail'] = $args['the_post_tree_thumbnail'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['this_post_id'] = $args['the_post_tree_id'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['post']['id'] = $post->ID;
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['parent_post'] = $args['the_post_tree_parent'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['post']['name'] = $args['the_post_tree_title'];
						$t++;
					}
					else
					{
						$checked = "checked=\"\"";
					}
				}
			}
			echo "
";
			echo "
";
			echo "ID."&the_post_tree_id=".$args['the_post_tree_id']."&act=cptt&parent=".$metabox['title']."&children=".$args['the_post_tree_title']."','".$post->ID."-".$args['the_post_tree_id']."-".$d."','load-".$post->ID."-".$args['the_post_tree_id']."-".$d."');\"> ";
			echo $args['the_post_tree_title']."
".$args['the_post_tree_thumbnail'];
			echo "

";
			$d++;
		}

	}

	// called by the post
	public static function getTree( $postID, $parent_post )
	{
		global $customPostTypeTree;
		
		$sql = "SELECT post FROM ".customPostTypeTree::$wpdb->prefix."custom_post_type_tree WHERE parent_post='".$parent_post."'";

		$resultados = customPostTypeTree::$wpdb->get_results( $sql );

		if( !empty($resultados) )
		{
			foreach ($resultados as $res)
			{
				$args = array(
						'post_type'	 =>	$res->post,
						'post_status' => 'publish'
					);
				$loop = new WP_Query($args);
				$array = array();

				foreach( $loop->posts as $tree_custom_posts)				
				{
					$tree_custom_post_id = $tree_custom_posts->ID;

					$array[] = array("the_post_tree_parent"=>$res->post,"the_post_tree_title"=>get_the_title($tree_custom_post_id),"the_post_tree_thumbnail"=>get_the_post_thumbnail($tree_custom_post_id, 'cemXcem'), "the_post_tree_id"=>$tree_custom_post_id, "the_post_tree_name"=>'tree_metabox_'.$res->post);
							
					customPostTypeTree::getChildren( $postID, $array );
				}
			}
		}
		return $customPostTypeTree;
	}
	
	public static function getChildren( $postID, $array )
	{
		global $customPostTypeTree;
		
		$t = 0;
		foreach ($array as $args)
		{	
			$sql = "SELECT parent_post,post,this_post_id FROM ".customPostTypeTree::$wpdb->prefix."custom_post_type_tree WHERE parent_post='".$args['the_post_tree_parent']."' AND post='".$args['the_post_tree_title']."' AND the_post_id='".$postID."'";
			
			$resultados = customPostTypeTree::$wpdb->get_results( $sql );
			if( !empty($resultados) )
			{
				foreach ($resultados as $res)
				{
					if( !empty($res->post) )
					{	
						$checked = "checked=\"checked\"";
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['thumbnail'] = $args['the_post_tree_thumbnail'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['this_post_id'] = $args['the_post_tree_id'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['post']['id'] = $postID;
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['parent_post'] = $args['the_post_tree_parent'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['post']['name'] = $args['the_post_tree_title'];
						$customPostTypeTree[$args['the_post_tree_parent']][$t]['permalink'] = '/?post_type='.$args['the_post_tree_parent'].'&p='.$args['the_post_tree_id'];
						$t++;
					}
				}
			}
		}
	}
	
	public static function viewChildren( $array = array() )
	{
		if( !empty( $array ) )
		{
		
			if( !empty($array) )
			{
				foreach ($array as $k => $v)
				{
					for($i=0; $i';
						print '';
						print $v[$i]['post']['name'];
						print '';
						echo '
';
						print '';
						print $v[$i]['thumbnail'];
						print '';	
					}				
				}
			}	
		}
	}

}

/**
 *  Add HOOKs
 */
$mppPluginFile = substr(strrchr(dirname(__FILE__),DIRECTORY_SEPARATOR),1).DIRECTORY_SEPARATOR.basename(__FILE__);

register_activation_hook($mppPluginFile,array('customPostTypeTree','install'));

add_filter('init', array('customPostTypeTree','init'));





add_action( 'add_meta_boxes', 'myplugin_add_custom_box' );

wp_enqueue_script("script", plugins_url(basename(dirname(__FILE__)) . '/script.js'), array('jquery'));

function myplugin_add_custom_box()
{
	$post_types = get_post_types();
	$array = array('attachment','revision','nav_menu_item','object','feedback');
	
	foreach ($post_types as $k => $v)
	{
		if( !in_array($k, $array) )
		{
			add_meta_box(
		        'myplugin_sectionid',
		        __( 'Custom Post Parent', 'myplugin_textdomain' ), 
		        'myplugin_inner_custom_box',
		        $v
		    );
		}
	}
}

function myplugin_inner_custom_box( $post )
{
	global $wpdb;

	$img = plugins_url('',__FILE__) . "/ajax_load.gif";
	$url = plugins_url('',__FILE__) . "/ajax.php";
	$checked = "";
			
    // Use nonce for verification
    wp_nonce_field( plugin_basename( __FILE__ ), 'myplugin_noncename' );

  	$post_types = get_post_types();
	$array = array('attachment','revision','nav_menu_item','object','feedback');
		
	$sql = "SELECT parent_post FROM ".$wpdb->prefix."custom_post_type_tree WHERE post='".get_post_type()."'";
	//print $sql;
	$resultados = $wpdb->get_results( $sql );
        $parents = array();
	foreach ($resultados as $res) 
	{
		$parents[] = $res->parent_post;
	}	
        if( !empty($post_types) )
	foreach ($post_types as $k => $v)
	{
		if( !in_array($k, $array) && $v != get_post_type() )
		{
			$checked = in_array($v, $parents)? "checked=\"checked\"": "";

			echo "
";
			echo "
";
			echo " ".$v."
";
			echo "
";
		}
	}
}	
      
?>