Date,Page,Function,Message
"2016-07-13 17:34:40",“Userdata”,“entries”,“SQL:
SELECT user
.userId, userName, userTypeId, loggedIn, email, homePage, lastAccessed, newUserWizard, retired, userGroups
.groupId, userGroups
.libraryQuota
FROM user
LEFT OUTER JOIN (
SELECT group
.groupId, group
.libraryQuota, lkusergroup
.userId
FROM lkusergroup
INNER JOIN group
ON group
.groupId = lkusergroup
.groupId
AND group
.isUserSpecific = 1
) userGroups
ON userGroups.userId = user
.userId
WHERE 1 = 1
AND user.retired = :retired ORDER BY username. Params: array (
‘retired’ => 0,
).”
“2016-07-13 17:34:35”,“User”,“DisplayList”,“SQL: SELECT display.displayid, display.display, displaygroup.description, layout.layout, display.loggedin, IFNULL(display.lastaccessed, 0) AS lastaccessed, display.inc_schedule, display.licensed, display.email_alert, displaygroup.DisplayGroupID, display.ClientAddress, display.MediaInventoryStatus, display.MacAddress, display.client_type, display.client_version, display.client_code, display.screenShotRequested, display.storageAvailableSpace, display.storageTotalSpace, currentLayout.layout AS currentLayout, currentLayout.layoutId AS currentLayoutId FROM display INNER JOIN lkdisplaydg ON lkdisplaydg.DisplayID = display.DisplayID INNER JOIN displaygroup ON displaygroup.DisplayGroupID = lkdisplaydg.DisplayGroupID LEFT OUTER JOIN layout ON layout.layoutid = display.defaultlayoutid LEFT OUTER JOIN layout currentLayout ON currentLayout.layoutId = display.currentLayoutId WHERE displaygroup.IsDisplaySpecific = 1 ORDER BY display. Params: array (
).”
Display Dump
DisplayID: 2
Display: 4-PC
Default Layout: PG_first
Logged In: 1
Last Accessed: 1468424071
Interleave: 0
Licensed: 1
DisplayID: 3
Display: ITZINW700136
Default Layout: PG_first
Logged In: 0
Last Accessed: 1468332852
Interleave: 0
Licensed: 1
Settings Dump
Setting: MEDIA_DEFAULT - Value: public
Setting: LAYOUT_DEFAULT - Value: private
Setting: defaultUsertype - Value: User
Setting: userModule - Value: module_user_general.php
Setting: defaultTimezone - Value: Europe/Rome
Setting: mail_to - Value: simeone.colardo@volvo.com
Setting: mail_from - Value: simeone.colardo@volvo.com
Setting: jpg_length - Value: 0
Setting: ppt_length - Value: 0
Setting: swf_length - Value: 0
Setting: audit - Value: audit
Setting: LIBRARY_LOCATION - Value: upload/
Setting: HELP_BASE - Value: http://www.xibo.org.uk/manual/en/
Setting: PHONE_HOME - Value: On
Setting: PHONE_HOME_URL - Value: http://www.xibo.org.uk/stats/track.php
Setting: PHONE_HOME_DATE - Value: 1468410135
Setting: SERVER_MODE - Value: Production
Setting: MAINTENANCE_ENABLED - Value: Off
Setting: MAINTENANCE_EMAIL_ALERTS - Value: On
Setting: MAINTENANCE_KEY - Value: changeme
Setting: MAINTENANCE_LOG_MAXAGE - Value: 30
Setting: MAINTENANCE_STAT_MAXAGE - Value: 30
Setting: MAINTENANCE_ALERT_TOUT - Value: 30
Setting: SHOW_DISPLAY_AS_VNCLINK - Value:
Setting: SHOW_DISPLAY_AS_VNC_TGT - Value: _top
Setting: MAINTENANCE_ALWAYS_ALERT - Value: On
Setting: SCHEDULE_LOOKAHEAD - Value: On
Setting: REQUIRED_FILES_LOOKAHEAD - Value: 172800
Setting: REGION_OPTIONS_COLOURING - Value: Media Colouring
Setting: LAYOUT_COPY_MEDIA_CHECKB - Value: Unchecked
Setting: MAX_LICENSED_DISPLAYS - Value: 0
Setting: LIBRARY_MEDIA_UPDATEINALL_CHECKB - Value: Unchecked
Setting: USER_PASSWORD_POLICY - Value:
Setting: USER_PASSWORD_ERROR - Value:
Setting: MODULE_CONFIG_LOCKED_CHECKB - Value: Unchecked
Setting: LIBRARY_SIZE_LIMIT_KB - Value: 0
Setting: MONTHLY_XMDS_TRANSFER_LIMIT_KB - Value: 0
Setting: DEFAULT_LANGUAGE - Value: en_GB
Setting: TRANSITION_CONFIG_LOCKED_CHECKB - Value: Unchecked
Setting: GLOBAL_THEME_NAME - Value: default
Setting: DEFAULT_LAT - Value: 51.504
Setting: DEFAULT_LONG - Value: -0.104
Setting: SCHEDULE_WITH_VIEW_PERMISSION - Value: Yes
Setting: SETTING_IMPORT_ENABLED - Value: 1
Setting: SETTING_LIBRARY_TIDY_ENABLED - Value: 1
Setting: SENDFILE_MODE - Value: Off
Setting: EMBEDDED_STATUS_WIDGET - Value:
Setting: PROXY_HOST - Value:
Setting: PROXY_PORT - Value: 0
Setting: PROXY_AUTH - Value:
Setting: DATE_FORMAT - Value: Y-m-d H:i
Setting: DETECT_LANGUAGE - Value: 1
Setting: DEFAULTS_IMPORTED - Value: 1
Setting: FORCE_HTTPS - Value: 0
Setting: ISSUE_STS - Value: 0
Setting: STS_TTL - Value: 600
Setting: MAINTENANCE_ALERTS_FOR_VIEW_USERS - Value: 0
Setting: CALENDAR_TYPE - Value: Gregorian
Setting: DASHBOARD_LATEST_NEWS_ENABLED - Value: 1
Setting: LIBRARY_MEDIA_DELETEOLDVER_CHECKB - Value: Unchecked
Setting: USE_INTL_DATEFORMAT - Value: 0
Setting: PROXY_EXCEPTIONS - Value:
Setting: CDN_URL - Value: