function jeml_page_management_dropdown()
{
    global $submenu, $wpdb;
    $pages = $wpdb->get_results("SELECT ID, post_title, post_name, post_parent FROM {$wpdb->posts} WHERE post_type = 'page' AND post_status = 'publish' ORDER BY menu_order ASC, post_title ASC");
    $indexed_pages = get_page_hierarchy($pages);
    foreach ($pages as $page) {
        $indexed_pages[$page->ID] = $page;
    }
    foreach ($indexed_pages as $page) {
        $indent = '';
        $parent = $page->post_parent;
        while ($parent != 0) {
            $indent .= '   ';
            $parent = $indexed_pages[$parent]->post_parent;
        }
        $submenu['edit.php?post_type=page'][] = array($indent . $page->post_title, 'edit_pages', 'post.php?action=edit&post=' . $page->ID);
    }
}

function generate_page_rewrite_rules() {
	global $wpdb;
	
	//get pages in order of hierarchy, i.e. children after parents
	$posts = get_page_hierarchy($wpdb->get_results("SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_status = 'static'"));
	//now reverse it, because we need parents after children for rewrite rules to work properly
	$posts = array_reverse($posts, true);

	$page_rewrite_rules = array();
	$page_attachment_rewrite_rules = array();

	if ($posts) {
		
		foreach ($posts as $id => $post) {

			// URI => page name
			$uri = get_page_uri($id);
			$attachments = $wpdb->get_results("SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_status = 'attachment' AND post_parent = '$id'");
			if ( $attachments ) {
				foreach ( $attachments as $attachment ) {
					$attach_uri = get_page_uri($attachment->ID);
					$page_attachment_rewrite_rules[$attach_uri] = $attachment->post_name;
				}
			}

			$page_rewrite_rules[$uri] = $post;
		}

		update_option('page_uris', $page_rewrite_rules);
		
		if ( $page_attachment_rewrite_rules )
			update_option('page_attachment_uris', $page_attachment_rewrite_rules);
	}
}

 /**
  * Retrieve all page and attachments for pages URIs.
  *
  * The attachments are for those that have pages as parents and will be
  * retrieved.
  *
  * @since 2.5.0
  * @access public
  *
  * @return array Array of page URIs as first element and attachment URIs as second element.
  */
 function page_uri_index()
 {
     global $wpdb;
     //get pages in order of hierarchy, i.e. children after parents
     $posts = get_page_hierarchy($wpdb->get_results("SELECT ID, post_name, post_parent FROM {$wpdb->posts} WHERE post_type = 'page' AND post_status != 'auto-draft'"));
     // If we have no pages get out quick
     if (!$posts) {
         return array(array(), array());
     }
     //now reverse it, because we need parents after children for rewrite rules to work properly
     $posts = array_reverse($posts, true);
     $page_uris = array();
     $page_attachment_uris = array();
     foreach ($posts as $id => $post) {
         // URL => page name
         $uri = get_page_uri($id);
         $attachments = $wpdb->get_results($wpdb->prepare("SELECT ID, post_name, post_parent FROM {$wpdb->posts} WHERE post_type = 'attachment' AND post_parent = %d", $id));
         if (!empty($attachments)) {
             foreach ($attachments as $attachment) {
                 $attach_uri = get_page_uri($attachment->ID);
                 $page_attachment_uris[$attach_uri] = $attachment->ID;
             }
         }
         $page_uris[$uri] = $id;
     }
     return array($page_uris, $page_attachment_uris);
 }

/**
 * get_page_hierarchy() - {@internal Missing Short Description}}
 *
 * Fetches the pages returned as a FLAT list, but arranged in order of their hierarchy,
 * i.e., child parents immediately follow their parents.
 *
 * @package WordPress
 * @subpackage Post
 * @since 2.0
 *
 * @param array $posts posts array
 * @param int $parent parent page ID
 * @return array {@internal Missing Description}}
 */
function get_page_hierarchy($posts, $parent = 0)
{
    $result = array();
    if ($posts) {
        foreach ($posts as $post) {
            if ($post->post_parent == $parent) {
                $result[$post->ID] = $post->post_name;
                $children = get_page_hierarchy($posts, $post->ID);
                $result += $children;
                //append $children to $result
            }
        }
    }
    return $result;
}

function generate_page_uri_index()
{
    global $wpdb;
    //get pages in order of hierarchy, i.e. children after parents
    $posts = get_page_hierarchy($wpdb->get_results("SELECT ID, post_name, post_parent FROM {$wpdb->posts} WHERE post_type = 'page'"));
    //now reverse it, because we need parents after children for rewrite rules to work properly
    $posts = array_reverse($posts, true);
    $page_uris = array();
    $page_attachment_uris = array();
    if ($posts) {
        foreach ($posts as $id => $post) {
            // URL => page name
            $uri = get_page_uri($id);
            $attachments = $wpdb->get_results("SELECT ID, post_name, post_parent FROM {$wpdb->posts} WHERE post_type = 'attachment' AND post_parent = '{$id}'");
            if ($attachments) {
                foreach ($attachments as $attachment) {
                    $attach_uri = get_page_uri($attachment->ID);
                    $page_attachment_uris[$attach_uri] = $attachment->ID;
                }
            }
            $page_uris[$uri] = $id;
        }
        delete_option('page_uris');
        update_option('page_uris', $page_uris);
        if ($page_attachment_uris) {
            delete_option('page_attachment_uris');
            update_option('page_attachment_uris', $page_attachment_uris);
        }
    }
}

 /**
  * prev_lecture( $lecture )
  * Get the previous lecture
  *
  * @param Mixed $lecture object, current lecture
  * @return Mixed the previous $lecture object
  */
 function prev_lecture($lecture)
 {
     global $bp;
     // Get lectures
     $lectures = BPSP_Lectures::has_lectures($bp->groups->current_group->id);
     if (empty($lectures)) {
         return null;
     }
     // Try to sort them by menu_order
     usort($lectures, array('BPSP_Lectures', 'cmp_menu_order'));
     // Use WordPress's hierarchical algorithm
     $hierarchy = get_page_hierarchy($lectures, 0);
     // Find current position in hierarchy
     while (next($hierarchy)) {
         if (current($hierarchy) == $lecture->post_name) {
             break;
         }
     }
     $prev = prev($hierarchy);
     if ($prev) {
         return BPSP_Lectures::is_lecture($prev);
     } else {
         return null;
     }
 }