Support » Plugins and Hacks » [Plugin: AStickyPostOrderER] 2.9.1 compatibility (Trash)…

Viewing 5 replies - 1 through 5 (of 5 total)
  • spedro

    (@spedro)

    I don’t solve the problem. The admin block when I enter in menu configuration plugin.

    AndreSC

    (@andresc)

    Hi

    Please tell me more about the problem

    Thanks

    saharusa could you please be more specific? where should I add those lines?…my numbers are probably different. Here is part of the code

    if ( $croer_cat != 0) {
                    //  Cat
                    $query= "SELECT * ".
                    "FROM $wpdb->posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ".
                    "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ".
                    "WHERE  $wpdb->term_taxonomy.term_id IN $c_cat_and_subcats AND post_type = 'post'";
                    //echo "br>".$query;
            } else {
                    // not cat
                    $query= "SELECT * ".
                    "FROM $wpdb->posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ".
                    "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ".
                    "WHERE  post_type = 'post'";
            }
    
             $query.="ORDER BY ID DESC ;";
            // echo "<br>Q:".$query;
             $result = mysql_query($query);
    
             ?>
        <tr>

    Thanks

    Directly after

    WHERE post_type = 'post'

    So it will looks like this:

    if ( $croer_cat != 0) {
                    //  Cat
                    $query= "SELECT * ".
                    "FROM $wpdb->posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ".
                    "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ".
                    "WHERE  $wpdb->term_taxonomy.term_id IN $c_cat_and_subcats AND post_type = 'post' AND post_status != 'trash'";
                    //echo "br>".$query;
            } else {
                    // not cat
                    $query= "SELECT * ".
                    "FROM $wpdb->posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ".
                    "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ".
                    "WHERE  post_type = 'post' AND post_status != 'trash'";
            }
    
             $query.="ORDER BY ID DESC ;";
            // echo "<br>Q:".$query;
             $result = mysql_query($query);
    
             ?>

    Thank you saharusa – this code was helpful. When I move posts from one category to another (which I must do frequently), the post shows in the new category sorting area, but it often remains in the old category sorting area as well. Have you found a solution to this problem? I have tried to contact the plugin developer, but have not heard anything.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: AStickyPostOrderER] 2.9.1 compatibility (Trash)…’ is closed to new replies.