Serendipity conversion from WebCalendar

Here you can post your custom-made, pimped up Serendipity installations, show off what you have achieved and tweaked
Locked
moenk
Regular
Posts: 52
Joined: Sat Apr 29, 2006 11:21 pm
Contact:

Serendipity conversion from WebCalendar

Post by moenk » Fri Aug 08, 2008 10:15 am

I used the "WebCalendar" quite a long time: http://www.k5n.us/webcalendar.php
Now I converted data to the s9y. If someone has need for it, this lines of SQL were used for the conversion:

Code: Select all

insert into `events_entries` (id, timestamp, title, body, author) SELECT cal_id, unix_timestamp(`cal_date`+" "+`cal_time`),cal_name,cal_description, cal_create_by FROM `webcal_entry` where `cal_access`="P"

insert into `event_entryproperties` (`entryid`,`property`,`value`) SELECT cal_id, "ep_access", "public" FROM `webcal_entry` where `cal_access`="P"

After this I filled some fields more, nothing critical, but I don't remember.
See result here: http://www.geocaching-events.de/
CMS mit S9Y: MCSE - LPIC - SQL - GIS

Locked