Hi,
actually i want to use that scheduler as an event calendar for my members is there any possibility that i can a add new field in the data base and fetch record with specific field. suppose i have a Table “Members”:
ID | Name
1 | Jabbar
2 | George
Table “Events”:
event_id | event_name | start_date |end_date | details | member_id
1 | testing activity |2011-10-17 00:20:00 | 2011-10-17 03:25:00 |this is detail | 2
so on so forth, can i select events created by Jabbar on the basis on Member ID. i am new in development looking for help
Are you using scheduler as plugin or as standalone app ?
In first case you can’t link separate table, but you can create a custom field and define list of options for it.
In second case you can set_options command of connector to link external table to the foreign-key field
I want to use it as plugin, Actually i was looking to add events by users, and authorized users can only see there events only; which they have created. to do this i have to add user id in events table. i have created following queries to get records:
if ($scheduler->is_select_mode())//code for loading data
$scheduler->render_sql(“Select * from developers as d, events as e where d.developer_id=e.developerid”, “e.event_id”,“start_date,end_date,event_name,details,developerid”);
else //code for other operations - i.e. update/insert/delete
$scheduler->render_table(“events”,“event_id”,“start_date,end_date,event_name,details,developerid”);
kindly guide me how can i get user’s id(i.e $_SESSION[developerid]) and store with each events they created after login to my system.