public function onPreInit($param)
{
// if(isset($_GET['idtm_organisation'])){
// $openItem = $_GET['idtm_organisation'];
// }else{
// $openItem = 1;
// }
//
// $this->setUserStartId($this->user->getStartNode($this->user->getUserId($this->user->Name),"tm_organisation"));
$res = mysql_connect($this->Application->Parameters['Host'], $this->Application->getModule('db1')->database->getUsername(), $this->Application->getModule('db1')->database->getPassword());
mysql_select_db($this->Application->Parameters['Database']);
$scheduler = new schedulerConnector($res);
$scheduler->enable_log("log.txt", true);
$scheduler->render_table("vv_termin_connector", "idtm_termin", "ter_starttimestamp, ter_endtimestamp, ter_betreff, ter_descr,idtm_activity");
}
<?php
include '../config.php';
include '../../codebase/scheduler_connector.php';
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
$scheduler = new schedulerConnector($res);
$scheduler->enable_live_update('actions_table');
$scheduler->enable_log("log.txt", true);
$scheduler->render_table("events", "event_id", "start_date,end_date,event_name,details");
<?php
require_once '../common/connector/scheduler_connector.php';
include '../common/config.php';
$scheduler = new schedulerConnector($res, $dbtype);
$scheduler->render_table("horario", "idhorario", "inicio,fin,espacio_idespacio");
<?php
include '../../../codebase/connector/scheduler_connector.php';
include '../../common/config.php';
$res = mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
$scheduler = new schedulerConnector($res);
//$scheduler->enable_log("log.txt",true);
$scheduler->render_table("events_map", "event_id", "start_date,end_date,event_name,details,event_location,lat,lng");
<?php
require_once 'connector/scheduler_connector.php';
include 'config.php';
$scheduler = new schedulerConnector($res, $dbtype);
$scheduler->render_table("schedule_general", "id", "start_date,end_date,text,name,phone");
include '../../common/config.php';
$res = mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
function delete_related($action)
{
global $scheduler;
$status = $action->get_status();
$type = $action->get_value("rec_type");
$pid = $action->get_value("event_pid");
//when serie changed or deleted we need to remove all linked events
if (($status == "deleted" || $status == "updated") && $type != "") {
$scheduler->sql->query("DELETE FROM events_rec WHERE event_pid='" . $scheduler->sql->escape($action->get_id()) . "'");
}
if ($status == "deleted" && $pid != 0) {
$scheduler->sql->query("UPDATE events_rec SET rec_type='none' WHERE event_id='" . $scheduler->sql->escape($action->get_id()) . "'");
$action->success();
}
}
function insert_related($action)
{
$status = $action->get_status();
$type = $action->get_value("rec_type");
if ($status == "inserted" && $type == "none") {
$action->set_status("deleted");
}
}
$scheduler = new schedulerConnector($res);
//$scheduler->enable_log("log.txt",true);
$scheduler->event->attach("beforeProcessing", "delete_related");
$scheduler->event->attach("afterProcessing", "insert_related");
$scheduler->render_table("events_rec", "event_id", "start_date,end_date,text,rec_type,event_pid,event_length");
<?php
require_once '../../common/connector/scheduler_connector.php';
include '../../common/config.php';
$list = new OptionsConnector($res, $dbtype);
$list->render_table("types", "typeid", "typeid(value),name(label)");
$scheduler = new schedulerConnector($res, $dbtype);
//$scheduler->enable_log("log.txt",true);
$scheduler->set_options("type", $list);
$scheduler->render_table("tevents", "event_id", "start_date,end_date,event_name,type");
<?php
include '../config.php';
include '../../codebase/db_pdo.php';
include '../../codebase/scheduler_connector.php';
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
$scheduler = new schedulerConnector($res, "PDO");
//$scheduler->enable_log("log.txt",true);
$scheduler->render_table("events", "event_id", "start_date,end_date,event_name,details");
<?php
//connector 1.x
include '../../../codebase/connector/scheduler_connector.php';
include '../../common/config.php';
$res = mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
$user_id = intval($_GET['user']);
$scheduler = new schedulerConnector($res);
$scheduler->enable_log("log.txt", true);
$scheduler->access->deny("insert");
$scheduler->access->deny("update");
$scheduler->access->deny("delete");
$scheduler->render_sql("select * from events_shared where event_type=1 AND userId = " . $user_id, "event_id", "start_date,end_date,text,event_type,userId");
<?php
require_once '../common/connector/scheduler_connector.php';
require_once '../common/config.php';
$user_id = intval($_GET['user']);
$scheduler = new schedulerConnector($res, $dbtype);
function default_values($action)
{
global $user_id;
$event_type = $action->get_value("event_type");
if ($event_type == "") {
$event_type = 0;
}
$action->set_value("userId", $user_id);
}
$scheduler->event->attach("beforeProcessing", "default_values");
$scheduler->render_sql("select * from events_shared where userId = " . $user_id, "event_id", "start_date,end_date,text,event_type,userId");
<?php
include '../../common/connector/scheduler_connector.php';
include '../../common/config.php';
$scheduler = new schedulerConnector($res, $dbtype);
//$scheduler->enable_log("log.txt",true);
$scheduler->render_table("events_tt", "event_id", "start_date,end_date,event_name,details,section_id,section2_id");
<?php
header("Content-Type:text/html;charset=utf-8");
include 'config.php';
include 'codebase/scheduler_connector.php';
require "codebase/db_mysqli.php";
$res = mysqli_connect($mysql_server, $mysql_user, $mysql_pass, $mysql_db);
$scheduler = new schedulerConnector($res, "MySQLi");
$scheduler->render_table("events", "event_id", "start_date,end_date,details,fname,procedur,personal,tel,price,pro_date,company_id");
<?php
require_once 'connector/scheduler_connector.php';
include 'config.php';
$scheduler = new schedulerConnector($res, $dbtype);
$scheduler->render_table("schedule_odonto", "id", "start_date,end_date,text,name,phone");
