PEAK XOOPS - SQL insert for recurring event in englishin japanese

SQL insert for recurring event

List posts in the topic

question SQL insert for recurring event

msg# 1
depth:
0
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

Posts tree

  Advanced search


Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!