[EventCalendar] Re: Need a tip: no post days in event calendar

[cool2sv]

Still cant find a way for displaying just events and post  and not the event
posts and posts in calendar.
I suppose the code I have to hack is the following:

// 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()
     )";


Where i have to implement somehow a more complex query wich will include the
results from $wpdb->post2cats where category_id<>'our event category id'. Or
I'm just digging the wrong way?!
Please help...
Cheers...

-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20070526/61393aaa/attachment.html