Fixes #390

For use in the materialized view column names

Fix possible serious errors in dynamic form fields

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

Fix ticket queue counts for limited users

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

Fix dropping of materialized view when variable name is changed

Ensure view exists before merging updates

Prevent possible sql injection error in field name used in the materialized
view.

Prevent possible xss error in the display of the field label and variable
name in the admin panel.

Conflicts:
	include/class.ticket.php

Ensure form for fields created during install

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

Conflicts:
	include/class.http.php
	include/mysqli.php

email: (Almost) always convert html on text body

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

Don't send attachments in staff alerts

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

Add underline button to redactor toolbars

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

This is especially important if the html ticket thread is disabled. In such
a case the message body will still be HTML, but an HTML email should not be
sent out.

Fixes #374

Satisfy lint test engine

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

http: Legacy versions of IIS redirect incorrectly

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

(And newer versions don't seem to like the legacy code). This patch uses a
`Refresh` header for IIS versions prior to 7.0 (included with Windows Vista
/ Server 2008). Starting with IIS 7.0, the Location header should be
properly handled by IIS.

Revisit plugin manager

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

perf: Use a materialized view to speed queue views

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

IE: Fix redactor and IE compatibility view for SCP

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

Honor ticket number in subject line without brackets

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

Add language selection to installer

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

Fix adding fields to an existing form

Use a union query to avoid using DISTINCT and lots and lots of joins in the
from clause.

Initial tests seem to indicate about a 80% faster (~500ms down from ~800ms)
on querying about 9k tickets).

And make plugin internal handling more consistent

And install initial data in target language. Also configure help tip
popovers to be in the configured, default system language.

And allow passing a callable array as the callback to the URL dispatcher

This patch introduces an automatic materialized view to speed database
performance when querying and displaying the ticket views. This can
eventually be extended to the search and advanced search features to speed
them as well.

The data from the dynamic form entries related to ticket details is copied
to a %ticket__cdata table. The %ticket__cdata table is then joined directly
to the other tables in the query for the ticket view. MySQL is magically
and dramatically faster using this method.

The downside is that the disk usage for the custom data is doubled, and the
time needed to update the dynamic data is at least doubled as the form
entries and the materialized view must both be updated.

This method should also extend well to other database platforms in the
future. It will be likely that most other database query optimizers will
have difficulty joining, scanning, and sorting the table models we have for
custom data fields.