[EventCalendar] showing only some of event-types

[Johan Michaelsen]

Well, that was what I tried (using the ec3 default query) but i found  
my skills on php/mysql so lacking, that I couldn't find the "hot  
spot" in the scripts.

But if you want to do it the way I described, I would like to know a  
little more about the architechture of your categories.
I don't have any posts in the event-category that is not an event! So  
I'm a little confused when you talk about events AND posts.

As far I can see any event IS a post in the event-category. What kind  
of posts beside that do you want to show?

best regards
Johan


Den 31/05/2007 kl. 9.31 skrev cool2sv:

> Nice, can you help me with a sql query I'm trying to generate for  
> displaying just events and posts and not the event posts and all  
> the posts in calendar.
>
> I've tryed to hack the ec3 default query:
>
> // We are interested in normal posts, as well as events.
>     $sql="( $sql ) UNION
>      ( SELECT DISTINCT
>          id,
>          post_title,
>          post_date AS start_date,
>          post_date AS end_date,
>          0 AS allday,
>          0 AS is_event
>        FROM $wpdb->posts
>        WHERE post_status='publish'
>          AND post_date>='$begin_date'
>          AND post_date<'$end_date'
>          AND post_date<NOW()
>      )";
>
> But couldn't get a proper result! I'm stucked!
>
> -- 
> ID: c00l2sv
> NAME: stanislav sushkov
> LOCATION: romania (currently)
> OCCUPATION: student
> STATUS: single
> PHONE NR.: +4075655963
> E-MAIL: cool2sv at gmail.com
> WEB: http://e-stas.net
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20070531/8414490e/attachment.htm