WordPress.org

1. LynneLiL
   Member
   Posted 2 years ago #

   OK, I need a simple answer to a complex question, if someone who knows WP really well knows it.

   I am trying to use Customizable Post Listings. In this thread, it appears CPL 1.5 works with one modification (adding the check for "post" vs "page"). At least, that's what people in that above thread say.

   I am using 2.2. The post v page mod helps with that problem, but the plugin is still not working as advertised...I cannot narrow the custom list of posts by category. It just lists all of them, no matter if I put in a category ID or even hardcode a known category ID into the plugin itself.

   Question: What possible different between 2.1 and 2.2 would cause this to happen? The SQL appears to be OK, so far as I can read down the table definitions in the documentation...so I'm totally lost as to why CPL 1.5 isn't working with WP2.2.

   I'm about to get seriously desperate, because I'm working on my friend's candidate website, and I need to list "upcoming events" posts along with other "lists" that need generating elsewhere.

2. LynneLiL
   Member
   Posted 2 years ago #

   FYI, the SQL generated by the plugin is as follows:

   SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)
   AND ( category_id = 4) WHERE wp_posts.post_date <= '2007-07-18 09:16:42'
   AND ( wp_posts.post_status = 'publish' ) AND wp_posts.post_password = ''
   GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

   This is using the c2c_get_recent_posts() function of the plugin.

   It has "AND ( category_id = 4)" but the plugin then goes on and lists all categories of recent posts anyway.

   Seriously, is there someone who's going to be able to help me?

Topic Closed

This topic has been closed to new replies.