- add event.yaml file
- create the event table using yaml file
- modify installation files to remove state and add event_id

Avoid php timeouts when upgrading databases with large amounts of data by updating Thread Events in batches.

- Create a new database patch to add a new Event table, use event_id instead of state for thread_events, and remote the 'state' column in thread_events
- Create the Event class
- Use event_id instead of state for Thread Events

Charset: Add generic transcode php_user_filter

Staff Profile Updates:

Filter Action Saving Fix:

This commit fixes the way we validate filter actions before saving a filter. Now, the code will accurately validate the action without needing a filter_id first while making sure all validations stay withing the validate_actions function.

issue: Image CID Attributes

issue: CDATA Phone Contains

forms: Disabled By Help Topic Users

This addresses an issue where images in email signatures containing a
`data-cid` attribute will either crash the ticket page or not show the image
in the signature.

This addresses issue 4470 where Users creating tickets via Client Portal and
failing to fill out a required field makes disabled fields by Help Topic
appear on the page. When the disabled fields appear they allow Users to
populate and save data that they were not meant to submit.

This addresses an issue where people who do not have a phone field on the
contact information form go to search for a User in the User Directory and
the system crashes. This is due to the search query that always contains the
phone field variable. This only adds the phone variable to the search query
if the field actually exists.

This will be useful when converting content on the fly on write or read -
allowing for support for output filter for file storage backend.

issue: mPDF SetAutoFont RTL

issue: SelectionField nset

This addresses an issue where `SetAutoFont()` was making the Thai PDFs
break. This adds the `AUTOFONT_RTL` flag to only autodetect RTL languages
and nothing else.

This addresses an issue where creating an advanced search with selection
field "does not have a value" throws a fatal error. This was due to an
improperly named search method "notset".

Conflicts:
	include/class.forms.php

Make getFiles() return files

issue: Task Term Search

This commit fixes an issue where the ORM was trying to get invalid Staff fields (which we actually store in the config table), therefore throwing an error.

cron: Clean Expired Passwd Resets

issue: Multiple File Display

This adds functionality to clean expired password reset tokens on cron runs.

sessions: Clear On Password Set/Reset

This addresses an issue where FileUploadFields on the ticket header is not
displaying all attachments in the field.

This adds a Signal to clean Agent and User sessions upon setting/resetting
their password. If an Agent/User resets their own password and has multiple
sessions open it will log them out of every session except the one they’re
on.

This commit addresses the root cause of an issue commit 96892beb (now
        reverted) attempted to solve - by providing consistency between
getFiles and getAttachments

queues: Column Conditions Overwrite

Relative Time Fixes:

queues: Row Conditions