• Resolved jimmy

    (@on-my-iphone)


    Thanks for the plugin. Does exactly what I was after. One thing, looks like changes to wordpress categories make that part no longer work.

    I changed this part of the code to fix

    $posts = $wpdb->get_results(“SELECT * FROM $wpdb->posts
    LEFT JOIN $wpdb->term_relationships ON
    ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
    LEFT JOIN $wpdb->term_taxonomy ON
    ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
    WHERE $wpdb->posts.post_status = ‘publish’
    AND $wpdb->term_taxonomy.taxonomy = ‘category’
    AND $wpdb->term_taxonomy.term_id = $category_id
    ORDER BY post_date DESC $limit”);

    https://wordpress.org/plugins/ical-feeds/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author maximevalette

    (@maximevalette)

    Hello jimmy,

    Thanks, it’s been fixed in 1.2.2 🙂

    Thread Starter jimmy

    (@on-my-iphone)

    Sorry, I just noticed that I gave you my test code, not the code I was using.

    It should be
    select $wpdb->posts.ID, UNIX_TIMESTAMP(post_date) AS post_date, post_title …..

    not
    select *

    without your timezone change the timestamps will be wrong. I have fixed at my end, but if others download and are using categories, then this won’t work.

    Plugin Author maximevalette

    (@maximevalette)

    Sorry I missed that. I issued the 1.2.3.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘changes to categories’ is closed to new replies.