Bug#1237198: Make Elasticsearch plugin work with MySQL.

Rebasing change - merging conflicts:

	htdocs/search/elasticsearch/lib.php

Change-Id: Ieb202b23eb9bc4521916e32c96266aadf96de16e
Signed-off-by: Ghada El-Zoghbi <ghada@catalyst-au.net>
Unescaping the <br> tag in warning message (bug #731647)

- also the bug mentions in comment #4 an Object warning
but I couldn't duplicate in testing with v1.8

Change-Id: I59960f9f717154d710de844546cef9cda29f17f3
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Tag links now for current owner not just owner = 1 (bug #1196213)

Change-Id: Id8b24afcd7dcfc315b1f62cf70e57de289ba784f
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Checking for $user->urlid before trying to access it (bug #1253462)

In some cases the $user->urlid may not be present - this checks for it
before accessing it otherwise it falls back to the $id to get info

Change-Id: I989e68321402f458b167879e994150213c3e4893
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Design changes by Evonne - tidying up some CSS problems (bug 1252085)

Change-Id: I4d56b24f4130d9d020e96e9c5fb552cf27e84e9f
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Friend request options return you to correct pagination (bug #852304)

- have got the deny request, remove friend, send message and request
friend options remembering the pagination

- I also altered the code in some places to match the coding layout
in others.

The offset variable gets passed through to form so on return you end
up on correct pagination page rather than beginning of list

Change-Id: I043240f2be97431b2db2376999ec551569a37e82
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Add class JavascriptDetector for checking if javascript is enabled

1. Add the begining of PHP file, call
JavascriptDetector::check_javascript();

2. Call JavascriptDetector::is_javascript_activated()
 or $SESSION->get('javascriptenabled') to get the current status.

3. Call JavascriptDetector::reset() when users logout.

Change-Id: Ia12e1678ae2f3f74f3b8e5fb2c0bfdd20d5ae906
Signed-off-by: Son Nguyen <son.nguyen@catalyst.net.nz>
Using empty() instead of is_null (Bug 1095934)

Change-Id: I32cf198a8fa33a9e9773a752c6b32ce5fa079c7b
Signed-off-by: Son Nguyen <son.nguyen@catalyst.net.nz>
Merge "Using empty() instead of is_null (Bug 1095934)"
Allow a $cfg->bounces_ratio of 0

Bug 1261233: If you set the ratio to 0, you'll bounce someone
as soon as they hit bounces_min, regardless of what the sent/bounced
ratio is

Change-Id: Ibe8223054fa70ea27748d78b099afa079be7f900
Override MySQL's check for accidental large queries

Bug 1070046: MySQL has an optional server config option, "MAX_JOIN_SIZE",
which throws an error if you try to run a SQL query that MySQL's strategizer
thinks will require it to evaluate more than MAX_JOIN_SIZE rows. This is
intended to prevent the user from accidentally running giant queries that
will never finish, but some Mahara queries (which are large but will finish)
can trip it. Adding SQL_BIG_SELECTS=1 tels it that our queries are *not*
accidentally large.

Change-Id: I6db4699ea765d3213d13eb93b8de098914db24e0
Integration of Cookie Consent solution (Bug #1258130)

Change-Id: I4bd3680e9866a3371b46de807e34712fa1029472
Signed-off-by: Gregor Anzelj <gregor.anzelj@gmail.com>
Merge "Integration of Cookie Consent solution (Bug #1258130)"
Added alt text to profile pictures so that username links are read (Bug #1259746)

Changed profile picture string to include the user's name.
Added this string to profile pictures where the lack of alt text was
preventing the attached username from being read out by screen
readers

Change-Id: I6be98e4b6131d8c01c2384222edeec2349a7d0ac
Signed-off-by: Jono Mingard <reason.koan@gmail.com>
Merge "Design changes by Evonne - tidying up some CSS problems (bug 1252085)"
Allow a $cfg->bounceprefix that's not exactly 4 characters

Bug 1261231

Change-Id: I82d8169e41dcca65c214fdfec954086eba8fc6c8
Merge "Allow a $cfg->bounceprefix that's not exactly 4 characters"
Merge "Tag links now for current owner not just owner = 1 (bug #1196213)"
Merge "Allow a $cfg->bounces_ratio of 0"
Adding in missing keys & indexes

Bug 1174623 For sites that have been upgraded from version 1.0 there are
some missing constraints and indexes on the artefact_access_usr,
artefact_access_role, artefact_attachment, group, grouptype_roles
and view_autocreate_grouptype tables.

Also some fields need to be adjusted to match the referenced field in
another table so that they can be used as a foreign key

Change-Id: Ifb8cd79d4fa9933be02f6086fb5dada18d47bfe2
Signed-off-by: Robert Lyon <robertl@catalyst.net.nz>
Signed-off-by: Aaron Wells <aaronw@catalyst.net.nz>