MDL-34190 Course: Role with student archtype should be selected as default in user list
MDL-37710 Assign: Fix pluginfile permission checks for student viewing their own team submission.

This change adds a function to the assign class to allow the permissions for a group submission
to be checked and updates all the submission plugins to call it.

Conflicts:

	mod/assign/locallib.php
	mod/assign/submission/file/lib.php
	mod/assign/submission/onlinetext/lib.php
MDL-37734 use prefetching workaround for MARS transaction problems
MDL-37734 add one more recordset isolation test
Merge branch 'wip-MDL-36363-m24' of https://github.com/samhemelryk/moodle into MOODLE_24_STABLE
Merge branch 'MDL-37533-24' of git://github.com/damyon/moodle into MOODLE_24_STABLE
MDL-37767 allow empty host in enrol_database which is required for default pg socket
MDL-37747 cache: changed PARAM_TEXT to PARAM_ALPHANUMEXT
Merge branch 'w04_MDL-37734_m24_marshack' of git://github.com/skodak/moodle into MOODLE_24_STABLE
MDL-25853 calendar: Fixed broken previous/next links
Merge branch 'wip-MDL-37747-m24' of git://github.com/samhemelryk/moodle into MOODLE_24_STABLE
MDL-36363 cache: fixed issue with double parsing keys for stacked loaders
MDL-34231 SCORM: calculate correct number of attemptsleft when entering an attempt.
MDL-36363 cache: added unit tests for muliple loaders
MDL-37785 theme_base: remove duplicate .dir-rtl file-picker css rules from styke/core.css
Merge branch 'm24_MDL-34231' of git://github.com/danmarsden/moodle into MOODLE_24_STABLE
MDL-37781 Check for switching the workshop phase without waiting for cron

Now we are checking for the need to switch the phase when the main
view.php is displayed to any user (previously this was done via cron
only). To give our subplugins (such as the scheduled allocation method)
a chance to do what they need to do, the workshop_viewed event is
triggered before the phase is actually switched.
MDL-37781 Allocate workshop submissions without waiting for cron

Now we are checking for the need to execute the allocator every time the
main view.php is displayed to any user. Previously this was done by cron
only.
MDL-37177 navigation: Prevent exception when viewing a profile

When viewing a profile as a non-authenticated user, an exception
was raised because we were trying to fetch the context of this user.
MDL-37775 theme_canvas: Changed ADD a block from center align to left in style/blocks.css