[EventCalendar] Serious Problem with the Post Levels Plugin

[Dr. Peter Troxler]

I don't know post levels, maybe you should expand a little bit on  
what post levels does and why it wants to left join and maybe  
particularly why exactly ec3 should be more robust and not post  
levels ;-)

On 18-sep-2007, at 3:16, firetree_ec3 at spamex.com wrote:

> There are a number of problems between the EventCalendar 3 plugin  
> (which I love), and the Post Levels 1.1.1 Plugin (http://fortes.com/ 
> 2007/02/16/post-levels-111/). I really, REALLY want to use Post  
> Levels, but I can't. The reason is that you guys are doing the same  
> thing, and you collide.
>
> There seem to be a couple of problems in the template-functions.php  
> file.
>
> One can be fairly easily fixed:
>
> Starting at line 113 (ec3_util_calendar_days function):
>   $sql=
>     "SELECT DISTINCT
>        id,
>        post_title,
>        GREATEST(start,'$begin_date') AS start_date,
>        LEAST(end,'$end_date') AS end_date,
>        allday,
>        1 AS is_event
>      FROM $wpdb->posts,$ec3->schedule
>      WHERE post_status='publish'
>        AND $ec3->schedule.post_id=id
>        AND end>='$begin_date'
>        AND start<'$end_date'";
>
> If you make the following change, it addresses that problem:
>
> Change "AND post_id=id" to:"AND $ec3->schedule.post_id=id".
>
> The other problem is a great deal harder to address, and I am  
> stumped. It involves the query you construct starting at line 379  
> (ec3_get_events function):
>
>   $calendar_entries = $wpdb->get_results(
>     "SELECT DISTINCT
>        p.id AS id,
>        post_title,
>        start,
>        u.$ec3->wp_user_nicename AS author,
>        allday
>      FROM $ec3->schedule s
>      LEFT JOIN $wpdb->posts p ON s.post_id=p.id
>      LEFT JOIN $wpdb->users u ON p.post_author = u.id
>      WHERE p.post_status='publish'
>        AND end>='$ec3->today' $and_before
>      ORDER BY start $limit_numposts"
>   );
>
> What happens here is that Post Levels inserts JOIN LEFTs inside  
> your JOIN LEFTs and MySQL throws a hissy fit.
>
> Basically, you guys are both doing the same thing. Maybe you can  
> write the SQL to be a bit more robust. I dunno.
>
> In a competition between them, EC3 wins, but I would really, REALLY  
> like to be able to use Post Levels.
>
> Yours,
>
> Chris Marshall
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar