Export - CSV (All fields)
Export - CSV (Current fields)
PHPBB-17502
Remove sid's from URL'sPHPBB-17484
Efficiency of Guest Sessions Needs Improvement
Add support for stateless routes
Automatically set the secure cookie option based on connection type rather than require ACP settingPHPBB-17375
User lastvisit gets updated too often in session garbage collection
User last visit gets updated too often
Link to spamhaus.org no longer valid
Enlarge session_browser field in sessions table to detect Googlebot
Non-existent urls to be written down to session_page
Cookie is not set
Adjust handling of session ID when requiring cookies
Whois not working for IPv6 addresses
Expose user id directly
phpbb\session::update_session_infos may attempt to read undefined $this->data['session_page']
Require cookies for sessions
No persistent cookies without user's consent
Topic Read Mine icon doesn't display accurately in older topics.
IPv6 address not working in Whois
Is not possible to start a session without update session page from controllers
Updating session time in AJAX request ignores 60 seconds check
Add the ability to auto-prune logged IPs etc.
Server slowed down when having high session count
avoid "soft 404" errors if user deleted or topic moved to restricted section of the board
phpbb don't detect some bot via user agent
Confirm to users that wish to register or log-in over an insecure connection of http (port 80)
PHP 7.2 compatibility: wrong sizeof/count parameter type
HHVM: Wrong URLs created by session.php/extract_current_page()
Pages served from app.php can't disable the update of session_page
Last Visit Time Not Updating
[PHP] core.user_setup_after
feed links lack sids
Bot session continuation with invalid f= query parameter causes SQL error
table columns for IP address too short (IPv4 embedded in IPv6 address = 45 chars)
Notification/Confirmation of email/password changes
Add option to notify about (admin) logins
Add user id to login/logout urls
$user->page['page'] is invalid resulting in confirm_box() not working correctly
Remember me cookie gets unset by admin reauthentication
dead code in sessions.php
Banned users cause infinite recursion
Setting a new password should delete all sessions?
AJAX requests are being stored to session_page
Use a factory for allowing custom datetime classes instead of passing the class name to \phpbb\user
Session loss when loading several pages simultaneously
"Prune notifications" cron task always ran, blocking others
$user->page contains bogus data on controller (app.php) pages
Write unit tests for session storage abstraction
Refactor session_table queries to use the session class
short_ipv6() doesn't expect IPv4 embedded IPv6 addresses
Performance: phpbb_sessions and innodb
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1746771273467},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1746771273468},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1746771273473},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true,"lastViewed":1746771273475},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Link types","id":"issue_link_type","key":"issue.field.issuelinks","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Development","id":"customfield_10440","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Epic Color","id":"customfield_10245","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10242","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10244","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10243","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Fix URL","id":"customfield_10030","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":true},{"name":"Flagged","id":"customfield_10540","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"GitHub Pull Request URL","id":"customfield_10020","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":true},{"name":"Labels","id":"customfield_10040","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Original story points","id":"customfield_10644","key":"com.atlassian.jpo:jpo-custom-field-original-story-points","isShown":true},{"name":"Parent Link","id":"customfield_10641","key":"com.atlassian.jpo:jpo-custom-field-parent","isShown":false},{"name":"Rank","id":"customfield_10240","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Sprint","id":"customfield_10241","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_10246","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Team","id":"customfield_10640","key":"com.atlassian.teams:rm-teams-custom-field-team","isShown":true},{"name":"phpBB Import Key","id":"customfield_10000","key":"com.atlassian.jira.plugin.system.customfieldtypes:importid","isShown":true},{"name":"phpBB Import Key","id":"customfield_10140","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10141","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10142","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10143","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10144","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10145","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10146","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true},{"name":"Target end","id":"customfield_10643","key":"com.atlassian.jpo:jpo-custom-field-baseline-end","isShown":true},{"name":"Target start","id":"customfield_10642","key":"com.atlassian.jpo:jpo-custom-field-baseline-start","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1746771273474},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label> <select class=\"select js-default-checkboxmultiselect\"\n id=\"searcher-type\"\n multiple=\"multiple\"\n name=\"type\"\n data-max-inline-results-displayed=\"100\"\n data-placeholder-text=\"Find Issue Types...\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12123&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/images/icons/issuetypes/epic.svg\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10100\"\n title=\"Epic\"\n value=\"10100\">Epic</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12130&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_4\"\n title=\"Improvement\"\n value=\"4\">Improvement</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12131&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/images/icons/issuetypes/exclamation.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10001\"\n title=\"Security Issue\"\n value=\"10001\">Security Issue</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12138&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_3\"\n title=\"Task\"\n value=\"3\">Task</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12136&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Sub-task\"\n value=\"5\">Sub-task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"component":{"name":"Component","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldcomponent\">Component:</label><span id=\"fieldcomponent\" class=\"fieldValue\">\n \n Sessions </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-projectconstant\" >\n <label for=\"searcher-component\">Component</label> <select class=\"select js-default-checkboxmultiselectcomponent\"\n id=\"searcher-component\"\n multiple=\"multiple\"\n name=\"component\"\n data-max-inline-results-displayed=\"100\"\n aria-label=\"Search for components\">\n <optgroup label=\"\">\n <option value=\"-1\" title=\"No Component\">No Component</option>\n <option value=\"id:ACP\" title=\"ACP\">ACP</option>\n <option value=\"id:Attachments\" title=\"Attachments\">Attachments</option>\n <option value=\"id:Authentication\" title=\"Authentication\">Authentication</option>\n <option value=\"id:BBCode Engine\" title=\"BBCode Engine\">BBCode Engine</option>\n <option value=\"id:Build System\" title=\"Build System\">Build System</option>\n <option value=\"id:Caching (ACM)\" title=\"Caching (ACM)\">Caching (ACM)</option>\n <option value=\"id:CLI\" title=\"CLI\">CLI</option>\n <option value=\"id:Continuous Integration (CI)\" title=\"Continuous Integration (CI)\">Continuous Integration (CI)</option>\n <option value=\"id:Cron\" title=\"Cron\">Cron</option>\n <option value=\"id:Database Abstraction Layer (DBAL)\" title=\"Database Abstraction Layer (DBAL)\">Database Abstraction Layer (DBAL)</option>\n <option value=\"id:Dependency Management\" title=\"Dependency Management\">Dependency Management</option>\n <option value=\"id:Documentation\" title=\"Documentation\">Documentation</option>\n <option value=\"id:Events\" title=\"Events\">Events</option>\n <option value=\"id:Extensions\" title=\"Extensions\">Extensions</option>\n <option value=\"id:Group Management\" title=\"Group Management\">Group Management</option>\n <option value=\"id:Installation system\" title=\"Installation system\">Installation system</option>\n <option value=\"id:IPB 1.x convertor\" title=\"IPB 1.x convertor\">IPB 1.x convertor</option>\n <option value=\"id:IPB 2.x convertor\" title=\"IPB 2.x convertor\">IPB 2.x convertor</option>\n <option value=\"id:JavaScript / AJAX\" title=\"JavaScript / AJAX\">JavaScript / AJAX</option>\n <option value=\"id:Language pack\" title=\"Language pack\">Language pack</option>\n <option value=\"id:Login\" title=\"Login\">Login</option>\n <option value=\"id:Memberlist/viewing profiles\" title=\"Memberlist/viewing profiles\">Memberlist/viewing profiles</option>\n <option value=\"id:Migrations\" title=\"Migrations\">Migrations</option>\n <option value=\"id:Moderator Control Panel (MCP)\" title=\"Moderator Control Panel (MCP)\">Moderator Control Panel (MCP)</option>\n <option value=\"id:Node.js\" title=\"Node.js\">Node.js</option>\n <option value=\"id:Notification System\" title=\"Notification System\">Notification System</option>\n <option value=\"id:OAuth\" title=\"OAuth\">OAuth</option>\n <option value=\"id:Other\" title=\"Other\">Other</option>\n <option value=\"id:Permissions\" title=\"Permissions\">Permissions</option>\n <option value=\"id:phpBB 2.0 convertor\" title=\"phpBB 2.0 convertor\">phpBB 2.0 convertor</option>\n <option value=\"id:Posting\" title=\"Posting\">Posting</option>\n <option value=\"id:Private Messages (PM)\" title=\"Private Messages (PM)\">Private Messages (PM)</option>\n <option value=\"id:Search\" title=\"Search\">Search</option>\n <option selected=\"selected\" value=\"id:Sessions\" title=\"Sessions\">Sessions</option>\n <option value=\"id:Storage\" title=\"Storage\">Storage</option>\n <option value=\"id:Styles\" title=\"Styles\">Styles</option>\n <option value=\"id:Template Engine\" title=\"Template Engine\">Template Engine</option>\n <option value=\"id:Test Suite\" title=\"Test Suite\">Test Suite</option>\n <option value=\"id:Unified Convertor Framework (UCF)\" title=\"Unified Convertor Framework (UCF)\">Unified Convertor Framework (UCF)</option>\n <option value=\"id:Update system\" title=\"Update system\">Update system</option>\n <option value=\"id:User Control Panel (UCP)\" title=\"User Control Panel (UCP)\">User Control Panel (UCP)</option>\n <option value=\"id:Version control\" title=\"Version control\">Version control</option>\n <option value=\"id:Viewing forums\" title=\"Viewing forums\">Viewing forums</option>\n <option value=\"id:Viewing posts\" title=\"Viewing posts\">Viewing posts</option>\n </optgroup>\n </select>\n </div>\n \n","jql":"component = Sessions","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a data-pid=\"10010\" data-issue-type-ids=\"\" href=\"/browse/PHPBB\" title=\"Browse phpBB project\">phpBB</a> </span></div>\n","editHtml":" \n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label> <select class=\"js-project-checkboxmultiselect\"\n data-placeholder-text=\"Find Projects...\"\n id=\"searcher-pid\"\n multiple=\"multiple\"\n name=\"pid\">\n <optgroup label=\"Recent Projects\">\n </optgroup>\n <optgroup label=\"All Projects\" >\n <option data-icon=\"/secure/projectavatar?pid=10010&size=small\"\n selected=\"selected\" title=\"phpBB\"\n value=\"10010\">\n phpBB (PHPBB)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10042&size=small\"\n title=\"Extension Security\"\n value=\"10042\">\n Extension Security (EXTSEC)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10040&size=small\"\n title=\"Incident Investigation\"\n value=\"10040\">\n Incident Investigation (INCIDENT)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10041&size=small\"\n title=\"phpBB Security\"\n value=\"10041\">\n phpBB Security (SECURITY)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10045&size=small\"\n title=\"Website\"\n value=\"10045\">\n Website (WEBSITE)\n </option>\n </optgroup>\n </select>\n </div>\n \n\n","jql":"project = PHPBB","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label> <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://tracker.phpbb.com/secure/useravatar?size=xsmall&avatarId=10143\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label> <select class=\"select js-default-checkboxmultiselectstatuslozenge\"\n data-placeholder-text=\"Find Statuses...\"\n id=\"searcher-status\"\n multiple=\"multiple\"\n name=\"status\"\n data-max-inline-results-displayed=\"100\"\n data-footer-text=\"-92 more options. Continue typing to refine further.\" data-status-lozenge=\"true\">\n <optgroup >\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/images/icons/phpbb-open.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unverified-fix.png\" value=\"5\" title=\"Unverified Fix\" data-simple-status=\"{"id":"5","name":"Unverified Fix","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/images/icons/phpbb-unverified-fix.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Unverified Fix</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/images/icons/phpbb-closed.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10001\" title=\"Awaiting Information\" data-simple-status=\"{"id":"10001","name":"Awaiting Information","description":"Further information from the reporter is required to commence work.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Awaiting Information</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unreviewed-patch.png\" value=\"10002\" title=\"Patch Awaiting Review\" data-simple-status=\"{"id":"10002","name":"Patch Awaiting Review","description":"A patch solving the issue has been proposed, but is awaiting review by a development team members.","iconUrl":"/images/icons/phpbb-unreviewed-patch.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Patch Awaiting Review</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10004\" title=\"Patch Needs Work\" data-simple-status=\"{"id":"10004","name":"Patch Needs Work","description":"A patch has been reviewed but needs further work before it can be merged.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Patch Needs Work</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10205\" title=\"Confirmed\" data-simple-status=\"{"id":"10205","name":"Confirmed","description":"A bug which has been confirmed","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Confirmed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10206\" title=\"Have regression test\" data-simple-status=\"{"id":"10206","name":"Have regression test","description":"A regression test has been implemented, committed and disabled","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Have regression test</option>\n </optgroup>\n</select>\n </div>\n \n","validSearcher":true,"isShown":true}}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0