Multiselect checkboxes - database->tables ?

Scheduler Javascript
#1

Hello,

So, i have a small issue with multiselect checkboxes (Scheduler) in event creating. My file called 21_multiselect_options.html is connected with other file : php/events_multiselect_options.php, which it references with some database tables for instance : user, event_user, fruit, event_fruit and events_ms.

There is the code :

<?php
	require_once ('../../../codebase/connector/scheduler_connector.php');
	require_once('../../../codebase/connector/crosslink_connector.php');
	require_once ('../../common/config.php');

	$res=mysql_connect($server, $user, $pass);
	mysql_select_db($db_name);

	$cross = new CrossOptionsConnector($res);
	$cross->dynamic_loading(true);
	$cross->options->render_table("user","user_id","user_id(value),username(label)");
	$cross->link->render_table("event_user","event_id", "user_id,event_id");
	
	$fruitCross = new CrossOptionsConnector($res);
	$fruitCross->dynamic_loading(true);
	$fruitCross->options->render_table("fruit","fruit_id","fruit_id(value),fruit_name(label)");
	$fruitCross->link->render_table("event_fruit","event_id","fruit_id,event_id");
	
	//sleep(2);
	$scheduler = new SchedulerConnector($res);
	//$scheduler->enable_log("events_logs.txt",true);
	
	$scheduler->set_options("user_id", $cross->options);
	$scheduler->set_options("fruit_id", $fruitCross->options);
	
	$scheduler->render_table("events_ms","event_id","start_date,end_date,event_name,details");
?>

So my question is : If anyone has sql script to create those tables ? Much appreciated.

#2

Hello,

You can use scheduler\samples\common\dump.sql file.

Kind regards,
Ilya

#3

Thank you very much !