Add Calendar Event Automatically?

[akiy]

Does anyone know of a way I could call a function to add an event into the public calendar from an external script? I have a section on my site where people add information on weekend events and such. It would be great if these events could be automatically added into the calendar.

Anyone know of a way these kinds of events can be auto-listed into the vBulletin calendar?

[akiy]

No thoughts on this?

Any help, perhaps even pointers to other hacks which have this functionality, would be appreciated.

[Richardg]

I'm just trying to sort this out right now (I'm assuming you're familiar with php/mysql).

I've been using my external events system to insert new records into the events table.
I've added a new column to the events table to hold the ID of the corresponding record in my external events table so that I can update the events table when I update my external table.
I've got the recurring events working.
I'm left with a couple of issues:
1) I'm having a little trouble with the time zone offset which I don't fully understand (I enter event dates using the Unix timestamp function in MySQL but this seems to go wrong because we have DST here at the moment and the events end up on the wrong day.
2) I do not know what the utc column is for.
I don't know if any of this helps...maybe you have got further than me.

Any input from anyone would be appreciated.

[akiy]

Hi Richard,

I was wondering if there was any consequences of just going straight to the database in inserting a new event. For example, putting in a new thread right into the database doesn't update the searchindex and such. Other than that, I can't say I've started really working on this....

[Richardg]

I don't think so, but I don't know for sure. I'll let youknow how I get on!

cheers

[JustAskJulie]

Have you considered just getting rid of the other area where you have users add events and have them add them straight to the vb calender?

That is what I'm about to do as I've always had a seperate calender of events on my site... but with the latest vb upgrades I'm going to drop my old crappy calender program and do what I said above.

[akiy]

Originally Posted by JustAskJulie

Have you considered just getting rid of the other area where you have users add events and have them add them straight to the vb calender?

I've thought of it, but decided against it as the old events listing still has a lot of good features such as listing events by place (eg individual states, countries)...