1
larsra99
SQL insert for recurring piCal event (birthdays)
  • 2004/4/20 3:23

  • larsra99

  • Just popping in

  • Posts: 1

  • Since: 2004/4/10


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

Login

Who's Online

162 user(s) are online (93 user(s) are browsing Support Forums)


Members: 0


Guests: 162


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits