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() | |
Function Documentation
| _lookupObjId | ( | $ | a_id | ) |
Definition at line 8599 of file dbupdate.php.
References $row.
Referenced by ilSearch::__checkAccess(), ilObjContentObjectAccess::_getLastAccessedPage(), ilPersonalDesktopGUI::addParentRow(), ilAccessHandler::checkAccessOfUser(), ilLMPresentationGUI::getLinkXML(), ilLMPageObjectGUI::getLinkXML(), ilGlossaryPresentationGUI::getLinkXML(), ilSCORMPresentationGUI::launchSahs(), ilHACPPresentationGUI::launchSahs(), ilAICCPresentationGUI::launchSahs(), ilObjHACPTracking::putparam(), 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 9867 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 9914 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++;
}
}
}
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 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 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(), 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 9543 of file dbupdate.php.
Referenced by ilAdvancedSearch::__createEducationalWhere(), ilAdvancedSearch::__getDifference(), ilCourseXMLParser::__parseId(), ilGroupImportParser::__parseId(), ilAppointmentHandler::appointmentRepeatsNot(), ilAppointmentHandler::appointmentUpdate(), ilObjiLincCourseGUI::displayEditForm(), ilObjiLincClassroomGUI::displayEditForm(), ilObjectGUI::displayEditForm(), ilObjiLincClassroomGUI::editClassroom(), ilObjiLincCourseGUI::editObject(), ilObjFileGUI::editObject(), ilObjectGUI::editObject(), ilMDConvert(), ilAppointmentHandler::insertAppointment(), ilElement::insertDb(), ilObjUserFolderGUI::learningProgressObject(), and SurveySearch::search().
| $file_ids = array() |
Definition at line 9072 of file dbupdate.php.
Referenced by ilPageObject::collectFileItems(), ilObjGlossary::exportXML(), ilObjContentObject::exportXMLPageObjects(), ilObjTest::exportXMLPageObjects(), ilObjQuestionPool::exportXMLPageObjects(), and ilPageObject::saveFileUsage().
| $foundactive = array() |
Definition at line 9783 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 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(), ilQTIParser::handlerParseEndTag(), ilObjSurvey::moveDownQuestion(), ilObjSurvey::moveDownQuestionblock(), ilObjSurvey::moveQuestions(), ilObjSurvey::moveUpQuestion(), ilObjSurvey::moveUpQuestionblock(), ilObjTestGUI::outPrinttest(), ilTestOutputGUI::outShowAnswersDetails(), ilTestEvaluationGUI::outShowAnswersDetails(), ilObjTestGUI::outShowAnswersDetails(), ASS_TextQuestionGUI::outWorkingForm(), ASS_OrderingQuestionGUI::outWorkingForm(), ASS_MultipleChoiceGUI::outWorkingForm(), ASS_MatchingQuestionGUI::outWorkingForm(), ASS_ImagemapQuestionGUI::outWorkingForm(), ASS_ClozeTestGUI::outWorkingForm(), ilTestEvaluationGUI::passDetails(), 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.
| $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 9545 of file dbupdate.php.
Referenced by ilCourseArchives::__buildStructure(), ilPermissionGUI::__displayAddRoleForm(), ilSearchGUI::__getFilter(), ilObjDlBookGUI::__parseCitationPost(), ilObjLinkResourceGUI::__setLocator(), ilObjRoleGUI::__setLocator(), ilObjChatGUI::__setLocator(), ilRbacReview::__setRoleType(), ilMDEditorGUI::__setTabs(), ilObjExerciseGUI::__showMembersTableContent(), ilSoapUserAdministration::__substituteUserData(), ilTree::__validateSubtrees(), ilObjSurvey::_clone(), ilObjTest::_clone(), ilHistory::_createEntry(), ilBMFDISCO_Server::_generate_DISCO_XML(), ilBMFDISCO_Server::_generate_WSDL_XML(), ilMDUtilSelect::_getDifficultySelect(), ilMDUtilSelect::_getDurationSelect(), ilMDFactory::_getInstance(), ilMDUtilSelect::_getInteractivityLevelSelect(), ilMediaItem::_getMapAreasIntLinks(), ilMDUtilSelect::_getSemanticDensitySelect(), ilObjTestAccess::_getTestResult(), ilUserAgreement::_getText(), ASS_Question::_getTotalRightAnswers(), ilMDUtilSelect::_getTypicalAgeRangeSelect(), ilMDUtilSelect::_getTypicalLearningTimeSelect(), ilObjCategoryGUI::_importCategoriesForm(), ilBMFTransport_HTTP::_sendHTTPS(), Spreadsheet_Excel_Writer_Workbook::_storeAllFonts(), ASS_OrderingQuestion::add_answer(), ASS_MultipleChoice::add_answer(), ilLocatorGUI::addAdministrationItems(), ilObjSurveyGUI::addHeadingObject(), ASS_OrderingQuestionGUI::addItem(), ilMDGeneral::addKeyword(), ilMDClassification::addKeyword(), ilObjContentObjectGUI::addLocations(), ilLocatorGUI::addRepositoryItems(), ASS_ClozeTestGUI::addSuggestedSolution(), array_merge_php4(), assignMailToPost(), ilObjSurveyGUI::browseForQuestionsObject(), ASS_JavaApplet::buildParams(), ASS_JavaApplet::buildParamsOnly(), ilBMFServer::buildResult(), ilvCard::buildVCard(), ilSQL2XML::buildXML(), ASS_OrderingQuestion::calculateReachedPoints(), ASS_MultipleChoice::calculateReachedPoints(), ASS_MatchingQuestion::calculateReachedPoints(), ASS_ImagemapQuestion::calculateReachedPoints(), soap_client::call(), ilCourseContentInterface::cci_view(), ilObjSystemFolderGUI::changeHeaderTitleObject(), ilObjLanguageFolder::checkAllLanguages(), ilUtil::checkFormEmpty(), checkIfNotNegDate(), ASS_MultipleChoiceGUI::checkInput(), ilLanguage::checkLanguage(), ASS_OrderingQuestion::checkSaveData(), ASS_MatchingQuestion::checkSaveData(), XML2DOM::clean(), ilNestedSetXML::clean(), ilObjSurveyGUI::codesObject2(), 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(), ASS_ClozeTest::createCloseTextArray(), ASS_ClozeTest::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(), ASS_OrderingQuestion::createRandomSolution(), ASS_MultipleChoice::createRandomSolution(), ASS_MatchingQuestion::createRandomSolution(), ilObjUserFolder::createXMLExport(), ilLanguage::cut_header(), ilExerciseMembers::deassignMember(), ilObjSurveyGUI::defineQuestionblock(), ilObjSurveyGUI::defineQuestionblockObject(), ilMDGeneral::delete(), ilMDClassification::delete(), ilBookmarkAdministrationGUI::delete(), ASS_OrderingQuestionGUI::delete(), ASS_MultipleChoiceGUI::delete(), ASS_ClozeTestGUI::delete(), ASS_MarkSchema::delete_mark_steps(), ilImagemapPreview::deleteArea(), ASS_ImagemapQuestionGUI::deleteArea(), ilObjSurveyGUI::deleteConstraintsObject(), ilExerciseMembers::deleteDeliveredFiles(), ilObjTestGUI::deleteMarkStepsObject(), SurveyQuestion::deleteMaterial(), ilObjUserFolderGUI::deleteObject(), ilObjRoleFolderGUI::deleteObject(), ilObjectGUI::deleteObject(), ilObjSurveyQuestionPoolGUI::deletePhraseObject(), ilObjSurveyQuestionPoolGUI::deleteQuestionsObject(), ilObjTestGUI::deleteSingleUserResultsObject(), ilObjUserGUI::deliverVCardObject(), ilGlossaryLocatorGUI::display(), ilContObjLocatorGUI::display(), ilForumLocatorGUI::display(), ilSetupGUI::displayClientList(), ilObjiLincCourseGUI::displayEditForm(), ilObjiLincClassroomGUI::displayEditForm(), ilObjectGUI::displayEditForm(), 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(), ASS_TextQuestionGUI::editQuestion(), ASS_OrderingQuestionGUI::editQuestion(), ASS_MultipleChoiceGUI::editQuestion(), ASS_MatchingQuestionGUI::editQuestion(), ASS_JavaAppletGUI::editQuestion(), ASS_ImagemapQuestionGUI::editQuestion(), ASS_ClozeTestGUI::editQuestion(), ilTestEvaluationGUI::eval_stat(), ilTestEvaluationGUI::evalSelectedUsers(), ilObjTest::evalStatistical(), ilTestEvaluationGUI::evalStatSelected(), ilObjTest::evalTotalFinishedAverageTime(), ilObjTest::evalTotalFinishedPassed(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalStartedAverageTime(), ilSurveyEvaluationGUI::evaluation(), ilSurveyEvaluationGUI::evaluationuser(), exercise(), ilObjDlBook::export(), ilObjSurveyQuestionPoolGUI::exportQuestionsObject(), ilObjSCORMTracking::extractData(), ilTemplate::fillVars(), ilForumExplorer::formatObject(), formSelect(), ilUtil::formSelect(), Context::from_language(), ilBMFWSDL::generateAllProxies(), ilBMFWSDL::generateProxyCode(), ilObjTest::generateRandomQuestions(), ASS_ClozeTest::get_gap_text_list(), ASS_OrderingQuestion::get_max_solution_order(), ASS_MatchingQuestion::get_random_id(), ilObjMediaPool::getChilds(), ilObjSurvey::getEvaluation(), ilObjSurvey::getEvaluationByUser(), ilObjUserFolder::getExportSettings(), Spreadsheet_Excel_Writer_Format::getFontKey(), ilFileExplorer::getIndex(), ilExplorer::getIndex(), ilPageObject::getInternalLinks(), ilGlossaryTermGUI::getInternalLinks(), ilMDGeneral::getKeyword(), ilMDClassification::getKeyword(), ilObjAssessmentFolder::getLog(), ASS_OrderingQuestion::getMaximumPoints(), ASS_MultipleChoice::getMaximumPoints(), ASS_MatchingQuestion::getMaximumPoints(), ASS_ImagemapQuestion::getMaximumPoints(), ASS_ClozeTest::getMaximumPoints(), ilObjSurvey::getNextPage(), ilBookmarkFolder::getObjects(), ilSCORMExplorer::getOutput(), ilPublicSectionSelector::getOutput(), ilMailExplorer::getOutput(), ilForumExplorer::getOutput(), ilFileExplorer::getOutput(), ilExplorer::getOutput(), ilBookmarkExplorer::getOutput(), ASS_JavaApplet::getParameterIndex(), ilObjUserGUI::getPublicProfile(), ilObjSurvey::getQuestionblocksTable(), ilObjSurveyQuestionPool::getQuestionsTable(), ilObjSurvey::getQuestionsTable(), ilObjTest::getQuestionsTable(), ilObjQuestionPool::getQuestionsTable(), ASS_MultipleChoice::getReachedInformation(), ASS_MatchingQuestion::getReachedInformation(), ASS_ImagemapQuestion::getReachedInformation(), ASS_ClozeTest::getReachedInformation(), ilPermissionGUI::getRolesData(), ilMailbox::getSubFolders(), ilObjiLincCourseGUI::getSubItems(), ilContainerGUI::getSubItems(), ilObjectDefinition::getSubobjectsToFilter(), ilObjQuestionPoolGUI::getTabs(), ilTabsGUI::getTargetsByObjectType(), 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(), 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(), SurveyQuestion::keyInArray(), ASS_Question::keyInArray(), ilObjUserFolderGUI::learningProgressObject(), ilUtil::Linkbar(), ilGlossaryPresentationGUI::listTermByGiven(), ilObjGlossaryGUI::listTerms(), ilObjAssessmentFolderGUI::logsObject(), ilUtil::makeDirParents(), ilObjTestGUI::marksObject(), ilObjQuestionPoolGUI::moveObject(), ilObjSurveyGUI::moveQuestionsObject(), ilObjExerciseGUI::newMembersObject(), ilDBUpdate::optimizeTables(), ilTestEvaluationGUI::outEvalSearchResultTable(), ilObjTestGUI::outPrintUserResults(), ilObjUserTrackingGUI::outputTrackingDataObject(), ilTestOutputGUI::outTestResults(), ilTestOutputGUI::outTestSummary(), ilObjTestGUI::outUserGroupTable(), ASS_OrderingQuestionGUI::outWorkingForm(), ASS_MatchingQuestionGUI::outWorkingForm(), 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(), ASS_ClozeTest::rebuild_cloze_text(), ilObjiLincClassroomGUI::removeClassroom(), ilObjSurvey::removeConstraintsConcerningQuestion(), ASS_JavaApplet::removeParameter(), ilObjSurveyGUI::removeQuestionsObject(), ilObjTestGUI::removeQuestionsObject(), ASS_ClozeTestGUI::removeSuggestedSolution(), ilTableGUI::render(), ilSearchResultPresentationGUI::renderItemList(), ilObjiLincCourseGUI::renderItemList(), ilContainerGUI::renderItemList(), ilTemplate::replace(), ilNestedSetXML::replaceDomContent(), ilTemplate::replaceFromDatabase(), ilValidator::restoreDeletedObjects(), ilValidator::restoreSubTrees(), ilBenchmark::save(), ilObjSurveyGUI::saveDefineQuestionblockObject(), 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(), ASS_OrderingQuestion::saveToDb(), ASS_MultipleChoice::saveToDb(), ASS_MatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), ASS_ImagemapQuestion::saveToDb(), ASS_ClozeTest::saveToDb(), ASS_OrderingQuestion::saveWorkingData(), ASS_MultipleChoice::saveWorkingData(), ASS_MatchingQuestion::saveWorkingData(), ASS_ClozeTest::saveWorkingData(), searchForm(), searchObjects(), ilSoapObjectAdministration::searchObjects(), searchTest(), ilObjUserFolderGUI::searchUserObject(), ilBMFTransport_SMTP::send(), ilHACPResponse::sendParam(), ASS_ClozeTest::set_cloze_text(), ASS_ClozeTest::set_cloze_type(), ASS_ClozeTest::set_gap_points(), ASS_ClozeTest::set_gap_shuffle(), ilObjectGUIAdapter::setAdminTabs(), ilMailExplorer::setExpand(), ilForumExplorer::setExpand(), ilFileExplorer::setExpand(), ilExplorer::setExpand(), ilBookmarkExplorer::setExpand(), ASS_ClozeTestGUI::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(), ilObjQuestionPoolGUI::setQuestionTabs(), ASS_ClozeTestGUI::setShuffleState(), ilObjAssessmentFolderGUI::settingsObject(), ilTemplate::show(), ilIniFile::show(), ilObjDlBookGUI::showCitation(), ilLMPresentationGUI::showPrintView(), ilPersonalProfileGUI::showProfile(), ilExplorer::sortNodes(), soap_parser::start_element(), ilBMFWSDL_Parser::startElement(), ilBMFParser::startElement(), ilWysiwygUtil::startElement(), ilNestedSetXML::startElement(), ASS_OrderingQuestion::syncWithOriginal(), ASS_MultipleChoice::syncWithOriginal(), ASS_MatchingQuestion::syncWithOriginal(), ASS_ImagemapQuestion::syncWithOriginal(), ASS_ClozeTest::syncWithOriginal(), testOutput(), ilObjSurveyQuestionPool::to_xml(), ilObjQuestionPool::to_xml(), ASS_JavaApplet::to_xml(), ASS_ClozeTest::to_xml(), ilMDGeneral::toXML(), ilMDEducational::toXML(), ilMDClassification::toXML(), ilObjUserTrackingGUI::trackingDataQueryFormObject(), 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(), ASS_OrderingQuestionGUI::writePostData(), ASS_MultipleChoiceGUI::writePostData(), ASS_MatchingQuestionGUI::writePostData(), ASS_JavaAppletGUI::writePostData(), ASS_ImagemapQuestionGUI::writePostData(), ASS_ClozeTestGUI::writePostData(), and xslt_process().
| $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["file"] = array(2,3) |
Definition at line 2431 of file dbupdate.php.
| $ops_data["frm"] = array(2,3,4,9) |
Definition at line 2432 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["grp"] = array(2,3,7,8,18,25,26) |
Definition at line 2434 of file dbupdate.php.
| $ops_data["lm"] = array(2,3,7,8) |
Definition at line 2435 of file dbupdate.php.
| $ops_data["slm"] = array(2,3,7,8) |
Definition at line 2436 of file dbupdate.php.
| $ops_data["glo"] = array(2,3,7,8) |
Definition at line 2433 of file dbupdate.php.
| $ops_data["fold"] = array(2,3,18,25,26) |
Definition at line 2437 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.
| $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(), ilCronClients::__checkDBVersion(), ilTree::__checkDelete(), ilLinkChecker::__checkNotify(), ilSoapAuthentication::__checkSOAPEnabled(), 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(), ilChatRoom::__deleteFirstLine(), ilObjCourse::__deleteSettings(), ilCourseObjectiveQuestion::__deleteTest(), ilLinkChecker::__fetchUserData(), ilChatRoom::__getCountLines(), ilObjForum::__getCountNew(), ilLPStatusManual::__getCourseInProgress(), ilCourseItems::__getItemData(), ilCourseObjective::__getLastPosition(), ilCourseItems::__getLastPosition(), ilObjForum::__getLastThreadAccess(), ilLPStatusManual::__getLMInProgress(), ilLinkChecker::__getObjIdByPageId(), ilCourseObjectiveResult::__getReachedPoints(), ilGeneralSettings::__getSettings(), ilTree::__getSubTreeByParentRelation(), ilLinkChecker::__getTitle(), ilLuceneIndexer::__indexFiles(), ilLuceneIndexer::__indexHTLMs(), ilUserResult::__init(), ilSearchResult::__init(), ilSearchFolder::__init(), ilCourseObjectiveResult::__isAnswered(), ilCourseItems::__purgeDeleted(), ilLPFilter::__read(), ilLPCollections::__read(), ilPaymentVendors::__read(), ilPaymentTrustees::__read(), ilPaymentShoppingCart::__read(), ilPaymentPrices::__read(), ilPaymentObject::__read(), ilPaymentBookings::__read(), ilPaymentBillVendor::__read(), ilCourseWaitingList::__read(), ilCourseStart::__read(), ilCourseObjectiveQuestion::__read(), ilCourseObjectiveLM::__read(), ilCourseObjective::__read(), ilCourseMembers::__read(), ilCourseArchives::__read(), ilObjForum::__read(), ilChatRoom::__read(), ilChatBlockedUsers::__read(), ilObjUser::__readAppliedUsers(), ilSearch::__readDBResult(), ilSearchFolder::__readRootId(), ilCron::__readSetting(), ilObjCourse::__readSettings(), ilCourseMembers::__readSubscriberData(), ilCourseMembers::__readSubscribers(), ilLinkChecker::__saveInDB(), 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(), ilCourseObjective::__updateTop(), ilCourseItems::__updateTop(), ilObjAssessmentFolder::_addLog(), ilObjSurvey::_addQuestionblock(), ilOnlineTracking::_addUser(), ilObjSurvey::_clone(), ilPaymentPrices::_countPrices(), ilHistory::_createEntry(), ilLPObjSettings::_delete(), ilLPFilter::_delete(), ilObjForum::_deleteAccessEntries(), ilLPCollections::_deleteAll(), ilObjCourseGrouping::_deleteAll(), ilCourseWaitingList::_deleteAll(), ilCourseObjective::_deleteAll(), ilMD::_deleteAllByType(), ilNestedSetXML::_deleteAllChildMetaData(), ilLMObject::_deleteAllObjectData(), ilChatBlockedUsers::_deleteChat(), ilLinkCheckNotify::_deleteObject(), ilObjForum::_deleteReadEntries(), ilPaymentTrustees::_deleteTrusteesOfVendor(), ilObjUserTracking::_deleteUser(), ilCourseWaitingList::_deleteUser(), ilCourseObjectiveResult::_deleteUser(), ilCourseMembers::_deleteUser(), ilCourseLMHistory::_deleteUser(), ilObjForum::_deleteUser(), ilLinkCheckNotify::_deleteUser(), ilChatBlockedUsers::_deleteUser(), 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(), 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(), 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(), ilObjSCORMTracking::_getInProgress(), ilLPCollections::_getItems(), ilSCORMItem::_getItems(), ilMediaItem::_getMapAreasIntLinks(), SurveyTextQuestion::_getMaxChars(), ASS_Question::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilMediaItem::_getMediaItemsOfMOb(), ilCourseMembers::_getMembers(), ilLinkCheckNotify::_getNotifiers(), ilLinkCheckNotify::_getNotifyStatus(), ilObjTest::_getObjectIDFromTestID(), ilCourseObjective::_getObjectiveIds(), ilUtil::_getObjectsByOperations(), ilPaymentObject::_getObjectsData(), ilOnlineTracking::_getOnlineTime(), ilRbacReview::_getOperationIdsByName(), SurveyQuestion::_getOriginalId(), ASS_Question::_getOriginalId(), ilObjTest::_getPass(), ilObjTestAccess::_getPassedUsers(), ilObjTest::_getPassedUsers(), ilObjTest::_getPassScoring(), ilObjUser::_getPersonalPicturePath(), ilStructureObject::_getPresentationTitle(), ilLMPageObject::_getPresentationTitle(), ilPaymentPrices::_getPrice(), ilLearningProgress::_getProgress(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjTest::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), ASS_Question::_getQuestionInfo(), ASS_Question::_getQuestionTitle(), SurveyQuestion::_getQuestionType(), ASS_Question::_getQuestionType(), ilObjSurvey::_getQuestiontypes(), ilObjTest::_getQuestiontypes(), ASS_Question::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilObjTest::_getResultPass(), ilSearchSettings::_getSearchSettingRefId(), ASS_Question::_getSolutionMaxPass(), ilObjTest::_getSolvedQuestions(), ilPaymentCurrency::_getSubUnit(), ASS_Question::_getSuggestedSolution(), ASS_Question::_getSuggestedSolutionCount(), ilCourseObjectiveQuestion::_getTest(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestType(), ASS_Question::_getTitle(), ASS_Question::_getTotalAnswers(), ASS_Question::_getTotalRightAnswers(), ilObjAICCLearningModule::_getTrackingItems(), ilMDEducational::_getTypicalLearningTimeSeconds(), ilPaymentCurrency::_getUnit(), ilObjUser::_getUserIdsByEmail(), ilPaymentTrustees::_getVendorsForObjects(), ilPaymentObject::_hasAccess(), ilPaymentBookings::_hasAccess(), ilLPMarks::_hasCompleted(), ilObjSurvey::_hasDatasets(), ilPaymentShoppingCart::_hasEntries(), ilObjQuestionPool::_hasEqualPoints(), ilObjTestAccess::_hasFinished(), ilPaymentTrustees::_hasObjectPermission(), ilPaymentTrustees::_hasObjectPermissionByVendor(), ilCourseMembers::_hasPassed(), ilExerciseMembers::_hasSolved(), ilPaymentTrustees::_hasStatisticPermission(), ilPaymentTrustees::_hasStatisticPermissionByVendor(), ilChatServerCommunicator::_initObject(), ilObjCourse::_isActivated(), ilCourseItems::_isActivated(), ilChatRoom::_isActive(), ilCourseObjectiveQuestion::_isAssigned(), ilCourseMembers::_isBlocked(), ilChatBlockedUsers::_isBlocked(), ilPaymentObject::_isBuyable(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilCourseMembers::_isMember(), ilPaymentObject::_isPurchasable(), ilCourseMembers::_isSubscriber(), ASS_Question::_isUsedInRandomTest(), ilPaymentVendors::_isVendor(), ASS_Question::_isWorkedThrough(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), ASS_Question::_isWriteable(), ilGlossaryTerm::_lookGlossaryID(), ilGlossaryTerm::_lookGlossaryTerm(), ilGlossaryTerm::_lookLanguage(), ilObjUser::_lookupClientIP(), ilLPMarks::_lookupComment(), ilLMObject::_lookupContObjID(), ilObjUser::_lookupEmail(), ilForum::_lookupForumData(), ilObjGroup::_lookupIdByTitle(), ilLPMarks::_lookupMark(), ilLPObjSettings::_lookupMode(), ilObject::_lookupObjIdByImportId(), ilObjSurveyQuestionPool::_lookupOnline(), ilObjQuestionPool::_lookupOnline(), ilObjTestAccess::_lookupOnlineTestAccess(), ilPaymentObject::_lookupPobjectId(), ilSCORMItem::_lookupTitle(), ilLMObject::_lookupTitle(), ilLMObject::_lookupType(), ilLPObjSettings::_lookupVisits(), ilPaymentPrices::_priceExists(), SurveyQuestion::_questionExists(), ASS_Question::_questionExists(), ilObjCourse::_registrationEnabled(), SurveyQuestion::_resolveIntLinks(), ilMapArea::_resolveIntLinks(), ASS_Question::_resolveIntLinks(), ilMediaItem::_resolveMapAreaLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), ilObjUser::_search(), ilObjRole::_search(), ilObjGroup::_search(), ilCourseMembers::_setPassed(), ASS_TextQuestion::_setReachedPoints(), ilLearningProgress::_tracProgress(), ilOnlineTracking::_updateAccess(), ilCourseLMHistory::_updateLastAccess(), ilObjForum::_updateOldAccess(), ilLearningProgress::_updateProgress(), ilCourseObjectiveResult::_updateUserResult(), ilObject::_writeDescription(), ilLMObject::_writeTitle(), ilLPCollections::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(), ilRoleDesktopItem::add(), ilChatRoom::add(), ilObjSurvey::addConstraint(), ilCourseObjectiveResult::addEntry(), ilAddressbook::addEntry(), ilMailbox::addFolder(), ilLinkCheckNotify::addNotifier(), SurveyOrdinalQuestion::addPhrase(), ilForum::addPostTree(), ilObjTest::addSelectedUser(), ilCourseMembers::addSubscriber(), ilCourseWaitingList::addToList(), ilObjDlBook::addTranslation(), ilFileDataMail::assignAttachmentsToDirectory(), ilExerciseMembers::assignMember(), ilSearchFolder::assignResult(), ilChatBlockedUsers::block(), ilObjUserFolder::buildExportFile(), ASS_TextQuestion::calculateReachedPoints(), ASS_OrderingQuestion::calculateReachedPoints(), ASS_MultipleChoice::calculateReachedPoints(), ASS_MatchingQuestion::calculateReachedPoints(), ASS_JavaApplet::calculateReachedPoints(), ASS_ImagemapQuestion::calculateReachedPoints(), ASS_ClozeTest::calculateReachedPoints(), ilCronCheckUserAccounts::check(), ilAddressbook::checkEntry(), ilCourseObjectiveLM::checkExists(), ilConditionHandler::checkExists(), ilLinkChecker::checkLinks(), ilGeneralSettings::clearAll(), ilObjTest::clearEvalSelectedUsers(), ilObjTest::cloneRandomQuestions(), ilElementList::countDbByQuery(), ilObjCourseGrouping::create(), ilMediaItem::create(), ilLMObject::create(), ilSearchFolder::create(), ilObject::create(), ilCourseItems::createDefaultEntry(), ilMailbox::createDefaultFolder(), ilPageObject::createFromXML(), ilMailOptions::createMailOptionsEntry(), ilObjSurvey::createQuestionblock(), ASS_OrderingQuestion::createRandomSolution(), ASS_MultipleChoice::createRandomSolution(), ASS_MatchingQuestion::createRandomSolution(), ilObjTest::createRandomSolutionsForAllUsers(), ilObjForum::createSettings(), ilObjSurvey::createSurveyCodes(), ilObjUserFolder::createXMLExport(), ilFileDataMail::deassignAttachmentFromDirectory(), ilExerciseMembers::deassignMember(), SurveyQuestion::delete(), ilLPCollections::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(), ilPaymentVendors::delete(), ilPaymentTrustees::delete(), ilPaymentShoppingCart::delete(), ilPaymentPrices::delete(), ilPaymentObject::delete(), ilPaymentBookings::delete(), ilPaymentBillVendor::delete(), ilLinkResourceItems::delete(), ilObjCourseGrouping::delete(), ilCourseStart::delete(), ilCourseObjectiveQuestion::delete(), ilCourseObjectiveLM::delete(), ilCourseObjective::delete(), ilCourseMembers::delete(), ilCourseArchives::delete(), ilPageObject::delete(), ilLMObject::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(), ASS_Question::delete(), ilObjTest::deleteActiveTests(), ilMD::deleteAll(), ilPaymentTrustees::deleteAll(), ilCourseObjectiveQuestion::deleteAll(), ilCourseObjectiveLM::deleteAll(), ilRoleDesktopItem::deleteAll(), ilObjSurveyQuestionPool::deleteAllData(), ilCourseMembers::deleteAllEntries(), ilCourseItems::deleteAllEntries(), ilMediaItem::deleteAllItemsOfMob(), ilChatRoom::deleteAllMessages(), ilPaymentPrices::deleteAllPrices(), ilObjSurvey::deleteAllUserData(), 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(), ILIAS::deleteSetting(), ilCourseMembers::deleteSubscriber(), ASS_Question::deleteSuggestedSolutions(), ilObjSurvey::deleteSurveyRecord(), ilObjTest::deleteTest(), ilObjDlBook::deleteTranslation(), ilTree::deleteTree(), 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(), ilObjLanguage::flush(), ilLanguage::flushLanguages(), ilMailbox::folderNameExists(), ilObjTest::get_qpl_titles(), ilObjTest::getActiveTestUser(), ilChatRoom::getActiveUsers(), ilCourseMembers::getAdmins(), ilRoleDesktopItem::getAll(), ilExerciseMembers::getAllDeliveredFiles(), ilLinkResourceItems::getAllItems(), ilChatRoom::getAllMessages(), ilObjQuestionPool::getAllQuestionIds(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilChatRoom::getAllRoomsOfObject(), ILIAS::getAllSettings(), ilObjSurvey::getAnonymousId(), ilObjTest::getArrayData(), ilFileDataMail::getAttachmentPath(), ilLanguage::getAvailableLanguages(), SurveyOrdinalQuestion::getAvailablePhrases(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), ilPaymentBookings::getBooking(), ilPaymentBookings::getBookingsOfCustomer(), SurveyOrdinalQuestion::getCategoriesForPhrase(), ilObjSurvey::getConstraints(), ilChatRoom::getCountActiveUser(), ilObjForum::getCountNew(), ilCourseMembers::getCountPassed(), ilElement::getDbDataByQuery(), ilElement::getDbValueByQuery(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilMailbox::getDraftsFolder(), ilAddressbook::getEntries(), ilPaymentShoppingCart::getEntry(), ilAddressbook::getEntry(), ilObjSurvey::getEvaluation(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationUsers(), ilObjSurvey::getExistingQuestions(), ilObjTest::getExistingQuestions(), ilObjGroup::getExpirationTimestamp(), ilObjUserFolder::getExportSettings(), ilForumExport::getFirstPostNode(), ilForum::getFirstPostNode(), ilMailbox::getFolderData(), ilObjSurvey::getForbiddenQuestionpools(), ilObjTest::getGroupData(), ilMailbox::getInboxFolder(), ilLanguage::getInstalledLanguages(), ilLanguage::getInstalledLocalLanguages(), ilLMObjectFactory::getInstance(), ilSearchItemFactory::getInstance(), 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::getQplQuestions(), ilObjSurvey::getQuestionblock(), ilObjSurvey::getQuestionblockQuestionIds(), ilObjSurvey::getQuestionblockQuestions(), ilObjSurvey::getQuestionblocks(), ilObjSurvey::getQuestionblocksTable(), ilObjSurvey::getQuestionblockTitles(), ilObjTest::getQuestionDataset(), ilObjQuestionPool::getQuestionDetails(), 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(), ASS_Question::getQuestionTypeFromDb(), ilObjSurvey::getQuestiontypes(), ilObjTest::getRandomQuestionpools(), ASS_TextQuestion::getReachedInformation(), ASS_OrderingQuestion::getReachedInformation(), ASS_MultipleChoice::getReachedInformation(), ASS_MatchingQuestion::getReachedInformation(), ASS_JavaApplet::getReachedInformation(), ASS_ImagemapQuestion::getReachedInformation(), ASS_ClozeTest::getReachedInformation(), ASS_Question::getReachedPoints(), ilChatRecording::getRecord(), ilChatRecord::getRecord(), ilChatRecording::getRecordings(), ilObjTest::getRoleData(), ilRbacReview::getRoleOperationsOnObject(), ilChatRoom::getRooms(), ilChatRoom::getRoomsOfObject(), ilMail::getSavedData(), ilMailbox::getSentFolder(), ILIAS::getSetting(), ASS_Question::getSolutionValues(), ilObjTest::getStartingTimeOfUser(), ilObjUser::getStoredActive(), ilMailbox::getSubFolders(), ilObjSurvey::getSurveyCodes(), ilObjSurvey::getSurveyCodesCount(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyQuestions(), ilDBUpdate::getTables(), ilDBUpdate::getTableStatus(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilCourseObjectiveQuestion::getTests(), ilObjTest::getTextAnswer(), ilForum::getThreadList(), ilObjSCORMLearningModule::getTrackedItems(), ilObjAICCLearningModule::getTrackedItems(), ilObjAICCLearningModule::getTrackingData(), ilObjSCORMLearningModule::getTrackingDataAgg(), ilObjSCORMLearningModule::getTrackingDataPerUser(), ilMailbox::getTrashFolder(), ilCourseMembers::getTutors(), ilObjQuestionPool::getUsedQuestionDetails(), ilForumExport::getUserData(), ilForum::getUserData(), ilObjTest::getUserData(), ilObjUser::getUserIdByEmail(), ilObjUser::getUserIdByLogin(), ilObjSurvey::getVariables(), ilObjTest::getWorkedQuestions(), ilMailbox::hasNewMail(), ilExerciseMembers::hasReturned(), ilObjForum::ilClone(), ilExerciseMembers::ilClone(), ilMDConvert(), ilNestedSetXML::init(), ilObjCourse::initDefaultRoles(), ilLPObjSettings::insert(), ilObjLanguage::insert(), ASS_Question::insertIntoTest(), ilLanguage::insertLanguage(), ilForum::insertPostNode(), ilObjSurvey::insertQuestion(), ilObjTest::insertQuestion(), ilObjSurvey::insertQuestionblock(), ilLanguage::installLanguages(), ilChatRoom::invite(), ilObjSurvey::inviteUser(), ilObjTest::inviteUser(), ilObjTest::isActiveTestSubmitted(), ilObjSurvey::isAnonymizedParticipant(), ilObjSurvey::isAnonymousKey(), ilRoleDesktopItem::isAssigned(), ilRepositoryExplorer::isClickable(), ASS_Question::isClone(), ilPaymentShoppingCart::isInShoppingCart(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), ASS_Question::isInUse(), ilChatRoom::isInvited(), ilChatRoom::isKicked(), ilObjForum::isNew(), ilObjForum::isRead(), ilChatRecording::isRecording(), ilChatRecord::isRecording(), ilCourseMembers::isSubscriber(), ilObjSurvey::isSurveyCodeUsed(), ilObjSurvey::isSurveyStarted(), ilSCORMPresentationGUI::launchSahs(), ilHACPPresentationGUI::launchSahs(), ilAICCPresentationGUI::launchSahs(), SurveyTextQuestion::loadFromDb(), SurveyQuestion::loadFromDb(), SurveyOrdinalQuestion::loadFromDb(), SurveyNominalQuestion::loadFromDb(), SurveyMetricQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjSurvey::loadFromDb(), ilObjTest::loadFromDb(), ilObjQuestionPool::loadFromDb(), ASS_TextQuestion::loadFromDb(), ASS_Question::loadFromDb(), ASS_OrderingQuestion::loadFromDb(), ASS_MultipleChoice::loadFromDb(), ASS_MatchingQuestion::loadFromDb(), ASS_MarkSchema::loadFromDb(), ASS_JavaApplet::loadFromDb(), ASS_ImagemapQuestion::loadFromDb(), ASS_ClozeTest::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(), ilObjectFactory::ObjectIdExists(), ilLMPresentationGUI::offlineexport(), ilObjLanguage::optimizeData(), ilDBUpdate::optimizeTables(), ilObjQuestionPool::pasteFromClipboard(), ilWebresourceSearch::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(), ilObjTestGUI::questionsObject(), ilObjQuestionPoolGUI::questionsObject(), SurveyQuestion::questionTitleExists(), ASS_Question::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(), ilObjTest::removeAllTestEditings(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilCourseWaitingList::removeFromList(), ilObjLanguageFolder::removeLanguages(), ilObjTest::removeNonRandomTestData(), ilObjSurvey::removeQuestions(), ilObjTestGUI::removeQuestionsForm(), ilObjTest::removeRandomTestData(), ilObjTest::removeSelectedTestResults(), ilObjTest::removeSelectedUser(), ilChatRoom::rename(), ilMailbox::renameFolder(), ilObjLanguage::resetUserLanguage(), ilObjTest::retrieveTestTypes(), 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(), ASS_TextQuestion::saveToDb(), ASS_Question::saveToDb(), ASS_OrderingQuestion::saveToDb(), ASS_MultipleChoice::saveToDb(), ASS_MatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), ASS_JavaApplet::saveToDb(), ASS_ImagemapQuestion::saveToDb(), ASS_ClozeTest::saveToDb(), ilObjSurvey::saveWorkingData(), ASS_TextQuestion::saveWorkingData(), ASS_Question::saveWorkingData(), ASS_OrderingQuestion::saveWorkingData(), ASS_MultipleChoice::saveWorkingData(), ASS_MatchingQuestion::saveWorkingData(), ASS_ImagemapQuestion::saveWorkingData(), ASS_ClozeTest::saveWorkingData(), SurveySearch::search(), ilObjUser::searchUsers(), ilAddressbook::searchUsers(), ilElementList::selectDbAllByQuery(), ilMail::sendInternalMail(), ilCourseMembers::sendNotificationToAdmins(), ilCourseMembers::sendSubscriptionRequestToAdmins(), ilCourseMembers::sendUnsubscribeNotificationToAdmins(), Session::Session(), ilObjTest::setActiveTestSubmitted(), ilObjTest::setActiveTestUser(), ilGeneralSettings::setAll(), ilObjTest::setClientIP(), ilObjSurvey::setInvitation(), ilObjSurvey::setInvitationAndMode(), ilObjSurvey::setInvitationMode(), ilChatRoom::setKicked(), ilDBx::setMaxAllowedPacket(), ilExerciseMembers::setNoticeForMember(), ilObjSurvey::setObligatoryStates(), ilObjTest::setQuestionSetSolved(), ASS_TextQuestion::setReachedPoints(), ilExerciseMembers::setStatusReturnedForMember(), ilExerciseMembers::setStatusSentForMember(), ilExerciseMembers::setStatusSolvedForMember(), ilNestedSetXML::setTagName(), ilNestedSetXML::setTagValue(), ilChatRoom::setUnkicked(), ilChatRecording::startRecording(), ilChatRecord::startRecording(), ilObjSurvey::startSurvey(), ilChatRecording::stopRecording(), ilChatRecord::stopRecording(), ilConditionHandler::storeCondition(), SurveyTextQuestion::syncWithOriginal(), SurveyQuestion::syncWithOriginal(), SurveyOrdinalQuestion::syncWithOriginal(), SurveyNominalQuestion::syncWithOriginal(), SurveyMetricQuestion::syncWithOriginal(), ASS_TextQuestion::syncWithOriginal(), ASS_Question::syncWithOriginal(), ASS_OrderingQuestion::syncWithOriginal(), ASS_MultipleChoice::syncWithOriginal(), ASS_MatchingQuestion::syncWithOriginal(), ASS_JavaApplet::syncWithOriginal(), ASS_ImagemapQuestion::syncWithOriginal(), ASS_ClozeTest::syncWithOriginal(), ilObjTest::testTitleExists(), ASS_OrderingQuestion::to_xml(), 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(), ilObjCourseGrouping::update(), ilCourseObjective::update(), ilCourseMembers::update(), ilCourseItems::update(), ilPageObject::update(), ilMediaItem::update(), ilLMObject::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(), ilCourseWaitingList::updateSubscriptionTime(), ilCourseMembers::updateSubscriptionTime(), ilCourseObjectiveQuestion::updateTest(), ilUserResult::updateTitle(), ilSearchResult::updateTitle(), ilSearchFolder::updateTitle(), ilLinkResourceItems::updateValid(), ilLinkResourceItems::updateValidByCheck(), ilConditionHandler::validate(), ilObjNote::viewObject(), and ASS_MultipleChoice::wasAnsweredByUser().
| 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(), and ilObjTest::removeSelectedTestResults().
| $query3 = "' AND type = 'crs'" |
Definition at line 612 of file dbupdate.php.
Referenced by ilForum::deletePost(), ilObjTest::removeAllTestEditings(), and ilObjTest::removeSelectedTestResults().
| $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.
| $rbacreview = new ilRbacReview() |
Definition at line 1192 of file dbupdate.php.
| while ($row=$res->fetchRow(DB_FETCHMODE_OBJECT)) $rbacsystem = & new ilRbacSystem() |
Definition at line 2117 of file dbupdate.php.
| $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(), ilObjExerciseGUI::__getMembersOfObject(), ilGeneralSettings::__getSettings(), ilLearningProgressBaseGUI::__getStatusInfo(), ilBookmarkImportExport::__parseExport(), ilBookmarkImportExport::__parseNetscape(), ilSearchGUI::__performDetailsSearch(), ilPurchaseBMFGUI::__sendBill(), ilObjAssessmentFolder::_addLog(), ilObjSurvey::_addQuestionblock(), ilObjTestAccess::_checkCondition(), ilObjSurvey::_clone(), Spreadsheet_Excel_Writer_Parser::_condition(), Spreadsheet_Excel_Writer_Parser::_expression(), Spreadsheet_Excel_Writer_Parser::_fact(), Spreadsheet_Excel_Writer_Parser::_func(), ilObjTest::_getActiveTestUser(), ilObjTest::_getArrayData(), ilObjQuestionPool::_getAvailableQuestionpools(), ilObjSurvey::_getAvailableSurveys(), ilObjTest::_getAvailableTests(), ilObjTest::_getBestPass(), ilLPStatusTestPassed::_getCompleted(), ilObjSurvey::_getConstraints(), ilObjTest::_getCountSystem(), ilBMFWSDL::_getDeepestArrayType(), ilObjSurvey::_getGlobalSurveyData(), ilObjTest::_getHidePreviousResults(), ilObjTest::_getHideTitlePoints(), SurveyTextQuestion::_getMaxChars(), ASS_Question::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilObjTest::_getObjectIDFromTestID(), SurveyQuestion::_getOriginalId(), ASS_Question::_getOriginalId(), ilObjTest::_getPass(), ilObjTestAccess::_getPassedUsers(), ilObjTest::_getPassedUsers(), ilObjTest::_getPassScoring(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjTest::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), ASS_Question::_getQuestionInfo(), ASS_Question::_getQuestionTitle(), SurveyQuestion::_getQuestionType(), ASS_Question::_getQuestionType(), ASS_Question::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilObjTest::_getResultPass(), ASS_Question::_getSolutionMaxPass(), ASS_Question::_getSuggestedSolution(), ASS_Question::_getSuggestedSolutionCount(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestResult(), ilObjTest::_getTestType(), ASS_Question::_getTitle(), ASS_Question::_getTotalAnswers(), ASS_Question::_getTotalRightAnswers(), ilObjSurvey::_hasDatasets(), ilObjQuestionPool::_hasEqualPoints(), ilObjSurveyAccess::_hasEvaluationAccess(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilObjSurveyAccess::_isSurveyParticipant(), ASS_Question::_isUsedInRandomTest(), ASS_Question::_isWorkedThrough(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), ASS_Question::_isWriteable(), ilObjSurveyAccess::_lookupAnonymize(), 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(), ASS_Question::_questionExists(), SurveyQuestion::_resolveIntLinks(), ASS_Question::_resolveIntLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), ASS_TextQuestion::_setReachedPoints(), ilBMFTransport_TCP::_socket_ping(), Spreadsheet_Excel_Writer_Parser::_term(), LastschriftWS::abbuchenOhneEinzugsermaechtigung(), SurveyQuestionGUI::addCategory(), ilObjSurvey::addConstraint(), Database::addDate(), Database::addKeyword(), ASS_MatchingQuestionGUI::addPair(), SurveyOrdinalQuestion::addPhrase(), ilObjTest::addSelectedUser(), Database::addStartEnd(), ASS_JavaAppletGUI::addSuggestedSolution(), ilObjDlBookGUI::addTranslation(), KundenstammdatenPflegeWS::anlegenKunde(), Database::applyChangedDate(), ilObjUserFolder::buildExportFile(), ASS_TextQuestion::calculateReachedPoints(), ASS_OrderingQuestion::calculateReachedPoints(), ASS_MultipleChoice::calculateReachedPoints(), ASS_MatchingQuestion::calculateReachedPoints(), ASS_JavaApplet::calculateReachedPoints(), ASS_ImagemapQuestion::calculateReachedPoints(), ASS_ClozeTest::calculateReachedPoints(), ilObjTest::canShowTestResults(), ilObjSurvey::canStartSurvey(), ilObjTest::canViewResults(), ilRbacSystem::checkAccess(), ASS_OrderingQuestion::checkSaveData(), ASS_MatchingQuestion::checkSaveData(), Database::cleanDatabase(), ilObjTest::clearEvalSelectedUsers(), ilObjTest::cloneRandomQuestions(), ilQTIItem::collectResponses(), ilUserTracking::countNum(), ilTracking::countNum(), ilObjUserTrackingGUI::countNum(), ilUserTracking::countResults(), ilTracking::countResults(), ilObjUserTracking::countResults(), ilObjSysUserTracking::countResults(), ASS_ClozeTest::createCloseTextArray(), ilObjUserFolder::createExcelExport(), ilObjSurvey::createQuestionblock(), ASS_OrderingQuestion::createRandomSolution(), ASS_MultipleChoice::createRandomSolution(), ASS_MatchingQuestion::createRandomSolution(), ilObjSurvey::createReference(), ilObjTest::createReference(), ilObjQuestionPool::createReference(), ilObjSurvey::createSurveyCodes(), Database::delDate(), SurveyQuestion::delete(), ASS_Question::delete(), ilObjTest::deleteActiveTests(), ilObjSurveyQuestionPool::deleteAllData(), ilObjSurvey::deleteAllUserData(), ilObjSurvey::deleteConstraints(), ilExerciseMembers::deleteDeliveredFiles(), ilObjSurveyQuestionPool::deletePhrases(), ilForum::deletePostTree(), ilObjTest::deleteResults(), ASS_Question::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(), ilTestEvaluationGUI::evalSelectedUsers(), ilObjTest::evalStatistical(), ilObjTest::evalTotalFinished(), ilObjTest::evalTotalFinishedAverageTime(), ilObjTest::evalTotalFinishedPassed(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalPersons(), ilObjTest::evalTotalPersonsArray(), ilObjTest::evalTotalStartedAverageTime(), ilSurveyEvaluationGUI::evaluation(), ilSurveyEvaluationGUI::evaluationuser(), ilObjDlBook::export(), ilNestedSetXML::export(), ilLMPresentationGUI::exportbibinfo(), ilObjGroupGUI::exportMembersObject(), 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(), ASS_ClozeTest::get_gap_text_list(), ilObjTest::get_qpl_titles(), ilObjTest::getActiveTestUser(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilObjSurvey::getAnonymousId(), SurveyOrdinalQuestion::getAvailablePhrases(), ilObjTest::getAvailableQuestionpoolIDs(), ilObjSurvey::getAvailableQuestionpools(), ilObjTest::getAvailableQuestionpools(), SurveyOrdinalQuestion::getCategoriesForPhrase(), Database::getChangedDates(), ilObjTest::getCompleteWorkingTime(), ilObjSurvey::getConstraints(), Database::getDate(), getDateList(), Database::getDates(), ilElement::getDbData(), ilElement::getDbDataByQuery(), ilElement::getDbValueByQuery(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilObjTest::getEstimatedWorkingTime(), ilObjSurvey::getEvaluation(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationUsers(), ilObjSurvey::getExistingQuestions(), ilObjTest::getExistingQuestions(), ilObjUserFolder::getExportSettings(), ilObjTest::getFirstSequence(), ilObjSurvey::getForbiddenQuestionpools(), Database::getFullDayDates(), Database::getFullDayRotationDates(), Database::getGroupDates(), getGroupDatesForDisplay(), Database::getGroupRotationDates(), ilObjSurvey::getInvitedGroups(), ilObjSurvey::getInvitedUsers(), Database::getKeywords(), ilObjSurvey::getLastActivePage(), ilForum::getLastPost(), ilObjUser::getLastVisitedLessons(), ilObjUser::getLessons(), 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(), ilObjSurvey::getQuestionpoolTitles(), ilObjSurveyQuestionPool::getQuestions(), ilObjSurvey::getQuestions(), ilObjSurveyQuestionPool::getQuestionsInfo(), ilObjTest::getQuestionsTable(), ilObjTest::getQuestiontext(), ilObjTest::getQuestionTitles(), ilObjSurveyQuestionPool::getQuestiontype(), ilObjSurvey::getQuestionType(), ilObjTest::getQuestionType(), ilObjQuestionPool::getQuestiontype(), ASS_Question::getQuestionTypeFromDb(), ilObjSurvey::getQuestiontypes(), ilObjTest::getRandomQuestionpools(), ASS_TextQuestion::getReachedInformation(), ASS_OrderingQuestion::getReachedInformation(), ASS_MultipleChoice::getReachedInformation(), ASS_MatchingQuestion::getReachedInformation(), ASS_JavaApplet::getReachedInformation(), ASS_ImagemapQuestion::getReachedInformation(), ASS_ClozeTest::getReachedInformation(), ASS_Question::getReachedPoints(), Database::getRotationDates(), ASS_Question::getSolutionCommentCountSystem(), ASS_Question::getSolutionCommentMCScoring(), ASS_Question::getSolutionValues(), Database::getStartEnd(), ilObjTest::getStartingTimeOfUser(), ilUserTracking::getSubId(), ilTracking::getSubId(), ilUserTracking::getSubTest(), ilTracking::getSubTest(), ilObjSurvey::getSurveyCodes(), ilObjSurvey::getSurveyCodesCount(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyQuestions(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilUserTracking::getTest(), ilTracking::getTest(), ilUserTracking::getTestId(), ilTracking::getTestId(), ilObjUserTracking::getTestId(), ilObjSysUserTracking::getTestId(), ilObjTest::getTextAnswer(), ASS_ClozeTest::getTextgapPoints(), ilPaymentShoppingCart::getTotalAmountValue(), ilObjQuestionPool::getUsedQuestionDetails(), ilObjSurvey::getVariables(), getWholeDayDateList(), ilObjTest::getWorkedQuestions(), ilObjTest::getWrongAnsweredQuestions(), ilNestedSetXML::getXpathNodes(), ilExerciseMembers::hasReturned(), ilPaymentExcelWriterAdapter::ilPaymentExcelWriterAdapter(), ilObjSurvey::importObject(), ilObjTestGUI::importVerifiedFileObject(), ilObjQuestionPoolGUI::importVerifiedFileObject(), ilNestedSetXML::init(), SurveyQuestionGUI::insertAfterCategory(), SurveyQuestionGUI::insertBeforeCategory(), ilElement::insertDb(), ASS_Question::insertIntoTest(), ilObjSurvey::insertQuestion(), ilObjTest::insertQuestion(), ilObjSurvey::insertQuestionblock(), ilObjSurvey::inviteUser(), ilObjTest::inviteUser(), ilObjTest::isActiveTestSubmitted(), ilObjSurvey::isAnonymizedParticipant(), ilObjSurvey::isAnonymousKey(), ASS_Question::isClone(), ilObjTest::isExecutable(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), ASS_Question::isInUse(), ilObjSurvey::isSurveyCodeUsed(), ilObjSurvey::isSurveyStarted(), ilLMPresentationGUI::layout(), SurveyTextQuestion::loadFromDb(), SurveyQuestion::loadFromDb(), SurveyOrdinalQuestion::loadFromDb(), SurveyNominalQuestion::loadFromDb(), SurveyMetricQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjSurvey::loadFromDb(), ilObjTest::loadFromDb(), ilObjQuestionPool::loadFromDb(), ASS_TextQuestion::loadFromDb(), ASS_Question::loadFromDb(), ASS_OrderingQuestion::loadFromDb(), ASS_MultipleChoice::loadFromDb(), ASS_MatchingQuestion::loadFromDb(), ASS_MarkSchema::loadFromDb(), ASS_JavaApplet::loadFromDb(), ASS_ImagemapQuestion::loadFromDb(), ASS_ClozeTest::loadFromDb(), SurveyQuestion::loadMaterialFromDb(), ilObjTest::loadQuestions(), ilObjSurvey::loadQuestionsFromDb(), ilObjSurvey::loadWorkingData(), ilObjSurvey::modifyQuestionblock(), ilObjExerciseGUI::newMembersObject(), ilLMPresentationGUI::offlineexport(), ilObjQuestionPool::pasteFromClipboard(), ilLuceneHTLMSearch::performSearch(), ilLuceneFileSearch::performSearch(), ilPaymentTrusteeGUI::performSearch(), ilSearchGUI::performSearch(), SurveyQuestion::phraseExists(), ilElement::queryDb(), ilObjTest::questionMoveDown(), ilObjTest::questionMoveUp(), SurveyQuestion::questionTitleExists(), ASS_Question::questionTitleExists(), ilObjTest::randomSelectQuestions(), ilTestOutputGUI::readFullSequence(), ilObjTest::removeAllTestEditings(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilObjTest::removeNonRandomTestData(), ilObjSurvey::removeQuestions(), ilObjTest::removeRandomTestData(), ilObjTest::removeSelectedTestResults(), ilObjTest::removeSelectedUser(), ilTemplate::replaceFromDatabase(), ilObjTest::retrieveTestTypes(), SurveyQuestionGUI::save(), ASS_QuestionGUI::save(), SurveyQuestion::saveCategoriesToDb(), SurveyQuestion::saveCategoryToDb(), ilObjTest::saveCompleteStatus(), SurveyQuestion::saveCompletionStatus(), ilObjSurvey::saveCompletionStatus(), ilObjTest::saveECTSStatus(), ASS_QuestionGUI::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(), ASS_TextQuestion::saveToDb(), ASS_Question::saveToDb(), ASS_OrderingQuestion::saveToDb(), ASS_MultipleChoice::saveToDb(), ASS_MatchingQuestion::saveToDb(), ASS_MarkSchema::saveToDb(), ASS_JavaApplet::saveToDb(), ASS_ImagemapQuestion::saveToDb(), ASS_ClozeTest::saveToDb(), ilObjSurvey::saveWorkingData(), ASS_TextQuestion::saveWorkingData(), ASS_Question::saveWorkingData(), ASS_OrderingQuestion::saveWorkingData(), ASS_MultipleChoice::saveWorkingData(), ASS_MatchingQuestion::saveWorkingData(), ASS_ImagemapQuestion::saveWorkingData(), ASS_ClozeTest::saveWorkingData(), SurveySearch::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(), ASS_OrderingQuestion::set_image_file(), ASS_MatchingQuestion::set_image_file(), ilObjSurvey::setInvitation(), ilObjSurvey::setInvitationAndMode(), ilObjSurvey::setInvitationMode(), ilObjSurvey::setObligatoryStates(), ASS_TextQuestion::setReachedPoints(), ilObjSurvey::setStatus(), ilNestedSetXML::setTagName(), ilNestedSetXML::setTagValue(), ilObjSurvey::startSurvey(), ilObjTest::startWorkingTime(), SurveyTextQuestion::syncWithOriginal(), SurveyQuestion::syncWithOriginal(), SurveyOrdinalQuestion::syncWithOriginal(), SurveyNominalQuestion::syncWithOriginal(), SurveyMetricQuestion::syncWithOriginal(), ASS_TextQuestion::syncWithOriginal(), ASS_Question::syncWithOriginal(), ASS_OrderingQuestion::syncWithOriginal(), ASS_MultipleChoice::syncWithOriginal(), ASS_MatchingQuestion::syncWithOriginal(), ASS_JavaApplet::syncWithOriginal(), ASS_ImagemapQuestion::syncWithOriginal(), ASS_ClozeTest::syncWithOriginal(), ilUserTracking::TestTitle(), ilTracking::TestTitle(), ilObjTest::testTitleExists(), ilObjSurvey::unfoldQuestionblocks(), Database::updateDate(), ilElement::updateDb(), Database::updateKeyword2Date(), ilObjTest::updateWorkingTime(), ASS_JavaAppletGUI::uploadingJavaApplet(), ilObjQuestionPoolGUI::uploadQplObject(), ilObjTestGUI::uploadTstObject(), userSettingEnabled(), ilPersonalProfileGUI::userSettingEnabled(), userSettingVisible(), ilPersonalProfileGUI::userSettingVisible(), ilValidatorAdapter::validate(), ilStatistics::validate(), KreditkartenzahlungWS::validierenKreditkarte(), ASS_MultipleChoice::wasAnsweredByUser(), workWithUserSetting(), ilPersonalProfileGUI::workWithUserSetting(), ilIniFile::write(), SurveyTextQuestionGUI::writePostData(), SurveyOrdinalQuestionGUI::writePostData(), SurveyNominalQuestionGUI::writePostData(), SurveyMetricQuestionGUI::writePostData(), ASS_TextQuestionGUI::writePostData(), ASS_OrderingQuestionGUI::writePostData(), ASS_MultipleChoiceGUI::writePostData(), ASS_MatchingQuestionGUI::writePostData(), ASS_JavaAppletGUI::writePostData(), ASS_ImagemapQuestionGUI::writePostData(), ASS_ClozeTestGUI::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 ilPermissionGUI::__filterRoles(), ilObjectGUI::__filterRoles(), ilObjCourse::__getDefaultCourseRoles(), ilRbacReview::__setProtectedStatus(), 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(), ilMail::getUserIds(), ilSoapRBACAdministration::getUserRoles(), grantPermissions(), ilSoapRBACAdministration::grantPermissions(), ilUserImportParser::importEndTag(), ilObjUserFolderGUI::importUserRoleAssignmentObject(), ilObjUserFolderGUI::importUsersObject(), ilObjSurvey::inviteRole(), ilObjTest::inviteRole(), ilObjSurveyGUI::inviteUserGroupObject(), 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 ilCronClients::__checkDBVersion(), ilTree::__checkDelete(), ilCron::__checkUserAccounts(), ilCourseObjective::__cleanStructure(), ilCourseItems::__delete(), ilChatRoom::__deleteFirstLine(), ilLinkChecker::__fetchUserData(), ilRbacReview::__getAllRoleFolderIds(), ilChatRoom::__getCountLines(), ilObjForum::__getCountNew(), ilLPStatusManual::__getCourseInProgress(), ilObjCourse::__getCrsNonMemberTemplateId(), ilCourseItems::__getItemData(), ilCourseObjective::__getLastPosition(), ilCourseItems::__getLastPosition(), ilObjForum::__getLastThreadAccess(), ilLPStatusManual::__getLMInProgress(), ilLinkChecker::__getObjIdByPageId(), ilRbacReview::__getParentRoles(), ilObjRole::__getPermissionDefinitions(), ilCourseObjectiveResult::__getReachedPoints(), ilTree::__getSubTreeByParentRelation(), ilLinkChecker::__getTitle(), ilLuceneIndexer::__indexFiles(), ilLuceneIndexer::__indexHTLMs(), ilUserResult::__init(), ilSearchResult::__init(), ilSearchFolder::__init(), ilCourseObjectiveResult::__isAnswered(), ilAbstractSearch::__prepareFound(), ilCourseItems::__purgeDeleted(), ilLPObjSettings::__read(), ilLPMarks::__read(), ilLPFilter::__read(), ilLPCollections::__read(), ilPaymentVendors::__read(), ilPaymentTrustees::__read(), ilPaymentShoppingCart::__read(), ilPaymentPrices::__read(), ilPaymentObject::__read(), ilPaymentBookings::__read(), ilPaymentBillVendor::__read(), ilCourseWaitingList::__read(), ilCourseStart::__read(), ilCourseObjectiveQuestion::__read(), ilCourseObjectiveLM::__read(), ilCourseObjective::__read(), ilCourseMembers::__read(), ilCourseArchives::__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(), ilObjExerciseGUI::__showMembersTableContent(), ilLearningProgressBaseGUI::__sort(), ilObjectDataCache::__storeObjectData(), ilObjectDataCache::__storeReference(), ilLinkChecker::__txt(), ilCourseItems::__updateBottom(), ilCourseItems::__updateTop(), Spreadsheet_Excel_Writer_Parser::_cellToPackedRowcol(), Spreadsheet_Excel_Writer_Worksheet::_cellToRowcol(), Spreadsheet_Excel_Writer_Parser::_cellToRowcol(), ilLPObjSettings::_checkObjectives(), Spreadsheet_Excel_Writer_Worksheet::_checkRowCol(), ilObjSurvey::_clone(), Spreadsheet_Excel_Writer_Parser::_convertRef2d(), Spreadsheet_Excel_Writer_Parser::_convertRef3d(), ilHistory::_copyEntriesForObject(), ilPaymentPrices::_countPrices(), ilNestedSetXML::_deleteAllChildMetaData(), ilPaymentObject::_getActivation(), ilPaymentBookings::_getActivation(), 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(), 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(), 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(), ilObjSCORMTracking::_getInProgress(), ilLPCollections::_getItems(), ilSCORMItem::_getItems(), SurveyTextQuestion::_getMaxChars(), ASS_Question::_getMaximumPoints(), ilObjTest::_getMCScoring(), ilCourseMembers::_getMembers(), ilLinkCheckNotify::_getNotifiers(), ilObjTest::_getObjectIDFromTestID(), ilCourseObjective::_getObjectiveIds(), ilUtil::_getObjectsByOperations(), ilPaymentObject::_getObjectsData(), ilOnlineTracking::_getOnlineTime(), ilRbacReview::_getOperationIdsByName(), SurveyQuestion::_getOriginalId(), ASS_Question::_getOriginalId(), ilParameterAppender::_getParams(), ilObjTest::_getPass(), ilObjTestAccess::_getPassedUsers(), ilObjTest::_getPassedUsers(), ilObjTest::_getPassScoring(), ilPaymentPrices::_getPrice(), ilLearningProgress::_getProgress(), ilObjSurvey::_getQuestionblock(), ilObjTestAccess::_getQuestionCount(), ilObjQuestionPool::_getQuestionCount(), ilObjSurvey::_getQuestiontypes(), ilObjTest::_getQuestiontypes(), ASS_Question::_getReachedPoints(), SurveyQuestion::_getRefIdFromObjId(), ilObjSurvey::_getRefIdFromObjId(), ilObjTest::_getRefIdFromObjId(), ilSearchSettings::_getSearchSettingRefId(), ilRADIUSAuthentication::_getServers(), ASS_Question::_getSolutionMaxPass(), ilPaymentCurrency::_getSubUnit(), ASS_Question::_getSuggestedSolution(), ilCourseObjectiveQuestion::_getTest(), ilObjTestAccess::_getTestIDFromObjectID(), ilObjTest::_getTestIDFromObjectID(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestType(), ASS_Question::_getTitle(), ASS_Question::_getTotalAnswers(), ASS_Question::_getTotalRightAnswers(), ilObjAICCLearningModule::_getTrackingItems(), ilMDEducational::_getTypicalLearningTimeSeconds(), ilPaymentCurrency::_getUnit(), ilObjUser::_getUserIdsByEmail(), ilPaymentTrustees::_getVendorsForObjects(), ilPaymentObject::_hasAccess(), ilPaymentBookings::_hasAccess(), ilLPMarks::_hasCompleted(), ilObjQuestionPool::_hasEqualPoints(), ilObjSurveyAccess::_hasEvaluationAccess(), ilPaymentTrustees::_hasObjectPermission(), ilExerciseMembers::_hasSolved(), ilPaymentTrustees::_hasStatisticPermission(), ilChatServerCommunicator::_initObject(), ilObjiLincCourse::_isActivated(), ilObjCourse::_isActivated(), ilCourseItems::_isActivated(), ilChatRoom::_isActive(), ilCourseObjectiveQuestion::_isAssigned(), ilCourseMembers::_isBlocked(), ilPaymentObject::_isBuyable(), SurveyQuestion::_isComplete(), ilObjTestAccess::_isComplete(), ilLMObject::_isPagePublic(), ilCourseMembers::_isSubscriber(), SurveyQuestion::_isWriteable(), ilObjSurveyQuestionPool::_isWriteable(), ilObjQuestionPool::_isWriteable(), ASS_Question::_isWriteable(), ilObjSurveyAccess::_lookupAnonymize(), ilObjUser::_lookupClientIP(), ilLPMarks::_lookupComment(), ilObjSurveyAccess::_lookupCreationComplete(), ilObjTestAccess::_lookupCreationComplete(), ilObjUser::_lookupEmail(), ilObjSurveyAccess::_lookupEvaluationAccess(), ilObjFile::_lookupFileName(), ilObjFile::_lookupFileSize(), ilObjSurveyAccess::_lookupFinished(), ilObjGroup::_lookupIdByTitle(), ilLPMarks::_lookupMark(), ilLPObjSettings::_lookupMode(), _lookupObjId(), ilObject::_lookupObjIdByImportId(), ilObjSurveyQuestionPool::_lookupOnline(), ilObjSurveyAccess::_lookupOnline(), ilObjQuestionPool::_lookupOnline(), ilObjTestAccess::_lookupOnlineTestAccess(), ilPaymentObject::_lookupPobjectId(), ilSCORMItem::_lookupTitle(), ilObjFile::_lookupVersion(), ilLPObjSettings::_lookupVisits(), ilObjCourse::_registrationEnabled(), SurveyQuestion::_resolveIntLinks(), ASS_Question::_resolveIntLinks(), ilObjDlBook::_search(), ilObjContentObject::_search(), ilObjUser::_search(), ilObjRole::_search(), ilObjGroup::_search(), Spreadsheet_Excel_Writer_Worksheet::_sizeRow(), ilOnlineTracking::_updateAccess(), ilLMObject::_writePublicAccessStatus(), ilPaymentObject::add(), ilLocatorGUI::addAdministrationItems(), ilObjSurveyGUI::addConstraintForm(), ilObjContentObjectGUI::addLocations(), ilSoapObjectAdministration::addObject(), SurveyOrdinalQuestion::addPhrase(), ilSoapObjectAdministration::addReference(), ilLocatorGUI::addRepositoryItems(), ilDBUpdate::applyUpdateNr(), ilRbacReview::assignedRoles(), ilRbacReview::assignedUsers(), ilObjUserFolder::buildExportFile(), ilTestExport::buildExportResultFile(), ASS_TextQuestion::calculateReachedPoints(), ASS_OrderingQuestion::calculateReachedPoints(), ASS_MultipleChoice::calculateReachedPoints(), ASS_MatchingQuestion::calculateReachedPoints(), ASS_JavaApplet::calculateReachedPoints(), ASS_ImagemapQuestion::calculateReachedPoints(), ASS_ClozeTest::calculateReachedPoints(), ilCronCheckUserAccounts::check(), ilRbacSystem::checkAccessOfUser(), ilLinkChecker::checkLinks(), ilRbacSystem::checkPermission(), ilObjAICCCourseInterchangeFiles::checkStructure(), ilTree::checkTree(), ilTree::checkTreeChilds(), Database::cleanDatabase(), ilObjTest::cloneRandomQuestions(), ilObjSurveyGUI::codesObject2(), ilRbacAdmin::copyRolePermission(), ilRbacAdmin::copyRolePermissionIntersection(), ilObject::countReferences(), ilObjCourseGrouping::create(), ilMetaTechnical::create(), ilObjUserFolder::createCSVExport(), ilObjUserFolder::createExcelExport(), ASS_MultipleChoice::createRandomSolution(), ilObjUserFolder::createXMLExport(), ilFileDataMail::deassignAttachmentFromDirectory(), SurveyQuestion::delete(), ilCourseObjectiveQuestion::delete(), ASS_Question::delete(), ilObjSurveyQuestionPool::deleteAllData(), ilNestedSetXML::deleteAllDbData(), ilObjSurvey::deleteAllUserData(), 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::evalTotalFinishedAverageTime(), ilObjTest::evalTotalFinishedPassed(), ilObjTest::evalTotalPassedAverageTime(), ilObjTest::evalTotalPersons(), ilObjTest::evalTotalPersonsArray(), ilObjTest::evalTotalStartedAverageTime(), ilSurveyEvaluationGUI::evaluationuser(), ilObjDlBook::export(), ilNestedSetXML::export(), 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(), ilChatRoom::getActiveUsers(), ilCourseMembers::getAdmins(), ilRoleDesktopItem::getAll(), ilExerciseMembers::getAllDeliveredFiles(), ilLinkResourceItems::getAllItems(), ilChatRoom::getAllMessages(), ilObjQuestionPool::getAllQuestionIds(), ilObjTest::getAllQuestions(), ilObjQuestionPool::getAllQuestions(), ilObjSurvey::getAllRelations(), ilChatRoom::getAllRoomsOfObject(), ilClient::getAllSettings(), ILIAS::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(), ilPageObject::getBibliographyXML(), ilPaymentBookings::getBooking(), ilPaymentBookings::getBookingsOfCustomer(), SurveyOrdinalQuestion::getCategoriesForPhrase(), Database::getChangedDates(), ilSCORMTree::getChilds(), ilTree::getChilds(), ilTree::getChildsByType(), ilTree::getChildSequenceNumber(), ilObjTest::getCompleteWorkingTime(), ilObjSurvey::getConstraints(), ilObjForum::getCountNew(), ilDBUpdate::getCurrentVersion(), Database::getDates(), getDayList(), ilObjQuestionPool::getDeleteableQuestionDetails(), ilExerciseMembers::getDeliveredFiles(), ilTree::getDepth(), ilObjAICCCourseInterchangeFiles::getDescriptor(), ilMailbox::getDraftsFolder(), ilAddressbook::getEntries(), ilAddressbook::getEntry(), ilXML2SQL::getEntryId(), ilObjSurvey::getEvaluation(), ilObjSurvey::getEvaluationByUser(), ilObjSurvey::getEvaluationForAllUsers(), ilObjTest::getEvaluationUsers(), ilObjGroup::getExpirationDateTime(), ilObjGroup::getExpirationTimestamp(), ilObjUserFolder::getExportSettings(), ilDBUpdate::getFileVersion(), 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(), 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(), 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::getQplQuestions(), ilObjSurvey::getQuestionblock(), ilObjSurvey::getQuestionblockQuestionIds(), ilObjSurvey::getQuestionblockQuestions(), ilObjSurvey::getQuestionblocks(), ilObjSurvey::getQuestionblocksTable(), ilObjSurvey::getQuestionblockTitles(), ilObjTest::getQuestionDataset(), ilObjQuestionPool::getQuestionDetails(), ilObjSurvey::getQuestionpoolTitles(), ilObjSurveyQuestionPool::getQuestions(), ilObjSurvey::getQuestions(), ilObjSurveyQuestionPool::getQuestionsInfo(), ilObjSurveyQuestionPool::getQuestionsTable(), ilObjSurvey::getQuestionsTable(), ilObjTest::getQuestionsTable(), ilObjQuestionPool::getQuestionsTable(), ilObjTest::getQuestiontext(), ilObjTest::getQuestionTitles(), ilObjSurvey::getQuestiontypes(), ilObjTest::getRandomQuestionpools(), ASS_Question::getReachedPoints(), ilObjGroup::getRegistrationFlag(), ilRbacReview::getRoleListByObject(), ilRbacReview::getRoleOperationsOnObject(), ilRbacReview::getRolesByFilter(), ilRbacReview::getRolesOfRoleFolder(), ilChatRoom::getRooms(), ilChatRoom::getRoomsOfObject(), Database::getRotationDates(), ilTree::getSavedNodeData(), ilMailbox::getSentFolder(), ilClient::getSetting(), ILIAS::getSetting(), ASS_Question::getSolutionValues(), ilObjTest::getStartingTimeOfUser(), ilObjUser::getStoredActive(), ilSQL2XML::getStructure(), ilMailbox::getSubFolders(), ilTree::getSubTree(), ilObjSurvey::getSurveyCodes(), ilObjSurvey::getSurveyCodesTableData(), ilObjSurvey::getSurveyPages(), ilObjSurvey::getSurveyQuestions(), ilDBUpdate::getTables(), ilDBUpdate::getTableStatus(), ilNestedSetXML::getTagName(), ilNestedSetXML::getTagValue(), ilTabsGUI::getTargetsByObjectType(), ilObjTest::getTestResult(), ilCourseObjectiveQuestion::getTests(), ilObjTest::getTestSummary(), ilObjTest::getTextAnswer(), ilObjCategory::getTranslations(), ilMailbox::getTrashFolder(), ilCourseMembers::getTutors(), ilRbacReview::getTypeId(), ilObjQuestionPool::getUsedQuestionDetails(), ilForumExport::getUserData(), ilForum::getUserData(), ilObjUser::getUserIdByEmail(), ilObjUser::getUserIdByLogin(), ilObjSurvey::getVariables(), ilObjTest::getWorkedQuestions(), ilMailbox::hasNewMail(), ilExerciseMembers::ilClone(), ilLanguage::ilLanguage(), ilLMPresentationGUI::ilLocator(), ilMDConvert(), ilPCTable::importSpreadsheet(), ilNestedSetXML::init(), ilAppointmentHandler::insertAppointment(), Spreadsheet_Excel_Writer_Worksheet::insertBitmap(), ilObjSurvey::insertQuestionblock(), ilRbacReview::isAssignable(), ilRepositoryExplorer::isClickable(), ASS_Question::isClone(), ilRbacReview::isDeleted(), ilObjRoleFolder::isDeleted(), ilClient::isInstalledDB(), ilObjSurveyQuestionPool::isInUse(), ilObjQuestionPool::isInUse(), ASS_Question::isInUse(), ilRbacReview::isProtected(), ilCourseMembers::isSubscriber(), ilObjSurvey::isSurveyStarted(), SurveyQuestion::loadFromDb(), ilObjSurveyQuestionPool::loadFromDb(), ilObjQuestionPool::loadFromDb(), ASS_Question::loadFromDb(), ilLanguage::loadLanguageModule(), ilObjSurvey::loadWorkingData(), ilObjAssessmentFolderGUI::logsObject(), ilChatRoom::lookupRoomId(), ilObjForum::markAllThreadsRead(), ilObjForum::markThreadRead(), ilLMPresentationGUI::offlineexport(), SurveyNominalQuestionGUI::outWorkingForm(), padFront(), ilObjQuestionPool::pasteFromClipboard(), ilWebresourceSearch::performSearch(), ilObjectSearch::performSearch(), ilMediaPoolSearch::performSearch(), ilLMContentSearch::performSearch(), ilGlossaryDefinitionSearch::performSearch(), ilForumSearch::performSearch(), ilExerciseSearch::performSearch(), ilObjRoleTemplateGUI::permObject(), 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(), ilObjSurvey::removeConstraintsConcerningQuestion(), ilObjectGUI::removeDeletedNodes(), ilUtil::removeItemFromDesktops(), ilObjTest::retrieveTestTypes(), ilRbacReview::roleExists(), Spreadsheet_Excel_Writer::rowcolToCell(), SurveyQuestion::saveCategoryToDb(), ilObjSurvey::saveQuestionsToDb(), ilObjTest::saveQuestionsToDb(), ilTree::saveSubTree(), ASS_MarkSchema::saveToDb(), ASS_MultipleChoice::saveWorkingData(), SurveySearch::search(), ilUtil::searchGroups(), 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(), ilObjContentObjectGUI::showActions(), ilObjUserFolderGUI::showActions(), ilObjectGUI::showActions(), ilBookmarkAdministrationGUI::showActions(), ilLMObjectGUI::showPossibleSubObjects(), ilObjUserFolderGUI::showPossibleSubObjects(), ilObjRoleFolderGUI::showPossibleSubObjects(), ilObjectGUI::showPossibleSubObjects(), ilContainerGUI::showPossibleSubObjects(), ilBookmarkAdministrationGUI::showPossibleSubObjects(), 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 9544 of file dbupdate.php.
Referenced by ilMD::_deleteAllByType(), ilObjSurveyGUI::browseForQuestionsObject(), ilMD::deleteAll(), ilObjTestGUI::questionBrowser(), ilObjSurveyQuestionPoolGUI::questionsObject(), and ilObjQuestionPoolGUI::questionsObject().
| 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.
| $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(), ilLPListOfObjectsGUI::__showUserList(), ilObjAssessmentFolder::_addLog(), ilObjiLincClassroomAccess::_checkAccess(), ilObjTest::_getActiveTestUser(), ilObjTest::_getBestPass(), ilObjTest::_getPass(), ilObjTestAccess::_getPassedUsers(), ilObjTest::_getPassedUsers(), ilObjTest::_getQuestionCount(), ASS_Question::_getReachedPoints(), ilObjTest::_getResultPass(), ASS_Question::_getSolutionMaxPass(), ilObjTestAccess::_getTestResult(), ilObjTest::_getTestResult(), ilObjSurveyAccess::_hasEvaluationAccess(), ilObjSurveyAccess::_isSurveyParticipant(), ASS_Question::_isWorkedThrough(), SurveyQuestion::_isWriteable(), ASS_Question::_isWriteable(), ASS_TextQuestion::_setReachedPoints(), ilUserTracking::_trackAccess(), ilTracking::_trackAccess(), ilTestEvaluationGUI::addFoundUsersToEval(), ilObjCourseGUI::addFromWaitingList(), ilObjTestGUI::addParticipantsObject(), ilObjTest::addSelectedGroup(), ilObjTest::addSelectedRole(), ilObjTest::addSelectedUser(), ilPaymentTrusteeGUI::addTrustee(), ilPaymentTrusteeGUI::addUser(), ilObjCourseGUI::addUserObject(), addUserRoleEntry(), ilSoapRBACAdministration::addUserRoleEntry(), assignCourseMember(), ilSoapCourseAdministration::assignCourseMember(), assignGroupMember(), ilSoapGroupAdministration::assignGroupMember(), ASS_TextQuestion::calculateReachedPoints(), ASS_OrderingQuestion::calculateReachedPoints(), ASS_MultipleChoice::calculateReachedPoints(), ASS_MatchingQuestion::calculateReachedPoints(), ASS_JavaApplet::calculateReachedPoints(), ASS_ImagemapQuestion::calculateReachedPoints(), ASS_ClozeTest::calculateReachedPoints(), ilObjTest::canShowTestResults(), ilPermissionGUI::changeOwner(), ilObjiLincCourseGUI::confirmationObject(), ilObjGroupGUI::confirmationObject(), ASS_OrderingQuestion::createRandomSolution(), ASS_MultipleChoice::createRandomSolution(), ASS_MatchingQuestion::createRandomSolution(), ilObjTest::createRandomSolutionsForAllUsers(), db_pwassist_session_find(), db_pwassist_session_write(), ilObjRole::delete(), ilObjExercise::deleteDeliveredFiles(), ilObjTest::deleteResults(), ilSoapRBACAdministration::deleteRole(), deleteUser(), ilSoapUserAdministration::deleteUser(), deleteUserRoleEntry(), ilSoapRBACAdministration::deleteUserRoleEntry(), ilObjSurvey::deleteWorkingData(), ilObjExercise::deliverFile(), ilForum::disableNotification(), ilObjSurvey::disinviteUser(), ilObjTest::disinviteUser(), ilObjSurveyGUI::disinviteUserGroupObject(), ilPersonalDesktopGUI::displayUsersOnline(), ilForum::enableNotification(), ilObjTest::evalStatistical(), ilSurveyEvaluationGUI::evaluationuser(), ilTestEvaluationGUI::evalUserDetail(), excludeCourseMember(), ilSoapCourseAdministration::excludeCourseMember(), excludeGroupMember(), ilSoapGroupAdministration::excludeGroupMember(), ilObjSurvey::finishSurvey(), ilObjTest::getActiveTestUser(), ilObjTest::getAllTestResults(), ilObjTest::getAnsweredQuestionCount(), ilObjTest::getCompleteWorkingTime(), ilObjExercise::getDeliveredFiles(), ilObjSurvey::getEvaluationByUser(), ilObjTest::getEvaluationUsers(), ilObjUser::getGroupMemberships(), ilSearchItemFactory::getInstance(), ilObjTest::getInvitedUsers(), ilObjSurvey::getLastActivePage(), ilObjTest::getNrOfResultsForPass(), getObjectByReference(), ilSoapObjectAdministration::getObjectByReference(), getObjectsByTitle(), ilSoapObjectAdministration::getObjectsByTitle(), getObjectTreeOperations(), ilSoapRBACAdministration::getObjectTreeOperations(), ilObjTest::getPassFinishDate(), ASS_TextQuestion::getReachedInformation(), ASS_OrderingQuestion::getReachedInformation(), ASS_MultipleChoice::getReachedInformation(), ASS_MatchingQuestion::getReachedInformation(), ASS_JavaApplet::getReachedInformation(), ASS_ImagemapQuestion::getReachedInformation(), ASS_ClozeTest::getReachedInformation(), ASS_Question::getReachedPoints(), ASS_Question::getSolutionMaxPass(), ilObjTest::getStartingTimeOfUser(), ilObjTest::getTestResult(), ilObjTest::getTestSummary(), ilObjTest::getTextAnswer(), ilObjTest::getTotalPointsArray(), ilObjTest::getTotalPointsPassedArray(), getTreeChilds(), ilSoapObjectAdministration::getTreeChilds(), getUser(), ilSoapUserAdministration::getUser(), getUserRoles(), ilSoapRBACAdministration::getUserRoles(), ilObjectStatusGUI::ilObjectStatusGUI(), ilObjNoteFolder::ilObjNoteFolder(), ilUserImportParser::importEndTag(), 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(), ilObjTest::loadQuestions(), ilObjSurvey::loadWorkingData(), ilSoapUserAdministration::lookupUser(), ilObjTestGUI::maintenanceObject(), ilTestEvaluationGUI::outEvalSearchResultTable(), ilObjTestGUI::outPrintUserResults(), ilTestOutputGUI::outResultsOverview(), ilTestOutputGUI::outShowAnswersDetails(), ilObjTestGUI::outShowAnswersDetails(), ilTestOutputGUI::outTestResults(), ilTestOutputGUI::outTestSummary(), ilObjSurveyGUI::outUserGroupTable(), ilTestEvaluationGUI::passDetails(), ilObjCategoryGUI::performDeleteUsersObject(), ilObjHACPTracking::putparam(), ilObjiLincCourse::registerUsers(), ilObjTestGUI::removeParticipantObject(), ilObjTest::removeSelectedTestResults(), ilTestEvaluationGUI::removeSelectedUser(), ilObjTest::removeSelectedUser(), ilObjTestGUI::saveClientIPObject(), saveQuestionResult(), ilSoapUtils::saveQuestionResult(), ilObjSurvey::saveWorkingData(), searchObjects(), ilSoapObjectAdministration::searchObjects(), ilHACPResponse::sendParam(), ilObjTest::setActiveTestSubmitted(), ilObjTest::setClientIP(), ilObjSurvey::setInvitation(), ilObjTest::setQuestionSetSolved(), ASS_TextQuestion::setReachedPoints(), ilObjTestGUI::showAnswersObject(), ilLPListOfObjectsGUI::showDetails(), ilObjTestGUI::showResultsObject(), ilObjSurvey::startSurvey(), ilObjTest::startWorkingTime(), ilObjSCORMTracking::store(), ilUserTracking::TestTitle(), ilTracking::TestTitle(), ASS_OrderingQuestion::to_xml(), ASS_JavaApplet::to_xml(), ilnetucateXMLAPI::unregisterUser(), ilObjiLincCourseGUI::updateMemberStatusObject(), updatePassword(), ilSoapUserAdministration::updatePassword(), and ASS_MultipleChoice::wasAnsweredByUser().
| $user_set = $this->db->query($q) |
Definition at line 3545 of file dbupdate.php.
Referenced by ilObjUser::_getUsersForClipboadObject(), ilObjUser::_lookupHasIlias2Password(), ilObjUser::_lookupId(), ilObjUser::_lookupLogin(), ilObjUser::_lookupName(), ilObjUser::_switchToIlias3Password(), and ilObjSCORMLearningModule::getTrackingDataAgg().
| $users = array() |
Definition at line 506 of file dbupdate.php.
| $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.
