Sticky posts before normal posts WITH PAGINATION WordPress

Ramsey comments:

WOW Thank you Nick! Ok, so far, this seems to be the closest thing to what I want... but... I can't get it to work. First, this is a custom post type and this is the category, so I had to add a few lines to get it to show up my posts.

First, I added:
`$term = get_term_by('slug', get_query_var('term'), get_query_var('taxonomy'));`
to the top of the code.

Then, in each query_posts's array, I added:
`'post_type' => 'my_CPT',
'my_CPT_cat' => $term->slug, `

That got the posts queried and showing up. I can also change the # of posts per page via the Settings -> Reading page. But my pagination isn't showing up at all, and if I visit page/2/ I don't see any posts, as well as none of the "normal" posts seem to be showing up....

Ramsey comments:

I just figured out the reason nothing is showing up on page/2/ isn't because the pagination isn't working... it works. I changed the posts_per_page to 3 and pagination came up just fine and is working, but ONLY the FEATURED posts are coming up, so that's the reason it doesn't seem like the pagination was working.

Nick Parsons comments:

Glad to hear we're getting closer! I tested this and all was working fine with regular posts, so I'll bet it's the taxonomy/category that's throwing a wrench into the works somewhere.

Would you mind pasting your edited version of my code? Thanks!

Ramsey comments:

Thanks Nick. Hopefully it's something easy. Ok here's what I have:

<?php
$term = get_term_by('slug', get_query_var('term'), get_query_var('taxonomy'));
$paged = ($paged)? $paged : 1;
$posts_per_page = get_option('posts_per_page');
$sticky_posts = get_option('sticky_posts');
$num_sticky_pages = (count($sticky_posts) / $posts_per_page);

//If this page has only sticky posts
if( $paged <= $num_sticky_pages){
query_posts(array(
'post_type' => 'my_CPT',
'my_CPT_tax_cat' => $term->slug,
'post__in'=>$sticky_posts,
'paged'=>$paged,
'posts_per_page'=>$posts_per_page,
'ignore_sticky_posts'=>1
));
get_template_part( 'loop', 'post_featured' );
}

//If this page has a combination of sticky and regular posts
elseif( ($paged-1) < $num_sticky_pages && ($paged+1) > $num_sticky_pages ){
$num_regular_posts = ceil( (1-($num_sticky_pages+1-$paged)) * $posts_per_page );
query_posts(array(
'post_type' => 'my_CPT',
'my_CPT_tax_cat' => $term->slug,
'post__in'=>$sticky_posts,
'paged'=>$paged
));
get_template_part( 'loop', 'post_featured' );

query_posts(array(
'post_type' => 'my_CPT',
'my_CPT_tax_cat' => $term->slug,
'ignore_sticky_posts'=>1,
'paged'=>$paged - floor($num_sticky_pages),
'posts_per_page' => $num_regular_posts,
'post__not_in'=>$sticky_posts
));
get_template_part( 'loop', 'post_normal' );

}

//If this page has only regular posts

else{
$sticky_percent = ($sticky_percent = $num_sticky_pages - floor($num_sticky_pages))? $sticky_percent : 1;
$offset = (1-$sticky_percent) * $posts_per_page + ( ($paged-ceil($num_sticky_pages)-1)*$posts_per_page );

query_posts(array(
'post_type' => 'my_CPT',
'my_CPT_tax_cat' => $term->slug,
'post__not_in'=>$sticky_posts,
'offset'=>$offset
));
get_template_part( 'loop', 'post_normal' );

$lost_pages = (count(get_posts('caller_get_posts=1'))-1) / $posts_per_page - ($paged-ceil($num_sticky_pages));
$wp_query->max_num_pages += $lost_pages;
}

if(is_int($num_sticky_pages)){ $wp_query->max_num_pages += 1; }
?>


Nick Parsons comments:

Hmm, I'm still having trouble figuring out what's going on. Is it possible you could give me a temporary login to your test environment so that I can look at the same thing you're seeing?

Thanks!

Nick Parsons comments:

Actually, I may have figured it out. Just a minute and I'll post a solution for you to try.

Nick Parsons comments:

OK, no guarantees but I think what may be happening is that there's another post of a different type that's been marked sticky and it's upsetting the sticky post count.

I was able to fix it by replacing this line:
$sticky_posts = get_option('sticky_posts');
With this one:

$sticky_IDs = $wpdb->get_col("SELECT ID from ".$wpdb->prefix."posts WHERE post_type = 'my_cpt'");
$sticky_posts = array_intersect(get_option('sticky_posts'),$sticky_IDs);

It's possible there's something else causing the issue, but give that a try and let me know.

Ramsey comments:

Nope, looks like it's grabbing the sticky posts correctly as it displays the featured posts fine, including paginating them, but I see no 'normal' posts yet. This theme uses a Custom Post Type and a hack to activate the sticky feature for CPT's... I'm not exactly sure if this info helps, but here's the places in the theme for that:

// hack until WP supports custom post type sticky feature
function theme_sticky_option() {
global $post;

//if post is a custom post type and only during the first execution of the action quick_edit_custom_box
if ($post->post_type == 'my_CPT' && did_action('quick_edit_custom_box') === 1): ?>

<fieldset class="inline-edit-col-right">
<div class="inline-edit-col">
<label class="alignleft">
<input type="checkbox" name="sticky" value="sticky" />
<span class="checkbox-title"><?php _e('Featured Post'); ?></span>
</label>
</div>
</fieldset>
<?php
endif;
}
//add the sticky option to the quick edit area
add_action('quick_edit_custom_box', 'theme_sticky_option');

Nick Parsons comments:

Thanks for the info on the sticky hack, I figured you had something like that running.

Would you just try putting echo count($sticky_posts); in there and verify that the number echoed is the correct number of sticky posts in that type and taxonomy?

Nick Parsons comments:

I realized I wasn't super clear - by 'in there' I meant after the $sticky_posts variable is declared in the main template code.

Ramsey comments:

Looks like it is echoing 102 but I know that isn't correct. It is also echoing the very same number on EACH category (there are about 9) and I know for a fact that they don't all have the same number.