* allow custom types for any settings

* fix ip

* fix system tests

Make sure to trigger Sites.getSites event when a new Site instance is created

Background: In Piwik 2.13 we removed the `Site.setSite` event because it is slow. So in some cases it may not actually trigger a `Sites.setSites` event when a site is loaded. For example when doing `new Site()`. I think in this case we should still trigger that event if the site did not exist yet because we do not call it very often and not in a loop for all sites etc. This is useful since `new Site` is used eg in `Controller` and for such cases we should trigger this event.

This is because angular might cancel the url change or listen to it themselves and not reload the page entirely.

Now that the type was changed to int, we no longer need that check

See Funnels plugin where the first part is a block quote

UI tests for Piwik 3.x

* added new marketplace widget and fixed some urls

* translate widget

* fix system test

* add some spacing

* testing referrer website with both HTTP and HTTPS
for https://github.com/piwik/piwik/issues/10857

* Add a system test reproducing #10857

Add a system test reproducing #10857 -> confirmed that Piwik will track referrers from the same HTTP and HTTPS page as different entries.

the refresh is  currently needed for several reasons as the Segmentation editor is not coded properly and does not just work without the page reload.
 Ideally we'll rewrite the Segment Editor in AngularJS later so this reload will not be needed.

fixes https://github.com/piwik/piwik/issues/10626
Reverting https://github.com/piwik/piwik/commit/5daf6c2388693746f2a47a9e6c31276d0b423a4f
part of https://github.com/piwik/piwik/commit/0c9c30b731ccbacf47e154b9f7a590af49e3d799

Hide full token_auth until it was clicked

* always unescape escaped % symbols in translations

* adds new tests to proove %-symbols are escaped in english translations

* submodule update

Trigger JS tracker update when checking for updates

Update  Bundle of CA Root Certificates for SSL connections

Don't change json2 format for Piwik 3 (revert #10928)

Port #10852 to Piwik 3

Reverts https://github.com/piwik/piwik/pull/10928/files
Refs https://github.com/piwik/piwik/issues/8566

Add new icon to font

* Better text + https link

* When activating the Awesome Search form, do not display 'No Results' until user types something in to form

Make LogAggregator::getWhereStatement public

When using `generateQuery()` in to archive reports it will automatically bind parameters from `getGeneralQueryBindParams()`. This works only when also applying the matching where statement that is generated by `getWhereStatement()`. Therefore the method needs to be public, otherwise `generateQuery()` is not really useful and may invalidate many plugins over time.

* Fix a bug where Piwik returns wrong rows by label

* fix typo

* added test

* fix a bug in query builder where tables are sorted randomly
* added more complex example to show it better

Call createFilesForSecurity() manually  in the update (doing this on cache delete affects IO performance too much in development mode)

This is related to https://forum.piwik.org/t/license-missing-of-a-free-glp-plugin/21674 

Some users see a license warning for a free GPL plugin. I have spent hours trying to understand how this could possibly happen over the last weeks but not sure how it happens. It must be some kind of caching issue with a certain PHP version or something. This change might not fix the actual issue but is a good check to have on top to check for invalid licenses only if it is not a free plugin.

* Apply ReplaceSummaryRowLabel filter when flattening

* Also apply filter in parent table

* Clarify that the filter is recursive