Go to the source code of this file.
Functions | |
| _lookupObjId ($a_id) | |
| if($result->numRows()) foreach($foundactive as $missingarray) | getNrOfResultsForPass ($test_id, $user_id, $pass) |
| getTextgapPoints ($gaprating, $a_original, $a_entered, $max_points) | |
Variables | |
| $q = "SELECT * FROM grp_tree WHERE ref_id = '-1'" | |
| $res = $this->db->query($q) | |
| $grp_data = array() | |
| $query = "VALUES ('typ', 'ldap', 'LDAP settings object', -1, now(), now())" | |
| $row = $res->fetchRow() | |
| $typ_id = $row[0] | |
| $obj_id = $row[0] | |
| $ref_id = $row[0] | |
| $left = $res->lft | |
| $lft = $left + 1 | |
| $rgt = $left + 2 | |
| $users = array() | |
| while($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) foreach($ops_ids as $id) | $query1 = "SELECT obj_id FROM object_data WHERE title = 'il_grp_member' " |
| $tpl = $res->fetchRow(DB_FETCHMODE_ASSOC) | |
| $query2 = "obj_id"] | |
| $rol_fold = $res->fetchRow(DB_FETCHMODE_ASSOC) | |
| $query3 = "' AND type = 'crs'" | |
| $query4 = "' AND type = 'frm' AND ops_id = 5 " | |
| $query5 = "' AND type = 'frm' AND ops_id = 6 " | |
| $query6 = "')" | |
| $query7 = "')" | |
| $query8 = "')" | |
| $query9 = "')" | |
| $query10 = "' AND type = 'grp' AND ops_id = 4 " | |
| $query11 = "')" | |
| $query12 = "')" | |
| $query13 = "' AND type = 'slm' AND ops_id = 5 " | |
| $query14 = "' AND type = 'slm' AND ops_id = 6 " | |
| $ini = new ilIniFile(ILIAS_ABSOLUTE_PATH."/ilias.ini.php") | |
| $migrate = true | |
| $page_set = $this->db->query($q) | |
| $rbacadmin = new ilRbacAdmin() | |
| $rbacreview = new ilRbacReview() | |
| $tree = new ilTree(ROOT_FOLDER_ID) | |
| $ilObjDef = new ilObjectDefinition() | |
| while($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) | $rbacsystem = & new ilRbacSystem() |
| $mem_role_id = $row[0] | |
| $ops_data ["chat"] = array(2,3) | |
| $ops_data ["file"] = array(2,3) | |
| $ops_data ["frm"] = array(2,3,4,9) | |
| $ops_data ["glo"] = array(2,3,7,8) | |
| $ops_data ["grp"] = array(2,3,7,8,18,25,26) | |
| $ops_data ["lm"] = array(2,3,7,8) | |
| $ops_data ["slm"] = array(2,3,7,8) | |
| $ops_data ["fold"] = array(2,3,18,25,26) | |
| $adm_role_id = $row[0] | |
| $adm_id = "obj_id"] | |
| $gl_set = $this->db->query($query) | |
| $perms | |
| $result = $this->db->query($query) | |
| $user_set = $this->db->query($q) | |
| $search_result = $this->db->query($query) | |
| $visible_id = "" | |
| $participate_id = "" | |
| $user_id = "" | |
| $guest_id = "" | |
| while($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) | $admin ["lm"] = array(1,2,3,4,6,7,8) |
| $admin ["slm"] = array(1,2,3,4,6,7,8) | |
| $admin ["dbk"] = array(1,2,3,4,6) | |
| $admin ["glo"] = array(1,2,3,4,6,7,8) | |
| $admin ["frm"] = array(1,2,3,4,6,9,10) | |
| $admin ["chat"] = array(1,2,3,4,6) | |
| $admin ["file"] = array(1,2,3,4,6) | |
| $admin ["tst"] = array(1,2,3,4,6) | |
| $admin ["grp"] = array(1,2,3,4,6,7,8,18,20,21,22,23,24,25,26,27,29,31) | |
| $admin ["exc"] = array(1,2,3,4,6) | |
| $admin ["fold"] = array(1,2,3,4,6,18,20,21,22,25,26,29) | |
| $admin ["crs"] = array(1,2,3,4,6,7,8,17,18,20,21,22,23,24,25,26,27,29,31,32) | |
| $d = opendir(CLIENT_WEB_DIR . "/assessment/") or die($php_errormsg) | |
| $type_id = $row[0] | |
| $tree_set = $this->db->query($q) | |
| $sty_folder_id = $row->id | |
| $ops_id = $res->ops_id | |
| $wd = getcwd() | |
| $webr_ids = array() | |
| global | $log |
| $idx = 1 | |
| $maxidx = $result->numRows() + 1 | |
| $tables | |
| $nested = new ilNestedSetXML() | |
| while($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) | $max_id = $max_id ? $max_id : 0 |
| $counter = 0 | |
| $icla_ops_id = $row->ops_id | |
| $admin ["icrs"] = array(1,2,3,4,6,7,8,$icla_ops_id) | |
| $admin ["rolf"] = array(1,2,3,4,6,14) | |
| $ilca_nodes = $tree->getNodeDataByType('icla') | |
| if(count($icla_nodes)!=0) | $ilcrs_nodes = $tree->getNodeDataByType('icrs') |
| $GLOBALS ['tree'] = $tree | |
| $GLOBALS ['ilLog'] = & $log | |
| $chat_id = $ilDB->getLastInsertId() | |
| $chat_ref_id = $ilDB->getLastInsertId() | |
| $rolf_id = $ilDB->getLastInsertId() | |
| $rolf_ref_id = $ilDB->getLastInsertId() | |
| $role_id = $ilDB->getLastInsertId() | |
| $permissions = ilRbacReview::_getOperationIdsByName(array('visible','read','moderate')) | |
| $file_ids = array() | |
| $new_ops_id = $ilDB->getLastInsertId() | |
| $fields = array('entity','date','description') | |
| $table = 'il_meta_annotation' | |
| $key = 'meta_annotation_id' | |
| $foundactive = array() | |
| if($result->numRows()) global | $ilLog |
| $lang_set = $ilDB->query($q) | |
Function Documentation
| _lookupObjId | ( | $ | a_id | ) |
Definition at line 8599 of file dbupdate.php.
References $row.
Referenced by ilObjContentObjectAccess::_getLastAccessedPage(), ilPersonalDesktopGUI::addParentRow(), ilAccessHandler::checkAccessOfUser(), ilLMPresentationGUI::getLinkXML(), ilLMPageObjectGUI::getLinkXML(), ilGlossaryPresentationGUI::getLinkXML(), ilSCORMPresentationGUI::launchSahs(), ilHACPPresentationGUI::launchSahs(), ilSAHSPresentationGUI::launchSahs(), ilAICCPresentationGUI::launchSahs(), ilObjHACPTracking::putparam(), ilAccountMail::replacePlaceholders(), ilMainMenuGUI::setTemplateVars(), and ilObjSCORMTracking::store().
{
global $ilDB;
$query = "SELECT obj_id FROM object_reference ".
"WHERE ref_id = '".$a_id."'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
return $row->obj_id;
}
return 0;
}
// Fix chat reference bug
$query = "SELECT * FROM chat_records ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ilDB->query("UPDATE chat_records SET chat_id = '".
_lookupObjId($row->chat_id)."' WHERE record_id = '".$row->record_id."'");
}
$query = "SELECT * FROM chat_room_messages ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ilDB->query("UPDATE chat_room_messages SET chat_id = '".
_lookupObjId($row->chat_id)."' WHERE entry_id = '".$row->entry_id."'");
}
$query = "SELECT * FROM chat_rooms ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ilDB->query("UPDATE chat_rooms SET chat_id = '".
_lookupObjId($row->chat_id)."' WHERE room_id = '".$row->room_id."'");
}
$ilDB->query("DELETE FROM chat_user");
?>
<#532>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#533>
<?php
global $log;
$GLOBALS['ilLog'] =& $log;
// add chat below ChatSettings for personal desktop chat
// Get chat settings id
$query = "SELECT * FROM object_data LEFT JOIN object_reference USING(obj_id) WHERE type = 'chac'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$chac_ref_id = $row->ref_id;
}
$query = "INSERT INTO object_data ".
"(type,title,description,owner,create_date,last_update,import_id) ".
"VALUES ".
"('chat','Public chat','Public chat',".
"'6',now(),now(),'')";
$ilDB->query($query);
$chat_id = $ilDB->getLastInsertId();
// Create reference
$query = "INSERT INTO object_reference ".
"(obj_id) VALUES ('".$chat_id."')";
$ilDB->query($query);
$chat_ref_id = $ilDB->getLastInsertId();
// put in tree
$tree =& new ilTree(ROOT_FOLDER_ID);
$tree->insertNode($chat_ref_id,$chac_ref_id);
// Create role folder
$query = "INSERT INTO object_data ".
"(type,title,description,owner,create_date,last_update,import_id) ".
"VALUES ".
"('rolf','".$chat_id."','(ref_id ".$chat_ref_id.")',".
"'6',now(),now(),'')";
$ilDB->query($query);
$rolf_id = $ilDB->getLastInsertId();
// Create reference
$query = "INSERT INTO object_reference ".
"(obj_id) VALUES ('".$rolf_id."')";
$ilDB->query($query);
$rolf_ref_id = $ilDB->getLastInsertId();
// put in tree
$tree->insertNode($rolf_ref_id,$chat_ref_id);
// Create role
$query = "INSERT INTO object_data ".
"(type,title,description,owner,create_date,last_update,import_id) ".
"VALUES ".
"('role','il_chat_moderator_".$chat_ref_id."','Moderator of chat obj_no.".$chat_id."',".
"'6',now(),now(),'')";
$ilDB->query($query);
$role_id = $ilDB->getLastInsertId();
// Insert role_data
$query = "INSERT INTO role_data set role_id = '".$role_id."'";
$ilDB->query($query);
$permissions = ilRbacReview::_getOperationIdsByName(array('visible','read','moderate'));
$rbacadmin = new ilRbacAdmin();
$rbacadmin->grantPermission($role_id,
$permissions,
$chat_ref_id);
$rbacadmin->assignRoleToFolder($role_id,$rolf_ref_id);
?>
<#534>
ALTER TABLE `qpl_questions` ADD `textgap_rating` ENUM( 'ci', 'cs', 'l1', 'l2', 'l3', 'l4', 'l5' ) AFTER `maxNumOfChars` ;
<#535>
CREATE TABLE `qpl_questionpool` (
`id_questionpool` INT NOT NULL AUTO_INCREMENT ,
`obj_fi` INT NOT NULL ,
`online` ENUM( '0', '1' ) NOT NULL ,
`TIMESTAMP` TIMESTAMP NOT NULL ,
PRIMARY KEY ( `id_questionpool` ) ,
INDEX ( `obj_fi` )
);
<#536>
<?php
// set all existing test question pools online
$query = "SELECT * FROM object_data WHERE type = 'qpl'";
$result = $ilDB->query($query);
if ($result->numRows() > 0)
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$checkquery = sprintf("SELECT id_questionpool FROM qpl_questionpool WHERE obj_fi = %s",
$ilDB->quote($row["obj_id"] . "")
);
$checkresult = $ilDB->query($checkquery);
if ($checkresult->numRows() == 0)
{
$insertquery = sprintf("INSERT INTO qpl_questionpool (online, obj_fi) VALUES ('1', %s)",
$ilDB->quote($row["obj_id"] . "")
);
$insertresult = $ilDB->query($insertquery);
}
}
}
?>
<#537>
CREATE TABLE `survey_questionpool` (
`id_questionpool` INT NOT NULL AUTO_INCREMENT ,
`obj_fi` INT NOT NULL ,
`online` ENUM( '0', '1' ) NOT NULL ,
`TIMESTAMP` TIMESTAMP NOT NULL ,
PRIMARY KEY ( `id_questionpool` ) ,
INDEX ( `obj_fi` )
);
<#538>
<?php
// set all existing test question pools online
$query = "SELECT * FROM object_data WHERE type = 'spl'";
$result = $ilDB->query($query);
if ($result->numRows() > 0)
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$checkquery = sprintf("SELECT id_questionpool FROM survey_questionpool WHERE obj_fi = %s",
$ilDB->quote($row["obj_id"] . "")
);
$checkresult = $ilDB->query($checkquery);
if ($checkresult->numRows() == 0)
{
$insertquery = sprintf("INSERT INTO survey_questionpool (online, obj_fi) VALUES ('1', %s)",
$ilDB->quote($row["obj_id"] . "")
);
$insertresult = $ilDB->query($insertquery);
}
}
}
?>
<#539>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#540>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#541>
CREATE TABLE IF NOT EXISTS `webr_params` (
`param_id` int(11) NOT NULL auto_increment,
`webr_id` int(11) NOT NULL default '0',
`link_id` int(11) NOT NULL default '0',
`name` char(128) NOT NULL default '',
`value` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`param_id`),
KEY `link_id` (`link_id`)
) TYPE = MyISAM;
<#542>
ALTER TABLE bookmark_data ADD description varchar(255) NOT NULL DEFAULT '' AFTER title;
<#543>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#544>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#545>
ALTER TABLE note ADD subject varchar(200) NOT NULL DEFAULT '';
<#546>
INSERT INTO `tst_test_type` ( `test_type_id` , `type_tag` ) VALUES ('5', 'tt_varying_randomtest');
ALTER TABLE `tst_solutions` ADD `pass` INT DEFAULT '0' NOT NULL AFTER `points` ;
ALTER TABLE `tst_test_random_question` ADD `pass` INT DEFAULT '0' NOT NULL AFTER `sequence` ;
ALTER TABLE `tst_test_result` ADD `pass` INT DEFAULT '0' NOT NULL AFTER `points` ;
<#547>
ALTER TABLE object_reference ADD COLUMN deleted datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
<#548>
CREATE INDEX obj_del ON object_reference(deleted);
<#549>
<?php
$query = "SELECT * FROM tree WHERE tree < 0";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$q = "UPDATE object_reference SET deleted=now() WHERE ref_id='".
$row["child"]."'";
$ilDB->query($q);
}
?>
<#550>
ALTER TABLE `tst_tests` ADD `hide_previous_results` ENUM( '0', '1' ) DEFAULT '0' NOT NULL AFTER `nr_of_tries` ;
<#551>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#552>
ALTER TABLE `frm_settings` ADD `anonymized` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `default_view`;
<#553>
CREATE TABLE IF NOT EXISTS `ut_learning_progress` (
`lp_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`obj_type` char(4) NOT NULL default '',
`obj_id` int(11) NOT NULL default '0',
`spent_time` int(10) NOT NULL default '0',
`access_time` int(10) NOT NULL default '0',
`visits` int(4) NOT NULL default '0',
PRIMARY KEY (`lp_id`),
KEY `user_obj` (`user_id`,`obj_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
<#554>
CREATE TABLE IF NOT EXISTS `ut_login` (
`usr_id` int(11) NOT NULL default '0',
`login_time` int(10) NOT NULL default '0'
) TYPE=MyISAM;
<#555>
CREATE TABLE IF NOT EXISTS `ut_lp_filter` (
`lpf_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`shown` text NOT NULL,
`hidden` text NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`lpf_id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
<#556>
CREATE TABLE IF NOT EXISTS `ut_lp_settings` (
`lps_id` int(11) NOT NULL auto_increment,
`obj_id` int(11) NOT NULL default '0',
`obj_type` char(4) NOT NULL default '',
`mode` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`lps_id`),
KEY `obj_id` (`obj_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
<#557>
CREATE TABLE `frm_notification` (
`notification_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`frm_id` int(11) NOT NULL default '0',
`thread_id` int(11) NOT NULL default '0',
PRIMARY KEY (`notification_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
<#558>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#559>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#560>
ALTER TABLE `tst_tests` ADD `pass_scoring` ENUM( '0', '1' ) DEFAULT '0' NOT NULL AFTER `mc_scoring` ;
<#561>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#562>
ALTER TABLE `tst_test_result` DROP INDEX `user_fi` , ADD UNIQUE `user_fi` ( `user_fi` , `test_fi` , `question_fi` , `pass` );
<#563>
<?php
// set user's style to delos (if it has been blueshadow)
$query = "SELECT u1.usr_id, u1.value as skin, u2.value as style ".
"FROM usr_pref AS u1, usr_pref AS u2 ".
"WHERE u1.usr_id = u2.usr_id AND u1.keyword = 'skin' AND u2.keyword = 'style' ";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
if (($row["skin"] == "default" && $row["style"] == "blueshadow") ||
$row["skin"] == "blueshadow2" && $row["style"] == "blueshadow2")
{
$q = "UPDATE usr_pref SET value = 'default' WHERE ".
" usr_id = '".$row["usr_id"]."' AND ".
" keyword = 'skin'";
$ilDB->query($q);
$q = "UPDATE usr_pref SET value = 'delos' WHERE ".
" usr_id = '".$row["usr_id"]."' AND ".
" keyword = 'style'";
$ilDB->query($q);
}
}
?>
<#564>
<?php
// set system default style to delos (if it has been blueshadow)
$ini = new ilIniFile(CLIENT_WEB_DIR."/client.ini.php");
$ini->read();
if (($ini->readVariable("layout","skin") == "default" &&
$ini->readVariable("layout","style") == "blueshadow") ||
($ini->readVariable("layout","skin") == "blueshadow2" &&
$ini->readVariable("layout","style") == "blueshadow2"))
{
$ini->setVariable("layout", "skin", "default");
$ini->setVariable("layout", "style", "delos");
$ini->write();
}
?>
<#565>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#566>
CREATE TABLE style_data
(
id INT NOT NULL,
uptodate TINYINT(2) DEFAULT 0
);
<#567>
<?php
// create style data record for each style
$query = "SELECT * FROM object_data ".
"WHERE type='sty' ";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$q = "INSERT INTO style_data (id, uptodate) VALUES ".
"('".$row["obj_id"]."','0')";
$ilDB->query($q);
}
?>
<#568>
ALTER TABLE `rbac_fa` ADD `protected` ENUM( 'y', 'n' ) DEFAULT 'n';
UPDATE rbac_fa SET protected = 'y' WHERE rol_id = '2';
<#569>
<?php
// set admin templates to protected status
$query = "SELECT * FROM object_data WHERE type='rolt' AND title IN ('il_crs_admin','il_icrs_admin','il_grp_admin','Local Administrator')";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$q = "UPDATE rbac_fa SET protected='y' WHERE rol_id='".$row["obj_id"]."'";
$ilDB->query($q);
}
?>
<#570>
ALTER TABLE `ut_lp_settings`
DROP `lps_id`;
<#571>
ALTER TABLE `ut_lp_settings` DROP INDEX `obj_id`,
ADD PRIMARY KEY ( `obj_id` );
<#572>
CREATE TABLE IF NOT EXISTS `ut_lp_collections` (
`obj_id` int(11) NOT NULL default '0',
`item_id` int(11) NOT NULL default '0',
KEY `obj_id` (`obj_id`,`item_id`)
) TYPE=MyISAM;
<#573>
DELETE FROM tst_test_type WHERE type_tag = 'tt_navigation_controlling';
UPDATE tst_tests SET test_type_fi = 1 WHERE test_type_fi = 3;
<#574>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#575>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#576>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#577>
ALTER TABLE `ut_lp_settings` ADD `visits` INT( 4 ) DEFAULT '0' AFTER `mode`;
<#578>
ALTER TABLE `content_object` ADD `downloads_public_active` ENUM('y','n') DEFAULT 'y' NOT NULL AFTER `downloads_active`;
<#579>
ALTER TABLE `tst_tests` ADD `hide_title_points` ENUM( '0', '1' ) DEFAULT '0' NOT NULL AFTER `hide_previous_results` ;
<#580>
ALTER TABLE `ut_login` RENAME `ut_online`;
<#581>
ALTER TABLE `ut_online` ADD PRIMARY KEY ( `usr_id` );
<#582>
ALTER TABLE `ut_online` CHANGE `login_time` `online_time` INT( 11 ) NOT NULL DEFAULT '0';
<#583>
ALTER TABLE `ut_online` ADD `access_time` INT( 10 ) NOT NULL ;
<#584>
ALTER TABLE `il_meta_format`
DROP `parent_type`,
DROP `parent_id`;
<#585>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#586>
ALTER TABLE file_data ADD mode char(8) DEFAULT 'object';
<#587>
<?php
// set admin templates to protected status
$query = "SELECT * FROM file_data";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$q2 = "SELECT * FROM file_usage WHERE id = ".$ilDB->quote($row["file_id"]);
$r2 = $ilDB->query($q2);
if ($dummy = $r2->fetchRow(DB_FETCHMODE_ASSOC))
{
$q3 = "UPDATE file_data SET mode=".$ilDB->quote("filelist").
" WHERE file_id = ".$row["file_id"];
$ilDB->query($q3);
}
}
?>
<#588>
<?php
$wd = getcwd();
chdir('..');
include_once 'Services/Migration/DBUpdate_426/classes/class.ilMDCreator.php';
include_once 'Services/Migration/DBUpdate_426/classes/class.ilMD.php';
$file_ids = array();
$query = "SELECT file_type, title, description, obj_id, file_id, file_name, version".
" FROM file_data, object_data WHERE mode = 'object'".
" AND file_data.file_id = object_data.obj_id";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
{
$md_creator = new ilMDCreator($row["obj_id"], $row["obj_id"], 'file');
$md_creator->setTitle($row['title']);
$md_creator->setTitleLanguage('');
$md_creator->setDescription($row['description']);
$md_creator->setDescriptionLanguage('');
$md_creator->setLanguage('');
$md_creator->create();
//echo "<br>file:".$row["obj_id"].":".$row["title"].":".$row["description"].":".$row["file_type"].":";
$file = CLIENT_DATA_DIR."/files/file_".$row["obj_id"]."/".$row["file_name"];
if (@!is_file($file))
{
$version_subdir = "/".sprintf("%03d", $row["version"]);
$file = CLIENT_DATA_DIR."/files/file_".$row["obj_id"].$version_subdir."/".$row["file_name"];
}
if (is_file($file))
{
$size = filesize($file);
}
else
{
$size = 0;
}
// create technical section
$md_obj =& new ilMD($row["obj_id"], $row["obj_id"], 'file');;
$technical = $md_obj->addTechnical();
$technical->setSize($size);
$technical->save();
$format = $technical->addFormat();
$format->setFormat($row["file_type"]);
$format->save();
$technical->update();
}
chdir($wd);
?>
<#589>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#590>
ALTER TABLE `survey_survey` CHANGE `evaluation_access` `evaluation_access` ENUM( '0', '1', '2' ) DEFAULT '0' NOT NULL;
<#591>
ALTER TABLE `rbac_operations` ADD `class` ENUM('create','general','object','rbac','admin','notused') DEFAULT 'notused' NOT NULL, ADD `op_order` SMALLINT UNSIGNED;
<#592>
<?php
$query = "SELECT * FROM rbac_operations";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch($row['operation'])
{
case 'visible':
case 'read':
case 'write':
case 'delete':
$perm_class = 'general';
break;
case 'join':
case 'leave':
case 'edit_post':
case 'delete_post':
case 'smtp_mail':
case 'system_message':
case 'cat_administrate_users':
case 'edit_roleassignment':
case 'edit_userassignment':
case 'invite':
case 'mail_visible':
case 'moderate':
case 'participate':
case 'push_desktop_items':
case 'read_users':
case 'search':
case 'leave':
$perm_class = 'object';
break;
case 'edit_permission':
$perm_class = 'rbac';
break;
case 'create_cat':
case 'create_chat':
case 'create_crs':
case 'create_dbk':
case 'create_exc':
case 'create_file':
case 'create_fold':
case 'create_frm':
case 'create_glo':
case 'create_grp':
case 'create_htlm':
case 'create_icla':
case 'create_icrs':
case 'create_lm':
case 'create_mep':
case 'create_qpl':
case 'create_role':
case 'create_rolt':
case 'create_sahs':
case 'create_spl':
case 'create_svy':
case 'create_tax':
case 'create_tst':
case 'create_user':
case 'create_webr':
$perm_class = 'create';
break;
default:
$perm_class = 'notused';
break;
}
$q2 = "UPDATE rbac_operations SET class='".$perm_class."' WHERE operation = '".$row['operation']."'";
$ilDB->query($q2);
}
$query = "UPDATE rbac_operations SET op_order='100' WHERE operation='visible'";
$ilDB->query($query);
$query = "UPDATE rbac_operations SET op_order='110' WHERE operation='read'";
$ilDB->query($query);
$query = "UPDATE rbac_operations SET op_order='120' WHERE operation='write'";
$ilDB->query($query);
$query = "UPDATE rbac_operations SET op_order='130' WHERE operation='delete'";
$ilDB->query($query);
$ilCtrlStructureReader->getStructure();
?>
<#593>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#594>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#595>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#596>
DROP TABLE `ut_lp_filter`;
CREATE TABLE `ut_lp_filter` (
`usr_id` int(11) NOT NULL default '0',
`filter_type` varchar(4) NOT NULL default '',
`root_node` int(11) NOT NULL default '0',
`hidden` text NOT NULL,
`query_string` varchar(128) NOT NULL default '',
PRIMARY KEY (`usr_id`)
) TYPE=MyISAM;
<#597>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#598>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#599>
CREATE table ctrl_structure
(
root_class varchar(40) NOT NULL PRIMARY KEY,
call_node MEDIUMTEXT,
forward MEDIUMTEXT,
parent MEDIUMTEXT
) TYPE=MyISAM;
<#600>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#601>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#602>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#603>
<?php
// Add operation edit_learing_progress
$query = "INSERT INTO rbac_operations SET operation = 'edit_learning_progress', ".
"description = 'edit learning progress', ".
"class = 'object'";
$res = $ilDB->query($query);
$new_ops_id = $ilDB->getLastInsertId();
// Get type ids of 'lm', 'dbk', 'sahs', 'htlm' ,'tst' and 'crs'
$query = "SELECT obj_id FROM object_data WHERE title IN ('lm','dbk','sahs','htlm','tst','crs') ".
"AND type = 'typ'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$type_ids[] = $row->obj_id;
}
// ASSIGN new operation to object types
foreach($type_ids as $typ_id)
{
$query = "INSERT INTO rbac_ta SET typ_id = '".$typ_id."', ".
"ops_id = '".$new_ops_id."'";
$ilDB->query($query);
}
// get template il_crs_admin Author and Local Administrator
$query = "SELECT obj_id FROM object_data WHERE title IN ('il_crs_admin','Author','Local Administrator') ".
"AND type = 'rolt'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$rolt_ids[] = $row->obj_id;
}
// ASSIGN new operation to role templates
foreach($rolt_ids as $rolt_id)
{
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'lm', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'tst', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'dbk', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'sahs', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'htlm', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'crs', ".
"ops_id = '".$new_ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
}
?>
<#604>
CREATE TABLE IF NOT EXISTS `ut_lp_marks` (
`obj_id` int(11) NOT NULL default '0',
`mark` char(32) NOT NULL default '',
`comment` char(255) NOT NULL default '',
PRIMARY KEY (`obj_id`)
) Type=MyISAM;
<#605>
DROP TABLE IF EXISTS `ut_lp_marks`;
CREATE TABLE `ut_lp_marks` (
`obj_id` int(11) NOT NULL default '0',
`usr_id` int(11) NOT NULL default '0',
`completed` int(1) NOT NULL default '0',
`mark` char(32) NOT NULL default '',
`comment` char(255) NOT NULL default '',
PRIMARY KEY (`obj_id`)
) Type=MyISAM;
<#606>
DROP TABLE `ut_lp_filter`;
CREATE TABLE `ut_lp_filter` (
`usr_id` int(11) NOT NULL default '0',
`filter_type` varchar(4) NOT NULL default '',
`root_node` int(11) NOT NULL default '0',
`hidden` text NOT NULL,
`query_string` varchar(128) NOT NULL default '',
PRIMARY KEY (`usr_id`)
) TYPE=MyISAM;
<#607>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#608>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#609>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#610>
DROP TABLE IF EXISTS `ut_lp_marks`;
CREATE TABLE `ut_lp_marks` (
`obj_id` int(11) NOT NULL default '0',
`usr_id` int(11) NOT NULL default '0',
`completed` int(1) NOT NULL default '0',
`mark` char(32) NOT NULL default '',
`comment` char(255) NOT NULL default '',
PRIMARY KEY (`obj_id`,`usr_id`),
KEY `obj_usr` (`obj_id`,`usr_id`)
) Type=MyISAM;
<#611>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#612>
<?php
// get all ref ids in scorm tracking
$query = "SELECT DISTINCT ref_id FROM scorm_tracking";
$res = $ilDB->query($query);
while($rec = $res->fetchRow(DB_FETCHMODE_ASSOC))
{
$q2 = "SELECT * FROM object_reference WHERE ref_id = ".
$ilDB->quote($rec["ref_id"]);
$res2 = $ilDB->query($q2);
$rec2 = $res2->fetchRow(DB_FETCHMODE_ASSOC);
$q3 = "UPDATE scorm_tracking SET ref_id= ".
$ilDB->quote($rec2["obj_id"]). " WHERE ".
" ref_id = ".$ilDB->quote($rec["ref_id"]);
$ilDB->query($q3);
}
?>
<#613>
ALTER TABLE scorm_tracking CHANGE ref_id obj_id INT;
<#614>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#615>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#616>
CREATE TABLE `feedback_items` (
`fb_id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`description` text,
`anonymous` tinyint(1) NOT NULL default '1',
`required` tinyint(1) default '0',
`show_on` varchar(6) default NULL,
`text_answer` tinyint(1) default '0',
`votes` text,
`starttime` int(11) default '0',
`endtime` int(11) default '0',
`repeat_interval` int(11) default NULL,
`interval_unit` tinyint(4) default NULL,
`first_vote_best` tinyint(1) default '0',
`obj_id` int(11) default '0',
`ref_id` int(11) default '0',
PRIMARY KEY (`fb_id`)
) TYPE=MyISAM ;
<#617>
CREATE TABLE `feedback_results` (
`fb_id` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`vote` int(11) NOT NULL default '0',
`note` text NOT NULL,
`votetime` int(11) NOT NULL default '0'
) TYPE=MyISAM;
<#618>
ALTER TABLE `frm_user_read` ADD INDEX `obj_usr` ( `obj_id`,`usr_id`);
<#619>
ALTER TABLE `frm_user_read` ADD INDEX `post_usr` ( `post_id` , `usr_id`);
<#620>
ALTER TABLE `frm_thread_access` ADD INDEX `usr_thread` ( `thread_id` , `usr_id`);
<#621>
ALTER TABLE `frm_posts` ADD INDEX ( `pos_thr_fk` );
<#622>
ALTER TABLE `frm_posts` ADD INDEX ( `pos_top_fk`);
<#623>
ALTER TABLE `crs_settings` ADD `waiting_list` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
<#624>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#625>
ALTER TABLE `tst_eval_users` DROP INDEX `test_fi_2`;
ALTER TABLE `tst_eval_users` DROP INDEX `user_fi`;
ALTER TABLE `tst_eval_users` DROP INDEX `evaluator_fi`;
ALTER TABLE `tst_eval_users` DROP INDEX `test_fi`;
ALTER TABLE `tst_eval_users` ADD INDEX ( `test_fi` , `evaluator_fi` , `user_fi` ) ;
DROP TABLE `tst_eval_groups`;
<#626>
ALTER TABLE `tst_eval_users` DROP `eval_users_id`;
ALTER TABLE `tst_eval_users` DROP `TIMESTAMP`;
<#627>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#628>
DROP TABLE IF EXISTS `user_defined_field_definition`;
CREATE TABLE `user_defined_field_definition` (
`field_id` int(3) NOT NULL auto_increment,
`field_name` tinytext NOT NULL,
`field_type` tinyint(1) NOT NULL default '0',
`field_values` text NOT NULL,
`visible` tinyint(1) NOT NULL default '0',
`changeable` tinyint(1) NOT NULL default '0',
`required` tinyint(1) NOT NULL default '0',
`searchable` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`field_id`)
) TYPE = MyISAM;
<#629>
DROP TABLE IF EXISTS `usr_defined_data`;
CREATE TABLE `usr_defined_data` (
`usr_id` int(11) NOT NULL default '0',
PRIMARY KEY (`usr_id`)
) TYPE = MyISAM;
<#630>
<?php
$query = "SELECT DISTINCT usr_id FROM usr_data";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$query = "INSERT INTO usr_defined_data ".
"SET usr_id = '".$row->usr_id."'";
$ilDB->query($query);
}
?>
<#631>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#632>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#633>
ALTER TABLE `frm_settings` ADD COLUMN `statistics_enabled` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `anonymized`;
?>
<#634>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#635>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('entity','date','description');
$table = 'il_meta_annotation';
$key = 'meta_annotation_id';
ilMDConvert($table,$fields,$key);
?>
<#636>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('purpose','description');
$table = 'il_meta_classification';
$key = 'meta_classification_id';
ilMDConvert($table,$fields,$key);
?>
<#637>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('role','date');
$table = 'il_meta_contribute';
$key = 'meta_contribute_id';
ilMDConvert($table,$fields,$key);
?>
<#638>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('description');
$table = 'il_meta_description';
$key = 'meta_description_id';
ilMDConvert($table,$fields,$key);
?>
<#639>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('interactivity_type','learning_resource_type','interactivity_level','semantic_density','intended_end_user_role',
'context','difficulty','typical_learning_time');
$table = 'il_meta_educational';
$key = 'meta_educational_id';
ilMDConvert($table,$fields,$key);
?>
<#640>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('entity');
$table = 'il_meta_entity';
$key = 'meta_entity_id';
ilMDConvert($table,$fields,$key);
?>
<#641>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('format');
$table = 'il_meta_format';
$key = 'meta_format_id';
ilMDConvert($table,$fields,$key);
?>
<#642>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('general_structure','title','coverage');
$table = 'il_meta_general';
$key = 'meta_general_id';
ilMDConvert($table,$fields,$key);
?>
<#643>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('catalog','entry');
$table = 'il_meta_identifier';
$key = 'meta_identifier_id';
ilMDConvert($table,$fields,$key);
?>
<#644>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('catalog','entry');
$table = 'il_meta_identifier_';
$key = 'meta_identifier__id';
ilMDConvert($table,$fields,$key);
?>
<#645>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('keyword');
$table = 'il_meta_keyword';
$key = 'meta_keyword_id';
ilMDConvert($table,$fields,$key);
?>
<#646>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('language');
$table = 'il_meta_language';
$key = 'meta_language_id';
ilMDConvert($table,$fields,$key);
?>
<#647>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('lifecycle_status','meta_version','version_language');
$table = 'il_meta_lifecycle';
$key = 'meta_lifecycle_id';
ilMDConvert($table,$fields,$key);
?>
<#648>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('location','location_type');
$table = 'il_meta_location';
$key = 'meta_location_id';
ilMDConvert($table,$fields,$key);
?>
<#649>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('meta_data_scheme','language');
$table = 'il_meta_meta_data';
$key = 'meta_meta_data_id';
ilMDConvert($table,$fields,$key);
?>
<#650>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('kind');
$table = 'il_meta_relation';
$key = 'meta_relation_id';
ilMDConvert($table,$fields,$key);
?>
<#651>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('operating_system_name','operating_system_minimum_version','operating_system_maximum_version',
'browser_name','browser_minimum_version','browser_maximum_version');
$table = 'il_meta_requirement';
$key = 'meta_requirement_id';
ilMDConvert($table,$fields,$key);
?>
<#652>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('description','costs','copyright_and_other_restrictions');
$table = 'il_meta_rights';
$key = 'meta_rights_id';
ilMDConvert($table,$fields,$key);
?>
<#653>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('taxon','taxon_id');
$table = 'il_meta_taxon';
$key = 'meta_taxon_id';
ilMDConvert($table,$fields,$key);
?>
<#654>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('source','source_language');
$table = 'il_meta_taxon_path';
$key = 'meta_taxon_path_id';
ilMDConvert($table,$fields,$key);
?>
<#655>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('size','installation_remarks','other_platform_requirements','duration');
$table = 'il_meta_technical';
$key = 'meta_technical_id';
ilMDConvert($table,$fields,$key);
?>
<#656>
<?php
include_once '../Services/Migration/DBUpdate_635/inc.meta_data_converter.php';
$fields = array('typical_age_range','typical_age_range_max','typical_age_range_min');
$table = 'il_meta_typical_age_range';
$key = 'meta_typical_age_range_id';
ilMDConvert($table,$fields,$key);
?>
<#657>
ALTER TABLE `il_meta_general` CHANGE `title` `title` TEXT NULL DEFAULT NULL;
ALTER TABLE `il_meta_location` CHANGE `parent_type` `parent_type` VARCHAR( 16 ) NULL;
<#658>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#659>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#660>
INSERT INTO rbac_ta (typ_id, ops_id) VALUES ('15','17');
<#661>
<?php
// reconstruct accidently deleted tst_active datasets when "delete selected user datasets"
// in test maintenance was used
// collect all the missing tst_active datasets in $foundactive
$foundactive = array();
$query = "SELECT DISTINCT concat( tst_test_result.user_fi, '_', tst_test_result.test_fi ) ".
", tst_test_result.user_fi, tst_test_result.test_fi, tst_active.user_fi AS active1, " .
"tst_active.test_fi AS active2, tst_tests.random_test FROM tst_tests, tst_test_result " .
"LEFT JOIN tst_active ON concat( tst_active.user_fi, '_', tst_active.test_fi ) = " .
"concat( tst_test_result.user_fi, '_', tst_test_result.test_fi ) ".
"WHERE isnull( tst_active.user_fi ) ".
"AND tst_test_result.test_fi = tst_tests.test_id";
$result = $ilDB->query($query);
if ($result->numRows())
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
array_push($foundactive, array($row["test_fi"], $row["user_fi"], $row["random_test"]));
}
}
// reconstruct the missing datasets
foreach ($foundactive as $missingarray)
{
$test_id = $missingarray[0];
$user_id = $missingarray[1];
$is_random = $missingarray[2];
// begin reconstruction
$found = 0;
if ($is_random)
{
// get number of questions in the test
$query = sprintf("SELECT test_random_question_id FROM tst_test_random_question WHERE test_fi = %s AND user_fi = %s AND pass = 0",
$ilDB->quote($test_id . ""),
$ilDB->quote($user_id . "")
);
$result = $ilDB->query($query);
$found = $result->numRows();
}
else
{
// get number of questions in the test
$query = sprintf("SELECT test_question_id FROM tst_test_question WHERE test_fi = %s",
$ilDB->quote($test_id . "")
);
$result = $ilDB->query($query);
$found = $result->numRows();
}
if ($is_random)
{
// get maximum pass
$query = sprintf("SELECT MAX(pass) AS maxpass FROM tst_test_random_question WHERE user_fi = %s AND test_fi = %s",
$ilDB->quote($user_id . ""),
$ilDB->quote($test_id . "")
);
}
else
{
// get maximum pass
$query = sprintf("SELECT MAX(pass) AS maxpass FROM tst_test_result WHERE user_fi = %s AND test_fi = %s",
$ilDB->quote($user_id . ""),
$ilDB->quote($test_id . "")
);
}
$result = $ilDB->query($query);
if ($result->numRows())
{
$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
$pass = $row["maxpass"];
$sequencearray = array();
for ($i = 1; $i <= $found; $i++) array_push($sequencearray, $i);
// re-add tst_active
$query = sprintf("INSERT INTO tst_active (user_fi, test_fi, sequence, lastindex, tries) VALUES (%s, %s, %s, %s, %s)",
$ilDB->quote($user_id . ""),
$ilDB->quote($test_id . ""),
$ilDB->quote(join(",",$sequencearray)),
$ilDB->quote("1"),
$ilDB->quote($pass . "")
);
$ilDB->query($query);
}
}
Here is the caller graph for this function:
| if ($result->numRows()) foreach ($foundactive as $missingarray) getNrOfResultsForPass | ( | $ | test_id, | |
| $ | user_id, | |||
| $ | pass | |||
| ) |
Definition at line 9868 of file dbupdate.php.
{
global $ilDB;
$query = sprintf("SELECT test_result_id FROM tst_test_result WHERE test_fi = %s AND user_fi = %s AND pass = %s",
$ilDB->quote($test_id . ""),
$ilDB->quote($user_id . ""),
$ilDB->quote($pass . "")
);
$result = $ilDB->query($query);
return $result->numRows();
}
global $log;
$query = "SELECT * FROM tst_active WHERE tries > 1";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$tries = $row["tries"];
while ((getNrOfResultsForPass($row["test_fi"], $row["user_fi"], $tries-1) == 0) && ($tries > 0))
{
$tries--;
}
if ($tries < $row["tries"])
{
$updatequery = sprintf("UPDATE tst_active SET tries = %s WHERE active_id = %s",
$ilDB->quote($tries . ""),
$ilDB->quote($row["active_id"] . "")
);
$ilDB->query($updatequery);
$log->write("Update step #662: set tst_active.tries from ".$row["tries"]." to $tries for tst_active.active_id = " . $row["active_id"]);
}
}
| getTextgapPoints | ( | $ | gaprating, | |
| $ | a_original, | |||
| $ | a_entered, | |||
| $ | max_points | |||
| ) |
Definition at line 9915 of file dbupdate.php.
{
$result = 0;
switch ($gaprating)
{
case "ci":
if (strcmp(strtolower($a_original), strtolower($a_entered)) == 0) $result = $max_points;
break;
case "cs":
if (strcmp($a_original, $a_entered) == 0) $result = $max_points;
break;
case "l1":
if (levenshtein($a_original, $a_entered) <= 1) $result = $max_points;
break;
case "l2":
if (levenshtein($a_original, $a_entered) <= 2) $result = $max_points;
break;
case "l3":
if (levenshtein($a_original, $a_entered) <= 3) $result = $max_points;
break;
case "l4":
if (levenshtein($a_original, $a_entered) <= 4) $result = $max_points;
break;
case "l5":
if (levenshtein($a_original, $a_entered) <= 5) $result = $max_points;
break;
}
return $result;
}
global $log;
$log->write("test&assessment text grap rating: starting with conversion. updating database entries for reached points of every user for every processed question");
// update code
$idx = 1;
$query = "SELECT question_id, question_type_fi, textgap_rating FROM qpl_questions WHERE question_type_fi = 3 AND textgap_rating <> 'ci'";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$queryanswers = sprintf("SELECT * FROM qpl_answers WHERE question_fi = %s ORDER BY gap_id, aorder ASC",
$ilDB->quote($row["question_id"] . "")
);
$resultanswers = $ilDB->query($queryanswers);
$answers = array();
while ($rowanswer = $resultanswers->fetchRow(DB_FETCHMODE_ASSOC))
{
array_push($answers, $rowanswer);
}
$querytests = sprintf("SELECT DISTINCT test_fi FROM tst_solutions WHERE question_fi = %s",
$ilDB->quote($row["question_id"] . "")
);
$resulttests = $ilDB->query($querytests);
$tests = array();
while ($rowtest = $resulttests->fetchRow(DB_FETCHMODE_ASSOC))
{
array_push($tests, $rowtest["test_fi"]);
}
foreach ($tests as $test_id)
{
$queryusers = sprintf("SELECT DISTINCT user_fi FROM tst_solutions WHERE test_fi = %s AND question_fi = %s",
$ilDB->quote($test_id . ""),
$ilDB->quote($row["question_id"])
);
$resultusers = $ilDB->query($queryusers);
$users = array();
while ($rowuser = $resultusers->fetchRow(DB_FETCHMODE_ASSOC))
{
array_push($users, $rowuser["user_fi"]);
}
// now begin the conversion
foreach ($users as $user_id)
{
$querysolutions = sprintf("SELECT * FROM tst_solutions WHERE test_fi = %s AND user_fi = %s AND question_fi = %s",
$ilDB->quote($test_id . ""),
$ilDB->quote($user_id . ""),
$ilDB->quote($row["question_id"] . "")
);
$resultsolutions = $ilDB->query($querysolutions);
switch ($row["question_type_fi"])
{
case 3:
// close questions
$found_value1 = array();
$found_value2 = array();
$user_result = array();
while ($data = $resultsolutions->fetchRow(DB_FETCHMODE_ASSOC))
{
if (strcmp($data["value2"], "") != 0)
{
$user_result[$data["value1"]] = array(
"gap_id" => $data["value1"],
"value" => $data["value2"]
);
}
}
$points = 0;
$counter = 0;
$gaps = array();
foreach ($answers as $key => $value)
{
if (!array_key_exists($value["gap_id"], $gaps))
{
$gaps[$value["gap_id"]] = array();
}
array_push($gaps[$value["gap_id"]], $value);
}
foreach ($user_result as $gap_id => $value)
{
if ($gaps[$gap_id][0]["cloze_type"] == 0)
{
$gappoints = 0;
foreach ($gaps[$gap_id] as $k => $v)
{
$gotpoints = getTextgapPoints($row["textgap_rating"], $v["answertext"], $value["value"], $v["points"]);
if ($gotpoints > $gappoints) $gappoints = $gotpoints;
}
$points += $gappoints;
}
else
{
if ($value["value"] >= 0)
{
foreach ($gaps[$gap_id] as $answerkey => $answer)
{
if ($value["value"] == $answerkey)
{
$points += $answer["points"];
}
}
}
}
}
// save $points;
break;
}
// check for special scoring options in test
$query = sprintf("SELECT * FROM tst_tests WHERE test_id = %s",
$ilDB->quote($test_id)
);
$resulttest = $ilDB->query($query);
if ($resulttest->numRows() == 1)
{
$rowtest = $resulttest->fetchRow(DB_FETCHMODE_ASSOC);
if ($rowtest["count_system"] == 1)
{
$maxpoints = 0;
$query = sprintf("SELECT points FROM qpl_questions WHERE question_id = %s",
$ilDB->quote($row["question_id"] . "")
);
$resultmaxpoints = $ilDB->query($query);
if ($resultmaxpoints->numRows() == 1)
{
$rowmaxpoints = $resultmaxpoints->fetchRow(DB_FETCHMODE_ASSOC);
$maxpoints = $rowmaxpoints["points"];
}
if ($points != $maxpoints)
{
$points = 0;
}
}
}
else
{
$points = 0;
}
$insertquery = sprintf("REPLACE tst_test_result (user_fi, test_fi, question_fi, points) VALUES (%s, %s, %s, %s)",
$ilDB->quote($user_id . ""),
$ilDB->quote($test_id . ""),
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($points . "")
);
$ilDB->query($insertquery);
$log->write(" $idx. creating user result: $insertquery");
$idx++;
}
}
}
$log->write("test&assessment: conversion finished. creating database entry for reached points of every user for every processed question");
?>
<#666>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#667>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#668>
CREATE TABLE lng_modules
(
module varchar(30) not null,
lang_key varchar(2) not null,
lang_array mediumtext,
primary key (module, lang_key)
);
<#669>
ALTER TABLE style_data ADD PRIMARY KEY (id);
ALTER TABLE style_data ADD COLUMN standard TINYINT(2) DEFAULT 0;
ALTER TABLE style_data ADD COLUMN category INT;
<#670>
ALTER TABLE style_data ADD COLUMN active TINYINT(2) DEFAULT 1;
<#671>
INSERT INTO `qpl_question_type` ( `question_type_id` , `type_tag` ) VALUES ('9', 'qt_numeric');
INSERT INTO `qpl_question_type` ( `question_type_id` , `type_tag` ) VALUES ('10', 'qt_textsubset');
<#672>
CREATE TABLE `qpl_numeric_range` (
`range_id` INT NOT NULL AUTO_INCREMENT ,
`lowerlimit` DOUBLE NOT NULL ,
`upperlimit` DOUBLE NOT NULL ,
`points` DOUBLE DEFAULT '0' NOT NULL ,
`aorder` INT DEFAULT '0' NOT NULL ,
`question_fi` INT NOT NULL ,
`lastchange` TIMESTAMP NOT NULL ,
PRIMARY KEY ( `range_id` )
);
<#673>
UPDATE survey_questiontype SET type_tag = 'SurveyNominalQuestion' WHERE questiontype_id = 1;
UPDATE survey_questiontype SET type_tag = 'SurveyOrdinalQuestion' WHERE questiontype_id = 2;
UPDATE survey_questiontype SET type_tag = 'SurveyMetricQuestion' WHERE questiontype_id = 3;
UPDATE survey_questiontype SET type_tag = 'SurveyTextQuestion' WHERE questiontype_id = 4;
<#674>
ALTER TABLE survey_survey CHANGE anonymize anonymize ENUM('0','1','2') NOT NULL DEFAULT '0';
<#675>
ALTER TABLE `qpl_questions` ADD `correctanswers` INT NULL DEFAULT '0' AFTER `textgap_rating`;
ALTER TABLE `qpl_questions` ADD `keywords` TEXT NULL AFTER `maxNumOfChars`;
<#676>
CREATE TABLE `qpl_question_cloze` (
`question_fi` int(11) NOT NULL default '0',
`textgap_rating` enum('ci','cs','l1','l2','l3','l4','l5') default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_essay` (
`question_fi` int(11) NOT NULL default '0',
`maxNumOfChars` int(11) NOT NULL default '0',
`keywords` text,
`textgap_rating` enum('ci','cs','l1','l2','l3','l4','l5') default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_imagemap` (
`question_fi` int(11) NOT NULL default '0',
`image_file` varchar(100) default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_javaapplet` (
`question_fi` int(11) NOT NULL default '0',
`image_file` varchar(100) default NULL,
`params` text,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_matching` (
`question_fi` int(11) NOT NULL default '0',
`shuffle` enum('0','1') NOT NULL default '1',
`matching_type` enum('0','1') default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_multiplechoice` (
`question_fi` int(11) NOT NULL default '0',
`shuffle` enum('0','1') NOT NULL default '1',
`choice_response` enum('0','1') default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_numeric` (
`question_fi` int(11) NOT NULL default '0',
`maxNumOfChars` int(11) NOT NULL default '0',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_ordering` (
`question_fi` int(11) NOT NULL default '0',
`ordering_type` enum('0','1') default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_question_textsubset` (
`question_fi` int(11) NOT NULL default '0',
`textgap_rating` enum('ci','cs','l1','l2','l3','l4','l5') default NULL,
`correctanswers` int(11) default '0',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
<#677>
<?php
$query = "SELECT * FROM qpl_questions";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch ($row["question_type_fi"])
{
case 1:
case 2:
$insertquery = sprintf("INSERT INTO qpl_question_multiplechoice (question_fi, shuffle, choice_response) VALUES (%s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["shuffle"] . ""),
$ilDB->quote($row["choice_response"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 3:
$insertquery = sprintf("INSERT INTO qpl_question_cloze (question_fi, textgap_rating) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["textgap_rating"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 4:
$insertquery = sprintf("INSERT INTO qpl_question_matching (question_fi, shuffle, matching_type) VALUES (%s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["shuffle"] . ""),
$ilDB->quote($row["matching_type"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 5:
$insertquery = sprintf("INSERT INTO qpl_question_ordering (question_fi, ordering_type) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["ordering_type"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 6:
$insertquery = sprintf("INSERT INTO qpl_question_imagemap (question_fi, image_file) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["image_file"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 7:
$insertquery = sprintf("INSERT INTO qpl_question_javaapplet (question_fi, image_file, params) VALUES (%s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["image_file"] . ""),
$ilDB->quote($row["params"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 8:
$insertquery = sprintf("INSERT INTO qpl_question_essay (question_fi, maxNumOfChars, keywords, textgap_rating) VALUES (%s, %s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["maxNumOfChars"] . ""),
$ilDB->quote($row["keywords"] . ""),
$ilDB->quote($row["textgap_rating"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 9:
$insertquery = sprintf("INSERT INTO qpl_question_numeric (question_fi, maxNumOfChars) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["maxNumOfChars"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 10:
$insertquery = sprintf("INSERT INTO qpl_question_textsubset (question_fi, textgap_rating, correctanswers) VALUES (%s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["textgap_rating"] . ""),
$ilDB->quote($row["correctanswers"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
}
}
?>
<#678>
ALTER TABLE `qpl_questions`
DROP `shuffle`,
DROP `start_tag`,
DROP `end_tag`,
DROP `matching_type`,
DROP `ordering_type`,
DROP `cloze_type`,
DROP `choice_response`,
DROP `image_file`,
DROP `params`,
DROP `maxNumOfChars`,
DROP `keywords`,
DROP `textgap_rating`,
DROP `correctanswers`;
<#679>
CREATE TABLE `survey_question_metric` (
`question_fi` int(11) NOT NULL default '0',
`subtype` enum('3','4','5') NOT NULL default '3',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `survey_question_nominal` (
`question_fi` int(11) NOT NULL default '0',
`subtype` enum('1','2') NOT NULL default '1',
`orientation` enum('0','1','2') NOT NULL default '0',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `survey_question_ordinal` (
`question_fi` int(11) NOT NULL default '0',
`orientation` enum('0','1','2') NOT NULL default '0',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `survey_question_text` (
`question_fi` int(11) NOT NULL default '0',
`maxchars` int(11) default NULL,
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
<#680>
<?php
$query = "SELECT * FROM survey_question";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch ($row["questiontype_fi"])
{
case 1:
$subtype = $row["subtype"];
if ($subtype < 1) $subtype = 1;
$orientation = $row["orientation"];
if ($orientation < 1) $orientation = 1;
$insertquery = sprintf("INSERT INTO survey_question_nominal (question_fi, subtype, orientation) VALUES (%s, %s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["subtype"] . ""),
$ilDB->quote($orientation . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 2:
$orientation = $row["orientation"];
if (!strlen($orientation)) $orientation = 0;
$insertquery = sprintf("INSERT INTO survey_question_ordinal (question_fi, orientation) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($orientation . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 3:
$subtype = $row["subtype"];
if ($subtype < 3) $subtype = 3;
$insertquery = sprintf("INSERT INTO survey_question_metric (question_fi, subtype) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($subtype . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 4:
$insertquery = sprintf("INSERT INTO survey_question_text (question_fi, maxchars) VALUES (%s, %s)",
$ilDB->quote($row["question_id"] . ""),
$ilDB->quote($row["maxchars"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
}
}
?>
<#681>
ALTER TABLE `survey_question`
DROP `subtype`,
DROP `orientation`,
DROP `maxchars`;
<#682>
DROP TABLE `qpl_answer_enhanced`;
<#683>
CREATE TABLE `qpl_answer_cloze` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`shuffle` enum('0','1') NOT NULL default '1',
`answertext` text NOT NULL,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`correctness` enum('0','1') NOT NULL default '0',
`gap_id` int(10) unsigned NOT NULL default '0',
`cloze_type` enum('0','1') default NULL,
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_imagemap` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`correctness` enum('0','1') NOT NULL default '0',
`coords` text,
`area` varchar(20) default NULL,
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_matching` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`matchingtext` text,
`matching_order` int(10) unsigned default NULL,
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_multiplechoice` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`imagefile` text,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`correctness` enum('0','1') NOT NULL default '0',
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_ordering` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`solution_order` int(10) unsigned NOT NULL default '0',
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_textsubset` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
<#684>
<?php
$query = "SELECT qpl_answers.*, qpl_questions.question_type_fi FROM qpl_answers, qpl_questions WHERE qpl_answers.question_fi = qpl_questions.question_id";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch ($row["question_type_fi"])
{
case 1:
case 2:
$insertquery = sprintf("INSERT INTO qpl_answer_multiplechoice (question_fi, answertext, points, aorder, correctness) VALUES (%s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . ""),
$ilDB->quote($row["correctness"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 3:
$insertquery = sprintf("INSERT INTO qpl_answer_cloze (question_fi, name, shuffle, answertext, points, aorder, correctness, gap_id, cloze_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["name"] . ""),
$ilDB->quote($row["shuffle"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . ""),
$ilDB->quote($row["correctness"] . ""),
$ilDB->quote($row["gap_id"] . ""),
$ilDB->quote($row["cloze_type"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 4:
$insertquery = sprintf("INSERT INTO qpl_answer_matching (question_fi, answertext, points, aorder, matchingtext, matching_order) VALUES (%s, %s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . ""),
$ilDB->quote($row["matchingtext"] . ""),
$ilDB->quote($row["matching_order"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 5:
$insertquery = sprintf("INSERT INTO qpl_answer_ordering (question_fi, answertext, points, aorder, solution_order) VALUES (%s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . ""),
$ilDB->quote($row["solution_order"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 6:
$insertquery = sprintf("INSERT INTO qpl_answer_imagemap (question_fi, answertext, points, aorder, correctness, coords, area) VALUES (%s, %s, %s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . ""),
$ilDB->quote($row["correctness"] . ""),
$ilDB->quote($row["coords"] . ""),
$ilDB->quote($row["area"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
case 7:
break;
case 8:
break;
case 9:
break;
case 10:
$insertquery = sprintf("INSERT INTO qpl_answer_textsubset (question_fi, answertext, points, aorder) VALUES (%s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . "")
);
$insertresult = $ilDB->query($insertquery);
break;
}
}
?>
<#685>
DROP TABLE qpl_answers;
DROP TABLE qpl_answerblock;
<#686>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#687>
ALTER TABLE survey_survey CHANGE anonymize anonymize ENUM('0','1','2') NOT NULL DEFAULT '0';
<#688>
ALTER TABLE `tst_tests` ADD `shuffle_questions` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `ending_time` ;
<#689>
ALTER TABLE `tst_tests` ADD `show_solution_details` ENUM( '0', '1' ) NOT NULL DEFAULT '1';
<#690>
ALTER TABLE `survey_question_nominal` CHANGE `orientation` `orientation` ENUM( '0', '1', '2' ) NOT NULL DEFAULT '0';
<#691>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#692>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#693>
ALTER TABLE `survey_anonymous` ADD `user_key` VARCHAR( 40 ) NULL AFTER `survey_fi` ;
<#694>
ALTER TABLE `exc_returned` CHANGE `TIMESTAMP` `timestamp` timestamp(14);
<#695>
<?php
// Update registration settings
$query = "SELECT value FROM settings WHERE keyword='auto_registration'";
$res = $this->db->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->value)
{
$reg_mode = 2;
}
}
$query = "SELECT value FROM settings WHERE keyword='enable_registration'";
$res = $this->db->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if(!$row->value)
{
$reg_mode = 1;
}
}
if(!$reg_mode)
{
$reg_mode = 3;
}
$query = "INSERT INTO settings SET keyword = 'new_registration_type',value = '".$reg_mode."'";
$ilDB->query($query);
?>
<#696>
CREATE TABLE `reg_email_role_assignments` (
`assignment_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`domain` VARCHAR( 128 ) NOT NULL ,
`role` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `assignment_id` )
) TYPE = MYISAM ;
<#697>
<?php
$query = "INSERT INTO reg_email_role_assignments SET domain = '', role = ''";
$ilDB->query($query);
?>
<#698>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#699>
ALTER TABLE `exc_members` ADD `solved_time` timestamp(14) DEFAULT '00000000000000' AFTER solved;
<#700>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#701>
ALTER TABLE `qpl_answer_multiplechoice` ADD `points_unchecked` DOUBLE NOT NULL DEFAULT '0' AFTER `points`;
<#702>
<?php
$query = "SELECT qpl_answer_multiplechoice.*, qpl_question_multiplechoice.choice_response FROM qpl_answer_multiplechoice, qpl_question_multiplechoice WHERE qpl_answer_multiplechoice.question_fi = qpl_question_multiplechoice.question_fi";
$result = $ilDB->query($query);
if ($result->numRows())
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
// only multiple response questions
if ($row["choice_response"] == 1)
{
if ($row["correctness"] == 0)
{
$query = sprintf("UPDATE qpl_answer_multiplechoice SET points = %s, points_unchecked = %s WHERE answer_id = %s",
$ilDB->quote("0"),
$ilDB->quote($row["points"]),
$ilDB->quote($row["answer_id"])
);
}
else
{
$query = sprintf("UPDATE qpl_answer_multiplechoice SET points = %s, points_unchecked = %s WHERE answer_id = %s",
$ilDB->quote($row["points"]),
$ilDB->quote("0"),
$ilDB->quote($row["answer_id"])
);
}
$updateres = $ilDB->query($query);
}
}
}
?>
<#703>
ALTER TABLE `qpl_answer_multiplechoice` DROP `correctness`;
<#704>
ALTER TABLE `tst_tests` ADD `score_cutting` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `mc_scoring`;
<#705>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#706>
CREATE TABLE `qpl_question_singlechoice` (
`question_fi` int(11) NOT NULL default '0',
`shuffle` enum('0','1') NOT NULL default '1',
PRIMARY KEY (`question_fi`)
) TYPE=MyISAM;
CREATE TABLE `qpl_answer_singlechoice` (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`question_fi` int(10) unsigned NOT NULL default '0',
`answertext` text NOT NULL,
`imagefile` text,
`points` double NOT NULL default '0',
`aorder` int(10) unsigned NOT NULL default '0',
`lastchange` timestamp NOT NULL,
PRIMARY KEY (`answer_id`),
KEY `question_fi` (`question_fi`)
) TYPE=MyISAM;
<#707>
<?php
// move multiple choice sr -> singlechoice
$query = "SELECT qpl_question_multiplechoice.*, qpl_questions.question_type_fi FROM qpl_question_multiplechoice, qpl_questions WHERE qpl_question_multiplechoice.question_fi = qpl_questions.question_id";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch ($row["question_type_fi"])
{
case 1:
// single response
$insertquery = sprintf("INSERT INTO qpl_question_singlechoice (question_fi, shuffle) VALUES (%s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["shuffle"] . "")
);
$insertresult = $ilDB->query($insertquery);
$deletequery = sprintf("DELETE FROM qpl_question_multiplechoice WHERE question_fi = %s",
$ilDB->quote($row["question_fi"] . "")
);
$deleteresult = $ilDB->query($deletequery);
break;
}
}
// move multiple choice sr answers -> singlechoice answers
$query = "SELECT qpl_answer_multiplechoice.*, qpl_questions.question_type_fi FROM qpl_answer_multiplechoice, qpl_questions WHERE qpl_answer_multiplechoice.question_fi = qpl_questions.question_id";
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
switch ($row["question_type_fi"])
{
case 1:
// single response
$insertquery = sprintf("INSERT INTO qpl_answer_singlechoice (question_fi, answertext, imagefile, points, aorder) VALUES (%s, %s, %s, %s, %s)",
$ilDB->quote($row["question_fi"] . ""),
$ilDB->quote($row["answertext"] . ""),
$ilDB->quote($row["imagefile"] . ""),
$ilDB->quote($row["points"] . ""),
$ilDB->quote($row["aorder"] . "")
);
$insertresult = $ilDB->query($insertquery);
$deletequery = sprintf("DELETE FROM qpl_answer_multiplechoice WHERE answer_id = %s",
$ilDB->quote($row["answer_id"] . "")
);
$deleteresult = $ilDB->query($deletequery);
break;
}
}
?>
<#708>
ALTER TABLE qpl_question_multiplechoice DROP choice_response;
<#709>
ALTER TABLE `tst_tests` ADD `password` VARCHAR( 20 ) NULL AFTER `pass_scoring`;
<#710>
ALTER TABLE `crs_items` ADD `changeable` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `activation_end` ,
ADD `visible` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `changeable`;
<#711>
ALTER TABLE `crs_items` ADD `timing_min` INT DEFAULT '0' NOT NULL AFTER `obj_id` ,
ADD `timing_max` INT DEFAULT '0' NOT NULL AFTER `timing_min`;
<#712>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#713>
ALTER TABLE `settings` ADD `module` VARCHAR( 50 ) NOT NULL DEFAULT 'common' FIRST ;
ALTER TABLE `settings` DROP PRIMARY KEY ;
ALTER TABLE `settings` ADD PRIMARY KEY ( `module` , `keyword` ) ;
ALTER TABLE `settings` CHANGE `value` `value` TEXT NOT NULL;
<#714>
UPDATE `settings` SET `module` = 'assessment' WHERE `module` = 'common' AND `keyword` LIKE 'assessment_%';
<#715>
ALTER TABLE `tst_tests` ADD `show_solution_printview` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `show_solution_details`;
<#716>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#717>
ALTER TABLE content_object ADD column header_page int NOT NULL DEFAULT 0;
ALTER TABLE content_object ADD column footer_page int NOT NULL DEFAULT 0;
<#718>
DROP TABLE `qpl_question_type`;
CREATE TABLE `qpl_question_type` (
`question_type_id` int(3) unsigned NOT NULL auto_increment,
`type_tag` char(35) NOT NULL default '',
PRIMARY KEY (`question_type_id`)
);
INSERT INTO `qpl_question_type` (`question_type_id`, `type_tag`) VALUES (1, 'assSingleChoice'),
(2, 'assMultipleChoice'),
(3, 'assClozeTest'),
(4, 'assMatchingQuestion'),
(5, 'assOrderingQuestion'),
(6, 'assImagemapQuestion'),
(7, 'assJavaApplet'),
(8, 'assTextQuestion'),
(9, 'assNumeric'),
(10, 'assTextSubset');
<#719>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#720>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#721>
ALTER TABLE `tst_tests` ADD `show_summary` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `show_solution_printview` ;
<#722>
ALTER TABLE `tst_active` ADD `anonymous_id` VARCHAR( 5 ) NULL AFTER `user_fi` ;
ALTER TABLE `tst_active` ADD INDEX ( `anonymous_id` ) ;
ALTER TABLE `tst_active_qst_sol_settings` ADD `anonymous_id` VARCHAR( 5 ) NULL AFTER `user_fi` ;
ALTER TABLE `tst_active_qst_sol_settings` ADD INDEX ( `anonymous_id` ) ;
ALTER TABLE `tst_solutions` ADD `anonymous_id` VARCHAR( 5 ) NULL AFTER `user_fi` ;
ALTER TABLE `tst_solutions` ADD INDEX ( `anonymous_id` ) ;
ALTER TABLE `tst_test_random_question` ADD `anonymous_id` VARCHAR( 5 ) NULL AFTER `user_fi` ;
ALTER TABLE `tst_test_random_question` ADD INDEX ( `anonymous_id` ) ;
ALTER TABLE `tst_test_result` ADD `anonymous_id` VARCHAR( 5 ) NULL AFTER `user_fi` ;
ALTER TABLE `tst_test_result` ADD INDEX ( `anonymous_id` ) ;
<#723>
ALTER TABLE `tst_active_qst_sol_settings` DROP `anonymous_id` ;
ALTER TABLE `tst_solutions` DROP `anonymous_id` ;
ALTER TABLE `tst_test_random_question` DROP `anonymous_id` ;
ALTER TABLE `tst_test_result` DROP `anonymous_id` ;
<#724>
ALTER TABLE `tst_active_qst_sol_settings` ADD `active_fi` INT NOT NULL AFTER `user_fi` ;
<#725>
<?php
$query = "SELECT tst_active_qst_sol_settings.*, tst_active.active_id FROM tst_active_qst_sol_settings, tst_active WHERE tst_active_qst_sol_settings.test_fi = tst_active.test_fi AND tst_active_qst_sol_settings.user_fi = tst_active.user_fi";
$result = $ilDB->query($query);
if ($result->numRows())
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$update = sprintf("UPDATE tst_active_qst_sol_settings SET active_fi = %s WHERE test_fi = %s AND user_fi = %s",
$ilDB->quote($row["active_id"] . ""),
$ilDB->quote($row["test_fi"] . ""),
$ilDB->quote($row["user_fi"] . "")
);
$updateresult = $ilDB->query($update);
}
}
?>
<#726>
ALTER TABLE `tst_active_qst_sol_settings` DROP PRIMARY KEY;
ALTER TABLE `tst_active_qst_sol_settings` ADD PRIMARY KEY ( `active_fi` , `question_fi` );
ALTER TABLE `tst_active_qst_sol_settings` DROP `test_fi`;
ALTER TABLE `tst_active_qst_sol_settings` DROP `user_fi`;
<#727>
ALTER TABLE `tst_solutions` DROP INDEX `solution_id_2`;
ALTER TABLE `tst_solutions` DROP INDEX `solution_id`;
ALTER TABLE `tst_solutions` ADD `active_fi` INT NOT NULL AFTER `user_fi` ;
<#728>
<?php
global $ilLog;
$query = "SELECT tst_solutions.*, tst_active.active_id FROM tst_solutions, tst_active WHERE tst_solutions.test_fi = tst_active.test_fi AND tst_solutions.user_fi = tst_active.user_fi";
$result = $ilDB->query($query);
if ($result->numRows())
{
if(function_exists('memory_get_usage'))
{
$memory_usage = " Memory usage: ".memory_get_usage();
}
$ilLog->write("-- MetaData (Migration type '".$row_pg->type."'): Processing obj number: ".$row_pg->obj_id.$memory_usage);
$counter = 0;
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
if(function_exists('memory_get_usage'))
{
$memory_usage = " Memory usage: ".memory_get_usage();
}
if(!(++$counter % 100))
{
$ilLog->write("test_result number: $counter".$memory_usage);
}
$update = sprintf("UPDATE tst_solutions SET active_fi = %s WHERE test_fi = %s AND user_fi = %s",
$ilDB->quote($row["active_id"] . ""),
$ilDB->quote($row["test_fi"] . ""),
$ilDB->quote($row["user_fi"] . "")
);
$updateresult = $ilDB->query($update);
}
}
?>
<#729>
ALTER TABLE `tst_solutions` DROP `test_fi`;
ALTER TABLE `tst_solutions` DROP `user_fi`;
ALTER TABLE `tst_solutions` ADD INDEX ( `active_fi` ) ;
<#730>
ALTER TABLE `tst_test_random_question` ADD `active_fi` INT NOT NULL AFTER `user_fi` ;
<#731>
<?php
$query = "SELECT tst_test_random_question.*, tst_active.active_id FROM tst_test_random_question, tst_active WHERE tst_test_random_question.test_fi = tst_active.test_fi AND tst_test_random_question.user_fi = tst_active.user_fi";
$result = $ilDB->query($query);
if ($result->numRows())
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$update = sprintf("UPDATE tst_test_random_question SET active_fi = %s WHERE test_fi = %s AND user_fi = %s",
$ilDB->quote($row["active_id"] . ""),
$ilDB->quote($row["test_fi"] . ""),
$ilDB->quote($row["user_fi"] . "")
);
$updateresult = $ilDB->query($update);
}
}
?>
<#732>
ALTER TABLE `tst_test_random_question` DROP `test_fi`;
ALTER TABLE `tst_test_random_question` DROP `user_fi`;
ALTER TABLE `tst_test_random_question` ADD INDEX ( `active_fi` ) ;
<#733>
ALTER TABLE `tst_test_result` ADD `active_fi` INT NOT NULL AFTER `user_fi` ;
<#734>
<?php
$query = "SELECT tst_test_result.*, tst_active.active_id FROM tst_test_result, tst_active WHERE tst_test_result.test_fi = tst_active.test_fi AND tst_test_result.user_fi = tst_active.user_fi";
$result = $ilDB->query($query);
if ($result->numRows())
{
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$update = sprintf("UPDATE tst_test_result SET active_fi = %s, TIMESTAMP = %s WHERE test_result_id = %s",
$ilDB->quote($row["active_id"] . ""),
$ilDB->quote($row["TIMESTAMP"] . ""),
$ilDB->quote($row["test_result_id"] . "")
);
$updateresult = $ilDB->query($update);
}
}
?>
<#735>
ALTER TABLE `tst_test_result` DROP INDEX `user_fi`;
ALTER TABLE `tst_test_result` DROP INDEX `question_fi`;
ALTER TABLE `tst_test_result` DROP `test_fi`;
ALTER TABLE `tst_test_result` DROP `user_fi`;
ALTER TABLE `tst_test_result` ADD UNIQUE (`active_fi` ,`question_fi`, `pass`);
<#736>
ALTER TABLE `tst_tests` ADD `allowedUsers` INT NULL AFTER `password` ;
ALTER TABLE `tst_tests` ADD `allowedUsersTimeGap` INT NULL AFTER `allowedUsers` ;
<#737>
ALTER TABLE `tst_active` DROP INDEX `active_id_2`;
ALTER TABLE `tst_active` DROP INDEX `active_id`;
ALTER TABLE `tst_mark` DROP INDEX `mark_id_2`;
ALTER TABLE `tst_mark` DROP INDEX `mark_id`;
ALTER TABLE `tst_tests` DROP INDEX `test_id_2`;
ALTER TABLE `tst_tests` DROP INDEX `test_id`;
ALTER TABLE `tst_test_type` DROP INDEX `test_type_id_2`;
ALTER TABLE `tst_test_type` DROP INDEX `test_type_id`;
<#738>
ALTER TABLE `ass_log` ADD `test_only` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `original_fi` ;
ALTER TABLE `ass_log` ADD `ref_id` INT NULL AFTER `original_fi` ;
<#739>
REPLACE INTO settings (module, keyword, value) VALUES ('common', 'enable_trash', 1);
<#740>
<?php
// register new object type 'adve' for Advanced editing settings in the administration
$query = "INSERT INTO object_data (type, title, description, owner, create_date, last_update) ".
"VALUES ('typ', 'adve', 'Advanced editing object', -1, now(), now())";
$this->db->query($query);
// ADD NODE IN SYSTEM SETTINGS FOLDER
// create object data entry
$query = "INSERT INTO object_data (type, title, description, owner, create_date, last_update) ".
"VALUES ('adve', '__AdvancedEditing', 'Advanced Editing', -1, now(), now())";
$this->db->query($query);
$query = "SELECT LAST_INSERT_ID() as id";
$res = $this->db->query($query);
$row = $res->fetchRow(DB_FETCHMODE_OBJECT);
// create object reference entry
$query = "INSERT INTO object_reference (obj_id) VALUES('".$row->id."')";
$res = $this->db->query($query);
$query = "SELECT LAST_INSERT_ID() as id";
$res = $this->db->query($query);
$row = $res->fetchRow(DB_FETCHMODE_OBJECT);
// put in tree
$tree = new ilTree(ROOT_FOLDER_ID);
$tree->insertNode($row->id,SYSTEM_FOLDER_ID);
// register RECOVERY_FOLDER_ID in table settings
$query = "INSERT INTO settings (keyword,value) VALUES('sys_advanced_editing_id','".$row->id."')";
$res = $this->db->query($query);
// retrieve assessment folder definition from object_data
$query = "SELECT obj_id FROM object_data WHERE type = 'typ' ".
" AND title = 'adve'";
$res = $this->db->query($query);
$row = $res->fetchRow();
$typ_id = $row[0];
// add rbac operations to assessment folder
// 1: edit_permissions, 2: visible, 3: read, 4:write
$query = "INSERT INTO rbac_ta (typ_id, ops_id) VALUES ('".$typ_id."','1')";
$this->db->query($query);
$query = "INSERT INTO rbac_ta (typ_id, ops_id) VALUES ('".$typ_id."','2')";
$this->db->query($query);
$query = "INSERT INTO rbac_ta (typ_id, ops_id) VALUES ('".$typ_id."','3')";
$this->db->query($query);
$query = "INSERT INTO rbac_ta (typ_id, ops_id) VALUES ('".$typ_id."','4')";
$this->db->query($query);
?>
<#741>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#742>
ALTER TABLE usr_data ADD COLUMN `profile_incomplete` int(2) default '0';
<#743>
ALTER TABLE `usr_data` MODIFY `auth_mode` ENUM( 'default','local', 'ldap', 'radius', 'shibboleth','script','cas','soap') DEFAULT 'default' NOT NULL;
ALTER TABLE `role_data` MODIFY `auth_mode` ENUM( 'default', 'local', 'ldap', 'radius', 'shibboleth', 'script','cas','soap') DEFAULT 'default' NOT NULL;
ALTER TABLE `usr_data` ADD COLUMN ext_account CHAR(50);
<#744>
CREATE TABLE xhtml_page(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
content MEDIUMTEXT
);
<#745>
ALTER TABLE `crs_items` ADD `suggestion_start` INT NOT NULL AFTER `activation_end` ,
ADD `suggestion_end` INT NOT NULL AFTER `suggestion_start`;
<#746>
DROP TABLE IF EXISTS event;
CREATE TABLE event (
event_id int(11) NOT NULL auto_increment,
obj_id int(11) NOT NULL default '0',
title varchar(70) NOT NULL default '',
description text NOT NULL,
location text NOT NULL,
tutor_firstname varchar(127) NOT NULL default '',
tutor_lastname varchar(127) NOT NULL default '',
tutor_title varchar(16) NOT NULL default '',
tutor_email varchar(127)NOT NULL default '',
tutor_phone varchar(127) NOT NULL default '',
details text NOT NULL,
PRIMARY KEY (event_id)
) TYPE=MyISAM;
<#747>
DROP TABLE IF EXISTS `event_appointment`;
CREATE TABLE `event_appointment` (
`appointment_id` int(11) NOT NULL auto_increment,
`event_id` int(11) NOT NULL default '0',
`starting_time` int(11) NOT NULL default '0',
`ending_time` int(11) NOT NULL default '0',
PRIMARY KEY (`appointment_id`)
) TYPE=MyISAM;
<#748>
DROP TABLE IF EXISTS `event_file`;
CREATE TABLE `event_file` (
`file_id` int(11) NOT NULL auto_increment,
`event_id` int(11) NOT NULL default '0',
`file_name` char(64) NOT NULL default '',
`file_type` char(64) NOT NULL default '',
`file_size` int(11) NOT NULL default '0',
PRIMARY KEY (`file_id`)
) TYPE=MyISAM;
<#749>
DROP TABLE IF EXISTS `event_items`;
CREATE TABLE `event_items` (
`event_id` int(11) NOT NULL default '0',
`item_id` int(11) NOT NULL default '0',
PRIMARY KEY (`event_id`,`item_id`),
KEY `event_id` (`event_id`)
) TYPE=MyISAM ;
<#750>
ALTER TABLE `crs_settings` ADD `important` TEXT NOT NULL ;
<#751>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#752>
ALTER TABLE `qpl_question_cloze` ADD `identical_scoring` ENUM( '0', '1' ) NOT NULL DEFAULT '1' AFTER `textgap_rating` ;
<#753>
ALTER TABLE `qpl_answer_cloze` CHANGE `cloze_type` `cloze_type` ENUM( '0', '1', '2' ) NULL DEFAULT NULL;
<#754>
DROP TABLE IF EXISTS `crs_file`;
CREATE TABLE `crs_file` (
`file_id` int(11) NOT NULL auto_increment,
`course_id` int(11) NOT NULL default '0',
`file_name` char(64) NOT NULL default '',
`file_type` char(64) NOT NULL default '',
`file_size` int(11) NOT NULL default '0',
PRIMARY KEY (`file_id`)
) TYPE=MyISAM;
<#755>
ALTER TABLE `crs_items` CHANGE `activation_unlimited` `timing_type` TINYINT( 2 ) NULL DEFAULT NULL;
<#756>
ALTER TABLE `crs_items` CHANGE `activation_start` `timing_start` INT( 8 ) NULL DEFAULT NULL;
<#757>
ALTER TABLE `crs_items` CHANGE `activation_end` `timing_end` INT( 8 ) NULL DEFAULT NULL ;
<#758>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#759>
ALTER TABLE `crs_items`
DROP `timing_min`,
DROP `timing_max`;
<#760>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#761>
DROP TABLE IF EXISTS `crs_objective_status`;
CREATE TABLE `crs_objective_status` (
`objective_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`objective_id`,`user_id`)
) TYPE=MyISAM;
<#762>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#763>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#764>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#765>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#766>
ALTER TABLE `event` ADD `registration` TINYINT( 1 ) NOT NULL ,
ADD `participation` TINYINT( 1 ) NOT NULL ;
<#767>
CREATE TABLE `event_participants` (
`event_id` INT( 11 ) NOT NULL ,
`usr_id` INT( 11 ) NOT NULL ,
`registered` TINYINT( 1 ) NOT NULL ,
`participated` TINYINT( 1 ) NOT NULL ,
PRIMARY KEY ( `event_id` , `usr_id` )
) TYPE = MYISAM ;
<#768>
ALTER TABLE `lm_data` ADD `active` ENUM( 'y', 'n' ) DEFAULT 'y';
<#769>
ALTER TABLE `event_participants` ADD `mark` TEXT NOT NULL ,
ADD `comment` TEXT NOT NULL ;
<#770>
CREATE TABLE `ut_lp_event_collections` (
`obj_id` int( 11 ) NOT NULL default '0',
`item_id` int( 11 ) NOT NULL default '0',
KEY `obj_id` ( `obj_id` , `item_id` )
) TYPE = MYISAM;
<#771>
ALTER TABLE `crs_items` ADD `earliest_start` INT( 11 ) NOT NULL AFTER `changeable` ,
ADD `latest_end` INT( 11 ) NOT NULL AFTER `earliest_start`;
<#772>
CREATE TABLE `usr_new_account_mail` (
`lang` CHAR(5) NOT NULL PRIMARY KEY,
`subject` VARCHAR(200) NULL default '',
`body` MEDIUMTEXT NULL default ''
) TYPE = MYISAM;
<#773>
ALTER TABLE `ilinc_data` ADD `akclassvalue1` VARCHAR( 40 ) NULL ;
ALTER TABLE `ilinc_data` ADD `akclassvalue2` VARCHAR( 40 ) NULL ;
REPLACE INTO settings (module, keyword, value) VALUES ('common', 'ilinc_akclassvalues_required', 1);
<#774>
ALTER TABLE `payment_settings` ADD `paypal` TEXT NOT NULL ;
<#775>
CREATE TABLE `crs_timings_usr_accept` (
`crs_id` int(11) NOT NULL default '0',
`usr_id` int(11) NOT NULL default '0',
`accept` tinyint(1) NOT NULL default '0',
`remark` text NOT NULL,
`visible` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`crs_id`,`usr_id`)
) TYPE=MyISAM;
<#776>
CREATE TABLE `crs_timings_planed` (
`item_id` INT( 11 ) NOT NULL ,
`usr_id` INT( 11 ) NOT NULL ,
`planed_start` INT( 11 ) NOT NULL ,
`planed_end` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `item_id` , `usr_id` )
) TYPE = MYISAM ;
<#777>
<?php
$tree = new ilTree(ROOT_FOLDER_ID);
$query = "SELECT ut.obj_id AS obj_id,type,item_id FROM ut_lp_collections AS ut INNER JOIN object_data AS od ON od.obj_id = ut.obj_id";
$res = $this->db->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->type != 'crs' and
$row->type != 'fold' and
$row->type != 'grp')
{
continue;
}
// get container ref_id
$query = "SELECT * FROM object_reference WHERE obj_id = '".$row->obj_id."'";
$ref_res = $this->db->query($query);
while($ref_row = $ref_res->fetchRow(DB_FETCHMODE_OBJECT))
{
$container_ref_id = $ref_row->ref_id;
}
// get item ref ids
$query = "SELECT * FROM object_reference WHERE obj_id = '".$row->item_id."'";
$item_res = $this->db->query($query);
while($item_row = $item_res->fetchRow(DB_FETCHMODE_OBJECT))
{
// is child node
if($tree->isGrandChild($container_ref_id,$item_row->ref_id))
{
$query = "UPDATE ut_lp_collections ".
"SET item_id = '".$item_row->ref_id."' ".
"WHERE obj_id = '".$row->obj_id."' ".
"AND item_id = '".$row->item_id."'";
$this->db->query($query);
break;
}
}
}
?>
<#778>
ALTER TABLE `usr_new_account_mail` ADD COLUMN `sal_f` VARCHAR(200) NOT NULL DEFAULT '';
ALTER TABLE `usr_new_account_mail` ADD COLUMN `sal_m` VARCHAR(200) NOT NULL DEFAULT '';
ALTER TABLE `usr_new_account_mail` ADD COLUMN `sal_g` VARCHAR(200) NOT NULL DEFAULT '';
<#779>
ALTER TABLE `crs_settings` ADD `activation_type` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `contact_consultation`;
<#780>
<?php
$query = "SELECT * FROM crs_settings ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->activation_unlimited)
{
$type = 1;
}
elseif($row->activation_offline)
{
$type = 0;
}
else
{
$type = 2;
}
$query = "UPDATE crs_settings ".
"SET activation_type = '".$type."' ".
"WHERE obj_id = '".$row->obj_id."'";
$ilDB->query($query);
}
?>
<#781>
ALTER TABLE `crs_settings`
DROP `activation_unlimited`,
DROP `activation_offline`;
<#782>
ALTER TABLE `crs_settings` ADD `subscription_limitation_type` TINYINT( 1 ) NOT NULL AFTER `activation_end` ;
<#783>
<?php
$query = "SELECT * FROM crs_settings ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->subscription_unlimited)
{
$type = 1;
}
elseif($row->subscription_type == 1)
{
$type = 0;
}
else
{
$type = 2;
}
$query = "UPDATE crs_settings ".
"SET subscription_limitation_type = '".$type."' ".
"WHERE obj_id = '".$row->obj_id."'";
$ilDB->query($query);
}
?>
<#784>
ALTER TABLE `crs_settings`
DROP `subscription_unlimited`;
<#785>
ALTER TABLE `crs_settings` ADD `view_mode` TINYINT( 1 ) NOT NULL AFTER `subscription_notify`;
<#786>
<?php
$query = "SELECT * FROM crs_settings ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->archive_type != 1)
{
$type = 3;
}
elseif($row->objective_view)
{
$type = 1;
}
else
{
$type = 0;
}
$query = "UPDATE crs_settings ".
"SET view_mode = '".$type."' ".
"WHERE obj_id = '".$row->obj_id."'";
$ilDB->query($query);
}
?>
<#787>
ALTER TABLE `crs_settings`
DROP `objective_view`;
<#788>
ALTER TABLE `survey_survey` ADD `outro` TEXT NULL AFTER `introduction` ;
UPDATE `survey_survey` SET `outro` = 'survey_finished';
<#789>
ALTER TABLE `event` DROP `tutor_firstname` ,
DROP `tutor_lastname` ,
DROP `tutor_title` ;
<#790>
ALTER TABLE `event` ADD `tutor_name` TEXT NOT NULL AFTER `location`;
<#791>
REPLACE INTO settings (keyword, value) VALUES ('shib_hos_type', 'external_wayf');
REPLACE INTO settings (keyword, value) VALUES ('shib_federation_name', 'Shibboleth');
REPLACE INTO settings (keyword, value) VALUES ('shib_idp_list', '');
<#792>
ALTER TABLE exc_members ADD sent_time TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00';
<#793>
CREATE TABLE exc_usr_tutor (
obj_id INT NOT NULL DEFAULT 0,
usr_id INT NOT NULL DEFAULT 0,
tutor_id INT NOT NULL DEFAULT 0,
download_time TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (obj_id, usr_id, tutor_id));
<#794>
ALTER TABLE `tst_tests` ADD `show_question_titles` ENUM( '0', '1' ) NOT NULL DEFAULT '1' AFTER `show_summary` ;
<#795>
CREATE TABLE IF NOT EXISTS `crs_objective_status_pretest` (
`objective_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`objective_id`,`user_id`)
) Type=MyISAM;
<#796>
<?php
$query = "SELECT * FROM crs_objective_status WHERE status = 0";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$query = "INSERT INTO crs_objective_status_pretest ".
"SET objective_id = '".$row->objective_id."', ".
"user_id = '".$row->user_id."'";
$ilDB->query($query);
}
?>
<#797>
<?php
$query = "DELETE FROM crs_objective_status ".
"WHERE status = '0'";
$ilDB->query($query);
?>
<#798>
ALTER TABLE exc_members ADD feedback_time TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE exc_members ADD feedback TINYINT(1);
UPDATE exc_members SET feedback=1 WHERE sent=1;
<#799>
ALTER TABLE exc_members MODIFY feedback TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE exc_members MODIFY returned TINYINT(1) NOT NULL DEFAULT 0;
<#800>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#801>
ALTER TABLE sc_resource ADD INDEX import_id (import_id);
<#802>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#803>
ALTER TABLE `event_appointment` ADD `fulltime` TINYINT( 1 ) NOT NULL;
<#804>
ALTER TABLE `ut_lp_marks` CHANGE `comment` `comment` TEXT NOT NULL;
<#805>
<?php
$query = "SELECT * FROM rbac_operations WHERE operation = 'edit_learning_progress'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ops_id = $row->ops_id;
}
// Get type ids of 'exc', 'grp', 'fold'
$query = "SELECT obj_id FROM object_data WHERE title IN ('exc','grp','fold') ".
"AND type = 'typ'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$type_ids[] = $row->obj_id;
}
// ASSIGN new operation to object types
foreach($type_ids as $typ_id)
{
$query = "INSERT INTO rbac_ta SET typ_id = '".$typ_id."', ".
"ops_id = '".$ops_id."'";
$ilDB->query($query);
}
// get template il_crs_admin Author and Local Administrator
$query = "SELECT obj_id FROM object_data WHERE title IN ('il_grp_admin','il_crs_admin','Author','Local Administrator') ".
"AND type = 'rolt'";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$rolt_ids[] = $row->obj_id;
}
// ASSIGN new operation to role templates
foreach($rolt_ids as $rolt_id)
{
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'grp', ".
"ops_id = '".$ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'exc', ".
"ops_id = '".$ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
$query = "INSERT INTO rbac_templates SET rol_id = '".$rolt_id."', ".
"type = 'fold', ".
"ops_id = '".$ops_id."', ".
"parent = '".ROLE_FOLDER_ID."'";
$ilDB->query($query);
}
?>
<#806>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#807>
ALTER TABLE exc_members ADD status ENUM('notgraded','failed','passed') NOT NULL DEFAULT 'notgraded';
UPDATE exc_members SET status = 'passed' WHERE solved = 1;
ALTER TABLE exc_members CHANGE solved_time status_time TIMESTAMP DEFAULT '0000-00-00 00:00:00';
<#808>
ALTER TABLE frm_data ADD INDEX top_frm_fk (top_frm_fk);
<#809>
ALTER TABLE mail ADD INDEX folder_id (folder_id);
<#810>
ALTER TABLE mail ADD INDEX m_status (m_status);
<#811>
ALTER TABLE frm_posts ADD INDEX pos_date (pos_date);
<#812>
ALTER TABLE `crs_settings` ADD `show_members` TINYINT NOT NULL DEFAULT '1';
<#813>
DROP TABLE IF EXISTS tmp_migration;
CREATE TABLE `tmp_migration` (
`objective_id` int(11) NOT NULL default '0',
`passed` tinyint(4) NOT NULL default '0');
<#814>
<?php
// Store objective results in table crs_objective_result
// Get all objectives
$query = "SELECT objective_id FROM crs_objectives ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
// check if objective is already processed
$res_passed = $ilDB->query("SELECT objective_id FROM tmp_migration WHERE objective_id = '".$row->objective_id."' AND passed = '1'");
if($res_passed->numRows())
{
continue;
}
// Read objective info
$query = "SELECT * FROM crs_objective_tst as ct JOIN crs_objective_qst as cq ".
"ON (ct.objective_id = cq.objective_id AND ct.obj_id = cq.obj_id) ".
"WHERE tst_status = '1' AND ct.objective_id = '".$row->objective_id."'";
$obj_info = $ilDB->query($query);
$objective_info = array();
while($obj_row = $obj_info->fetchRow(DB_FETCHMODE_OBJECT))
{
$objective_info[$obj_row->obj_id]['questions'][] = $obj_row->question_id;
$objective_info[$obj_row->obj_id]['limit'] = $obj_row->tst_limit;
}
// Read max reachable points
// Read user points
foreach($objective_info as $test_id => $data)
{
$query = "SELECT SUM(points) as reachable FROM qpl_questions WHERE ".
"question_id IN('".implode("','",$data['questions'])."')";
$reachable_res = $ilDB->query($query);
while($reachable_row = $reachable_res->fetchRow(DB_FETCHMODE_OBJECT))
{
$objective_info[$test_id]['reachable'] = $reachable_row->reachable;
}
$query = "SELECT user_fi, MAX(points) as reached FROM tst_test_result JOIN tst_active ON active_fi = active_id ".
"WHERE question_fi IN('".implode("','",$data['questions'])."') ".
"GROUP BY question_fi,user_fi";
$user_reached_res = $ilDB->query($query);
$objective_info[$test_id]['users'] = array();
while($user_reached_row = $user_reached_res->fetchRow(DB_FETCHMODE_OBJECT))
{
$objective_info[$test_id]['users'][$user_reached_row->user_fi] += $user_reached_row->reached;
}
}
// Check reached
foreach($objective_info as $test_id => $data)
{
if(!$data['reachable'])
{
continue;
}
foreach($data['users'] as $user_id => $reached)
{
if(($reached / $data['reachable'] * 100) >= $data['limit'])
{
$query = "REPLACE INTO crs_objective_status ".
"SET objective_id = '".$row->objective_id."', ".
"user_id = '".$user_id."', ".
"status = '1'";
$ilDB->query($query);
}
}
}
// Now set objective passed
$query = "REPLACE INTO tmp_migration ".
"SET objective_id = '".$row->objective_id."', ".
"passed = '1'";
$ilDB->query($query);
}
?>
<#815>
DROP TABLE IF EXISTS tmp_migration;
<#816>
ALTER TABLE xhtml_page ADD COLUMN save_content MEDIUMTEXT;
<#817>
<?php
$ilCtrlStructureReader->getStructure();
?>
<#818>
<?php
// get all languages
$q = "SELECT * FROM object_data WHERE type = ".$ilDB->quote("lng");
$lang_set = $ilDB->query($q);
while($lang_rec = $lang_set->fetchRow(DB_FETCHMODE_ASSOC))
{
// get all installed languages
if (substr($lang_rec["description"], 0, 9) == "installed")
{
$q = "SELECT * FROM lng_data WHERE lang_key = ".$ilDB->quote($lang_rec["title"]);
$var_set = $ilDB->query($q);
$lang_array = array();
// get data from lng_data table
while($var_rec = $var_set->fetchRow(DB_FETCHMODE_ASSOC))
{
$lang_array[$var_rec["module"]][$var_rec["identifier"]] = $var_rec["value"];
}
// put data into lng_modules table
foreach($lang_array as $module => $lang_arr)
{
$query = "REPLACE INTO lng_modules (lang_key, module, lang_array) VALUES ".
"(".$ilDB->quote($lang_rec["title"]).", " .
" ".$ilDB->quote($module).", " .
" ".$ilDB->quote(serialize($lang_arr)).") ";
$ilDB->query($query);
}
}
}
Variable Documentation
| $adm_id = "obj_id"] |
Definition at line 2691 of file dbupdate.php.
| $adm_role_id = $row[0] |
Definition at line 2534 of file dbupdate.php.
| $admin["tst"] = array(1,2,3,4,6) |
Definition at line 3947 of file dbupdate.php.
| $admin["grp"] = array(1,2,3,4,6,7,8,18,20,21,22,23,24,25,26,27,29,31) |
Definition at line 3948 of file dbupdate.php.
| $admin["exc"] = array(1,2,3,4,6) |
Definition at line 3949 of file dbupdate.php.
| $admin["fold"] = array(1,2,3,4,6,18,20,21,22,25,26,29) |
Definition at line 3950 of file dbupdate.php.
| $admin["crs"] = array(1,2,3,4,6,7,8,17,18,20,21,22,23,24,25,26,27,29,31,32) |
Definition at line 3951 of file dbupdate.php.
| $admin["icrs"] = array(1,2,3,4,6,7,8,$icla_ops_id) |
Definition at line 8052 of file dbupdate.php.
| $admin["rolf"] = array(1,2,3,4,6,14) |
Definition at line 8053 of file dbupdate.php.
| $admin = array(1,2,3,4,6,7,8) |
Definition at line 3940 of file dbupdate.php.
Referenced by ilObjCourseGUI::__renderAdminsTable(), and ilObjRoleGUI::deassignUserObject().
| $admin["slm"] = array(1,2,3,4,6,7,8) |
Definition at line 3941 of file dbupdate.php.
| $admin["dbk"] = array(1,2,3,4,6) |
Definition at line 3942 of file dbupdate.php.
| $admin["glo"] = array(1,2,3,4,6,7,8) |
Definition at line 3943 of file dbupdate.php.
| $admin["frm"] = array(1,2,3,4,6,9,10) |
Definition at line 3944 of file dbupdate.php.
| $admin["chat"] = array(1,2,3,4,6) |
Definition at line 3945 of file dbupdate.php.
| $admin["file"] = array(1,2,3,4,6) |
Definition at line 3946 of file dbupdate.php.
| $chat_id = $ilDB->getLastInsertId() |
Definition at line 8666 of file dbupdate.php.
Referenced by ilPersonalDesktopGUI::__showActiveChatsOfUser(), and ilChatRoom::getAllRooms().
| $chat_ref_id = $ilDB->getLastInsertId() |
Definition at line 8673 of file dbupdate.php.
| $counter = 0 |
Definition at line 6856 of file dbupdate.php.
| $d = opendir(CLIENT_WEB_DIR . "/assessment/") or die($php_errormsg) |
Definition at line 4136 of file dbupdate.php.
Referenced by ilObjTest::_getECTSGrade(), ilObjUser::addDesktopItem(), ilObjUser::addObjectToClipboard(), ilObjLanguageFolder::checkAllLanguages(), ilBMFParser::domulti(), ilFormat::fmtDateTime(), ilBMFType_duration::getduration(), ilLanguage::getInstallableLanguages(), ilObjLanguageFolder::getLanguages(), ilLanguage::getLanguages(), ilLanguage::getLocalLanguages(), ilTabsGUI::getTargetsByObjectType(), ilClientList::init(), ilFormat::input2date(), ilObjUser::isDesktopItem(), makeTimestamp(), ilBMFType_duration::mod(), outMobImages(), ilObjContentObjectGUI::showActions(), ilObjUserFolderGUI::showActions(), ilObjectGUI::showActions(), ilBookmarkAdministrationGUI::showActions(), ilLMObjectGUI::showPossibleSubObjects(), ilObjUserFolderGUI::showPossibleSubObjects(), ilObjRoleFolderGUI::showPossibleSubObjects(), ilObjectGUI::showPossibleSubObjects(), ilContainerGUI::showPossibleSubObjects(), and ilBookmarkAdministrationGUI::showPossibleSubObjects().
| $fields = array('entity','date','description') |
Definition at line 9544 of file dbupdate.php.
Referenced by ilUserSearchOptions::__appendUserDefinedFields(), ilAdvancedSearch::__createEducationalWhere(), ilLikeUserSearch::__createWhereCondition(), ilLikeUserDefinedFieldSearch::__createWhereCondition(), ilAdvancedSearch::__getDifference(), ilCourseXMLParser::__parseId(), ilGroupImportParser::__parseId(), ilUserSearchOptions::_getSearchableFieldsInfo(), ilObjiLincCourseGUI::displayEditForm(), ilObjiLincClassroomGUI::displayEditForm(), ilObjectGUI::displayEditForm(), ilObjiLincClassroomGUI::editClassroom(), ilObjiLincCourseGUI::editObject(), ilObjFileGUI::editObject(), ilObjectGUI::editObject(), ilMDConvert(), ilElement::insertDb(), ilObjUserFolderGUI::learningProgressObject(), SurveySearch::search(), and ilObjUser::updateUserDefinedFields().
| $file_ids = array() |
Definition at line 9072 of file dbupdate.php.
Referenced by ilPageObject::collectFileItems(), ilObjGlossary::exportXML(), ilObjContentObject::exportXMLPageObjects(), ilObjTest::exportXMLPageObjects(), ilObjQuestionPool::exportXMLPageObjects(), ilPageObject::saveFileUsage(), and ilPageObject::update().
| $foundactive = array() |
Definition at line 9784 of file dbupdate.php.
| $gl_set = $this->db->query($query) |
Definition at line 2823 of file dbupdate.php.
Referenced by ilObjGlossary::read().
| $GLOBALS['tree'] = $tree |
Definition at line 8437 of file dbupdate.php.
| $GLOBALS['ilLog'] = & $log |
Definition at line 8646 of file dbupdate.php.
| $grp_data = array() |
Definition at line 203 of file dbupdate.php.
| $guest_id = "" |
Definition at line 3747 of file dbupdate.php.
| $icla_ops_id = $row->ops_id |
Definition at line 8010 of file dbupdate.php.
| $idx = 1 |
Definition at line 6416 of file dbupdate.php.
Referenced by ilRTE::_replaceMediaObjectImageSrc(), PHPlot::DrawArea(), PHPlot::DrawBars(), PHPlot::DrawDots(), PHPlot::DrawLines(), PHPlot::DrawLinesError(), PHPlot::DrawSquared(), PHPlot::DrawStackedBars(), PHPlot::DrawThinBarLines(), SurveyTextQuestion::from_xml(), SurveyOrdinalQuestion::from_xml(), SurveyNominalQuestion::from_xml(), SurveyMetricQuestion::from_xml(), assTextSubset::fromXML(), assClozeTest::fromXML(), assOrderingQuestionGUI::getPreview(), assMatchingQuestionGUI::getPreview(), assTextQuestionGUI::getSolutionOutput(), assSingleChoiceGUI::getSolutionOutput(), assOrderingQuestionGUI::getSolutionOutput(), assMultipleChoiceGUI::getSolutionOutput(), assMatchingQuestionGUI::getSolutionOutput(), assImagemapQuestionGUI::getSolutionOutput(), assTextSubsetGUI::getTestOutput(), assTextQuestionGUI::getTestOutput(), assSingleChoiceGUI::getTestOutput(), assOrderingQuestionGUI::getTestOutput(), assMultipleChoiceGUI::getTestOutput(), assMatchingQuestionGUI::getTestOutput(), assImagemapQuestionGUI::getTestOutput(), ilObjSurvey::moveDownQuestion(), ilObjSurvey::moveDownQuestionblock(), ilObjSurvey::moveQuestions(), ilObjSurvey::moveUpQuestion(), ilObjSurvey::moveUpQuestionblock(), and ilObjTest::randomSelectQuestions().
| $ilca_nodes = $tree->getNodeDataByType('icla') |
Definition at line 8095 of file dbupdate.php.
| if (count($icla_nodes)!=0) $ilcrs_nodes = $tree->getNodeDataByType('icrs') |
Definition at line 8152 of file dbupdate.php.
Definition at line 10811 of file dbupdate.php.
| $ilObjDef = new ilObjectDefinition() |
Definition at line 1196 of file dbupdate.php.
| while ($row=$result->fetchRow(DB_FETCHMODE_ASSOC)) $ini = new ilIniFile(ILIAS_ABSOLUTE_PATH."/ilias.ini.php") |
Definition at line 706 of file dbupdate.php.
| $key = 'meta_annotation_id' |
Definition at line 9546 of file dbupdate.php.
Referenced by ilCourseArchives::__buildStructure(), ilPermissionGUI::__displayAddRoleForm(), ilSearchGUI::__getFilter(), ilObjDlBookGUI::__parseCitationPost(), ilObjExerciseGUI::__saveStatus(), ilObjLinkResourceGUI::__setLocator(), ilObjRoleGUI::__setLocator(), ilObjChatGUI::__setLocator(), ilRbacReview::__setRoleType(), ilMDEditorGUI::__setTabs(), ilCourseContentGUI::__showMaterial(), ilCourseContentGUI::__showMaterials(), ilSoapUserAdministration::__substituteUserData(), ilTree::__validateSubtrees(), ilObjSurvey::_clone(), ilObjTest::_clone(), ilHistory::_createEntry(), ilMDUtilSelect::_getDifficultySelect(), ilMDUtilSelect::_getDurationSelect(), ilMDFactory::_getInstance(), ilMDUtilSelect::_getInteractivityLevelSelect(), ilObjAssessmentFolder::_getLog(), ilMediaItem::_getMapAreasIntLinks(), ilMDUtilSelect::_getSemanticDensitySelect(), ilObjTestAccess::_getTestResult(), ilUserAgreement::_getText(), assQuestion::_getTotalRightAnswers(), ilMDUtilSelect::_getTypicalAgeRangeSelect(), ilMDUtilSelect::_getTypicalLearningTimeSelect(), ilObjCategoryGUI::_importCategoriesForm(), ilBMFTransport_HTTP::_sendHTTPS(), Spreadsheet_Excel_Writer_Workbook::_storeAllFonts(), ilLocatorGUI::addAdministrationItems(), assSingleChoice::addAnswer(), assOrderingQuestion::addAnswer(), assMultipleChoice::addAnswer(), ilObjSurveyGUI::addHeadingObject(), assOrderingQuestionGUI::addItem(), ilMDGeneral::addKeyword(), ilMDClassification::addKeyword(), ilObjContentObjectGUI::addLocations(), assNumeric::addRange(), ilLocatorGUI::addRepositoryItems(), ilMDEditorGUI::addSection(), assClozeTestGUI::addSuggestedSolution(), array_merge_php4(), assignMailToPost(), ilObjSurveyGUI::browseForQuestionsObject(), assJavaApplet::buildParams(), assJavaApplet::buildParamsOnly(), ilvCard::buildVCard(), ilSQL2XML::buildXML(), ilLMStatistics::calcStats(), assSingleChoice::calculateReachedPoints(), assOrderingQuestion::calculateReachedPoints(), assNumeric::calculateReachedPoints(), assMultipleChoice::calculateReachedPoints(), assMatchingQuestion::calculateReachedPoints(), assImagemapQuestion::calculateReachedPoints(), soap_client::call(), ilCourseContentInterface::cci_view(), ilObjSystemFolderGUI::changeHeaderTitleObject(), ilObjLanguageFolder::checkAllLanguages(), ilPurchasePaypal::checkData(), ilUtil::checkFormEmpty(), checkIfNotNegDate(), assSingleChoiceGUI::checkInput(), assNumericGUI::checkInput(), assMultipleChoiceGUI::checkInput(), ilLanguage::checkLanguage(), assOrderingQuestion::checkSaveData(), assMatchingQuestion::checkSaveData(), XML2DOM::clean(), ilNestedSetXML::clean(), conditionForm(), ilObjiLincCourseGUI::confirmationObject(), ilObjGroupGUI::confirmationObject(), ilObjTestGUI::confirmChangeProperties(), ilObjSurveyQuestionPoolGUI::confirmDeletePhraseObject(), ilObjSurveyQuestionPoolGUI::confirmDeleteQuestionsObject(), ilObjQuestionPoolGUI::confirmDeleteQuestionsObject(), ilObjSurveyGUI::confirmInsertQuestionObject(), ilObjSurveyQuestionPoolGUI::confirmPasteQuestionsObject(), ilObjSurveyGUI::confirmRemoveQuestionsObject(), ilObjTestGUI::confirmRemoveQuestionsObject(), ilObjGlossaryGUI::confirmTermDeletion(), ilObjSurveyGUI::constraintsAddObject(), ilObjSurveyGUI::constraintStep1Object(), ilObjSurveyQuestionPoolGUI::copyObject(), ilObjQuestionPoolGUI::copyObject(), ilLMObjectGUI::create(), assClozeTest::createCloseTextArray(), assClozeTest::createCloseTextFromArray(), ilMailbox::createDefaultFolder(), ilObjSurveyQuestionPoolGUI::createObject(), ilObjSurveyGUI::createObject(), ilObjGlossaryGUI::createObject(), ilObjFileBasedLMGUI::createObject(), ilObjContentObjectGUI::createObject(), ilObjUserGUI::createObject(), ilObjRoleTemplateGUI::createObject(), ilObjGroupGUI::createObject(), ilObjFolderGUI::createObject(), ilObjFileGUI::createObject(), ilObjectGUI::createObject(), ilObjCategoryGUI::createObject(), ilObjTestGUI::createObject(), ilObjQuestionPoolGUI::createObject(), ilObjSurveyGUI::createQuestionObject(), ilObjTestGUI::createQuestionObject(), ilObjUserFolder::createXMLExport(), ilLanguage::cut_header(), ilExerciseMembers::deassignMember(), ilObjSurveyGUI::defineQuestionblock(), ilObjSurveyGUI::defineQuestionblockObject(), ilMDGeneral::delete(), ilMDClassification::delete(), ilBookmarkAdministrationGUI::delete(), assOrderingQuestionGUI::delete(), assClozeTestGUI::delete(), assImagemapQuestionGUI::deleteArea(), ilObjSurveyGUI::deleteConstraintsObject(), ilExerciseMembers::deleteDeliveredFiles(), assSingleChoiceGUI::deleteImage(), assMultipleChoiceGUI::deleteImage(), ASS_MarkSchema::deleteMarkSteps(), ilObjTestGUI::deleteMarkStepsObject(), SurveyQuestion::deleteMaterial(), ilObjUserFolderGUI::deleteObject(), ilObjRoleFolderGUI::deleteObject(), ilObjectGUI::deleteObject(), ilObjSurveyQuestionPoolGUI::deletePhraseObject(), ilObjSurveyQuestionPoolGUI::deleteQuestionsObject(), ilObjSurveyGUI::deleteSingleUserResultsObject(), ilObjTestGUI::deleteSingleUserResultsObject(), ilObjUserGUI::deliverVCardObject(), ilLPItemListGUI::disable(), ilUserFilter::disableField(), ilGlossaryLocatorGUI::display(), ilContObjLocatorGUI::display(), ilForumLocatorGUI::display(), ilSetupGUI::displayClientList(), ilObjiLincCourseGUI::displayEditForm(), ilObjiLincClassroomGUI::displayEditForm(), ilObjectGUI::displayEditForm(), ilRegistrationGUI::displayForm(), ilSetupGUI::displayLanguages(), ilObjUserFolderGUI::displayList(), ilObjTypeDefinitionGUI::displayList(), ilObjSystemFolderGUI::displayList(), ilObjObjectFolderGUI::displayList(), ilObjLanguageFolderGUI::displayList(), ilObjectGUI::displayList(), ilLMEditorGUI::displayLocator(), ilBookmarkAdministrationGUI::displayLocator(), ilSetupGUI::displayProcessPanel(), ilSetupGUI::displayStatusPanel(), displayStructure(), PHPlot_Data::DoDivision(), PHPlot_Data::DoRemoveDataSet(), ilExerciseMembers::downloadMultipleFiles(), ilExerciseMembers::downloadSelectedFiles(), ilObjSurveyQuestionPoolGUI::duplicateObject(), ilObjQuestionPoolGUI::duplicateObject(), ilObjUserGUI::editObject(), ilObjTypeDefinitionGUI::editObject(), ilObjStyleSheetGUI::editObject(), ilObjGroupGUI::editObject(), ilObjCategoryGUI::editObject(), SurveyTextQuestionGUI::editQuestion(), SurveyOrdinalQuestionGUI::editQuestion(), SurveyNominalQuestionGUI::editQuestion(), SurveyMetricQuestionGUI::editQuestion(), assTextSubsetGUI::editQuestion(), assTextQuestionGUI::editQuestion(), assSingleChoiceGUI::editQuestion(), assOrderingQuestionGUI::editQuestion(), assNumericGUI::editQuestion(), assMultipleChoiceGUI::editQuestion(), assMatchingQuestionGUI::editQuestion(), assJavaAppletGUI::editQuestion(), assImagemapQuestionGUI::editQuestion(), assClozeTestGUI::editQuestion(), ilObjStyleSheetGUI::editTagStyleObject(), ilLPItemListGUI::enable(), ilLPItemListGUI::enabled(), ilUserFilter::enableField(), ilTestEvaluationGUI::eval_stat(), ilTestEvaluationGUI::evalSelectedUsers(), ilObjTest::evalStatistical(), ilTestEvaluationGUI::evalStatSelected(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalStartedAverageTime(), ilSurveyEvaluationGUI::evaluationuser(), exercise(), ilObjDlBook::export(), ilSurveyEvaluationGUI::exportCumulatedResults(), ilObjSurveyQuestionPoolGUI::exportQuestionsObject(), ilObjSCORMTracking::extractData(), ilTemplate::fillVars(), ilForumExplorer::formatObject(), formSelect(), ilUtil::formSelect(), Context::from_language(), assSingleChoice::fromXML(), assOrderingQuestion::fromXML(), assMultipleChoice::fromXML(), ilBMFWSDL::generateAllProxies(), ilObjTest::generateRandomQuestions(), assMatchingQuestion::get_random_id(), assNumeric::getBestRange(), ilObjMediaPool::getChilds(), SurveyOrdinalQuestion::getCumulatedResults(), SurveyNominalQuestion::getCumulatedResults(), SurveyMetricQuestion::getCumulatedResults(), ilObjQuestionPoolGUI::getEmbeddedTabs(), ilObjSurvey::getEvaluationByUser(), ilObjUserFolder::getExportSettings(), Spreadsheet_Excel_Writer_Format::getFontKey(), assClozeTest::getGapTextList(), ilFileExplorer::getIndex(), ilExplorer::getIndex(), assQuestion::getInstances(), ilPageObject::getInternalLinks(), ilGlossaryTermGUI::getInternalLinks(), ilMDGeneral::getKeyword(), ilMDClassification::getKeyword(), ilObjAssessmentFolder::getLog(), assClozeTest::getMaximumGapPoints(), assSingleChoice::getMaximumPoints(), assOrderingQuestion::getMaximumPoints(), assNumeric::getMaximumPoints(), assMultipleChoice::getMaximumPoints(), assMatchingQuestion::getMaximumPoints(), assImagemapQuestion::getMaximumPoints(), assClozeTest::getMaximumPoints(), assOrderingQuestion::getMaxSolutionOrder(), ilObjSurvey::getNextPage(), ilBookmarkFolder::getObjects(), ilSCORMExplorer::getOutput(), ilPublicSectionSelector::getOutput(), ilMailExplorer::getOutput(), ilForumExplorer::getOutput(), ilFileExplorer::getOutput(), ilExplorer::getOutput(), ilBookmarkExplorer::getOutput(), assJavaApplet::getParameterIndex(), ilObjUserGUI::getPublicProfile(), ilObjSurvey::getQuestionblocksTable(), ilObjSurveyQuestionPool::getQuestionsTable(), ilObjSurvey::getQuestionsTable(), ilPermissionGUI::getRolesData(), assNumericGUI::getSolutionOutput(), ilMailbox::getSubFolders(), ilObjiLincCourseGUI::getSubItems(), ilContainerGUI::getSubItems(), ilObjectDefinition::getSubobjectsToFilter(), ilObjSurvey::getSurveyQuestions(), ilObjQuestionPoolGUI::getTabs(), ilTabsGUI::getTargetsByObjectType(), assOrderingQuestionGUI::getTestOutput(), assMatchingQuestionGUI::getTestOutput(), ilObjTest::getTestResult(), ilObjTest::getTestSummary(), ilCtrl::getTransitArray(), getUserAgreement(), ilRbacAdmin::grantPermission(), ilTemplate::handleReferer(), ilPageContent::haveSameContainer(), ilLMPresentationGUI::ilLocator(), ilObjHACPTracking::ilObjHACPTracking(), ilRepositoryGUI::ilRepositoryGUI(), ilObjSurveyGUI::importObject(), ilObjSurvey::importObject(), ilObjTestGUI::importObject(), ilObjUserFolderGUI::importUserRoleAssignmentObject(), ilSoapUserAdministration::importUsers(), XMLStruct::insert(), ilElement::insertDb(), ilLanguage::insertLanguage(), ilObjSurveyGUI::insertQuestions(), ilObjTestGUI::insertQuestionsAfterObject(), ilObjTestGUI::insertQuestionsBeforeObject(), ilObjSurveyGUI::insertQuestionsObject(), ilObjTestGUI::insertQuestionsObject(), ilObjTestGUI::insertRandomSelectionObject(), ilXML2SQL::insertStructureIntoTree(), ilLanguage::installLanguages(), ilObjLanguageFolderGUI::installLocalObject(), ilObjLanguageFolderGUI::installObject(), ilObjSurvey::isAnonymizedParticipant(), ilObjSurvey::isAnonymousKey(), assTextSubset::isAnswerCorrect(), SurveyQuestion::keyInArray(), assQuestion::keyInArray(), ilObjUserFolderGUI::learningProgressObject(), ilUtil::Linkbar(), ilGlossaryPresentationGUI::listTermByGiven(), ilObjGlossaryGUI::listTerms(), ilObjAssessmentFolderGUI::logsObject(), ilUtil::makeDirParents(), ilObjTestGUI::marksObject(), ilObjQuestionPoolGUI::moveObject(), ilObjSurveyGUI::moveQuestionsObject(), ilObjExerciseGUI::newMembersObject(), ilDBUpdate::optimizeTables(), SurveyOrdinalQuestionGUI::outCumulatedResultsDetails(), SurveyNominalQuestionGUI::outCumulatedResultsDetails(), SurveyMetricQuestionGUI::outCumulatedResultsDetails(), ilTestEvaluationGUI::outEvalSearchResultTable(), ilObjTestGUI::outPrintUserResults(), ilObjUserTrackingGUI::outputTrackingDataObject(), ilTestOutputGUI::outQuestionSummary(), ilTestOutputGUI::outTestResults(), ilTestOutputGUI::outTestSummary(), ilObjTestGUI::outUserGroupTable(), ilTestEvaluationGUI::passDetails(), ilObjSurveyQuestionPoolGUI::pasteObject(), ilContainerGUI::pasteObject(), ilObjRoleTemplateGUI::permObject(), ilObjRoleGUI::permObject(), ilPermissionGUI::permSave(), ilObjRoleTemplateGUI::permSaveObject(), ilObjRoleGUI::permSaveObject(), ilXML2SQL::prepareData(), ilContObjParser::processPagesToParse(), ilObjTestGUI::propertiesObject(), ilObjHACPTracking::putparam(), ilObjTestGUI::questionBrowser(), ilObjSurveyQuestionPoolGUI::questionsObject(), ilObjTestGUI::questionsObject(), ilObjQuestionPoolGUI::questionsObject(), ilObjGlossaryGUI::quickList(), ilObjTestGUI::randomQuestionsObject(), ilObjTestGUI::randomselectObject(), ilIniFile::readGroups(), assClozeTest::rebuildClozeText(), ilRTE::removeButton(), ilObjiLincClassroomGUI::removeClassroom(), ilObjSurvey::removeConstraintsConcerningQuestion(), assJavaApplet::removeParameter(), ilRTE::removePlugin(), ilObjSurveyGUI::removeQuestionsObject(), ilObjTestGUI::removeQuestionsObject(), assClozeTestGUI::removeSuggestedSolution(), ilTableGUI::render(), ilSearchResultPresentationGUI::renderItemList(), ilObjiLincCourseGUI::renderItemList(), ilContainerGUI::renderItemList(), ilTemplate::replace(), ilNestedSetXML::replaceDomContent(), ilTemplate::replaceFromDatabase(), ilValidator::restoreDeletedObjects(), ilValidator::restoreSubTrees(), ilBenchmark::save(), assTextSubsetGUI::save(), ilObjSurveyGUI::saveDefineQuestionblockObject(), assTextSubsetGUI::saveEdit(), ilRegistrationGUI::saveForm(), ilObjSystemFolderGUI::saveHeaderTitleObject(), ilObjTestGUI::saveMarkSchemaFormData(), SurveyQuestion::saveMaterialsToDb(), ilObjUserGUI::saveObject(), ilObjCategoryGUI::saveObject(), ilObjSurveyGUI::saveObligatoryObject(), ilPersonalProfileGUI::saveProfile(), ilObjSurvey::saveQuestionsToDb(), ilObjTest::saveQuestionsToDb(), ilObjTest::saveRandomQuestionpools(), ilObjSystemFolderGUI::saveSettingsObject(), ilObjStyleSettingsGUI::saveStyleSettingsObject(), ilObjTest::saveToDb(), assTextSubset::saveToDb(), assSingleChoice::saveToDb(), assOrderingQuestion::saveToDb(), assNumeric::saveToDb(), assMultipleChoice::saveToDb(), assMatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), assImagemapQuestion::saveToDb(), assClozeTest::saveToDb(), assTextSubset::saveWorkingData(), assOrderingQuestion::saveWorkingData(), assMultipleChoice::saveWorkingData(), assMatchingQuestion::saveWorkingData(), assClozeTest::saveWorkingData(), searchForm(), searchObjects(), ilSoapObjectAdministration::searchObjects(), searchTest(), ilObjUserFolderGUI::searchUserObject(), ilFeedbackGUI::selectbox(), ilBMFTransport_SMTP::send(), ilHACPResponse::sendParam(), ilObjectGUIAdapter::setAdminTabs(), assClozeTest::setClozeText(), assClozeTest::setClozeType(), ilMailExplorer::setExpand(), ilForumExplorer::setExpand(), ilFileExplorer::setExpand(), ilExplorer::setExpand(), ilBookmarkExplorer::setExpand(), assClozeTest::setGapPoints(), assClozeTest::setGapShuffle(), assClozeTestGUI::setGapValues(), ilTableGUI::setHeaderVars(), ilvCard::setKey(), setLocator(), ilObjSAHSLearningModuleGUI::setLocator(), ilObjFileBasedLMGUI::setLocator(), setLOLocator(), ilSQL2XML::setNavigation(), ilSCORMExplorer::setOutput(), ilMailExplorer::setOutput(), ilForumExplorer::setOutput(), ilFileExplorer::setOutput(), ilExplorer::setOutput(), ilBookmarkExplorer::setOutput(), ilFileExplorer::setParamsGet(), ilExplorer::setParamsGet(), assClozeTestGUI::setShuffleState(), ilObjAssessmentFolderGUI::settingsObject(), ilLMStatisticsGUI::show(), ilTemplate::show(), ilIniFile::show(), ilObjDlBookGUI::showCitation(), ilStartUpGUI::showClientList(), ilObjUserTrackingGUI::showForm(), ilLMPresentationGUI::showPrintView(), ilPersonalProfileGUI::showProfile(), ilStartUpGUI::showUserMappingSelection(), ilExplorer::sortNodes(), soap_parser::start_element(), ilBMFWSDL_Parser::startElement(), ilBMFParser::startElement(), ilWysiwygUtil::startElement(), ilNestedSetXML::startElement(), assTextSubset::syncWithOriginal(), assSingleChoice::syncWithOriginal(), assOrderingQuestion::syncWithOriginal(), assNumeric::syncWithOriginal(), assMultipleChoice::syncWithOriginal(), assMatchingQuestion::syncWithOriginal(), assImagemapQuestion::syncWithOriginal(), assClozeTest::syncWithOriginal(), testOutput(), ilUtil::timearray2string(), ilObjSurveyQuestionPool::to_xml(), ilObjQuestionPool::to_xml(), assJavaApplet::to_xml(), assClozeTest::to_xml(), ilMDGeneral::toXML(), ilMDEducational::toXML(), ilMDClassification::toXML(), ilObjectGUI::trashObject(), ilCron::txt(), ilCronCheckUserAccounts::txt(), ilObjSurveyGUI::unfoldQuestionblockObject(), ilObjLanguageFolderGUI::uninstallObject(), ilUtil::unique_multi_array(), ilObjMediaObject::update(), ilElement::updateDb(), ilNestedSetXML::updateDomContent(), ilObjiLincCourseGUI::updateMemberStatusObject(), ilObjGroupGUI::updateMemberStatusObject(), ilObjUserGUI::updateObject(), ilObjCategoryGUI::updateObject(), ilStatistics::validate(), ilSetupGUI::validateSetup(), ilBookmarkAdministrationGUI::view(), ilObjUserFolderGUI::viewObject(), ilObjTypeDefinitionGUI::viewObject(), ilObjSystemFolderGUI::viewObject(), ilObjObjectFolderGUI::viewObject(), viewObject(), ilObjLanguageFolderGUI::viewObject(), ilObjectGUI::viewObject(), ilIniFile::write(), SurveyQuestionGUI::writeCategoryData(), assTextSubsetGUI::writePostData(), assSingleChoiceGUI::writePostData(), assOrderingQuestionGUI::writePostData(), assNumericGUI::writePostData(), assMultipleChoiceGUI::writePostData(), assMatchingQuestionGUI::writePostData(), assJavaAppletGUI::writePostData(), assImagemapQuestionGUI::writePostData(), assClozeTestGUI::writePostData(), and xslt_process().
| $lang_set = $ilDB->query($q) |
Definition at line 11579 of file dbupdate.php.
| $left = $res->lft |
Definition at line 402 of file dbupdate.php.
| $lft = $left + 1 |
Definition at line 403 of file dbupdate.php.
Referenced by ilTree::checkTree(), ilTree::insertNode(), ilForum::insertPostNode(), ilObjRoleGUI::permSaveObject(), and ilTree::saveSubTree().
| global $log |
Definition at line 6414 of file dbupdate.php.
| while ($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) $max_id = $max_id ? $max_id : 0 |
Definition at line 6849 of file dbupdate.php.
| $maxidx = $result->numRows() + 1 |
Definition at line 6419 of file dbupdate.php.
| $mem_role_id = $row[0] |
Definition at line 2426 of file dbupdate.php.
| $migrate = true |
Definition at line 709 of file dbupdate.php.
| $nested = new ilNestedSetXML() |
Definition at line 6841 of file dbupdate.php.
Referenced by ilObjFileBasedLM::delete(), ilObjContentObject::delete(), ilObjDlBook::export(), ilObjDlBook::exportRekursiv(), ilGlossaryExport::exportRekursiv(), ilContObjectExport::exportRekursiv(), ilPageObject::getBibliographyXML(), and ilContObjParser::handlerEndTag().
| $new_ops_id = $ilDB->getLastInsertId() |
Definition at line 9278 of file dbupdate.php.
| $obj_id = $row[0] |
Definition at line 384 of file dbupdate.php.
| $ops_data["lm"] = array(2,3,7,8) |
Definition at line 2435 of file dbupdate.php.
| $ops_data["frm"] = array(2,3,4,9) |
Definition at line 2432 of file dbupdate.php.
| $ops_data["file"] = array(2,3) |
Definition at line 2431 of file dbupdate.php.
| $ops_data["grp"] = array(2,3,7,8,18,25,26) |
Definition at line 2434 of file dbupdate.php.
| $ops_data["slm"] = array(2,3,7,8) |
Definition at line 2436 of file dbupdate.php.
| $ops_data["chat"] = array(2,3) |
Definition at line 2430 of file dbupdate.php.
Referenced by ilObjectStatusGUI::getAssignedValidRoles(), ilSoapRBACAdministration::getObjectTreeOperations(), and ilPermissionGUI::getRolesData().
| $ops_data["fold"] = array(2,3,18,25,26) |
Definition at line 2437 of file dbupdate.php.
| $ops_data["glo"] = array(2,3,7,8) |
Definition at line 2433 of file dbupdate.php.
| $ops_id = $res->ops_id |
Definition at line 5743 of file dbupdate.php.
Referenced by ilObjectXMLWriter::__appendOperations(), ilUtil::_getObjectsByOperations(), ilRbacSystem::checkAccessOfUser(), ilRbacSystem::checkPermission(), createNewOperation(), ilSoapRBACAdministration::getObjectTreeOperations(), ilRbacReview::getOperation(), ilRbacReview::getOperationsOnType(), and ilObjTypeDefinitionGUI::saveObject().
| $page_set = $this->db->query($q) |
Definition at line 1010 of file dbupdate.php.
| $participate_id = "" |
Definition at line 3727 of file dbupdate.php.
| $permissions = ilRbacReview::_getOperationIdsByName(array('visible','read','moderate')) |
Definition at line 8714 of file dbupdate.php.
Referenced by grantPermissions(), ilSoapRBACAdministration::grantPermissions(), ilObjForum::initDefaultRoles(), and ilObjChat::initDefaultRoles().
| $perms |
array( array("type" => "dbk", "ops_id" => 1), array("type" => "dbk", "ops_id" => 2), array("type" => "dbk", "ops_id" => 3), array("type" => "dbk", "ops_id" => 4), array("type" => "dbk", "ops_id" => 6))
Definition at line 2885 of file dbupdate.php.
| $q = "SELECT * FROM grp_tree WHERE ref_id = '-1'" |
Definition at line 200 of file dbupdate.php.
Referenced by ilRbacReview::__getAllRoleFolderIds(), ilObjCourse::__getCrsNonMemberTemplateId(), ilRbacReview::__getParentRoles(), ilObjRole::__getPermissionDefinitions(), ilObjiLincUser::__init(), ilTree::__renumber(), ilObjStyleSettings::_activateStyle(), ilObjUser::_checkPassword(), ilHistory::_copyEntriesForObject(), ilObjStyleSettings::_deactivateStyle(), ilInternalLink::_deleteAllLinksOfSource(), ilObjMediaObject::_deleteAllUsages(), ilObjFile::_deleteAllUsages(), ilObjContentObject::_deleteStyleAssignments(), ilLMObject::_exists(), ilGlossaryTerm::_exists(), ilObject::_exists(), ilObjiLincCourse::_getAKClassValues(), ilObject::_getAllReferences(), ilObjUser::_getAllUserAssignedStyles(), ilObjUser::_getAllUserData(), ilObjRole::_getAuthMode(), ilAuthUtils::_getAuthMode(), ilAuthUtils::_getAuthModeOfUser(), ilObjStyleSheet::_getClonableContentStyles(), ilObjiLincClassroom::_getDocent(), ilHistory::_getEntryByHistoryID(), ilObjFile::_getFilesOfObject(), ilObjSystemFolder::_getHeaderTitle(), ilObjSystemFolder::_getHeaderTitleDescription(), ilObjSystemFolder::_getId(), ilLMObject::_getIdForImportId(), ilGlossaryTerm::_getIdForImportId(), ilObject::_getIdForImportId(), ilMapArea::_getIntLinks(), ilUserTracking::_getLastAccess(), ilTracking::_getLastAccess(), ilObjContentObjectAccess::_getLastAccessedPage(), ilNote::_getLastNotesOfUser(), ilMapArea::_getMaxNr(), ilObjMediaObject::_getMobsOfObject(), ilNote::_getNotesOfObject(), ilObjContentObject::_getNrLMsIndividualStyles(), ilObjContentObject::_getNrLMsNoStyle(), ilObjContentObject::_getNrOfAssignedLMs(), ilObjUser::_getNumberOfUsersForStyle(), ilObject::_getObjectsDataForType(), ilNote::_getRelatedObjectsOfUser(), ilRADIUSAuthentication::_getServers(), ilInternalLink::_getSourcesOfTarget(), ilObjStyleSheet::_getStandardStyles(), ilInternalLink::_getTargetsOfSource(), ilObjUser::_getUsersForClipboadObject(), ilGroup::_groupNameExists(), ilObjSurveyAccess::_hasEvaluationAccess(), ilObjSCORMTracking::_insertTrackData(), ilObjiLincCourse::_isActivated(), ilLMObject::_isPagePublic(), ilObjSurveyAccess::_isSurveyParticipant(), ilObjStyleSettings::_lookupActivatedStyle(), ilObjStyleSheet::_lookupActive(), ilObjRole::_lookupAllowRegister(), ilObjSurveyAccess::_lookupAnonymize(), ilObjExercise::_lookupAnyExerciseSent(), ilContainer::_lookupContainerSetting(), ilObjContentObject::_lookupContObjIdByStyleId(), ilObjSurveyAccess::_lookupCreationComplete(), ilObjTestAccess::_lookupCreationComplete(), ilNote::_lookupCreationDate(), ilLanguage::_lookupEntry(), ilObjSurveyAccess::_lookupEvaluationAccess(), ilObjExercise::_lookupFeedbackTime(), ilObjFile::_lookupFileName(), ilObjFileAccess::_lookupFileSize(), ilObjSurveyAccess::_lookupFinished(), ilObjUser::_lookupHasIlias2Password(), ilObjiLincClassroom::_lookupiCourseId(), ilObjUser::_lookupId(), ilSCORMResource::_lookupIdByIdRef(), ilObjUser::_lookupLanguage(), ilObjUser::_lookupLastLogin(), ilObjUser::_lookupLogin(), ilObjUser::_lookupName(), ilObjExercise::_lookupNewFiles(), ilObjSurveyAccess::_lookupOnline(), ilObjSAHSLearningModuleAccess::_lookupOnline(), ilObjSAHSLearningModule::_lookupOnline(), ilObjGlossaryAccess::_lookupOnline(), ilObjGlossary::_lookupOnline(), ilObjFileBasedLMAccess::_lookupOnline(), ilObjFileBasedLM::_lookupOnline(), ilObjContentObjectAccess::_lookupOnline(), ilObjContentObject::_lookupOnline(), ilSCORMObject::_lookupPresentableItems(), ilObjRole::_lookupRegisterAllowed(), ilObjExerciseAccess::_lookupRemainingWorkingTimeString(), ilSCORMResource::_lookupScormType(), ilObjExercise::_lookupSentTime(), ilObjStyleSheet::_lookupStandard(), ilObjExercise::_lookupStatusTime(), ilObjContentObject::_lookupStyleSheetId(), ilObjSAHSLearningModule::_lookupSubType(), ilObjFileAccess::_lookupSuffix(), ilBookmarkFolder::_lookupTitle(), ilSCORMItem::_lookupTrackingDataOfUser(), ilObject::_lookupType(), ilNote::_lookupUpdateDate(), ilObjExercise::_lookupUpdatedSubmission(), ilObjStyleSheet::_lookupUpToDate(), ilObjFileAccess::_lookupVersion(), ilObjContentObject::_moveLMStyles(), ilObjUser::_moveUsersToStyle(), ilHistory::_removeEntriesForObject(), ilTree::_removeEntry(), ilObjMediaObject::_removeUsage(), ilObject::_resetDeletedDate(), ilMapArea::_resolveIntLinks(), ilInternalLink::_saveLink(), ilObjMediaObject::_saveUsage(), ilObjFile::_saveUsage(), ilObject::_setDeletedDate(), ilObjUser::_switchToIlias3Password(), ilUserTracking::_trackAccess(), ilTracking::_trackAccess(), ilObjRole::_updateAuthMode(), ilObjRole::_updateSessionRoles(), ilObjStyleSheet::_writeActive(), ilObjUser::_writeAuthMode(), ilContainer::_writeContainerSetting(), ilObject::_writeDescription(), ilObjUser::_writeExternalAccount(), ilObjFile::_writeFileType(), ilLMObject::_writeImportId(), ilObject::_writeImportId(), ilObjUser::_writePref(), ilLMObject::_writePublicAccessStatus(), ilObjStyleSheet::_writeScope(), ilObjStyleSheet::_writeStandard(), ilObject::_writeTitle(), ilObjStyleSheet::_writeUpToDate(), ilObjUserGUI::activeRoleSaveObject(), ilObjUser::addDesktopItem(), ilObjSystemFolder::addHeaderTitleTranslation(), ilObjUser::addObjectToClipboard(), ilObjStyleSheet::addParameter(), ilObjCategory::addTranslation(), ilTree::addTree(), ilObjUserTracking::allAuthor(), ilObjSysUserTracking::allAuthor(), ilRegisterGUI::apply(), ilRbacReview::assignedRoles(), ilRbacReview::assignedUsers(), ilRbacAdmin::assignOperationToObject(), ilRbacAdmin::assignRoleToFolder(), ilRbacAdmin::assignUser(), ilObjUserTracking::authorLms(), ilObjSysUserTracking::authorLms(), ilLMStatistics::calcStats(), ilCtrl::callBaseClass(), ilFeedback::canVote(), ilRbacSystem::checkAccessOfUser(), ilSetup::checkClientDatabase(), ilForum::checkEditRight(), ilAddressbook::checkEntryByLogin(), ilRbacSystem::checkPermission(), ilTree::checkTree(), ilTree::checkTreeChilds(), ilBenchmark::clearData(), ilServiceReader::clearTables(), ilModuleReader::clearTables(), ilRbacAdmin::copyRolePermission(), ilRbacAdmin::copyRolePermissionIntersection(), ilElementList::countDb(), ilUserTracking::countNum(), ilTracking::countNum(), ilObjUserTrackingGUI::countNum(), ilObject::countReferences(), ilUserTracking::countResults(), ilTracking::countResults(), ilObjUserTracking::countResults(), ilObjSysUserTracking::countResults(), ilForumExport::countUserArticles(), ilForum::countUserArticles(), ilNote::create(), ilFeedback::create(), ilSCORMResources::create(), ilSCORMResource::create(), ilSCORMOrganizations::create(), ilSCORMOrganization::create(), ilSCORMObject::create(), ilSCORMManifest::create(), ilSCORMItem::create(), ilMapArea::create(), ilObjSAHSLearningModule::create(), ilObjGlossary::create(), ilObjFileBasedLM::create(), ilLMMenuEditor::create(), ilGlossaryTerm::create(), ilGlossaryDefinition::create(), ilAICCUnit::create(), ilAICCObject::create(), ilAICCCourse::create(), ilObjStyleSheet::create(), ilObjRole::create(), ilObjFile::create(), ilObject::create(), ilMetaTechnical::create(), ilBookmarkFolder::create(), ilBookmark::create(), ilObjStyleSheet::createFromXMLFile(), createNewOperation(), ilObjContentObject::createProperties(), ilObject::createReference(), ilObjUserFolder::createXMLExport(), db_pwassist_session_destroy(), db_pwassist_session_find(), db_pwassist_session_gc(), db_pwassist_session_read(), db_pwassist_session_write(), db_session_destroy(), db_session_gc(), db_session_read(), db_session_write(), ilRbacAdmin::deassignOperationFromObject(), ilRbacAdmin::deassignUser(), ilNote::delete(), ilFeedback::delete(), ilObjiLincCourse::delete(), ilSCORMResources::delete(), ilSCORMResource::delete(), ilSCORMOrganizations::delete(), ilSCORMOrganization::delete(), ilSCORMObject::delete(), ilSCORMManifest::delete(), ilSCORMItem::delete(), ilObjSAHSLearningModule::delete(), ilObjGlossary::delete(), ilObjFileBasedLM::delete(), ilObjContentObject::delete(), ilObjAICCLearningModule::delete(), ilLMMenuEditor::delete(), ilGlossaryTerm::delete(), ilGlossaryDefinition::delete(), ilAICCUnit::delete(), ilAICCObject::delete(), ilAICCCourse::delete(), ilObjUser::delete(), ilObjStyleSheet::delete(), ilObjRole::delete(), ilObjFile::delete(), ilObject::delete(), ilMetaTechnical::delete(), ilMailbox::delete(), ilBookmarkFolder::delete(), ilBookmark::delete(), ilObjGroup::deleteApplicationListEntry(), ilRbacAdmin::deleteLocalRole(), ilObjStyleSheet::deleteParameter(), ilForum::deletePost(), ilRbacAdmin::deleteRole(), ilRbacAdmin::deleteRolePermission(), ilObjStyleSheet::deleteStylePar(), ilRbacAdmin::deleteTemplate(), ilObjUserTracking::deleteTrackingDataBeforeMonth(), ilObjSysUserTracking::deleteTrackingDataBeforeMonth(), ilTree::deleteTree(), ilExerciseMembers::deliverReturnedFiles(), ilForum::disableNotification(), ilSetupGUI::displayTools(), ilPersonalDesktopGUI::displayUsersOnline(), ilObjUser::dropDesktopItem(), ilValidator::dumpTree(), ilForum::enableNotification(), ilObjTest::evalLoadStatisticalSettings(), ilObjTest::evalSaveStatisticalSettings(), ilObjTest::evalStatistical(), ilObjTest::evalTotalFinished(), ilObjTest::evalTotalParticipantsArray(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalPersons(), ilObjTest::evalTotalPersonsArray(), ilObjTest::evalTotalStartedAverageTime(), ilSetup::execQuery(), ilDBUpdate::execQuery(), ilNestedSetXML::export(), ilTree::fetchNodeData(), ilTree::fetchPredecessorNode(), ilTree::fetchSuccessorNode(), ilValidator::findDeletedObjects(), ilValidator::findInvalidChilds(), ilValidator::findInvalidRBACEntries(), ilValidator::findInvalidReferences(), ilValidator::findInvalidRolefolders(), ilValidator::findMissingObjects(), ilValidator::findUnboundObjects(), ilObjContentObject::fixTree(), ilForum::generatePost(), ilForum::generateThread(), ilObjUserTracking::getAccessPerUserDetail(), ilObjSysUserTracking::getAccessPerUserDetail(), ilObjUserTracking::getAccessTotalPerObj(), ilObjSysUserTracking::getAccessTotalPerObj(), ilObjUserTracking::getAccessTotalPerUser(), ilObjSysUserTracking::getAccessTotalPerUser(), ilFeedback::getAllBarometer(), ilClient::getAllSettings(), ilRbacReview::getAssignableRoles(), ilUtil::getAssociatedUsersOnline(), ilSQL2XML::getAttributes(), ilSQL2XML::getAttributeValue(), ilFeedback::getBarometer(), ilFeedback::getBarometerByObjId(), ilFeedback::getBarometerByRefId(), ilCtrl::getCallStructure(), ilFeedback::getChartData(), ilSCORMTree::getChilds(), ilTree::getChilds(), ilTree::getChildsByType(), ilTree::getChildSequenceNumber(), ilObjUser::getClipboardObjects(), ilObjTest::getCompleteWorkingTime(), ilBenchmark::getCurrentRecordNumber(), ilDBUpdate::getCurrentVersion(), ilElement::getDbData(), ilGlossaryDefinition::getDefinitionList(), ilTree::getDepth(), ilObjUser::getDesktopItems(), ilObjUserTracking::getDuration(), ilSQL2XML::getElementName(), ilSQL2XML::getElementText(), ilXML2SQL::getEntryId(), ilBenchmark::getEvaluation(), ilObjGroup::getExpirationDateTime(), ilFeedback::getFeedback(), ilRbacReview::getFoldersAssignedToRole(), ilUtil::getGroupId(), ilObjGroup::getGroupMemberData(), ilObjGroup::getGrpStatusClosedTemplateId(), ilObjGroup::getGrpStatusOpenTemplateId(), ilObjSystemFolder::getHeaderTitleTranslations(), ilObjectFactory::getInstanceByObjId(), ilObjectFactory::getInstanceByRefId(), ilForum::getLastPost(), ilObjExercise::getLastSubmission(), ilObjUser::getLastVisitedLessons(), ilTree::getLeftValue(), ilObjUser::getLessons(), ilRbacReview::getLinkedRolesOfRoleFolder(), ilTree::getMaximumDepth(), ilBenchmark::getMeasuredModules(), ilObjiLincCourse::getMemberData(), ilObjExercise::getMemberListData(), ilObjiLincCourse::getMemberRolesTitle(), ilObjGroup::getMemberRolesTitle(), ilLMMenuEditor::getMenuEntries(), ilForum::getModeratorFromPost(), ilObjUserTracking::getMonthTotalOverview(), ilObjSysUserTracking::getMonthTotalOverview(), ilObjGroup::getNewRegistrations(), ilTree::getNodeData(), ilTree::getNodeDataByType(), ilFeedback::getNotes(), getObjectList(), ilObjUserTracking::getObjId(), ilObjSysUserTracking::getObjId(), ilForum::getOneDataset(), ilForumExport::getOnePost(), ilForum::getOnePost(), getOperationId(), getOperationList(), ilRbacReview::getOperationsOfRole(), ilRbacReview::getOperationsOnType(), ilObjUserTracking::getOwnerName(), ilObjSysUserTracking::getOwnerName(), ilTree::getParentId(), ilTree::getParentNodeData(), ilObjGroup::getPassword(), ilTree::getPathIdsUsingAdjacencyMap(), ilTree::getPathIdsUsingNestedSets(), ilUserTracking::getPerTestId(), ilTracking::getPerTestId(), ilForum::getPostChilds(), ilForum::getPostList(), ilForum::getPostMaximumDepth(), ilObjUserTracking::getRecordsTotal(), ilObjSysUserTracking::getRecordsTotal(), ilObjGroup::getRegistrationFlag(), ilFeedback::getResultUsers(), ilRbacReview::getRoleListByObject(), ilRbacReview::getRolesByFilter(), ilRbacReview::getRolesOfRoleFolder(), ilTree::getSavedNodeData(), ilClient::getSetting(), ilSQL2XML::getStructure(), ilUserTracking::getSubId(), ilTracking::getSubId(), ilUserTracking::getSubTest(), ilTracking::getSubTest(), ilTree::getSubTree(), ilGlossaryTerm::getTermList(), ilUserTracking::getTest(), ilTracking::getTest(), ilUserTracking::getTestId(), ilTracking::getTestId(), ilObjUserTracking::getTestId(), ilObjSysUserTracking::getTestId(), ilForumExport::getThreadList(), ilObjUserTracking::getTotalOlderThanMonth(), ilObjSysUserTracking::getTotalOlderThanMonth(), ilSCORMItem::getTrackingDataOfUser(), ilAICCUnit::getTrackingDataOfUser(), ilAICCCourse::getTrackingDataOfUser(), ilObjCategory::getTranslations(), ilObjectFactory::getTypeByRefId(), ilRbacReview::getTypeId(), ilObjMediaObject::getUsages(), ilObjFile::getUsages(), ilUtil::getUsersOnline(), ilRbacAdmin::grantPermission(), ilUtil::groupNameExists(), ilServiceReader::handlerBeginTag(), ilModuleReader::handlerBeginTag(), ilObjForum::ilClone(), ilObjFile::ilClone(), ilObjiLincCourse::initDefaultRoles(), ilObjGroup::initDefaultRoles(), ilObjLanguage::insert(), ilXML2SQL::insertAttributes(), ilXML2SQL::insertComment(), ilElement::insertDb(), ilXML2SQL::insertElement(), ilLanguage::insertLanguage(), ilXML2SQL::insertNode(), ilTree::insertNode(), ilXML2SQL::insertText(), ilForum::isAnonymized(), ilRbacReview::isAssignable(), ilRbacReview::isDeleted(), ilObjRoleFolder::isDeleted(), ilObjUser::isDesktopItem(), ilTree::isGrandChild(), ilClient::isInstalledDB(), ilTree::isInTree(), ilObjForum::isNotificationEnabled(), ilForum::isNotificationEnabled(), ilRbacReview::isProtected(), ilTree::isSaved(), ilRegisterGUI::isUserAlreadyRegistered(), ilLMPresentationGUI::lmAccess(), ilSetup::loginAsClient(), loginExists(), ilCtrl::lookupClassPath(), ilGlossaryDefinition::moveDown(), ilGlossaryDefinition::moveUp(), ilObjRoleTemplateGUI::permObject(), ilForum::postCensorship(), ilCtrlStructureReader::read(), ilNote::read(), ilObjiLincCourse::read(), ilSCORMResources::read(), ilSCORMResource::read(), ilSCORMOrganizations::read(), ilSCORMOrganization::read(), ilSCORMObject::read(), ilSCORMManifest::read(), ilSCORMItem::read(), ilMapArea::read(), ilObjSAHSLearningModule::read(), ilObjGlossary::read(), ilObjFileBasedLM::read(), ilGlossaryTerm::read(), ilGlossaryDefinition::read(), ilAICCUnit::read(), ilAICCObject::read(), ilAICCCourse::read(), ilObjUser::read(), ilObjStyleSheetFolder::read(), ilObjStyleSheet::read(), ilObjStyleSettings::read(), ilObjRole::read(), ilObjFile::read(), ilObject::read(), ilBookmarkFolder::read(), ilBookmark::read(), ilSCORMResource::readByIdRef(), ilCtrl::readCallStructure(), ilSetup::readDump(), ilLMMenuEditor::readEntry(), ilObjUser::readPrefs(), ilObjContentObject::readProperties(), ilObjUser::refreshLogin(), ilObjectGUI::removeDeletedNodes(), ilObjSystemFolder::removeHeaderTitleTranslations(), ilValidator::removeInvalidChilds(), ilValidator::removeInvalidReferences(), ilUtil::removeItemFromDesktops(), ilObjUser::removeObjectFromClipboard(), ilObjCategory::removeTranslations(), ilTree::removeTree(), ilRbacAdmin::removeUser(), ilObjUser::replacePassword(), ilObjStyleSheet::replaceStylePar(), ilObjUser::resetPassword(), ilValidator::restoreReference(), ilValidator::restoreTrash(), ilRbacAdmin::revokePermission(), ilRbacAdmin::revokePermissionList(), ilRbacReview::roleExists(), ilBenchmark::save(), ilObjiLincCourse::saveActivationStatus(), ilObjiLincCourse::saveAKClassValues(), ilObjUser::saveAsNew(), ilTree::saveNode(), ilObjForumGUI::saveObject(), ilFeedback::saveResult(), ilTree::saveSubTree(), ilUtil::searchGroups(), ilUserTracking::searchResults(), ilTracking::searchResults(), ilUserTracking::searchTestId(), ilTracking::searchTestId(), ilUserTracking::searchTestResults(), ilTracking::searchTestResults(), ilUserTracking::searchUserId(), ilTracking::searchUserId(), ilUserTracking::selectTime(), ilTracking::selectTime(), ilObjUserTrackingGUI::selectTime(), ilCronForumNotification::sendNotifications(), ilForum::sendNotifications(), ilDBUpdate::setCurrentVersion(), ilObjUser::setDesktopItemParameters(), ilObjGroup::setExpirationDateTime(), ilObjGroup::setPassword(), ilRbacAdmin::setProtected(), ilObjGroup::setRegistrationFlag(), ilRbacAdmin::setRolePermission(), ilClient::setSetting(), ilLMStatisticsGUI::show(), ilBMFWSDL_Parser::startElement(), ilObjTest::startWorkingTime(), ilCtrlStructureReader::store(), ilObjSCORMTracking::store(), ilCtrl::storeCommonStructures(), ilObjiLincCourse::storeiLincId(), ilUserTracking::TestTitle(), ilTracking::TestTitle(), ilNote::update(), ilFeedback::update(), ilObjiLincUser::update(), ilObjiLincCourse::update(), ilSCORMResources::update(), ilSCORMResource::update(), ilSCORMOrganizations::update(), ilSCORMOrganization::update(), ilSCORMObject::update(), ilSCORMManifest::update(), ilSCORMItem::update(), ilMapArea::update(), ilObjSAHSLearningModule::update(), ilObjGlossary::update(), ilObjFileBasedLM::update(), ilLMMenuEditor::update(), ilGlossaryTerm::update(), ilGlossaryDefinition::update(), ilAICCUnit::update(), ilAICCObject::update(), ilAICCCourse::update(), ilObjUser::update(), ilObjStyleSheetFolder::update(), ilObjStyleSheet::update(), ilObjStyleSettings::update(), ilObjRole::update(), ilObjFile::update(), ilObject::update(), ilBookmarkFolder::update(), ilBookmark::update(), ilObjUser::updateActiveRoles(), ilLMMenuEditor::updateActiveStatus(), ilElement::updateDb(), ilObjUser::updateLogin(), ilXML2SQL::updateNode(), ilObjNote::updateNote(), updateObjectValue(), ilObject::updateOwner(), ilObjUser::updatePassword(), ilForum::updatePost(), ilObjContentObject::updateProperties(), ilObjStyleSheet::updateStyleParameter(), ilForum::updateThread(), ilExerciseMembers::updateTutorDownloadTime(), ilForum::updateVisits(), ilObjTest::updateWorkingTime(), ilObjUser::writeAccepted(), ilObjUser::writePrefs(), ilObjContentObject::writeStyleSheetId(), and ilMediaItem::writeThumbTried().
| $query = "VALUES ('typ', 'ldap', 'LDAP settings object', -1, now(), now())" |
Definition at line 355 of file dbupdate.php.
Referenced by ilLPMarks::__add(), ilLPFilter::__add(), ilChatRoom::__addLine(), ilCourseObjectiveQuestion::__addTest(), ilForumImportParser::__addTopic(), ilSoapAuthenticationCAS::__buildAuth(), ilSoapUserAdministration::__buildSearchQuery(), ilCronClients::__checkDBVersion(), ilTree::__checkDelete(), ilLinkChecker::__checkNotify(), ilSoapAuthentication::__checkSOAPEnabled(), ilPurchasePaypal::__checkTransactionId(), ilCron::__checkUserAccounts(), ilCourseObjective::__cleanStructure(), ilLinkChecker::__clearDBData(), ilFulltextMediaPoolSearch::__createAndCondition(), ilFulltextMetaDataSearch::__createContributeWhereCondition(), ilFulltextAdvancedSearch::__createCoverageAndCondition(), ilObjCourse::__createDefaultSettings(), ilFulltextMetaDataSearch::__createDescriptionWhereCondition(), ilFulltextAdvancedSearch::__createEntityWhereCondition(), ilFulltextMetaDataSearch::__createKeywordWhereCondition(), ilFulltextAdvancedSearch::__createKeywordWhereCondition(), ilFulltextAdvancedSearch::__createLifecycleWhereCondition(), ilCourseMembers::__createMemberEntry(), ilSearchFolder::__createNewTree(), ilFulltextForumSearch::__createPostAndCondition(), ilFulltextAdvancedSearch::__createTaxonWhereCondition(), ilFulltextAdvancedSearch::__createTitleDescriptionWhereCondition(), ilFulltextMetaDataSearch::__createTitleWhereCondition(), ilFulltextForumSearch::__createTopicAndCondition(), ilFulltextWebresourceSearch::__createWhereCondition(), ilFulltextTestSearch::__createWhereCondition(), ilFulltextGlossaryDefinitionSearch::__createWhereCondition(), ilFulltextExerciseSearch::__createWhereCondition(), ilCourseItems::__delete(), ilCourseStart::__deleteAll(), ilCourseObjectiveResult::__deleteEntries(), ilLPCollections::__deleteEntry(), ilChatRoom::__deleteFirstLine(), ilObjCourse::__deleteSettings(), ilCourseObjectiveQuestion::__deleteTest(), ilLinkChecker::__fetchUserData(), ilChatRoom::__getCountLines(), ilObjForum::__getCountNew(), ilLPStatusManual::__getCourseInProgress(), ilLPStatusManual::__getGroupInProgress(), ilSoapUserAdministration::__getGroupMemberData(), ilCourseItems::__getItemData(), ilCourseObjective::__getLastPosition(), ilCourseItems::__getLastPosition(), ilObjForum::__getLastThreadAccess(), ilLPStatusManual::__getLMInProgress(), ilLinkChecker::__getObjIdByPageId(), ilPaypalSettings::__getSettings(), ilGeneralSettings::__getSettings(), ilPaypalSettings::__getSettingsId(), ilTree::__getSubTreeByParentRelation(), ilLinkChecker::__getTitle(), ilSoapUserAdministration::__getUserFolderUsers(), ilSoapUserObjectXMLWriter::__handleUser(), ilLuceneIndexer::__indexFiles(), ilLuceneIndexer::__indexHTLMs(), ilUserResult::__init(), ilSearchResult::__init(), ilSearchFolder::__init(), ilCourseMembers::__purgeDeleted(), ilCourseItems::__purgeDeleted(), ilLPFilter::__read(), ilLPEventCollections::__read(), ilLPCollections::__read(), ilRegistrationRoleAssignments::__read(), ilPaymentVendors::__read(), ilPaymentTrustees::__read(), ilPaymentShoppingCart::__read(), ilPaymentPrices::__read(), ilPaymentObject::__read(), ilPaymentBookings::__read(), ilPaymentBillVendor::__read(), ilTimingPlaned::__read(), ilTimingAccepted::__read(), ilEventParticipants::__read(), ilEventItems::__read(), ilEventFile::__read(), ilEventAppointment::__read(), ilEvent::__read(), ilCourseWaitingList::__read(), ilCourseStart::__read(), ilCourseObjectiveQuestion::__read(), ilCourseObjectiveLM::__read(), ilCourseObjective::__read(), ilCourseMembers::__read(), ilCourseFile::__read(), ilCourseArchives::__read(), ilUserDefinedFields::__read(), ilUserDefinedData::__read(), ilObjForum::__read(), ilChatRoom::__read(), ilChatBlockedUsers::__read(), ilObjUser::__readAppliedUsers(), ilSearch::__readDBResult(), ilSearchFolder::__readRootId(), ilCron::__readSetting(), ilObjCourse::__readSettings(), ilCourseMembers::__readSubscriberData(), ilCourseMembers::__readSubscribers(), ilLinkChecker::__saveInDB(), ilPurchasePaypal::__saveTransaction(), ilAdvancedSearch::__searchClassification(), ilMetaDataSearch::__searchContribute(), ilAdvancedSearch::__searchContribute(), ilMetaDataSearch::__searchDescriptions(), ilAdvancedSearch::__searchEducational(), ilAdvancedSearch::__searchEntity(), ilAdvancedSearch::__searchFormat(), ilAdvancedSearch::__searchGeneral(), ilAdvancedSearch::__searchKeyword(), ilMetaDataSearch::__searchKeywords(), ilMDSearch::__searchKeywordsOnly(), ilAdvancedSearch::__searchLanguage(), ilAdvancedSearch::__searchLifecycle(), ilAdvancedSearch::__searchRequirement(), ilAdvancedSearch::__searchRights(), ilTestSearch::__searchSurveyIntroduction(), ilTestSearch::__searchSurveyTitle(), ilAdvancedSearch::__searchTaxon(), ilTestSearch::__searchTestIntroduction(), ilTestSearch::__searchTestTitle(), ilAdvancedSearch::__searchTitleDescription(), ilMetaDataSearch::__searchTitles(), ilAdvancedSearch::__searchTypicalAgeRange(), ilSearchResultExplorer::__setRootId(), ilLearningProgressBaseGUI::__sort(), ilObjectDataCache::__storeObjectData(), ilObjectDataCache::__storeReference(), ilCourseItems::__switchNodes(), ilSearchFolder::__treeExists(), ilLinkChecker::__txt(), ilCourseItems::__updateBottom(), ilSearch::__updateDBResult(), ilCourseObjectiveResult::__updatePassed(), ilCourseObjective::__updateTop(), ilCourseItems::__updateTop(), ilObjAssessmentFolder::_addLog(), ilObjSurvey::_addQuestionblock(), ilOnlineTracking::_addUser(), assQuestion::_areAnswered(), ilObjSurvey::_clone(), ilMailbox::_countNewMails(), ilPaymentPrices::_countPrices(), ilHistory::_createEntry(), ilLPObjSettings::_delete(), ilLPFilter::_delete(), ilTimingPlaned::_delete(), ilTimingAccepted::_delete(), ilEventItems::_delete(), ilEventAppointment::_delete(), ilEvent::_delete(), ilObjForum::_deleteAccessEntries(), ilLPEventCollections::_deleteAll(), ilLPCollections::_deleteAll(), ilEvent::_deleteAll(), ilObjCourseGrouping::_deleteAll(), ilCourseWaitingList::_deleteAll(), ilCourseObjective::_deleteAll(), ilMD::_deleteAllByType(), ilNestedSetXML::_deleteAllChildMetaData(), ilLMObject::_deleteAllObjectData(), ilTimingAccepted::_deleteByCourse(), ilCourseFile::_deleteByCourse(), ilEventParticipants::_deleteByEvent(), ilEventFile::_deleteByEvent(), ilEventAppointment::_deleteByEvent(), ilTimingPlaned::_deleteByItem(), ilTimingPlaned::_deleteByUser(), ilTimingAccepted::_deleteByUser(), ilEventParticipants::_deleteByUser(), ilChatBlockedUsers::_deleteChat(), ilLinkCheckNotify::_deleteObject(), ilObjForum::_deleteReadEntries(), ilPaymentTrustees::_deleteTrusteesOfVendor(), ilObjUserTracking::_deleteUser(), ilCourseWaitingList::_deleteUser(), ilCourseObjectiveResult::_deleteUser(), ilCourseMembers::_deleteUser(), ilCourseLMHistory::_deleteUser(), ilObjForum::_deleteUser(), ilLinkCheckNotify::_deleteUser(), ilChatBlockedUsers::_deleteUser(), ilObjTest::_evalResultsOverview(), ilEvent::_exists(), ilPageObject::_exists(), ilCourseObjectiveResult::_getAccomplished(), ilPaymentObject::_getActivation(), ilPaymentBookings::_getActivation(), ilObjTest::_getActiveTestUser(), ilNestedSetXML::_getAllChildIds(), ilLinkCheckNotify::_getAllNotifiers(), ilLocalUser::_getAllUserIds(), ilObjUser::_getAllUserLogins(), ilObjTest::_getArrayData(), ilObjRole::_getAssignUsersStatus(), ilPaymentCurrency::_getAvailableCurrencies(), ilObjQuestionPool::_getAvailableQuestionpools(), ilObjSurvey::_getAvailableSurveys(), ilObjTest::_getAvailableTests(), ilObjTest::_getBestPass(), ilLPStatusVisits::_getCompleted(), ilLPStatusTypicalLearningTime::_getCompleted(), ilLPStatusTestFinished::_getCompleted(), ilLPStatusManual::_getCompleted(), ilObjSCORMTracking::_getCompleted(), ilObjTest::_getCompleteEvaluationData(), ilObjTest::_getCompleteWorkingTimeOfParticipants(), ilConditionHandler::_getCondition(), ilConditionHandler::_getConditionsOfTarget(), ilConditionHandler::_getConditionsOfTrigger(), ilObjSurvey::_getConstraints(), ilPaymentVendors::_getCostCenter(), ilChatRoom::_getCountActiveUsers(), ilPaymentBookings::_getCountBookingsByCustomer(), ilPaymentBookings::_getCountBookingsByObject(), ilPaymentBookings::_getCountBookingsByPayMethod(), ilPaymentBookings::_getCountBookingsByVendor(), ilObjSCORMTracking::_getCountCompletedPerUser(), ilPaymentObject::_getCountObjectsByPayMethod(), ilObjTest::_getCountSystem(), ilObjForum::_getCountUnread(), ilPaymentCurrency::_getCurrency(), ilHistory::_getEntriesForObject(), ilEvent::_getEvents(), ilObjSCORMTracking::_getFailed(), ilExerciseMembers::_getFailedUsers(), ilLocalUser::_getFolderIds(), ilMDUtilSelect::_getFormatSelect(), ilObjCourseGrouping::_getGroupings(), ilObjTest::_getHidePreviousResults(), ilObjTest::_getHideTitlePoints(), ilMDTechnical::_getId(), ilMDRights::_getId(), ilMDMetaMetadata::_getId(), ilMDLifecycle::_getId(), ilMDGeneral::_getId(), ilMDEducational::_getId(), ilMDTypicalAgeRange::_getIds(), ilMDTaxonPath::_getIds(), ilMDTaxon::_getIds(), ilMDRequirement::_getIds(), ilMDRelation::_getIds(), ilMDOrComposite::_getIds(), ilMDLocation::_getIds(), ilMDLanguage::_getIds(), ilMDKeyword::_getIds(), ilMDIdentifier_::_getIds(), ilMDIdentifier::_getIds(), ilMDFormat::_getIds(), ilMDEntity::_getIds(), ilMDDescription::_getIds(), ilMDContribute::_getIds(), ilMDClassification::_getIds(), ilMDAnnotation::_getIds(), ilObjUser::_getImportedUserId(), ilLPStatusVisits::_getInProgress(), ilLPStatusTypicalLearningTime::_getInProgress(), ilLPStatusTestPassed::_getInProgress(), ilLPStatusTestFinished::_getInProgress(), ilLPStatusObjectives::_getInProgress(), ilObjSCORMTracking::_getInProgress(), ilCourseItems::_getItem(), ilLPEventCollections::_getItems(), ilLPCollections::_getItems(), ilSCORMItem::_getItems(), ilEventItems::_getItemsOfContainer(), ilObjSurvey::_getLastAccess(), ilObjTest::_getLastAccess(), ilObjAssessmentFolder::_getLog(), ilMediaItem::_getMapAreasIntLinks(), SurveyTextQuestion::_getMaxChars(), assQuestion::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilMediaItem::_getMediaItemsOfMOb(), ilCourseMembers::_getMembers(), ilExerciseMembers::_getMembers(), ilLinkCheckNotify::_getNotifiers(), ilLinkCheckNotify::_getNotifyStatus(), ilPaymentObject::_getObjectData(), ilObjTest::_getObjectIDFromActiveID(), ilObjTest::_getObjectIDFromTestID(), ilCourseObjective::_getObjectiveIds(), ilUtil::_getObjectsByOperations(), ilPaymentObject::_getObjectsData(), ilOnlineTracking::_getOnlineTime(), ilRbacReview::_getOperationIdsByName(), SurveyQuestion::_getOriginalId(), assQuestion::_getOriginalId(), ilEventParticipants::_getParticipated(), ilObjTest::_getPass(), ilExerciseMembers::_getPassedUsers(), ilObjTest::_getPassScoring(), ilObjUser::_getPersonalPicturePath(), ilTimingPlaned::_getPlanedTimings(), ilTimingPlaned::_getPlanedTimingsByItem(), ilStructureObject::_getPresentationTitle(), ilLMPageObject::_getPresentationTitle(), ilPaymentPrices::_getPrice(), ilLearningProgress::_getProgress(), ilObjSCORMTracking::_getProgressInfo(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjTest::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), SurveyTextQuestion::_getQuestionDataArray(), SurveyOrdinalQuestion::_getQuestionDataArray(), SurveyNominalQuestion::_getQuestionDataArray(), SurveyMetricQuestion::_getQuestionDataArray(), assQuestion::_getQuestionInfo(), assQuestion::_getQuestionTitle(), SurveyQuestion::_getQuestionType(), assQuestion::_getQuestionType(), ilObjSurvey::_getQuestiontypes(), ilObjTest::_getQuestiontypes(), assQuestion::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilEventParticipants::_getRegistered(), ilObjTest::_getResultPass(), ilExerciseMembers::_getReturned(), ilObjTest::_getScoreCutting(), ilSearchSettings::_getSearchSettingRefId(), assQuestion::_getSolutionMaxPass(), ilObjTest::_getSolvedQuestions(), ilLPStatusObjectives::_getStatusInfo(), ilPaymentCurrency::_getSubUnit(), ilCourseObjectiveResult::_getSuggested(), assQuestion::_getSuggestedSolution(), assQuestion::_getSuggestedSolutionCount(), ilCourseObjectiveQuestion::_getTest(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestQuestions(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestType(), assQuestion::_getTitle(), assQuestion::_getTotalAnswers(), assQuestion::_getTotalRightAnswers(), ilObjAICCLearningModule::_getTrackingItems(), ilMDEducational::_getTypicalLearningTimeSeconds(), ilPaymentCurrency::_getUnit(), ilObjTest::_getUserIdFromActiveId(), ilObjUser::_getUserIdsByEmail(), ilPaymentTrustees::_getVendorsForObjects(), ilObjCourseGrouping::_getVisibleGroupings(), ilObjTest::_getVisitTimeOfParticipant(), ilPaymentObject::_hasAccess(), ilPaymentBookings::_hasAccess(), ilCourseItems::_hasChangeableTimings(), ilCourseItems::_hasCollectionTimings(), ilLPMarks::_hasCompleted(), ilObjSurvey::_hasDatasets(), ilPaymentShoppingCart::_hasEntries(), ilTracking::_hasEntry(), ilObjQuestionPool::_hasEqualPoints(), ilObjTestAccess::_hasFinished(), ilPaymentTrustees::_hasObjectPermission(), ilPaymentTrustees::_hasObjectPermissionByVendor(), ilCourseMembers::_hasPassed(), ilPaymentTrustees::_hasStatisticPermission(), ilPaymentTrustees::_hasStatisticPermissionByVendor(), ilChatServerCommunicator::_initObject(), ilObjCourse::_isActivated(), ilCourseItems::_isActivated(), ilChatRoom::_isActive(), ilEventItems::_isAssigned(), ilCourseObjectiveQuestion::_isAssigned(), ilCourseMembers::_isBlocked(), ilChatBlockedUsers::_isBlocked(), ilPaymentObject::_isBuyable(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilPaymentObject::_isInCart(), ilCourseMembers::_isMember(), ilObjGroup::_isMember(), ilPaymentObject::_isPurchasable(), ilEventParticipants::_isRegistered(), ilCourseMembers::_isSubscriber(), assQuestion::_isUsedInRandomTest(), ilPaymentVendors::_isVendor(), assQuestion::_isWorkedThrough(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), assQuestion::_isWriteable(), ilGlossaryTerm::_lookGlossaryID(), ilGlossaryTerm::_lookGlossaryTerm(), ilGlossaryTerm::_lookLanguage(), ilLMObject::_lookupActive(), ilObjTest::_lookupAuthor(), ilObjUser::_lookupClientIP(), ilLPMarks::_lookupComment(), ilEventParticipants::_lookupComment(), ilPageObject::_lookupContainsDeactivatedElements(), ilLMObject::_lookupContObjID(), ilEvent::_lookupCourseId(), ilObjUser::_lookupEmail(), ilForum::_lookupForumData(), ilObjGroup::_lookupIdByTitle(), ilLPMarks::_lookupMark(), ilEventParticipants::_lookupMark(), ilLPObjSettings::_lookupMode(), ilObject::_lookupObjIdByImportId(), ilObjSurveyQuestionPool::_lookupOnline(), ilObjQuestionPool::_lookupOnline(), ilObjTestAccess::_lookupOnlineTestAccess(), ilPaymentObject::_lookupPobjectId(), ilForum::_lookupPostMessage(), ilObjUser::_lookupPref(), ilExerciseMembers::_lookupStatus(), ilObjTest::_lookupTestIdForQuestion(), ilObjTest::_lookupTestType(), ilObjForum::_lookupThreadSubject(), ilSCORMItem::_lookupTitle(), ilLMObject::_lookupTitle(), ilLMObject::_lookupType(), ilObjCourse::_lookupViewMode(), ilLPObjSettings::_lookupVisits(), ilPaymentPrices::_priceExists(), SurveyQuestion::_questionExists(), assQuestion::_questionExists(), ilEventAppointment::_readAppointmentsByEvent(), ilCourseObjectiveResult::_readAssignedObjectives(), ilCourseObjectiveResult::_readAssignedObjectivesOfQuestion(), ilCourseFile::_readFilesByCourse(), ilEventFile::_readFilesByEvent(), ilEventParticipants::_register(), ilObjCourse::_registrationEnabled(), SurveyQuestion::_resolveIntLinks(), ilMapArea::_resolveIntLinks(), assQuestion::_resolveIntLinks(), ilMediaItem::_resolveMapAreaLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), ilObjUser::_search(), ilObjRole::_search(), ilObjGroup::_search(), ilCourseMembers::_setPassed(), assTextQuestion::_setReachedPoints(), ilUtil::_sortIds(), ilLearningProgress::_tracProgress(), ilEventParticipants::_unregister(), ilOnlineTracking::_updateAccess(), ilCourseLMHistory::_updateLastAccess(), ilCourseObjectiveResult::_updateObjectiveStatus(), ilObjForum::_updateOldAccess(), ilEventParticipants::_updateParticipation(), ilCourseMembers::_updatePassed(), ilLearningProgress::_updateProgress(), ilObjQuestionPool::_updateQuestionCount(), ilCourseMembers::_updateStatus(), ilLMObject::_writeActive(), ilObject::_writeDescription(), ilLMObject::_writeTitle(), ilLPEventCollections::add(), ilLPCollections::add(), ilRegistrationRoleAssignments::add(), ilPaymentVendors::add(), ilPaymentTrustees::add(), ilPaymentShoppingCart::add(), ilPaymentPrices::add(), ilPaymentObject::add(), ilPaymentBookings::add(), ilParameterAppender::add(), ilLinkResourceItems::add(), ilCourseStart::add(), ilCourseObjectiveQuestion::add(), ilCourseObjectiveLM::add(), ilCourseObjective::add(), ilCourseArchives::add(), ilUserDefinedFields::add(), ilRoleDesktopItem::add(), ilChatRoom::add(), ilObjSurvey::addConstraint(), ilAddressbook::addEntry(), ilMailbox::addFolder(), ilLinkCheckNotify::addNotifier(), SurveyOrdinalQuestion::addPhrase(), ilForum::addPostTree(), ilObjTest::addQuestionSequence(), ilObjTest::addSelectedUser(), ilCourseMembers::addSubscriber(), ilCourseWaitingList::addToList(), ilObjDlBook::addTranslation(), ilObjUser::addUserDefinedFieldEntry(), ilFileDataMail::assignAttachmentsToDirectory(), ilExerciseMembers::assignMember(), ilSearchFolder::assignResult(), ilChatBlockedUsers::block(), ilObjUserFolder::buildExportFile(), assTextSubset::calculateReachedPoints(), assTextQuestion::calculateReachedPoints(), assSingleChoice::calculateReachedPoints(), assQuestionTypeTemplate::calculateReachedPoints(), assOrderingQuestion::calculateReachedPoints(), assNumeric::calculateReachedPoints(), assMultipleChoice::calculateReachedPoints(), assMatchingQuestion::calculateReachedPoints(), assJavaApplet::calculateReachedPoints(), assImagemapQuestion::calculateReachedPoints(), assClozeTest::calculateReachedPoints(), ilObjTest::canShowSolutionPrintview(), ilCronCheckUserAccounts::check(), ilAddressbook::checkEntry(), ilAddressbook::checkEntryByLogin(), ilCourseObjectiveLM::checkExists(), ilConditionHandler::checkExists(), ilLinkChecker::checkLinks(), ilObjTest::checkMaximumAllowedUsers(), ilPaypalSettings::clearAll(), ilGeneralSettings::clearAll(), ilObjTest::clearEvalSelectedUsers(), ilObjTest::cloneRandomQuestions(), ilElementList::countDbByQuery(), ilTimingPlaned::create(), ilTimingAccepted::create(), ilEventFile::create(), ilEventAppointment::create(), ilEvent::create(), ilObjCourseGrouping::create(), ilCourseFile::create(), ilMediaItem::create(), ilLMObject::create(), ilSearchFolder::create(), ilObject::create(), ilCourseItems::createDefaultEntry(), ilMailbox::createDefaultFolder(), ilPageObject::createFromXML(), ilMailOptions::createMailOptionsEntry(), ilObjSurvey::createQuestionblock(), ilObjForum::createSettings(), ilObjSurvey::createSurveyCodes(), ilObjUserFolder::createXMLExport(), ilFileDataMail::deassignAttachmentFromDirectory(), ilExerciseMembers::deassignMember(), SurveyQuestion::delete(), ilLPEventCollections::delete(), ilLPCollections::delete(), ilRegistrationRoleAssignments::delete(), ilMDTypicalAgeRange::delete(), ilMDTechnical::delete(), ilMDTaxonPath::delete(), ilMDTaxon::delete(), ilMDRights::delete(), ilMDRequirement::delete(), ilMDRelation::delete(), ilMDMetaMetadata::delete(), ilMDLocation::delete(), ilMDLifecycle::delete(), ilMDLanguage::delete(), ilMDKeyword::delete(), ilMDIdentifier_::delete(), ilMDIdentifier::delete(), ilMDGeneral::delete(), ilMDFormat::delete(), ilMDEntity::delete(), ilMDEducational::delete(), ilMDDescription::delete(), ilMDContribute::delete(), ilMDClassification::delete(), ilMDAnnotation::delete(), ilSetting::delete(), ilPaymentVendors::delete(), ilPaymentTrustees::delete(), ilPaymentShoppingCart::delete(), ilPaymentPrices::delete(), ilPaymentObject::delete(), ilPaymentBookings::delete(), ilPaymentBillVendor::delete(), ilLinkResourceItems::delete(), ilEventFile::delete(), ilObjCourseGrouping::delete(), ilCourseStart::delete(), ilCourseObjectiveQuestion::delete(), ilCourseObjectiveLM::delete(), ilCourseObjective::delete(), ilCourseMembers::delete(), ilCourseFile::delete(), ilCourseArchives::delete(), ilPageObject::delete(), ilLMObject::delete(), ilUserDefinedFields::delete(), ilSearchFolder::delete(), ilRoleDesktopItem::delete(), ilObjGroup::delete(), ilObjForum::delete(), ilObjExercise::delete(), ilObject::delete(), ilObjCategory::delete(), ilExerciseMembers::delete(), ilConditionHandler::delete(), ilObjChat::delete(), ilChatRoom::delete(), ilChatRecording::delete(), assQuestion::delete(), ilObjTest::deleteActiveTests(), SurveyQuestion::deleteAdditionalTableData(), assQuestion::deleteAdditionalTableData(), ilMD::deleteAll(), ilPaymentTrustees::deleteAll(), ilCourseObjectiveQuestion::deleteAll(), ilCourseObjectiveLM::deleteAll(), ilRoleDesktopItem::deleteAll(), ilObjSurveyQuestionPool::deleteAllData(), ilCourseMembers::deleteAllEntries(), ilCourseItems::deleteAllEntries(), ilMediaItem::deleteAllItemsOfMob(), ilChatRoom::deleteAllMessages(), ilPaymentPrices::deleteAllPrices(), ilObjSurvey::deleteAllUserData(), assQuestion::deleteAnswers(), ilConditionHandler::deleteByObjId(), ilConditionHandler::deleteCondition(), ilObjSurvey::deleteConstraint(), ilObjSurvey::deleteConstraints(), ilExerciseMembers::deleteDeliveredFiles(), ilAddressbook::deleteEntry(), ilMailbox::deleteFolder(), ilMail::deleteMails(), ilObjNoteFolder::deleteNotes(), ilLinkCheckNotify::deleteNotifier(), ilObjSurveyQuestionPool::deletePhrases(), ilForum::deletePost(), ilForum::deletePostTree(), ilObjSurveyQuestionPoolGUI::deleteQuestionsObject(), ilObjTest::deleteResults(), ilCourseMembers::deleteSubscriber(), assQuestion::deleteSuggestedSolutions(), ilObjSurvey::deleteSurveyRecord(), ilObjTest::deleteTest(), ilObjDlBook::deleteTranslation(), ilTree::deleteTree(), ilObjUser::deleteUserDefinedFieldEntries(), ilUserDefinedFields::deleteValue(), ilObjSurvey::deleteWorkingData(), ilObjExercise::deliverFile(), ilExerciseMembers::deliverReturnedFiles(), ilObjSurvey::disinviteUser(), ilObjTest::disinviteUser(), ilExerciseMembers::downloadSelectedFiles(), ilChatRoom::drop(), ilObjTest::duplicate(), ilPaymentShoppingCart::emptyShoppingCart(), exercise(), ilCourseStart::exists(), ilObjDlBook::export(), ilNestedSetXML::export(), ilLMPresentationGUI::exportbibinfo(), ilChatRecording::exportMessages(), ilObjDlBook::exportRekursiv(), ilGlossaryExport::exportRekursiv(), ilContObjectExport::exportRekursiv(), ilObjSurvey::finishSurvey(), ilForum::fixThreadNumber(), ilObjLanguage::flush(), ilLanguage::flushLanguages(), ilMailbox::folderNameExists(), ilObjTest::get_qpl_titles(), ilObjTest::getActiveIdOfUser(), ilObjTest::getActiveTestUser(), ilObjTest::getActiveTestUserFromActiveId(), assQuestion::getActiveUserData(), ilChatRoom::getActiveUsers(), ilCourseMembers::getAdmins(), ilRoleDesktopItem::getAll(), ilExerciseMembers::getAllDeliveredFiles(), ilLinkResourceItems::getAllItems(), ilChatRoom::getAllMessages(), ilObjQuestionPool::getAllQuestionIds(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilChatRoom::getAllRoomsOfObject(), ilObjSurvey::getAnonymousId(), ilObjTest::getArrayData(), ilFileDataMail::getAttachmentPath(), ilLanguage::getAvailableLanguages(), SurveyOrdinalQuestion::getAvailablePhrases(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), ilPaymentBookings::getBooking(), ilPaymentBookings::getBookingsOfCustomer(), SurveyOrdinalQuestion::getCategoriesForPhrase(), ilObjTest::getCompleteEvaluationData(), ilObjSurvey::getConstraints(), ilChatRoom::getCountActiveUser(), ilObjForum::getCountNew(), ilCourseMembers::getCountPassed(), SurveyTextQuestion::getCumulatedResults(), SurveyOrdinalQuestion::getCumulatedResults(), SurveyNominalQuestion::getCumulatedResults(), SurveyMetricQuestion::getCumulatedResults(), ilObjSurvey::getCumulatedResults(), ilElement::getDbDataByQuery(), ilElement::getDbValueByQuery(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilMailbox::getDraftsFolder(), ilAddressbook::getEntries(), ilPaymentShoppingCart::getEntry(), ilAddressbook::getEntry(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationParticipants(), ilObjTest::getEvaluationUsers(), ilObjSurvey::getExistingQuestions(), ilObjTest::getExistingQuestions(), ilObjGroup::getExpirationTimestamp(), ilObjUserFolder::getExportSettings(), ilForum::getFirstPostByThread(), ilForumExport::getFirstPostNode(), ilForum::getFirstPostNode(), ilMailbox::getFolderData(), ilObjSurvey::getForbiddenQuestionpools(), ilObjTest::getGroupData(), ilMailbox::getInboxFolder(), ilLanguage::getInstalledLanguages(), ilLanguage::getInstalledLocalLanguages(), ilLMObjectFactory::getInstance(), ilSearchItemFactory::getInstance(), assQuestion::getInstances(), ilLinkChecker::getInvalidLinksFromDB(), ilObjSurvey::getInvitedGroups(), ilObjSurvey::getInvitedUsers(), ilObjTest::getInvitedUsers(), ilLinkResourceItems::getItem(), ilRoleDesktopItem::getItem(), ilObjSurvey::getLastActivePage(), ilLinkChecker::getLastCheckTimestamp(), ilMailbox::getLastInsertId(), ilCourseLMHistory::getLastLM(), ilCourseLMHistory::getLMHistory(), ilObjAssessmentFolder::getLog(), ilObjUser::getLoginByUserId(), ilMail::getMail(), ilMail::getMailsOfFolder(), ilCourseMembers::getMembers(), ilObjAssessmentFolder::getNrOfLogEntries(), ilObjTest::getNrOfResultsForPass(), ilLMObject::getObjectList(), ilObjSurvey::getObligatoryStates(), ilForumExport::getOneThread(), ilForum::getOneThread(), ilForumExport::getOneTopic(), ilForum::getOneTopic(), ilRbacReview::getOperation(), ilRbacReview::getOperations(), ilRbacReview::getOperationsOnTypeString(), ilMailOptions::getOptions(), ilMDOrComposite::getOrCompositeId(), ilMailbox::getParentFolderId(), ilObjTest::getPassFinishDate(), SurveyQuestion::getPhrase(), ilForum::getPostById(), ilForum::getPostDepth(), ilForum::getPostNode(), ilForumExport::getPostTree(), ilForum::getPostTree(), ilObjQuestionPool::getPrintviewQuestions(), ilObjQuestionPool::getQplQuestions(), ilObjSurvey::getQuestionblock(), ilObjSurvey::getQuestionblockQuestionIds(), ilObjSurvey::getQuestionblockQuestions(), ilObjSurvey::getQuestionblocks(), ilObjSurvey::getQuestionblocksTable(), ilObjSurvey::getQuestionblockTitles(), ilObjTest::getQuestionDataset(), ilObjQuestionPool::getQuestionDetails(), ilObjQuestionPool::getQuestionList(), ilObjSurvey::getQuestionpoolTitles(), ilObjSurveyQuestionPool::getQuestions(), ilObjSurvey::getQuestions(), ilObjSurveyQuestionPool::getQuestionsInfo(), ilObjSurveyQuestionPool::getQuestionsTable(), ilObjSurvey::getQuestionsTable(), ilObjTest::getQuestionsTable(), ilObjQuestionPool::getQuestionsTable(), ilObjTest::getQuestiontext(), ilObjTest::getQuestionTitles(), ilObjSurveyQuestionPool::getQuestiontype(), ilObjSurvey::getQuestionType(), ilObjTest::getQuestionType(), ilObjQuestionPool::getQuestiontype(), assQuestion::getQuestionTypeFromDb(), ilObjSurvey::getQuestiontypes(), ilObjQuestionPool::getQuestionTypes(), ilObjTest::getRandomQuestionDuplicate(), ilObjTest::getRandomQuestionpools(), assJavaApplet::getReachedInformation(), assQuestion::getReachedPoints(), ilChatRecording::getRecord(), ilChatRecord::getRecord(), ilChatRecording::getRecordings(), ilObjTest::getRoleData(), ilRbacReview::getRoleOperationsOnObject(), ilChatRoom::getRooms(), ilChatRoom::getRoomsOfObject(), ilMail::getSavedData(), ilMailbox::getSentFolder(), assQuestion::getSolutionValues(), ilObjTest::getStartingTimeOfUser(), ilObjUser::getStoredActive(), ilMailbox::getSubFolders(), ilObjSurvey::getSurveyCodesCount(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyParticipants(), ilObjSurvey::getSurveyQuestions(), ilDBUpdate::getTables(), ilDBUpdate::getTableStatus(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilObjTest::getTestQuestions(), ilCourseObjectiveQuestion::getTests(), ilObjTest::getTextAnswer(), ilForum::getThreadList(), ilObjSCORMLearningModule::getTrackedItems(), ilObjAICCLearningModule::getTrackedItems(), ilObjAICCLearningModule::getTrackingData(), ilObjSCORMLearningModule::getTrackingDataAgg(), ilObjSCORMLearningModule::getTrackingDataPerUser(), ilMailbox::getTrashFolder(), ilCourseMembers::getTutors(), ilObjQuestionPool::getUsedQuestionDetails(), ilObjSurvey::getUserAccessCode(), ilForumExport::getUserData(), ilForum::getUserData(), ilObjTest::getUserData(), ilSoapUserAdministration::getUserForRole(), ilObjUser::getUserIdByEmail(), ilObjUser::getUserIdByLogin(), ilObjSurvey::getUserSurveyCode(), ilObjSurvey::getVariables(), ilObjTest::getWorkedQuestions(), ilCourseObjectiveResult::hasAccomplishedObjective(), ilMailbox::hasNewMail(), ilExerciseMembers::hasReturned(), ilObjForum::ilClone(), ilExerciseMembers::ilClone(), ilMDConvert(), ilSetting::ilSetting(), ilNestedSetXML::init(), ilObjCourse::initDefaultRoles(), ilLPObjSettings::insert(), ilObjLanguage::insert(), assQuestion::insertIntoTest(), ilLanguage::insertLanguage(), ilForum::insertPostNode(), ilObjSurvey::insertQuestion(), ilObjTest::insertQuestion(), ilObjSurvey::insertQuestionblock(), ilLanguage::installLanguages(), ilChatRoom::invite(), ilObjSurvey::inviteUser(), ilObjTest::inviteUser(), ilObjTest::isAccessCodeUsed(), ilObjTest::isActiveTestSubmitted(), ilObjSurvey::isAnonymizedParticipant(), ilObjSurvey::isAnonymousKey(), ilRoleDesktopItem::isAssigned(), ilRepositoryExplorer::isClickable(), assQuestion::isClone(), ilPaymentShoppingCart::isInShoppingCart(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), assQuestion::isInUse(), ilChatRoom::isInvited(), ilChatRoom::isKicked(), ilObjForum::isNew(), ilObjForum::isRead(), ilChatRecording::isRecording(), ilChatRecord::isRecording(), ilCourseMembers::isSubscriber(), ilObjSurvey::isSurveyCodeUsed(), ilObjSurvey::isSurveyStarted(), ilSCORMPresentationGUI::launchSahs(), ilHACPPresentationGUI::launchSahs(), ilSAHSPresentationGUI::launchSahs(), ilAICCPresentationGUI::launchSahs(), SurveyTextQuestion::loadFromDb(), SurveyQuestion::loadFromDb(), SurveyOrdinalQuestion::loadFromDb(), SurveyNominalQuestion::loadFromDb(), SurveyMetricQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjSurvey::loadFromDb(), ilObjTest::loadFromDb(), ilObjQuestionPool::loadFromDb(), assTextSubset::loadFromDb(), assTextQuestion::loadFromDb(), assSingleChoice::loadFromDb(), assQuestionTypeTemplate::loadFromDb(), assQuestion::loadFromDb(), assOrderingQuestion::loadFromDb(), assNumeric::loadFromDb(), assMultipleChoice::loadFromDb(), assMatchingQuestion::loadFromDb(), ASS_MarkSchema::loadFromDb(), assJavaApplet::loadFromDb(), assImagemapQuestion::loadFromDb(), assClozeTest::loadFromDb(), ilLanguage::loadLanguageModule(), SurveyQuestion::loadMaterialFromDb(), ilObjTest::loadQuestions(), ilObjSurvey::loadQuestionsFromDb(), ilObjSurvey::loadWorkingData(), ilChatRoom::lookupRoomId(), ilObjForum::markAllThreadsRead(), ilObjForum::markPostRead(), ilMail::markRead(), ilObjForum::markThreadRead(), ilMail::markUnread(), ilPaymentTrustees::modify(), ilObjSurvey::modifyQuestionblock(), ilCourseObjective::moveDown(), ilMail::moveMailsToFolder(), ilCourseObjective::moveUp(), ilUserDefinedFields::nameExists(), ilObjectFactory::ObjectIdExists(), ilLMPresentationGUI::offlineexport(), ilObjLanguage::optimizeData(), ilDBUpdate::optimizeTables(), ilObjQuestionPool::pasteFromClipboard(), ilWebresourceSearch::performSearch(), ilUserSearch::performSearch(), ilUserDefinedFieldSearch::performSearch(), ilObjectSearch::performSearch(), ilMediaPoolSearch::performSearch(), ilLMContentSearch::performSearch(), ilGlossaryDefinitionSearch::performSearch(), ilForumSearch::performSearch(), ilExerciseSearch::performSearch(), SurveyQuestion::phraseExists(), ilDBx::prepare(), ilElement::queryDb(), ilObjTest::questionMoveDown(), ilObjTest::questionMoveUp(), ilObjSurveyQuestionPoolGUI::questionsObject(), ilObjSurveyGUI::questionsObject(), SurveyQuestion::questionTitleExists(), assQuestion::questionTitleExists(), ilObjTest::randomSelectQuestions(), ilMDTypicalAgeRange::read(), ilMDTechnical::read(), ilMDTaxonPath::read(), ilMDTaxon::read(), ilMDRights::read(), ilMDRequirement::read(), ilMDRelation::read(), ilMDMetaMetadata::read(), ilMDLocation::read(), ilMDLifecycle::read(), ilMDLanguage::read(), ilMDKeyword::read(), ilMDIdentifier_::read(), ilMDIdentifier::read(), ilMDGeneral::read(), ilMDFormat::read(), ilMDEntity::read(), ilMDEducational::read(), ilMDDescription::read(), ilMDContribute::read(), ilMDClassification::read(), ilMDAnnotation::read(), ilObjCourseGrouping::read(), ilPageObject::read(), ilMediaItem::read(), ilLMObject::read(), ilSearchResult::read(), ilObjExercise::read(), ilObject::read(), ilExerciseMembers::read(), ilObjDlBook::readAssignedTranslations(), ilLinkResourceItems::readItem(), ilMail::readMailObjectReferenceId(), ilTree::readRootId(), ilMetaTechnical::readTechnicalSections(), ilObjUser::readUserDefinedFields(), ilObjTest::removeAllTestEditings(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilCourseWaitingList::removeFromList(), ilObjLanguageFolder::removeLanguages(), ilObjTest::removeNonRandomTestData(), ilObjSurvey::removeQuestions(), ilObjTest::removeRandomTestData(), ilObjSurvey::removeSelectedSurveyResults(), ilObjTest::removeSelectedTestResults(), ilObjTest::removeSelectedUser(), ilObjTest::removeTestResultsForUser(), ilChatRoom::rename(), ilMailbox::renameFolder(), ilCourseObjectiveResult::reset(), ilObjLanguage::resetUserLanguage(), ilObjTest::retrieveTestTypes(), ilRegistrationRoleAssignments::save(), ilSearchResult::save(), ilMail::saveAttachments(), SurveyQuestion::saveCategoriesToDb(), SurveyQuestion::saveCategoryToDb(), ilObjTest::saveCompleteStatus(), SurveyQuestion::saveCompletionStatus(), ilObjSurvey::saveCompletionStatus(), ilObjExercise::saveData(), ilObjTest::saveECTSStatus(), ilObjSurvey::saveHeading(), SurveyQuestion::saveMaterialsToDb(), ilObjNote::saveNote(), SurveyOrdinalQuestion::savePhrase(), ilMail::savePostData(), ilSoapUtils::saveQuestionResult(), ilObjSurvey::saveQuestionsToDb(), ilObjTest::saveQuestionsToDb(), ilObjTest::saveRandomQuestion(), ilObjTest::saveRandomQuestionCount(), ilObjTest::saveRandomQuestionpools(), SurveyTextQuestion::saveToDb(), SurveyQuestion::saveToDb(), SurveyOrdinalQuestion::saveToDb(), SurveyNominalQuestion::saveToDb(), SurveyMetricQuestion::saveToDb(), ilObjSurveyQuestionPool::saveToDb(), ilObjSurvey::saveToDb(), ilObjTest::saveToDb(), ilObjQuestionPool::saveToDb(), assTextSubset::saveToDb(), assTextQuestion::saveToDb(), assSingleChoice::saveToDb(), assQuestionTypeTemplate::saveToDb(), assQuestion::saveToDb(), assOrderingQuestion::saveToDb(), assNumeric::saveToDb(), assMultipleChoice::saveToDb(), assMatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), assJavaApplet::saveToDb(), assImagemapQuestion::saveToDb(), assClozeTest::saveToDb(), ilObjSurvey::saveUserAccessCode(), SurveyTextQuestion::saveUserInput(), SurveyOrdinalQuestion::saveUserInput(), SurveyNominalQuestion::saveUserInput(), SurveyMetricQuestion::saveUserInput(), ilObjSurvey::saveWorkingData(), assTextSubset::saveWorkingData(), assTextQuestion::saveWorkingData(), assSingleChoice::saveWorkingData(), assQuestionTypeTemplate::saveWorkingData(), assQuestion::saveWorkingData(), assOrderingQuestion::saveWorkingData(), assNumeric::saveWorkingData(), assMultipleChoice::saveWorkingData(), assMatchingQuestion::saveWorkingData(), assImagemapQuestion::saveWorkingData(), assClozeTest::saveWorkingData(), SurveySearch::search(), ilSoapUserAdministration::searchUser(), ilObjUser::searchUsers(), ilAddressbook::searchUsers(), ilElementList::selectDbAllByQuery(), ilMail::sendInternalMail(), ilCourseMembers::sendNotificationToAdmins(), ilCourseMembers::sendSubscriptionRequestToAdmins(), ilCourseMembers::sendUnsubscribeNotificationToAdmins(), Session::Session(), ilObjTest::setActiveTestSubmitted(), ilObjTest::setActiveTestUser(), ilPaypalSettings::setAll(), ilGeneralSettings::setAll(), ilObjTest::setClientIP(), ilObjSurvey::setInvitation(), ilObjSurvey::setInvitationAndMode(), ilObjSurvey::setInvitationMode(), ilChatRoom::setKicked(), ilDBx::setMaxAllowedPacket(), ilExerciseMembers::setNoticeForMember(), ilObjSurvey::setObligatoryStates(), ilObjTest::setQuestionSetSolved(), assTextQuestion::setReachedPoints(), ilExerciseMembers::setStatusFeedbackForMember(), ilExerciseMembers::setStatusForMember(), ilExerciseMembers::setStatusReturnedForMember(), ilExerciseMembers::setStatusSentForMember(), ilNestedSetXML::setTagName(), ilNestedSetXML::setTagValue(), ilChatRoom::setUnkicked(), ilObjForumGUI::showStatisticsObject(), ilChatRecording::startRecording(), ilChatRecord::startRecording(), ilObjSurvey::startSurvey(), ilChatRecording::stopRecording(), ilChatRecord::stopRecording(), ilConditionHandler::storeCondition(), SurveyTextQuestion::syncWithOriginal(), SurveyQuestion::syncWithOriginal(), SurveyOrdinalQuestion::syncWithOriginal(), SurveyNominalQuestion::syncWithOriginal(), SurveyMetricQuestion::syncWithOriginal(), assTextSubset::syncWithOriginal(), assTextQuestion::syncWithOriginal(), assSingleChoice::syncWithOriginal(), assQuestionTypeTemplate::syncWithOriginal(), assQuestion::syncWithOriginal(), assOrderingQuestion::syncWithOriginal(), assNumeric::syncWithOriginal(), assMultipleChoice::syncWithOriginal(), assMatchingQuestion::syncWithOriginal(), assJavaApplet::syncWithOriginal(), assImagemapQuestion::syncWithOriginal(), assClozeTest::syncWithOriginal(), ilDBx::tableColumnExists(), ilObjTest::testTitleExists(), ilCron::txt(), ilCronCheckUserAccounts::txt(), ilLanguage::txtlng(), ilChatBlockedUsers::unblock(), ilObjSurvey::unfoldQuestionblocks(), ilLPObjSettings::update(), ilLPMarks::update(), ilLPFilter::update(), ilPaymentVendors::update(), ilPaymentShoppingCart::update(), ilPaymentPrices::update(), ilPaymentObject::update(), ilPaymentBookings::update(), ilPaymentBillVendor::update(), ilLinkResourceItems::update(), ilEventItems::update(), ilEventAppointment::update(), ilEvent::update(), ilObjCourseGrouping::update(), ilCourseObjective::update(), ilCourseMembers::update(), ilCourseItems::update(), ilPageObject::update(), ilMediaItem::update(), ilLMObject::update(), ilUserDefinedFields::update(), ilUserDefinedData::update(), ilObjForum::update(), ilObjExercise::update(), ilObject::update(), ilMetaData::update(), ilLinkResourceItems::updateActive(), ilConditionHandler::updateCondition(), ilLinkResourceItems::updateDisableCheck(), ilMail::updateDraft(), ilAddressbook::updateEntry(), ilPageObject::updateFromXML(), ilObjForum::updateLastAccess(), ilLinkResourceItems::updateLastCheck(), ilChatRoom::updateLastVisit(), ilMailbox::updateMailsOfDeletedUser(), ilMailOptions::updateOptions(), ilObjCourse::updateSettings(), ilExerciseMembers::updateStatusTimeForMember(), ilCourseWaitingList::updateSubscriptionTime(), ilCourseMembers::updateSubscriptionTime(), ilCourseObjectiveQuestion::updateTest(), ilUserResult::updateTitle(), ilSearchResult::updateTitle(), ilSearchFolder::updateTitle(), ilEventParticipants::updateUser(), ilObjUser::updateUserDefinedFields(), ilLinkResourceItems::updateValid(), ilLinkResourceItems::updateValidByCheck(), ilConditionHandler::validate(), and ilObjNote::viewObject().
| foreach ($perms as $perm) $query1 = "SELECT obj_id FROM object_data WHERE title = 'il_grp_member' " |
Definition at line 601 of file dbupdate.php.
Referenced by ilObjDlBook::_search(), and ilObjContentObject::_search().
| $query10 = "' AND type = 'grp' AND ops_id = 4 " |
Definition at line 632 of file dbupdate.php.
| $query11 = "')" |
Definition at line 636 of file dbupdate.php.
| $query12 = "')" |
Definition at line 638 of file dbupdate.php.
| $query13 = "' AND type = 'slm' AND ops_id = 5 " |
Definition at line 642 of file dbupdate.php.
| $query14 = "' AND type = 'slm' AND ops_id = 6 " |
Definition at line 644 of file dbupdate.php.
| $query2 = "obj_id"] |
Definition at line 606 of file dbupdate.php.
Referenced by ilObjDlBook::_search(), ilObjContentObject::_search(), ilForum::deletePost(), ilObjTest::removeAllTestEditings(), ilObjTest::removeSelectedTestResults(), and ilObjTest::removeTestResultsForUser().
| $query3 = "' AND type = 'crs'" |
Definition at line 612 of file dbupdate.php.
Referenced by ilForum::deletePost(), ilObjTest::removeAllTestEditings(), ilObjTest::removeSelectedTestResults(), and ilObjTest::removeTestResultsForUser().
| $query4 = "' AND type = 'frm' AND ops_id = 5 " |
Definition at line 616 of file dbupdate.php.
Referenced by ilForum::deletePost().
| $query5 = "' AND type = 'frm' AND ops_id = 6 " |
Definition at line 618 of file dbupdate.php.
Referenced by ilForum::deletePost().
| $query6 = "')" |
Definition at line 620 of file dbupdate.php.
| $query7 = "')" |
Definition at line 624 of file dbupdate.php.
| $query8 = "')" |
Definition at line 626 of file dbupdate.php.
| $query9 = "')" |
Definition at line 630 of file dbupdate.php.
| $rbacadmin = new ilRbacAdmin() |
Definition at line 1191 of file dbupdate.php.
Referenced by ilForumImportParser::__addModerator(), ilRegistrationGUI::__assignRole(), ilObjCourse::__getDefaultCourseRoles(), ilSoapUserAdministration::__getGroupMemberData(), ilObjCourse::__setCourseStatus(), ilObjGroup::__setGroupStatus(), ilCourseMembers::add(), ilObjiLincCourse::addMember(), ilObjGroup::addMember(), ilPermissionGUI::addRole(), ilSoapRBACAdministration::addRoleFromTemplate(), ilSoapUserAdministration::addUser(), ilSoapRBACAdministration::addUserRoleEntry(), ilObjRoleTemplateGUI::adoptPermSaveObject(), ilObjRoleGUI::adoptPermSaveObject(), ilObjUserGUI::assignSaveObject(), ilObjCategoryGUI::assignSaveObject(), ilUserImportParser::assignToRole(), ilObjRoleGUI::assignUserObject(), ilBookmarkAdministrationGUI::confirm(), ilObjectGUI::confirmedDeleteObject(), ilObjNote::createObject(), ilObjRoleFolder::createRole(), ilObjRoleGUI::deassignUserObject(), ilCourseMembers::delete(), ilObjUser::delete(), ilObjRoleTemplate::delete(), ilObjRole::delete(), ilObject::delete(), ilSoapCourseAdministration::deleteCourse(), ilSoapObjectAdministration::deleteObject(), ilSoapRBACAdministration::deleteUserRoleEntry(), ilUserImportParser::detachFromRole(), ilObjUserGUI::editObject(), ilUserImportParser::getCourseMembersObjectForRole(), ilObjGroup::getDefaultGroupRoles(), ilObjiLincCourse::getDefaultRoles(), ilObjGroup::getGroupMemberData(), ilObjGroup::getGroupMemberIds(), ilObjGroup::getLocalGroupRoles(), ilObjiLincCourse::getLocalRoles(), ilObjiLincCourse::getMemberData(), ilObjiLincCourse::getMemberIds(), ilObjiLincCourse::getMemberRoles(), ilObjGroup::getMemberRoles(), ilSoapRBACAdministration::grantPermissions(), ilCategoryImportParser::handlerBeginTag(), ilCategoryImportParser::handlerEndTag(), ilObjSurveyQuestionPool::ilClone(), ilObjSurvey::ilClone(), ilObjLinkResource::ilClone(), ilObjiLincCourse::ilClone(), ilObjSAHSLearningModule::ilClone(), ilObjMediaPool::ilClone(), ilObjGlossary::ilClone(), ilObjFileBasedLM::ilClone(), ilObjContentObject::ilClone(), ilObj< module_name >::ilClone(), ilObjUserFolder::ilClone(), ilObjSysUserTracking::ilClone(), ilObjSystemFolder::ilClone(), ilObjStyleSheetFolder::ilClone(), ilObjStyleSettings::ilClone(), ilObjRootFolder::ilClone(), ilObjRoleTemplate::ilClone(), ilObjRoleFolder::ilClone(), ilObjRole::ilClone(), ilObjRecoveryFolder::ilClone(), ilObjObjectFolder::ilClone(), ilObjGroup::ilClone(), ilObjForum::ilClone(), ilObjExternalToolsSettings::ilClone(), ilObjExercise::ilClone(), ilObjCategory::ilClone(), ilObjAuthSettings::ilClone(), ilObjAssessmentFolder::ilClone(), ilObjAdvancedEditing::ilClone(), ilObjTest::ilClone(), ilObjQuestionPool::ilClone(), ilUserImportParser::importEndTag(), ilInitialisation::initAccessHandling(), ilObjiLincCourse::initDefaultRoles(), ilObjCourse::initDefaultRoles(), ilObjMediaPool::initDefaultRoles(), ilObjFileBasedLM::initDefaultRoles(), ilObjContentObject::initDefaultRoles(), ilObj< module_name >::initDefaultRoles(), ilObjSysUserTracking::initDefaultRoles(), ilObjStyleSheetFolder::initDefaultRoles(), ilObjStyleSettings::initDefaultRoles(), ilObjRecoveryFolder::initDefaultRoles(), ilObjGroup::initDefaultRoles(), ilObjForum::initDefaultRoles(), ilObjExternalToolsSettings::initDefaultRoles(), ilObjAuthSettings::initDefaultRoles(), ilObjAssessmentFolder::initDefaultRoles(), ilObjAdvancedEditing::initDefaultRoles(), ilObjChat::initDefaultRoles(), ilObjTest::initDefaultRoles(), ilObjQuestionPool::initDefaultRoles(), ilObjectGUI::insertSavedNodes(), ilObjiLincCourse::join(), ilObjGroup::join(), ilObjiLincCourse::leave(), ilObjGroup::leave(), ilObjGroup::leaveGroup(), ilContainerGUI::linkObject(), ilSOAPAuth::login(), ilCASAuth::login(), ShibAuth::login(), ilContainerGUI::pasteObject(), ilObjRoleTemplateGUI::permObject(), ilObjRoleGUI::permObject(), ilPermissionGUI::permSave(), ilObjRoleTemplateGUI::permSaveObject(), ilObjRoleGUI::permSaveObject(), ilObjRoleFolder::purge(), ilValidator::restoreDeletedObjects(), ilValidator::restoreMissingObjects(), ilValidator::restoreSubTrees(), ilSoapRBACAdministration::revokePermissions(), ilRegistrationGUI::saveForm(), ilObjSurveyQuestionPoolGUI::saveObject(), ilObjSurveyGUI::saveObject(), ilObjLinkResourceGUI::saveObject(), ilObjiLincCourseGUI::saveObject(), ilObjCourseGUI::saveObject(), ilObjSAHSLearningModuleGUI::saveObject(), ilObjMediaPoolGUI::saveObject(), ilObjGlossaryGUI::saveObject(), ilObjFileBasedLMGUI::saveObject(), ilObjContentObjectGUI::saveObject(), GUI::saveObject(), ilObjUserGUI::saveObject(), ilObjTypeDefinitionGUI::saveObject(), ilObjStyleSheetFolderGUI::saveObject(), ilObjStyleSettingsGUI::saveObject(), ilObjRoleTemplateGUI::saveObject(), ilObjRoleGUI::saveObject(), ilObjRoleFolderGUI::saveObject(), ilObjRecoveryFolderGUI::saveObject(), ilObjGroupGUI::saveObject(), ilObjForumGUI::saveObject(), ilObjExerciseGUI::saveObject(), ilObjAssessmentFolderGUI::saveObject(), ilObjAdvancedEditingGUI::saveObject(), ilObjChatGUI::saveObject(), ilObjTestGUI::saveObject(), ilObjQuestionPoolGUI::saveObject(), ilSCORMExplorer::setOutput(), ilExplorer::setOutput(), ilObject::setPermissions(), ilPasswordAssistanceGUI::showAssignPasswordForm(), ilPasswordAssistanceGUI::submitAssignPasswordForm(), ilPasswordAssistanceGUI::submitAssistanceForm(), ilPasswordAssistanceGUI::submitUsernameAssistanceForm(), ilCourseMembers::update(), ilObjCourseGUI::updateMembersObject(), ilObjUserGUI::updateObject(), ilObjRoleTemplateGUI::updateObject(), ilObjRoleGUI::updateObject(), and ilObjTypeDefinitionGUI::viewObject().
| $rbacreview = new ilRbacReview() |
Definition at line 1192 of file dbupdate.php.
Referenced by ilObjectXMLWriter::__appendOperations(), ilRoleDesktopItem::__assign(), ilRegistrationSettingsGUI::__buildRoleSelection(), ilObjCategoryGUI::__checkGlobalRoles(), ilPermissionGUI::__filterRoles(), ilObjectGUI::__filterRoles(), ilObjCategoryGUI::__getAssignableRoles(), ilObjCourse::__getDefaultCourseRoles(), ilSoapUserAdministration::__getGroupMemberData(), ilObjCourse::__getLocalRoles(), ilLPListOfProgressGUI::__initUser(), ilObjCourse::__setCourseStatus(), ilObjGroup::__setGroupStatus(), ilObjGroup::_getMembers(), ilForum::_getModerators(), ilUtil::_getObjectsByOperations(), ilObjCategoryGUI::_importCategoriesForm(), ilObjiLincCourse::_isMember(), ilObjGroup::_isMember(), ilObjRole::_updateSessionRoles(), ilObjUserGUI::activeRoleSaveObject(), ilRegistrationSettingsGUI::addAssignment(), ilObjNoteFolder::addNote(), ilSoapRBACAdministration::addRole(), ilPermissionGUI::addRole(), ilSoapRBACAdministration::addRoleFromTemplate(), ilObjTest::addSelectedRole(), ilSoapUserAdministration::addUser(), ilObjRoleTemplateGUI::adoptPermSaveObject(), ilObjRoleGUI::adoptPermSaveObject(), ilObjCategoryGUI::assignRolesObject(), ilObjUserGUI::assignSaveObject(), ilObjCategoryGUI::assignSaveObject(), ilUserImportParser::assignToRole(), ilObjRoleGUI::assignUserObject(), ilRbacSystem::checkAccessOfUser(), ilMail::checkRecipients(), ilObjRoleFolderGUI::confirmedDeleteObject(), ilRbacAdmin::copyRolePermission(), ilRbacAdmin::copyRolePermissionIntersection(), ilObjUserGUI::createObject(), ilObjRoleFolder::createRole(), ilObject::createRoleFolder(), ilObjUserFolder::createXMLExport(), ilObjRoleGUI::deassignUserObject(), ilObjRoleFolder::delete(), ilObjRole::delete(), ilRegistrationSettingsGUI::deleteAssignment(), ilSoapRBACAdministration::deleteRole(), ilUserImportParser::detachFromRole(), ilObjAuthSettingsGUI::editCASObject(), ilRegistrationSettingsGUI::editEmailAssignments(), ilObjExternalToolsSettingsGUI::editiLincObject(), ilObjUserGUI::editObject(), ilObjTypeDefinitionGUI::editObject(), ilObjRoleTemplateGUI::editObject(), ilObjRoleGUI::editObject(), ilObjAuthSettingsGUI::editRADIUSObject(), ilRegistrationSettingsGUI::editRoles(), ilObjAuthSettingsGUI::editSHIBObject(), ilObjAuthSettingsGUI::editSOAPObject(), ilObjiLincCourse::getAdminIds(), ilObjChatServerGUI::getAdminTabs(), ilObjectStatusGUI::getAssignedValidRoles(), ilObjRole::getCountMembers(), ilUserImportParser::getCourseMembersObjectForRole(), ilObjGroup::getDefaultGroupRoles(), ilObjiLincCourse::getDefaultRoles(), ilObjGroup::getGroupAdminIds(), ilObjGroup::getGroupMemberData(), ilObjGroup::getGroupMemberIds(), ilObjUser::getGroupMemberships(), ilObjGroup::getGroupStatus(), ilObjGroup::getLocalGroupRoles(), ilSoapRBACAdministration::getLocalRoles(), ilObjiLincCourse::getLocalRoles(), ilObjiLincCourse::getMemberData(), ilObjiLincCourse::getMemberIds(), ilObjiLincCourse::getMemberRoles(), ilObjGroup::getMemberRoles(), ilForum::getModerators(), ilObjectStatusGUI::getObjectSummary(), ilSoapRBACAdministration::getObjectTreeOperations(), ilSoapRBACAdministration::getOperations(), ilObjectStatusGUI::getPermissionInfo(), ilObjUser::getProfileAsString(), ilObjectStatusGUI::getRoleAssignmentInfo(), ilSoapRBACAdministration::getRoles(), ilPermissionGUI::getRolesData(), ilObjLinkResourceGUI::getTabs(), ilObjRoleTemplateGUI::getTabs(), ilObjRoleGUI::getTabs(), ilObjChatGUI::getTabs(), ilSoapUserAdministration::getUserForRole(), ilMail::getUserIds(), ilSoapRBACAdministration::getUserRoles(), ilSoapUserAdministration::getUsersForContainer(), ilCategoryImportParser::handlerBeginTag(), ilObjectStatusGUI::ilObjectStatusGUI(), ilUserImportParser::importEndTag(), ilObjUserFolderGUI::importUserRoleAssignmentObject(), ilSoapUserAdministration::importUsers(), ilObjUserFolderGUI::importUsersObject(), ilInitialisation::initAccessHandling(), ilObjiLincCourse::initDefaultRoles(), ilObjCourse::initDefaultRoles(), ilObjContentObject::initDefaultRoles(), ilObjGroup::initDefaultRoles(), ilInitialisation::initUserAccount(), ilObjectGUI::insertSavedNodes(), ilObjSurvey::inviteRole(), ilObjTest::inviteRole(), ilObjiLincCourse::isAdmin(), ilObjGroup::isAdmin(), ilObjGroup::leaveGroup(), ilObjRoleGUI::listDesktopItemsObject(), ilLMStatisticsGUI::listUsersGroup(), ilObjiLincCourseGUI::listUsersGroupObject(), ilObjRoleGUI::listUsersGroupObject(), ilObjGroupGUI::listUsersGroupObject(), ilObjCategoryGUI::listUsersObject(), ilLMStatisticsGUI::listUsersRole(), ilRepositorySearchGUI::listUsersRole(), ilObjiLincCourseGUI::listUsersRoleObject(), ilObjCourseGUI::listUsersRoleObject(), ilObjRoleGUI::listUsersRoleObject(), ilObjGroupGUI::listUsersRoleObject(), ilObjiLincCourseGUI::mailMembersObject(), ilObjCourseGUI::mailMembersObject(), ilObjGroupGUI::mailMembersObject(), ilContainerGUI::pasteObject(), ilPermissionGUI::perm(), ilObjRoleTemplateGUI::permObject(), ilObjRoleGUI::permObject(), ilPermissionGUI::permSave(), ilObjRoleTemplateGUI::permSaveObject(), ilObjRoleGUI::permSaveObject(), ilObjRoleFolder::purge(), ilRbacAdmin::revokePermission(), ilObjUserGUI::roleassignmentObject(), ilRegistrationSettingsGUI::saveAssignment(), ilObjTypeDefinitionGUI::saveObject(), ilObjRoleTemplateGUI::saveObject(), ilObjRoleGUI::saveObject(), ilObjUserFolderGUI::searchUserObject(), ilObject::setPermissions(), ilPasswordAssistanceGUI::showAssignPasswordForm(), ilPersonalProfileGUI::showProfile(), ilPasswordAssistanceGUI::submitAssignPasswordForm(), ilPasswordAssistanceGUI::submitAssistanceForm(), ilPasswordAssistanceGUI::submitUsernameAssistanceForm(), ilObjUser::updateActiveRoles(), ilObjRoleTemplateGUI::updateObject(), ilObjRoleGUI::updateObject(), ilSoapObjectAdministration::updateObjects(), ilRegistrationSettingsGUI::updateRoles(), ilObjRoleGUI::userassignmentObject(), ilObjTypeDefinitionGUI::viewObject(), and ilObjRoleFolderGUI::viewObject().
| while ($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) $rbacsystem = & new ilRbacSystem() |
Definition at line 2117 of file dbupdate.php.
Referenced by ilObjCourse::__setCourseStatus(), ilObjGroup::__setGroupStatus(), ilRbacReview::__setProtectedStatus(), ilLearningProgressBaseGUI::__setSubTabs(), ilObjiLincCourseGUI::__setSubTabs(), ilObjGroupGUI::__setSubTabs(), ilObjFolderGUI::__setSubTabs(), ilCourseItemAdministrationGUI::__setTabs(), ilPersonalDesktopGUI::__showActiveChatsOfUser(), ilObjChatGUI::__showActiveUsers(), ilObjChatGUI::__showAdminRoomSelect(), ilObjRoleGUI::__showAssignedUsersTable(), ilPersonalDesktopGUI::__showChatInvitation(), ilCourseObjectivePresentationGUI::__showLearningMaterials(), ilCourseContentInterface::__showLearningMaterials(), ilObjiLincCourseGUI::__showMembersTable(), ilObjGroupGUI::__showMembersTable(), ilCourseObjectivePresentationGUI::__showOtherResources(), ilCourseContentInterface::__showOtherResources(), ilObjUserGUI::__showRolesTable(), ilObjRoleFolderGUI::__showRolesTable(), ilObjChatGUI::__showRooms(), ilCourseObjectivePresentationGUI::__showTests(), ilCourseContentInterface::__showTests(), ilObjSurveyAccess::_checkAccess(), ilObjiLincCourseAccess::_checkAccess(), ilObjiLincClassroomAccess::_checkAccess(), ilObjCourseAccess::_checkAccess(), ilObjSAHSLearningModuleAccess::_checkAccess(), ilObjGlossaryAccess::_checkAccess(), ilObjFileBasedLMAccess::_checkAccess(), ilObjContentObjectAccess::_checkAccess(), ilObjGroupAccess::_checkAccess(), ilObjTestAccess::_checkAccess(), ilMainMenuGUI::_checkAdministrationPermission(), ilPaymentObject::_getActivation(), ilObjQuestionPool::_getAvailableQuestionpools(), ilObjSurvey::_getAvailableSurveys(), ilObjTest::_getAvailableTests(), ilLocalUser::_getFolderIds(), ilStructureObjectGUI::_goto(), ilObjGlossaryGUI::_goto(), ilObjFileBasedLMGUI::_goto(), ilLMPageObjectGUI::_goto(), ilGlossaryTermGUI::_goto(), ilObjExerciseGUI::_goto(), ilPaymentObject::_hasAccess(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), ilSoapCourseAdministration::addCourse(), ilObjCourseGUI::addFromWaitingList(), ilSoapGroupAdministration::addGroup(), ilObjLinkResourceGUI::addItemObject(), ilSoapObjectAdministration::addObject(), ilCourseObjectivesGUI::addObjective(), ilSoapObjectAdministration::addReference(), ilSoapRBACAdministration::addRole(), ilPermissionGUI::addRole(), ilSoapRBACAdministration::addRoleFromTemplate(), ilObjChatGUI::addRoom(), ilObjChatGUI::addRoomObject(), ilObjCourseGUI::addStarterObject(), ilObjCourseGUI::addSubscribers(), ilSoapUserAdministration::addUser(), ilObjPaymentSettingsGUI::addUserObject(), ilObjPaymentSettingsGUI::addVendorObject(), ilObjChatGUI::adminAddRoomObject(), ilObjChatGUI::adminRoomsObject(), ilObjRoleTemplateGUI::adoptPermSaveObject(), ilObjRoleGUI::adoptPermSaveObject(), ilObjUserFolderGUI::appliedUsersObject(), ilCourseObjectivesGUI::askDeassignQuestion(), ilObjRoleGUI::askDeleteDesktopItemObject(), ilObjLinkResourceGUI::askDeleteItemsObject(), ilCourseObjectivesGUI::askDeleteLM(), ilCourseObjectivesGUI::askDeleteObjective(), ilObjChatGUI::askDeleteRecordingsObject(), ilCourseObjectivesGUI::assignChapterSelect(), ilSoapCourseAdministration::assignCourseMember(), ilObjRoleGUI::assignDesktopItemObject(), ilSoapGroupAdministration::assignGroupMember(), ilCourseObjectivesGUI::assignLM(), ilCourseObjectivesGUI::assignLMChapter(), ilCourseObjectivesGUI::assignLMSelect(), ilObjCourseGUI::assignMembersObject(), ilCourseObjectivesGUI::assignQuestion(), ilCourseObjectivesGUI::assignQuestionSelect(), ilObjUserGUI::assignSaveObject(), ilCourseObjectivesGUI::assignTestSelect(), ilObjRoleGUI::assignUserObject(), ilObjAuthSettingsGUI::authSettingsObject(), ilObjCourseGUI::autoFillObject(), ilObjSystemFolderGUI::benchmarkObject(), ilObjChatGUI::blockedUsersObject(), ilObjChatGUI::blockUserObject(), ilObjSurveyGUI::browseForQuestionsObject(), ilCourseContentInterface::cci_objectives(), ilCourseContentInterface::cci_start_objects(), ilCourseContentInterface::cci_view(), ilObjSystemFolderGUI::changeHeaderTitleObject(), ilPermissionGUI::changeOwner(), ilObjRoleGUI::checkAccess(), ilSurveyEvaluationGUI::checkAnonymizedEvaluationAccess(), ilForum::checkEditRight(), ilObjSystemFolderGUI::checkObject(), ilMail::checkRecipients(), ilObjSurveyGUI::codesObject(), ilBookmarkAdministrationGUI::confirm(), ilObjGroupGUI::confirmDeleteExportFileObject(), ilObjUserTrackingGUI::confirmDeletionDataObject(), ilObjUserFolderGUI::confirmedDeleteObject(), ilObjRoleFolderGUI::confirmedDeleteObject(), ilObjectGUI::confirmedDeleteObject(), ilObjChatGUI::confirmedDeleteRoomObject(), ilObjSurveyGUI::constraintsObject(), ilLMObjectGUI::create(), ilObjSurveyQuestionPoolGUI::createExportFileObject(), ilObjSurveyGUI::createExportFileObject(), ilObjQuestionPoolGUI::createExportFileObject(), ilObjSurveyQuestionPoolGUI::createObject(), ilObjSurveyGUI::createObject(), ilObjiLincCourseGUI::createObject(), ilObjCourseGUI::createObject(), ilObjGlossaryGUI::createObject(), ilObjFileBasedLMGUI::createObject(), ilObjContentObjectGUI::createObject(), ilObjUserGUI::createObject(), ilObjStyleSheetGUI::createObject(), ilObjRoleTemplateGUI::createObject(), ilObjRoleGUI::createObject(), ilObjNote::createObject(), ilObjGroupGUI::createObject(), ilObjForumGUI::createObject(), ilObjFileGUI::createObject(), ilObjectGUI::createObject(), ilObjCategoryGUI::createObject(), ilObjTestGUI::createObject(), ilObjQuestionPoolGUI::createObject(), ilContainerGUI::cutObject(), ilCourseObjectivesGUI::deassignQuestion(), ilObjRoleGUI::deassignUserObject(), ilSoapCourseAdministration::deleteCourse(), ilObjUserTrackingGUI::deleteDataObject(), ilObjRoleGUI::deleteDesktopItemsObject(), ilObjLinkResourceGUI::deleteItemsObject(), ilCourseObjectivesGUI::deleteLM(), ilObjCourseGUI::deleteMembers(), ilObjNoteFolder::deleteNotes(), ilSoapObjectAdministration::deleteObject(), ilCourseObjectivesGUI::deleteObjectives(), ilObjSurveyQuestionPoolGUI::deleteQuestionsObject(), ilObjChatGUI::deleteRecordingsObject(), ilSoapRBACAdministration::deleteRole(), ilObjChatGUI::deleteRoom(), ilObjCourseGUI::deleteStarterObject(), ilObjCourseGUI::deleteSubscribers(), ilSoapUserAdministration::deleteUser(), ilObjSystemFolderGUI::displayBasicSettings(), ilObjSystemFolderGUI::displayList(), ilObjLanguageFolderGUI::displayList(), ilPersonalDesktopGUI::displayUsersOnline(), ilObjCourseGUI::downloadArchivesObject(), ilObjExerciseGUI::downloadFileObject(), ilObjUserFolderGUI::editAppliedUsersObject(), ilObjStyleSettingsGUI::editBasicSettingsObject(), ilObjAuthSettingsGUI::editCASObject(), ilObjStyleSettingsGUI::editContentStylesObject(), ilObjCourseGUI::editCourseIconsObject(), ilObjExternalToolsSettingsGUI::editiLincObject(), ilObjLinkResourceGUI::editItemObject(), ilObjLinkResourceGUI::editItemsObject(), ilObjAuthSettingsGUI::editLDAPObject(), ilObjCourseGUI::editMemberObject(), ilObjFileBasedLMGUI::editObject(), ilObjUserGUI::editObject(), ilObjTypeDefinitionGUI::editObject(), ilObjStyleSheetGUI::editObject(), ilObjRoleTemplateGUI::editObject(), ilObjRoleGUI::editObject(), ilObjGroupGUI::editObject(), ilObjForumGUI::editObject(), ilObjFileGUI::editObject(), ilObjExerciseGUI::editObject(), ilObjectGUI::editObject(), ilObjCategoryGUI::editObject(), ilObjChatServerGUI::editObject(), ilCourseObjectivesGUI::editObjective(), ilContainerGUI::editPageContentObject(), ilCourseObjectivesGUI::editQuestionAssignment(), ilObjAuthSettingsGUI::editRADIUSObject(), ilObjAuthSettingsGUI::editScriptObject(), ilObjAuthSettingsGUI::editSHIBObject(), ilObjAuthSettingsGUI::editSOAPObject(), ilObjStyleSettingsGUI::editSystemStylesObject(), ilObjStyleSheetGUI::editTagStyleObject(), ilObjPaymentSettingsGUI::editVendor(), ilObjChatGUI::emptyRoom(), ilSurveyEvaluationGUI::evaluation(), ilSoapCourseAdministration::excludeCourseMember(), ilSoapGroupAdministration::excludeGroupMember(), ilSearchresultGUI::executeCommand(), ilSearchController::executeCommand(), ilRepositorySearchGUI::executeCommand(), ilAdvancedSearchGUI::executeCommand(), ilMDEditorGUI::executeCommand(), ilObjLinkResourceGUI::executeCommand(), ilObjiLincUserGUI::executeCommand(), ilObjiLincCourseGUI::executeCommand(), ilObjCourseGUI::executeCommand(), ilCourseContentInterface::executeCommand(), ilSearchGUI::executeCommand(), ilPermissionGUI::executeCommand(), ilObjUserGUI::executeCommand(), ilObjSystemFolderGUI::executeCommand(), ilObjRootFolderGUI::executeCommand(), ilObjRoleTemplateGUI::executeCommand(), ilObjRoleGUI::executeCommand(), ilObjGroupGUI::executeCommand(), ilObjectGUI::executeCommand(), ilObjCategoryGUI::executeCommand(), ilInfoScreenGUI::executeCommand(), ilObjChatGUI::executeCommand(), ilObjQuestionPoolGUI::executeCommand(), exercise(), ilObjSurveyGUI::exportObject(), ilObjChatGUI::exportRecordingObject(), ilObjGroupGUI::exportXMLObject(), ilObjPaymentSettingsGUI::generalSettingsObject(), ilObjTest::get_qpl_titles(), ilObjSystemFolderGUI::getAdminTabs(), ilObjectGUI::getAdminTabs(), ilObjChatServerGUI::getAdminTabs(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), ilSoapCourseAdministration::getCourseXML(), ilObjUser::getDesktopItems(), ilObjQuestionPoolGUI::getEmbeddedTabs(), ilObjSurvey::getForbiddenQuestionpools(), ilObjGroup::getGroupStatus(), ilCourseItems::getItems(), ilSoapRBACAdministration::getObjectTreeOperations(), ilObjSurveyListGUI::getProperties(), ilObjiLincCourseListGUI::getProperties(), ilObjSAHSLearningModuleListGUI::getProperties(), ilObjLearningModuleListGUI::getProperties(), ilObjGlossaryListGUI::getProperties(), ilObjFileBasedLMListGUI::getProperties(), ilObjDlBookListGUI::getProperties(), ilObjGroupListGUI::getProperties(), ilObjSurvey::getQuestionpoolTitles(), ilSoapRBACAdministration::getRoles(), ilPermissionGUI::getRolesData(), ilPersonalDesktopGUI::getSelectedItemsBlockHTML(), ilPersonalDesktopGUI::getSelectedItemsPerLocation(), ilPersonalDesktopGUI::getSelectedItemsPerType(), ilObjUserTrackingGUI::getTabs(), ilObjSearchSettingsGUI::getTabs(), ilObjPaymentSettingsGUI::getTabs(), ilObjLinkResourceGUI::getTabs(), ilObjiLincCourseGUI::getTabs(), ilObjCourseGUI::getTabs(), ilObjSAHSLearningModuleGUI::getTabs(), ilObjGlossaryGUI::getTabs(), ilObjFileBasedLMGUI::getTabs(), ilObjContentObjectGUI::getTabs(), ilObjUserGUI::getTabs(), ilObjUserFolderGUI::getTabs(), ilObjTypeDefinitionGUI::getTabs(), ilObjStyleSettingsGUI::getTabs(), ilObjRootFolderGUI::getTabs(), ilObjRoleTemplateGUI::getTabs(), ilObjRoleGUI::getTabs(), ilObjRoleFolderGUI::getTabs(), ilObjObjectFolderGUI::getTabs(), ilObjMailGUI::getTabs(), ilObjLanguageFolderGUI::getTabs(), ilObjGroupGUI::getTabs(), ilObjForumGUI::getTabs(), ilObjFolderGUI::getTabs(), ilObjFileGUI::getTabs(), ilObjExternalToolsSettingsGUI::getTabs(), ilObjCategoryGUI::getTabs(), ilObjAuthSettingsGUI::getTabs(), ilObjAssessmentFolderGUI::getTabs(), ilObjAdvancedEditingGUI::getTabs(), ilInfoScreenGUI::getTabs(), ilForumTabsGUI::getTabs(), ilContainerGUI::getTabs(), ilObjChatGUI::getTabs(), ilSoapUserAdministration::getUser(), ilSoapUserAdministration::getUserForRole(), ilSoapUserAdministration::getUsersForContainer(), ilCategoryImportParser::handlerBeginTag(), ilCourseMembers::hasAccess(), ilObjLinkResourceGUI::historyObject(), ilAccessHandler::ilAccessHandler(), ilContainerGUI::ilContainerGUI(), ilLMEditorGUI::ilLMEditorGUI(), ilLMPresentationGUI::ilLMPresentationGUI(), ilLMPresentationGUI::ilLMSubMenu(), ilObjAdvancedEditingGUI::ilObjAdvancedEditingGUI(), ilObjAssessmentFolderGUI::ilObjAssessmentFolderGUI(), ilObjectListGUI::ilObjectListGUI(), ilObjQuestionPoolGUI::ilObjQuestionPoolGUI(), ilObjSurveyGUI::ilObjSurveyGUI(), ilObjSurveyQuestionPoolGUI::ilObjSurveyQuestionPoolGUI(), ilObjTestGUI::ilObjTestGUI(), ilPersonalDesktopGUI::ilPersonalDesktopGUI(), ilPersonalProfileGUI::ilPersonalProfileGUI(), ilPurchaseBMFGUI::ilPurchaseBMFGUI(), ilObjCourseGUI::importFileObject(), ilObjGlossaryGUI::importFileObject(), ilObjContentObjectGUI::importFileObject(), ilObjSurveyQuestionPoolGUI::importObject(), ilObjMailGUI::importObject(), ilObjectGUI::importObject(), ilObjQuestionPoolGUI::importObject(), ilObjUserFolderGUI::importUserRoleAssignmentObject(), ilSoapUserAdministration::importUsers(), ilObjUserFolderGUI::importUsersObject(), ilObjGroupGUI::infoScreen(), ilInitialisation::initAccessHandling(), ilInitialisation::initILIAS(), ilObjSurveyGUI::inviteObject(), ilSoapCourseAdministration::isAssignedToCourse(), ilSoapGroupAdministration::isAssignedToGroup(), ilSearchResultExplorer::isClickable(), ilRoleDesktopItemSelector::isClickable(), ilRepositoryLinkSelector::isClickable(), ilRepositoryExplorer::isClickable(), ilObjGroup::isUserRegistered(), ilRepositoryExplorer::isVisible(), ilExplorer::isVisible(), ilAdministrationExplorer::isVisible(), ilObjiLincCourseGUI::joinObject(), ilObjChatGUI::kickUser(), ilObjUserFolderGUI::learningProgressExcelExportObject(), ilObjUserFolderGUI::learningProgressObject(), ilContainerGUI::linkObject(), ilCourseObjectivesGUI::listAssignedLM(), ilCourseObjectivesGUI::listAssignedQuestions(), ilObjRoleGUI::listDesktopItemsObject(), ilObjGroupGUI::listExportFilesObject(), ilObjLinkResourceGUI::listItemsObject(), ilCourseObjectivesGUI::listObjectives(), ilObjCourseGUI::listStructureObject(), ilLMStatisticsGUI::listUsersGroup(), ilRepositorySearchGUI::listUsersGroup(), ilObjiLincCourseGUI::listUsersGroupObject(), ilObjCourseGUI::listUsersGroupObject(), ilObjRoleGUI::listUsersGroupObject(), ilObjGroupGUI::listUsersGroupObject(), ilObjCategoryGUI::listUsersObject(), ilLMStatisticsGUI::listUsersRole(), ilRepositorySearchGUI::listUsersRole(), ilObjiLincCourseGUI::listUsersRoleObject(), ilObjCourseGUI::listUsersRoleObject(), ilObjRoleGUI::listUsersRoleObject(), ilObjGroupGUI::listUsersRoleObject(), ilSoapUserAdministration::lookupUser(), ilObjSurveyGUI::maintenanceObject(), ilObjiLincCourseGUI::membersGalleryObject(), ilObjCourseGUI::membersGalleryObject(), ilObjGroupGUI::membersGalleryObject(), ilObjiLincCourseGUI::membersObject(), ilObjGroupGUI::membersObject(), ilObjExerciseGUI::membersObject(), ilCourseObjectivesGUI::moveObjectiveDown(), ilCourseObjectivesGUI::moveObjectiveUp(), ilSurveyExecutionGUI::navigate(), ilObjExerciseGUI::newMembersObject(), ilTestOutputGUI::outTestPage(), ilObjSurveyGUI::outUserGroupTable(), ilContainerGUI::pasteObject(), ilObjPaymentSettingsGUI::payMethodsObject(), ilObjPaymentSettingsGUI::paypalSettingsObject(), ilObjPaymentSettingsGUI::performDeleteVendorsObject(), ilObjPaymentSettingsGUI::performEditVendorObject(), ilObjMailGUI::performImportObject(), ilObjCourseGUI::performRemoveFromWaitingListObject(), ilObjCourseGUI::performUnsubscribeObject(), ilPermissionGUI::perm(), ilObjRoleTemplateGUI::permObject(), ilObjRoleGUI::permObject(), ilPermissionGUI::permSave(), ilObjRoleTemplateGUI::permSaveObject(), ilObjRoleGUI::permSaveObject(), ilObjSurveyQuestionPoolGUI::phrasesObject(), ilObjCourseGUI::printMembersObject(), ilObjSCORMLearningModuleGUI::properties(), ilObjGlossaryGUI::properties(), ilObjFileBasedLMGUI::properties(), ilObjSurveyQuestionPoolGUI::questionsObject(), ilObjSurveyGUI::questionsObject(), ilObjQuestionPoolGUI::questionsObject(), ilObjTest::randomSelectQuestions(), ilObjChatGUI::recordingsObject(), ilSoapObjectAdministration::removeFromSystemByImportId(), ilObjRecoveryFolderGUI::removeFromSystemObject(), ilObjectGUI::removeFromSystemObject(), ilObjCourseGUI::removeFromWaitingList(), ilObjCourseGUI::removeMembersObject(), ilObjCourseGUI::removeSubscribersObject(), ilObjChatGUI::renameRoomObject(), ilObjUserGUI::roleassignmentObject(), ilObjPaymentSettingsGUI::saveGeneralSettingsObject(), ilObjiLincCourseGUI::saveObject(), ilObjGlossaryGUI::saveObject(), ilObjContentObjectGUI::saveObject(), ilObjUserGUI::saveObject(), ilObjTypeDefinitionGUI::saveObject(), ilObjRoleTemplateGUI::saveObject(), ilObjRoleGUI::saveObject(), ilObjFileGUI::saveObject(), ilObjectGUI::saveObject(), ilCourseObjectivesGUI::saveObjective(), ilObjPaymentSettingsGUI::savePayMethodsObject(), ilObjPaymentSettingsGUI::savePaypalSettingsObject(), ilObjSearchSettingsGUI::saveSettingsObject(), ilObjSystemFolderGUI::saveSettingsObject(), SurveySearch::search(), ilLMStatisticsGUI::search(), ilObjPaymentSettingsGUI::searchObject(), ilObjiLincCourseGUI::searchObject(), ilObjCourseGUI::searchObject(), ilObjRoleGUI::searchObject(), ilObjGroupGUI::searchObject(), ilSoapUserAdministration::searchUser(), ilLMStatisticsGUI::searchUserForm(), ilObjiLincCourseGUI::searchUserFormObject(), ilObjRoleGUI::searchUserFormObject(), ilObjGroupGUI::searchUserFormObject(), ilObjPaymentSettingsGUI::searchUserObject(), ilObjCourseGUI::searchUserObject(), ilObjRoleGUI::selectDesktopItemObject(), ilObjCourseGUI::selectStarterObject(), ilMail::sendMail(), ilCronForumNotification::sendNotifications(), ilObjectGUIAdapter::setAdminTabs(), ilObjAuthSettingsGUI::setAuthModeObject(), ilSurveyEvaluationGUI::setEvalTabs(), ilSCORMExplorer::setOutput(), ilExplorer::setOutput(), SurveyQuestionGUI::setQuestionTabsForClass(), ilObjCourseGUI::setSubTabs(), ilObjUserFolderGUI::setSubTabs(), ilMainMenuGUI::setTemplateVars(), ilObjUserTrackingGUI::settingsObject(), ilObjSearchSettingsGUI::settingsObject(), ilObjUserFolderGUI::showActions(), ilObjLinkResourceGUI::showAddItemObject(), ilMaterialExplorer::showChilds(), ilSearchRootSelector::showChilds(), ilPaymentObjectSelector::showChilds(), ilObjectSelector::showChilds(), ilLMMenuObjectSelector::showChilds(), ilIntLinkRepItemExplorer::showChilds(), ilSearchResultExplorer::showChilds(), ilRoleDesktopItemSelector::showChilds(), ilRepositoryLinkSelector::showChilds(), ilRepositoryExplorer::showChilds(), ilRepositoryCopySelector::showChilds(), ilConditionSelector::showChilds(), ilSolutionExplorer::showChilds(), ilObjChatGUI::showFrames(), ilObjChatGUI::showInputFrame(), ilInfoScreenGUI::showLearningProgress(), ilObjGroupGUI::showNewRegistrationsObject(), ilObjPaymentSettingsGUI::showObjectSelectorObject(), ilObjUserFolderGUI::showPossibleSubObjects(), ilObjRoleFolderGUI::showPossibleSubObjects(), ilRegisterGUI::showRegistrationForm(), ilCourseContentGUI::showStartObjects(), ilObjForumGUI::showStatisticsObject(), ilObjForumGUI::showThreadsObject(), ilSurveyExecutionGUI::start(), ilObjChatGUI::startRecording(), ilTestOutputGUI::startTest(), ilObjSystemFolderGUI::startValidator(), ilObjPaymentSettingsGUI::statisticObject(), ilObjChatGUI::stopRecording(), ilObjChatGUI::unblockUsersObject(), ilObjectGUI::undeleteObject(), ilObjChatGUI::unkickUser(), ilObjCourseGUI::unsubscribeObject(), ilObjUserFolderGUI::updateAppliedUsersObject(), ilObjAuthSettingsGUI::updateAuthRolesObject(), ilSoapCourseAdministration::updateCourse(), ilObjCourseGUI::updateCourseIconsObject(), ilObjLinkResourceGUI::updateItemObject(), ilObjLinkResourceGUI::updateItemsObject(), ilObjCourseGUI::updateMemberObject(), ilObjExerciseGUI::updateMembersObject(), ilObjiLincCourseGUI::updateMemberStatusObject(), ilObjGroupGUI::updateMemberStatusObject(), ilObjiLincCourseGUI::updateObject(), ilObjUserGUI::updateObject(), ilObjRoleTemplateGUI::updateObject(), ilObjRoleGUI::updateObject(), ilObjGroupGUI::updateObject(), ilObjExerciseGUI::updateObject(), ilObjCategoryGUI::updateObject(), ilObjChatServerGUI::updateObject(), ilCourseObjectivesGUI::updateObjective(), ilSoapObjectAdministration::updateObjects(), ilSoapUserAdministration::updatePassword(), ilCourseObjectivesGUI::updateQuestionAssignment(), ilSoapUserAdministration::updateUser(), ilObjExerciseGUI::uploadFileObject(), ilObjSAHSLearningModuleGUI::uploadObject(), ilObjMailGUI::uploadObject(), ilObjRoleGUI::userassignmentObject(), ilObjPaymentSettingsGUI::vendorsObject(), ilObjFileGUI::versionsObject(), ilCourseObjectivePresentationGUI::view(), ilCourseContentGUI::view(), ilObjCourseGUI::viewObject(), ilObjGlossaryGUI::viewObject(), ilObjUserFolderGUI::viewObject(), ilObjSystemFolderGUI::viewObject(), ilObjStyleSheetFolderGUI::viewObject(), ilObjRoleFolderGUI::viewObject(), ilObjObjectFolderGUI::viewObject(), viewObject(), ilObjLanguageFolderGUI::viewObject(), ilObjGroupGUI::viewObject(), ilObjExternalToolsSettingsGUI::viewObject(), ilObjExerciseGUI::viewObject(), ilObjectGUI::viewObject(), and ilObjChatGUI::viewObject().
| $ref_id = $row[0] |
Definition at line 394 of file dbupdate.php.
| $res = $this->db->query($q) |
Definition at line 201 of file dbupdate.php.
| $result = $this->db->query($query) |
Definition at line 3058 of file dbupdate.php.
Referenced by ilObjCourseGUI::__appendToStoredResults(), ilObjGroupGUI::__appendToStoredResults(), ilObjiLincUser::__createLoginData(), ilObjExerciseGUI::__getMembersOfObject(), ilPaypalSettings::__getSettings(), ilGeneralSettings::__getSettings(), ilPaypalSettings::__getSettingsId(), ilSoapUserAdministration::__getUserFolderUsers(), ilBookmarkImportExport::__parseExport(), ilBookmarkImportExport::__parseNetscape(), ilSearchGUI::__performDetailsSearch(), ilPurchaseBMFGUI::__sendBill(), ilRepositorySearchGUI::__showSearchResults(), ilRepositorySearchGUI::__updateResults(), ilObjAssessmentFolder::_addLog(), ilObjSurvey::_addQuestionblock(), ilObjTestAccess::_checkCondition(), ilObjSurvey::_clone(), Spreadsheet_Excel_Writer_Parser::_condition(), ilObjTest::_evalResultsOverview(), Spreadsheet_Excel_Writer_Parser::_expression(), Spreadsheet_Excel_Writer_Parser::_fact(), Spreadsheet_Excel_Writer_Parser::_func(), ilObjTest::_getActiveTestUser(), ilObjAdvancedEditing::_getAllHTMLTagsAsString(), ilObjTest::_getArrayData(), ilObjQuestionPool::_getAvailableQuestionpools(), ilObjSurvey::_getAvailableSurveys(), ilObjTest::_getAvailableTests(), ilObjTest::_getBestPass(), ilObjTest::_getCompleteEvaluationData(), ilObjTest::_getCompleteWorkingTimeOfParticipants(), ilObjSurvey::_getConstraints(), ilObjTest::_getCountSystem(), ilObjSurvey::_getGlobalSurveyData(), ilObjTest::_getHidePreviousResults(), ilObjTest::_getHideTitlePoints(), ilObjSurvey::_getLastAccess(), ilObjTest::_getLastAccess(), ilObjAssessmentFolder::_getLog(), SurveyTextQuestion::_getMaxChars(), assQuestion::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilObjTest::_getObjectIDFromActiveID(), ilObjTest::_getObjectIDFromTestID(), SurveyQuestion::_getOriginalId(), assQuestion::_getOriginalId(), ilObjTest::_getPass(), ilObjTest::_getPassScoring(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjTest::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), SurveyTextQuestion::_getQuestionDataArray(), SurveyOrdinalQuestion::_getQuestionDataArray(), SurveyNominalQuestion::_getQuestionDataArray(), SurveyMetricQuestion::_getQuestionDataArray(), assQuestion::_getQuestionInfo(), assQuestion::_getQuestionTitle(), SurveyQuestion::_getQuestionType(), assQuestion::_getQuestionType(), assQuestion::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilObjTest::_getResultPass(), ilObjTest::_getScoreCutting(), assQuestion::_getSolutionMaxPass(), assQuestion::_getSuggestedSolution(), assQuestion::_getSuggestedSolutionCount(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestQuestions(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestType(), assQuestion::_getTitle(), assQuestion::_getTotalAnswers(), assQuestion::_getTotalRightAnswers(), ilObjAdvancedEditing::_getUsedHTMLTagsAsString(), ilObjTest::_getUserIdFromActiveId(), ilObjTest::_getVisitTimeOfParticipant(), ilObjSurvey::_hasDatasets(), ilObjQuestionPool::_hasEqualPoints(), ilObjSurveyAccess::_hasEvaluationAccess(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilObjSurveyAccess::_isSurveyParticipant(), assQuestion::_isUsedInRandomTest(), assQuestion::_isWorkedThrough(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), assQuestion::_isWriteable(), ilObjSurveyAccess::_lookupAnonymize(), ilObjTest::_lookupAuthor(), ilObjSurveyAccess::_lookupCreationComplete(), ilObjTestAccess::_lookupCreationComplete(), ilObjSurveyAccess::_lookupEvaluationAccess(), ilObjSurveyAccess::_lookupFinished(), ilForum::_lookupForumData(), ilObjSurveyQuestionPool::_lookupOnline(), ilObjSurveyAccess::_lookupOnline(), ilObjQuestionPool::_lookupOnline(), ilObjTestAccess::_lookupOnlineTestAccess(), Spreadsheet_Excel_Writer_Parser::_parenthesizedExpression(), SurveyQuestion::_questionExists(), assQuestion::_questionExists(), SurveyQuestion::_resolveIntLinks(), assQuestion::_resolveIntLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), assTextQuestion::_setReachedPoints(), Spreadsheet_Excel_Writer_Parser::_term(), ilObjQuestionPool::_updateQuestionCount(), LastschriftWS::abbuchenOhneEinzugsermaechtigung(), SurveyQuestionGUI::addCategory(), ilObjSurvey::addConstraint(), Database::addDate(), Database::addKeyword(), assMatchingQuestionGUI::addPair(), SurveyOrdinalQuestion::addPhrase(), ilObjTest::addSelectedUser(), Database::addStartEnd(), assJavaAppletGUI::addSuggestedSolution(), ilObjDlBookGUI::addTranslation(), KundenstammdatenPflegeWS::anlegenKunde(), Database::applyChangedDate(), ilObjUserFolder::buildExportFile(), ilLMStatistics::calcStats(), assTextSubset::calculateReachedPoints(), assTextQuestion::calculateReachedPoints(), assSingleChoice::calculateReachedPoints(), assQuestionTypeTemplate::calculateReachedPoints(), assOrderingQuestion::calculateReachedPoints(), assNumeric::calculateReachedPoints(), assMultipleChoice::calculateReachedPoints(), assMatchingQuestion::calculateReachedPoints(), assJavaApplet::calculateReachedPoints(), assImagemapQuestion::calculateReachedPoints(), assClozeTest::calculateReachedPoints(), ilObjTest::canShowSolutionPrintview(), ilObjTest::canShowTestResults(), ilObjSurvey::canStartSurvey(), ilObjTest::canViewResults(), ilRbacSystem::checkAccess(), ilObjTest::checkMaximumAllowedUsers(), assOrderingQuestion::checkSaveData(), assMatchingQuestion::checkSaveData(), Database::cleanDatabase(), ilObjTest::clearEvalSelectedUsers(), ilObjTest::cloneRandomQuestions(), ilQTIItem::collectResponses(), ilUserTracking::countNum(), ilTracking::countNum(), ilUserTracking::countResults(), ilTracking::countResults(), ilObjUserTracking::countResults(), ilObjSysUserTracking::countResults(), assClozeTest::createCloseTextArray(), ilObjSurvey::createQuestionblock(), ilObjSurvey::createReference(), ilObjTest::createReference(), ilObjQuestionPool::createReference(), ilObjSurvey::createSurveyCodes(), Database::delDate(), SurveyQuestion::delete(), assQuestion::delete(), ilObjTest::deleteActiveTests(), SurveyQuestion::deleteAdditionalTableData(), assQuestion::deleteAdditionalTableData(), ilObjSurveyQuestionPool::deleteAllData(), ilObjSurvey::deleteAllUserData(), assQuestion::deleteAnswers(), ilObjSurvey::deleteConstraints(), ilExerciseMembers::deleteDeliveredFiles(), ilObjSurveyQuestionPool::deletePhrases(), ilForum::deletePostTree(), ilObjTest::deleteResults(), assQuestion::deleteSuggestedSolutions(), ilObjSurvey::deleteSurveyRecord(), ilObjTest::deleteTest(), ilObjSurvey::deleteWorkingData(), ilFileDataExercise::deliverFile(), ilExerciseMembers::deliverReturnedFiles(), Database::discardChangedDate(), ilObjSurvey::disinviteUser(), ilObjTest::disinviteUser(), ilSetupGUI::displayLanguages(), ilExerciseMembers::downloadSelectedFiles(), ilObjTest::duplicate(), ilObjTest::evalLoadStatisticalSettings(), ilObjTest::evalSaveStatisticalSettings(), ilObjTest::evalStatistical(), ilObjTest::evalTotalFinished(), ilObjTest::evalTotalParticipantsArray(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalPersons(), ilObjTest::evalTotalPersonsArray(), ilObjTest::evalTotalStartedAverageTime(), ilObjDlBook::export(), ilNestedSetXML::export(), ilLMPresentationGUI::exportbibinfo(), ilObjDlBook::exportRekursiv(), ilGlossaryExport::exportRekursiv(), ilContObjectExport::exportRekursiv(), ilObjSurvey::finishSurvey(), SurveyTextQuestion::from_xml(), SurveyOrdinalQuestion::from_xml(), SurveyNominalQuestion::from_xml(), SurveyMetricQuestion::from_xml(), ilObjSurvey::from_xml(), ilForum::generatePost(), ilForum::generateThread(), ilBMFWSDL_Cache::get(), ilFeedbackGUI::get_last(), ilObjTest::get_qpl_titles(), ilObjTest::getActiveIdOfUser(), ilObjTest::getActiveTestUser(), ilObjTest::getActiveTestUserFromActiveId(), assQuestion::getActiveUserData(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilObjSurvey::getAnonymousId(), SurveyOrdinalQuestion::getAvailablePhrases(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), SurveyOrdinalQuestion::getCategoriesForPhrase(), Database::getChangedDates(), ilObjTest::getCompleteEvaluationData(), ilObjTest::getCompleteWorkingTime(), ilObjSurvey::getConstraints(), SurveyTextQuestion::getCumulatedResults(), SurveyOrdinalQuestion::getCumulatedResults(), SurveyNominalQuestion::getCumulatedResults(), SurveyMetricQuestion::getCumulatedResults(), ilObjSurvey::getCumulatedResults(), Database::getDate(), getDateList(), Database::getDates(), ilElement::getDbData(), ilElement::getDbDataByQuery(), ilElement::getDbValueByQuery(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilObjTest::getEstimatedWorkingTime(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationParticipants(), ilObjTest::getEvaluationUsers(), ilObjSurvey::getExistingQuestions(), ilObjTest::getExistingQuestions(), ilObjUserFolder::getExportSettings(), ilObjTest::getFirstSequence(), ilObjSurvey::getForbiddenQuestionpools(), Database::getFullDayDates(), Database::getFullDayRotationDates(), assClozeTest::getGapTextList(), Database::getGroupDates(), getGroupDatesForDisplay(), Database::getGroupRotationDates(), assQuestion::getInstances(), ilObjSurvey::getInvitedGroups(), ilObjSurvey::getInvitedUsers(), Database::getKeywords(), ilObjSurvey::getLastActivePage(), ilForum::getLastPost(), ilObjUser::getLastVisitedLessons(), ilObjUser::getLessons(), ilSetup::getline(), ilObjAssessmentFolder::getLog(), ilForum::getModeratorFromPost(), Database::getNegRotationDates(), ilObjAssessmentFolder::getNrOfLogEntries(), ilObjTest::getNrOfResultsForPass(), ilObjSurvey::getObligatoryStates(), ilForumExport::getOnePost(), ilForum::getOnePost(), ilForumExport::getOneThread(), ilForum::getOneThread(), ilForumExport::getOneTopic(), ilForum::getOneTopic(), ilObjUserTracking::getOwnerName(), ilObjSysUserTracking::getOwnerName(), ilObjTest::getPassFinishDate(), ilUserTracking::getPerTestId(), ilTracking::getPerTestId(), SurveyQuestion::getPhrase(), ilObjQuestionPool::getQplQuestions(), ilObjSurvey::getQuestionblock(), ilObjSurvey::getQuestionblockQuestionIds(), ilObjSurvey::getQuestionblockQuestions(), ilObjSurvey::getQuestionblocks(), ilObjSurvey::getQuestionblockTitles(), ilObjTest::getQuestionDataset(), ilObjQuestionPool::getQuestionDetails(), ilObjQuestionPool::getQuestionList(), ilObjSurvey::getQuestionpoolTitles(), ilObjSurveyQuestionPool::getQuestions(), ilObjSurvey::getQuestions(), ilObjSurveyQuestionPool::getQuestionsInfo(), ilObjTest::getQuestionsTable(), ilObjTest::getQuestiontext(), ilObjTest::getQuestionTitles(), ilObjSurveyQuestionPool::getQuestiontype(), ilObjSurvey::getQuestionType(), ilObjTest::getQuestionType(), ilObjQuestionPool::getQuestiontype(), assQuestion::getQuestionTypeFromDb(), ilObjSurvey::getQuestiontypes(), ilObjQuestionPool::getQuestionTypes(), ilObjTest::getRandomQuestionDuplicate(), ilObjTest::getRandomQuestionpools(), assJavaApplet::getReachedInformation(), assQuestion::getReachedPoints(), Database::getRotationDates(), assQuestion::getSolutionCommentCountSystem(), assQuestion::getSolutionCommentMCScoring(), assQuestion::getSolutionCommentScoreCutting(), assQuestion::getSolutionValues(), Database::getStartEnd(), ilObjTest::getStartingTimeOfUser(), ilUserTracking::getSubId(), ilTracking::getSubId(), ilUserTracking::getSubTest(), ilTracking::getSubTest(), ilObjSurvey::getSurveyCodesCount(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyParticipants(), ilObjSurvey::getSurveyQuestions(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilUserTracking::getTest(), ilTracking::getTest(), ilUserTracking::getTestId(), ilTracking::getTestId(), ilObjUserTracking::getTestId(), ilObjSysUserTracking::getTestId(), ilObjTest::getTextAnswer(), assClozeTest::getTextgapPoints(), ilPaymentShoppingCart::getTotalAmountValue(), ilObjQuestionPool::getUsedQuestionDetails(), ilObjSurvey::getUserAccessCode(), ilObjSurvey::getUserSurveyCode(), ilObjSurvey::getVariables(), getWholeDayDateList(), ilObjTest::getWorkedQuestions(), ilNestedSetXML::getXpathNodes(), ilExerciseMembers::hasReturned(), ilExcelWriterAdapter::ilExcelWriterAdapter(), ilObjSurvey::importObject(), ilObjTestGUI::importVerifiedFileObject(), ilObjQuestionPoolGUI::importVerifiedFileObject(), ilNestedSetXML::init(), SurveyQuestionGUI::insertAfterCategory(), SurveyQuestionGUI::insertBeforeCategory(), ilElement::insertDb(), assQuestion::insertIntoTest(), ilObjSurvey::insertQuestion(), ilObjTest::insertQuestion(), ilObjSurvey::insertQuestionblock(), ilObjSurvey::inviteUser(), ilObjTest::inviteUser(), ilObjTest::isAccessCodeUsed(), ilObjTest::isActiveTestSubmitted(), ilObjSurvey::isAnonymizedParticipant(), ilObjSurvey::isAnonymousKey(), assQuestion::isClone(), ilObjTest::isExecutable(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), assQuestion::isInUse(), assTextQuestion::isKeywordMatching(), ilObjSurvey::isSurveyCodeUsed(), ilObjSurvey::isSurveyStarted(), ilLMPresentationGUI::layout(), ilRepositorySearchGUI::listUsersGroup(), ilRepositorySearchGUI::listUsersRole(), SurveyTextQuestion::loadFromDb(), SurveyQuestion::loadFromDb(), SurveyOrdinalQuestion::loadFromDb(), SurveyNominalQuestion::loadFromDb(), SurveyMetricQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjSurvey::loadFromDb(), ilObjTest::loadFromDb(), ilObjQuestionPool::loadFromDb(), assTextSubset::loadFromDb(), assTextQuestion::loadFromDb(), assSingleChoice::loadFromDb(), assQuestionTypeTemplate::loadFromDb(), assQuestion::loadFromDb(), assOrderingQuestion::loadFromDb(), assNumeric::loadFromDb(), assMultipleChoice::loadFromDb(), assMatchingQuestion::loadFromDb(), ASS_MarkSchema::loadFromDb(), assJavaApplet::loadFromDb(), assImagemapQuestion::loadFromDb(), assClozeTest::loadFromDb(), SurveyQuestion::loadMaterialFromDb(), ilObjTest::loadQuestions(), ilObjSurvey::loadQuestionsFromDb(), ilObjSurvey::loadWorkingData(), ilObjSurvey::modifyQuestionblock(), ilObjExerciseGUI::newMembersObject(), ilLMPresentationGUI::offlineexport(), ilObjQuestionPool::pasteFromClipboard(), ilLuceneHTLMSearch::performSearch(), ilLuceneFileSearch::performSearch(), ilPaymentTrusteeGUI::performSearch(), ilPaymentStatisticGUI::performSearch(), ilSearchGUI::performSearch(), ilObjPaymentSettingsGUI::performSearchSPObject(), SurveyQuestion::phraseExists(), SurveyQuestion::prepareTextareaOutput(), ilObjSurvey::prepareTextareaOutput(), ilObjTest::prepareTextareaOutput(), assQuestion::prepareTextareaOutput(), SurveyQuestion::QTIMaterialToString(), ilObjTest::QTIMaterialToString(), assQuestion::QTIMaterialToString(), ilElement::queryDb(), ilObjTest::questionMoveDown(), ilObjTest::questionMoveUp(), SurveyQuestion::questionTitleExists(), assQuestion::questionTitleExists(), ilObjTest::randomSelectQuestions(), ilTestOutputGUI::readFullSequence(), ilObjTest::removeAllTestEditings(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilObjTest::removeNonRandomTestData(), ilObjSurvey::removeQuestions(), ilObjTest::removeRandomTestData(), ilObjSurvey::removeSelectedSurveyResults(), ilObjTest::removeSelectedTestResults(), ilObjTest::removeSelectedUser(), ilObjTest::removeTestResultsForUser(), ilTemplate::replaceFromDatabase(), ilObjTest::retrieveTestTypes(), SurveyQuestionGUI::save(), assQuestionGUI::save(), SurveyQuestion::saveCategoriesToDb(), SurveyQuestion::saveCategoryToDb(), ilObjTest::saveCompleteStatus(), SurveyQuestion::saveCompletionStatus(), ilObjSurvey::saveCompletionStatus(), ilObjTest::saveECTSStatus(), assQuestionGUI::saveEdit(), SurveyQuestion::saveMaterialsToDb(), SurveyOrdinalQuestion::savePhrase(), ilObjSurveyGUI::savePropertiesObject(), ilObjSurvey::saveQuestionsToDb(), ilObjTest::saveQuestionsToDb(), ilObjTest::saveRandomQuestion(), ilObjTest::saveRandomQuestionCount(), ilObjTest::saveRandomQuestionpools(), SurveyTextQuestion::saveToDb(), SurveyQuestion::saveToDb(), SurveyOrdinalQuestion::saveToDb(), SurveyNominalQuestion::saveToDb(), SurveyMetricQuestion::saveToDb(), ilObjSurveyQuestionPool::saveToDb(), ilObjSurvey::saveToDb(), ilObjTest::saveToDb(), ilObjQuestionPool::saveToDb(), assTextSubset::saveToDb(), assTextQuestion::saveToDb(), assSingleChoice::saveToDb(), assQuestionTypeTemplate::saveToDb(), assQuestion::saveToDb(), assOrderingQuestion::saveToDb(), assNumeric::saveToDb(), assMultipleChoice::saveToDb(), assMatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), assJavaApplet::saveToDb(), assImagemapQuestion::saveToDb(), assClozeTest::saveToDb(), ilObjSurvey::saveUserAccessCode(), SurveyTextQuestion::saveUserInput(), SurveyOrdinalQuestion::saveUserInput(), SurveyNominalQuestion::saveUserInput(), SurveyMetricQuestion::saveUserInput(), ilObjSurvey::saveWorkingData(), assTextSubset::saveWorkingData(), assTextQuestion::saveWorkingData(), assSingleChoice::saveWorkingData(), assQuestionTypeTemplate::saveWorkingData(), assQuestion::saveWorkingData(), assOrderingQuestion::saveWorkingData(), assNumeric::saveWorkingData(), assMultipleChoice::saveWorkingData(), assMatchingQuestion::saveWorkingData(), assImagemapQuestion::saveWorkingData(), assClozeTest::saveWorkingData(), SurveySearch::search(), ilLMStatisticsGUI::search(), searchForm(), ilObjPaymentSettingsGUI::searchObject(), ilObjiLincCourseGUI::searchObject(), ilObjCourseGUI::searchObject(), ilObjRoleGUI::searchObject(), ilObjGroupGUI::searchObject(), ilUserTracking::searchResults(), ilTracking::searchResults(), searchTest(), ilUserTracking::searchTestId(), ilTracking::searchTestId(), ilUserTracking::searchTestResults(), ilTracking::searchTestResults(), ilUserTracking::searchUserId(), ilTracking::searchUserId(), ilUserTracking::selectTime(), ilTracking::selectTime(), ilObjUserTrackingGUI::selectTime(), ilBMFTransport_SMTP::send(), ilPurchaseBMFGUI::sendCreditCard(), ilPurchaseBMFGUI::sendDebitEntry(), assClozeTestGUI::setGapValues(), assSingleChoice::setImageFile(), assOrderingQuestion::setImageFile(), assMultipleChoice::setImageFile(), assMatchingQuestion::setImageFile(), ilObjSurvey::setInvitation(), ilObjSurvey::setInvitationAndMode(), ilObjSurvey::setInvitationMode(), ilObjSurvey::setObligatoryStates(), assTextQuestion::setReachedPoints(), ilObjSurvey::setStatus(), ilNestedSetXML::setTagName(), ilNestedSetXML::setTagValue(), ilLMStatisticsGUI::show(), ilTestEvaluationData::sortParticipants(), ilObjSurvey::startSurvey(), ilObjTest::startWorkingTime(), SurveyTextQuestion::syncWithOriginal(), SurveyQuestion::syncWithOriginal(), SurveyOrdinalQuestion::syncWithOriginal(), SurveyNominalQuestion::syncWithOriginal(), SurveyMetricQuestion::syncWithOriginal(), assTextSubset::syncWithOriginal(), assTextQuestion::syncWithOriginal(), assSingleChoice::syncWithOriginal(), assQuestionTypeTemplate::syncWithOriginal(), assQuestion::syncWithOriginal(), assOrderingQuestion::syncWithOriginal(), assNumeric::syncWithOriginal(), assMultipleChoice::syncWithOriginal(), assMatchingQuestion::syncWithOriginal(), assJavaApplet::syncWithOriginal(), assImagemapQuestion::syncWithOriginal(), assClozeTest::syncWithOriginal(), ilSetup::testLatex(), ilUserTracking::TestTitle(), ilTracking::TestTitle(), ilObjTest::testTitleExists(), ilObjSurvey::unfoldQuestionblocks(), ilObjiLincClassroom::update(), Database::updateDate(), ilElement::updateDb(), Database::updateKeyword2Date(), ilObjTest::updateWorkingTime(), assJavaAppletGUI::uploadingJavaApplet(), ilObjQuestionPoolGUI::uploadQplObject(), ilObjTestGUI::uploadTstObject(), ilPersonalProfileGUI::userSettingEnabled(), ilPersonalProfileGUI::userSettingVisible(), ilValidatorAdapter::validate(), ilStatistics::validate(), KreditkartenzahlungWS::validierenKreditkarte(), ilPersonalProfileGUI::workWithUserSetting(), ilIniFile::write(), SurveyTextQuestionGUI::writePostData(), SurveyOrdinalQuestionGUI::writePostData(), SurveyNominalQuestionGUI::writePostData(), SurveyMetricQuestionGUI::writePostData(), assTextSubsetGUI::writePostData(), assTextQuestionGUI::writePostData(), assSingleChoiceGUI::writePostData(), assOrderingQuestionGUI::writePostData(), assNumericGUI::writePostData(), assMultipleChoiceGUI::writePostData(), assMatchingQuestionGUI::writePostData(), assJavaAppletGUI::writePostData(), assImagemapQuestionGUI::writePostData(), assClozeTestGUI::writePostData(), xslt_process(), and KreditkartenzahlungWS::zahlenUndAnlegenKunde().
| $rgt = $left + 2 |
Definition at line 404 of file dbupdate.php.
Referenced by ilTree::checkTree(), ilTree::insertNode(), ilForum::insertPostNode(), ilObjRoleGUI::permSaveObject(), and ilTree::saveSubTree().
| $rol_fold = $res->fetchRow(DB_FETCHMODE_ASSOC) |
Definition at line 608 of file dbupdate.php.
| $role_id = $ilDB->getLastInsertId() |
Definition at line 8707 of file dbupdate.php.
Referenced by ilRegistrationSettingsGUI::__buildRoleSelection(), ilRepositorySearchGUI::__fillRoleTable(), ilPermissionGUI::__filterRoles(), ilObjectGUI::__filterRoles(), ilObjCourse::__getDefaultCourseRoles(), ilRbacReview::__setProtectedStatus(), ilObjGroup::_getMembers(), ilForum::_getModerators(), ilObjRole::_updateAuthMode(), ilTestEvaluationGUI::addFoundRolesToEval(), ilObjTestGUI::addParticipantsObject(), ilObjTest::addSelectedRole(), addUserRoleEntry(), ilSoapRBACAdministration::addUserRoleEntry(), ilObjRoleFolder::delete(), deleteRole(), ilSoapRBACAdministration::deleteRole(), deleteUserRoleEntry(), ilSoapRBACAdministration::deleteUserRoleEntry(), ilUserImportParser::detachFromRole(), ilObjUserGUI::editObject(), ilObjCourse::getDefaultAdminRole(), ilObjGroup::getDefaultGroupRoles(), ilObjCourse::getDefaultMemberRole(), ilObjiLincCourse::getDefaultRoles(), ilObjCourse::getDefaultTutorRole(), ilRbacReview::getGlobalAssignableRoles(), ilRbacReview::getGlobalRolesArray(), ilObjGroup::getLocalGroupRoles(), ilSoapRBACAdministration::getLocalRoles(), ilObjiLincCourse::getLocalRoles(), ilSoapUserAdministration::getUserForRole(), ilMail::getUserIds(), ilSoapRBACAdministration::getUserRoles(), ilSoapUserAdministration::getUsersForContainer(), getUsersForRole(), grantPermissions(), ilSoapRBACAdministration::grantPermissions(), ilUserImportParser::importEndTag(), ilObjUserFolderGUI::importUserRoleAssignmentObject(), ilSoapUserAdministration::importUsers(), ilObjUserFolderGUI::importUsersObject(), ilObjSurvey::inviteRole(), ilObjTest::inviteRole(), ilObjSurveyGUI::inviteUserGroupObject(), ilLMStatisticsGUI::listUsersRole(), ilRepositorySearchGUI::listUsersRole(), ilObjiLincCourseGUI::listUsersRoleObject(), ilObjCourseGUI::listUsersRoleObject(), ilObjRoleGUI::listUsersRoleObject(), ilObjGroupGUI::listUsersRoleObject(), ilObjSurveyGUI::outUserGroupTable(), ilPermissionGUI::permSave(), revokePermissions(), ilSoapRBACAdministration::revokePermissions(), and ilPersonalProfileGUI::showProfile().
| $rolf_id = $ilDB->getLastInsertId() |
Definition at line 8687 of file dbupdate.php.
Referenced by ilRbacReview::__setProtectedStatus(), ilSoapRBACAdministration::addRole(), ilPermissionGUI::addRole(), ilSoapRBACAdministration::addRoleFromTemplate(), ilSoapRBACAdministration::deleteRole(), ilRbacReview::getObjectsWithStopedInheritance(), ilPermissionGUI::permSave(), and ilSoapObjectAdministration::updateObjects().
| $rolf_ref_id = $ilDB->getLastInsertId() |
Definition at line 8694 of file dbupdate.php.
| $row = $res->fetchRow() |
Definition at line 362 of file dbupdate.php.
Referenced by ilXMLResultSetWriter::__buildRows(), ilCronClients::__checkDBVersion(), ilTree::__checkDelete(), ilCron::__checkUserAccounts(), ilCourseObjective::__cleanStructure(), ilCourseItems::__delete(), ilChatRoom::__deleteFirstLine(), ilLinkChecker::__fetchUserData(), ilRbacReview::__getAllRoleFolderIds(), ilChatRoom::__getCountLines(), ilObjForum::__getCountNew(), ilLPStatusManual::__getCourseInProgress(), ilObjCourse::__getCrsNonMemberTemplateId(), ilLPStatusManual::__getGroupInProgress(), ilSoapUserAdministration::__getGroupMemberData(), ilCourseItems::__getItemData(), ilCourseObjective::__getLastPosition(), ilCourseItems::__getLastPosition(), ilObjForum::__getLastThreadAccess(), ilLPStatusManual::__getLMInProgress(), ilLinkChecker::__getObjIdByPageId(), ilRbacReview::__getParentRoles(), ilObjRole::__getPermissionDefinitions(), ilTree::__getSubTreeByParentRelation(), ilLinkChecker::__getTitle(), ilSoapUserAdministration::__getUserFolderUsers(), ilSoapUserObjectXMLWriter::__handleUser(), ilLuceneIndexer::__indexFiles(), ilLuceneIndexer::__indexHTLMs(), ilUserResult::__init(), ilSearchResult::__init(), ilSearchFolder::__init(), ilAbstractSearch::__prepareFound(), ilCourseMembers::__purgeDeleted(), ilCourseItems::__purgeDeleted(), ilLPObjSettings::__read(), ilLPMarks::__read(), ilLPFilter::__read(), ilLPEventCollections::__read(), ilLPCollections::__read(), ilRegistrationRoleAssignments::__read(), ilPaymentVendors::__read(), ilPaymentTrustees::__read(), ilPaymentShoppingCart::__read(), ilPaymentPrices::__read(), ilPaymentObject::__read(), ilPaymentBookings::__read(), ilPaymentBillVendor::__read(), ilTimingPlaned::__read(), ilTimingAccepted::__read(), ilEventParticipants::__read(), ilEventItems::__read(), ilEventFile::__read(), ilEventAppointment::__read(), ilEvent::__read(), ilCourseWaitingList::__read(), ilCourseStart::__read(), ilCourseObjectiveQuestion::__read(), ilCourseObjectiveLM::__read(), ilCourseObjective::__read(), ilCourseMembers::__read(), ilCourseFile::__read(), ilCourseArchives::__read(), ilUserDefinedFields::__read(), ilUserDefinedData::__read(), ilObjForum::__read(), ilChatRoom::__read(), ilChatBlockedUsers::__read(), ilObjUser::__readAppliedUsers(), ilSearch::__readDBResult(), ilCronClients::__readFileDBVersion(), ilSearchFolder::__readRootId(), ilCron::__readSetting(), ilObjCourse::__readSettings(), ilCourseMembers::__readSubscriberData(), ilCourseMembers::__readSubscribers(), ilAdvancedSearch::__searchClassification(), ilMetaDataSearch::__searchContribute(), ilAdvancedSearch::__searchContribute(), ilMetaDataSearch::__searchDescriptions(), ilAdvancedSearch::__searchEducational(), ilAdvancedSearch::__searchEntity(), ilAdvancedSearch::__searchFormat(), ilAdvancedSearch::__searchGeneral(), ilAdvancedSearch::__searchKeyword(), ilMetaDataSearch::__searchKeywords(), ilMDSearch::__searchKeywordsOnly(), ilAdvancedSearch::__searchLanguage(), ilAdvancedSearch::__searchLifecycle(), ilAdvancedSearch::__searchRequirement(), ilAdvancedSearch::__searchRights(), ilTestSearch::__searchSurveyIntroduction(), ilTestSearch::__searchSurveyTitle(), ilAdvancedSearch::__searchTaxon(), ilTestSearch::__searchTestIntroduction(), ilTestSearch::__searchTestTitle(), ilAdvancedSearch::__searchTitleDescription(), ilMetaDataSearch::__searchTitles(), ilAdvancedSearch::__searchTypicalAgeRange(), ilObjLinkResourceGUI::__setLocator(), ilObjRoleGUI::__setLocator(), ilObjChatGUI::__setLocator(), ilSearchResultExplorer::__setRootId(), ilLearningProgressBaseGUI::__sort(), ilObjectDataCache::__storeObjectData(), ilObjectDataCache::__storeReference(), ilLinkChecker::__txt(), ilCourseItems::__updateBottom(), ilCourseObjectiveResult::__updatePassed(), ilCourseItems::__updateTop(), Spreadsheet_Excel_Writer_Parser::_cellToPackedRowcol(), Spreadsheet_Excel_Writer_Worksheet::_cellToRowcol(), Spreadsheet_Excel_Writer_Parser::_cellToRowcol(), Spreadsheet_Excel_Writer_Worksheet::_checkRowCol(), ilObjSurvey::_clone(), Spreadsheet_Excel_Writer_Parser::_convertRef2d(), Spreadsheet_Excel_Writer_Parser::_convertRef3d(), ilHistory::_copyEntriesForObject(), ilMailbox::_countNewMails(), ilPaymentPrices::_countPrices(), ilEvent::_deleteAll(), ilNestedSetXML::_deleteAllChildMetaData(), ilObjTest::_evalResultsOverview(), ilPageObject::_exists(), ilCourseObjectiveResult::_getAccomplished(), ilPaymentObject::_getActivation(), ilPaymentBookings::_getActivation(), ilObjiLincCourse::_getAKClassValues(), ilNestedSetXML::_getAllChildIds(), ilLinkCheckNotify::_getAllNotifiers(), ilObjUser::_getAllUserData(), ilLocalUser::_getAllUserIds(), ilObjUser::_getAllUserLogins(), ilObjTest::_getArrayData(), ilObjRole::_getAssignUsersStatus(), ilObjRole::_getAuthMode(), ilAuthUtils::_getAuthMode(), ilAuthUtils::_getAuthModeOfUser(), ilPaymentCurrency::_getAvailableCurrencies(), ilObjQuestionPool::_getAvailableQuestionpools(), ilObjSurvey::_getAvailableSurveys(), ilObjTest::_getAvailableTests(), ilObjTest::_getBestPass(), ilLPStatusVisits::_getCompleted(), ilLPStatusTypicalLearningTime::_getCompleted(), ilLPStatusTestFinished::_getCompleted(), ilLPStatusManual::_getCompleted(), ilObjSCORMTracking::_getCompleted(), ilObjTest::_getCompleteEvaluationData(), ilObjTest::_getCompleteWorkingTimeOfParticipants(), ilConditionHandler::_getCondition(), ilConditionHandler::_getConditionsOfTarget(), ilConditionHandler::_getConditionsOfTrigger(), ilObjSurvey::_getConstraints(), ilPaymentVendors::_getCostCenter(), ilPaymentBookings::_getCountBookingsByCustomer(), ilPaymentBookings::_getCountBookingsByObject(), ilPaymentBookings::_getCountBookingsByPayMethod(), ilPaymentBookings::_getCountBookingsByVendor(), ilObjSCORMTracking::_getCountCompletedPerUser(), ilPaymentObject::_getCountObjectsByPayMethod(), ilObjTest::_getCountSystem(), ilObjForum::_getCountUnread(), ilPaymentCurrency::_getCurrency(), ilObjiLincClassroom::_getDocent(), ilEvent::_getEvents(), ilObjSCORMTracking::_getFailed(), ilExerciseMembers::_getFailedUsers(), ilLinkResourceItems::_getFirstLink(), ilLocalUser::_getFolderIds(), ilMDUtilSelect::_getFormatSelect(), ilObjCourseGrouping::_getGroupings(), ilObjSystemFolder::_getHeaderTitle(), ilObjSystemFolder::_getHeaderTitleDescription(), ilObjTest::_getHidePreviousResults(), ilObjTest::_getHideTitlePoints(), ilMDTechnical::_getId(), ilMDRights::_getId(), ilMDMetaMetadata::_getId(), ilMDLifecycle::_getId(), ilMDGeneral::_getId(), ilMDEducational::_getId(), ilObjSystemFolder::_getId(), ilMDTypicalAgeRange::_getIds(), ilMDTaxonPath::_getIds(), ilMDTaxon::_getIds(), ilMDRequirement::_getIds(), ilMDRelation::_getIds(), ilMDOrComposite::_getIds(), ilMDLocation::_getIds(), ilMDLanguage::_getIds(), ilMDKeyword::_getIds(), ilMDIdentifier_::_getIds(), ilMDIdentifier::_getIds(), ilMDFormat::_getIds(), ilMDEntity::_getIds(), ilMDDescription::_getIds(), ilMDContribute::_getIds(), ilMDClassification::_getIds(), ilMDAnnotation::_getIds(), ilObjUser::_getImportedUserId(), ilLPStatusVisits::_getInProgress(), ilLPStatusTypicalLearningTime::_getInProgress(), ilLPStatusTestPassed::_getInProgress(), ilLPStatusTestFinished::_getInProgress(), ilLPStatusObjectives::_getInProgress(), ilObjSCORMTracking::_getInProgress(), ilCourseItems::_getItem(), ilLPEventCollections::_getItems(), ilLPCollections::_getItems(), ilSCORMItem::_getItems(), ilEventItems::_getItemsOfContainer(), ilObjSurvey::_getLastAccess(), ilObjTest::_getLastAccess(), ilObjAssessmentFolder::_getLog(), SurveyTextQuestion::_getMaxChars(), assQuestion::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilCourseMembers::_getMembers(), ilExerciseMembers::_getMembers(), ilLinkCheckNotify::_getNotifiers(), ilObjTest::_getObjectIDFromActiveID(), ilObjTest::_getObjectIDFromTestID(), ilCourseObjective::_getObjectiveIds(), ilUtil::_getObjectsByOperations(), ilPaymentObject::_getObjectsData(), ilOnlineTracking::_getOnlineTime(), ilRbacReview::_getOperationIdsByName(), SurveyQuestion::_getOriginalId(), assQuestion::_getOriginalId(), ilParameterAppender::_getParams(), ilEventParticipants::_getParticipated(), ilObjTest::_getPass(), ilExerciseMembers::_getPassedUsers(), ilObjTest::_getPassScoring(), ilTimingPlaned::_getPlanedTimings(), ilTimingPlaned::_getPlanedTimingsByItem(), ilPaymentPrices::_getPrice(), ilLearningProgress::_getProgress(), ilObjSCORMTracking::_getProgressInfo(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjTest::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), ilObjSurvey::_getQuestiontypes(), ilObjTest::_getQuestiontypes(), assQuestion::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilEventParticipants::_getRegistered(), ilExerciseMembers::_getReturned(), ilObjTest::_getScoreCutting(), ilSearchSettings::_getSearchSettingRefId(), ilRADIUSAuthentication::_getServers(), assQuestion::_getSolutionMaxPass(), ilLPStatusObjectives::_getStatusInfo(), ilPaymentCurrency::_getSubUnit(), ilCourseObjectiveResult::_getSuggested(), assQuestion::_getSuggestedSolution(), ilCourseObjectiveQuestion::_getTest(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestQuestions(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestType(), assQuestion::_getTitle(), assQuestion::_getTotalAnswers(), assQuestion::_getTotalRightAnswers(), ilObjAICCLearningModule::_getTrackingItems(), ilMDEducational::_getTypicalLearningTimeSeconds(), ilPaymentCurrency::_getUnit(), ilObjTest::_getUserIdFromActiveId(), ilObjUser::_getUserIdsByEmail(), ilPaymentTrustees::_getVendorsForObjects(), ilObjCourseGrouping::_getVisibleGroupings(), ilObjTest::_getVisitTimeOfParticipant(), ilPaymentObject::_hasAccess(), ilPaymentBookings::_hasAccess(), ilLPMarks::_hasCompleted(), ilTracking::_hasEntry(), ilObjQuestionPool::_hasEqualPoints(), ilObjSurveyAccess::_hasEvaluationAccess(), ilPaymentTrustees::_hasObjectPermission(), ilPaymentTrustees::_hasStatisticPermission(), ilChatServerCommunicator::_initObject(), ilObjiLincCourse::_isActivated(), ilObjCourse::_isActivated(), ilCourseItems::_isActivated(), ilChatRoom::_isActive(), ilCourseObjectiveQuestion::_isAssigned(), ilCourseMembers::_isBlocked(), ilPaymentObject::_isBuyable(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilPaymentObject::_isInCart(), ilLMObject::_isPagePublic(), ilEventParticipants::_isRegistered(), ilCourseMembers::_isSubscriber(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), assQuestion::_isWriteable(), ilObjSurveyAccess::_lookupAnonymize(), ilObjTest::_lookupAuthor(), ilObjUser::_lookupClientIP(), ilLPMarks::_lookupComment(), ilEventParticipants::_lookupComment(), ilEvent::_lookupCourseId(), ilObjSurveyAccess::_lookupCreationComplete(), ilObjTestAccess::_lookupCreationComplete(), ilObjUser::_lookupEmail(), ilObjSurveyAccess::_lookupEvaluationAccess(), ilObjFile::_lookupFileName(), ilObjFileAccess::_lookupFileSize(), ilObjSurveyAccess::_lookupFinished(), ilObjGroup::_lookupIdByTitle(), ilObjUser::_lookupLanguage(), ilLPMarks::_lookupMark(), ilEventParticipants::_lookupMark(), ilLPObjSettings::_lookupMode(), _lookupObjId(), ilObject::_lookupObjIdByImportId(), ilObjSurveyQuestionPool::_lookupOnline(), ilObjSurveyAccess::_lookupOnline(), ilObjQuestionPool::_lookupOnline(), ilObjTestAccess::_lookupOnlineTestAccess(), ilPaymentObject::_lookupPobjectId(), ilForum::_lookupPostMessage(), ilObjUser::_lookupPref(), ilExerciseMembers::_lookupStatus(), ilObjFileAccess::_lookupSuffix(), ilObjTest::_lookupTestIdForQuestion(), ilObjTest::_lookupTestType(), ilObjForum::_lookupThreadSubject(), ilSCORMItem::_lookupTitle(), ilObjFileAccess::_lookupVersion(), ilObjCourse::_lookupViewMode(), ilLPObjSettings::_lookupVisits(), ilEventAppointment::_readAppointmentsByEvent(), ilCourseObjectiveResult::_readAssignedObjectives(), ilCourseObjectiveResult::_readAssignedObjectivesOfQuestion(), ilCourseFile::_readFilesByCourse(), ilEventFile::_readFilesByEvent(), ilObjCourse::_registrationEnabled(), SurveyQuestion::_resolveIntLinks(), assQuestion::_resolveIntLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), ilObjUser::_search(), ilObjRole::_search(), ilObjGroup::_search(), Spreadsheet_Excel_Writer_Worksheet::_sizeRow(), ilUtil::_sortIds(), ilOnlineTracking::_updateAccess(), ilCourseObjectiveResult::_updateObjectiveStatus(), ilLMObject::_writePublicAccessStatus(), ilPaymentObject::add(), ilLocatorGUI::addAdministrationItems(), ilXMLResultSet::addArray(), ilObjSurveyGUI::addConstraintForm(), ilObjContentObjectGUI::addLocations(), ilSoapObjectAdministration::addObject(), SurveyOrdinalQuestion::addPhrase(), ilSoapObjectAdministration::addReference(), ilLocatorGUI::addRepositoryItems(), ilXMLResultSet::addRow(), ilDBUpdate::applyUpdateNr(), ilRbacReview::assignedRoles(), ilRbacReview::assignedUsers(), ilObjUserFolder::buildExportFile(), ilQuestionpoolExport::buildExportFileXLS(), ilTestExport::buildExportResultFile(), ilObjTest::buildName(), ilLMStatistics::calcStats(), assTextQuestion::calculateReachedPoints(), ilCronCheckUserAccounts::check(), ilRbacSystem::checkAccessOfUser(), ilLinkChecker::checkLinks(), ilRbacSystem::checkPermission(), ilObjAICCCourseInterchangeFiles::checkStructure(), ilTree::checkTree(), ilTree::checkTreeChilds(), Database::cleanDatabase(), ilObjTest::cloneRandomQuestions(), ilRbacAdmin::copyRolePermission(), ilRbacAdmin::copyRolePermissionIntersection(), ilObject::countReferences(), ilObjCourseGrouping::create(), ilMetaTechnical::create(), ilObjUserFolder::createCSVExport(), ilObjUserFolder::createExcelExport(), ilObjUserFolder::createXMLExport(), ilFileDataMail::deassignAttachmentFromDirectory(), SurveyQuestion::delete(), ilCourseObjectiveQuestion::delete(), assQuestion::delete(), ilObjSurveyQuestionPool::deleteAllData(), ilNestedSetXML::deleteAllDbData(), ilObjSurvey::deleteConstraints(), ilExerciseMembers::deleteDeliveredFiles(), ilForum::deletePostTree(), ilObjSurvey::deleteSurveyRecord(), ilObjTest::deleteTest(), ilTree::deleteTree(), ilExerciseMembers::deliverReturnedFiles(), ilGlossaryLocatorGUI::display(), ilContObjLocatorGUI::display(), ilForumLocatorGUI::display(), ilSetupGUI::displayDatabase(), ilLMEditorGUI::displayLocator(), ilBookmarkAdministrationGUI::displayLocator(), ilExerciseMembers::downloadSelectedFiles(), PHPlot::DrawArea(), PHPlot::DrawBars(), PHPlot::DrawDots(), PHPlot::DrawDotsError(), PHPlot::DrawLines(), PHPlot::DrawLinesError(), PHPlot::DrawSquared(), PHPlot::DrawStackedBars(), PHPlot::DrawThinBarLines(), PHPlot::DrawXDataLabel(), PHPlot::DrawXDataLine(), ilValidator::dumpTree(), ilObjTest::evalLoadStatisticalSettings(), ilObjTest::evalSaveStatisticalSettings(), ilTestEvaluationGUI::evalSelectedUsers(), ilObjTest::evalStatistical(), ilObjTest::evalTotalFinished(), ilObjTest::evalTotalParticipantsArray(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalPersons(), ilObjTest::evalTotalPersonsArray(), ilObjTest::evalTotalStartedAverageTime(), ilSurveyEvaluationGUI::evaluation(), ilSurveyEvaluationGUI::evaluationuser(), ilObjDlBook::export(), ilNestedSetXML::export(), ilSurveyEvaluationGUI::exportCumulatedResults(), ilObjGroupGUI::exportMembersObject(), ilObjDlBook::exportRekursiv(), ilGlossaryExport::exportRekursiv(), ilContObjectExport::exportRekursiv(), ilTree::fetchNodeData(), ilTree::fetchPredecessorNode(), ilTree::fetchSuccessorNode(), ilValidator::findDeletedObjects(), ilValidator::findInvalidChilds(), ilValidator::findInvalidRBACEntries(), ilValidator::findInvalidReferences(), ilValidator::findInvalidRolefolders(), ilValidator::findMissingObjects(), ilValidator::findUnboundObjects(), ilMailbox::folderNameExists(), ilObjTest::get_qpl_titles(), ilObjTest::getActiveIdOfUser(), ilObjTest::getActiveTestUserFromActiveId(), assQuestion::getActiveUserData(), ilChatRoom::getActiveUsers(), ilCourseMembers::getAdmins(), ilRoleDesktopItem::getAll(), ilFeedback::getAllBarometer(), ilExerciseMembers::getAllDeliveredFiles(), ilLinkResourceItems::getAllItems(), ilChatRoom::getAllMessages(), ilObjQuestionPool::getAllQuestionIds(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilChatRoom::getAllRoomsOfObject(), ilClient::getAllSettings(), ilObjTest::getAllTestResults(), ilObjSurvey::getAnonymousId(), ilRbacReview::getAssignableRoles(), ilUtil::getAssociatedUsersOnline(), ilFileDataMail::getAttachmentPath(), ilSQL2XML::getAttributes(), ilSQL2XML::getAttributeValue(), ilLanguage::getAvailableLanguages(), SurveyOrdinalQuestion::getAvailablePhrases(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), ilFeedback::getBarometer(), ilFeedback::getBarometerByObjId(), ilFeedback::getBarometerByRefId(), ilPageObject::getBibliographyXML(), ilPaymentBookings::getBooking(), ilPaymentBookings::getBookingsOfCustomer(), SurveyOrdinalQuestion::getCategoriesForPhrase(), Database::getChangedDates(), ilFeedback::getChartData(), ilSCORMTree::getChilds(), ilTree::getChilds(), ilTree::getChildsByType(), ilTree::getChildSequenceNumber(), ilObjTest::getCompleteEvaluationData(), ilObjTest::getCompleteWorkingTime(), ilObjSurvey::getConstraints(), ilObjForum::getCountNew(), SurveyTextQuestion::getCumulatedResults(), SurveyOrdinalQuestion::getCumulatedResults(), SurveyNominalQuestion::getCumulatedResults(), SurveyMetricQuestion::getCumulatedResults(), ilDBUpdate::getCurrentVersion(), Database::getDates(), getDayList(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilTree::getDepth(), ilObjAICCCourseInterchangeFiles::getDescriptor(), ilMailbox::getDraftsFolder(), ilAddressbook::getEntries(), ilAddressbook::getEntry(), ilXML2SQL::getEntryId(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationParticipants(), ilObjTest::getEvaluationUsers(), ilObjGroup::getExpirationDateTime(), ilObjGroup::getExpirationTimestamp(), ilObjUserFolder::getExportSettings(), ilFeedback::getFeedback(), ilDBUpdate::getFileVersion(), ilForum::getFirstPostByThread(), ilForumExport::getFirstPostNode(), ilForum::getFirstPostNode(), ilMailbox::getFolderData(), ilRbacReview::getFoldersAssignedToRole(), ilObjSurvey::getForbiddenQuestionpools(), Database::getFullDayDates(), Database::getFullDayRotationDates(), Database::getGroupDates(), ilUtil::getGroupId(), ilObjGroup::getGroupMemberData(), Database::getGroupRotationDates(), ilObjGroup::getGrpStatusClosedTemplateId(), ilObjGroup::getGrpStatusOpenTemplateId(), ilObjSystemFolder::getHeaderTitleTranslations(), ilMailbox::getInboxFolder(), ilLanguage::getInstalledLanguages(), ilLanguage::getInstalledLocalLanguages(), ilSearchItemFactory::getInstance(), assQuestion::getInstances(), ilLinkChecker::getInvalidLinksFromDB(), ilObjSurvey::getInvitedGroups(), ilObjSurvey::getInvitedUsers(), ilLinkResourceItems::getItem(), ilRoleDesktopItem::getItem(), Database::getKeywords(), ilObjSurvey::getLastActivePage(), ilLinkChecker::getLastCheckTimestamp(), ilMailbox::getLastInsertId(), ilDBx::getLastInsertId(), ilCourseLMHistory::getLastLM(), ilTree::getLeftValue(), ilRbacReview::getLinkedRolesOfRoleFolder(), ilCourseLMHistory::getLMHistory(), ilObjAssessmentFolder::getLog(), ilObjUser::getLoginByUserId(), ilMail::getMailsOfFolder(), ilTree::getMaximumDepth(), ilObjiLincCourse::getMemberData(), ilObjiLincCourse::getMemberRolesTitle(), ilObjGroup::getMemberRolesTitle(), ilCourseMembers::getMembers(), ilLMMenuEditor::getMenuEntries(), Database::getNegRotationDates(), ilObjGroup::getNewRegistrations(), ilTree::getNodeData(), ilTree::getNodeDataByType(), ilFeedback::getNotes(), ilObjAssessmentFolder::getNrOfLogEntries(), getObjectList(), ilObjSurvey::getObligatoryStates(), ilRbacReview::getOperation(), getOperationId(), getOperationList(), ilRbacReview::getOperations(), ilRbacReview::getOperationsOfRole(), ilRbacReview::getOperationsOnType(), ilRbacReview::getOperationsOnTypeString(), ilMailOptions::getOptions(), ilMDOrComposite::getOrCompositeId(), ilMailbox::getParentFolderId(), ilTree::getParentId(), ilTree::getParentNodeData(), ilObjTest::getPassFinishDate(), ilObjGroup::getPassword(), ilTree::getPathIdsUsingAdjacencyMap(), ilTree::getPathIdsUsingNestedSets(), SurveyQuestion::getPhrase(), ilForum::getPostById(), ilForum::getPostChilds(), ilForum::getPostMaximumDepth(), ilForum::getPostNode(), ilForumExport::getPostTree(), ilForum::getPostTree(), ilObjQuestionPool::getPrintviewQuestions(), ilObjQuestionPool::getQplQuestions(), ilObjSurvey::getQuestionblock(), ilObjSurvey::getQuestionblockQuestionIds(), ilObjSurvey::getQuestionblockQuestions(), ilObjSurvey::getQuestionblocks(), ilObjSurvey::getQuestionblocksTable(), ilObjSurvey::getQuestionblockTitles(), ilObjTest::getQuestionDataset(), ilObjQuestionPool::getQuestionDetails(), ilObjQuestionPool::getQuestionList(), ilObjSurvey::getQuestionpoolTitles(), ilObjSurveyQuestionPool::getQuestions(), ilObjSurvey::getQuestions(), ilObjSurveyQuestionPool::getQuestionsInfo(), ilObjSurveyQuestionPool::getQuestionsTable(), ilObjSurvey::getQuestionsTable(), ilObjTest::getQuestionsTable(), ilObjQuestionPool::getQuestionsTable(), ilObjTest::getQuestiontext(), ilObjTest::getQuestionTitles(), ilObjSurvey::getQuestiontypes(), ilObjQuestionPool::getQuestionTypes(), ilObjTest::getRandomQuestionDuplicate(), ilObjTest::getRandomQuestionpools(), assQuestion::getReachedPoints(), ilObjGroup::getRegistrationFlag(), ilFeedback::getResultUsers(), ilRbacReview::getRoleListByObject(), ilRbacReview::getRoleOperationsOnObject(), ilRbacReview::getRolesByFilter(), ilRbacReview::getRolesOfRoleFolder(), ilChatRoom::getRooms(), ilChatRoom::getRoomsOfObject(), Database::getRotationDates(), ilTree::getSavedNodeData(), ilMailbox::getSentFolder(), ilClient::getSetting(), assQuestion::getSolutionValues(), ilObjTest::getStartingTimeOfUser(), ilObjUser::getStoredActive(), ilSQL2XML::getStructure(), ilMailbox::getSubFolders(), ilTree::getSubTree(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyParticipants(), ilObjSurvey::getSurveyQuestions(), ilDBUpdate::getTables(), ilDBUpdate::getTableStatus(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilTabsGUI::getTargetsByObjectType(), ilObjTest::getTestQuestions(), ilObjTest::getTestResult(), ilCourseObjectiveQuestion::getTests(), ilObjTest::getTestSummary(), ilObjTest::getTextAnswer(), ilObjCategory::getTranslations(), ilMailbox::getTrashFolder(), ilCourseMembers::getTutors(), ilRbacReview::getTypeId(), ilObjQuestionPool::getUsedQuestionDetails(), ilObjSurvey::getUserAccessCode(), ilForumExport::getUserData(), ilForum::getUserData(), ilSoapUserAdministration::getUserForRole(), ilObjUser::getUserIdByEmail(), ilObjUser::getUserIdByLogin(), ilObjSurvey::getUserSurveyCode(), ilObjSurvey::getVariables(), ilObjTest::getWorkedQuestions(), ilCourseObjectiveResult::hasAccomplishedObjective(), ilMailbox::hasNewMail(), ilExerciseMembers::ilClone(), ilLanguage::ilLanguage(), ilLMPresentationGUI::ilLocator(), ilMDConvert(), ilSetting::ilSetting(), ilPCTable::importSpreadsheet(), ilNestedSetXML::init(), ilObjLanguage::insert(), Spreadsheet_Excel_Writer_Worksheet::insertBitmap(), ilLanguage::insertLanguage(), ilObjSurvey::insertQuestionblock(), ilRbacReview::isAssignable(), ilRepositoryExplorer::isClickable(), assQuestion::isClone(), ilRbacReview::isDeleted(), ilObjRoleFolder::isDeleted(), ilClient::isInstalledDB(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), assQuestion::isInUse(), ilRbacReview::isProtected(), ilCourseMembers::isSubscriber(), ilObjSurvey::isSurveyStarted(), SurveyQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjQuestionPool::loadFromDb(), assQuestion::loadFromDb(), ilLanguage::loadLanguageModule(), ilObjSurvey::loadWorkingData(), ilObjAssessmentFolderGUI::logsObject(), ilChatRoom::lookupRoomId(), ilObjForum::markAllThreadsRead(), ilObjForum::markThreadRead(), ilLMPresentationGUI::offlineexport(), padFront(), ilObjQuestionPool::pasteFromClipboard(), ilWebresourceSearch::performSearch(), ilUserSearch::performSearch(), ilUserDefinedFieldSearch::performSearch(), ilObjectSearch::performSearch(), ilMediaPoolSearch::performSearch(), ilLMContentSearch::performSearch(), ilGlossaryDefinitionSearch::performSearch(), ilForumSearch::performSearch(), ilExerciseSearch::performSearch(), ilObjRoleTemplateGUI::permObject(), ilObjQuestionPoolGUI::printObject(), ilObjSurvey::processCSVRow(), ilUtil::processCSVRow(), ilObjTest::processCSVRow(), ilObjTest::randomSelectQuestions(), ilMDTypicalAgeRange::read(), ilMDTechnical::read(), ilMDTaxonPath::read(), ilMDTaxon::read(), ilMDRights::read(), ilMDRequirement::read(), ilMDRelation::read(), ilMDMetaMetadata::read(), ilMDLocation::read(), ilMDLifecycle::read(), ilMDLanguage::read(), ilMDKeyword::read(), ilMDIdentifier_::read(), ilMDIdentifier::read(), ilMDGeneral::read(), ilMDFormat::read(), ilMDEntity::read(), ilMDEducational::read(), ilMDDescription::read(), ilMDContribute::read(), ilMDClassification::read(), ilMDAnnotation::read(), ilObjCourseGrouping::read(), ilSearchResult::read(), ilObjFile::read(), ilObjExercise::read(), ilObject::read(), ilExerciseMembers::read(), ilObjDlBook::readAssignedTranslations(), ilObjAICCCourseInterchangeFiles::readCSVFile(), ilLMMenuEditor::readEntry(), ilLinkResourceItems::readItem(), ilMail::readMailObjectReferenceId(), ilObjUser::readPrefs(), ilTree::readRootId(), ilObjUser::readUserDefinedFields(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilObjectGUI::removeDeletedNodes(), ilUtil::removeItemFromDesktops(), ilObjSurvey::removeSelectedSurveyResults(), ilObjTest::retrieveTestTypes(), ilRbacReview::roleExists(), Spreadsheet_Excel_Writer::rowcolToCell(), SurveyQuestion::saveCategoryToDb(), ilObjSurvey::saveQuestionsToDb(), ilObjTest::saveQuestionsToDb(), ilTree::saveSubTree(), ASS_MarkSchema::saveToDb(), assSingleChoice::saveWorkingData(), assQuestionTypeTemplate::saveWorkingData(), assNumeric::saveWorkingData(), SurveySearch::search(), ilUtil::searchGroups(), ilSoapUserAdministration::searchUser(), ilObjUser::searchUsers(), ilAddressbook::searchUsers(), ilMail::sendInternalMail(), ilCronForumNotification::sendNotifications(), ilForum::sendNotifications(), ilCourseMembers::sendNotificationToAdmins(), ilCourseMembers::sendSubscriptionRequestToAdmins(), ilCourseMembers::sendUnsubscribeNotificationToAdmins(), ilObjectGUIAdapter::setAdminTabs(), ilObjSurvey::setInvitation(), setLocator(), ilObjSAHSLearningModuleGUI::setLocator(), ilObjFileBasedLMGUI::setLocator(), setLOLocator(), ilDBx::setMaxAllowedPacket(), ilObjSurvey::setObligatoryStates(), Spreadsheet_Excel_Writer_Worksheet::setRow(), ilNestedSetXML::setTagName(), ilNestedSetXML::setTagValue(), ilLMStatisticsGUI::show(), ilObjContentObjectGUI::showActions(), ilObjUserFolderGUI::showActions(), ilObjectGUI::showActions(), ilBookmarkAdministrationGUI::showActions(), ilLMObjectGUI::showPossibleSubObjects(), ilObjUserFolderGUI::showPossibleSubObjects(), ilObjRoleFolderGUI::showPossibleSubObjects(), ilObjectGUI::showPossibleSubObjects(), ilContainerGUI::showPossibleSubObjects(), ilBookmarkAdministrationGUI::showPossibleSubObjects(), ilObjForumGUI::showStatisticsObject(), ilNestedSetXML::startElement(), ilConditionHandler::storeCondition(), ilCron::txt(), ilCronCheckUserAccounts::txt(), ilLanguage::txtlng(), Spreadsheet_Excel_Writer_Worksheet::write(), Spreadsheet_Excel_Writer_Worksheet::writeBlank(), Spreadsheet_Excel_Writer_Worksheet::writeCol(), Spreadsheet_Excel_Writer_Worksheet::writeFormula(), Spreadsheet_Excel_Writer_Worksheet::writeNote(), Spreadsheet_Excel_Writer_Worksheet::writeNumber(), Spreadsheet_Excel_Writer_Worksheet::writeRow(), Spreadsheet_Excel_Writer_Worksheet::writeString(), Spreadsheet_Excel_Writer_Worksheet::writeStringBIFF8(), ilObjAICCCourseInterchangeFiles::writeToDatabase(), and Spreadsheet_Excel_Writer_Worksheet::writeUrl().
| $search_result = $this->db->query($query) |
Definition at line 3569 of file dbupdate.php.
Referenced by ilObjUserFolderGUI::searchUserObject().
| $sty_folder_id = $row->id |
Definition at line 5464 of file dbupdate.php.
| $table = 'il_meta_annotation' |
Definition at line 9545 of file dbupdate.php.
Referenced by ilMD::_deleteAllByType(), ilObjSurveyGUI::browseForQuestionsObject(), ilMD::deleteAll(), ilTestEvaluationGUI::eval_a(), ilFeedback::getChartData(), PGTStorageDB::PGTStorageDB(), ilObjQuestionPoolGUI::printObject(), ilObjTestGUI::questionBrowser(), ilObjSurveyQuestionPoolGUI::questionsObject(), ilObjQuestionPoolGUI::questionsObject(), and CASClient::setPGTStorageDB().
| while ($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) $tables |
array('il_meta_annotation', 'il_meta_classification', 'il_meta_contribute', 'il_meta_description', 'il_meta_educational', 'il_meta_entity', 'il_meta_format', 'il_meta_general', 'il_meta_identifier', 'il_meta_identifier_', 'il_meta_keyword', 'il_meta_language', 'il_meta_lifecycle', 'il_meta_location', 'il_meta_meta_data', 'il_meta_relation', 'il_meta_requirement', 'il_meta_rights', 'il_meta_taxon', 'il_meta_taxon_path', 'il_meta_technical', 'il_meta_typical_age_range')
Definition at line 6799 of file dbupdate.php.
Referenced by ilMD::_deleteAllByType(), ilMD::deleteAll(), and ilClient::isInstalledDB().
| $tpl = $res->fetchRow(DB_FETCHMODE_ASSOC) |
Definition at line 603 of file dbupdate.php.
| $tree = new ilTree(ROOT_FOLDER_ID) |
Definition at line 1194 of file dbupdate.php.
Referenced by ilObjectXMLWriter::__appendObject(), ilCourseContentGUI::__buildPath(), ilCourseItemAdministrationGUI::__checkItemId(), ilLPListOfSettingsGUI::__formatPath(), ilEventAdministrationGUI::__formatPath(), ilCourseObjectivesGUI::__getAllChapters(), ilCourseObjectivesGUI::__getAllLMs(), ilLPFilter::__getAllObjects(), ilCourseObjectivesGUI::__getAllTests(), ilPaymentObjectGUI::__getHTMLPath(), ilLuceneIndexer::__indexFiles(), ilEventAdministrationGUI::__initCourseObject(), ilCourseObjectivePresentationGUI::__initCourseObject(), ilCourseContentGUI::__initCourseObject(), ilCourseArchivesGUI::__initCourseObject(), ilCourseItemAdministrationGUI::__initItem(), ilLearningProgressBaseGUI::__insertPath(), ilCourseStart::__read(), ilCourseObjectiveQuestion::__read(), ilCourseObjectiveLM::__read(), ilLPListOfSettingsGUI::__showCollectionTable(), ilLPListOfSettingsGUI::__showSCOTable(), ilSearch::__validateResults(), ilObjCourseGrouping::_checkAccess(), ilObjCourseGrouping::_checkGroupingDependencies(), ilSearch::_checkParentConditions(), ilInternalLink::_exists(), ilObjCourseGrouping::_getGroupingItemsAsString(), ilLPCollections::_getPossibleItems(), ilLMPageObject::_getPresentationTitle(), ilObjChat::_getPublicChatRefId(), ilObjStyleSheet::_getStandardStyles(), ilObjSCORMLearningModule::_getTrackingItems(), ilObject::_isInTrash(), ilLMPageObject::_splitPage(), ilLMPageObject::_splitPageNext(), ilCourseLMHistory::_updateLastAccess(), ilLocatorGUI::addAdministrationItems(), SurveyQuestionGUI::addMaterial(), ilPersonalDesktopGUI::addParentRow(), ilSoapObjectAdministration::addReference(), ilLocatorGUI::addRepositoryItems(), assQuestionGUI::addSuggestedSolution(), ilObjCourseGroupingGUI::assignCourse(), ilUserImportParser::assignToRole(), ilSurveyEvaluationGUI::cancelEvaluationAccess(), ilCourseContentInterface::cci_read(), ilObjContentObject::checkTree(), ilValidator::checkTreeStructure(), ilSoapCourseAdministration::deleteCourse(), ilSoapObjectAdministration::deleteObject(), ilUserImportParser::detachFromRole(), ilAccessHandler::doPathCheck(), ilAccessHandler::doTreeCheck(), ilPurchaseBMFGUI::executeCommand(), ilPaymentTrusteeGUI::executeCommand(), ilPaymentStatisticGUI::executeCommand(), ilPaymentShoppingCartGUI::executeCommand(), ilPaymentObjectGUI::executeCommand(), ilPaymentBuyedObjectsGUI::executeCommand(), ilPaymentBillAdminGUI::executeCommand(), ilPaymentAdminGUI::executeCommand(), ilPaymentGUI::executeCommand(), ilSearchResult::filter(), ilSearchResult::filterResults(), ilObjContentObject::fixTree(), ilRoleDesktopItem::getAll(), ilRbacReview::getAssignableChildRoles(), ilObjCourseGrouping::getAssignedItems(), ilUserImportParser::getCourseMembersObjectForRole(), ilObjUser::getDesktopItems(), ilForum::getForumPath(), ilObjUser::getGroupMemberships(), ilNoteGUI::getNoteListHTML(), ilRbacReview::getObjectsWithStopedInheritance(), ilRbacReview::getParentRoleIds(), ilSoapObjectAdministration::getRefIdsByImportId(), ilRbacReview::getRoleFolderOfObject(), ilChatRoom::getRooms(), ilObjGlossary::getTermList(), ilSQL2XML::getTree(), ilSoapObjectAdministration::getTreeChilds(), ilSoapUserAdministration::getUserForRole(), ilSoapObjectAdministration::getXMLTree(), ilObjContentObject::hasSuccessorPage(), ilCourseContentInterface::ilCourseContentInterface(), ilCourseObjectivesGUI::ilCourseObjectivesGUI(), ilForumTabsGUI::ilForumTabsGUI(), ilLMPresentationGUI::ilLocator(), ilLocatorGUI::ilLocatorGUI(), ilLPItemListGUI::ilLPItemListGUI(), ilMDSaxParser::ilMDSaxParser(), ilObjGroup::ilObjGroup(), ilPermissionGUI::ilPermissionGUI(), ilStyleImportParser::ilStyleImportParser(), ilTimingAccepted::ilTimingAccepted(), ilTimingPlaned::ilTimingPlaned(), ilUserImportParser::ilUserImportParser(), ilSoapUserAdministration::importUsers(), ilValidator::initGapsInTree(), ilInitialisation::initILIAS(), ilObjectListGUI::insertPath(), ilLMStatisticsGUI::listUsersGroup(), ilRepositorySearchGUI::listUsersGroup(), ilRepositorySearchGUI::listUsersRole(), ilEventAdministrationGUI::materials(), ilObjSurveyQuestionPool::notify(), ilObjSurvey::notify(), ilObjSAHSLearningModule::notify(), ilObjGlossary::notify(), ilObjContentObject::notify(), ilObj< module_name >::notify(), ilObjSysUserTracking::notify(), ilObjStyleSheetFolder::notify(), ilObjStyleSettings::notify(), ilObjRootFolder::notify(), ilObjRecoveryFolder::notify(), ilObjGroup::notify(), ilObjForum::notify(), ilObjExternalToolsSettings::notify(), ilObject::notify(), ilObjAuthSettings::notify(), ilObjAssessmentFolder::notify(), ilObjAdvancedEditing::notify(), ilObjTest::notify(), ilObjQuestionPool::notify(), ilPageObjectGUI::presentation(), ilPageObjectGUI::preview(), ilObjRoleFolder::purge(), ilObjContentObject::putInTree(), ilLMObjectGUI::putInTree(), ilObjFolder::putInTree(), ilObject::putInTree(), ilSoapObjectAdministration::removeFromSystemByImportId(), ilAccountMail::replacePlaceholders(), ilValidator::restoreDeletedObjects(), ilValidator::restoreSubTrees(), ilLMStatisticsGUI::search(), ilObjCourseGroupingGUI::selectCourse(), ilLPFilterGUI::selector(), ilMainMenuGUI::setTemplateVars(), ilContainerLinkListGUI::show(), ilPaymentStatisticGUI::showObjectSelector(), ilPaymentObjectGUI::showObjectSelector(), ilPageObjectGUI::showPage(), ilLMPresentationGUI::showTableOfContents(), ilNoteGUI::showTargets(), Spreadsheet_Excel_Writer_Parser::toReversePolish(), ilPageObjectGUI::view(), ilEditClipboardGUI::view(), viewObject(), and ilObjAICCCourseInterchangeFiles::writeToDatabase().
| $tree_set = $this->db->query($q) |
Definition at line 5387 of file dbupdate.php.
Referenced by ilStructureObject::_getPresentationTitle().
| $typ_id = $row[0] |
Definition at line 363 of file dbupdate.php.
| $type_id = $row[0] |
Definition at line 4350 of file dbupdate.php.
| $user_id = "" |
Definition at line 3737 of file dbupdate.php.
Referenced by ilLearningProgressBaseGUI::__appendLPDetails(), ilRoleDesktopItem::__assign(), ilLearningProgressBaseGUI::__readStatus(), ilObjAssessmentFolder::_addLog(), ilObjTest::_buildName(), ilObjiLincClassroomAccess::_checkAccess(), ilObjTest::_getActiveTestUser(), ilLPStatusObjectives::_getCompleted(), ilObjSurveyAccess::_hasEvaluationAccess(), ilObjSurveyAccess::_isSurveyParticipant(), SurveyQuestion::_isWriteable(), assQuestion::_isWriteable(), ilUserTracking::_trackAccess(), ilTracking::_trackAccess(), ilTestEvaluationGUI::addFoundUsersToEval(), ilObjCourseGUI::addFromWaitingList(), ilObjTestGUI::addParticipantsObject(), ilObjTest::addSelectedGroup(), ilObjTest::addSelectedRole(), ilObjTest::addSelectedUser(), ilPaymentTrusteeGUI::addTrustee(), ilPaymentTrusteeGUI::addUser(), addUserRoleEntry(), ilSoapRBACAdministration::addUserRoleEntry(), ilCourseStart::allFullfilled(), assignCourseMember(), ilSoapCourseAdministration::assignCourseMember(), assignGroupMember(), ilSoapGroupAdministration::assignGroupMember(), ilObjCourseGUI::assignMembersObject(), ilObjTest::buildName(), ilObjTest::canShowSolutionPrintview(), ilObjTest::canShowTestResults(), ilPermissionGUI::changeOwner(), ilObjiLincCourseGUI::confirmationObject(), ilObjGroupGUI::confirmationObject(), db_pwassist_session_find(), db_pwassist_session_write(), ilObjRole::delete(), ilObjExercise::deleteDeliveredFiles(), ilObjTest::deleteResults(), ilSoapRBACAdministration::deleteRole(), ilObjTestGUI::deleteSingleUserResultsObject(), deleteUser(), ilSoapUserAdministration::deleteUser(), deleteUserRoleEntry(), ilSoapRBACAdministration::deleteUserRoleEntry(), ilObjSurvey::deleteWorkingData(), ilObjExercise::deliverFile(), ilForum::disableNotification(), ilObjSurvey::disinviteUser(), ilObjTest::disinviteUser(), ilObjSurveyGUI::disinviteUserGroupObject(), ilPersonalDesktopGUI::displayUsersOnline(), ilEventAdministrationGUI::editMembers(), ilForum::enableNotification(), ilTestEvaluationGUI::evaluationDetail(), ilSurveyEvaluationGUI::evaluationuser(), ilTestEvaluationGUI::evalUserDetail(), excludeCourseMember(), ilSoapCourseAdministration::excludeCourseMember(), excludeGroupMember(), ilSoapGroupAdministration::excludeGroupMember(), ilObjSurvey::finishSurvey(), ilObjTest::getActiveIdOfUser(), ilObjTest::getActiveTestUser(), ilObjTest::getAllTestResults(), ilObjTest::getCompleteWorkingTime(), ilObjExercise::getDeliveredFiles(), ilObjSurvey::getEvaluationByUser(), ilObjTest::getEvaluationParticipants(), ilObjTest::getEvaluationUsers(), ilObjUser::getGroupMemberships(), ilSearchItemFactory::getInstance(), ilObjTest::getInvitedUsers(), ilObjSurvey::getLastActivePage(), getObjectByReference(), ilSoapObjectAdministration::getObjectByReference(), getObjectsByTitle(), ilSoapObjectAdministration::getObjectsByTitle(), getObjectTreeOperations(), ilSoapRBACAdministration::getObjectTreeOperations(), ilSoapRBACAdministration::getRoles(), ilObjTest::getStartingTimeOfUser(), ilObjTest::getTestSummary(), getTreeChilds(), ilSoapObjectAdministration::getTreeChilds(), getUser(), ilSoapUserAdministration::getUser(), ilObjSurvey::getUserAccessCode(), getUserRoles(), ilSoapRBACAdministration::getUserRoles(), ilObjSurvey::getUserSurveyCode(), getXMLTree(), ilSoapObjectAdministration::getXMLTree(), ilCourseItems::ilCourseItems(), ilObjectStatusGUI::ilObjectStatusGUI(), ilObjNoteFolder::ilObjNoteFolder(), ilObjSurvey::inviteGroup(), ilObjTest::inviteGroup(), ilObjSurvey::inviteRole(), ilObjTest::inviteRole(), ilObjSurvey::inviteUser(), ilObjTest::inviteUser(), ilObjSurveyGUI::inviteUserGroupObject(), ilObjTest::isActiveTestSubmitted(), isAssignedToCourse(), ilSoapCourseAdministration::isAssignedToCourse(), isAssignedToGroup(), ilSoapGroupAdministration::isAssignedToGroup(), ilObjTest::isExecutable(), ilCourseStart::isFullfilled(), ilObjGroup::isMember(), ilObjForum::isNotificationEnabled(), ilForum::isNotificationEnabled(), ilObjSurvey::isSurveyStarted(), isUserLoggedIn(), ilObjSurvey::loadWorkingData(), ilSoapUserAdministration::lookupUser(), ilTestEvaluationGUI::outEvalSearchResultTable(), ilObjTestGUI::outPrintUserResults(), ilTestOutputGUI::outQuestionSummary(), ilTestOutputGUI::outResultsOverview(), ilTestOutputGUI::outShowAnswersDetails(), ilObjTestGUI::outShowAnswersDetails(), ilTestOutputGUI::outTestResults(), ilTestOutputGUI::outTestSummary(), ilObjSurveyGUI::outUserGroupTable(), ilTestEvaluationGUI::passDetails(), ilObjCategoryGUI::performDeleteUsersObject(), ilEventAdministrationGUI::printViewMembers(), ilObjHACPTracking::putparam(), ilObjiLincCourse::registerUsers(), ilObjTestGUI::removeParticipantObject(), ilTestEvaluationGUI::removeSelectedUser(), ilObjTest::removeSelectedUser(), ilObjTest::removeTestResultsForUser(), ilSurveyExecutionGUI::saveActiveQuestionData(), ilObjTestGUI::saveClientIPObject(), saveQuestionResult(), ilSoapUtils::saveQuestionResult(), ilObjSurvey::saveUserAccessCode(), SurveyTextQuestion::saveUserInput(), SurveyOrdinalQuestion::saveUserInput(), SurveyNominalQuestion::saveUserInput(), SurveyMetricQuestion::saveUserInput(), ilObjSurvey::saveWorkingData(), searchObjects(), ilSoapObjectAdministration::searchObjects(), ilHACPResponse::sendParam(), ilObjTest::setActiveTestSubmitted(), ilObjTest::setClientIP(), ilObjSurvey::setInvitation(), ilObjTest::setQuestionSetSolved(), ilObjTestGUI::showAnswersObject(), ilObjTestGUI::showResultsObject(), ilObjSurvey::startSurvey(), ilObjTest::startWorkingTime(), ilObjSCORMTracking::store(), ilUserTracking::TestTitle(), ilTracking::TestTitle(), ilnetucateXMLAPI::unregisterUser(), ilObjiLincCourseGUI::updateMemberStatusObject(), updatePassword(), and ilSoapUserAdministration::updatePassword().
| $user_set = $this->db->query($q) |
Definition at line 3545 of file dbupdate.php.
Referenced by ilObjUser::_getUsersForClipboadObject(), ilObjUser::_lookupHasIlias2Password(), ilObjUser::_lookupId(), ilObjUser::_lookupLastLogin(), ilObjUser::_lookupLogin(), ilObjUser::_lookupName(), ilObjUser::_switchToIlias3Password(), and ilObjSCORMLearningModule::getTrackingDataAgg().
| $users = array() |
Definition at line 506 of file dbupdate.php.
Referenced by ilObjChatGUI::__showActiveUsers(), ilObjChatGUI::__showOnlineUsers(), ilUserFilter::__toArray(), ilLocalUser::_getAllUserIds(), ilLPStatusSCORM::_getCompleted(), ilLPStatusCollection::_getCompleted(), ilObjSCORMTracking::_getCountCompletedPerUser(), ilLPStatusSCORM::_getFailed(), ilLPStatusCollection::_getFailed(), ilLPStatusTestPassed::_getInProgress(), ilLPStatusSCORM::_getInProgress(), ilLPStatusExerciseReturned::_getInProgress(), ilLPStatusCollection::_getInProgress(), ilObjUser::_getLocalAccountsForEmail(), ilObjGroup::_getMembers(), ilLPStatusObjectives::_getNotAttempted(), ilLPStatusManual::_getNotAttempted(), ilLPStatusExerciseReturned::_getNotAttempted(), ilLPStatusEvent::_getNotAttempted(), ilLPStatusCollection::_getNotAttempted(), ilLocalUser::_getUserData(), ilObjUser::_getUsersForClipboadObject(), Database::addDate(), Database::cleanDatabase(), Database::delDate(), ilObjRole::delete(), ilPersonalDesktopGUI::displayUsersOnline(), ilUtil::getAssociatedUsersOnline(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationParticipants(), ilObjTest::getEvaluationUsers(), ilFeedback::getResultUsers(), ilObjMediaObject::getUsages(), ilUtil::getUsersOnline(), ilObjSurveyGUI::inviteObject(), ilObjCategoryGUI::listUsersObject(), ilObjAssessmentFolderGUI::logsObject(), ilTestEvaluationGUI::outStatSelectedSearchResults(), ilObjTestGUI::participantsObject(), ilUtil::removeItemFromDesktops(), and Database::updateDate().
| $visible_id = "" |
Definition at line 3717 of file dbupdate.php.
| while ($row=$result->fetchRow(DB_FETCHMODE_ASSOC)) $wd = getcwd() |
Definition at line 6220 of file dbupdate.php.
| $webr_ids = array() |
Definition at line 6225 of file dbupdate.php.
