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

[Jan Schneider]

Zitat von LALOT Dominique <dom.lalot at gmail.com>:

> 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))

What makes you think that this query is from generating free/busy  
information. Kronolith_FreeBusy::generate() does *not* request  
alarm-only events.

> 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
> --
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org


Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/