PEAK XOOPS - SQL insert for recurring event in englishin japanese

SQL insert for recurring event

  • You cannot open a new topic into this forum
  • Guests cannot post into this forum
Previous post - Next post | Parent - Children.1 | Posted on 2004/4/20 12:38
larsra99  ÆóÅùʼ   Posts: 1
I'm trying to create a page that will insert several recurring events (birthdays) into piCal's database.

I don't understand how the
'start' & 'end'
fields are calculated.

I know that they are 84600 seconds apart - 1 day - but I don't understand how the other part of the value is calculated.

Any help is appreciated.

-Lars

INSERT INTO `xoops_pical_event` ( `id` , `uid` , `groupid` , `summary` , `location` , `organizer` , `sequence` , `contact` , `tzid` , `description` , `dtstamp` , `categories` , `transp` , `priority` , `admission` , `class` , `rrule` , `rrule_pid` , `unique_id` , `allday` , `start` , `end` , `start_date` , `end_date` , `cid` , `comments` , `event_tz` , `server_tz` , `poster_tz` , `extkey0` , `extkey1` )
VALUES (
'', '00000001', '00000', 'Test Event', '', '', '0', '', 'GMT', 'test event desc', NOW( ) , '', '1', '0', '1', 'PUBLIC', 'FREQ=YEARLY;INTERVAL=1;BYMONTH=6;WKST=SU', '', 'pical060-md5hash-that-is-unique', '5', '2122848000', '2122934400', NULL , NULL , '00000', '0', '0', '0', '0', '0000000000', '0000000000'
);
Votes:0 Average:0.00
Previous post - Next post | Parent - No child | Posted on 2004/4/24 17:39
GIJOE  ÀèǤ·³Áâ   Posts: 4110
hi Lars.

Extracting RFC2445's "RRULE" is very complex.
I can only say that see the function "rrule_extract()" in piCal.php.
Votes:0 Average:0.00

  Advanced search


Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!