2 /***************************************************************
5 * (c) 1999-2010 Kasper Skårhøj (kasperYYYY@typo3.com)
8 * This script is part of the TYPO3 project. The TYPO3 project is
9 * free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 2 of the License, or
12 * (at your option) any later version.
14 * The GNU General Public License can be found at
15 * http://www.gnu.org/copyleft/gpl.html.
16 * A copy is found in the textfile GPL.txt and important notices to the license
17 * from the author is found in LICENSE.txt distributed with these scripts.
20 * This script is distributed in the hope that it will be useful,
21 * but WITHOUT ANY WARRANTY; without even the implied warranty of
22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23 * GNU General Public License for more details.
25 * This copyright notice MUST APPEAR in all copies of the script!
26 ***************************************************************/
28 * Contains an extension class specifically for authentication/initialization of backend users in TYPO3
31 * Revised for TYPO3 3.6 July/2003 by Kasper Skårhøj
33 * @author Kasper Skårhøj <kasperYYYY@typo3.com>
36 * [CLASS/FUNCTION INDEX of SCRIPT]
40 * 135: class t3lib_userAuthGroup extends t3lib_userAuth
42 * SECTION: Permission checking functions:
43 * 199: function isAdmin()
44 * 211: function isMemberOfGroup($groupId)
45 * 233: function doesUserHaveAccess($row,$perms)
46 * 250: function isInWebMount($id,$readPerms='',$exitOnError=0)
47 * 277: function modAccess($conf,$exitOnError)
48 * 328: function getPagePermsClause($perms)
49 * 367: function calcPerms($row)
50 * 405: function isRTE()
51 * 439: function check($type,$value)
52 * 456: function checkAuthMode($table,$field,$value,$authMode)
53 * 522: function checkLanguageAccess($langValue)
54 * 544: function recordEditAccessInternals($table,$idOrRow,$newRecord=FALSE)
55 * 619: function isPSet($lCP,$table,$type='')
56 * 636: function mayMakeShortcut()
57 * 650: function workspaceCannotEditRecord($table,$recData)
58 * 689: function workspaceCannotEditOfflineVersion($table,$recData)
59 * 712: function workspaceAllowLiveRecordsInPID($pid, $table)
60 * 733: function workspaceCreateNewRecord($pid, $table)
61 * 752: function workspaceAllowAutoCreation($table,$id,$recpid)
62 * 772: function workspaceCheckStageForCurrent($stage)
63 * 795: function workspacePublishAccess($wsid)
64 * 823: function workspaceSwapAccess()
65 * 835: function workspaceVersioningTypeAccess($type)
66 * 866: function workspaceVersioningTypeGetClosest($type)
68 * SECTION: Miscellaneous functions
69 * 909: function getTSConfig($objectString,$config='')
70 * 935: function getTSConfigVal($objectString)
71 * 947: function getTSConfigProp($objectString)
72 * 959: function inList($in_list,$item)
73 * 970: function returnWebmounts()
74 * 980: function returnFilemounts()
75 * 997: function jsConfirmation($bitmask)
77 * SECTION: Authentication methods
78 * 1035: function fetchGroupData()
79 * 1168: function fetchGroups($grList,$idList='')
80 * 1266: function setCachedList($cList)
81 * 1286: function addFileMount($title, $altTitle, $path, $webspace, $type)
82 * 1333: function addTScomment($str)
85 * 1369: function workspaceInit()
86 * 1412: function checkWorkspace($wsRec,$fields='uid,title,adminusers,members,reviewers,publish_access,stagechg_notification')
87 * 1487: function checkWorkspaceCurrent()
88 * 1500: function setWorkspace($workspaceId)
89 * 1528: function setWorkspacePreview($previewState)
90 * 1538: function getDefaultWorkspace()
93 * 1589: function writelog($type,$action,$error,$details_nr,$details,$data,$tablename='',$recuid='',$recpid='',$event_pid=-1,$NEWid='',$userId=0)
94 * 1621: function simplelog($message, $extKey='', $error=0)
95 * 1642: function checkLogFailures($email, $secondsBack=3600, $max=3)
98 * (This index is automatically created/updated by the extension "extdeveval")
104 * Extension to class.t3lib_userauth.php; Authentication of users in TYPO3 Backend
106 * Actually this class is extended again by t3lib_beuserauth which is the actual backend user class that will be instantiated.
107 * In fact the two classes t3lib_beuserauth and this class could just as well be one, single class since t3lib_userauthgroup is not - to my knowledge - used separately elsewhere. But for historical reasons they are two separate classes.
109 * @author Kasper Skårhøj <kasperYYYY@typo3.com>
113 class t3lib_userAuthGroup
extends t3lib_userAuth
{
114 var $usergroup_column = 'usergroup'; // Should be set to the usergroup-column (id-list) in the user-record
115 var $usergroup_table = 'be_groups'; // The name of the group-table
118 var $groupData = array( // This array holds lists of eg. tables, fields and other values related to the permission-system. See fetchGroupData
119 'filemounts' => array() // Filemounts are loaded here
121 var $workspace = -99; // User workspace. -99 is ERROR (none available), -1 is offline, 0 is online, >0 is custom workspaces.
122 var $workspaceRec = array(); // Custom workspace record if any
124 var $userGroups = array(); // This array will hold the groups that the user is a member of
125 var $userGroupsUID = array(); // This array holds the uid's of the groups in the listed order
126 var $groupList = ''; // This is $this->userGroupsUID imploded to a comma list... Will correspond to the 'usergroup_cached_list'
127 var $dataLists = array( // Used internally to accumulate data for the user-group. DONT USE THIS EXTERNALLY! Use $this->groupData instead
128 'webmount_list' => '',
129 'filemount_list' => '',
130 'fileoper_perms' => 0,
132 'tables_select' => '',
133 'tables_modify' => '',
134 'pagetypes_select' => '',
135 'non_exclude_fields' => '',
136 'explicit_allowdeny' => '',
137 'allowed_languages' => '',
138 'workspace_perms' => '',
139 'custom_options' => '',
141 var $includeHierarchy = array(); // For debugging/display of order in which subgroups are included.
142 var $includeGroupArray = array(); // List of group_id's in the order they are processed.
144 var $OS = ''; // Set to 'WIN', if windows
145 var $TSdataArray = array(); // Used to accumulate the TSconfig data of the user
146 var $userTS_text = ''; // Contains the non-parsed user TSconfig
147 var $userTS = array(); // Contains the parsed user TSconfig
148 var $userTSUpdated = 0; // Set internally if the user TSconfig was parsed and needs to be cached.
149 var $userTS_dontGetCached = 0; // Set this from outside if you want the user TSconfig to ALWAYS be parsed and not fetched from cache.
151 var $RTE_errors = array(); // RTE availability errors collected.
152 var $errorMsg = ''; // Contains last error message
154 var $checkWorkspaceCurrent_cache = NULL; // Cache for checkWorkspaceCurrent()
157 /************************************
159 * Permission checking functions:
161 ************************************/
164 * Returns true if user is admin
165 * Basically this function evaluates if the ->user[admin] field has bit 0 set. If so, user is admin.
170 return (($this->user
['admin'] & 1) == 1);
174 * Returns true if the current user is a member of group $groupId
175 * $groupId must be set. $this->groupList must contain groups
176 * Will return true also if the user is a member of a group through subgroups.
178 * @param integer Group ID to look for in $this->groupList
181 function isMemberOfGroup($groupId) {
182 $groupId = intval($groupId);
183 if ($this->groupList
&& $groupId) {
184 return $this->inList($this->groupList
, $groupId);
189 * Checks if the permissions is granted based on a page-record ($row) and $perms (binary and'ed)
191 * Bits for permissions, see $perms variable:
193 * 1 - Show: See/Copy page and the pagecontent.
194 * 16- Edit pagecontent: Change/Add/Delete/Move pagecontent.
195 * 2- Edit page: Change/Move the page, eg. change title, startdate, hidden.
196 * 4- Delete page: Delete the page and pagecontent.
197 * 8- New pages: Create new pages under the page.
199 * @param array $row is the pagerow for which the permissions is checked
200 * @param integer $perms is the binary representation of the permission we are going to check. Every bit in this number represents a permission that must be set. See function explanation.
201 * @return boolean True or False upon evaluation
203 function doesUserHaveAccess($row, $perms) {
204 $userPerms = $this->calcPerms($row);
205 return ($userPerms & $perms) == $perms;
209 * Checks if the page id, $id, is found within the webmounts set up for the user.
210 * This should ALWAYS be checked for any page id a user works with, whether it's about reading, writing or whatever.
211 * The point is that this will add the security that a user can NEVER touch parts outside his mounted pages in the page tree. This is otherwise possible if the raw page permissions allows for it. So this security check just makes it easier to make safe user configurations.
212 * If the user is admin OR if this feature is disabled (fx. by setting TYPO3_CONF_VARS['BE']['lockBeUserToDBmounts']=0) then it returns "1" right away
213 * Otherwise the function will return the uid of the webmount which was first found in the rootline of the input page $id
215 * @param integer Page ID to check
216 * @param string Content of "->getPagePermsClause(1)" (read-permissions). If not set, they will be internally calculated (but if you have the correct value right away you can save that database lookup!)
217 * @param boolean If set, then the function will exit with an error message.
218 * @return integer The page UID of a page in the rootline that matched a mount point
220 function isInWebMount($id, $readPerms = '', $exitOnError = 0) {
221 if (!$GLOBALS['TYPO3_CONF_VARS']['BE']['lockBeUserToDBmounts'] ||
$this->isAdmin()) {
226 // Check if input id is an offline version page in which case we will map id to the online version:
227 $checkRec = t3lib_beFUnc
::getRecord('pages', $id, 'pid,t3ver_oid');
228 if ($checkRec['pid'] == -1) {
229 $id = intval($checkRec['t3ver_oid']);
233 $readPerms = $this->getPagePermsClause(1);
236 $wM = $this->returnWebmounts();
237 $rL = t3lib_BEfunc
::BEgetRootLine($id, ' AND ' . $readPerms);
239 foreach ($rL as $v) {
240 if ($v['uid'] && in_array($v['uid'], $wM)) {
246 throw new RuntimeException('Access Error: This page is not within your DB-mounts');
251 * Checks access to a backend module with the $MCONF passed as first argument
253 * @param array $MCONF array of a backend module!
254 * @param boolean If set, an array will issue an error message and exit.
255 * @return boolean Will return true if $MCONF['access'] is not set at all, if the BE_USER is admin or if the module is enabled in the be_users/be_groups records of the user (specifically enabled). Will return false if the module name is not even found in $TBE_MODULES
257 function modAccess($conf, $exitOnError) {
258 if (!t3lib_BEfunc
::isModuleSetInTBE_MODULES($conf['name'])) {
260 throw new RuntimeException('Fatal Error: This module "' . $conf['name'] . '" is not enabled in TBE_MODULES');
266 if ($conf['workspaces']) {
267 if (($this->workspace
=== 0 && t3lib_div
::inList($conf['workspaces'], 'online')) ||
268 ($this->workspace
=== -1 && t3lib_div
::inList($conf['workspaces'], 'offline')) ||
269 ($this->workspace
> 0 && t3lib_div
::inList($conf['workspaces'], 'custom'))) {
273 throw new RuntimeException('Workspace Error: This module "' . $conf['name'] . '" is not available under the current workspace');
279 // Returns true if conf[access] is not set at all or if the user is admin
280 if (!$conf['access'] ||
$this->isAdmin()) {
284 // If $conf['access'] is set but not with 'admin' then we return true, if the module is found in the modList
285 if (!strstr($conf['access'], 'admin') && $conf['name']) {
286 $acs = $this->check('modules', $conf['name']);
288 if (!$acs && $exitOnError) {
289 throw new RuntimeException('Access Error: You don\'t have access to this module.');
296 * Returns a WHERE-clause for the pages-table where user permissions according to input argument, $perms, is validated.
297 * $perms is the "mask" used to select. Fx. if $perms is 1 then you'll get all pages that a user can actually see!
302 * If the user is 'admin' " 1=1" is returned (no effect)
303 * If the user is not set at all (->user is not an array), then " 1=0" is returned (will cause no selection results at all)
304 * The 95% use of this function is "->getPagePermsClause(1)" which will return WHERE clauses for *selecting* pages in backend listings - in other words this will check read permissions.
306 * @param integer Permission mask to use, see function description
307 * @return string Part of where clause. Prefix " AND " to this.
309 function getPagePermsClause($perms) {
310 global $TYPO3_CONF_VARS;
311 if (is_array($this->user
)) {
312 if ($this->isAdmin()) {
316 $perms = intval($perms); // Make sure it's integer.
318 '(pages.perms_everybody & ' . $perms . ' = ' . $perms . ')' . // Everybody
319 ' OR (pages.perms_userid = ' . $this->user
['uid'] . ' AND pages.perms_user & ' . $perms . ' = ' . $perms . ')'; // User
320 if ($this->groupList
) {
321 $str .= ' OR (pages.perms_groupid in (' . $this->groupList
. ') AND pages.perms_group & ' . $perms . ' = ' . $perms . ')'; // Group (if any is set)
326 // getPagePermsClause-HOOK
328 if (is_array($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['getPagePermsClause'])) {
330 foreach ($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['getPagePermsClause'] as $_funcRef) {
331 $_params = array('currentClause' => $str, 'perms' => $perms);
332 $str = t3lib_div
::callUserFunction($_funcRef, $_params, $this);
343 * Returns a combined binary representation of the current users permissions for the page-record, $row.
344 * The perms for user, group and everybody is OR'ed together (provided that the page-owner is the user and for the groups that the user is a member of the group
345 * If the user is admin, 31 is returned (full permissions for all five flags)
347 * @param array Input page row with all perms_* fields available.
348 * @return integer Bitwise representation of the users permissions in relation to input page row, $row
350 function calcPerms($row) {
351 global $TYPO3_CONF_VARS;
352 if ($this->isAdmin()) {
354 } // Return 31 for admin users.
357 if (isset($row['perms_userid']) && isset($row['perms_user']) && isset($row['perms_groupid']) && isset($row['perms_group']) && isset($row['perms_everybody']) && isset($this->groupList
)) {
358 if ($this->user
['uid'] == $row['perms_userid']) {
359 $out |
= $row['perms_user'];
361 if ($this->isMemberOfGroup($row['perms_groupid'])) {
362 $out |
= $row['perms_group'];
364 $out |
= $row['perms_everybody'];
370 if (is_array($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['calcPerms'])) {
371 foreach ($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['calcPerms'] as $_funcRef) {
374 'outputPermissions' => $out
376 $out = t3lib_div
::callUserFunction($_funcRef, $_params, $this);
384 * Returns true if the RTE (Rich Text Editor) can be enabled for the user
385 * Strictly this is not permissions being checked but rather a series of settings like a loaded extension, browser/client type and a configuration option in ->uc[edit_RTE]
386 * The reasons for a FALSE return can be found in $this->RTE_errors
394 $this->RTE_errors
= array();
395 if (!$this->uc
['edit_RTE']) {
396 $this->RTE_errors
[] = 'RTE is not enabled for user!';
398 if (!$GLOBALS['TYPO3_CONF_VARS']['BE']['RTEenabled']) {
399 $this->RTE_errors
[] = 'RTE is not enabled in $TYPO3_CONF_VARS["BE"]["RTEenabled"]';
403 // Acquire RTE object:
404 $RTE = t3lib_BEfunc
::RTEgetObj();
405 if (!is_object($RTE)) {
406 $this->RTE_errors
= array_merge($this->RTE_errors
, $RTE);
409 if (!count($this->RTE_errors
)) {
417 * Returns true if the $value is found in the list in a $this->groupData[] index pointed to by $type (array key).
418 * Can thus be users to check for modules, exclude-fields, select/modify permissions for tables etc.
419 * If user is admin true is also returned
420 * Please see the document Inside TYPO3 for examples.
422 * @param string The type value; "webmounts", "filemounts", "pagetypes_select", "tables_select", "tables_modify", "non_exclude_fields", "modules"
423 * @param string String to search for in the groupData-list
424 * @return boolean True if permission is granted (that is, the value was found in the groupData list - or the BE_USER is "admin")
426 function check($type, $value) {
427 if (isset($this->groupData
[$type])) {
428 if ($this->isAdmin() ||
$this->inList($this->groupData
[$type], $value)) {
436 * Checking the authMode of a select field with authMode set
438 * @param string Table name
439 * @param string Field name (must be configured in TCA and of type "select" with authMode set!)
440 * @param string Value to evaluation (single value, must not contain any of the chars ":,|")
441 * @param string Auth mode keyword (explicitAllow, explicitDeny, individual)
442 * @return boolean True or false whether access is granted or not.
444 function checkAuthMode($table, $field, $value, $authMode) {
447 // Admin users can do anything:
448 if ($this->isAdmin()) {
452 // Allow all blank values:
453 if (!strcmp($value, '')) {
457 // Certain characters are not allowed in the value
458 if (preg_match('/[:|,]/', $value)) {
463 $testValue = $table . ':' . $field . ':' . $value;
467 switch ((string) $authMode) {
468 case 'explicitAllow':
469 if (!$this->inList($this->groupData
['explicit_allowdeny'], $testValue . ':ALLOW')) {
474 if ($this->inList($this->groupData
['explicit_allowdeny'], $testValue . ':DENY')) {
479 t3lib_div
::loadTCA($table);
480 if (is_array($TCA[$table]) && is_array($TCA[$table]['columns'][$field])) {
481 $items = $TCA[$table]['columns'][$field]['config']['items'];
482 if (is_array($items)) {
483 foreach ($items as $iCfg) {
484 if (!strcmp($iCfg[1], $value) && $iCfg[4]) {
485 switch ((string) $iCfg[4]) {
487 if (!$this->inList($this->groupData
['explicit_allowdeny'], $testValue . ':ALLOW')) {
492 if ($this->inList($this->groupData
['explicit_allowdeny'], $testValue . ':DENY')) {
509 * Checking if a language value (-1, 0 and >0 for sys_language records) is allowed to be edited by the user.
511 * @param integer Language value to evaluate
512 * @return boolean Returns true if the language value is allowed, otherwise false.
514 function checkLanguageAccess($langValue) {
515 if (strcmp(trim($this->groupData
['allowed_languages']), '')) { // The users language list must be non-blank - otherwise all languages are allowed.
516 $langValue = intval($langValue);
517 if ($langValue != -1 && !$this->check('allowed_languages', $langValue)) { // Language must either be explicitly allowed OR the lang Value be "-1" (all languages)
525 * Check if user has access to all existing localizations for a certain record
527 * @param string the table
528 * @param array the current record
531 function checkFullLanguagesAccess($table, $record) {
532 $recordLocalizationAccess = $this->checkLanguageAccess(0);
533 if ($recordLocalizationAccess
535 t3lib_BEfunc
::isTableLocalizable($table)
536 ||
isset($GLOBALS['TCA'][$table]['ctrl']['transForeignTable'])
540 if (isset($GLOBALS['TCA'][$table]['ctrl']['transForeignTable'])) {
541 $l10nTable = $GLOBALS['TCA'][$table]['ctrl']['transForeignTable'];
542 $pointerField = $GLOBALS['TCA'][$l10nTable]['ctrl']['transOrigPointerField'];
543 $pointerValue = $record['uid'];
546 $pointerField = $GLOBALS['TCA'][$l10nTable]['ctrl']['transOrigPointerField'];
547 $pointerValue = $record[$pointerField] > 0 ?
$record[$pointerField] : $record['uid'];
550 $recordLocalizations = t3lib_BEfunc
::getRecordsByField(
560 if (is_array($recordLocalizations)) {
561 foreach ($recordLocalizations as $localization) {
562 $recordLocalizationAccess = $recordLocalizationAccess
563 && $this->checkLanguageAccess($localization[$GLOBALS['TCA'][$l10nTable]['ctrl']['languageField']]);
564 if (!$recordLocalizationAccess) {
571 return $recordLocalizationAccess;
575 * Checking if a user has editing access to a record from a $TCA table.
576 * The checks does not take page permissions and other "environmental" things into account. It only deal with record internals; If any values in the record fields disallows it.
577 * For instance languages settings, authMode selector boxes are evaluated (and maybe more in the future).
578 * It will check for workspace dependent access.
579 * The function takes an ID (integer) or row (array) as second argument.
581 * @param string Table name
582 * @param mixed If integer, then this is the ID of the record. If Array this just represents fields in the record.
583 * @param boolean Set, if testing a new (non-existing) record array. Will disable certain checks that doesn't make much sense in that context.
584 * @param boolean Set, if testing a deleted record array.
585 * @param boolean Set, whenever access to all translations of the record is required
586 * @return boolean True if OK, otherwise false
588 function recordEditAccessInternals($table, $idOrRow, $newRecord = FALSE, $deletedRecord = FALSE, $checkFullLanguageAccess = FALSE) {
591 if (isset($TCA[$table])) {
592 t3lib_div
::loadTCA($table);
594 // Always return true for Admin users.
595 if ($this->isAdmin()) {
599 // Fetching the record if the $idOrRow variable was not an array on input:
600 if (!is_array($idOrRow)) {
601 if ($deletedRecord) {
602 $idOrRow = t3lib_BEfunc
::getRecord($table, $idOrRow, '*', '', FALSE);
604 $idOrRow = t3lib_BEfunc
::getRecord($table, $idOrRow);
606 if (!is_array($idOrRow)) {
607 $this->errorMsg
= 'ERROR: Record could not be fetched.';
612 // Checking languages:
613 if ($TCA[$table]['ctrl']['languageField']) {
614 if (isset($idOrRow[$TCA[$table]['ctrl']['languageField']])) { // Language field must be found in input row - otherwise it does not make sense.
615 if (!$this->checkLanguageAccess($idOrRow[$TCA[$table]['ctrl']['languageField']])) {
616 $this->errorMsg
= 'ERROR: Language was not allowed.';
618 } elseif ($checkFullLanguageAccess && $idOrRow[$TCA[$table]['ctrl']['languageField']] == 0 && !$this->checkFullLanguagesAccess($table, $idOrRow)) {
619 $this->errorMsg
= 'ERROR: Related/affected language was not allowed.';
623 $this->errorMsg
= 'ERROR: The "languageField" field named "' . $TCA[$table]['ctrl']['languageField'] . '" was not found in testing record!';
626 } elseif (isset($TCA[$table]['ctrl']['transForeignTable']) && $checkFullLanguageAccess && !$this->checkFullLanguagesAccess($table, $idOrRow)) {
630 // Checking authMode fields:
631 if (is_array($TCA[$table]['columns'])) {
632 foreach ($TCA[$table]['columns'] as $fieldName => $fieldValue) {
633 if (isset($idOrRow[$fieldName])) {
634 if ($fieldValue['config']['type'] == 'select' && $fieldValue['config']['authMode'] && !strcmp($fieldValue['config']['authMode_enforce'], 'strict')) {
635 if (!$this->checkAuthMode($table, $fieldName, $idOrRow[$fieldName], $fieldValue['config']['authMode'])) {
636 $this->errorMsg
= 'ERROR: authMode "' . $fieldValue['config']['authMode'] . '" failed for field "' . $fieldName . '" with value "' . $idOrRow[$fieldName] . '" evaluated';
644 // Checking "editlock" feature (doesn't apply to new records)
645 if (!$newRecord && $TCA[$table]['ctrl']['editlock']) {
646 if (isset($idOrRow[$TCA[$table]['ctrl']['editlock']])) {
647 if ($idOrRow[$TCA[$table]['ctrl']['editlock']]) {
648 $this->errorMsg
= 'ERROR: Record was locked for editing. Only admin users can change this state.';
652 $this->errorMsg
= 'ERROR: The "editLock" field named "' . $TCA[$table]['ctrl']['editlock'] . '" was not found in testing record!';
657 // Checking record permissions
658 // THIS is where we can include a check for "perms_" fields for other records than pages...
661 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['recordEditAccessInternals'])) {
662 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['recordEditAccessInternals'] as $funcRef) {
665 'idOrRow' => $idOrRow,
666 'newRecord' => $newRecord
668 if (!t3lib_div
::callUserFunction($funcRef, $params, $this)) {
674 // Finally, return true if all is well.
680 * Checks a type of permission against the compiled permission integer, $compiledPermissions, and in relation to table, $tableName
682 * @param integer $compiledPermissions could typically be the "compiled permissions" integer returned by ->calcPerms
683 * @param string $tableName is the tablename to check: If "pages" table then edit,new,delete and editcontent permissions can be checked. Other tables will be checked for "editcontent" only (and $type will be ignored)
684 * @param string For $tableName='pages' this can be 'edit' (2), 'new' (8 or 16), 'delete' (4), 'editcontent' (16). For all other tables this is ignored. (16 is used)
686 * @access public (used by typo3/alt_clickmenu.php)
688 public function isPSet($compiledPermissions, $tableName, $actionType = '') {
689 if ($this->isAdmin()) {
692 elseif ($tableName == 'pages') {
693 switch ($actionType) {
695 $result = ($compiledPermissions & 2) !== 0;
698 // Create new page OR page content
699 $result = ($compiledPermissions & (8 +
16)) !== 0;
702 $result = ($compiledPermissions & 4) !== 0;
705 $result = ($compiledPermissions & 16) !== 0;
711 $result = ($compiledPermissions & 16) !== 0;
717 * Returns true if the BE_USER is allowed to *create* shortcuts in the backend modules
721 function mayMakeShortcut() {
722 // "Shortcuts" have been renamed to "Bookmarks"
723 // @deprecated remove shortcuts code in TYPO3 4.7
724 return ($this->getTSConfigVal('options.enableShortcuts')
725 ||
$this->getTSConfigVal('options.enableBookmarks'))
726 && (!$this->getTSConfigVal('options.mayNotCreateEditShortcuts')
727 && !$this->getTSConfigVal('options.mayNotCreateEditBookmarks'));
731 * Checking if editing of an existing record is allowed in current workspace if that is offline.
732 * Rules for editing in offline mode:
733 * - record supports versioning and is an offline version from workspace and has the corrent stage
734 * - or record (any) is in a branch where there is a page which is a version from the workspace and where the stage is not preventing records
736 * @param string Table of record
737 * @param array Integer (record uid) or array where fields are at least: pid, t3ver_wsid, t3ver_stage (if versioningWS is set)
738 * @return string String error code, telling the failure state. FALSE=All ok
740 function workspaceCannotEditRecord($table, $recData) {
742 if ($this->workspace
!== 0) { // Only test offline spaces:
744 if (!is_array($recData)) {
745 $recData = t3lib_BEfunc
::getRecord($table, $recData, 'pid' . ($GLOBALS['TCA'][$table]['ctrl']['versioningWS'] ?
',t3ver_wsid,t3ver_stage' : ''));
748 if (is_array($recData)) {
749 if ((int) $recData['pid'] === -1) { // We are testing a "version" (identified by a pid of -1): it can be edited provided that workspace matches and versioning is enabled for the table.
750 if (!$GLOBALS['TCA'][$table]['ctrl']['versioningWS']) { // No versioning, basic error, inconsistency even! Such records should not have a pid of -1!
751 return 'Versioning disabled for table';
752 } elseif ((int) $recData['t3ver_wsid'] !== $this->workspace
) { // So does workspace match?
753 return 'Workspace ID of record didn\'t match current workspace';
754 } else { // So what about the stage of the version, does that allow editing for this user?
755 return $this->workspaceCheckStageForCurrent($recData['t3ver_stage']) ?
FALSE : 'Record stage "' . $recData['t3ver_stage'] . '" and users access level did not allow for editing';
757 } else { // We are testing a "live" record:
758 if ($res = $this->workspaceAllowLiveRecordsInPID($recData['pid'], $table)) { // For "Live" records, check that PID for table allows editing
759 // Live records are OK in this branch, but what about the stage of branch point, if any:
760 return $res > 0 ?
FALSE : 'Stage for versioning root point and users access level did not allow for editing'; // OK
761 } else { // If not offline and not in versionized branch, output error:
762 return 'Online record was not in versionized branch!';
769 return FALSE; // OK because workspace is 0
774 * Evaluates if a user is allowed to edit the offline version
776 * @param string Table of record
777 * @param array Integer (record uid) or array where fields are at least: pid, t3ver_wsid, t3ver_stage (if versioningWS is set)
778 * @return string String error code, telling the failure state. FALSE=All ok
779 * @see workspaceCannotEditRecord()
781 function workspaceCannotEditOfflineVersion($table, $recData) {
782 if ($GLOBALS['TCA'][$table]['ctrl']['versioningWS']) {
784 if (!is_array($recData)) {
785 $recData = t3lib_BEfunc
::getRecord($table, $recData, 'uid,pid,t3ver_wsid,t3ver_stage');
787 if (is_array($recData)) {
788 if ((int) $recData['pid'] === -1) {
789 return $this->workspaceCannotEditRecord($table, $recData);
791 return 'Not an offline version';
797 return 'Table does not support versioning.';
802 * Check if "live" records from $table may be created or edited in this PID.
803 * If the answer is FALSE it means the only valid way to create or edit records in the PID is by versioning
804 * If the answer is 1 or 2 it means it is OK to create a record, if -1 it means that it is OK in terms of versioning because the element was within a versionized branch but NOT ok in terms of the state the root point had!
806 * @param integer PID value to check for.
807 * @param string Table name
808 * @return mixed Returns FALSE if a live record cannot be created and must be versionized in order to do so. 2 means a) Workspace is "Live" or workspace allows "live edit" of records from non-versionized tables (and the $table is not versionizable). 1 and -1 means the pid is inside a versionized branch where -1 means that the branch-point did NOT allow a new record according to its state.
810 function workspaceAllowLiveRecordsInPID($pid, $table) {
812 // Always for Live workspace AND if live-edit is enabled and tables are completely without versioning it is ok as well.
813 if ($this->workspace
=== 0 ||
($this->workspaceRec
['live_edit'] && !$GLOBALS['TCA'][$table]['ctrl']['versioningWS']) ||
$GLOBALS['TCA'][$table]['ctrl']['versioningWS_alwaysAllowLiveEdit']) {
814 return 2; // OK to create for this table.
815 } elseif (t3lib_BEfunc
::isPidInVersionizedBranch($pid, $table)) { // Check if records from $table can be created with this PID: Either if inside "branch" versioning type or a "versioning_followPages" table on a "page" versioning type.
816 // Now, check what the stage of that "page" or "branch" version type is:
817 $stage = t3lib_BEfunc
::isPidInVersionizedBranch($pid, $table, TRUE);
818 return $this->workspaceCheckStageForCurrent($stage) ?
1 : -1;
820 return FALSE; // If the answer is FALSE it means the only valid way to create or edit records in the PID is by versioning
825 * Evaluates if a record from $table can be created in $pid
827 * @param integer Page id. This value must be the _ORIG_uid if available: So when you have pages versionized as "page" or "element" you must supply the id of the page version in the workspace!
828 * @param string Table name
829 * @return boolean TRUE if OK.
831 function workspaceCreateNewRecord($pid, $table) {
832 if ($res = $this->workspaceAllowLiveRecordsInPID($pid, $table)) { // If LIVE records cannot be created in the current PID due to workspace restrictions, prepare creation of placeholder-record
834 return FALSE; // Stage for versioning root point and users access level did not allow for editing
836 } elseif (!$GLOBALS['TCA'][$table]['ctrl']['versioningWS']) { // So, if no live records were allowed, we have to create a new version of this record:
843 * Evaluates if auto creation of a version of a record is allowed.
845 * @param string Table of the record
846 * @param integer UID of record
847 * @param integer PID of record
848 * @return boolean TRUE if ok.
850 function workspaceAllowAutoCreation($table, $id, $recpid) {
851 // Auto-creation of version: In offline workspace, test if versioning is enabled and look for workspace version of input record. If there is no versionized record found we will create one and save to that.
852 if ($this->workspace
!== 0 // Only in draft workspaces
853 && !$this->workspaceRec
['disable_autocreate'] // Auto-creation must not be disabled.
854 && $GLOBALS['TCA'][$table]['ctrl']['versioningWS'] // Table must be versionizable
855 && $recpid >= 0 // The PID of the record must NOT be -1 or less (would indicate that it already was a version!)
856 && !t3lib_BEfunc
::getWorkspaceVersionOfRecord($this->workspace
, $table, $id, 'uid') // There must be no existing version of this record in workspace.
857 && !t3lib_BEfunc
::isPidInVersionizedBranch($recpid, $table)) { // PID must NOT be in a versionized branch either
863 * Checks if an element stage allows access for the user in the current workspace
864 * In workspaces 0 (Live) and -1 (Default draft) access is always granted for any stage.
865 * Admins are always allowed.
866 * An option for custom workspaces allows members to also edit when the stage is "Review"
868 * @param integer Stage id from an element: -1,0 = editing, 1 = reviewer, >1 = owner
869 * @return boolean TRUE if user is allowed access
871 function workspaceCheckStageForCurrent($stage) {
872 if ($this->isAdmin()) {
876 if ($this->workspace
> 0) {
877 $stat = $this->checkWorkspaceCurrent();
879 // Check if custom staging is activated
880 $workspaceRec = t3lib_BEfunc
::getRecord('sys_workspace', $stat['uid']);
881 if ($workspaceRec['custom_stages'] > 0 && $stage !== '0' && $stage !== '-10') {
883 // Get custom stage record
884 $workspaceStageRec = t3lib_BEfunc
::getRecord('sys_workspace_stage', $stage);
885 // Check if the user is responsible for the current stage
886 if ((t3lib_div
::inList($workspaceStageRec['responsible_persons'], 'be_users_' . $this->user
['uid'])
887 && $stat['_ACCESS'] === 'member')
888 ||
$stat['_ACCESS'] === 'owner') {
889 return TRUE; // OK for these criteria
892 // Check if the user is in a group which is responsible for the current stage
893 foreach ($this->userGroupsUID
as $groupUid) {
894 if ((t3lib_div
::inList($workspaceStageRec['responsible_persons'], 'be_groups_' . $groupUid)
895 && $stat['_ACCESS'] === 'member')
896 ||
$stat['_ACCESS'] === 'owner') {
897 return TRUE; // OK for these criteria
901 $memberStageLimit = $this->workspaceRec
['review_stage_edit'] ?
1 : 0;
902 if (($stage <= $memberStageLimit && $stat['_ACCESS'] === 'member')
903 ||
($stage <= 1 && $stat['_ACCESS'] === 'reviewer')
904 ||
$stat['_ACCESS'] === 'owner') {
905 return TRUE; // OK for these criteria
910 } // Always OK for live and draft workspaces.
914 * Returns TRUE if the user has access to publish content from the workspace ID given.
915 * Admin-users are always granted access to do this
916 * If the workspace ID is 0 (live) all users have access also
917 * If -1 (draft workspace) TRUE is returned if the user has access to the Live workspace
918 * For custom workspaces it depends on whether the user is owner OR like with draft workspace if the user has access to Live workspace.
920 * @param integer Workspace UID; -1,0,1+
921 * @return boolean Returns TRUE if the user has access to publish content from the workspace ID given.
923 function workspacePublishAccess($wsid) {
924 if ($this->isAdmin()) {
928 // If no access to workspace, of course you cannot publish!
931 $wsAccess = $this->checkWorkspace($wsid);
933 switch ($wsAccess['uid']) {
934 case 0: // Live workspace
935 $retVal = TRUE; // If access to Live workspace, no problem.
937 case -1: // Default draft workspace
938 $retVal = $this->checkWorkspace(0) ?
TRUE : FALSE; // If access to Live workspace, no problem.
940 default: // Custom workspace
941 $retVal = $wsAccess['_ACCESS'] === 'owner' ||
($this->checkWorkspace(0) && !($wsAccess['publish_access'] & 2)); // Either be an adminuser OR have access to online workspace which is OK as well as long as publishing access is not limited by workspace option.
949 * Workspace swap-mode access?
951 * @return boolean Returns TRUE if records can be swapped in the current workspace, otherwise false
953 function workspaceSwapAccess() {
954 if ($this->workspace
> 0 && (int) $this->workspaceRec
['swap_modes'] === 2) {
962 * Workspace Versioning type access. Check wether the requsted type of versioning (element/page/branch) is allowd in current workspace
963 * (element/pages/branches type of versioning can/could be set on custom workspaces on filed "vtype")
965 * @todo workspacecleanup: this seems mostly obsolete and should be removed
966 * @param integer Versioning type to evaluation: -1, 0, >1
967 * 0 = page (deprecated)
969 * >1 = branch (deprecated), indicating the "nesting" level
970 * @return boolean TRUE if OK
972 function workspaceVersioningTypeAccess($type) {
975 $type = t3lib_div
::intInRange($type, -1);
977 // Check if only element versioning is allowed:
978 if ($GLOBALS['TYPO3_CONF_VARS']['BE']['elementVersioningOnly'] && $type != -1) {
982 if ($this->workspace
> 0 && !$this->isAdmin()) {
983 $stat = $this->checkWorkspaceCurrent();
984 if ($stat['_ACCESS'] !== 'owner') {
986 switch ((int) $type) {
988 $retVal = $this->workspaceRec
['vtypes'] & 1 ?
FALSE : TRUE;
991 $retVal = $this->workspaceRec
['vtypes'] & 2 ?
FALSE : TRUE;
994 $retVal = $this->workspaceRec
['vtypes'] & 4 ?
FALSE : TRUE;
1008 * Finding "closest" versioning type, used for creation of new records.
1010 * @see workspaceVersioningTypeAccess() for hints on $type
1011 * @param integer Versioning type to evaluation: -1, 0, >1
1012 * @return integer Returning versioning type
1014 function workspaceVersioningTypeGetClosest($type) {
1015 $type = t3lib_div
::intInRange($type, -1);
1017 if ($this->workspace
> 0) {
1018 switch ((int) $type) {
1023 $type = $this->workspaceVersioningTypeAccess($type) ?
$type : -1;
1026 $type = $this->workspaceVersioningTypeAccess($type) ?
$type : ($this->workspaceVersioningTypeAccess(0) ?
0 : -1);
1034 /*************************************
1036 * Miscellaneous functions
1038 *************************************/
1041 * Returns the value/properties of a TS-object as given by $objectString, eg. 'options.dontMountAdminMounts'
1042 * Nice (general!) function for returning a part of a TypoScript array!
1044 * @param string Pointer to an "object" in the TypoScript array, fx. 'options.dontMountAdminMounts'
1045 * @param array Optional TSconfig array: If array, then this is used and not $this->userTS. If not array, $this->userTS is used.
1046 * @return array An array with two keys, "value" and "properties" where "value" is a string with the value of the objectsting and "properties" is an array with the properties of the objectstring.
1047 * @params array An array with the TypoScript where the $objectString is located. If this argument is not an array, then internal ->userTS (User TSconfig for the current BE_USER) will be used instead.
1049 function getTSConfig($objectString, $config = '') {
1050 if (!is_array($config)) {
1051 $config = $this->userTS
; // Getting Root-ts if not sent
1054 $parts = explode('.', $objectString, 2);
1057 if (count($parts) > 1 && trim($parts[1])) {
1058 // Go on, get the next level
1059 if (is_array($config[$key . '.'])) {
1060 $TSConf = $this->getTSConfig($parts[1], $config[$key . '.']);
1063 $TSConf['value'] = $config[$key];
1064 $TSConf['properties'] = $config[$key . '.'];
1071 * Returns the "value" of the $objectString from the BE_USERS "User TSconfig" array
1073 * @param string Object string, eg. "somestring.someproperty.somesubproperty"
1074 * @return string The value for that object string (object path)
1075 * @see getTSConfig()
1077 function getTSConfigVal($objectString) {
1078 $TSConf = $this->getTSConfig($objectString);
1079 return $TSConf['value'];
1083 * Returns the "properties" of the $objectString from the BE_USERS "User TSconfig" array
1085 * @param string Object string, eg. "somestring.someproperty.somesubproperty"
1086 * @return array The properties for that object string (object path) - if any
1087 * @see getTSConfig()
1089 function getTSConfigProp($objectString) {
1090 $TSConf = $this->getTSConfig($objectString);
1091 return $TSConf['properties'];
1095 * Returns true if $item is in $in_list
1097 * @param string Comma list with items, no spaces between items!
1098 * @param string The string to find in the list of items
1099 * @return string Boolean
1101 function inList($in_list, $item) {
1102 return strstr(',' . $in_list . ',', ',' . $item . ',');
1106 * Returns an array with the webmounts.
1107 * If no webmounts, and empty array is returned.
1108 * NOTICE: Deleted pages WILL NOT be filtered out! So if a mounted page has been deleted it is STILL coming out as a webmount. This is not checked due to performance.
1112 function returnWebmounts() {
1113 return (string) ($this->groupData
['webmounts']) != '' ?
explode(',', $this->groupData
['webmounts']) : array();
1117 * Returns an array with the filemounts for the user. Each filemount is represented with an array of a "name", "path" and "type".
1118 * If no filemounts an empty array is returned.
1122 function returnFilemounts() {
1123 return $this->groupData
['filemounts'];
1127 * Returns an integer bitmask that represents the permissions for file operations.
1128 * Permissions of the user and groups the user is a member of were combined by a logical OR.
1130 * Meaning of each bit:
1131 * 1 - Files: Upload,Copy,Move,Delete,Rename
1133 * 4 - Directory: Move,Delete,Rename,New
1134 * 8 - Directory: Copy
1135 * 16 - Directory: Delete recursively (rm -Rf)
1137 * @return integer File operation permission bitmask
1139 public function getFileoperationPermissions() {
1140 if ($this->isAdmin()) {
1143 return $this->groupData
['fileoper_perms'];
1148 * Returns true or false, depending if an alert popup (a javascript confirmation) should be shown
1149 * call like $GLOBALS['BE_USER']->jsConfirmation($BITMASK)
1152 * 2 - copy/move/paste
1154 * 8 - frontend editing
1155 * 128 - other (not used yet)
1157 * @param integer Bitmask
1158 * @return boolean true if the confirmation should be shown
1160 function jsConfirmation($bitmask) {
1161 $alertPopup = $GLOBALS['BE_USER']->getTSConfig('options.alertPopups');
1162 if (empty($alertPopup['value'])) {
1163 $alertPopup = 255; // default: show all warnings
1165 $alertPopup = (int) $alertPopup['value'];
1167 if (($alertPopup & $bitmask) == $bitmask) { // show confirmation
1169 } else { // don't show confirmation
1175 /*************************************
1177 * Authentication methods
1179 *************************************/
1183 * Initializes a lot of stuff like the access-lists, database-mountpoints and filemountpoints
1184 * This method is called by ->backendCheckLogin() (from extending class t3lib_beuserauth) if the backend user login has verified OK.
1185 * Generally this is required initialization of a backend user.
1189 * @see t3lib_TSparser
1191 function fetchGroupData() {
1192 if ($this->user
['uid']) {
1194 // Get lists for the be_user record and set them as default/primary values.
1195 $this->dataLists
['modList'] = $this->user
['userMods']; // Enabled Backend Modules
1196 $this->dataLists
['allowed_languages'] = $this->user
['allowed_languages']; // Add Allowed Languages
1197 $this->dataLists
['workspace_perms'] = $this->user
['workspace_perms']; // Set user value for workspace permissions.
1198 $this->dataLists
['webmount_list'] = $this->user
['db_mountpoints']; // Database mountpoints
1199 $this->dataLists
['filemount_list'] = $this->user
['file_mountpoints']; // File mountpoints
1200 $this->dataLists
['fileoper_perms'] = (int) $this->user
['fileoper_perms']; // Fileoperation permissions
1202 // Setting default User TSconfig:
1203 $this->TSdataArray
[] = $this->addTScomment('From $GLOBALS["TYPO3_CONF_VARS"]["BE"]["defaultUserTSconfig"]:') .
1204 $GLOBALS['TYPO3_CONF_VARS']['BE']['defaultUserTSconfig'];
1206 // Default TSconfig for admin-users
1207 if ($this->isAdmin()) {
1208 $this->TSdataArray
[] = $this->addTScomment('"admin" user presets:') . '
1209 admPanel.enable.all = 1
1211 if (t3lib_extMgm
::isLoaded('sys_note')) {
1212 $this->TSdataArray
[] = '
1213 // Setting defaults for sys_note author / email...
1214 TCAdefaults.sys_note.author = ' . $this->user
['realName'] . '
1215 TCAdefaults.sys_note.email = ' . $this->user
['email'] . '
1221 // Admin users has the base fileadmin dir mounted
1222 if ($this->isAdmin() && $GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir']) {
1223 $this->addFileMount($GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir'], '', PATH_site
. $GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir'], 0, '');
1226 // If userHomePath is set, we attempt to mount it
1227 if ($GLOBALS['TYPO3_CONF_VARS']['BE']['userHomePath']) {
1228 // First try and mount with [uid]_[username]
1229 $didMount = $this->addFileMount($this->user
['username'], '', $GLOBALS['TYPO3_CONF_VARS']['BE']['userHomePath'] . $this->user
['uid'] . '_' . $this->user
['username'] . $GLOBALS['TYPO3_CONF_VARS']['BE']['userUploadDir'], 0, 'user');
1231 // If that failed, try and mount with only [uid]
1232 $this->addFileMount($this->user
['username'], '', $GLOBALS['TYPO3_CONF_VARS']['BE']['userHomePath'] . $this->user
['uid'] . $GLOBALS['TYPO3_CONF_VARS']['BE']['userUploadDir'], 0, 'user');
1237 // Get the groups...
1238 # $grList = t3lib_BEfunc::getSQLselectableList($this->user[$this->usergroup_column],$this->usergroup_table,$this->usergroup_table);
1239 $grList = $GLOBALS['TYPO3_DB']->cleanIntList($this->user
[$this->usergroup_column
]); // 240203: Since the group-field never contains any references to groups with a prepended table name we think it's safe to just intExplode and re-implode - which should be much faster than the other function call.
1241 // Fetch groups will add a lot of information to the internal arrays: modules, accesslists, TSconfig etc. Refer to fetchGroups() function.
1242 $this->fetchGroups($grList);
1245 // Add the TSconfig for this specific user:
1246 $this->TSdataArray
[] = $this->addTScomment('USER TSconfig field') . $this->user
['TSconfig'];
1247 // Check include lines.
1248 $this->TSdataArray
= t3lib_TSparser
::checkIncludeLines_array($this->TSdataArray
);
1250 $this->userTS_text
= implode(LF
. '[GLOBAL]' . LF
, $this->TSdataArray
); // Imploding with "[global]" will make sure that non-ended confinements with braces are ignored.
1252 if ($GLOBALS['TYPO3_CONF_VARS']['BE']['TSconfigConditions'] && !$this->userTS_dontGetCached
) {
1253 // Perform TS-Config parsing with condition matching
1254 $parseObj = t3lib_div
::makeInstance('t3lib_TSparser_TSconfig');
1255 $res = $parseObj->parseTSconfig($this->userTS_text
, 'userTS');
1257 $this->userTS
= $res['TSconfig'];
1258 $this->userTSUpdated
= ($res['cached'] ?
0 : 1);
1261 // Parsing the user TSconfig (or getting from cache)
1262 $hash = md5('userTS:' . $this->userTS_text
);
1263 $cachedContent = t3lib_BEfunc
::getHash($hash);
1264 if (isset($cachedContent) && !$this->userTS_dontGetCached
) {
1265 $this->userTS
= unserialize($cachedContent);
1267 $parseObj = t3lib_div
::makeInstance('t3lib_TSparser');
1268 $parseObj->parse($this->userTS_text
);
1269 $this->userTS
= $parseObj->setup
;
1270 t3lib_BEfunc
::storeHash($hash, serialize($this->userTS
), 'BE_USER_TSconfig');
1272 $this->userTSUpdated
= 1;
1276 // Processing webmounts
1277 if ($this->isAdmin() && !$this->getTSConfigVal('options.dontMountAdminMounts')) { // Admin's always have the root mounted
1278 $this->dataLists
['webmount_list'] = '0,' . $this->dataLists
['webmount_list'];
1281 // Processing filemounts
1282 t3lib_div
::loadTCA('sys_filemounts');
1283 $orderBy = $GLOBALS['TCA']['sys_filemounts']['ctrl']['default_sortby'] ?
$GLOBALS['TYPO3_DB']->stripOrderBy($GLOBALS['TCA']['sys_filemounts']['ctrl']['default_sortby']) : 'sorting';
1284 $this->dataLists
['filemount_list'] = t3lib_div
::uniqueList($this->dataLists
['filemount_list']);
1285 if ($this->dataLists
['filemount_list']) {
1286 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'sys_filemounts', 'deleted=0 AND hidden=0 AND pid=0 AND uid IN (' . $this->dataLists
['filemount_list'] . ')', '', $orderBy);
1287 while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
1288 $this->addFileMount($row['title'], $row['path'], $row['path'], $row['base'] ?
1 : 0, '');
1292 // The lists are cleaned for duplicates
1293 $this->groupData
['webmounts'] = t3lib_div
::uniqueList($this->dataLists
['webmount_list']);
1294 $this->groupData
['pagetypes_select'] = t3lib_div
::uniqueList($this->dataLists
['pagetypes_select']);
1295 $this->groupData
['tables_select'] = t3lib_div
::uniqueList($this->dataLists
['tables_modify'] . ',' . $this->dataLists
['tables_select']);
1296 $this->groupData
['tables_modify'] = t3lib_div
::uniqueList($this->dataLists
['tables_modify']);
1297 $this->groupData
['non_exclude_fields'] = t3lib_div
::uniqueList($this->dataLists
['non_exclude_fields']);
1298 $this->groupData
['explicit_allowdeny'] = t3lib_div
::uniqueList($this->dataLists
['explicit_allowdeny']);
1299 $this->groupData
['allowed_languages'] = t3lib_div
::uniqueList($this->dataLists
['allowed_languages']);
1300 $this->groupData
['custom_options'] = t3lib_div
::uniqueList($this->dataLists
['custom_options']);
1301 $this->groupData
['modules'] = t3lib_div
::uniqueList($this->dataLists
['modList']);
1302 $this->groupData
['fileoper_perms'] = $this->dataLists
['fileoper_perms'];
1303 $this->groupData
['workspace_perms'] = $this->dataLists
['workspace_perms'];
1305 // populating the $this->userGroupsUID -array with the groups in the order in which they were LAST included.!!
1306 $this->userGroupsUID
= array_reverse(array_unique(array_reverse($this->includeGroupArray
)));
1308 // Finally this is the list of group_uid's in the order they are parsed (including subgroups!) and without duplicates (duplicates are presented with their last entrance in the list, which thus reflects the order of the TypoScript in TSconfig)
1309 $this->groupList
= implode(',', $this->userGroupsUID
);
1310 $this->setCachedList($this->groupList
);
1312 // Checking read access to webmounts:
1313 if (trim($this->groupData
['webmounts']) !== '') {
1314 $webmounts = explode(',', $this->groupData
['webmounts']); // Explode mounts
1315 $MProws = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('uid', 'pages', 'deleted=0 AND uid IN (' . $this->groupData
['webmounts'] . ') AND ' . $this->getPagePermsClause(1), '', '', '', 'uid'); // Selecting all webmounts with permission clause for reading
1316 foreach ($webmounts as $idx => $mountPointUid) {
1317 if ($mountPointUid > 0 && !isset($MProws[$mountPointUid])) { // If the mount ID is NOT found among selected pages, unset it:
1318 unset($webmounts[$idx]);
1321 $this->groupData
['webmounts'] = implode(',', $webmounts); // Implode mounts in the end.
1324 // Setting up workspace situation (after webmounts are processed!):
1325 $this->workspaceInit();
1330 * Fetches the group records, subgroups and fills internal arrays.
1331 * Function is called recursively to fetch subgroups
1333 * @param string Commalist of be_groups uid numbers
1334 * @param string List of already processed be_groups-uids so the function will not fall into a eternal recursion.
1338 function fetchGroups($grList, $idList = '') {
1339 global $TYPO3_CONF_VARS;
1341 // Fetching records of the groups in $grList (which are not blocked by lockedToDomain either):
1342 $lockToDomain_SQL = ' AND (lockToDomain=\'\' OR lockToDomain IS NULL OR lockToDomain=\'' . t3lib_div
::getIndpEnv('HTTP_HOST') . '\')';
1343 $whereSQL = 'deleted=0 AND hidden=0 AND pid=0 AND uid IN (' . $grList . ')' . $lockToDomain_SQL;
1345 // Hook for manipulation of the WHERE sql sentence which controls which BE-groups are included
1346 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['fetchGroupQuery'])) {
1347 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['fetchGroupQuery'] as $classRef) {
1348 $hookObj = t3lib_div
::getUserObj($classRef);
1349 if (method_exists($hookObj, 'fetchGroupQuery_processQuery')) {
1350 $whereSQL = $hookObj->fetchGroupQuery_processQuery($this, $grList, $idList, $whereSQL);
1355 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', $this->usergroup_table
, $whereSQL);
1357 // The userGroups array is filled
1358 while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
1359 $this->userGroups
[$row['uid']] = $row;
1362 // Traversing records in the correct order
1363 $include_staticArr = t3lib_div
::intExplode(',', $grList);
1365 foreach ($include_staticArr as $key => $uid) {
1368 $row = $this->userGroups
[$uid];
1369 if (is_array($row) && !t3lib_div
::inList($idList, $uid)) { // Must be an array and $uid should not be in the idList, because then it is somewhere previously in the grouplist
1371 // Include sub groups
1372 if (trim($row['subgroup'])) {
1373 $theList = implode(',', t3lib_div
::intExplode(',', $row['subgroup'])); // Make integer list
1374 $this->fetchGroups($theList, $idList . ',' . $uid); // Call recursively, pass along list of already processed groups so they are not recursed again.
1376 // Add the group uid, current list, TSconfig to the internal arrays.
1377 $this->includeGroupArray
[] = $uid;
1378 $this->includeHierarchy
[] = $idList;
1379 $this->TSdataArray
[] = $this->addTScomment('Group "' . $row['title'] . '" [' . $row['uid'] . '] TSconfig field:') . $row['TSconfig'];
1381 // Mount group database-mounts
1382 if (($this->user
['options'] & 1) == 1) {
1383 $this->dataLists
['webmount_list'] .= ',' . $row['db_mountpoints'];
1386 // Mount group file-mounts
1387 if (($this->user
['options'] & 2) == 2) {
1388 $this->dataLists
['filemount_list'] .= ',' . $row['file_mountpoints'];
1391 // Mount group home-dirs
1392 if (($this->user
['options'] & 2) == 2) {
1393 // If groupHomePath is set, we attempt to mount it
1394 if ($GLOBALS['TYPO3_CONF_VARS']['BE']['groupHomePath']) {
1395 $this->addFileMount($row['title'], '', $GLOBALS['TYPO3_CONF_VARS']['BE']['groupHomePath'] . $row['uid'], 0, 'group');
1399 // The lists are made: groupMods, tables_select, tables_modify, pagetypes_select, non_exclude_fields, explicit_allowdeny, allowed_languages, custom_options
1400 if ($row['inc_access_lists'] == 1) {
1401 $this->dataLists
['modList'] .= ',' . $row['groupMods'];
1402 $this->dataLists
['tables_select'] .= ',' . $row['tables_select'];
1403 $this->dataLists
['tables_modify'] .= ',' . $row['tables_modify'];
1404 $this->dataLists
['pagetypes_select'] .= ',' . $row['pagetypes_select'];
1405 $this->dataLists
['non_exclude_fields'] .= ',' . $row['non_exclude_fields'];
1406 $this->dataLists
['explicit_allowdeny'] .= ',' . $row['explicit_allowdeny'];
1407 $this->dataLists
['allowed_languages'] .= ',' . $row['allowed_languages'];
1408 $this->dataLists
['custom_options'] .= ',' . $row['custom_options'];
1411 // Setting fileoperation permissions
1412 $this->dataLists
['fileoper_perms'] |
= (int) $row['fileoper_perms'];
1414 // Setting workspace permissions:
1415 $this->dataLists
['workspace_perms'] |
= $row['workspace_perms'];
1417 // If this function is processing the users OWN group-list (not subgroups) AND if the ->firstMainGroup is not set, then the ->firstMainGroup will be set.
1418 if (!strcmp($idList, '') && !$this->firstMainGroup
) {
1419 $this->firstMainGroup
= $uid;
1425 // HOOK: fetchGroups_postProcessing
1427 if (is_array($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['fetchGroups_postProcessing'])) {
1428 foreach ($TYPO3_CONF_VARS['SC_OPTIONS']['t3lib/class.t3lib_userauthgroup.php']['fetchGroups_postProcessing'] as $_funcRef) {
1430 t3lib_div
::callUserFunction($_funcRef, $_params, $this);
1436 * Updates the field be_users.usergroup_cached_list if the groupList of the user has changed/is different from the current list.
1437 * The field "usergroup_cached_list" contains the list of groups which the user is a member of. After authentication (where these functions are called...) one can depend on this list being a representation of the exact groups/subgroups which the BE_USER has membership with.
1439 * @param string The newly compiled group-list which must be compared with the current list in the user record and possibly stored if a difference is detected.
1443 function setCachedList($cList) {
1444 if ((string) $cList != (string) $this->user
['usergroup_cached_list']) {
1445 $GLOBALS['TYPO3_DB']->exec_UPDATEquery('be_users', 'uid=' . intval($this->user
['uid']), array('usergroup_cached_list' => $cList));
1450 * Adds a filemount to the users array of filemounts, $this->groupData['filemounts'][hash_key] = Array ('name'=>$name, 'path'=>$path, 'type'=>$type);
1451 * Is a part of the authentication proces of the user.
1452 * A final requirement for a path being mounted is that a) it MUST return true on is_dir(), b) must contain either PATH_site+'fileadminDir' OR 'lockRootPath' - if lockRootPath is set - as first part of string!
1453 * Paths in the mounted information will always be absolute and have a trailing slash.
1455 * @param string $title will be the (root)name of the filemount in the folder tree
1456 * @param string $altTitle will be the (root)name of the filemount IF $title is not true (blank or zero)
1457 * @param string $path is the path which should be mounted. Will accept backslash in paths on windows servers (will substituted with forward slash). The path should be 1) relative to TYPO3_CONF_VARS[BE][fileadminDir] if $webspace is set, otherwise absolute.
1458 * @param boolean If $webspace is set, the $path is relative to 'fileadminDir' in TYPO3_CONF_VARS, otherwise $path is absolute. 'fileadminDir' must be set to allow mounting of relative paths.
1459 * @param string Type of filemount; Can be blank (regular) or "user" / "group" (for user and group filemounts presumably). Probably sets the icon first and foremost.
1460 * @return boolean Returns "1" if the requested filemount was mounted, otherwise no return value.
1463 function addFileMount($title, $altTitle, $path, $webspace, $type) {
1464 // Return false if fileadminDir is not set and we try to mount a relative path
1465 if ($webspace && !$GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir']) {
1469 // Trimming and pre-processing
1470 $path = trim($path);
1471 if ($this->OS
== 'WIN') { // with WINDOWS convert backslash to slash!!
1472 $path = str_replace('\\', '/', $path);
1474 // If the path is true and validates as a valid path string:
1475 if ($path && t3lib_div
::validPathStr($path)) {
1476 // normalize path: remove leading '/' and './', and trailing '/' and '/.'
1477 $path = trim($path);
1478 $path = preg_replace('#^\.?/|/\.?$#', '', $path);
1480 if ($path) { // there must be some chars in the path
1481 $fdir = PATH_site
. $GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir']; // fileadmin dir, absolute
1483 $path = $fdir . $path; // PATH_site + fileadmin dir is prepended
1485 if ($this->OS
!= 'WIN') { // with WINDOWS no prepending!!
1486 $path = '/' . $path; // root-level is the start...
1491 // We now have a path with slash after and slash before (if unix)
1492 if (@is_dir
($path) &&
1493 (($GLOBALS['TYPO3_CONF_VARS']['BE']['lockRootPath'] && t3lib_div
::isFirstPartOfStr($path, $GLOBALS['TYPO3_CONF_VARS']['BE']['lockRootPath'])) || t3lib_div
::isFirstPartOfStr($path, $fdir))) {
1494 // Alternative title?
1495 $name = $title ?
$title : $altTitle;
1496 // Adds the filemount. The same filemount with same name, type and path cannot be set up twice because of the hash string used as key.
1497 $this->groupData
['filemounts'][md5($name . '|' . $path . '|' . $type)] = array('name' => $name, 'path' => $path, 'type' => $type);
1498 // Return true - went well, success!
1506 * Creates a TypoScript comment with the string text inside.
1508 * @param string The text to wrap in comment prefixes and delimiters.
1509 * @return string TypoScript comment with the string text inside.
1511 function addTScomment($str) {
1512 $delimiter = '# ***********************************************';
1514 $out = $delimiter . LF
;
1515 $lines = t3lib_div
::trimExplode(LF
, $str);
1516 foreach ($lines as $v) {
1517 $out .= '# ' . $v . LF
;
1519 $out .= $delimiter . LF
;
1524 /************************************
1528 ************************************/
1531 * Initializing workspace.
1532 * Called from within this function, see fetchGroupData()
1535 * @see fetchGroupData()
1537 function workspaceInit() {
1539 // Initializing workspace by evaluating and setting the workspace, possibly updating it in the user record!
1540 $this->setWorkspace($this->user
['workspace_id']);
1542 // Limiting the DB mountpoints if there any selected in the workspace record
1543 $dbMountpoints = trim($this->workspaceRec
['db_mountpoints']);
1544 if ($this->workspace
> 0 && $dbMountpoints != '') {
1545 $filteredDbMountpoints = array();
1546 $readPerms = '1=1'; // Notice: We cannot call $this->getPagePermsClause(1); as usual because the group-list is not available at this point. But bypassing is fine because all we want here is check if the workspace mounts are inside the current webmounts rootline. The actual permission checking on page level is done elsewhere as usual anyway before the page tree is rendered.
1548 // Traverse mount points of the
1549 $dbMountpoints = t3lib_div
::intExplode(',', $dbMountpoints);
1550 foreach ($dbMountpoints as $mpId) {
1551 if ($this->isInWebMount($mpId, $readPerms)) {
1552 $filteredDbMountpoints[] = $mpId;
1556 // Re-insert webmounts:
1557 $filteredDbMountpoints = array_unique($filteredDbMountpoints);
1558 $this->groupData
['webmounts'] = implode(',', $filteredDbMountpoints);
1561 // Filtering the file mountpoints
1562 // if there some selected in the workspace record
1563 if ($this->workspace
!== 0) {
1564 $usersFileMounts = $this->groupData
['filemounts'];
1565 $this->groupData
['filemounts'] = array();
1567 $fileMountpoints = trim($this->workspaceRec
['file_mountpoints']);
1568 if ($this->workspace
> 0) {
1570 // no custom filemounts that should serve as filter
1571 // so all user mountpoints are re-applied
1572 if ($fileMountpoints === '') {
1573 $this->groupData
['filemounts'] = $usersFileMounts;
1575 // Fetching all filemounts from the workspace
1576 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
1579 'deleted = 0 AND hidden = 0 AND pid = 0 AND uid IN (' . $GLOBALS['TYPO3_DB']->cleanIntList($fileMountpoints) . ')'
1582 while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
1583 // add every filemount of this workspace record
1584 $this->addFileMount($row['title'], $row['path'], $row['path'], ($row['base'] ?
1 : 0), '');
1586 // get the added entry, and check if it was in the users' original filemounts
1587 // if not, remove it from the new filemount list again
1588 // see self::addFileMount
1589 end($this->groupData
['filemounts']);
1590 $md5hash = key($this->groupData
['filemounts']);
1591 if (!array_key_exists($md5hash, $usersFileMounts)) {
1592 unset($this->groupData
['filemounts'][$md5hash]);
1598 if ($allowed_languages = $this->getTSConfigVal('options.workspaces.allowed_languages.' . $this->workspace
)) {
1599 $this->groupData
['allowed_languages'] = $allowed_languages;
1600 $this->groupData
['allowed_languages'] = t3lib_div
::uniqueList($this->groupData
['allowed_languages']);
1605 * Checking if a workspace is allowed for backend user
1607 * @param mixed If integer, workspace record is looked up, if array it is seen as a Workspace record with at least uid, title, members and adminusers columns. Can be faked for workspaces uid 0 and -1 (online and offline)
1608 * @param string List of fields to select. Default fields are: uid,title,adminusers,members,reviewers,publish_access,stagechg_notification
1609 * @return array TRUE if access. Output will also show how access was granted. Admin users will have a true output regardless of input.
1611 function checkWorkspace($wsRec, $fields = 'uid,title,adminusers,members,reviewers,publish_access,stagechg_notification') {
1614 // Show draft workspace only if it's enabled in version extension
1615 if (t3lib_extMgm
::isLoaded('version')) {
1616 $versionExtConf = unserialize($GLOBALS['TYPO3_CONF_VARS']['EXT']['extConf']['version']);
1617 if (!$versionExtConf['showDraftWorkspace']) {
1618 if (!is_array($wsRec)) {
1619 if ((string) $wsRec === '-1') {
1623 if ((string) $wsRec['uid'] === '-1') {
1630 // If not array, look up workspace record:
1631 if (!is_array($wsRec)) {
1632 switch ((string) $wsRec) {
1635 $wsRec = array('uid' => $wsRec);
1638 list($wsRec) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
1641 'pid=0 AND uid=' . intval($wsRec) .
1642 t3lib_BEfunc
::deleteClause('sys_workspace'),
1650 // If wsRec is set to an array, evaluate it:
1651 if (is_array($wsRec)) {
1652 if ($this->isAdmin()) {
1653 return array_merge($wsRec, array('_ACCESS' => 'admin'));
1656 switch ((string) $wsRec['uid']) {
1658 $retVal = ($this->groupData
['workspace_perms'] & 1) ?
array_merge($wsRec, array('_ACCESS' => 'online')) : FALSE;
1661 $retVal = ($this->groupData
['workspace_perms'] & 2) ?
array_merge($wsRec, array('_ACCESS' => 'offline')) : FALSE;
1664 // Checking if the guy is admin:
1665 if (t3lib_div
::inList($wsRec['adminusers'], 'be_users_' . $this->user
['uid'])) {
1666 return array_merge($wsRec, array('_ACCESS' => 'owner'));
1668 // Checking if he is owner through a user group of his:
1669 foreach ($this->userGroupsUID
as $groupUid) {
1670 if (t3lib_div
::inList($wsRec['adminusers'], 'be_groups_' . $groupUid)) {
1671 return array_merge($wsRec, array('_ACCESS' => 'owner'));
1674 // Checking if he is reviewer user:
1675 if (t3lib_div
::inList($wsRec['reviewers'], 'be_users_' . $this->user
['uid'])) {
1676 return array_merge($wsRec, array('_ACCESS' => 'reviewer'));
1678 // Checking if he is reviewer through a user group of his:
1679 foreach ($this->userGroupsUID
as $groupUid) {
1680 if (t3lib_div
::inList($wsRec['reviewers'], 'be_groups_' . $groupUid)) {
1681 return array_merge($wsRec, array('_ACCESS' => 'reviewer'));
1684 // Checking if he is member as user:
1685 if (t3lib_div
::inList($wsRec['members'], 'be_users_' . $this->user
['uid'])) {
1686 return array_merge($wsRec, array('_ACCESS' => 'member'));
1688 // Checking if he is member through a user group of his:
1689 foreach ($this->userGroupsUID
as $groupUid) {
1690 if (t3lib_div
::inList($wsRec['members'], 'be_groups_' . $groupUid)) {
1691 return array_merge($wsRec, array('_ACCESS' => 'member'));
1703 * Uses checkWorkspace() to check if current workspace is available for user. This function caches the result and so can be called many times with no performance loss.
1705 * @return array See checkWorkspace()
1706 * @see checkWorkspace()
1708 function checkWorkspaceCurrent() {
1709 if (!isset($this->checkWorkspaceCurrent_cache
)) {
1710 $this->checkWorkspaceCurrent_cache
= $this->checkWorkspace($this->workspace
);
1712 return $this->checkWorkspaceCurrent_cache
;
1716 * Setting workspace ID
1718 * @param integer ID of workspace to set for backend user. If not valid the default workspace for BE user is found and set.
1721 function setWorkspace($workspaceId) {
1723 // Check workspace validity and if not found, revert to default workspace.
1724 if ($this->workspaceRec
= $this->checkWorkspace($workspaceId, '*')) {
1725 // Set workspace ID internally
1726 $this->workspace
= (int) $workspaceId;
1728 $this->workspace
= (int) $this->getDefaultWorkspace();
1729 $this->workspaceRec
= $this->checkWorkspace($this->workspace
, '*');
1732 // Unset access cache:
1733 unset($this->checkWorkspaceCurrent_cache
);
1735 // If ID is different from the stored one, change it:
1736 if (strcmp($this->workspace
, $this->user
['workspace_id'])) {
1737 $this->user
['workspace_id'] = $this->workspace
;
1738 $GLOBALS['TYPO3_DB']->exec_UPDATEquery('be_users', 'uid=' . intval($this->user
['uid']), array('workspace_id' => $this->user
['workspace_id']));
1739 $this->simplelog('User changed workspace to "' . $this->workspace
. '"');
1744 * Setting workspace preview state for user:
1746 * @param boolean State of user preview.
1749 function setWorkspacePreview($previewState) {
1750 $this->user
['workspace_preview'] = $previewState;
1751 $GLOBALS['TYPO3_DB']->exec_UPDATEquery('be_users', 'uid=' . intval($this->user
['uid']), array('workspace_preview' => $this->user
['workspace_preview']));
1755 * Return default workspace ID for user
1757 * @return integer Default workspace id. If no workspace is available it will be "-99"
1759 function getDefaultWorkspace() {
1761 if ($this->checkWorkspace(0)) { // Check online
1763 } elseif ($this->checkWorkspace(-1)) { // Check offline
1765 } else { // Traverse custom workspaces:
1766 $workspaces = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('uid,title,adminusers,members,reviewers', 'sys_workspace', 'pid=0' . t3lib_BEfunc
::deleteClause('sys_workspace'), '', 'title');
1767 foreach ($workspaces as $rec) {
1768 if ($this->checkWorkspace($rec)) {
1777 /************************************
1781 ************************************/
1784 * Writes an entry in the logfile/table
1785 * Documentation in "TYPO3 Core API"
1787 * @param integer Denotes which module that has submitted the entry. See "TYPO3 Core API". Use "4" for extensions.
1788 * @param integer Denotes which specific operation that wrote the entry. Use "0" when no sub-categorizing applies
1789 * @param integer Flag. 0 = message, 1 = error (user problem), 2 = System Error (which should not happen), 3 = security notice (admin)
1790 * @param integer The message number. Specific for each $type and $action. This will make it possible to translate errormessages to other languages
1791 * @param string Default text that follows the message (in english!). Possibly translated by identification through type/action/details_nr
1792 * @param array Data that follows the log. Might be used to carry special information. If an array the first 5 entries (0-4) will be sprintf'ed with the details-text
1793 * @param string Table name. Special field used by tce_main.php.
1794 * @param integer Record UID. Special field used by tce_main.php.
1795 * @param integer Record PID. Special field used by tce_main.php. OBSOLETE
1796 * @param integer The page_uid (pid) where the event occurred. Used to select log-content for specific pages.
1797 * @param string Special field used by tce_main.php. NEWid string of newly created records.
1798 * @param integer Alternative Backend User ID (used for logging login actions where this is not yet known).
1799 * @return integer Log entry ID.
1801 function writelog($type, $action, $error, $details_nr, $details, $data, $tablename = '', $recuid = '', $recpid = '', $event_pid = -1, $NEWid = '', $userId = 0) {
1803 $fields_values = array(
1804 'userid' => $userId ?
$userId : intval($this->user
['uid']),
1805 'type' => intval($type),
1806 'action' => intval($action),
1807 'error' => intval($error),
1808 'details_nr' => intval($details_nr),
1809 'details' => $details,
1810 'log_data' => serialize($data),
1811 'tablename' => $tablename,
1812 'recuid' => intval($recuid),
1813 # 'recpid' => intval($recpid),
1814 'IP' => t3lib_div
::getIndpEnv('REMOTE_ADDR'),
1815 'tstamp' => $GLOBALS['EXEC_TIME'],
1816 'event_pid' => intval($event_pid),
1818 'workspace' => $this->workspace
1821 $GLOBALS['TYPO3_DB']->exec_INSERTquery('sys_log', $fields_values);
1822 return $GLOBALS['TYPO3_DB']->sql_insert_id();
1826 * Simple logging function
1828 * @param string Log message
1829 * @param string Option extension key / module name
1830 * @param integer Error level. 0 = message, 1 = error (user problem), 2 = System Error (which should not happen), 3 = security notice (admin)
1831 * @return integer Log entry UID
1833 function simplelog($message, $extKey = '', $error = 0) {
1834 return $this->writelog(
1839 ($extKey ?
'[' . $extKey . '] ' : '') . $message,
1845 * Sends a warning to $email if there has been a certain amount of failed logins during a period.
1846 * If a login fails, this function is called. It will look up the sys_log to see if there has been more than $max failed logins the last $secondsBack seconds (default 3600). If so, an email with a warning is sent to $email.
1848 * @param string Email address
1849 * @param integer Number of sections back in time to check. This is a kind of limit for how many failures an hour for instance.
1850 * @param integer Max allowed failures before a warning mail is sent
1854 function checkLogFailures($email, $secondsBack = 3600, $max = 3) {
1858 // get last flag set in the log for sending
1859 $theTimeBack = $GLOBALS['EXEC_TIME'] - $secondsBack;
1860 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
1863 'type=255 AND action=4 AND tstamp>' . intval($theTimeBack),
1868 if ($testRow = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
1869 $theTimeBack = $testRow['tstamp'];
1872 // Check for more than $max number of error failures with the last period.
1873 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
1876 'type=255 AND action=3 AND error!=0 AND tstamp>' . intval($theTimeBack),
1880 if ($GLOBALS['TYPO3_DB']->sql_num_rows($res) > $max) {
1881 // OK, so there were more than the max allowed number of login failures - so we will send an email then.
1882 $subject = 'TYPO3 Login Failure Warning (at ' . $GLOBALS['TYPO3_CONF_VARS']['SYS']['sitename'] . ')';
1884 There has been numerous attempts (' . $GLOBALS['TYPO3_DB']->sql_num_rows($res) . ') to login at the TYPO3
1885 site "' . $GLOBALS['TYPO3_CONF_VARS']['SYS']['sitename'] . '" (' . t3lib_div
::getIndpEnv('HTTP_HOST') . ').
1887 This is a dump of the failures:
1890 while ($testRows = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
1891 $theData = unserialize($testRows['log_data']);
1892 $email_body .= date($GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'] . ' ' . $GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'], $testRows['tstamp']) . ': ' . @sprintf
($testRows['details'], '' . $theData[0], '' . $theData[1], '' . $theData[2]);
1895 t3lib_utility_Mail
::mail($email,
1898 'From: TYPO3 Login WARNING<>'
1900 $this->writelog(255, 4, 0, 3, 'Failure warning (%s failures within %s seconds) sent by email to %s', array($GLOBALS['TYPO3_DB']->sql_num_rows($res), $secondsBack, $email)); // Logout written to log
1907 if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE
]['XCLASS']['t3lib/class.t3lib_userauthgroup.php']) {
1908 include_once($TYPO3_CONF_VARS[TYPO3_MODE
]['XCLASS']['t3lib/class.t3lib_userauthgroup.php']);