The %ticket_email_info table needs an index on thread_id. This is done in
the `develop-next` branch; however, this patch helps alleviate performance
issues on the main branch until the `develop-next` branch is collapsed for
main line development.

search: Fix search for unassigned tickets

Reviewed-By: Peter Rotich <peter@osticket.com>

forms: Fix unset of all checkboxes on a form

Reviewed-By: Peter Rotich <peter@osticket.com>

collabs: Skip activity notice if collabs included in Cc header

Reviewed-By: Peter Rotich <peter@osticket.com>

alerts: Consider "alert assigned on new message"

Reviewed-By: Peter Rotich <peter@osticket.com>

i18n: Automate dns signature publishing for language packs

Reviewed-By: Peter Rotich <peter@osticket.com>

csv: Add UTF-8 BOM to export file

Reviewed-By: Peter Rotich <peter@osticket.com>

faq: Show proper internal/public category in drop-down

Reviewed-By: Peter Rotich <peter@osticket.com>

dashboard: Fix initial page load and stats pagination

Reviewed-By: Peter Rotich <peter@osticket.com>

kb: Add setting to enable only for authenticated clients

Review-By: Peter Rotich <peter@osticket.com>

search: Fix search on create date

Clear overdue on close

Reviewed-By: Jared Hancock <jared@osticket.com>

oops: Fix dropped custom data from API requests

Reviewed-By: Peter Rotich <peter@osticket.com>

filter: Trim match values when saving rules

Reviewed-By: Peter Rotich <peter@osticket.com>

Fixed typo

cdata: Drop ticket cdata on delete

Reviewed-By: Peter Rotich <peter@osticket.com>

files: Clear attachment box after posting a response

Reviewed-By: Peter Rotich <peter@osticket.com>

thread: Log remote IP for staff replies and notes

Reviewed-By: Peter Rotich <peter@osticket.com>

Because CSV has no way of indicating a content character set, writing the
file with a Unicode byte-order mark is useful to declare the content in
UTF-8 encoding.

When sending alerts to agents, consider the setting of the new message alert
configuration.

This addresses the issue where the advanced search dialog was submitted
before the date picker inputs were fixed up. This problem arises out of a
difference between the agent's date formatting preference and the server
being able to process that date format. The date pickers are reformated to
yyyy-mm-dd before submission; however, for advanced search, the submission
happened before the inputs were fixed up.

This patch addresses the issue by manually fixing up the date in the
submission routine for the advanced search dialog.

This will help when saving rules with trailing spaces for instance, which
may make things not match when visually the administrator would otherwise
expect the filter to match.

Fixes #1834

For a yet unknown reason, the association between the field implementations
and the DynamicFormEntry object is not maintained from calls to
DynamicFormEntry::getFields().

This patch addresses the issue by always associating the "form" when
returning from ::getFields()

wording: must be agents, because its agents table

Reviewed-By: Jared Hancock <jared@osticket.com>

Fixed typos in scp/helptopics.php

Reviewed-By: Peter Rotich <peter@osticket.com>