===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-165-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:166: $queryStr = "UPDATE tblDocuments SET name = ".$db->qstr($newName)." WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-167- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-188-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:189: $queryStr = "UPDATE tblDocuments SET comment = ".$db->qstr($newComment)." WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-190- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-201-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:202: $queryStr = "UPDATE tblDocuments SET keywords = ".$db->qstr($newKeywords)." WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-203- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-218- if(!$this->_categories) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:219: $queryStr = "SELECT * FROM tblCategory where id in (select categoryID from tblDocumentCategory where documentID = ".$this->_id.")";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-220- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-242-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:243: $queryStr = "DELETE from tblDocumentCategory WHERE documentID = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-244- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-288-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:289: $queryStr = "UPDATE tblDocuments SET folder = " . $newFolder->getID() . " WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-290- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-303- }
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:304: $queryStr = "UPDATE tblDocuments SET folderList = '" . $flist . "' WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-305- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-330-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:331: $queryStr = "UPDATE tblDocuments set owner = " . $newOwner->getID() . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-332- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-351-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:352: $queryStr = "UPDATE tblDocuments set defaultAccess = " . (int) $mode . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-353- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-391-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:392: $queryStr = "UPDATE tblDocuments SET inheritAccess = " . ($inheritAccess ? "1" : "0") . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-393- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-456-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:457: $queryStr = "UPDATE tblDocuments SET expires = " . (int) $expires . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-458- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-511- if (is_bool($falseOrUser) && !$falseOrUser) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:512: $queryStr = "DELETE FROM tblDocumentLocks WHERE document = ".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-513- }
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-547-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:548: $queryStr = "UPDATE tblDocuments SET sequence = " . $seq . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-549- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-563-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:564: $queryStr = "DELETE FROM tblACLs WHERE targetType = " . T_DOCUMENT . " AND target = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-565- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-669-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:670: $queryStr = "UPDATE tblACLs SET mode = " . (int) $newMode . " WHERE targetType = ".T_DOCUMENT." AND target = " . $this->_id . " AND " . $userOrGroup . " = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-671- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-696-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:697: $queryStr = "DELETE FROM tblACLs WHERE targetType = ".T_DOCUMENT." AND target = ".$this->_id." AND ".$userOrGroup." = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-698- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-826-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:827: $queryStr ="SELECT * FROM tblNotify WHERE targetType = " . T_DOCUMENT . " AND target = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-828- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-939- /* Check to see if user/group is already on the list. */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:940: $queryStr = "SELECT * FROM `tblNotify` WHERE `tblNotify`.`target` = '".$this->_id."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-941- "AND `tblNotify`.`targetType` = '".T_DOCUMENT."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:942: "AND `tblNotify`.`".$userOrGroup."` = '".(int) $userOrGroupID."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-943- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1010- /* Check to see if the target is in the database. */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1011: $queryStr = "SELECT * FROM `tblNotify` WHERE `tblNotify`.`target` = '".$this->_id."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1012- "AND `tblNotify`.`targetType` = '".T_DOCUMENT."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1013: "AND `tblNotify`.`".$userOrGroup."` = '".(int) $userOrGroupID."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1014- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1021-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1022: $queryStr = "DELETE FROM tblNotify WHERE target = " . $this->_id . " AND targetType = " . T_DOCUMENT . " AND " . $userOrGroup . " = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1023- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1061- if ((int)$version<1) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1062: $queryStr = "SELECT MAX(version) as m from tblDocumentContent where document = ".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1063- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1176- if (!isset($this->_content)) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1177: $queryStr = "SELECT * FROM tblDocumentContent WHERE document = ".$this->_id." ORDER BY version";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1178- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1207- $db = $this->_dms->getDB();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1208: $queryStr = "SELECT * FROM tblDocumentContent WHERE document = ".$this->_id." AND version = " . (int) $version;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1209- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1221- $db = $this->_dms->getDB();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1222: $queryStr = "SELECT * FROM tblDocumentContent WHERE document = ".$this->_id." ORDER BY version DESC LIMIT 0,1";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1223- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1247-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1248: $queryStr = "DELETE FROM tblDocumentContent WHERE `document` = " . $this->getID() . " AND `version` = " . $version->_version;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1249- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1251-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1252: $queryStr = "DELETE FROM tblDocumentContentAttributes WHERE content = " . $version->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1253- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1255-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1256: $queryStr = "DELETE FROM `tblDocumentStatusLog` WHERE `statusID` = '".$stID."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1257- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1259-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1260: $queryStr = "DELETE FROM `tblDocumentStatus` WHERE `documentID` = '". $this->getID() ."' AND `version` = '" . $version->_version."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1261- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1277- }
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1278: $queryStr = "DELETE FROM `tblDocumentReviewers` WHERE `documentID` = '". $this->getID() ."' AND `version` = '" . $version->_version."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1279- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1293- }
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1294: $queryStr = "DELETE FROM `tblDocumentApprovers` WHERE `documentID` = '". $this->getID() ."' AND `version` = '" . $version->_version."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1295- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1305-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1306: $queryStr = "SELECT * FROM tblDocumentLinks WHERE document = " . $this->_id ." AND id = " . (int) $linkID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1307- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1320-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1321: $queryStr = "SELECT * FROM tblDocumentLinks WHERE document = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1322- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1352-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1353: $queryStr = "DELETE FROM tblDocumentLinks WHERE document = " . $this->_id ." AND id = " . (int) $linkID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1354- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1363-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1364: $queryStr = "SELECT * FROM tblDocumentFiles WHERE document = " . $this->_id ." AND id = " . (int) $ID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1365- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1375-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1376: $queryStr = "SELECT * FROM tblDocumentFiles WHERE document = " . $this->_id." ORDER BY `date` DESC";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1377- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1425-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1426: $queryStr = "DELETE FROM tblDocumentFiles WHERE document = " . $this->getID() . " AND id = " . (int) $ID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1427- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1459-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1460: $queryStr = "DELETE FROM tblDocuments WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1461- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1462- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1463: $queryStr = "DELETE FROM tblDocumentAttributes WHERE document = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1464- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1465- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1466: $queryStr = "DELETE FROM tblACLs WHERE target = " . $this->_id . " AND targetType = " . T_DOCUMENT;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1467- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1468- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1469: $queryStr = "DELETE FROM tblDocumentLinks WHERE document = " . $this->_id . " OR target = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1470- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1471- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1472: $queryStr = "DELETE FROM tblDocumentLocks WHERE document = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1473- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1474- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1475: $queryStr = "DELETE FROM tblDocumentFiles WHERE document = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1476- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1477- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1478: $queryStr = "DELETE FROM tblDocumentCategory WHERE documentID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1479- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1482- // Delete the notification list.
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1483: $queryStr = "DELETE FROM tblNotify WHERE target = " . $this->_id . " AND targetType = " . T_DOCUMENT;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1484- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1547- "(SELECT `tblUsers`.* FROM `tblUsers` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1548: "WHERE (`tblUsers`.`id` = ". $this->_ownerID . ") ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1549- "OR (`tblUsers`.`role` = ".LetoDMS_Core_User::role_admin."))".
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1603-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1604: $queryStr = "SELECT folderList FROM tblDocuments where id = ".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1605- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1633- if($curfolderlist != $pathPrefix) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1634: $queryStr = "UPDATE tblDocuments SET folderList='".$pathPrefix."' WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1635- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1737-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1738: $queryStr = "UPDATE tblDocumentContent SET comment = ".$db->qstr($newComment)." WHERE `document` = " . $this->_document->getID() . " AND `version` = " . $this->_version;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1739- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1764- $res = 0;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1765: exec($command, $output, $res);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1766-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1850- "LEFT JOIN `tblDocumentStatusLog` USING (`statusID`) ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1851: "WHERE `tblDocumentStatus`.`documentID` = '". $this->_document->getID() ."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1852- "AND `tblDocumentStatus`.`version` = '". $this->_version ."' ".
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1923- $queryStr=
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1924: "SELECT reviewID FROM tblDocumentReviewers WHERE `version`='".$this->_version
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1925- ."' AND `documentID` = '". $this->_document->getID() ."' ";
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1939- "LEFT JOIN `tblGroups` on `tblGroups`.`id` = `tblDocumentReviewers`.`required`".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1940: "WHERE `tblDocumentReviewers`.`reviewID` = '". $rec['reviewID'] ."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1941- "ORDER BY `tblDocumentReviewLog`.`reviewLogID` DESC LIMIT ".(int) $limit;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1964- $queryStr=
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1965: "SELECT approveId FROM tblDocumentApprovers WHERE `version`='".$this->_version
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1966- ."' AND `documentID` = '". $this->_document->getID() ."' ";
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1980- "LEFT JOIN `tblGroups` on `tblGroups`.`id` = `tblDocumentApprovers`.`required`".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php:1981: "WHERE `tblDocumentApprovers`.`approveId` = '". $rec['approveId'] ."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocument.php-1982- "ORDER BY `tblDocumentApproveLog`.`approveLogId` DESC LIMIT ".(int) $limit;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-106-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:107: $queryStr = "UPDATE tblFolders SET name = " . $db->qstr($newName) . " WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-108- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-120-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:121: $queryStr = "UPDATE tblFolders SET comment = " . $db->qstr($newComment) . " WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-122- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-178- }
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:179: $queryStr = "UPDATE tblFolders SET parent = ".$newParent->getID().", folderList='".$pathPrefix."' WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-180- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-203- $newPath = preg_replace("/^.*:".$this->_id.":(.*$)/", $pathPrefix."\\1", $row["folderList"]);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:204: $queryStr="UPDATE `tblDocuments` SET `folderList` = '".$newPath."' WHERE `tblDocuments`.`id` = '".$row["id"]."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-205- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-230-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:231: $queryStr = "UPDATE tblFolders set owner = " . $newOwner->getID() . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-232- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-252-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:253: $queryStr = "UPDATE tblFolders set defaultAccess = " . (int) $mode . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-254- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-283-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:284: $queryStr = "UPDATE tblFolders SET inheritAccess = " . (int) $inheritAccess . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-285- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-312-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:313: $queryStr = "UPDATE tblFolders SET sequence = " . $seq . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-314- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-334- if (!isset($this->_subFolders)) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:335: if ($orderby=="n") $queryStr = "SELECT * FROM tblFolders WHERE parent = " . $this->_id . " ORDER BY name";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:336: else $queryStr = "SELECT * FROM tblFolders WHERE parent = " . $this->_id . " ORDER BY sequence";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-337- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-464- if (!isset($this->_documents)) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:465: if ($orderby=="n") $queryStr = "SELECT * FROM tblDocuments WHERE folder = " . $this->_id . " ORDER BY name";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:466: else $queryStr = "SELECT * FROM tblDocuments WHERE folder = " . $this->_id . " ORDER BY sequence";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-467-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-539- if (is_bool($res) && !$res) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:540: $queryStr = "DELETE FROM tblDocuments WHERE id = " . $document->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-541- $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:587: $queryStr = "DELETE FROM tblFolders WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-588- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-589- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:590: $queryStr = "DELETE FROM tblFolderAttributes WHERE folder = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-591- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-592- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:593: $queryStr = "DELETE FROM tblACLs WHERE target = ". $this->_id. " AND targetType = " . T_FOLDER;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-594- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-596-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:597: $queryStr = "DELETE FROM tblNotify WHERE target = ". $this->_id. " AND targetType = " . T_FOLDER;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-598- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-664-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:665: $queryStr = "DELETE FROM tblACLs WHERE targetType = " . T_FOLDER . " AND target = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-666- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-717-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:718: $queryStr = "UPDATE tblACLs SET mode = " . (int) $newMode . " WHERE targetType = ".T_FOLDER." AND target = " . $this->_id . " AND " . $userOrGroup . " = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-719- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-736-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:737: $queryStr = "DELETE FROM tblACLs WHERE targetType = ".T_FOLDER." AND target = ".$this->_id." AND ".$userOrGroup." = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-738- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-858-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:859: $queryStr ="SELECT * FROM tblNotify WHERE targetType = " . T_FOLDER . " AND target = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-860- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-977- //
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:978: $queryStr = "SELECT * FROM `tblNotify` WHERE `tblNotify`.`target` = '".$this->_id."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-979- "AND `tblNotify`.`targetType` = '".T_FOLDER."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:980: "AND `tblNotify`.`".$userOrGroup."` = '". (int) $userOrGroupID."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-981- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1050- //
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1051: $queryStr = "SELECT * FROM `tblNotify` WHERE `tblNotify`.`target` = '".$this->_id."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1052- "AND `tblNotify`.`targetType` = '".T_FOLDER."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1053: "AND `tblNotify`.`".$userOrGroup."` = '". (int) $userOrGroupID."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1054- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1061-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1062: $queryStr = "DELETE FROM tblNotify WHERE target = " . $this->_id . " AND targetType = " . T_FOLDER . " AND " . $userOrGroup . " = " . (int) $userOrGroupID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1063- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1128- "(SELECT `tblUsers`.* FROM `tblUsers` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1129: "WHERE (`tblUsers`.`id` = ". $this->_ownerID . ") ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1130- "OR (`tblUsers`.`role` = ".LetoDMS_Core_User::role_admin."))".
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1184-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1185: $queryStr = "SELECT folderList FROM tblFolders where id = ".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1186- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1213- if($curfolderlist != $pathPrefix) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php:1214: $queryStr = "UPDATE tblFolders SET folderList='".$pathPrefix."' WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassFolder.php-1215- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-336-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:337: $queryStr = "SELECT * FROM tblDocuments WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-338- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-345- // New Locking mechanism uses a separate table to track the lock.
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:346: $queryStr = "SELECT * FROM tblDocumentLocks WHERE document = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-347- $lockArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-371- "LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id`=`tblDocumentLocks`.`document` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:372: "WHERE `tblDocuments`.`owner` = " . $user->getID() . " ORDER BY `sequence`";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-373-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-397- "FROM `tblDocuments` LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id` = `tblDocumentLocks`.`document` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:398: "WHERE `tblDocumentLocks`.`userID` = '".$user->getID()."' ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-399- "ORDER BY `id` DESC";
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-429- "LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id`=`tblDocumentLocks`.`document` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:430: "WHERE `tblDocuments`.`name` = " . $this->db->qstr($name);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-431- if($folder)
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-699- if($attrdef->getValueSet())
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:700: $searchAttributes[] = "`tblDocumentAttributes`.`attrdef`=".$attrdefid." AND `tblDocumentAttributes`.`value`='".$attribute."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-701- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:702: $searchAttributes[] = "`tblDocumentAttributes`.`attrdef`=".$attrdefid." AND `tblDocumentAttributes`.`value` like '%".$attribute."%'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-703- } elseif($attrdef->getObjType() == LetoDMS_Core_AttributeDefinition::objtype_documentcontent) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-704- if($attrdef->getValueSet())
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:705: $searchAttributes[] = "`tblDocumentContentAttributes`.`attrdef`=".$attrdefid." AND `tblDocumentContentAttributes`.`value`='".$attribute."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-706- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:707: $searchAttributes[] = "`tblDocumentContentAttributes`.`attrdef`=".$attrdefid." AND `tblDocumentContentAttributes`.`value` like '%".$attribute."%'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-708- }
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-862-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:863: $queryStr = "SELECT * FROM tblFolders WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-864- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-891-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:892: $queryStr = "SELECT * FROM tblFolders WHERE name = " . $this->db->qstr($name);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-893- if($folder)
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-921-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:922: $queryStr = "SELECT * FROM tblUsers WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-923- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-946- function getUserByLogin($login, $email='') { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:947: $queryStr = "SELECT * FROM tblUsers WHERE login = ".$this->db->qstr($login);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-948- if($email)
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-971- function getUserByEmail($email) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:972: $queryStr = "SELECT * FROM tblUsers WHERE email = ".$this->db->qstr($email);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-973- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1049-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1050: $queryStr = "SELECT * FROM tblGroups WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1051- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1071- function getGroupByName($name) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1072: $queryStr = "SELECT `tblGroups`.* FROM `tblGroups` WHERE `tblGroups`.`name` = ".$this->db->qstr($name);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1073- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1134-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1135: $queryStr = "SELECT * FROM tblKeywordCategories WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1136- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1146- function getKeywordCategoryByName($name, $userID) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1147: $queryStr = "SELECT * FROM tblKeywordCategories WHERE name = " . $this->db->qstr($name) . " AND owner = " . (int) $userID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1148- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1182- if ($userID != -1)
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1183: $queryStr .= " WHERE owner = " . (int) $userID;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1184-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1213-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1214: $queryStr = "SELECT * FROM tblCategory WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1215- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1250- function getDocumentCategoryByName($name) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1251: $queryStr = "SELECT * FROM tblCategory where name=".$this->db->qstr($name);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1252-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1283- $queryStr = "SELECT `tblNotify`.* FROM `tblNotify` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1284: "WHERE `tblNotify`.`groupID` = ". $group->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1285- if($type) {
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1311- $queryStr = "SELECT `tblNotify`.* FROM `tblNotify` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1312: "WHERE `tblNotify`.`userID` = ". $user->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1313- if($type) {
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1355- /* Get the password request from the database */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1356: $queryStr = "SELECT * FROM tblUserPasswordRequest where hash=".$this->db->qstr($hash);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1357- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1375- /* Delete the request, so nobody can use it a second time */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1376: $queryStr = "DELETE FROM tblUserPasswordRequest WHERE hash=".$this->db->qstr($hash);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1377- if (!$this->db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1394-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1395: $queryStr = "SELECT * FROM tblAttributeDefinitions WHERE id = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1396- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1416- function getAttributeDefinitionByName($name) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1417: $queryStr = "SELECT * FROM tblAttributeDefinitions WHERE name = " . $this->db->qstr($name);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1418- $resArr = $this->db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1441- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php:1442: $queryStr .= ' WHERE objtype='.intval($objtype);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDMS.php-1443- }
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-159-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:160: $queryStr = "UPDATE tblUsers SET login =".$db->qstr($newLogin)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-161- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-173-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:174: $queryStr = "UPDATE tblUsers SET fullname = ".$db->qstr($newFullName)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-175- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-187-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:188: $queryStr = "UPDATE tblUsers SET pwd =".$db->qstr($newPwd)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-189- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-201-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:202: $queryStr = "UPDATE tblUsers SET pwdExpiration =".$db->qstr($newPwdExpiration)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-203- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-215-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:216: $queryStr = "UPDATE tblUsers SET email =".$db->qstr($newEmail)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-217- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-229-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:230: $queryStr = "UPDATE tblUsers SET language =".$db->qstr($newLanguage)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-231- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-243-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:244: $queryStr = "UPDATE tblUsers SET theme =".$db->qstr($newTheme)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-245- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-257-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:258: $queryStr = "UPDATE tblUsers SET comment =".$db->qstr($newComment)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-259- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-271-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:272: $queryStr = "UPDATE tblUsers SET role = " . $newrole . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-273- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-284-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:285: $queryStr = "UPDATE tblUsers SET role = " . LetoDMS_Core_User::role_admin . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-286- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-297-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:298: $queryStr = "UPDATE tblUsers SET role = " . LetoDMS_Core_User::role_guest . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-299- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-311- $isHidden = ($isHidden) ? "1" : "0";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:312: $queryStr = "UPDATE tblUsers SET hidden = " . $isHidden . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-313- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-325- $isDisabled = ($isDisabled) ? "1" : "0";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:326: $queryStr = "UPDATE tblUsers SET disabled = " . $isDisabled . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-327- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-337- $this->_loginFailures++;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:338: $queryStr = "UPDATE tblUsers SET loginfailures = " . $this->_loginFailures . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-339- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-348- $this->_loginFailures = 0;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:349: $queryStr = "UPDATE tblUsers SET loginfailures = " . $this->_loginFailures . " WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-350- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-379- // delete private keyword lists
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:380: $queryStr = "SELECT tblKeywords.id FROM tblKeywords, tblKeywordCategories WHERE tblKeywords.category = tblKeywordCategories.id AND tblKeywordCategories.owner = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-381- $resultArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-391-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:392: $queryStr = "DELETE FROM tblKeywordCategories WHERE owner = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-393- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-395- //Benachrichtigungen entfernen
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:396: $queryStr = "DELETE FROM tblNotify WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-397- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-399- /* Assign documents of the removed user to the given user */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:400: $queryStr = "UPDATE tblFolders SET owner = " . $assignTo . " WHERE owner = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-401- if (!$db->getResult($queryStr)) return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-402-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:403: $queryStr = "UPDATE tblDocuments SET owner = " . $assignTo . " WHERE owner = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-404- if (!$db->getResult($queryStr)) return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-405-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:406: $queryStr = "UPDATE tblDocumentContent SET createdBy = " . $assignTo . " WHERE createdBy = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-407- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-409- // Remove private links on documents ...
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:410: $queryStr = "DELETE FROM tblDocumentLinks WHERE userID = " . $this->_id . " AND public = 0";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-411- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-413- // ... but keep public links
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:414: $queryStr = "UPDATE tblDocumentLinks SET userID = " . $assignTo . " WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-415- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-417- // set administrator for deleted user's attachments
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:418: $queryStr = "UPDATE tblDocumentFiles SET userID = " . $assignTo . " WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-419- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-421- //Evtl. von diesem Benutzer gelockte Dokumente werden freigegeben
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:422: $queryStr = "DELETE FROM tblDocumentLocks WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-423- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-425- // Delete user from all groups
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:426: $queryStr = "DELETE FROM tblGroupMembers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-427- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-429- // User aus allen ACLs streichen
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:430: $queryStr = "DELETE FROM tblACLs WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-431- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-433- // Delete image of user
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:434: $queryStr = "DELETE FROM tblUserImages WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-435- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-437- // Delete entries in password history
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:438: $queryStr = "DELETE FROM tblUserPasswordHistory WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-439- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-441- // Delete entries in password request
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:442: $queryStr = "DELETE FROM tblUserPasswordRequest WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-443- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-445- // mandatory review/approve
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:446: $queryStr = "DELETE FROM tblMandatoryReviewers WHERE reviewerUserID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-447- if (!$db->getResult($queryStr)) return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-448-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:449: $queryStr = "DELETE FROM tblMandatoryApprovers WHERE approverUserID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-450- if (!$db->getResult($queryStr)) return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-451-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:452: $queryStr = "DELETE FROM tblMandatoryReviewers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-453- if (!$db->getResult($queryStr)) return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-454-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:455: $queryStr = "DELETE FROM tblMandatoryApprovers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-456- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-458- // set administrator for deleted user's events
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:459: $queryStr = "UPDATE tblEvents SET userID = " . $assignTo . " WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-460- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-462- // Delete user itself
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:463: $queryStr = "DELETE FROM tblUsers WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-464- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-467- // TODO : update document status if reviewer/approver has been deleted
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:468: // "DELETE FROM tblDocumentApproveLog WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:469: // "DELETE FROM tblDocumentReviewLog WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-470-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-541- "LEFT JOIN `tblGroupMembers` ON `tblGroups`.`id` = `tblGroupMembers`.`groupID` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:542: "WHERE `tblGroupMembers`.`userID`='". $this->_id ."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-543- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-575-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:576: $queryStr = "SELECT COUNT(*) AS num FROM tblUserImages WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-577- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-595-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:596: $queryStr = "SELECT * FROM tblUserImages WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-597- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-614- if ($this->hasImage())
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:615: $queryStr = "UPDATE tblUserImages SET image = '".base64_encode($content)."', mimeType = ".$db->qstr($mimeType)." WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-616- else
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-843-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:844: $queryStr = "SELECT * FROM tblMandatoryReviewers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-845- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-859-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:860: $queryStr = "SELECT * FROM tblMandatoryApprovers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-861- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-878-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:879: $queryStr = "SELECT * FROM tblMandatoryReviewers WHERE userID = " . $this->_id . " AND reviewerGroupID = " . $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-880- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-888-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:889: $queryStr = "SELECT * FROM tblMandatoryReviewers WHERE userID = " . $this->_id . " AND reviewerUserID = " . $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-890- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-912-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:913: $queryStr = "SELECT * FROM tblMandatoryApprovers WHERE userID = " . $this->_id . " AND approverGroupID = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-914- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-922-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:923: $queryStr = "SELECT * FROM tblMandatoryApprovers WHERE userID = " . $this->_id . " AND approverUserID = " . (int) $id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-924- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-939- $db = $this->_dms->getDB();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:940: $queryStr = "DELETE FROM tblMandatoryReviewers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-941- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-952-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php:953: $queryStr = "DELETE FROM tblMandatoryApprovers WHERE userID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassUser.php-954- if (!$db->getResult($queryStr)) return false;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-63-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:64: $queryStr = "UPDATE tblGroups SET name = ".$db->qstr($newName)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-65- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-76-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:77: $queryStr = "UPDATE tblGroups SET comment = ".$db->qstr($newComment)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-78- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-90- "LEFT JOIN `tblGroupMembers` ON `tblGroupMembers`.`userID`=`tblUsers`.`id` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:91: "WHERE `tblGroupMembers`.`groupID` = '". $this->_id ."'";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-92- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-110- "LEFT JOIN `tblGroupMembers` ON `tblGroupMembers`.`userID`=`tblUsers`.`id` ".
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:111: "WHERE `tblGroupMembers`.`groupID` = '". $this->_id ."' AND tblGroupMembers.manager = 1";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-112- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-139-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:140: $queryStr = "DELETE FROM tblGroupMembers WHERE groupID = ".$this->_id." AND userID = ".$user->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-141- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-158- $db = $this->_dms->getDB();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:159: if ($asManager) $queryStr = "SELECT * FROM tblGroupMembers WHERE groupID = " . $this->_id . " AND userID = " . $user->getID() . " AND manager = 1";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:160: else $queryStr = "SELECT * FROM tblGroupMembers WHERE groupID = " . $this->_id . " AND userID = " . $user->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-161-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-174-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:175: if ($this->isMember($user,true)) $queryStr = "UPDATE tblGroupMembers SET manager = 0 WHERE groupID = ".$this->_id." AND userID = ".$user->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:176: else $queryStr = "UPDATE tblGroupMembers SET manager = 1 WHERE groupID = ".$this->_id." AND userID = ".$user->getID();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-177-
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-193-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:194: $queryStr = "DELETE FROM tblGroupMembers WHERE groupID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-195- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-196- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:197: $queryStr = "DELETE FROM tblACLs WHERE groupID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-198- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-199- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:200: $queryStr = "DELETE FROM tblNotify WHERE groupID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-201- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-202- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:203: $queryStr = "DELETE FROM tblMandatoryReviewers WHERE reviewerGroupID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-204- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-205- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:206: $queryStr = "DELETE FROM tblMandatoryApprovers WHERE approverGroupID = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-207- if (!$db->getResult($queryStr))
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-208- return false;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php:209: $queryStr = "DELETE FROM tblGroups WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassGroup.php-210- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.DBAccessPDO.php-185- function getResult($queryStr, $silent=false) { /* {{{ */
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.DBAccessPDO.php:186: $res = $this->_conn->exec($queryStr);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.DBAccessPDO.php-187- if($res === false) {
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-73-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:74: $queryStr = "UPDATE tblKeywordCategories SET name = ".$db->qstr($newName)." WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-75- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-96-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:97: $queryStr = "SELECT * FROM tblKeywords WHERE category = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-98- return $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-103-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:104: $queryStr = "UPDATE tblKeywords SET keywords = ".$db->qstr($keywords)." WHERE id = $listID";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-105- return $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-117-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:118: $queryStr = "DELETE FROM tblKeywords WHERE id = $listID";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-119- return $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-124-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:125: $queryStr = "DELETE FROM tblKeywords WHERE category = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-126- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-128-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php:129: $queryStr = "DELETE FROM tblKeywordCategories WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassKeywords.php-130- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-58-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php:59: $queryStr = "UPDATE tblCategory SET name = ".$db->qstr($newName)." WHERE id = ". $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-60- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-69-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php:70: $queryStr = "SELECT * FROM tblDocumentCategory WHERE categoryID=".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-71- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-93-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php:94: $queryStr = "DELETE FROM tblCategory WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-95- if (!$db->getResult($queryStr))
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-103-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php:104: $queryStr = "SELECT * FROM tblDocumentCategory where categoryID=".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassDocumentCategory.php-105- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-77- case "LetoDMS_Core_Document":
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php:78: $queryStr = "SELECT * FROM tblDocumentAttributes WHERE document = " . $this->_id." ORDER BY `id`";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-79- break;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-80- case "LetoDMS_Core_DocumentContent":
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php:81: $queryStr = "SELECT * FROM tblDocumentContentAttributes WHERE content = " . $this->_id." ORDER BY `id`";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-82- break;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-83- case "LetoDMS_Core_Folder":
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php:84: $queryStr = "SELECT * FROM tblFolderAttributes WHERE folder = " . $this->_id." ORDER BY `id`";
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassObject.php-85- break;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-87- if(trim($value) === '')
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:88: $queryStr = "DELETE FROM tblDocumentAttributes WHERE `document` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-89- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:90: $queryStr = "UPDATE tblDocumentAttributes SET value = ".$db->qstr($value)." WHERE `document` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-91- break;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-93- if(trim($value) === '')
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:94: $queryStr = "DELETE FROM tblDocumentContentAttributes WHERE `content` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-95- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:96: $queryStr = "UPDATE tblDocumentContentAttributes SET value = ".$db->qstr($value)." WHERE `content` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-97- break;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-99- if(trim($value) === '')
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:100: $queryStr = "DELETE FROM tblFolderAttributes WHERE `folder` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-101- else
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:102: $queryStr = "UPDATE tblFolderAttributes SET value = ".$db->qstr($value)." WHERE `folder` = " . $this->_obj->getID() . " AND `attrdef` = " . $this->_attrdef->getId();
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-103- break;
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-183-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:184: $queryStr = "UPDATE tblAttributeDefinitions SET name =".$db->qstr($name)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-185- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-197-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:198: $queryStr = "UPDATE tblAttributeDefinitions SET objtype =".intval($objtype)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-199- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-211-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:212: $queryStr = "UPDATE tblAttributeDefinitions SET type =".intval($type)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-213- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-225-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:226: $queryStr = "UPDATE tblAttributeDefinitions SET multiple =".intval($mv)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-227- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-239-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:240: $queryStr = "UPDATE tblAttributeDefinitions SET minvalues =".intval($minvalues)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-241- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-253-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:254: $queryStr = "UPDATE tblAttributeDefinitions SET maxvalues =".intval($maxvalues)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-255- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-324-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:325: $queryStr = "UPDATE tblAttributeDefinitions SET valueset =".$db->qstr($valuesetstr)." WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-326- $res = $db->getResult($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-345-
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:346: $queryStr = "SELECT * FROM tblDocumentAttributes WHERE attrdef=".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-347- $resArr = $db->getResultArray($queryStr);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-348- if (is_array($resArr) && count($resArr) == 0) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:349: $queryStr = "SELECT * FROM tblFolderAttributes WHERE attrdef=".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-350- $resArr = $db->getResultArray($queryStr);
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-351- if (is_array($resArr) && count($resArr) == 0) {
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:352: $queryStr = "SELECT * FROM tblDocumentContentAttributes WHERE attrdef=".$this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-353- $resArr = $db->getResultArray($queryStr);
##############################################
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-375- // Delete user itself
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php:376: $queryStr = "DELETE FROM tblAttributeDefinitions WHERE id = " . $this->_id;
php-letodms-core-3.4.2/LetoDMS_Core-3.4.2/Core/inc.ClassAttribute.php-377- if (!$db->getResult($queryStr)) return false;