WordPressを読む　38-10 /blog/wp-includes/post.php 10

2014/11/30 2014/12/25

1 /blog/wp-includes/post.php 10
2 関数　trackback_url_list()
3 関数　get_all_page_ids()
4 関数　get_page()
5 関数　get_page_by_path()
6 関数　get_page_by_title()
7 関数　get_page_children()
8 関数　get_page_hierarchy()
9 関数　_page_traverse_name()
10 関数　get_page_uri()
11 関数　get_pages()

/blog/wp-includes/post.php 10

関数　trackback_url_list()

/**
 * Do trackbacks for a list of URLs.
 *
 * @since 1.0.0
 *
 * @param string $tb_list Comma separated list of URLs.
 * @param int    $post_id Post ID.
 */
function trackback_url_list( $tb_list, $post_id ) {
	if ( ! empty( $tb_list ) ) {
		// Get post data.
		$postdata = get_post( $post_id, ARRAY_A );

		// Form an excerpt.
		$excerpt = strip_tags( $postdata['post_excerpt'] ? $postdata['post_excerpt'] : $postdata['post_content'] );

		if ( strlen( $excerpt ) > 255 ) {
			$excerpt = substr( $excerpt, 0, 252 ) . '&hellip;';
		}

		$trackback_urls = explode( ',', $tb_list );
		foreach( (array) $trackback_urls as $tb_url ) {
			$tb_url = trim( $tb_url );
			trackback( $tb_url, wp_unslash( $postdata['post_title'] ), $excerpt, $post_id );
		}
	}
}

/**

* Do trackbacks for a list of URLs.

* @since 1.0.0

* @param string $tb_list Comma separated list of URLs.

* @param int $post_id Post ID.

function trackback_url_list( $tb_list, $post_id ) {

if ( ! empty( $tb_list ) ) {

// Get post data.

$postdata = get_post( $post_id, ARRAY_A );

// Form an excerpt.

$excerpt = strip_tags( $postdata['post_excerpt'] ? $postdata['post_excerpt'] : $postdata['post_content'] );

if ( strlen( $excerpt ) > 255 ) {

$excerpt = substr( $excerpt, 0, 252 ) . '…';

}

$trackback_urls = explode( ',', $tb_list );

foreach( (array) $trackback_urls as $tb_url ) {

$tb_url = trim( $tb_url );

trackback( $tb_url, wp_unslash( $postdata['post_title'] ), $excerpt, $post_id );

}

関数　get_all_page_ids()

//
// Page functions
//

/**
 * Get a list of page IDs.
 *
 * @since 2.0.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @return array List of page IDs.
 */
function get_all_page_ids() {
	global $wpdb;

	$page_ids = wp_cache_get('all_page_ids', 'posts');
	if ( ! is_array( $page_ids ) ) {
		$page_ids = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'page'");
		wp_cache_add('all_page_ids', $page_ids, 'posts');
	}

	return $page_ids;
}

// Page functions

/**

* Get a list of page IDs.

* @since 2.0.0

* @global wpdb $wpdb WordPress database abstraction object.

* @return array List of page IDs.

function get_all_page_ids() {

global $wpdb;

$page_ids = wp_cache_get('all_page_ids', 'posts');

if ( ! is_array( $page_ids ) ) {

$page_ids = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'page'");

wp_cache_add('all_page_ids', $page_ids, 'posts');

}

return $page_ids;

}

関数　get_page()

/**
 * Retrieves page data given a page ID or page object.
 *
 * Use get_post() instead of get_page().
 *
 * @since 1.5.1
 * @deprecated 3.5.0 Use get_post()
 *
 * @param mixed  $page   Page object or page ID. Passed by reference.
 * @param string $output Optional. What to output. Accepts OBJECT, ARRAY_A, or ARRAY_N.
 *                       Default OBJECT.
 * @param string $filter Optional. How the return value should be filtered. Accepts 'raw',
 *                       'edit', 'db', 'display'. Default 'raw'.
 * @return WP_Post|null WP_Post on success or null on failure.
 */
function get_page( $page, $output = OBJECT, $filter = 'raw') {
	return get_post( $page, $output, $filter );
}

/**

* Retrieves page data given a page ID or page object.

* Use get_post() instead of get_page().

* @since 1.5.1

* @deprecated 3.5.0 Use get_post()

* @param mixed $page Page object or page ID. Passed by reference.

* @param string $output Optional. What to output. Accepts OBJECT, ARRAY_A, or ARRAY_N.

* Default OBJECT.

* @param string $filter Optional. How the return value should be filtered. Accepts 'raw',

* 'edit', 'db', 'display'. Default 'raw'.

* @return WP_Post|null WP_Post on success or null on failure.

function get_page( $page, $output = OBJECT, $filter = 'raw') {

return get_post( $page, $output, $filter );

}

関数　get_page_by_path()

/**
 * Retrieves a page given its path.
 *
 * @since 2.1.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param string       $page_path Page path.
 * @param string       $output    Optional. Output type. Accepts OBJECT, ARRAY_N, or ARRAY_A.
 *                                Default OBJECT.
 * @param string|array $post_type Optional. Post type or array of post types. Default 'page'.
 * @return WP_Post|null WP_Post on success or null on failure.
 */
function get_page_by_path( $page_path, $output = OBJECT, $post_type = 'page' ) {
	global $wpdb;

	$page_path = rawurlencode(urldecode($page_path));
	$page_path = str_replace('%2F', '/', $page_path);
	$page_path = str_replace('%20', ' ', $page_path);
	$parts = explode( '/', trim( $page_path, '/' ) );
	$parts = esc_sql( $parts );
	$parts = array_map( 'sanitize_title_for_query', $parts );

	$in_string = "'" . implode( "','", $parts ) . "'";

	if ( is_array( $post_type ) ) {
		$post_types = $post_type;
	} else {
		$post_types = array( $post_type, 'attachment' );
	}

	$post_types = esc_sql( $post_types );
	$post_type_in_string = "'" . implode( "','", $post_types ) . "'";
	$sql = "
		SELECT ID, post_name, post_parent, post_type
		FROM $wpdb->posts
		WHERE post_name IN ($in_string)
		AND post_type IN ($post_type_in_string)
	";

	$pages = $wpdb->get_results( $sql, OBJECT_K );

	$revparts = array_reverse( $parts );

	$foundid = 0;
	foreach ( (array) $pages as $page ) {
		if ( $page->post_name == $revparts[0] ) {
			$count = 0;
			$p = $page;
			while ( $p->post_parent != 0 && isset( $pages[ $p->post_parent ] ) ) {
				$count++;
				$parent = $pages[ $p->post_parent ];
				if ( ! isset( $revparts[ $count ] ) || $parent->post_name != $revparts[ $count ] )
					break;
				$p = $parent;
			}

			if ( $p->post_parent == 0 && $count+1 == count( $revparts ) && $p->post_name == $revparts[ $count ] ) {
				$foundid = $page->ID;
				if ( $page->post_type == $post_type )
					break;
			}
		}
	}

	if ( $foundid )
		return get_post( $foundid, $output );

	return null;
}

/**

* Retrieves a page given its path.

* @since 2.1.0

* @global wpdb $wpdb WordPress database abstraction object.

* @param string $page_path Page path.

* @param string $output Optional. Output type. Accepts OBJECT, ARRAY_N, or ARRAY_A.

* Default OBJECT.

* @param string|array $post_type Optional. Post type or array of post types. Default 'page'.

* @return WP_Post|null WP_Post on success or null on failure.

function get_page_by_path( $page_path, $output = OBJECT, $post_type = 'page' ) {

global $wpdb;

$page_path = rawurlencode(urldecode($page_path));

$page_path = str_replace('%2F', '/', $page_path);

$page_path = str_replace('%20', ' ', $page_path);

$parts = explode( '/', trim( $page_path, '/' ) );

$parts = esc_sql( $parts );

$parts = array_map( 'sanitize_title_for_query', $parts );

$in_string = "'" . implode( "','", $parts ) . "'";

if ( is_array( $post_type ) ) {

$post_types = $post_type;

} else {

$post_types = array( $post_type, 'attachment' );

}

$post_types = esc_sql( $post_types );

$post_type_in_string = "'" . implode( "','", $post_types ) . "'";

$sql = "

SELECT ID, post_name, post_parent, post_type

FROM $wpdb->posts

WHERE post_name IN ($in_string)

AND post_type IN ($post_type_in_string)

$pages = $wpdb->get_results( $sql, OBJECT_K );

$revparts = array_reverse( $parts );

$foundid = 0;

foreach ( (array) $pages as $page ) {

if ( $page->post_name == $revparts[0] ) {

$count = 0;

$p = $page;

while ( $p->post_parent != 0 && isset( $pages[ $p->post_parent ] ) ) {

$count++;

$parent = $pages[ $p->post_parent ];

if ( ! isset( $revparts[ $count ] ) || $parent->post_name != $revparts[ $count ] )

break;

$p = $parent;

}

if ( $p->post_parent == 0 && $count+1 == count( $revparts ) && $p->post_name == $revparts[ $count ] ) {

$foundid = $page->ID;

if ( $page->post_type == $post_type )

break;

}

if ( $foundid )

return get_post( $foundid, $output );

return null;

}

関数　get_page_by_title()

/**
 * Retrieve a page given its title.
 *
 * @since 2.1.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param string       $page_title Page title
 * @param string       $output     Optional. Output type. OBJECT, ARRAY_N, or ARRAY_A.
 *                                 Default OBJECT.
 * @param string|array $post_type  Optional. Post type or array of post types. Default 'page'.
 * @return WP_Post|null WP_Post on success or null on failure
 */
function get_page_by_title( $page_title, $output = OBJECT, $post_type = 'page' ) {
	global $wpdb;

	if ( is_array( $post_type ) ) {
		$post_type = esc_sql( $post_type );
		$post_type_in_string = "'" . implode( "','", $post_type ) . "'";
		$sql = $wpdb->prepare( "
			SELECT ID
			FROM $wpdb->posts
			WHERE post_title = %s
			AND post_type IN ($post_type_in_string)
		", $page_title );
	} else {
		$sql = $wpdb->prepare( "
			SELECT ID
			FROM $wpdb->posts
			WHERE post_title = %s
			AND post_type = %s
		", $page_title, $post_type );
	}

	$page = $wpdb->get_var( $sql );

	if ( $page )
		return get_post( $page, $output );

	return null;
}

/**

* Retrieve a page given its title.

* @since 2.1.0

* @global wpdb $wpdb WordPress database abstraction object.

* @param string $page_title Page title

* @param string $output Optional. Output type. OBJECT, ARRAY_N, or ARRAY_A.

* Default OBJECT.

* @param string|array $post_type Optional. Post type or array of post types. Default 'page'.

* @return WP_Post|null WP_Post on success or null on failure

function get_page_by_title( $page_title, $output = OBJECT, $post_type = 'page' ) {

global $wpdb;

if ( is_array( $post_type ) ) {

$post_type = esc_sql( $post_type );

$post_type_in_string = "'" . implode( "','", $post_type ) . "'";

$sql = $wpdb->prepare( "

SELECT ID

FROM $wpdb->posts

WHERE post_title = %s

AND post_type IN ($post_type_in_string)

", $page_title );

} else {

$sql = $wpdb->prepare( "

SELECT ID

FROM $wpdb->posts

WHERE post_title = %s

AND post_type = %s

", $page_title, $post_type );

}

$page = $wpdb->get_var( $sql );

if ( $page )

return get_post( $page, $output );

return null;

}

関数　get_page_children()

/**
 * Retrieve child pages from list of pages matching page ID.
 *
 * Matches against the pages parameter against the page ID. Also matches all
 * children for the same to retrieve all children of a page. Does not make any
 * SQL queries to get the children.
 *
 * @since 1.5.1
 *
 * @param int   $page_id Page ID.
 * @param array $pages   List of pages' objects.
 * @return array List of page children.
 */
function get_page_children($page_id, $pages) {
	$page_list = array();
	foreach ( (array) $pages as $page ) {
		if ( $page->post_parent == $page_id ) {
			$page_list[] = $page;
			if ( $children = get_page_children($page->ID, $pages) )
				$page_list = array_merge($page_list, $children);
		}
	}
	return $page_list;
}

/**

* Retrieve child pages from list of pages matching page ID.

* Matches against the pages parameter against the page ID. Also matches all

* children for the same to retrieve all children of a page. Does not make any

* SQL queries to get the children.

* @since 1.5.1

* @param int $page_id Page ID.

* @param array $pages List of pages' objects.

* @return array List of page children.

function get_page_children($page_id, $pages) {

$page_list = array();

foreach ( (array) $pages as $page ) {

if ( $page->post_parent == $page_id ) {

$page_list[] = $page;

if ( $children = get_page_children($page->ID, $pages) )

$page_list = array_merge($page_list, $children);

}

return $page_list;

}

関数　get_page_hierarchy()

/**
 * Order the pages with children under parents in a flat list.
 *
 * It uses auxiliary structure to hold parent-children relationships and
 * runs in O(N) complexity
 *
 * @since 2.0.0
 *
 * @param array $pages   Posts array, passed by reference.
 * @param int   $page_id Optional. Parent page ID. Default 0.
 * @return array A list arranged by hierarchy. Children immediately follow their parents.
 */
function get_page_hierarchy( &$pages, $page_id = 0 ) {
	if ( empty( $pages ) ) {
		$result = array();
		return $result;
	}

	$children = array();
	foreach ( (array) $pages as $p ) {
		$parent_id = intval( $p->post_parent );
		$children[ $parent_id ][] = $p;
	}

	$result = array();
	_page_traverse_name( $page_id, $children, $result );

	return $result;
}

/**

* Order the pages with children under parents in a flat list.

* It uses auxiliary structure to hold parent-children relationships and

* runs in O(N) complexity

* @since 2.0.0

* @param array $pages Posts array, passed by reference.

* @param int $page_id Optional. Parent page ID. Default 0.

* @return array A list arranged by hierarchy. Children immediately follow their parents.

function get_page_hierarchy( &$pages, $page_id = 0 ) {

if ( empty( $pages ) ) {

$result = array();

return $result;

}

$children = array();

foreach ( (array) $pages as $p ) {

$parent_id = intval( $p->post_parent );

$children[ $parent_id ][] = $p;

}

$result = array();

_page_traverse_name( $page_id, $children, $result );

return $result;

}

関数　_page_traverse_name()

/**
 * Traverse and return all the nested children post names of a root page.
 *
 * $children contains parent-children relations
 *
 * @since 2.9.0
 *
 * @see _page_traverse_name()
 *
 * @param int   $page_id   Page ID.
 * @param array &$children Parent-children relations, passed by reference.
 * @param array &$result   Result, passed by reference.
 */
function _page_traverse_name( $page_id, &$children, &$result ){
	if ( isset( $children[ $page_id ] ) ){
		foreach( (array)$children[ $page_id ] as $child ) {
			$result[ $child->ID ] = $child->post_name;
			_page_traverse_name( $child->ID, $children, $result );
		}
	}
}

/**

* Traverse and return all the nested children post names of a root page.

* $children contains parent-children relations

* @since 2.9.0

* @see _page_traverse_name()

* @param int $page_id Page ID.

* @param array &$children Parent-children relations, passed by reference.

* @param array &$result Result, passed by reference.

function _page_traverse_name( $page_id, &$children, &$result ){

if ( isset( $children[ $page_id ] ) ){

foreach( (array)$children[ $page_id ] as $child ) {

$result[ $child->ID ] = $child->post_name;

_page_traverse_name( $child->ID, $children, $result );

}

関数　get_page_uri()

/**
 * Build URI for a page.
 *
 * Sub pages will be in the "directory" under the parent page post name.
 *
 * @since 1.5.0
 *
 * @param WP_Post|object|int $page Page object or page ID.
 * @return string|false Page URI, false on error.
 */
function get_page_uri( $page ) {
	$page = get_post( $page );

	if ( ! $page )
		return false;

	$uri = $page->post_name;

	foreach ( $page->ancestors as $parent ) {
		$uri = get_post( $parent )->post_name . '/' . $uri;
	}

	return $uri;
}

/**

* Build URI for a page.

* Sub pages will be in the "directory" under the parent page post name.

* @since 1.5.0

* @param WP_Post|object|int $page Page object or page ID.

* @return string|false Page URI, false on error.

function get_page_uri( $page ) {

$page = get_post( $page );

if ( ! $page )

return false;

$uri = $page->post_name;

foreach ( $page->ancestors as $parent ) {

$uri = get_post( $parent )->post_name . '/' . $uri;

}

return $uri;

}

関数　get_pages()

/**
 * Retrieve a list of pages.
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @since 1.5.0
 *
 * @param mixed $args {
 *     Array or string of arguments. Optional.
 *
 *     @type int    'child_of'     Page ID to return child and grandchild pages of. Default 0, or no restriction.
 *     @type string 'sort_order'   How to sort retrieved pages.
 *                                 Default 'ASC'. Accepts 'ASC', 'DESC'.
 *     @type string 'sort_column'  What columns to sort pages by, comma-separated.
 *                                 Default 'post_title'. Accepts 'post_author', 'post_date', 'post_title', 'post_name',
 *                                 'post_modified', 'post_modified_gmt', 'menu_order', 'post_parent', 'ID', 'rand',
 *                                 'comment_count'. 'post_' can be omitted for any values that start with it.
 *     @type bool   'hierarchical' Whether to return pages hierarchically. Default true.
 *     @type array  'exclude'      Array of page IDs to exclude.
 *     @type array  'include'      Array of page IDs to include. Cannot be used with 'child_of', 'parent', 'exclude',
 *                                 'meta_key', 'meta_value', or 'hierarchical'.
 *     @type string 'meta_key'     Only include pages with this meta key.
 *     @type string 'meta_value'   Only include pages with this meta value.
 *     @type string 'authors'      A comma-separated list of author IDs.
 *     @type int    'parent'       Page ID to return direct children of. 'hierarchical' must be false.
 *                                 Default -1, or no restriction.
 *     @type int    'exclude_tree' Remove all children of the given ID from returned pages.
 *     @type int    'number'       The number of pages to return. Default 0, or all pages.
 *     @type int    'offset'       The number of pages to skip before returning. Requires 'number'.
 *                                 Default 0.
 *     @type string 'post_type'    The post type to query.
 *                                 Default 'page'.
 *     @type string 'post_status'  A comma-separated list of post status types to include.
 *                                 Default 'publish'.
 * }
 * @return array List of pages matching defaults or $args.
 */
function get_pages( $args = array() ) {
	global $wpdb;

	$defaults = array(
		'child_of' => 0, 'sort_order' => 'ASC',
		'sort_column' => 'post_title', 'hierarchical' => 1,
		'exclude' => array(), 'include' => array(),
		'meta_key' => '', 'meta_value' => '',
		'authors' => '', 'parent' => -1, 'exclude_tree' => array(),
		'number' => '', 'offset' => 0,
		'post_type' => 'page', 'post_status' => 'publish',
	);

	$r = wp_parse_args( $args, $defaults );

	$number = (int) $r['number'];
	$offset = (int) $r['offset'];
	$child_of = (int) $r['child_of'];
	$hierarchical = $r['hierarchical'];
	$exclude = $r['exclude'];
	$meta_key = $r['meta_key'];
	$meta_value = $r['meta_value'];
	$parent = $r['parent'];
	$post_status = $r['post_status'];

	// Make sure the post type is hierarchical.
	$hierarchical_post_types = get_post_types( array( 'hierarchical' => true ) );
	if ( ! in_array( $r['post_type'], $hierarchical_post_types ) ) {
		return false;
	}

	if ( $parent > 0 && ! $child_of ) {
		$hierarchical = false;
	}

	// Make sure we have a valid post status.
	if ( ! is_array( $post_status ) ) {
		$post_status = explode( ',', $post_status );
	}
	if ( array_diff( $post_status, get_post_stati() ) ) {
		return false;
	}

	// $args can be whatever, only use the args defined in defaults to compute the key.
	$key = md5( serialize( wp_array_slice_assoc( $r, array_keys( $defaults ) ) ) );
	$last_changed = wp_cache_get( 'last_changed', 'posts' );
	if ( ! $last_changed ) {
		$last_changed = microtime();
		wp_cache_set( 'last_changed', $last_changed, 'posts' );
	}

	$cache_key = "get_pages:$key:$last_changed";
	if ( $cache = wp_cache_get( $cache_key, 'posts' ) ) {
		// Convert to WP_Post instances.
		$pages = array_map( 'get_post', $cache );
		/** This filter is documented in wp-includes/post.php */
		$pages = apply_filters( 'get_pages', $pages, $r );
		return $pages;
	}

	$inclusions = '';
	if ( ! empty( $r['include'] ) ) {
		$child_of = 0; //ignore child_of, parent, exclude, meta_key, and meta_value params if using include
		$parent = -1;
		$exclude = '';
		$meta_key = '';
		$meta_value = '';
		$hierarchical = false;
		$incpages = wp_parse_id_list( $r['include'] );
		if ( ! empty( $incpages ) ) {
			$inclusions = ' AND ID IN (' . implode( ',', $incpages ) .  ')';
		}
	}

	$exclusions = '';
	if ( ! empty( $exclude ) ) {
		$expages = wp_parse_id_list( $exclude );
		if ( ! empty( $expages ) ) {
			$exclusions = ' AND ID NOT IN (' . implode( ',', $expages ) .  ')';
		}
	}

	$author_query = '';
	if ( ! empty( $r['authors'] ) ) {
		$post_authors = preg_split( '/[\s,]+/', $r['authors'] );

		if ( ! empty( $post_authors ) ) {
			foreach ( $post_authors as $post_author ) {
				//Do we have an author id or an author login?
				if ( 0 == intval($post_author) ) {
					$post_author = get_user_by('login', $post_author);
					if ( empty( $post_author ) ) {
						continue;
					}
					if ( empty( $post_author->ID ) ) {
						continue;
					}
					$post_author = $post_author->ID;
				}

				if ( '' == $author_query ) {
					$author_query = $wpdb->prepare(' post_author = %d ', $post_author);
				} else {
					$author_query .= $wpdb->prepare(' OR post_author = %d ', $post_author);
				}
			}
			if ( '' != $author_query ) {
				$author_query = " AND ($author_query)";
			}
		}
	}

	$join = '';
	$where = "$exclusions $inclusions ";
	if ( '' !== $meta_key || '' !== $meta_value ) {
		$join = " LEFT JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id )";

		// meta_key and meta_value might be slashed
		$meta_key = wp_unslash($meta_key);
		$meta_value = wp_unslash($meta_value);
		if ( '' !== $meta_key ) {
			$where .= $wpdb->prepare(" AND $wpdb->postmeta.meta_key = %s", $meta_key);
		}
		if ( '' !== $meta_value ) {
			$where .= $wpdb->prepare(" AND $wpdb->postmeta.meta_value = %s", $meta_value);
		}

	}

	if ( is_array( $parent ) ) {
		$post_parent__in = implode( ',', array_map( 'absint', (array) $parent ) );
		if ( ! empty( $post_parent__in ) ) {
			$where .= " AND post_parent IN ($post_parent__in)";
		}
	} elseif ( $parent >= 0 ) {
		$where .= $wpdb->prepare(' AND post_parent = %d ', $parent);
	}

	if ( 1 == count( $post_status ) ) {
		$where_post_type = $wpdb->prepare( "post_type = %s AND post_status = %s", $r['post_type'], array_shift( $post_status ) );
	} else {
		$post_status = implode( "', '", $post_status );
		$where_post_type = $wpdb->prepare( "post_type = %s AND post_status IN ('$post_status')", $r['post_type'] );
	}

	$orderby_array = array();
	$allowed_keys = array( 'author', 'post_author', 'date', 'post_date', 'title', 'post_title', 'name', 'post_name', 'modified',
		'post_modified', 'modified_gmt', 'post_modified_gmt', 'menu_order', 'parent', 'post_parent',
		'ID', 'rand', 'comment_count' );

	foreach ( explode( ',', $r['sort_column'] ) as $orderby ) {
		$orderby = trim( $orderby );
		if ( ! in_array( $orderby, $allowed_keys ) ) {
			continue;
		}

		switch ( $orderby ) {
			case 'menu_order':
				break;
			case 'ID':
				$orderby = "$wpdb->posts.ID";
				break;
			case 'rand':
				$orderby = 'RAND()';
				break;
			case 'comment_count':
				$orderby = "$wpdb->posts.comment_count";
				break;
			default:
				if ( 0 === strpos( $orderby, 'post_' ) ) {
					$orderby = "$wpdb->posts." . $orderby;
				} else {
					$orderby = "$wpdb->posts.post_" . $orderby;
				}
		}

		$orderby_array[] = $orderby;

	}
	$sort_column = ! empty( $orderby_array ) ? implode( ',', $orderby_array ) : "$wpdb->posts.post_title";

	$sort_order = strtoupper( $r['sort_order'] );
	if ( '' !== $sort_order && ! in_array( $sort_order, array( 'ASC', 'DESC' ) ) ) {
		$sort_order = 'ASC';
	}

	$query = "SELECT * FROM $wpdb->posts $join WHERE ($where_post_type) $where ";
	$query .= $author_query;
	$query .= " ORDER BY " . $sort_column . " " . $sort_order ;

	if ( ! empty( $number ) ) {
		$query .= ' LIMIT ' . $offset . ',' . $number;
	}

	$pages = $wpdb->get_results($query);

	if ( empty($pages) ) {
		/** This filter is documented in wp-includes/post.php */
		$pages = apply_filters( 'get_pages', array(), $r );
		return $pages;
	}

	// Sanitize before caching so it'll only get done once.
	$num_pages = count($pages);
	for ($i = 0; $i < $num_pages; $i++) {
		$pages[$i] = sanitize_post($pages[$i], 'raw');
	}

	// Update cache.
	update_post_cache( $pages );

	if ( $child_of || $hierarchical ) {
		$pages = get_page_children($child_of, $pages);
	}

	if ( ! empty( $r['exclude_tree'] ) ) {
		$exclude = wp_parse_id_list( $r['exclude_tree'] );
		foreach( $exclude as $id ) {
			$children = get_page_children( $id, $pages );
			foreach ( $children as $child ) {
				$exclude[] = $child->ID;
			}
		}

		$num_pages = count( $pages );
		for ( $i = 0; $i < $num_pages; $i++ ) {
			if ( in_array( $pages[$i]->ID, $exclude ) ) {
				unset( $pages[$i] );
			}
		}
	}

	$page_structure = array();
	foreach ( $pages as $page ) {
		$page_structure[] = $page->ID;
	}

	wp_cache_set( $cache_key, $page_structure, 'posts' );

	// Convert to WP_Post instances.
	$pages = array_map( 'get_post', $pages );

	/**
	 * Filter the retrieved list of pages.
	 *
	 * @since 2.1.0
	 *
	 * @param array $pages List of pages to retrieve.
	 * @param array $r     Array of get_pages() arguments.
	 */
	$pages = apply_filters( 'get_pages', $pages, $r );

	return $pages;
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

/**

* Retrieve a list of pages.

* @global wpdb $wpdb WordPress database abstraction object.

* @since 1.5.0

* @param mixed $args {

* Array or string of arguments. Optional.

* @type int 'child_of' Page ID to return child and grandchild pages of. Default 0, or no restriction.

* @type string 'sort_order' How to sort retrieved pages.

* Default 'ASC'. Accepts 'ASC', 'DESC'.

* @type string 'sort_column' What columns to sort pages by, comma-separated.

* Default 'post_title'. Accepts 'post_author', 'post_date', 'post_title', 'post_name',

* 'post_modified', 'post_modified_gmt', 'menu_order', 'post_parent', 'ID', 'rand',

* 'comment_count'. 'post_' can be omitted for any values that start with it.

* @type bool 'hierarchical' Whether to return pages hierarchically. Default true.

* @type array 'exclude' Array of page IDs to exclude.

* @type array 'include' Array of page IDs to include. Cannot be used with 'child_of', 'parent', 'exclude',

* 'meta_key', 'meta_value', or 'hierarchical'.

* @type string 'meta_key' Only include pages with this meta key.

* @type string 'meta_value' Only include pages with this meta value.

* @type string 'authors' A comma-separated list of author IDs.

* @type int 'parent' Page ID to return direct children of. 'hierarchical' must be false.

* Default -1, or no restriction.

* @type int 'exclude_tree' Remove all children of the given ID from returned pages.

* @type int 'number' The number of pages to return. Default 0, or all pages.

* @type int 'offset' The number of pages to skip before returning. Requires 'number'.

* Default 0.

* @type string 'post_type' The post type to query.

* Default 'page'.

* @type string 'post_status' A comma-separated list of post status types to include.

* Default 'publish'.

* }

* @return array List of pages matching defaults or $args.

function get_pages( $args = array() ) {

global $wpdb;

$defaults = array(

'child_of' => 0, 'sort_order' => 'ASC',

'sort_column' => 'post_title', 'hierarchical' => 1,

'exclude' => array(), 'include' => array(),

'meta_key' => '', 'meta_value' => '',

'authors' => '', 'parent' => -1, 'exclude_tree' => array(),

'number' => '', 'offset' => 0,

'post_type' => 'page', 'post_status' => 'publish',

);

$r = wp_parse_args( $args, $defaults );

$number = (int) $r['number'];

$offset = (int) $r['offset'];

$child_of = (int) $r['child_of'];

$hierarchical = $r['hierarchical'];

$exclude = $r['exclude'];

$meta_key = $r['meta_key'];

$meta_value = $r['meta_value'];

$parent = $r['parent'];

$post_status = $r['post_status'];

// Make sure the post type is hierarchical.

$hierarchical_post_types = get_post_types( array( 'hierarchical' => true ) );

if ( ! in_array( $r['post_type'], $hierarchical_post_types ) ) {

return false;

}

if ( $parent > 0 && ! $child_of ) {

$hierarchical = false;

}

// Make sure we have a valid post status.

if ( ! is_array( $post_status ) ) {

$post_status = explode( ',', $post_status );

}

if ( array_diff( $post_status, get_post_stati() ) ) {

return false;

}

// $args can be whatever, only use the args defined in defaults to compute the key.

$key = md5( serialize( wp_array_slice_assoc( $r, array_keys( $defaults ) ) ) );

$last_changed = wp_cache_get( 'last_changed', 'posts' );

if ( ! $last_changed ) {

$last_changed = microtime();

wp_cache_set( 'last_changed', $last_changed, 'posts' );

}

$cache_key = "get_pages:$key:$last_changed";

if ( $cache = wp_cache_get( $cache_key, 'posts' ) ) {

// Convert to WP_Post instances.

$pages = array_map( 'get_post', $cache );

/** This filter is documented in wp-includes/post.php */

$pages = apply_filters( 'get_pages', $pages, $r );

return $pages;

}

$inclusions = '';

if ( ! empty( $r['include'] ) ) {

$child_of = 0; //ignore child_of, parent, exclude, meta_key, and meta_value params if using include

$parent = -1;

$exclude = '';

$meta_key = '';

$meta_value = '';

$hierarchical = false;

$incpages = wp_parse_id_list( $r['include'] );

if ( ! empty( $incpages ) ) {

$inclusions = ' AND ID IN (' . implode( ',', $incpages ) . ')';

}

$exclusions = '';

if ( ! empty( $exclude ) ) {

$expages = wp_parse_id_list( $exclude );

if ( ! empty( $expages ) ) {

$exclusions = ' AND ID NOT IN (' . implode( ',', $expages ) . ')';

}

$author_query = '';

if ( ! empty( $r['authors'] ) ) {

$post_authors = preg_split( '/[\s,]+/', $r['authors'] );

if ( ! empty( $post_authors ) ) {

foreach ( $post_authors as $post_author ) {

//Do we have an author id or an author login?

if ( 0 == intval($post_author) ) {

$post_author = get_user_by('login', $post_author);

if ( empty( $post_author ) ) {

continue;

}

if ( empty( $post_author->ID ) ) {

continue;

}

$post_author = $post_author->ID;

}

if ( '' == $author_query ) {

$author_query = $wpdb->prepare(' post_author = %d ', $post_author);

} else {

$author_query .= $wpdb->prepare(' OR post_author = %d ', $post_author);

}

if ( '' != $author_query ) {

$author_query = " AND ($author_query)";

}

$join = '';

$where = "$exclusions $inclusions ";

if ( '' !== $meta_key || '' !== $meta_value ) {

$join = " LEFT JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id )";

// meta_key and meta_value might be slashed

$meta_key = wp_unslash($meta_key);

$meta_value = wp_unslash($meta_value);

if ( '' !== $meta_key ) {

$where .= $wpdb->prepare(" AND $wpdb->postmeta.meta_key = %s", $meta_key);

}

if ( '' !== $meta_value ) {

$where .= $wpdb->prepare(" AND $wpdb->postmeta.meta_value = %s", $meta_value);

}

if ( is_array( $parent ) ) {

$post_parent__in = implode( ',', array_map( 'absint', (array) $parent ) );

if ( ! empty( $post_parent__in ) ) {

$where .= " AND post_parent IN ($post_parent__in)";

}

} elseif ( $parent >= 0 ) {

$where .= $wpdb->prepare(' AND post_parent = %d ', $parent);

}

if ( 1 == count( $post_status ) ) {

$where_post_type = $wpdb->prepare( "post_type = %s AND post_status = %s", $r['post_type'], array_shift( $post_status ) );

} else {

$post_status = implode( "', '", $post_status );

$where_post_type = $wpdb->prepare( "post_type = %s AND post_status IN ('$post_status')", $r['post_type'] );

}

$orderby_array = array();

$allowed_keys = array( 'author', 'post_author', 'date', 'post_date', 'title', 'post_title', 'name', 'post_name', 'modified',

'post_modified', 'modified_gmt', 'post_modified_gmt', 'menu_order', 'parent', 'post_parent',

'ID', 'rand', 'comment_count' );

foreach ( explode( ',', $r['sort_column'] ) as $orderby ) {

$orderby = trim( $orderby );

if ( ! in_array( $orderby, $allowed_keys ) ) {

continue;

}

switch ( $orderby ) {

case 'menu_order':

break;

case 'ID':

$orderby = "$wpdb->posts.ID";

break;

case 'rand':

$orderby = 'RAND()';

break;

case 'comment_count':

$orderby = "$wpdb->posts.comment_count";

break;

default:

if ( 0 === strpos( $orderby, 'post_' ) ) {

$orderby = "$wpdb->posts." . $orderby;

} else {

$orderby = "$wpdb->posts.post_" . $orderby;

}

$orderby_array[] = $orderby;

}

$sort_column = ! empty( $orderby_array ) ? implode( ',', $orderby_array ) : "$wpdb->posts.post_title";

$sort_order = strtoupper( $r['sort_order'] );

if ( '' !== $sort_order && ! in_array( $sort_order, array( 'ASC', 'DESC' ) ) ) {

$sort_order = 'ASC';

}

$query = "SELECT * FROM $wpdb->posts $join WHERE ($where_post_type) $where ";

$query .= $author_query;

$query .= " ORDER BY " . $sort_column . " " . $sort_order ;

if ( ! empty( $number ) ) {

$query .= ' LIMIT ' . $offset . ',' . $number;

}

$pages = $wpdb->get_results($query);

if ( empty($pages) ) {

/** This filter is documented in wp-includes/post.php */

$pages = apply_filters( 'get_pages', array(), $r );

return $pages;

}

// Sanitize before caching so it'll only get done once.

$num_pages = count($pages);

for ($i = 0; $i < $num_pages; $i++) {

$pages[$i] = sanitize_post($pages[$i], 'raw');

}

// Update cache.

update_post_cache( $pages );

if ( $child_of || $hierarchical ) {

$pages = get_page_children($child_of, $pages);

}

if ( ! empty( $r['exclude_tree'] ) ) {

$exclude = wp_parse_id_list( $r['exclude_tree'] );

foreach( $exclude as $id ) {

$children = get_page_children( $id, $pages );

foreach ( $children as $child ) {

$exclude[] = $child->ID;

}

$num_pages = count( $pages );

for ( $i = 0; $i < $num_pages; $i++ ) {

if ( in_array( $pages[$i]->ID, $exclude ) ) {

unset( $pages[$i] );

}

$page_structure = array();

foreach ( $pages as $page ) {

$page_structure[] = $page->ID;

}

wp_cache_set( $cache_key, $page_structure, 'posts' );

// Convert to WP_Post instances.

$pages = array_map( 'get_post', $pages );

/**

* Filter the retrieved list of pages.

* @since 2.1.0

* @param array $pages List of pages to retrieve.

* @param array $r Array of get_pages() arguments.

$pages = apply_filters( 'get_pages', $pages, $r );

return $pages;

}

- Wordpress

2024年4月
月	火	水	木	金	土	日
« 4月
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

WordPressを読む 38-10 /blog/wp-includes/post.php 10

/blog/wp-includes/post.php 10

WordPressを読む　38-10 /blog/wp-includes/post.php 10