The CDATA table may be dropped on upgrade and is not created on new installs.
So it should be created on demand when searching for users.

This commit fixes an issue where we failed to upload attachments on Information Fields. In the to_config function, we were only taking the array_values of attachments which would return an array with only the file name ([0] => 'filename') instead of an array with the file id and file name ([123] => 'filename').

Now, when we pass the keepers to keepOnlyFileIds, we have a file id that can be passed to the upload function.

This addresses issue 4700 where local avatars where breaking queues with
Avatar Annotation. This is due to the local avatars not having a `setSize()`
function. This updates local avatars so that they can be resized.

This addresses an issue where the system banlist throws the error "SYSTEM
BAN LIST filter is DISABLED". This is due to the Filters moving to ORM but
not updating everywhere they are used.

This addresses an issue where the client-side forms are not rendering
correctly. This is due to updating the render() functions but not updating
everywhere they are used.

This addresses all the issues found in the final round of testing.

This commit includes several final fixes in general that needed to be made.

This fixes PHP issues compiling language packs with PHP after version 7.

This addresses an issue where removing a Referral from the Manage Referrals
modal just loads and loads, never actually removing the referral. This is
due to the AJAX URL containing an extra `/` causing an "Unsupported URL"
error.

This addresses an issue where creating a ticket as an agent and selecting a
Help Topic does not show the Issue Summary or Issue Details fields. This is
due to us passing 3 parameters instead of 1 as an array. This combines the
params in one array and only passes the array as a param.

This addresses an issue where adding SubQueues hides PersonalQueues. This
was due to the variable `$childs` being reset in the sub-navigation
template.

This commit addresses an issue where a Department might have the Ticket Assignment option set to All Agents, but when trying to mass assign Tickets, only Department Agents were shown in the list.

Note: If mass assign is done on Tickets with different Departments that have different Ticket Assignment rules, Tickets will only be assigned to the Tickets that are allowed the assignment.

This pull request is wayyyy overdue. This updates jQuery and all related
files to the latest jQuery release (3.3.1). This also adds a new script
called jQuery-Migrate that maintains older functions needed for a few things
(eg. `filedrop.field.js`).

- Pull latest code from osTicket
- Fix Filter ORM compatibility issues that resulted from merge

This updates the references to the old jQuery UI filename to the new
filename. (this needs #4672 merged first)

Fixes an unexpected side effect of Pull Request #4652

This commit fixes an issue where a Short Answer Field would show as Empty if the value saved in it was '0'

This pull adds a Profile Setting for Agents to choose where to redirect
after replying to ticket. The two options are Queue (redirect to queue to
work on other tickets) or Ticket (redirect back to same ticket to continue
working) with the latter being the default. The setting is configurable for
each Agent in the helpdesk.

This addresses an issue where having more than 30+ choices for a Quickfilter
makes the dropdown run off the page causing some choices to be hidden. This
makes it to where if you have more than 20+ choices we will make the
dropdown a fixed height and make it scrollable.

This addresses a fatal error when adding a new response to a Task with
Collaborators. When we implemented the MailingList for Users/Collaborators
we forgot about the little Task Collaborators (poor little guys). This adds
a new function called `getRecipients()` to `class Thread` that utilizes
MailingList instead of UserList. This also adds two new functions to `class
Util` that retrieves the User’s `user_id`.

This addresses an issue where the Loading overlay on Tasks will not
disappear after the request was submitted. This adds two lines to first hide
the "Loading" modal and then toggle the overlay.

- Make sure we only set Filter Flags if they need to be changed (don't update them every time we save)
- Make sure we sure we use the email_id if we have actually set it. Otherwise, we lose what should be set for the Target Channel

This commit fixes an issue where we did not correctly change the values passed to the render function that was updated to work with PHP 7.1

This commit ensures that we do not return duplicate results when searching for Tickets with an Advanced Search that contains keywords.

This commit addresses issues we had with viewing Task(s) within a Ticket:

1. When viewing the table of all Tasks on a Ticket, the Options dropdown should only allow the Agent to Reopen or Close the Tasks based on the status of the Tasks.
Ex: If there is only 1 Open Task, you should only see the 'Close' Option
    If there are 2 Closed Tasks, you should only see the 'Reopen' Option
    If there are multiple Tasks in which some are Open and some are Closed, you should see both the 'Reopen' and 'Close' options

2. When viewing an individual Task within a Ticket, the status options were the opposite of what they should have been. Now, if the Task is Open, the Agent will see the option to 'Close' the Task. If the Task is Closded, the Agent will see the option to 'Reopen' the Task.

This commit updates the instructions for User imports letting the Agent know they should type 'Name, Email' on the first line and then put each new User Name/Email on the following lines to import Users.

This addresses an issue where exporting statistics via the dashboard within
a certain timeframe (eg. 07/01/2018 -> One Quarter) will always export the
statistics from the selected date up to today. This is due to the Period
option always being set to "Up to today" when the Export button is clicked
which in return exports the stats from the selected start date to today.
This adds JS to set the period the Agent selects so the Export will return
the stats from the selected date to the selected period.

This commit addresses an issue where we did not save headings for export fields.
We just need to leave the heading in the array rather than filtering it out so that we can save its new heading.

This commit changes the wording for Collaborators on Tasks to match the wording for Collaborators on Tickets.

This addresses an issue where Department Managers would not see the option
for Marking tickets as (un)answered due to an elseif (should be an if
instead).

This addresses a typo in the `markAs()` function in `ajax.tickets.php`. DOH!
Should’ve ran the lint tests

This feature extends the ability to mark tickets as Answered/Unanswered to
any Agent with the Role Permission to Post Reply in the Department. This
also adds the ability to add an (optional) Internal Note when marking as
(un)answered.

Support using %{ticket.thread} to export the entire ticket thread
correspondence between agents and end users (owner + collaborators).

Don't show fields disabled by help topic
Pass create mode for pre-selected help topic forms

This addresses an issue where Users updating their profile will throw an SQL
error in the system logs. This is due to a line of code trying to set a
value for the `dst` column which no longer exists as of `1.10.0`.