query['suppress_filters'])) $query->query['suppress_filters'] = FALSE; if (isset($query->query_vars['suppress_filters'])) $query->query_vars['suppress_filters'] = FALSE; } return $query; } add_filter('posts_orderby', 'CPTOrderPosts'); function CPTOrderPosts($orderBy) { global $wpdb; $options = get_option('cpto_options'); if (is_admin()) { if ($options['adminsort'] == "1") $orderBy = "{$wpdb->posts}.menu_order, {$wpdb->posts}.post_date DESC"; } else { if ($options['autosort'] == "1") $orderBy = "{$wpdb->posts}.menu_order, {$wpdb->posts}.post_date DESC"; } return($orderBy); } $is_configured = get_option('CPT_configured'); if ($is_configured == '') add_action( 'admin_notices', 'CPTO_admin_notices'); function CPTO_admin_notices() { if (isset($_POST['form_submit'])) return; ?>

Post Types Order must be configured. Please go to Settings Page make the configuration and save

Post Types Order', 'manage_options', 'cpto-options', 'cpt_plugin_options'); } add_action('wp_loaded', 'initCPTO' ); function initCPTO() { global $custom_post_type_order, $userdata; $options = get_option('cpto_options'); if (is_admin()) { if (is_numeric($options['level'])) { if (userdata_get_user_level(true) >= $options['level']) $custom_post_type_order = new CPTO(); } else { $custom_post_type_order = new CPTO(); } } } add_filter('get_previous_post_where', 'cpto_get_previous_post_where'); add_filter('get_previous_post_sort', 'cpto_get_previous_post_sort'); add_filter('get_next_post_where', 'cpto_get_next_post_where'); add_filter('get_next_post_sort', 'cpto_get_next_post_sort'); function cpto_get_previous_post_where($where) { global $post, $wpdb; if ( empty( $post ) ) return $where; $current_post_date = $post->post_date; $join = ''; $posts_in_ex_cats_sql = ''; if ( $in_same_cat || !empty($excluded_categories) ) { $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id"; if ( $in_same_cat ) { $cat_array = wp_get_object_terms($post->ID, 'category', array('fields' => 'ids')); $join .= " AND tt.taxonomy = 'category' AND tt.term_id IN (" . implode(',', $cat_array) . ")"; } $posts_in_ex_cats_sql = "AND tt.taxonomy = 'category'"; if ( !empty($excluded_categories) ) { $excluded_categories = array_map('intval', explode(' and ', $excluded_categories)); if ( !empty($cat_array) ) { $excluded_categories = array_diff($excluded_categories, $cat_array); $posts_in_ex_cats_sql = ''; } if ( !empty($excluded_categories) ) { $posts_in_ex_cats_sql = " AND tt.taxonomy = 'category' AND tt.term_id NOT IN (" . implode($excluded_categories, ',') . ')'; } } } $current_menu_order = $post->menu_order; //check if there are more posts with lower menu_order $query = "SELECT p.* FROM $wpdb->posts AS p WHERE p.menu_order < '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"; $results = $wpdb->get_results($query); if (count($results) > 0) { $where = $wpdb->prepare("WHERE p.menu_order < '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"); } else { $where = $wpdb->prepare("WHERE p.post_date < '".$current_post_date."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' AND p.ID != '". $post->ID ."' $posts_in_ex_cats_sql"); } return $where; } function cpto_get_previous_post_sort($sort) { global $post, $wpdb; $current_menu_order = $post->menu_order; $query = "SELECT p.* FROM $wpdb->posts AS p WHERE p.menu_order < '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"; $results = $wpdb->get_results($query); if (count($results) > 0) { $sort = 'ORDER BY p.menu_order DESC, p.post_date ASC LIMIT 1'; } else { $sort = 'ORDER BY p.post_date DESC LIMIT 1'; } return $sort; } function cpto_get_next_post_where($where) { global $post, $wpdb; if ( empty( $post ) ) return null; $current_post_date = $post->post_date; $join = ''; $posts_in_ex_cats_sql = ''; if ( $in_same_cat || !empty($excluded_categories) ) { $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id"; if ( $in_same_cat ) { $cat_array = wp_get_object_terms($post->ID, 'category', array('fields' => 'ids')); $join .= " AND tt.taxonomy = 'category' AND tt.term_id IN (" . implode(',', $cat_array) . ")"; } $posts_in_ex_cats_sql = "AND tt.taxonomy = 'category'"; if ( !empty($excluded_categories) ) { $excluded_categories = array_map('intval', explode(' and ', $excluded_categories)); if ( !empty($cat_array) ) { $excluded_categories = array_diff($excluded_categories, $cat_array); $posts_in_ex_cats_sql = ''; } if ( !empty($excluded_categories) ) { $posts_in_ex_cats_sql = " AND tt.taxonomy = 'category' AND tt.term_id NOT IN (" . implode($excluded_categories, ',') . ')'; } } } $current_menu_order = $post->menu_order; //check if there are more posts with lower menu_order $query = "SELECT p.* FROM $wpdb->posts AS p WHERE p.menu_order > '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"; $results = $wpdb->get_results($query); if (count($results) > 0) { $where = $wpdb->prepare("WHERE p.menu_order > '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"); } else { $where = $wpdb->prepare("WHERE p.post_date > '".$current_post_date."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' AND p.ID != '". $post->ID ."' $posts_in_ex_cats_sql"); } return $where; } function cpto_get_next_post_sort($sort) { global $post, $wpdb; $current_menu_order = $post->menu_order; $query = "SELECT p.* FROM $wpdb->posts AS p WHERE p.menu_order > '".$current_menu_order."' AND p.post_type = '". $post->post_type ."' AND p.post_status = 'publish' $posts_in_ex_cats_sql"; $results = $wpdb->get_results($query); if (count($results) > 0) { $sort = 'ORDER BY p.menu_order ASC, p.post_date DESC LIMIT 1'; } else { $sort = 'ORDER BY p.post_date ASC LIMIT 1'; } return $sort; } class Post_Types_Order_Walker extends Walker { var $db_fields = array ('parent' => 'post_parent', 'id' => 'ID'); function start_lvl(&$output, $depth) { $indent = str_repeat("\t", $depth); $output .= "\n$indent\n"; } function start_el(&$output, $page, $depth, $args) { if ( $depth ) $indent = str_repeat("\t", $depth); else $indent = ''; extract($args, EXTR_SKIP); $output .= $indent . '
  • '.apply_filters( 'the_title', $page->post_title, $page->ID ).''; } function end_el(&$output, $page, $depth) { $output .= "
    • \n"; } } class CPTO { var $current_post_type = null; function CPTO() { add_action( 'admin_init', array(&$this, 'registerFiles'), 11 ); add_action( 'admin_init', array(&$this, 'checkPost'), 10 ); add_action( 'admin_menu', array(&$this, 'addMenu') ); add_action( 'wp_ajax_update-custom-type-order', array(&$this, 'saveAjaxOrder') ); } function registerFiles() { if ( $this->current_post_type != null ) { wp_enqueue_script('jQuery'); wp_enqueue_script('jquery-ui-sortable'); } wp_register_style('CPTStyleSheets', CPTURL . '/css/cpt.css'); wp_enqueue_style( 'CPTStyleSheets'); } function checkPost() { if ( isset($_GET['page']) && substr($_GET['page'], 0, 17) == 'order-post-types-' ) { $this->current_post_type = get_post_type_object(str_replace( 'order-post-types-', '', $_GET['page'] )); if ( $this->current_post_type == null) { wp_die('Invalid post type'); } } } function saveAjaxOrder() { global $wpdb; parse_str($_POST['order'], $data); if (is_array($data)) foreach($data as $key => $values ) { if ( $key == 'item' ) { foreach( $values as $position => $id ) { $wpdb->update( $wpdb->posts, array('menu_order' => $position, 'post_parent' => 0), array('ID' => $id) ); } } else { foreach( $values as $position => $id ) { $wpdb->update( $wpdb->posts, array('menu_order' => $position, 'post_parent' => str_replace('item_', '', $key)), array('ID' => $id) ); } } } } function addMenu() { global $userdata; //put a menu for all custom_type $post_types = get_post_types(); foreach( $post_types as $post_type_name ) { if ($post_type_name == 'page') continue; if ($post_type_name == 'post') add_submenu_page('edit.php', 'Re-Order', 'Re-Order', userdata_get_user_level(), 'order-post-types-'.$post_type_name, array(&$this, 'SortPage') ); else { if (!is_post_type_hierarchical($post_type_name)) add_submenu_page('edit.php?post_type='.$post_type_name, 'Re-Order', 'Re-Order', userdata_get_user_level(), 'order-post-types-'.$post_type_name, array(&$this, 'SortPage') ); } } } function SortPage() { ?>

    current_post_type->labels->singular_name . ' - Re-order '?>

    Update

    0, 'show_date' => '', 'date_format' => get_option('date_format'), 'child_of' => 0, 'exclude' => '', 'title_li' => __('Pages'), 'echo' => 1, 'authors' => '', 'sort_column' => 'menu_order', 'link_before' => '', 'link_after' => '', 'walker' => '' ); $r = wp_parse_args( $args, $defaults ); extract( $r, EXTR_SKIP ); $output = ''; $r['exclude'] = preg_replace('/[^0-9,]/', '', $r['exclude']); $exclude_array = ( $r['exclude'] ) ? explode(',', $r['exclude']) : array(); $r['exclude'] = implode( ',', apply_filters('wp_list_pages_excludes', $exclude_array) ); // Query pages. $r['hierarchical'] = 0; $args = array( 'sort_column' => 'menu_order', 'post_type' => $post_type, 'posts_per_page' => -1, 'orderby' => 'menu_order', 'order' => 'ASC' ); $the_query = new WP_Query($args); $pages = $the_query->posts; if ( !empty($pages) ) { if ( $r['title_li'] ) $output .= '
  • ' . $r['title_li'] . '
    • '; } $output = apply_filters('wp_list_pages', $output, $r); if ( $r['echo'] ) echo $output; else return $output; } function walkTree($pages, $depth, $r) { if ( empty($r['walker']) ) $walker = new Post_Types_Order_Walker; else $walker = $r['walker']; $args = array($pages, $depth, $r); return call_user_func_array(array(&$walker, 'walk'), $args); } } ?>