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