5 include_once
"Services/Tree/classes/class.ilTree.php";
19 $this->table_tree =
'tree_workspace';
20 $this->table_obj_data =
'object_data';
21 $this->table_obj_reference =
'object_reference_ws';
22 $this->ref_pk =
'wsp_id';
23 $this->obj_pk =
'obj_id';
24 $this->tree_pk =
'tree';
43 $next_id = $ilDB->nextId($this->table_obj_reference);
45 $fields = array($this->ref_pk => array(
"integer", $next_id),
46 $this->obj_pk => array(
"integer", $a_object_id));
48 $ilDB->insert($this->table_obj_reference, $fields);
63 $set = $ilDB->query(
"SELECT ".$this->obj_pk.
64 " FROM ".$this->table_obj_reference.
65 " WHERE ".$this->ref_pk.
" = ".$ilDB->quote($a_node_id,
"integer"));
66 $res = $ilDB->fetchAssoc($set);
84 $set = $ilDB->query(
"SELECT ".$this->ref_pk.
85 " FROM ".$this->table_obj_reference.
86 " WHERE ".$this->obj_pk.
" = ".$ilDB->quote($a_obj_id,
"integer"));
87 $res = $ilDB->fetchAssoc($set);
102 $set = $ilDB->query(
"SELECT tree".
103 " FROM ".$this->table_obj_reference.
104 " JOIN ".$this->table_tree.
" ON (".$this->table_obj_reference.
".".$this->ref_pk.
" = ".$this->table_tree.
".child)".
105 " WHERE ".$this->ref_pk.
" = ".$ilDB->quote($a_node_id,
"integer"));
106 $res = $ilDB->fetchAssoc($set);
121 $this->
insertNode($node_id, $a_parent_node_id);
135 $query =
"DELETE FROM ".$this->table_obj_reference.
136 " WHERE ".$this->ref_pk.
" = ".$ilDB->quote($a_node_id,
"integer");
137 return $ilDB->manipulate(
$query);
153 include_once
"Services/PersonalWorkspace/classes/class.ilWorkspaceAccessHandler.php";
158 foreach($nodes as $node)
160 $access_handler->removePermission($node[
"wsp_id"]);
195 $root =
new $root(null);