inserting info into the calendar tables

[Benj]

hi i want to insert calendar dates into the vb calendar via a custom script. could someone break down to me the tables i would need to insert data into for the custom script to work? and in what format eg date and user id ?

[Reeve of shinra]

I started to work on something of my own but never got around to it. I'd be interested in seeing your script when done if you dont mind. :)

Here are the fields for the calendar table. If your looking to add holidays you will also need to add two phrases...

holiday_title_cal_SOMETHING

Something would be your designator like 'bqday' and would spit out the event name like 'Brookyln Queens Day'.


holiday_event_cal_SOMETHING

Same thing but for the description.


Field Type Attributes Null Default Extra
calendarid int(10) UNSIGNED No auto_increment
title varchar(255) No
description varchar(100) No
displayorder smallint(6) No 0
neweventemail varchar(255) No
moderatenew smallint(6) No 0
startofweek smallint(6) No 0
options int(10) UNSIGNED No 0
cutoff smallint(5) UNSIGNED No 0
eventcount smallint(5) UNSIGNED No 0
birthdaycount smallint(5) UNSIGNED No 0
startyear smallint(5) UNSIGNED No 2000
endyear smallint(5) UNSIGNED No 2006
holidays int(10) UNSIGNED No 0

[Benj]

what it is im going to be running vb along side jamroom (jamroom.net) (if anyone knows it) when adding an event usin there script i would like the event to also be added to the vb calendar.......

when addin an event with jamroom you imput

event name

event location

event text

event date

if i added this infomation into the following fields would it work

Field Type Attributes Null Default Extra
calendarid int(10) UNSIGNED No auto_increment
title varchar(255) No
description varchar(100) No

or would i have to hard code my user ID into the custom script. also on my calendar i have some required custom fields what happens if i dont fill these in with this custom script ?


thanks for ya help

Benj

[Reeve of shinra]

I assume you would want to hard code the Calendar ID (not user id) into the script. I am not sure what happens when you dont enter required fields. I guess since your entering it directly into the database, it would spit out the error message that the required fields are missing but only one way to find out ;)