Events database fields:
Field name
Type
Required
Event id
Unique identifier
YES
Event group id
Numeric integer
No
Title
Varchar - 50chars
YES
Description
Text (no size limit)
No
Start date
DateTime
YES
End date
DateTime
YES
Is all day:
Numeric integer
YES
Category id
Numeric integer
No
Is private
Numeric integer
No
User id
Numeric integer
No
User group id
Numeric integer
No
Text color
Varchar - 10chars
No
Background color
Varchar - 10chars
No
Border color
Varchar - 10chars
No
Editable
Numeric integer
No
Recordset mapping:
In this section you must choose the recordset that return the list of events and in the other combo you must choose the recordset field corresponding to the events field.
So you can give your own name to the recordset fields.
Editable dynamic:
In this field you can write the name of your function that define if a single event is editable or not.
The extension call this function with 3 parameters like this example
<?php
function IsEditable($id, $user_id, $user_group_id){
$editable = "true";//HERE YOUR ASP CODE TO DETERMINE
// IF THE SCHEDULER CAN BE EDITABLE OR NOT
// THE FUNCTION MUST RETURN A STRING: "true" or "false"
return $editable;
}
?>
Table mapping:
In this section you must choose the connection and after the table and in the other combo you must choose the table field corresponding to the events field.
So you can give your own name to the table fields.
Category mapping:
In this section you must choose the recordset that return the list of category and in the other combo you must choose the recordset field corresponding to the category field. This is optional.
Session mapping:
In case you want save in the database the reference to the user create an event you must setup this fields. In the "User id" field of this section you must write the name of the session variable where you save the user id.
The user_group_id define the group of the user, if defined the extension allows the change to all users of the same group of the user who created the event.
