[kronolith] freebusy URL not working AND event_alarm > 0 ?

[LALOT Dominique]

Hello,

I was wondering why the FB were not working, so I looked at the SQL:

SELECT event_id, event_uid, event_description, event_location,
event_private, event_status, event_attendees, event_title, event_recurcount,
event_url, event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays, event_start, event_end, event_allday, event_alarm,
event_alarm_methods, event_modified, event_exceptions, event_creator_id,
event_resources, event_baseid, event_exceptionoriginaldate FROM
kronolith_events WHERE calendar_id = 'xxx' *AND event_alarm > 0* AND
((event_end >= '2011-08-23 22:00:00') OR (event_recurenddate >= '2011-08-23
22:00:00' AND event_recurtype <> 0))

gives empty set

So I tried to change

SELECT event_id, event_uid, event_description, event_location,
event_private, event_status, event_attendees, event_title, event_recurcount,
event_url, event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays, event_start, event_end, event_allday, event_alarm,
event_alarm_methods, event_modified, event_exceptions, event_creator_id,
event_resources, event_baseid, event_exceptionoriginaldate FROM
kronolith_events WHERE calendar_id = 'rouanet.x'  AND ((event_end >=
'2011-08-23 22:00:00') OR (event_recurenddate >= '2011-08-23 22:00:00' AND
event_recurtype <> 0))

gives the busy events..
Is there a reason to look at alarms for FB?

and other little problem (no side effect at that time, but ..
I was also surprised that the fb URL was no correct:
fb.php?u= xxx
there is a space but it does not matter  as it's still working.

my backend for ldap is:
        'freebusyUrl' => array('fields' => array('uid'), 'format' =>
Horde::url($GLOBALS['registry']->get('webroot', 'horde') .
'/kronolith/fb.php?u=%s', true)),

-- 
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot