=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ 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;