WP_Rewrite::page_uri_index(): array

427	public function page_uri_index() {428		global $wpdb;429 430		// Get pages in order of hierarchy, i.e. children after parents.431		$pages = $wpdb->get_results( "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'page' AND post_status != 'auto-draft'" );432		$posts = get_page_hierarchy( $pages );433 434		// If we have no pages get out quick.435		if ( ! $posts ) {436			return array( array(), array() );437		}438 439		// Now reverse it, because we need parents after children for rewrite rules to work properly.440		$posts = array_reverse( $posts, true );441 442		$page_uris            = array();443		$page_attachment_uris = array();444 445		foreach ( $posts as $id => $post ) {446			// URL => page name.447			$uri         = get_page_uri( $id );448			$attachments = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent = %d", $id ) );449			if ( ! empty( $attachments ) ) {450				foreach ( $attachments as $attachment ) {451					$attach_uri                          = get_page_uri( $attachment->ID );452					$page_attachment_uris[ $attach_uri ] = $attachment->ID;453				}454			}455 456			$page_uris[ $uri ] = $id;457		}458 459		return array( $page_uris, $page_attachment_uris );460	}