MoodleDocs - User contributions [en]

Moodle Workplace 4.1 release notes

2025-08-12T14:14:30Z

Pholden: 4.1.20

=4.1=
See our [https://docs.moodle.org/401/en/Moodle_Workplace_new_features Moodle Workplace 4.1 new features page] in the user documentation for an introduction to Moodle Workplace 4.1 with screenshots.
==Major features==
Moodle Workplace 4.1 is based on top of Moodle LMS 4.1 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace:
* '''Advanced tenant appearance settings''': tenant branding now includes two more settings that were available in Workplace 3.11: Navigation bar and Primary button colours. We have added more granularity to the permissions to change the appearance of the tenant, so advanced settings such as custom SCSS can be restricted to specific roles.
* '''Improvement to Tenant-allocation rules in the Shared Space'''. We have added two new conditions (“Users is allocated to tenant” and “User is not allocated to tenant”) and one action (“Allocate to tenant”) to Shared Dynamic Rules, with this addition we simplify the tenant allocation workflows for Admins in multi-tenant Workplace sites.
* '''Migration of core_reportbuilder custom reports'''. Migration feature now supports import and export of Custom Reports using Moodle LMS native report sources.
* '''Improved My Teams support in the Workplace App'''. The new My Teams page now includes information about learning and tracking in the Workplace App.
=== Other interesting features ===
* Hide/mask description of Dynamic rules conditions and actions when current user is not able to edit them
* Improved how hidden courses are displayed in the My Courses and Program pages
* Added "department" to User profile field condition in Dynamic Rules
* New setting to disable Program Cover page
* New setting to hide "Dates" section in the course information popup
* Fixed bug with deleted appointments being listed in user calendar
* Archive course certificates during program reset
* Display a warning when changing a tab without saving a form
* Allow tenant admin to edit locked profile fields for users in their tenant
* Fixed a bug causing an exception when viewing program progress report as an organisation manager after program import
== Upgrade notes for 4.1 ==
=== Upgrade from LMS ===
If "$CFG->forcewpsetup = true;" is set in config.php before upgrading Moodle LMS to Moodle Workplace 4.1, the upgrade process add ‘myinprogress’ and ‘myavailable’ blocks to the default dashboard, and reset the dashboard for all users.
=== Upgrade from Moodle Workplace 3.11 and 4.0 ===
On upgrade from Workplace 3.11 to 4.1 in one step, all appearance settings will be preserved excepting the Drawer colour, which doesn’t have any equivalent in 4.1.

Note that in case the upgrade is performed in two steps (3.11 > 4.0 and 4.0 > 4.1), the Navigation bar and Primary button colours will not be preserved in the corresponding settings, but the values of the settings that were added as custom CSS on upgrade to 4.0 will still be available (see [[Moodle Workplace 4.0 release notes#Branding|Workplace 4.0 upgrade notes]]).
=== Deprecation ===
We have deprecated the following in 4.1:
* get_managed_users web and get_teams_tab_filters web service in tool_organisation;
* get_user_learning_statuses in tool_program.
* tool_wp/db class
=4.1.1=
Moodle Workplace 4.1.1 is based on top of Moodle LMS 4.1.1 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace. This is a very short release as we launched 4.1 one week ago, so it does only include a couple of minor bug fixes.
=== Interesting features and fixes ===
* Fixed bug blocking users without the capability to edit their own profile to access Program Pages
=4.1.2=
See our [https://docs.moodle.org/401/en/Moodle_Workplace_new_features#4.1.2 Moodle Workplace 4.1.2 new features page] in the user documentation for an introduction to Moodle Workplace 4.1.2 with screenshots.
==Major features==
Moodle Workplace 4.1.2 is based on top of Moodle LMS 4.1.2 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace:
=== Key highlights ===
''(Available in 4.1.2 rolling only)''
* '''Search, filtering and reporting improvements to the Team overview block''':
** Quick filters that allow users to sort and filter data quickly within the Team overview block, making it easier to find the information they need.
** Access to full progress reports for certification, program, and course reports provide a comprehensive overview of each team member's learning progress
** Live search functionality that allows users to search for specific items in real-time within the Team overview block
** Warnings for overdue learning to provide notifications and reminders to users when they are falling behind on their coursework or certifications.
* '''Automatic branding enhancement for tenants''': generate shades of grey automatically based on the tenant primary colour, to reinforce the brand identity while avoiding disturbing the experience.
* '''Improvements in Appointments:'''
** New expandable UI for session details and bookings, with consistent navigation and design across activity modules.
** New completion criteria based on attendance
* '''Improvements in Dynamic Rules'''
** '''New action to end jobs'''
** '''New action to assign users to learning plans'''
** Option to suspend user's allocation to programs and certifications
* '''New setting to lock shared department and position frameworks''': only users with appropriate permissions can manage jobs within locked departments and position frameworks.
* '''Apply only allowed filters in Certificates:''' new feature for users to define allowed filters for certificates, so that only the ones specified by the user are applied to the PDF content.
=== Other improvements ===
''(Available in 4.1.2 rolling only)''
* Lock the Audience tab in Custom Pages and don’t include audiences in duplication of custom pages for users with no permission to locked departments and positions.
* Added back a link to Moodle LMS's user management page in Site Administration
* Maintain the order of blocks in courses when switching from Workplace List to topics course format during upgrade
* Introduce new data attributes to distinguish the tenant for better tenant customization
* Preserve the URL when switching tenants
=== Other interesting features and fixes ===
''(Available in 4.1.2 rolling and 4.1.2 standard)''
* Add the possibility for Certificate element plugins to have their own settings page
* Add course name to “My Certificates” list
* Fixed a bug that prevented the import of positions and departments into existing frameworks, preserving the hierarchy
* Fixed a bug where the completion status for courses was not displaying correctly on the Program Page
* Fixed a bug that prevented tenant administrators from viewing hidden user fields
* Legacy custom reports can no longer be created if custom reports are disabled site wide
== Upgrade notes for 4.1.2 ==
=== Block order is preserved when upgrading to 4.1 rolling only ===
In Workplace 4.0, the old Workplace List course format was replaced with topics course format (more details on [[Moodle Workplace 4.0 release notes#Course%20format%20.E2.80.9CWPList.E2.80.9D|Workplace 4.0 upgrade notes]]). As a consequence of that upgrade, order of blocks in course page might not be preserved (as per MDL-37240).

If the order of the blocks in courses has been changed and needs to be preserved, please make sure to upgrade to 4.1.2 rolling.
=== New data attributes to identify the tenant ===
Workplace 4.1.2 (rolling only) includes two new HTML data attributes to help to customize the styles for specific tenants. The new attributes are <code>[data-tenantid="{tenant_id}"]</code> and <code>[data-tenantidnumber="{tenant_idnumber}"]</code> (available when <code>idnumber</code> is defined for the tenant)
=4.1.3=
See our [https://docs.moodle.org/401/en/Moodle_Workplace_new_features#4.1.3 Moodle Workplace 4.1.3 new features page] in the user documentation for an introduction to Moodle Workplace 4.1.3 with screenshots.
==Major features==
Moodle Workplace 4.1.3 is based on top of Moodle LMS 4.1.3 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace:
=== Key highlights ===
''(Available in 4.1.3 rolling only)''
* '''Support contact by tenant.''' Now it is possible to configure the support contact information (support contact, support URL and availability) at a tenant level, so different tenant can have their own support contact settings.
* T'''eam’s overdue learning warnings for managers'''. The team overview block in the My Teams page now displays a warning when there are people with overdue learning to their managers. This notice includes a link to the corresponding report.
* ''''''User first login dynamic rule condition.'''''' Now it’s possible to create automations based on user’s first login.
=== Other improvements ===
''(Available in 4.1.3 rolling only)''
* Notify program creators when a course in the program when course completion is not set for courses with completion tracking enabled
* Add manager and department lead permissions to CSV import
=== Other interesting features and fixes ===
''(Available in 4.1.3 rolling, 4.1.3 standard and 4.0.8)''
* Fixed a bug causing appointment sessions being deleted after deleting another session.
* Fixed a bug that prevented assigning jobs in the upload user tool when using positions with duplicated idnumbers
* Fixed a bug in causing ad-hoc reports scheduled to be stuck endlessly
== Upgrade notes for 4.1.3 ==
Due to a fixed bug, the reports generated in the scheduled reports may now contain more data than they did before. We recommend reviewing your schedules and make sure that "View report as" is correct. For example, if the "View report as" is a global admin, the reports may contain cross-tenant data and they will be sent to all users in the schedules audiences, even those who do not normally have access to cross-tenant data.
= 4.1.4 =
Moodle Workplace 4.1.4 is based on top of Moodle LMS 4.1.4 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Interesting features and bug fixes ===
* Fixed a bug where the 'reset program' option was incorrectly displayed for dynamic allocation
* Fixed a bug in the 'Access' tab on tenant page where some users might have been incorrectly displayed.
* Fixed a bug during the upgrade process that caused it to get stuck in a loop
* Fixed a bug during the installation process that caused blocks in the dashboard to be copied multiple times under certain circumstances.
* Fixed a bug in tenant archiving that was granting tenant administration permissions from the default tenant to the tenant administrator of the archived tenant
* Fixed a bug during the upgrade process that caused it to get stuck in a loop (''4.1.4 rolling only)''
= 4.1.5 =
Moodle Workplace 4.1.5 is based on top of Moodle LMS 4.1.5 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Highlights ===
* We added some changes to the "Workplace" theme that allow to create child themes easier. We have released an example "[https://github.com/moodleworkplace/moodle-theme_wpchild Workplace child theme]"
* Moved "Information" tab to the second position on the course page
* Changed report data source "Issued certificates" removing a very strict capability check. Now it is possible to create reports such as "My certificates" or "My team's certificates" that can be accessed by users who can not view the templates list.
** '''Upgrade notes:''' To prevent accidental disclosure of new data to people who already have reports using the "Issued certificates" datasource, we have added a new condition that mimics the previous hardcoded restriction. This condition (called "Permission to access templates") is automatically added during upgrade to all existing reports from this datasource. It can be removed if necessary. This condition will not be automatically added to the newly created reports but can be added manually if needed.
=== Other fixes ===
* Fixed a bug causing program reset ad-hoc task to fail
* Fixed a bug insufficiently resetting course module views during program reset
* Fixed a bug causing failures during organisation structure export
* Improved Dynamic rules, allowing some actions to be executed as scheduled tasks only. Changed actions "Assign to learning plans" and respective "Unassign" action to use this functionality, because they can fail if they are executed in a session of a student
* Changed workplace activity icons to look more consistent with the LMS activity icons (white instead of black)
* Bug fixes and improvements in how some tenant configuration data is being sent to the mobile app (among other things, this makes sure that the site name in the user information page is correct and corresponds to the current tenant).
* Added validation to the tenant branding "Custom SCSS" field to prevent accidental breaking of the whole site layout
* Added column "Session date & time" to Appointments datasources that was present in legacy report builder in 3.11 but was forgotten in 4.0+ report builder

This version also contains a fix for a security issue in Moodle Workplace, the details will be communicated to the Moodle Partners on the day of release and disclosed here later.
= 4.1.6 =
Moodle Workplace 4.1.6 is based on top of Moodle LMS 4.1.6 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Other fixes ===
* Fixed: Suspended on Program report displays "Yes" even though user is not suspended from program

This version also contains a fix for a security issue in Moodle Workplace, the details will be communicated to the Moodle Partners on the day of release and disclosed here later.
= 4.1.7 =
Moodle Workplace 4.1.7 is based on top of Moodle LMS 4.1.7 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Fixes ===
* Fixed condition 'Select course' in the course participants custom report
* Appointment status and session summary no longer shows Wait-listed users as 'Booked'
* Allow to sort by allocation date column in report builder
* Fixed bug when manually changing certification due date causes date to get stuck on program info card
* Do not show percentage in recent courses block if course does not have completion
* It is now possible to delete user profile picture in the tenant user editing popup
* Do not show the enable/disable switch for the manual auth method that can never be disabled
= 4.1.8 =
Moodle Workplace 4.1.8 is based on top of Moodle LMS 4.1.8 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Fixes ===
* Removed and empty link in the "Certification progress" report

= 4.1.9 =
Moodle Workplace 4.1.9 is based on top of Moodle LMS 4.1.9 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Fixes ===
* Corrected the link to the user documentation in the Course Certificate activity module
* Fixed a bug in the Course Certificate scheduled task related with deleted templates

= 4.1.10 =
Moodle Workplace 4.1.10 is based on top of Moodle LMS 4.1.10 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.
=== Fixes ===

* Fixed multiple accessibility issues in several components in the scope of the WCAG 2.1 AA accreditation

= 4.1.11 =
Moodle Workplace 4.1.11 is based on top of Moodle LMS 4.1.11 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

=== Fixes ===

* Various accessibility fixes related to the ongoing effort to achieve WCAG AA accessibility accreditation for Moodle Workplace

= 4.1.12 =
Moodle Workplace 4.1.12 is based on top of Moodle LMS 4.1.12 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

=== Fixes ===

* Add support for separate group mode to Appointments activity module

=4.1.13=
Moodle Workplace 4.1.13 is based on top of Moodle LMS 4.1.13 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

=== Security fixes ===
* A number of security related issues were resolved. Details of these issues will be released after a period of approximately one week to allow system administrators to safely update to the latest version.

= 4.1.14 =
Moodle Workplace 4.1.14 is based on top of Moodle LMS 4.1.14 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

=== Security fixes ===

* A number of security related issues were resolved

= 4.1.15 =
Moodle Workplace 4.1.15 is based on top of Moodle LMS 4.1.15 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

=== Fixes ===

* Resolved issue where users from other tenants could be incorrectly displayed on the tag index page

= 4.1.16 =
Moodle Workplace 4.1.16 is based on top of Moodle LMS 4.1.16 and has all the new features of the core version. In addition, it contains all exclusive features from Moodle Workplace.

There were no workplace-specific fixes in this release.

= 4.1.17 =
Moodle Workplace 4.1.17 is based on top of Moodle LMS 4.1.17 and has all the security fixes of the core version.

There were no workplace-specific fixes in this release.

= 4.1.18 =
Moodle Workplace 4.1.18 is based on top of Moodle LMS 4.1.18 and has all the security fixes of the core version.

There were no workplace-specific fixes in this release.

= 4.1.19 =
Moodle Workplace 4.1.19 is based on top of Moodle LMS 4.1.19 and has all the security fixes of the core version.

=== Improvements ===

* Added functionality to capture and display historical data for registered and active users in the datastore.

=== Fixes ===

* Resolved an issue where the course certificates page was not displayed within the course navigation layout.

= 4.1.20 =
Moodle Workplace 4.1.20 is based on top of Moodle LMS 4.1.20 and has all the security fixes of the core version.

=== Fixes ===

* Resolved potential privacy issue moving users with job assignments between tenants

Moodle libraries credits

2022-03-02T14:25:06Z

Pholden: Library updates for 4.0.

Some of Moodle's libraries were written by other people, and are being redistributed as part of Moodle under their respective open source licenses that thankfully allow us to do so. Thanks to the authors of all these excellent products - without them Moodle would be missing important functionality. Copyright information for each package is included below:
==ADOdb==
''lib/adodb''

Database abstraction library for MySQL, PostgreSQL, MSSQL, Oracle, Interbase, Foxpro, Access, ADO, Sybase, DB2 and ODBC.

Version: 5.21.0

@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.

@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community

License: Dual LGPL and BSD-styleMDL-71712

http://adodb.sourceforge.net
==Amazon S3==
''repository/s3/S3.php''

A standalone Amazon S3 (REST) client for PHP 5.2.x using CURL that does not require PEAR.

Version: 0.5.1

Copyright (c) 2013, Donovan Schönknecht

License: BSD 2-Clause

https://github.com/tpyo/amazon-s3-php-class/releases
==Axe==
''lib/behat/axe''

Accessibility testing engine for websites and other HTML-based user interfaces.

Version: 3.5.5

Copyright Deque Systems Inc.

License: Mozilla Public License 2.0

<nowiki>https://github.com/dequelabs/axe-core/tags</nowiki>
==Bennu==
"lib/bennu"

Bennu is an object-oriented library written in PHP that implements the iCalendar standard (RFC 2445).

Version: 0.1 (customized since then)

Copyright (c) 2005, Jon Papaioannou

License: LGPL 2.1+

http://bennu.sourceforge.net/
==CAS==
''auth/cas/CAS''

phpCAS library to support CAS authentication plugin

Version: 1.3.8

Copyright Jasig

License: Apache License 2.0

https://wiki.jasig.org/display/CASC/phpCAS
==CFPropertyList==
''/lib/plist''

PHP Implementation of Apple's PList (binary and XML)

Version: 2.0.2

Copyright © 2018 Teclib

Copyright © 2009 Christian Kruse, Rodney Rehm

License: MIT

http://teclib.github.io/CFPropertyList/
==Chart.js==
''lib/amd/src/chartjs-lazy.js''

Simple yet flexible JavaScript charting for designers & developers

Version: 2.9.4

Copyright 2016 Nick Downie

License: MIT

http://www.chartjs.org
==CodeMirror==
''lib/editor/atto/plugins/html/yui/src/codemirror''

CodeMirror is a versatile text editor implemented in JavaScript for the browser.

Version: 5.59.4

License: MIT

https://github.com/codemirror/CodeMirror
==Emoji-data==
''lib/emoji-data''

Library to parse easily data and sprite sheets for emoji.

Version 6.0.0

Copyright (c) 2013 Cal Henderson

License: MIT

https://github.com/iamcal/emoji-data/
==EvalMath==
''lib/evalmath''

Class to safely evaluate math expressions

Copyright Miles Kaufmann

License: BSD

http://www.twmagic.com/
==FLV player==
''filter/mediaplugin/flvplayer.swf''

Flash movie to play FLV files

Copyright Jeroen Wijering

License: GNU GPL

http://www.jeroenwijering.com

(This library is not currently used in Moodle)
==FPDI==
''/mod/assign/feedback/editpdf/fpdi/''

Collection of PHP classes facilitating developers to read pages from existing PDF documents and use them as templates in FPDF.

Version: 2.3.6

Copyright (c) 2020 Setasign GmbH & Co. KG, https://www.setasign.com

License: MIT

https://www.setasign.com/products/pdf-php-solutions/fpdi/
== GeoIp2 ==
''lib/maxmind/GeoIp2''

Library for processing of GeoIP data files

Version: 2.11.0

Copyright MaxMind

License: Apache 2.0

https://github.com/maxmind/GeoIP2-php
== GeoPattern==
''lib/geopattern-php''

Library for creating beautiful generative background images from a string

Version: 1.1.2

Copyright 2015 Leaf Corcoran

License: MIT

https://github.com/RedeyeGroup/geopattern-php
==Google APIs==
"lib/google"

Library Google APIs Client Library for PHP

Version: 1.1.7

License: Apache License Version 2.0

https://github.com/google/google-api-php-client
==Graph Class==
''lib/graphlib.php''

Class to draw line, point, bar, and area graphs, including numeric x-axis and double y-axis.

Version: 1.6.3 (with modifications)

Copyright © 2000 Herman Veluwenkamp (''hermanV AT mindless DOT com'')

License: LGPL
==H5P==
''joubel/core''

The general H5P library

Version: 1.24.2

Copyright © Joubel

License: GPL-3.0

https://github.com/h5p/h5p-php-library/
==H5P Editor PHP Library==
''joubel/editor''

A general library that is supposed to be used in most PHP implementations of H5P.

Version: moodle-1.20.2

Copyright © Joubel

License: MIT

https://github.com/h5p/h5p-editor-php-library
==Horde==
''lib/horde''

Library used by the inbound e-mail handling system.

Version: 5.2.23

Copyright © Horde LLC

License: LGPL

http://www.horde.org/
==html2text==
''lib/html2text''

PHP script to convert HTML into an approximate text equivalent

Version: 4.3.1

Copyright (c) 2005-2007 Jon Abernathy <jon@chuggnutt.com>

License: GNU GPL

https://github.com/mtibben/html2text.git
==htmlArea==
''lib/editor''

Javascript/HTML script to put a GUI editor in textareas on Internet Explorer and Mozilla

Version: 3.0 beta (with modifications)

Copyright © 2002 interactivetools.com, inc.

License: htmlArea License (based on BSD license)

(This library is not currently used in Moodle)
==HTML Purifier==
"lib/htmlpurifier"

Filters HTML.

Version: 4.13.0

License: LGPL
==http-message==
"/lib/http-message"

Provide a set of common interfaces for HTTP messages as described in RFC 7230 and RFC 7231

Version: 1.0.1

Copyright (c) 2014 PHP Framework Interoperability Group

License: MIT
==IP-Atlas==
''lib/ipatlas''

PHP scripts to show the location of an IP address on a map.

Version: 1.0 (with modifications)

Copyright © 2002 Ivan Kozik

License: GNU GPL

http://www.xpenguin.com/ip-atlas.php

(This library is not currently used in Moodle)
==Jabber - XMPPHP==
''lib/jabber''

PHP library for XMPP (aka Jabber, Google Talk, etc).

Version: 0.1rc2-r77

Copyright: 2008 Nathanael C. Fritz

License: GPL

http://code.google.com/p/xmpphp
==jQuery==
''lib/jquery''

jQuery is a fast, small, and feature-rich JavaScript library widely used on moodle.

Version: 3.5.1

Copyright: 2016 The jQuery Foundation

License: MIT

https://jquery.com
==jQuery EU Cookie Law popups==
'/admin/tool/policy/amd/src/jquery-eu-cookie-law-popup.js''

An easy-to-install jQuery plugin to create EU Cookie Law popups

Version: 1.1.3

Copyright (c) 2015 Richard Dancsi

License: MIT

https://github.com/wimagguc/jquery-eu-cookie-law-popup
==jQuery migrate==
''lib/jquery/jquery-migrate-1.4.0.js''

Library used migrate older jQuery code to jQuery 3.0.

Version: 1.4.0

Copyright: 2016 The jQuery Foundation and other contributors

License: MIT

https://github.com/jquery/jquery-migrate

(This library is not currently used in Moodle)
==jQuery UI==
''lib/jquery/ui-1.12.1/''

jQuery UI is a set of user interface interactions, effects, widgets, and themes built on top of the jQuery library.

Version: 1.12.1

Copyright: 2016 The jQuery Foundation and other contributors

License: MIT

https://github.com/jquery/jquery-migrate
==JavaScript Beautifier==
''yui/src/beautify''

Beautify HTML code in Atto.

Version: 1.13.0

Copyright (c) 2007-2018 Einar Lielmanis, Liam Newman, and contributors.

License: MIT

https://beautifier.io/
==Services_JSON==
''lib/json''

Allows PHP->JS communication via JSON

Version: 1.3.1

Copyright © 2005 Michal Migurski

License: Modified BSD (GPL-compatible)

http://pear.php.net/pepr/pepr-proposal-show.php?id=198

(This library is not currently used in Moodle)
==JWT==
''lib/php-jwt''

A simple library to encode and decode JSON Web Tokens (JWT) in PHP, conforming to RFC 7519

Version: 5.2.0

Copyright © 2011, Neuman Vong

License: BSD

https://github.com/firebase/php-jwt
==ENUM==
''lib/php-enum''

PHP Enum implementation inspired from SplEnum

Version: 1.7.7

Copyright (c) 2015 My C-Labs

License: MIT

https://github.com/myclabs/php-enum
==kses==
''lib/kses.php''

HTML/XHTML filter that only allows some elements and attributes

Version: 0.2.2

Copyright © 2002, 2003, 2005 Ulf Harnhammar

License: GNU GPL

http://sourceforge.net/projects/kses

(This library is not currently used in Moodle)
==less.php==
The less.php is a PHP port of the official LESS processor used by moodle themes.

''lib/lessphp''

Version: 1.7.0.10

License: Apache 2.0

http://lessphp.typesettercms.com/

Copyright: Matt Agar and Martin Jantošovič

(This library is not currently used in Moodle)

==loglevel.js==
Minimal lightweight simple logging for JavaScript.

Version 1.7.1

Copyright (c) 2019 Tim Perry

License: MIT

https://github.com/pimterry/loglevel/
==LTI Tool Provider Library for PHP==
"lib/ltiprovider/"

PHP library for communicating with learning tools as per the LTI specification.

Version: 3.0.2

© 2016 IMS Global Learning Consortium Inc. All Rights Reserved. Trademark Policy - (www.imsglobal.org/trademarks)

License: Apache 2

https://github.com/IMSGlobal/LTI-Tool-Provider-Library-PHP
==MathJax==
JavaScript filter library for displaying LaTeX, AsciiMath notation, and MathML.

Not actually included in Moodle. Instead, Moodle [[:en:MathJax filter|has a setting]] for where the library is located to be loaded from. It is currently pointing to the Cloudflare CDN by default.

© Copyright 2009 - 2017 The MathJax Consortium
* Default MathJax version: 2.7.9 (Moodle 3.11)
* License: Apache 2.0
* Homepage: https://www.mathjax.org/
==MatthiasMullie\Minify==
CSS & JavaScript minifier, in PHP

Version 1.3.63

License: MIT

https://github.com/matthiasmullie/minify

==MatthiasMullie\Path converter==
CSS path converter, in PHP

Version 1.1.3

License: MIT

https://github.com/matthiasmullie/path-converter
==MaxMind DB Reader==
lib/maxmind/MaxMind/

PHP API for reading MaxMind DB files

Version: 1.10.1

Copyright MaxMind

License: Apache 2.0

https://github.com/maxmind/MaxMind-DB-Reader-php/
==MDN Polyfills==
''/lib/mdn-polyfills''

A collection of side-effect ECMAScript modules. Minimized, mangled and extremely small thanks to Rollup - next-generation ES6 module bundler.

Version: 5.20.0
Version url-polyfill: 1.1.12

License: MIT

https://www.npmjs.com/package/mdn-polyfills
==mimeTeX==
''filter/tex''

Compiled C program to convert TeX into GIFs

Version: 1.77

Copyright © 2002-2004 John Forkosh Associates, Inc

License: GNU GPL

http://www.forkosh.com/mimetex.html
==MongoDB PHP Library==
''/cache/stores/mongodb/MongoDB/''

MongoDB PHP library

Version: 1.8.0

License: apache 2.0

https://docs.mongodb.com/php-library/
==Mustache.js==
"lib/amd/src/mustache.js"

JS library for displaying mustache templates.

Version: 3.1.0

Copyright (c) 2009 Chris Wanstrath (Ruby)

Copyright (c) 2010-2014 Jan Lehnardt (JavaScript)

Copyright (c) 2010-2015 The mustache.js community

License: MIT

https://github.com/janl/mustache.js/releases
==Mustache==
"lib/mustache"

PHP library for displaying mustache templates.

Version: 2.13.0

Copyright (c) 2010-2016 Justin Hileman

License: MIT

https://github.com/bobthecow/mustache.php/releases
==mp3player==
''lib/mp3player''

Flash movie to play streaming MP3s

Copyright © 2005 Andrew Walker

License: GNU GPL

(This library is not currently used in Moodle)
==overlibmws==
''lib/overlib.js''

Javascript library to enable DHTML popups, floating windows, events etc

Version: July 2004

Copyright © 2002-2004 Foteos Macrides

Copyright © 1998-2004 Erik Bosrup

License: Artistic Open Source License

http://www.macridesweb.com/oltest/

(This library is not currently used in Moodle)
==PclZip==
''lib/pclzip''

Class to create, manage and unpack zip files.

Version: 2.4 RC1

Copyright © 2004 Vincent Blavet (''vincent AT phpconcept DOT net'')

License: GNU GPL

http://www.phpconcept.net

(This library is not currently used in Moodle)
==PEAR OLE Classes==
''lib/pear''

Class to write Excel files

Version: 0.5

Copyright © 2004 Xavier Noguer

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/OLE

(This library is not currently used in Moodle)
==PEAR Spreadsheet_Excel_Writer==
''lib/pear''

Class to write Excel files

Version: 0.9.1

Copyright © 2004 Xavier Noguer and Mika Tuupola

License: LGPL

http://pear.php.net/package/Spreadsheet_Excel_Writer

(This library is not currently used in Moodle)
==PEAR HTML_Quickform==
''lib/pear''

Class to write forms

Version: 3.2.6

Copyright © 2004 Bertrand Mansion, Adam Daniel, Alexey Borzov

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Quickform
==PEAR HTML_Quickform_Renderer_Tableless==
''lib/pear''

Class to render forms without tables

Version: 0.3.4

Copyright © 2005 Mark Wiesemann

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Quickform_Renderer_Tableless
==PEAR HTML_QuickForm_DHTMLRulesTableless==
''lib/pear''

Class to render validation notices with dhtml

Version: 0.1.2

Copyright © 2005 Alexey Borzov, Adam Daniel, Bertrand Mansion, Justin Patrin, Mark Wiesemann

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_QuickForm_DHTMLRulesTableless
==PEAR HTML_Common==
''lib/pear''

Class with many common HTML functions (used by HTML Quickform)

Version: 0.3.4

Copyright © 2004 Adam Daniel, Bertrand Mansion, Klaus Guenther, Alexey Borzov

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Common
==PEAR XML_Parser==
''lib/pear''

Class implementing one handy (sax-expat) XML parser

Version: 1.3.2

Copyright © 2004-2008 The PHP Group & Stephan Schmidt

License: New BSD License

http://pear.php.net/package/XML_Parser

(This library is not currently used in Moodle)
==PHP-CSS-Parser==
''lib/php-css-parser''

A Parser for CSS Files written in PHP.

Version: 8.3.1

Copyright (c) 2011 Raphael Schweikert, http://sabberworm.com/

License: MIT

https://github.com/sabberworm/PHP-CSS-Parser
==PHPExcel==
''lib/phpexcel/PHPExcel.php''

Library to read, write and create spreadsheet documents in PHP.

Version 1.8.1

Copyright © 2006 - 2015 PHPExcel
License: LGPL

https://github.com/PHPOffice/PHPExcel

(This library is not currently used in Moodle)
==PhpSpreadsheet==
''lib/phpspreadsheet''

Library to read, write and create spreadsheet documents in PHP.

Version 1.16.0

License: LGPL

https://github.com/PHPOffice/PhpSpreadsheet
==PHP mailer==
''lib/class.phpmailer.php''

Class for sending email using either sendmail, PHP mail(), or SMTP. Methods are based upon the standard AspEmail(tm) classes.

Version 6.2.0

Copyright © 2003 Brent R. Matzelle (''bmatzelle AT yahoo DOT com'')
License: LGPL

http://phpmailer.sourceforge.net
https://github.com/PHPMailer/PHPMailer/releases
==PHP Markdown==
''lib/markdown.php''

Functions to convert from the Markdown text format into clean XHTML.

Version: 1.9.0 (with modifications)
* @copyright 2004-2016 Michel Fortin <https://michelf.com/projects/php-markdown/>

* @copyright (Original Markdown) 2004-2006 John Gruber <https://daringfireball.net/projects/markdown/>
All rights reserved.

License: BSD

http://www.michelf.com/projects/php-markdown/
==PHP-ML==
''lib/mlbackend/php/phpml''

Machine learning library used to generate data for the Analytics system.

Version: 0.8.0
* @copyright 2016-2018 Arkadiusz Kondas <arkadiusz.kondas[at]gmail>
License: MIT

https://php-ml.readthedocs.io/
==Popper.js==
"admin/tool/usertours/amd/src/popper.js"

A kickass library used to created Poppers in web applications

Version: 1.12.6

© 2016 Federico Zivolo and contributors

License: MIT

https://github.com/FezVrasta/popper.js
==Rangy==
"/lib/editor/atto/yui/src/rangy/js/*.*"

A cross-browser JavaScript range and selection library.

Version: 1.3.0

Copyright (c) 2014 Tim Down

License: MIT

https://github.com/timdown/rangy
==RTLCSS for PHP==
"lib/rtlcss"

RTLCSS is a framework for converting Left-To-Right (LTR) Cascading Style Sheets(CSS) to Right-To-Left (RTL).

© 2016 Frédéric Massart

License: MIT

https://github.com/moodlehq/rtlcss-php
==RequireJS==
''/lib/requirejs/''

RequireJS is a JavaScript file and module loader.

Version 2.3.5

License: new BSD or MIT

http://requirejs.org/
==scssphp==
''/lib/scssphp/''

scssphp is a compiler for SCSS written in PHP.

Version: 1.10.0

Copyright (c) 2015 Leaf Corcoran

License: MIT

http://leafo.github.io/scssphp
==SimplePie==
"/lib/simplepie"

Simple Pie helps with blogs.

Version 1.5.6

License: BSD

https://github.com/simplepie/simplepie
==Snoopy==
''lib/snoopy''

A PHP net client

Version: 1.0

Copyright © 1999-2000 Monte Ohrt (''monte AT ispi DOT net'')
License: GNU LGPL

http://snoopy.sourceforge.com

(This library is not currently used in Moodle)
==SMTP class==
''lib/class.smtp.php''

Class that can be used to connect and communicate with any SMTP server. It implements all the SMTP functions defined in RFC821 except TURN.

Version: 03/26/2001

Copyright © 2001 Chris Ryan (''chris AT greatbridge DOT com'')

(This library is not currently used in Moodle)
==Spike PHPCoverage==
''lib/spikephpcoverage''

PHP code coverage reporting tool

Version: 0.8.2 (with modifications)

Copyright © 2004 SpikeSource Inc

License: LGPL

http://developer.spikesource.com/projects/phpcoverage

(This library is not currently used in Moodle)
==Spout==
"lib/spout"

Library for importing and exporting csv / excel / ODS files.

Version 3.3.0

License: Apache

https://github.com/box/spout/
==TCPDF Class==
''lib/tcpdf''

Class to generate PDF files

Version: 6.4.1

Copyright Olivier PLATHEY

License: LGPL-v3.0-only

http://www.setasign.com/products/fpdi/downloads
==Twitter Bootstrap==
''/theme/boost/scss/bootstrap/''

HTML, CSS, and JavaScript framework for developing responsive, mobile-first projects on the web.

Version: 4.6.0

Copyright (c) 2011-2021 Twitter, Inc.

Copyright (c) 2011-2021 The Bootstrap Authors

Licence: MIT

https://getbootstrap.com/
==Typo3 Character Set Class==
''lib/typo3''

Class for conversion between charsets and multibyte-savy operations with strings.

Version: 4.7.19

Copyright © 2003-2005 Kasper Skaarhoj

Licence: GNU GPL

http://typo3.org/
==truncate.js==
''amd/src/truncate.js''

Dead simple HTML-safe truncation via the DOM. It truncates HTML code, and has several options such as length, finishBlock, noBreak...

Version: 0.0.1

Licence: MIT

https://github.com/pathable/truncate
==Video.js==
''/media/player/videojs/amd/src/video-lazy.js''

"/media/player/videojs/videojs/"

JavaScript library that makes it easier to work with and build on HTML5 video

Version: 7.10.0

Copyright Brightcove, Inc

Licence: Apache

http://videojs.com/
==Video.js - The Flash tech==
''/media/player/videojs/amd/src/videojs-flash-lazy.js"

The Flash tech for video.js

Version: 2.2.1

Copyright Brightcove, Inc

Licence: Apache

https://github.com/videojs/videojs-flash
==Video.js - Custom Flash Player==
''/media/player/videojs/amd/src/videojs-flash-lazy.js"

Custom Flash Player for VideoJS

Version: 5.4.2

Copyright Brightcove, Inc

Licence: Apache

https://github.com/videojs/video-js-swf/releases
==WebRTC adapter==
''amd/src/adapter.js''

JavaScript library to insulate apps from spec changes and prefix differences in WebRTC. The prefix differences are mostly gone these days but differences in behaviour between browsers remain.

Version: 7.4.0

Copyright (c) 2014, The WebRTC project authors. All rights reserved. Copyright (c) 2018, The adapter.js project authors.

Licence: BSD 3 Clause

https://github.com/webrtc/adapter
==XHProf==
''lib/xhprof''

A Hierarchical Profiler for PHP

Version: 2.2.3

Copyright © 2009 Phacility

Licence: Apache

https://github.com/phacility/xhprof
==Yahoo User Interface==
''lib/yui''

The Yahoo! User Interface Library is a set of utilities and controls, in JavaScript, for building richly interactive web applications using techniques such as DOM scripting, DHTML and AJAX. The YUI Library also includes several core CSS resources.Set of user-interface components using AJAX, DHTML etc. We use it for all our AJAX-related stuff.

CVS version: 3.17.2

Copyright (c) 2006, Yahoo! Inc.

Licence: BSD

http://developer.yahoo.com/yui/
==ZipStream-PHP==
''/lib/zipstream''

PHP ZIP Streaming Library

Version: 2.1.0

Copyright (C) 2007-2009 Paul Duncan <pabs@pablotron.org>

Copyright (C) 2014 Jonatan Männchen <jonatan@maennchen.ch>

Copyright (C) 2014 Jesse G. Donat <donatj@gmail.com>

Copyright (C) 2018 Nicolas CARPi <nicolas.carpi@curie.fr>

Licence: MIT

https://packagist.org/packages/maennchen/zipstream-php
[[Category:Credits]]

Category:Obsolete

2021-10-14T13:34:59Z

Pholden: Correct obsolete tag.

These pages are no longer in use.

A page can be marked as obsolete by adding <syntaxhighlight>{{obsolete}}</syntaxhighlight> to the page.

Core APIs

2021-10-07T11:52:20Z

Pholden: Link to Report builder API.

Moodle has a number of core APIs that provide tools for Moodle scripts.

They are essential when writing [[Plugins|Moodle plugins]].

==Most-used General APIs==
These APIs are critical and will be used by nearly every Moodle plugin.
=== Access API (access) ===
The [[Access API]] gives you functions so you can determine what the current user is allowed to do, and it allows modules to extend Moodle with new capabilities.
=== Data manipulation API (dml) ===
The [[Data manipulation API]] allows you to read/write to databases in a consistent and safe way.
=== File API (files) ===
The [[File API]] controls the storage of files in connection to various plugins.
=== Form API (form) ===
The [[Form API]] defines and handles user data via web forms.
=== Logging API (log) ===
The [[Events API]] allows you to log events in Moodle, while [[Logging 2]] describes how logs are stored and retrieved.
=== Navigation API (navigation) ===
The [[Navigation API]] allows you to manipulate the navigation tree to add and remove items as you wish.
=== Page API (page) ===
The [[Page API]] is used to set up the current page, add JavaScript, and configure how things will be displayed to the user.
=== Output API (output) ===
The [[Output API]] is used to render the HTML for all parts of the page.
=== String API (string) ===
The [[String API]] is how you get language text strings to use in the user interface. It handles any language translations that might be available.
=== Upgrade API (upgrade) ===
The [[Upgrade API]] is how your module installs and upgrades itself, by keeping track of its own version.
=== Moodlelib API (core) ===
The [[Moodlelib API]] is the central library file of miscellaneous general-purpose Moodle functions. Functions can over the handling of request parameters, configs, user preferences, time, login, mnet, plugins, strings and others. There are plenty of defined constants too.
==Other General APIs==
=== Admin settings API (admin) ===
The [[Admin settings]] API deals with providing configuration options for each plugin and Moodle core.
=== Analytics API (analytics) ===
The [[Analytics API]] allow you to create prediction models and generate insights.
=== Availability API (availability) ===
The [[Availability API]] controls access to activities and sections.
=== Backup API (backup) ===
The [[Backup API]] defines exactly how to convert course data into XML for backup purposes, and the [[Restore API]] describes how to convert it back the other way.
=== Cache API (cache) ===
The [[The Moodle Universal Cache (MUC)]] is the structure for storing cache data within Moodle. [[Cache_API]] explains some of what is needed to use a cache in your code.
=== Calendar API (calendar) ===
The [[Calendar API]] allows you to add and modify events in the calendar for user, groups, courses, or the whole site.
=== Check API (check) ===
The [[Check API]] allows you to add security, performance or health checks to your site.
=== Comment API (comment) ===
The [[Comment API]] allows you to save and retrieve user comments, so that you can easily add commenting to any of your code.
=== Competency API (competency) ===
The [[Competency API]] allows you to list and add evidence of competencies to learning plans, learning plan templates, frameworks, courses and activities.
=== Data definition API (ddl) ===
The [[Data definition API]] is what you use to create, change and delete tables and fields in the database during upgrades.
=== Editor API ===
The [[Editor API]] is used to control HTML text editors.
=== Enrolment API (enrol) ===
The [[Enrolment API]] deals with course participants.
=== Events API (event) ===
The [[Events API]] allows to define "events" with payload data to be fired whenever you like, and it also allows you to define handlers to react to these events when they happen. This is the recommended form of inter-plugin communication. This also forms the basis for logging in Moodle.
=== Experience API (xAPI) ===
The Experience API (xAPI) is an e-learning standard that allows learning content and learning systems to speak to each other. The [[Experience API (xAPI)]]
allows any plugin to generate and handle xAPI standard statements.
=== External functions API (external) ===
The [[External functions API]] allows you to create fully parametrised methods that can be accessed by external programs (such as [[Web services]]).
=== Favourites API ===
The [[Favourites API]] allows you to mark items as favourites for a user and manage these favourites. This is often referred to as 'Starred'.
=== H5P API (h5p) ===
The [[H5P API]] allows plugins to make some decisions/implementations related to the [[H5P|H5P integration]].
=== Lock API (lock) ===
The [[Lock API]] lets you synchronise processing between multiple requests, even for separate nodes in a cluster.
=== Message API (message) ===
The [[Message API]] lets you post messages to users. They decide how they want to receive them.
=== Media API (media) ===
The [[Media_players#Using_media_players|Media]] API can be used to embed media items such as audio, video, and Flash.
=== My profile API ===
The [[My profile API]] is used to add things to the profile page.
=== OAuth 2 API (oauth2) ===
The [[OAuth 2 API]] is used to provide a common place to configure and manage external systems using OAuth 2.
=== Payment API (payment) ===
The [[Payment API]] deals with payments.
=== Preference API (preference) ===
The [[Preference API]] is a simple way to store and retrieve preferences for individual users.
=== Portfolio API (portfolio) ===
The [[Portfolio API]] allows you to add portfolio interfaces on your pages and allows users to package up data to send to their portfolios.
=== Privacy API (privacy) ===
The [[Privacy API]] allows you to describe the personal data that you store, and provides the means for that data to be discovered, exported, and deleted on a per-user basis.
This allows compliance with regulation such as the General Data Protection Regulation (GDPR) in Europe.
=== Rating API (rating) ===
The [[Rating API]] lets you create AJAX rating interfaces so that users can rate items in your plugin. In an activity module, you may choose to aggregate ratings to form grades.
=== Report builder API (reportbuilder) ===
The [[Report builder API]] allows you to create reports in your plugin, as well as providing custom reporting data which users can use to build their own reports.
=== RSS API (rss) ===
The [[RSS API]] allows you to create secure RSS feeds of data in your module.
=== Search API (search) ===
The [[Search API]] allows you to index contents in a search engine and query the search engine for results.
=== Tag API (tag) ===
The [[Tag API]] allows you to store tags (and a tag cloud) to items in your module.
=== Task API (task) ===
The [[Task API]] lets you run jobs in the background. Either once off, or on a regular schedule.
=== Time API (time) ===
The [[Time API]] takes care of translating and displaying times between users in the site.
=== Testing API (test) ===
The testing API contains the Unit test API ([[PHPUnit]]) and Acceptance test API ([[Acceptance testing]]). Ideally all new code should have unit tests written FIRST.
=== User-related APIs (user) ===
This is a rather informal grouping of miscellaneous [[User-related APIs]] relating to sorting and searching lists of users.
=== Web services API (webservice) ===
The [[Web services API]] allows you to expose particular functions (usually external functions) as web services.
=== Badges API (badges) ===
The [https://docs.moodle.org/dev/OpenBadges_User_Documentation Badges] user documentation (is a temp page until we compile a proper page with all the classes and APIs that allows you to manage particular badges and OpenBadges Backpack).
=== Custom fields API ===
The [[Custom fields API]] allows you to configure and add custom fields for different entities

== Activity module APIs ==
Activity modules are the most important plugin in Moodle. There are several core APIs that service only Activity modules.
=== Activity completion API (completion) ===
The [[Activity completion API]] is to indicate to the system how activities are completed.
=== Advanced grading API (grading) ===
The [[Advanced grading API]] allows you to add more advanced grading interfaces (such as rubrics) that can produce simple grades for the gradebook.
=== Conditional activities API (condition) - deprecated in 2.7 ===
The deprecated [[Conditional activities API]] used to provide conditional access to modules and sections in Moodle 2.6 and below. It has been replaced by the [[Availability API]].
=== Groups API (group) ===
The [[Groups API]] allows you to check the current activity group mode and set the current group.
=== Gradebook API (grade) ===
The [[Gradebook API]] allows you to read and write from the gradebook. It also allows you to provide an interface for detailed grading information.
=== Plagiarism API (plagiarism) ===
The [[Plagiarism API]] allows your activity module to send files and data to external services to have them checked for plagiarism.
=== Question API (question) ===
The [[Question API]] (which can be divided into the Question bank API and the Question engine API), can be used by activities that want to use questions from the question bank.
== See also ==
* [[Plugins]] - plugin types also have their own APIs
* [[Callbacks]] - list of all callbacks in Moodle
* [[Coding style]] - general information about writing PHP code for Moodle
[[ja:コアAPI]]

Report builder API

2021-07-28T09:40:19Z

Pholden: /* Create an entity */

== Report Builder API overview ==
== System Reports ==
=== Introduction ===
System reports are a consistent way of providing reporting data, with paging, filtering, exporting standardized across them. Once the groundwork is done in defining the report elements in entities, it's possible to implement them with minimal code just by adding entities to the report, and defining which elements you want to use from them.
=== Column ===
==== Column overview ====
Column instances define the data captured/displayed within a report column - typically: 
* How the data is retrieved, either a simple SQL table.field fragment or an expression that returns a value
* They type of data that is being retrieved (int, text, datetime, etc)
* How that data should be presented in a report (for instance calling userdate() on datetime types)
==== Column types ====
* '''Text'''
* '''Integer''' (Integer numbers)
* '''Float''' (Decimal numbers)
* '''Timestamp''' (Dates)
* '''Boolean''' (Yes / No values)
* '''Longtext'''
==== Creating columns ====
To create a new column, just create a new instance of '''reportbuilder/classes/local/report/column.php''' class with: 
<syntaxhighlight lang="php">
* string $name
* ?lang_string $title
* string $entityname
</syntaxhighlight>
And use: 
'''add_joins()''' to add any extra SQL joins the column might need 
'''set_type()''' to add the column type (All constant types are defined within the same column class) 
'''set_is_sortable()''' to define if column can be sorted (For example we don't want to sort if the column shows just a picture) 
'''add_callback()''' to format the output of the column 
'''add_field()''' to add any db fields format callback might need 
Example:
<syntaxhighlight lang="php">
$columns[] = (new column(
'starttime',
new lang_string('task_starttime', 'admin'),
$this->get_entity_name()
))
->add_joins($this->get_joins())
->set_type(column::TYPE_TIMESTAMP)
->add_field("{$tablealias}.timestart")
->set_is_sortable(true)
->add_callback([format::class, 'userdate']);
</syntaxhighlight>
=== Filter ===
==== Filter overview ====
Report filters can be defined for a report and allow users to narrow down (filter) the data that is displayed in a report
* They define the data being filtered, either a simple SQL fragment or expression.
* The type of filtering being performed (int, text, datetime, etc).
Filter types are extendable, allowing for the addition of many more as suits each use case. We have provided common ones that cover most use cases.

Note that filters & columns are entirely separate concepts in the report, and each can be used without a matching column/filter (that is to say, we can add a report filter for a user field without needing the column for the same field to be present in the report).
==== Filter types ====
* '''Text''' (reportbuilder/classes/local/filters/text.php)
* '''Date''' (reportbuilder/classes/local/filters/date.php)
* '''Number''' (reportbuilder/classes/local/filters/number.php)
* '''Boolean Select''' (reportbuilder/classes/local/filters/boolean_select.php)
* '''Select''' (reportbuilder/classes/local/filters/select.php)
* '''Course selector''' (reportbuilder/classes/local/filters/course_selector.php)
==== Creating filters ====
To create a new filter, just create a new instance of '''reportbuilder/classes/local/report/filter.php''' class with: 
<syntaxhighlight lang="php">
* string $filterclass
* string $name
* lang_string $header
* string $entityname
* string $fieldsql = ''
* array $fieldparams = []
</syntaxhighlight>
Example:
<syntaxhighlight lang="php">
$filters[] = (new filter(
course_selector::class,
'courseselector',
new lang_string('courses'),
$this->get_entity_name(),
"{$tablealias}.id"
))
->add_joins($this->get_joins());
</syntaxhighlight>
=== Entity ===
==== Entity overview ====
Entities are simply collections of report elements (currently columns and filters). They allow for common elements to be defined once, and then re-used in all reports - developers can choose to use as many or as few of the elements from each entity as required. We have provided user and course entities. They can be joined to reports using standard SQL query syntax

All report elements can be defined within the reports themselves - but entities mean it's much easier to create re-usable components, and will also help in the long term with custom reports
==== Create an entity ====
To create an entity, the new entity class must extend '''/reportbuilder/classes/local/entities/base.php''' class and must include these methods:
<syntaxhighlight lang="php">
get_default_table_aliases()
get_default_entity_title()
initialise()
</syntaxhighlight>
===== get_default_table_aliases() =====
Defines the SQL alias for the database tables the entity uses.
===== get_default_entity_title() =====
Defines the default title for this entity.
===== initialise() =====
This is where we '''add''' the entity columns and filters.
==== Examples ====
Report Builder has two entities as an example to start building reports:

'''User entity''': reportbuilder/classes/local/entities/user.php 
'''Course entity''': reportbuilder/classes/local/entities/course.php
=== Actions ===
Report actions can be defined in system reports to provide CTA links for each row in the report. Using :placeholder elements in the action URLs allows them to be specific to the row content - e.g. to always provide a link to the current user/course of the current row
<syntaxhighlight lang="php">
$this->add_action((new action(
new moodle_url('/admin/tasklogs.php', ['logid' => ':id']),
new pix_icon('e/search', get_string('view')),
[],
true,
)));
</syntaxhighlight>
=== System reports ===
System reports are a consistent way of providing reporting data, with paging, filtering, exporting standardized across them. Once the groundwork is done in defining the report elements in entities, it's possible to implement them with minimal code just by adding entities to the report, and defining which elements you want to use from them
==== Create a new system report using entities ====
To create a new system report just create a new class extending '''reportbuilder/classes/system_report.php'''.

The first method that we need is '''initialise()''':
<syntaxhighlight lang="php">
/**
* Initialise report, we need to set the main table, load our entities and set columns/filters
*/
protected function initialise(): void {
</syntaxhighlight>
The initialise method needs to get the main entity, set the main table it needs to use and add the entity to the report:
<syntaxhighlight lang="php">
// Our main entity, it contains all of the column definitions that we need.
$entitymain = new task_log();
$entitymainalias = $entitymain->get_table_alias('task_log');

$this->set_main_table('task_log', $entitymainalias);
$this->add_entity($entitymain);
</syntaxhighlight>
After that, if the report will have 'Actions', it needs to define the columns it will use:
<syntaxhighlight lang="php">
$this->add_base_fields("{$entitymainalias}.id");
</syntaxhighlight>
Now, after adding our first entity, the report can use the columns and filters from it OR more entities can be added to the report using SQL joins:
<syntaxhighlight lang="php">
$entityuser = new user();
$entituseralias = $entityuser->get_table_alias('user');
$this->add_entity($entityuser->add_join(
"LEFT JOIN {user} {$entituseralias} ON {$entituseralias}.id = {$entitymainalias}.userid"
));
</syntaxhighlight>
Once all entities have been added it needs to define which columns it needs to show in the order we need:
<syntaxhighlight lang="php">
$columns = [
'task_log:name',
'task_log:type',
'user:fullname',
'task_log:starttime',
];

$this->add_columns_from_entities($columns);
</syntaxhighlight>
After defining the columns, it needs to define all the filters (or empty array for no filters) that it will use:
<syntaxhighlight lang="php">
$filters = [
'task_log:name',
'task_log:result',
'task_log:timestart',
];

$this->add_filters_from_entities($filters);
</syntaxhighlight>
In case it needs actions for each report row, they can be defined like:
<syntaxhighlight lang="php">
// Action to download individual task log.
$this->add_action((new action(
new moodle_url('/admin/tasklogs.php', ['logid' => ':id', 'download' => true]),
new pix_icon('t/download', get_string('download')),
)));
</syntaxhighlight>
Once the whole report has been defined, is possible to set if the report will be downloadable or not:
<syntaxhighlight lang="php">
$this->set_downloadable(true);
</syntaxhighlight>
==== Use an entity ====
==== Override display name for a column ====
It's possible to override the display name of a column, if you don't want to use the value provided by the entity.
<syntaxhighlight lang="php">
if ($column = $this->get_column('user:fullname')) {
$column->set_title(new lang_string('user', 'admin'));
}
</syntaxhighlight>
==== Set a default initial sort direction ====
It's possible to set a default initial sort direction for one column.
<syntaxhighlight lang="php">
$this->set_initial_sort_column('task_log:starttime', SORT_DESC);
</syntaxhighlight>

Privacy API/Utilities

2021-07-14T19:53:25Z

Pholden: Fix syntaxhighlight tags.

While implementing the privacy API into your plugin, there are CLI scripts that can help you to test things on the fly. Just don't forget these are not supposed to replace proper unit tests.

Put these scripts into the root of your Moodle development installation and run them via command line. See [[Privacy API]] for the full guide on implementing the API in your plugin.

== Test of privacy API compliance ==

<syntaxhighlight lang="php">
<?php

// Set this if you want to run the script for one component only. Otherwise leave empty.
$CHECK_COMPONENT = '';

define('CLI_SCRIPT', true);

require_once('config.php');

$user = \core_user::get_user(2);

\core\session\manager::init_empty_session();
\core\session\manager::set_user($user);

$rc = new \ReflectionClass(\core_privacy\manager::class);
$rcm = $rc->getMethod('get_component_list');
$rcm->setAccessible(true);

$manager = new \core_privacy\manager();
$components = $rcm->invoke($manager);

$list = (object) [
'good' => [],
'bad' => [],
];

foreach ($components as $component) {
if ($CHECK_COMPONENT && $component !== $CHECK_COMPONENT) {
continue;
}
$compliant = $manager->component_is_compliant($component);
if ($compliant) {
$list->good[] = $component;
} else {
$list->bad[] = $component;
}
}

echo "The following plugins are not compliant:\n";
echo "=> " . implode("\n=> ", array_values($list->bad)) . "\n";

echo "\n";
echo "Testing the compliant plugins:\n";
foreach ($list->good as $component) {
$classname = \core_privacy\manager::get_provider_classname_for_component($component);
echo "== {$component} ($classname) ==\n";
if (check_implements($component, \core_privacy\local\metadata\null_provider::class)) {
echo " Claims not to store any data with reason:\n";
echo " '" . get_string($classname::get_reason(), $component) . "'\n";
}
else if (check_implements($component, \core_privacy\local\metadata\provider::class)) {
$collection = new \core_privacy\local\metadata\collection($component);
$classname::get_metadata($collection);
$count = count($collection->get_collection());
echo " Found {$count} items of metadata\n";
if (empty($count)) {
echo "!!! No metadata found!!! This an error.\n";
}

if (check_implements($component, \core_privacy\local\request\user_preference_provider::class)) {
$userprefdescribed = false;
foreach ($collection->get_collection() as $item) {
if ($item instanceof \core_privacy\local\metadata\types\user_preference) {
$userprefdescribed = true;
echo " ".$item->get_name()." : ".get_string($item->get_summary(), $component) . "\n";
}
}
if (!$userprefdescribed) {
echo "!!! User preference found, but was not described in metadata\n";
}
}

if (check_implements($component, \core_privacy\local\request\core_user_data_provider::class)) {
// No need to check the return type - it's enforced by the interface.
$contextlist = $classname::get_contexts_for_userid($user->id);
$approvedcontextlist = new \core_privacy\local\request\approved_contextlist($user, $contextlist->get_component(), $contextlist->get_contextids());
if (count($approvedcontextlist)) {
$classname::export_user_data($approvedcontextlist);
echo " Successfully ran a test export\n";
} else {
echo " Nothing to export.\n";
}
}
if (check_implements($component, \core_privacy\local\request\shared_data_provider::class)) {
echo " This is a shared data provider\n";
}
}
}

echo "\n\n== Done ==\n";

function check_implements($component, $interface) {
$manager = new \core_privacy\manager();
$rc = new \ReflectionClass(\core_privacy\manager::class);
$rcm = $rc->getMethod('component_implements');
$rcm->setAccessible(true);

return $rcm->invoke($manager, $component, $interface);
}
</syntaxhighlight>

== Test of exporting user data ==

<syntaxhighlight lang="php">
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.

/**
* Helper utility to perform a test export.
*
* @copyright 2018 Andrew Nicols <andrew@nicols.co.uk>
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/

define('CLI_SCRIPT', true);
require_once('config.php');
require_once("$CFG->libdir/clilib.php");

list($options, $unrecognized) = cli_get_params(
[
'username' => '',
'userid' => '',
],
[]
);

$user = null;
$username = $options['username'];
$userid = $options['userid'];

if (!empty($options['username'])) {
$user = \core_user::get_user_by_username($options['username']);
} else if (!empty($options['userid'])) {
$user = \core_user::get_user($options['userid']);
}

while (empty($user)) {
if (!empty($username)) {
echo "Unable to find a user with username '{$username}'.\n";
echo "Try again.\n";
} else if (!empty($userid)) {
echo "Unable to find a user with userid '{$userid}'.\n";
echo "Try again.\n";
}
$username = readline("Username: ");
$user = \core_user::get_user_by_username($username);
}

echo "Processing export for " . fullname($user) . "\n";

\core\session\manager::init_empty_session();
\core\session\manager::set_user($user);

$PAGE = new moodle_page();
$OUTPUT = new core_renderer($PAGE, RENDERER_TARGET_GENERAL);

$manager = new \core_privacy\manager();

$approvedlist = new \core_privacy\local\request\contextlist_collection($user->id);

$contextlists = $manager->get_contexts_for_userid($user->id);
foreach ($contextlists as $contextlist) {
$approvedlist->add_contextlist(new \core_privacy\local\request\approved_contextlist(
$user,
$contextlist->get_component(),
$contextlist->get_contextids()
));
}

$exportedcontent = $manager->export_user_data($approvedlist);
$basedir = make_temp_directory('privacy');
$exportpath = make_unique_writable_directory($basedir, true);
$fp = get_file_packer();
$fp->extract_to_pathname($exportedcontent, $exportpath);

echo "\n";
echo "== File export was uncompressed to {$exportpath}\n";
echo "============================================================================\n";
</syntaxhighlight>

== Test of deleting user data ==

<syntaxhighlight lang="php">
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.

define('CLI_SCRIPT', true);
require_once('config.php');
require_once("$CFG->libdir/clilib.php");

list($options, $unrecognized) = cli_get_params(
[
'username' => '',
'userid' => '',
],
[]
);

$user = null;
$username = $options['username'];
$userid = $options['userid'];

if (!empty($options['username'])) {
$user = \core_user::get_user_by_username($options['username']);
} else if (!empty($options['userid'])) {
$user = \core_user::get_user($options['userid']);
}

while (empty($user)) {
if (!empty($username)) {
echo "Unable to find a user with username '{$username}'.\n";
echo "Try again.\n";
} else if (!empty($userid)) {
echo "Unable to find a user with userid '{$userid}'.\n";
echo "Try again.\n";
}
$username = readline("Username: ");
$user = \core_user::get_user_by_username($username);
}

echo "Processing delete for " . fullname($user) . "\n";

\core\session\manager::init_empty_session();
\core\session\manager::set_user($user);

$manager = new \core_privacy\manager();

$approvedlist = new \core_privacy\local\request\contextlist_collection($user->id);

$trace = new text_progress_trace();
$contextlists = $manager->get_contexts_for_userid($user->id, $trace);
foreach ($contextlists as $contextlist) {
$approvedlist->add_contextlist(new \core_privacy\local\request\approved_contextlist(
$user,
$contextlist->get_component(),
$contextlist->get_contextids()
));
}

$manager->delete_data_for_user($approvedlist, $trace);
</syntaxhighlight>

[[Category:Privacy]]
[[Category:GDPR]]
[[Category:Utilities]]
[[Category:SampleCode]]

Moodle libraries credits

2021-05-11T08:07:23Z

Pholden: Library updates for 3.11.

Some of Moodle's libraries were written by other people, and are being redistributed as part of Moodle under their respective open source licenses that thankfully allow us to do so. Thanks to the authors of all these excellent products - without them Moodle would be missing important functionality. Copyright information for each package is included below:

==ADOdb==

''lib/adodb''

Database abstraction library for MySQL, PostgreSQL, MSSQL, Oracle, Interbase, Foxpro, Access, ADO, Sybase, DB2 and ODBC.

Version: 5.20.14

@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.

@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community

License: Dual LGPL and BSD-style

http://adodb.sourceforge.net

==Bennu==

"lib/bennu"

Bennu is an object-oriented library written in PHP that implements the iCalendar standard (RFC 2445).

Version: 0.1 (customized since then)

Copyright (c) 2005, Jon Papaioannou

License: LGPL 2.1+

http://bennu.sourceforge.net/

==Amazon S3==

''repository/s3/S3.php''

A standalone Amazon S3 (REST) client for PHP 5.2.x using CURL that does not require PEAR.

Version: 0.5.1

Copyright (c) 2013, Donovan Schönknecht

License: BSD 2-Clause

https://github.com/tpyo/amazon-s3-php-class/releases

==CAS==

''auth/cas/CAS''

phpCAS library to support CAS authentication plugin

Version: 1.3.7

Copyright Jasig

License: Apache License 2.0

https://wiki.jasig.org/display/CASC/phpCAS

==Chart.js==

''lib/amd/src/chartjs-lazy.js''

Simple yet flexible JavaScript charting for designers & developers

Version: 2.9.4

Copyright 2016 Nick Downie

License: MIT

http://www.chartjs.org

==CodeMirror==

''lib/editor/atto/plugins/html/yui/src/codemirror''

CodeMirror is a versatile text editor implemented in JavaScript for the browser.

Version: 5.59.4

License: MIT

https://github.com/codemirror/CodeMirror

==Emoji-data==

''lib/emoji-data''

Library to parse easily data and spritesheets for emoji

License: MIT

https://github.com/iamcal/emoji-data/

==EvalMath==

''lib/evalmath''

Class to safely evaluate math expressions

Copyright Miles Kaufmann

License: BSD

http://www.twmagic.com/

==Flexitour==

"admin/tool/usertours/amd/src/tour.js"

A JS library for tours

© 2016 Andrew Nicols and contributors

License: GPLv3

https://github.com/andrewnicols/flexitour

==FLV player==

''filter/mediaplugin/flvplayer.swf''

Flash movie to play FLV files

Copyright Jeroen Wijering

License: GNU GPL

http://www.jeroenwijering.com

(This library is not currently used in Moodle)

== GeoIp2 ==

''lib/maxmind/GeoIp2''

Library for processing of GeoIP data files

Version: 2.10.0

Copyright MaxMind

License: Apache 2.0

https://github.com/maxmind/GeoIP2-php

== GeoPattern==

''lib/geopattern-php''

Library for creating beautiful generative background images from a string

Version: 1.1.1

Copyright 2015 Leaf Corcoran

License: MIT

https://github.com/RedeyeGroup/geopattern-php

==Google APIs==

"lib/google"

Library Google APIs Client Library for PHP

Version: 1.1.7

License: Apache License Version 2.0

https://github.com/google/google-api-php-client

==Graph Class==

''lib/graphlib.php''

Class to draw line, point, bar, and area graphs, including numeric x-axis and double y-axis.

Version: 1.6.3 (with modifications)

Copyright © 2000 Herman Veluwenkamp (''hermanV AT mindless DOT com'')

License: LGPL

==H5P==

''lib/h5p''

The general H5P library

Version: 1.24

Copyright © Joubel

License: GPL-3.0

https://github.com/h5p/h5p-php-library/

==Horde==

''lib/horde''

Library used by the inbound e-mail handling system.

Version: 5.2.22

Copyright © Horde LLC

License: LGPL

http://www.horde.org/

==html2text==

''lib/html2text''

PHP script to convert HTML into an approximate text equivalent

Version: 4.3.1

Copyright (c) 2005-2007 Jon Abernathy <jon@chuggnutt.com>

License: GNU GPL

https://github.com/mtibben/html2text.git

==htmlArea==

''lib/editor''

Javascript/HTML script to put a GUI editor in textareas on Internet Explorer and Mozilla

Version: 3.0 beta (with modifications)

Copyright © 2002 interactivetools.com, inc.

License: htmlArea License (based on BSD license)

(This library is not currently used in Moodle)

==HTML Purifier==

"lib/htmlpurifier"

Filters HTML.

Version: 4.13.0

License: LGPL

==IP-Atlas==

''lib/ipatlas''

PHP scripts to show the location of an IP address on a map.

Version: 1.0 (with modifications)

Copyright © 2002 Ivan Kozik

License: GNU GPL

http://www.xpenguin.com/ip-atlas.php

(This library is not currently used in Moodle)

==Jabber - XMPPHP==

''lib/jabber''

PHP library for XMPP (aka Jabber, Google Talk, etc).

Version: 0.1rc2-r77

Copyright: 2008 Nathanael C. Fritz

License: GPL

http://code.google.com/p/xmpphp

==jQuery==

''lib/jquery''

jQuery is a fast, small, and feature-rich JavaScript library widely used on moodle.

Version: 3.4.1

Copyright: 2016 The jQuery Foundation

License: MIT

https://jquery.com

==jQuery migrate==

''lib/jquery/jquery-migrate-1.4.0.js''

Library used migrate older jQuery code to jQuery 3.0.

Version: 1.4.0

Copyright: 2016 The jQuery Foundation and other contributors

License: MIT

https://github.com/jquery/jquery-migrate

(This library is not currently used in Moodle)

==jQuery UI==

''lib/jquery/ui-1.12.1/''

jQuery UI is a set of user interface interactions, effects, widgets, and themes built on top of the jQuery library.

Version: 1.12.1

Copyright: 2016 The jQuery Foundation and other contributors

License: MIT

https://github.com/jquery/jquery-migrate

==JavaScript Beautifier==

''yui/src/beautify''

Beautify HTML code in Atto.

Version: 1.13.0

Copyright (c) 2007-2018 Einar Lielmanis, Liam Newman, and contributors.

License: MIT

https://beautifier.io/

==Services_JSON==

''lib/json''

Allows PHP->JS communication via JSON

Version: 1.3.1

Copyright © 2005 Michal Migurski

License: Modified BSD (GPL-compatible)

http://pear.php.net/pepr/pepr-proposal-show.php?id=198

(This library is not currently used in Moodle)

==JWT==

''lib/php-jwt''

A simple library to encode and decode JSON Web Tokens (JWT) in PHP, conforming to RFC 7519

Version: 5.0.0

Copyright © 2011, Neuman Vong

License: BSD

https://github.com/firebase/php-jwt

==ENUM==

''lib/php-enum''

PHP Enum implementation inspired from SplEnum

Version: 1.7.6

Copyright (c) 2015 My C-Labs

License: MIT

https://github.com/myclabs/php-enum

==kses==

''lib/kses.php''

HTML/XHTML filter that only allows some elements and attributes

Version: 0.2.2

Copyright © 2002, 2003, 2005 Ulf Harnhammar

License: GNU GPL

http://sourceforge.net/projects/kses

(This library is not currently used in Moodle)

==less.php==

The less.php is a PHP port of the official LESS processor used by moodle themes.

''lib/lessphp''

Version: 1.7.0.10

License: Apache 2.0

http://lessphp.typesettercms.com/

Copyright: Matt Agar and Martin Jantošovič

(This library is not currently used in Moodle)

==loglevel.js==

Minimal lightweight simple logging for JavaScript.

Version 1.7.1

Copyright (c) 2019 Tim Perry

License: MIT

https://github.com/pimterry/loglevel/

==LTI Tool Provider Library for PHP==

"lib/ltiprovider/"

PHP library for communicating with learning tools as per the LTI specification.

Version: 3.0.2

© 2016 IMS Global Learning Consortium Inc. All Rights Reserved. Trademark Policy - (www.imsglobal.org/trademarks)

License: Apache 2

https://github.com/IMSGlobal/LTI-Tool-Provider-Library-PHP

==MathJax==

JavaScript filter library for displaying LaTeX, AsciiMath notation, and MathML.

Not actually included in Moodle. Instead, Moodle [[:en:MathJax filter|has a setting]] for where the library is located to be loaded from. It is currently pointing to the Cloudflare CDN by default.

© Copyright 2009 - 2017 The MathJax Consortium

* Default MathJax version: 2.7.2 (Moodle 3.4)
* License: Apache 2.0
* Homepage: https://www.mathjax.org/

==MatthiasMullie\Minify==
CSS & JavaScript minifier, in PHP

Version 1.3.61

License: MIT

https://github.com/matthiasmullie/minify

==MaxMind DB Reader==
lib/maxmind/MaxMind/

PHP API for reading MaxMind DB files

Version: 1.5.1

Copyright MaxMind

License: Apache 2.0

https://github.com/maxmind/MaxMind-DB-Reader-php/

==mimeTeX==

''filter/tex''

Compiled C program to convert TeX into GIFs

Version: 1.74

Copyright © 2002-2004 John Forkosh Associates, Inc

License: GNU GPL

http://www.forkosh.com/mimetex.html

==Mustache.js==

"lib/amd/src/mustache.js"

JS library for displaying mustache templates.

Version: 3.0.1

Copyright (c) 2009 Chris Wanstrath (Ruby)

Copyright (c) 2010-2014 Jan Lehnardt (JavaScript)

Copyright (c) 2010-2015 The mustache.js community

License: MIT

https://github.com/janl/mustache.js/releases

==Mustache==

"lib/mustache"

PHP library for displaying mustache templates.

Version: 2.12.0

Copyright (c) 2010-2016 Justin Hileman

License: MIT

https://github.com/bobthecow/mustache.php/releases

==mp3player==

''lib/mp3player''

Flash movie to play streaming MP3s

Copyright © 2005 Andrew Walker

License: GNU GPL

(This library is not currently used in Moodle)

==overlibmws==

''lib/overlib.js''

Javascript library to enable DHTML popups, floating windows, events etc

Version: July 2004

Copyright © 2002-2004 Foteos Macrides

Copyright © 1998-2004 Erik Bosrup

License: Artistic Open Source License

http://www.macridesweb.com/oltest/

(This library is not currently used in Moodle)

==PclZip==

''lib/pclzip''

Class to create, manage and unpack zip files.

Version: 2.4 RC1

Copyright © 2004 Vincent Blavet (''vincent AT phpconcept DOT net'')

License: GNU GPL

http://www.phpconcept.net

(This library is not currently used in Moodle)

==PEAR OLE Classes==

''lib/pear''

Class to write Excel files

Version: 0.5

Copyright © 2004 Xavier Noguer

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/OLE

(This library is not currently used in Moodle)

==PEAR Spreadsheet_Excel_Writer==

''lib/pear''

Class to write Excel files

Version: 0.9.1

Copyright © 2004 Xavier Noguer and Mika Tuupola

License: LGPL

http://pear.php.net/package/Spreadsheet_Excel_Writer

(This library is not currently used in Moodle)

==PEAR HTML_Quickform==

''lib/pear''

Class to write forms

Version: 3.2.6

Copyright © 2004 Bertrand Mansion, Adam Daniel, Alexey Borzov

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Quickform

==PEAR HTML_Quickform_Renderer_Tableless==

''lib/pear''

Class to render forms without tables

Version: 0.3.4

Copyright © 2005 Mark Wiesemann

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Quickform_Renderer_Tableless

==PEAR HTML_QuickForm_DHTMLRulesTableless==

''lib/pear''

Class to render validation notices with dhtml

Version: 0.1.2

Copyright © 2005 Alexey Borzov, Adam Daniel, Bertrand Mansion, Justin Patrin, Mark Wiesemann

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_QuickForm_DHTMLRulesTableless

==PEAR HTML_Common==

''lib/pear''

Class with many common HTML functions (used by HTML Quickform)

Version: 0.3.4

Copyright © 2004 Adam Daniel, Bertrand Mansion, Klaus Guenther, Alexey Borzov

License: PHP (plus special exemption for Moodle to make it compatible)

http://pear.php.net/package/HTML_Common

==PEAR XML_Parser==

''lib/pear''

Class implementing one handy (sax-expat) XML parser

Version: 1.3.2

Copyright © 2004-2008 The PHP Group & Stephan Schmidt

License: New BSD License

http://pear.php.net/package/XML_Parser

(This library is not currently used in Moodle)

==PHP-CSS-Parser==

''lib/php-css-parser''

A Parser for CSS Files written in PHP.

Version: 8.3.0

Copyright (c) 2011 Raphael Schweikert, http://sabberworm.com/

License: MIT

https://github.com/sabberworm/PHP-CSS-Parser

==PHPExcel==

''lib/phpexcel/PHPExcel.php''

Library to read, write and create spreadsheet documents in PHP.

Version 1.8.1

Copyright © 2006 - 2015 PHPExcel
License: LGPL

https://github.com/PHPOffice/PHPExcel

(This library is not currently used in Moodle)

==PhpSpreadsheet==

''lib/phpspreadsheet''

Library to read, write and create spreadsheet documents in PHP.

Version 1.7.0

License: LGPL

https://github.com/PHPOffice/PhpSpreadsheet

==PHP mailer==

''lib/class.phpmailer.php''

Class for sending email using either sendmail, PHP mail(), or SMTP. Methods are based upon the standard AspEmail(tm) classes.

Version 6.0.7

Copyright © 2003 Brent R. Matzelle (''bmatzelle AT yahoo DOT com'')
License: LGPL

http://phpmailer.sourceforge.net
https://github.com/PHPMailer/PHPMailer/releases

==PHP Markdown==

''lib/markdown.php''

Functions to convert from the Markdown text format into clean XHTML.

Version: 1.8.0 (with modifications)

* @copyright 2004-2016 Michel Fortin <https://michelf.com/projects/php-markdown/>

* @copyright (Original Markdown) 2004-2006 John Gruber <https://daringfireball.net/projects/markdown/>
All rights reserved.

License: BSD

http://www.michelf.com/projects/php-markdown/

==PHP-ML==

''lib/mlbackend/php/phpml''

Machine learning library used to generate data for the Analytics system.

Version: 0.8.0

* @copyright 2016-2018 Arkadiusz Kondas <arkadiusz.kondas[at]gmail>

License: MIT

https://php-ml.readthedocs.io/

==Popper.js==

"admin/tool/usertours/amd/src/popper.js"

A kickass library used to created Poppers in web applications

Version: 1.12.6

© 2016 Federico Zivolo and contributors

License: MIT

https://github.com/FezVrasta/popper.js

==RTLCSS for PHP==

"lib/rtlcss"

RTLCSS is a framework for converting Left-To-Right (LTR) Cascading Style Sheets(CSS) to Right-To-Left (RTL).

© 2016 Frédéric Massart

License: MIT

https://github.com/moodlehq/rtlcss-php

==RequireJS==

''/lib/requirejs/''

RequireJS is a JavaScript file and module loader.

Version 2.3.5

License: new BSD or MIT

http://requirejs.org/

==scssphp==

''/lib/scssphp/''

scssphp is a compiler for SCSS written in PHP.

Version: 1.0.2

Copyright (c) 2015 Leaf Corcoran

License: MIT

http://leafo.github.io/scssphp

==SimplePie==

"/lib/simplepie"

Simple Pie helps with blogs.

Version 1.5.6

License: BSD

https://github.com/simplepie/simplepie

==Snoopy==

''lib/snoopy''

A PHP net client

Version: 1.0

Copyright © 1999-2000 Monte Ohrt (''monte AT ispi DOT net'')
License: GNU LGPL

http://snoopy.sourceforge.com

(This library is not currently used in Moodle)

==SMTP class==

''lib/class.smtp.php''

Class that can be used to connect and communicate with any SMTP server. It implements all the SMTP functions defined in RFC821 except TURN.

Version: 03/26/2001

Copyright © 2001 Chris Ryan (''chris AT greatbridge DOT com'')

(This library is not currently used in Moodle)

==Spike PHPCoverage==

''lib/spikephpcoverage''

PHP code coverage reporting tool

Version: 0.8.2 (with modifications)

Copyright © 2004 SpikeSource Inc

License: LGPL

http://developer.spikesource.com/projects/phpcoverage

(This library is not currently used in Moodle)

==Spout==

"lib/spout"

Library for importing and exporting csv / excel / ODS files.

Version 3.0.1

License: Apache

https://github.com/box/spout/

==TCPDF Class==

''lib/tcpdf''

Class to generate PDF files

Version: 6.3.5

Copyright Olivier PLATHEY

License: LGPL-v3.0-only

http://www.setasign.com/products/fpdi/downloads

==Typo3 Character Set Class==

''lib/typo3''

Class for conversion between charsets and multibyte-savy operations with strings.

Version: 4.7.19

Copyright © 2003-2005 Kasper Skaarhoj

Licence: GNU GPL

http://typo3.org/

==Video.js==

''amd/src/video-lazy.js''

JavaScript library that makes it easier to work with and build on HTML5 video

Version: 7.7.6

Copyright Brightcove, Inc

Licence: Apache

http://videojs.com/

==XHProf==

''lib/xhprof''

A Hierarchical Profiler for PHP

Version: 0.9.4

Copyright © 2009 Phacility

Licence: Apache

https://github.com/phacility/xhprof

==Yahoo User Interface==

''lib/yui''

The Yahoo! User Interface Library is a set of utilities and controls, in JavaScript, for building richly interactive web applications using techniques such as DOM scripting, DHTML and AJAX. The YUI Library also includes several core CSS resources.Set of user-interface components using AJAX, DHTML etc. We use it for all our AJAX-related stuff.

CVS version: 3.17.2

Copyright (c) 2006, Yahoo! Inc.

Licence: BSD

http://developer.yahoo.com/yui/

[[Category:Credits]]

Data manipulation API

2021-02-26T13:54:15Z

Pholden: SQL group concatenation method.

{{Moodle_2.0}}This page describes the functions available to access data in the Moodle database. You should '''exclusively''' use these functions in order to retrieve or modify database content because these functions provide a high level of abstraction and guarantee that your database manipulation will work against different RDBMSes.

Where possible, tricks and examples will be documented here in order to make developers' lives a bit easier. Of course, feel free to clarify, complete and add more information to this documentation. It will be welcome, absolutely!

== General concepts ==

=== DB object ===

* The data manipulation API is exposed via public methods of the <tt>$DB</tt> object.
* Moodle core takes care of setting up the connection to the database according to values specified in the main config.php file.
* The $DB global object is an instance of the <tt>moodle_database</tt> class. It is instantiated automatically during the bootstrap setup, i.e. as a part of including the main config.php file.
* The DB object is available in the global scope right after including the config.php file:
<code php>
<?php

require(__DIR__.'/../../../config.php');

// You can access the database via the $DB method calls here.
</code>
* To make the DB object available in your local scope, such as within a function:
<code php>
<?php

defined('MOODLE_INTERNAL') || die();

function my_function_making_use_of_database() {
global $DB;

// You can access the database via the $DB method calls here.
}
</code>

=== Table prefix ===

* Most Moodle installations use a prefix for all the database tables, such as <tt>mdl_</tt>. This prefix is NOT to be used in the code in the code itself.
* All the $table parameters in the functions are meant to be the table name without prefixes:
<code php>$user = $DB->get_record('user', ['id' => '1']);</code>
* In custom SQL queries, table names must be enclosed between curly braces. They will be then automatically converted to the real prefixed table name. There is no need to access <tt>$CFG->prefix</tt>
<code php>$user = $DB->get_record_sql('SELECT COUNT(*) FROM {user} WHERE deleted = 1 OR suspended = 1;');</code>

=== Conditions ===

* All the $conditions parameters in the functions are arrays of fieldname=>fieldvalue elements.
* They all must be fulfilled - i.e. logical <tt>AND</tt> is used to populate the actual <tt>WHERE</tt> statement.
<code php>$user = $DB->get_record('user', ['firstname' => 'Martin', 'lastname' => 'Dougiamas']);</code>

=== Placeholders ===

* All the $params parameters in the functions are arrays of values used to fill placeholders in SQL statements.
* Placeholders help to avoid problems with SQL-injection and/or invalid quotes in SQL queries. They facilitate secure and cross-db compatible code.
* Two types of placeholders are supported - question marks (<tt>SQL_PARAMS_QM</tt>) and named placeholders (<tt>SQL_PARAMS_NAMED</tt>).
* Named params '''must be unique''' even if the value passed is the same. If you need to pass the same value multiple times, you need to have multiple distinct named parameters.
<code php>
// Example of using question mark placeholders.
$DB->get_record_sql('SELECT * FROM {user} WHERE firstname = ? AND lastname = ?',
['Martin', 'Dougiamas']);

// Example of using named placeholders.
$DB->get_record_sql('SELECT * FROM {user} WHERE firstname = :firstname AND lastname = :lastname',
['firstname' => 'Martin', 'lastname' => 'Dougiamas']);
</code>

=== Strictness ===

Some methods accept the <tt>$strictness</tt> parameter affecting the method behaviour. Supported modes are specified using the constants:

* <tt>MUST_EXIST</tt> - In this mode, the requested record must exist and must be unique. An exception will be thrown if no record is found or multiple matching records are found.
* <tt>IGNORE_MISSING</tt> - In this mode, a missing record is not an error. False boolean is returned if the requested record is not found. If more records are found, a debugging message is displayed.
* <tt>IGNORE_MULTIPLE</tt> - This is not a recommended mode. The function will silently ignore multiple records found and will return just the first one of them.

== Getting a single record ==

=== get_record ===
Return a single database record as an object where all the given conditions are met.
<code php>$DB->get_record($table, array $conditions, $fields='*', $strictness=IGNORE_MISSING)</code>

=== get_record_select ===
Return a single database record as an object where the given conditions are used in the WHERE clause.
<code php>$DB->get_record_select($table, $select, array $params=null, $fields='*', $strictness=IGNORE_MISSING)</code>

=== get_record_sql ===
Return a single database record as an object using a custom SELECT query.
<code php>$DB->get_record_sql($sql, array $params=null, $strictness=IGNORE_MISSING)</code>

== Getting a hashed array of records ==
Each of the following methods return an array of objects. The array is indexed by the first column of the fields returned by the query. To assure consistency, it is a good practice to ensure that your query include an "id column" as the first field. When designing custom tables, make <tt>id</tt> their first column and primary key.

=== get_records ===
Return a list of records as an array of objects where all the given conditions are met.
<code php>$DB->get_records($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>

=== get_records_select ===
Return a list of records as an array of objects where the given conditions are used in the WHERE clause.
<code php>$DB->get_records_select($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>
$fields is a comma separated list of fields to return (optional, by default all fields are returned).

=== get_records_sql ===
Return a list of records as an array of objects using a custom SELECT query.
<code php>$DB->get_records_sql($sql, array $params=null, $limitfrom=0, $limitnum=0)</code>

=== get_records_list ===
Return a list of records as an array of objects where the given field matches one of the possible values.
<code php>$DB->get_records_list($table, $field, array $values, $sort='', $fields='*', $limitfrom='', $limitnum='')</code>

== Getting data as key/value pairs in an associative array ==

=== get_records_menu ===
Return the first two columns from a list of records as an associative array where all the given conditions are met.
<code php>$DB->get_records_menu($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>

=== get_records_select_menu ===
Return the first two columns from a list of records as an associative array where the given conditions are used in the WHERE clause.
<code php>$DB->get_records_select_menu($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>

=== get_records_sql_menu ===
Return the first two columns from a number of records as an associative array using a custom SELECT query.
<code php>$DB->get_records_sql_menu($sql, array $params=null, $limitfrom=0, $limitnum=0)</code>

== Counting records that match the given criteria ==

=== count_records ===
Count the records in a table where all the given conditions are met.
<code php>$DB->count_records($table, array $conditions=null) </code>

=== count_records_select ===
Count the records in a table where the given conditions are used in the WHERE clause.
<code php>$DB->count_records_select($table, $select, array $params=null, $countitem="COUNT('x')")</code>

=== count_records_sql ===
Counting the records using a custom SELECT COUNT(...) query.
<code php>$DB->count_records_sql($sql, array $params=null)</code>

== Checking if a given record exists ==

=== record_exists ===
Test whether a record exists in a table where all the given conditions are met.
<code php>$DB->record_exists($table, array $conditions=null)</code>

=== record_exists_select ===
Test whether any records exists in a table where the given conditions are used in the WHERE clause.
<code php>$DB->record_exists_select($table, $select, array $params=null)</code>

=== record_exists_sql ===
Test whether the given SELECT query would return any record.
<code php>$DB->record_exists_sql($sql, array $params=null)</code>

== Getting a particular field value from one record ==

=== get_field ===
Get a single field value from a table record where all the given conditions are met.
<code php>$DB->get_field($table, $return, array $conditions, $strictness=IGNORE_MISSING)</code>

=== get_field_select ===
Get a single field value from a table record where the given conditions are used in the WHERE clause.
<code php>$DB->get_field_select($table, $return, $select, array $params=null, $strictness=IGNORE_MISSING)</code>

=== get_field_sql ===
Get a single field value (first field) using a custom SELECT query.
<code php>$DB->get_field_sql($sql, array $params=null, $strictness=IGNORE_MISSING)</code>

== Getting field values from multiple records ==

=== get_fieldset_select ===
Return values of the given field as an array where the given conditions are used in the WHERE clause.
<code php>$DB->get_fieldset_select($table, $return, $select, array $params=null)</code>

=== get_fieldset_sql ===
Return values of the first column as an array using a custom SELECT field FROM ... query.
<code php>$DB->get_fieldset_sql($sql, array $params=null)</code>

== Setting a field value ==

=== set_field ===
Set a single field in every record where all the given conditions are met.
<code php>$DB->set_field($table, $newfield, $newvalue, array $conditions=null)</code>

=== set_field_select ===
Set a single field in every table record where the given conditions are used in the WHERE clause.
<code php>$DB->set_field_select($table, $newfield, $newvalue, $select, array $params=null)</code>

== Deleting records ==

=== delete_records ===
Delete records from the table where all the given conditions are met.
<code php>$DB->delete_records($table, array $conditions=null)</code>

=== delete_records_select ===
Delete records from the table where the given conditions are used in the WHERE clause.
<code php>$DB->delete_records_select($table, $select, array $params=null)</code>

== Inserting records ==

=== insert_record ===
Insert the given data object into the table and return the "id" of the newly created record.
<code php>$DB->insert_record($table, $dataobject, $returnid=true, $bulk=false)</code>

=== insert_records ===
{{Moodle_2.7}}Insert multiple records into the table as fast as possible. Records are inserted in the given order, but the operation is not atomic. Use transactions if necessary.
<code php>$DB->insert_records($table, $dataobjects)</code>

=== insert_record_raw ===
For rare cases when you also need to specify the ID of the record to be inserted.

== Updating records ==

=== update_record ===
Update a record in the table. The data object must have the property "id" set.
<code php>$DB->update_record($table, $dataobject, $bulk=false)</code>

== Executing a custom query ==

=== execute ===
* If you need to perform a complex update using arbitrary SQL, you can use the low level "execute" method. Only use this when no specialised method exists.
* Do NOT use this to make changes in database structure, use database_manager methods instead!
<code php>$DB->execute($sql, array $params=null)</code>

== Using recordsets ==

If the number of records to be retrieved from DB is high, the 'get_records_xxx() functions above are far from optimal, because they load all the records into the memory via the returned array. Under those circumstances, it is highly recommended to use these get_recordset_xxx() functions instead. They return an iterator to iterate over all the found records and save a lot of memory.

It is '''absolutely important''' to not forget to close the returned recordset iterator after using it. This is to free up a lot of resources in the RDBMS.

A general way to iterate over records using the get_recordset_xxx() functions:

<code php>
$rs = $DB->get_recordset(....) {
foreach ($rs as $record) {
// Do whatever you want with this record
}
$rs->close();
</code>

Unlike get_record functions, you cannot check if <tt>$rs == true</tt> or <tt>!empty($rs)</tt> to determine if any records were found. Instead, if you need to, you can use:

<code php>
if ($rs->valid()) {
// The recordset contains some records.
}
</code>

=== get_recordset ===
Return a list of records as a moodle_recordset where all the given conditions are met.
<code php>$DB->get_recordset($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>

=== get_recordset_select ===
Return a list of records as a moodle_recordset where the given conditions are used in the WHERE clause.
<code php>$DB->get_recordset_select($table, $select, array $params=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0)</code>

=== get_recordset_sql ===
Return a list of records as a moodle_recordset using a custom SELECT query.
<code php>$DB->get_recordset_sql($sql, array $params=null, $limitfrom=0, $limitnum=0)</code>

=== get_recordset_list ===
Return a list of records as a moodle_recordset where the given field matches one of the possible values.
<code php>$DB->get_recordset_list($table, $field, array $values, $sort='', $fields='*', $limitfrom='', $limitnum='')</code>

== Delegated transactions ==

* Please note some databases do not support transactions (such as the MyISAM MySQL database engine), however all server administrators are strongly encouraged to migrate to databases that support transactions (such as the InnoDB MySQL database engine).
* Previous versions supported only one level of transaction. Since Moodle 2.0, the DML layer emulates delegated transactions that allow nesting of transactions.
* Some subsystems (such as messaging) do not support transactions because it is not possible to rollback in external systems.

A transaction is started by:
<code php>
$transaction = $DB->start_delegated_transaction();
</code>

and finished by:
<code php>
$transaction->allow_commit();
</code>

Usually a transaction is rolled back when an exception is thrown:
<code php>$transaction->rollback($ex);</code>

which must be used very carefully because it might break compatibility with databases that do not support transactions. Transactions cannot be used as part of expected code flow; they can be used only as an emergency protection of data consistency.

See more details in [[DB layer 2.0 delegated transactions]] or MDL-20625.

=== Example ===

<code php>
global $DB;
try {
$transaction = $DB->start_delegated_transaction();
$DB->insert_record('foo', $object);
$DB->insert_record('bar', $otherobject);

// Assuming the both inserts work, we get to the following line.
$transaction->allow_commit();

} catch(Exception $e) {
$transaction->rollback($e);
}
</code>

== Cross-DB compatibility ==

Moodle supports several SQL servers (MySQL, PostgreSQL, MS-SQL and Oracle). Each of them have some specific syntax in certain cases. In order to achieve cross-db compatibility of the code, following functions must be used to generate the fragments of the query valid for the actual SQL server.

=== sql_bitand ===
Return the SQL text to be used in order to perform a bitwise AND operation between 2 integers.
<code php>$DB->sql_bitand($int1, $int2)</code>

=== sql_bitnot ===
Return the SQL text to be used in order to perform a bitwise NOT operation on the given integer.
<code php>$DB->sql_bitnot($int1)</code>

=== sql_bitor ===
Return the SQL text to be used in order to perform a bitwise OR operation between 2 integers.
<code php>$DB->sql_bitor($int1, $int2)</code>

=== sql_bitxor ===
Return the SQL text to be used in order to perform a bitwise XOR operation between 2 integers.
<code php>$DB->sql_bitxor($int1, $int2)</code>

=== sql_null_from_clause ===
Return an empty FROM clause required by some DBs in all SELECT statements.
<code php>$DB->sql_null_from_clause()</code>

=== sql_ceil ===
Return the correct CEIL expression applied to the given fieldname.
<code php>$DB->sql_ceil($fieldname)</code>

=== sql_equal ===
{{Moodle 3.2}}Return the query fragment to perform cross-db varchar comparisons when case-sensitiveness is important.
<code php>$DB->sql_equal($fieldname, $param, $casesensitive = true, $accentsensitive = true, $notequal = false)</code>

=== sql_like ===
Return the query fragment to perform the LIKE comparison.
<code php>$DB->sql_like($fieldname, $param, $casesensitive = true, $accentsensitive = true, $notlike = false, $escapechar = ' \\ ')</code>

Example: Searching for records partially matching the given hard-coded literal.
<code php>$DB->get_records_sql('SELECT id,fullname FROM {course} WHERE '.$DB->sql_like('idnumber', ':idnum'), ['idnum' => 'DEMO-%'));</code>
See below if you need to compare with a value submitted by the user.

=== sql_like_escape ===
Escape the value submitted by the user so that it can be used for partial comparison and the special characters like '_' or '%' behave as literal characters, not wildcards.
<code php>$DB->sql_like_escape($text, $escapechar = '\\')</code>

Example: If you need to perform a partial comparison with a value that has been submitted by the user.
<code php>
$search = required_param('search', PARAM_RAW);
$DB->get_records_sql('SELECT id,fullname FROM {course} WHERE '.$DB->sql_like('fullname', ':fullname'), ['fullname' => '%'.$DB->sql_like_escape($search).'%']);
</code>

=== sql_length ===
Return the query fragment to be used to calculate the length of the expression in characters.
<code php>$DB->sql_length($fieldname)</code>

=== sql_modulo ===
Return the query fragment to be used to calculate the remainder after division.
<code php>$DB->sql_modulo($int1, $int2)</code>

=== sql_position ===
Return the query fragment for searching a string for the location of a substring. If both needle and haystack use placeholders, you must use named placeholders.
<code php>$DB->sql_position($needle, $haystack)</code>

=== sql_substr ===
Return the query fragment for extracting a substring from the given expression.
<code php>$DB->sql_substr($expr, $start, $length=false)</code>

=== sql_cast_char2int ===
Return the query fragment to cast a CHAR column to INTEGER
<code php>$DB->sql_cast_char2int($fieldname, $text=false)</code>

=== sql_cast_char2real ===
Return the query fragment to cast a CHAR column to REAL (float) number
<code php>$DB->sql_cast_char2real($fieldname, $text=false)</code>

=== sql_compare_text ===
Return the query fragment to be used when comparing a TEXT (clob) column with a given string or a VARCHAR field (some RDBMs do not allow for direct comparison).
<code php>$DB->sql_compare_text($fieldname, $numchars=32)</code>

Example:
<code php>
$todogroups = $DB->get_records_sql('SELECT id FROM {group} WHERE ' . $DB->sql_compare_text('description') . ' = ' . $DB->sql_compare_text(':description'), ['description' => 'TODO']);
</code>

=== sql_order_by_text ===
Return the query fragment to be used to get records ordered by a TEXT (clob) column. Note this affects the performance badly and should be avoided if possible.
<code php>$DB->sql_order_by_text($fieldname, $numchars=32)</code>

=== sql_concat ===
Return the query fragment to concatenate all given paremeters into one string.
<code php>$DB->sql_concat(...)</code>

=== sql_group_concat ===
Return SQL for performing group concatenation on given field/expression.
<code php>$DB->sql_group_concat(string $field, string $separator = ', ', string $sort = '')</code>

=== sql_concat_join ===
Return the query fragment to concatenate all given elements into one string using the given separator.
<code php>$DB->sql_concat_join($separator="' '", $elements=array())</code>

=== sql_fullname ===
Return the query fragment to concatenate the given $firstname and $lastname
<code php>$DB->sql_fullname($first='firstname', $last='lastname')</code>

=== sql_isempty ===
Return the query fragment to check if the field is empty
<code php>$DB->sql_isempty($tablename, $fieldname, $nullablefield, $textfield)</code>

=== sql_isnotempty ===
Return the query fragment to check if the field is not empty
<code php>$DB->sql_isnotempty($tablename, $fieldname, $nullablefield, $textfield)</code>

=== get_in_or_equal ===
Return the query fragment to check if a value is IN the given list of items (with a fallback to plain equal comparison if there is just one item)
<code php>$DB->get_in_or_equal($items, $type=SQL_PARAMS_QM, $prefix='param', $equal=true, $onemptyitems=false)</code>

Example:
<code php>
$statuses = ['todo', 'open', 'inprogress', 'intesting'];
list($insql, $inparams) = $DB->get_in_or_equal($statuses);
$sql = "SELECT * FROM {bugtracker_issues} WHERE status $insql";
$bugs = $DB->get_records_sql($sql, $inparams);
</code>

An example using named params:

<code php>
...
list($insql, $params) = $DB->get_in_or_equal($contexts, SQL_PARAMS_NAMED, 'ctx');
$contextsql = "AND rc.contextid $insql";
...
</code>

=== sql_regex_supported ===
Does the current database driver support regex syntax when searching?
<code php>$DB->sql_regex_supported()</code>

=== sql_regex ===
Return the query fragment to perform a regex search.
<code php>$DB->sql_regex($positivematch = true, $casesensitive = false)</code>

Example: Searching for Page module instances containing links.
<code php>
if ($DB->sql_regex_supported()) {
$select = 'content ' . $DB->sql_regex() . ' :pattern';
$params = ['pattern' => "(src|data)\ *=\ *[\\\"\']https?://"]
} else {
$select = $DB->sql_like('content', ':pattern', false);
$params = ['pattern' => '%=%http%://%'];
}

$pages = $DB->get_records_select('page', $select, $params, 'course', 'id, course, name');
</code>

=== sql_intersect ===
{{Moodle 2.8}}Return the query fragment that allows to find intersection of two or more queries
<code php>$DB->sql_intersect($selects, $fields)</code>

== Debugging ==

=== set_debug ===
You can enable a debugging mode to make $DB output the SQL of every executed query, along with some timing information. This can be useful when debugging your code. Obviously, all such calls should be removed before code is submitted for integration.
<code php>$DB->set_debug(true)</code>

== Special cases ==

=== get_course ===

From Moodle 2.5.1 onwards, you should use the get_course function instead of using get_record('course', ...) if you want to get a course record based on its ID, especially if there is a significant possibility that the course being retrieved is either the current course for the page, or the site course. Those two course records have probably already been loaded, and using this function will save a database query.

Additionally, the code is shorter and easier to read.

=== get_courses ===

If you want to get all the current courses in your Moodle, use get_courses() without parameter:

$courses = get_courses();

== See also ==

* [[SQL coding style]]
* [[Core APIs]]
* [[DML exceptions|DML exceptions]]: New DML code is throwing exceptions instead of returning false if anything goes wrong
* [[DML drivers|DML drivers]]: Database drivers for new DML layer
* [[DML functions - pre 2.0|DML functions - pre 2.0]]: '''(deprecated!)''' For information valid before Moodle 2.0.
* [[DDL functions|DDL functions]]: Where all the functions used to handle DB objects ([[wikipedia:Data_Definition_Language|DDL]]) are defined.
* [[DB layer 2.0 examples|DB layer 2.0 examples]]: To see some code examples using various DML functions.
* [[DB layer 2.0 migration docs|DB layer 2.0 migration docs]]: Information about how to modify your code to work with the new Moodle 2.0 DB layer.
* [[DTL functions|DTL functions]]: Exporting, importing and moving of data stored in SQL databases

[[Category:DB]]
[[Category:XMLDB]]
[[Category:API]]

String deprecation

2020-10-21T17:01:04Z

Pholden: Fix comment, lest we upset glorious codechecker.

{{Infobox Project
|name = String deprecation
|state = Implemented
|tracker = MDL-46585
|discussion =
|assignee = Marina Glancy
}}
{{Moodle 2.8}}
==Removing strings which are no longer used==

From Moodle 2.8 onwards, strings can be deprecated in a way very similar to how functions are deprecated. This feature allows us to safely remove strings once we are reasonably sure they are no longer used. The process should help to remove unnecessary strings from the language packs, so translators do not waste valuable time translating them, while protecting us from accidentally removing a string that is still being used somewhere.

== How it works ==

There is a file with the list of deprecated strings. When a deprecated string is used (typically via the <code>get_string()</code> call), a warning message is displayed, such as:

String [identifier,component] is deprecated. Either you should no longer be using that string,
or the string has been incorrectly deprecated, in which case you should report this as a bug.
Please refer to https://docs.moodle.org/dev/String_deprecation

Note that this warning is displayed at the DEBUG_DEVELOPER level only (which is what Moodle developers should have selected). See below for info on what to do if you see this message.

=== Why and when should a string be deprecated? ===

The most common case is that you realize that a string is not used any more in standard Moodle code. You will probably search the whole moodle.git for the string identifier and the only relevant place found is the string definition itself. Even if it seems that the given string is not used any more in the standard Moodle code, it's possible that some additional (contributed) plugins still rely on it. This is typical for semantically general strings provided by the moodle.php (core) component such as "Yes", "Continue", "Hidden" etc.

Beware that searching for the string identifier only may sometimes lead to false negatives. Imagine you have a suspicion that a hypothetical string "actionloginremote" is no longer used any more as there is no code that would actually use this stringid. However, there can be places like this:

<code php>
$action = optional_param('action', 'loginremote', PARAM_ALPHA);
print_string('action'.$action);
</code>

that are harder to detect. So, instead of simply removing the string "actionloginremote" you would put it to the list of deprecated strings.

Another scenario may be that a semantically identical string was defined twice or it was put into the wrong component. If you think there may be places that rely on the wrong location (component), you should deprecate it. Copy the string to a new location (do not forget to use CPY instruction for AMOS to replay the change in all existing translations) and deprecate the old one.

Also, it may turn out that some strings are only vaguely defined and do not have a clear and unique context / semantics. Ideally, Moodle code should use context-sensitive strings rather than rely on one general string covering all cases. Things like [http://en.wikipedia.org/wiki/Grammatical_gender grammatical gender] play an important role in many languages. For example, in Czech, "a role" or "a question" are of feminine gender and the correct translation of "hidden" in this case is "skrytá", while "a badge" is of masculine gender and the correct translation is "skrytý". So it would be better to have separate strings like "hiddenrole", "hiddenquestion" and "hiddenbadge" even if they all read just "Hidden" in the English language pack. When you are about to split existing string into a couple of specific ones, you may wish to deprecate the general one at the end too (also, do not forget to use the CPY again).

=== When should a string be removed? ===

There are situations where deprecation does not make sense. For example when a whole functionality is being removed, or a very specific string (such as error message) is no longer used by the code. If it is very unlikely that the string is not used by any other code, it can simply be removed without the full deprecation process.

The same logic applies to cases when a very specific string is to be moved or renamed. In this situation, it is valid to just move it (together with the matching MOV instruction in the AMOScript).

== How to deprecate a string ==

* Strings can be deprecated and removed on master branch only.
* Locate or create a file deprecated.txt either in ''lang/en/'' or ''componentfullpath/lang/en/''
* Add a line "identifier,fullcomponentname" to the end of this file
* Move the string inside the existing language file to the end of the file under the comment <code>// Deprecated since Moodle X.Y.</code> (this comment will help removing deprecated strings later).
* For final deprecation (4 major versions later), delete the string from both deprecated.txt and respective lang file.

''Note: when deprecating core string from lang/en/xxxx.php the fullcomponentname should be "core_xxxx", except for lang/en/moodle.php that has fullcomponentname "core"''

''Note: before Moodle 3.0, final deprecation was 2 major versions later. With 3.0 the policy switched to 4 major releases later''

Take care when deprecating a string within a few weeks of en_fix being merged with en, as it can result in a conflict (as happened in MDL-52315).

== What to do if you get a debugging message ==

There are two possibilities. Either the code that uses the deprecated string must be fixed, or the string should not have been deprecated and must be removed from the list.

Use the git-blame tool on the corresponding lang/en/deprecated.txt and find the commit/issue that deprecated the string. It should give you enough information to decide on the most appropriate action.

* If you think the string was deprecated by mistake, create a new issue in the tracker to remove it from the list (on all supported branches, not only on master).
* If the string was renamed or moved, you will probably want to fix the caller to use the new name/location of the string.
* You may as well copy the string to your own plugin scope and make it context-specific.

[https://github.com/moodle/moodle/blame/master/lang/en/deprecated.txt <nowiki>git blame lang/en/deprecated.txt</nowiki>]
[https://github.com/moodle/moodle/blame/master/mod/quiz/lang/en/deprecated.txt <nowiki>git blame mod/quiz/lang/en/deprecated.txt</nowiki>]

==See also==

* MDL-64905 comments regarding introducing a new string and deprecating the old one

[[Category:Language]]

Moodle 3.9 release notes

2020-06-15T08:17:34Z

Pholden: Dataformat API upgrade notes.

[[Releases]] > {{FULLPAGENAME}}

Release date: 15 June 2020

Here is [https://tracker.moodle.org/secure/IssueNavigator!executeAdvanced.jspa?jqlQuery=project+%3D+mdl+AND+resolution+%3D+fixed+AND+fixVersion+in+%28%223.9%22%29+ORDER+BY+priority+DESC&runQuery=true&clear=true the full list of fixed issues in 3.9].

If you are upgrading from a previous version, please see [[:en:Upgrading|Upgrading]] in the user docs.

==Server requirements==

These are just the minimum supported versions. We recommend keeping all of your software and operating systems up-to-date.

* Moodle upgrade: Moodle 3.5 or later
* PHP version: minimum PHP 7.2.0 ''Note: minimum PHP version has increased since Moodle 3.8''. PHP 7.3.x and 7.4.x are supported too. See [[Moodle and PHP]] for details.
* PHP extension '''mbstring''' is required (it was previously only recommended)

=== Database requirements ===

Moodle supports the following database servers. Again, version numbers are just the minimum supported version. We recommend running the latest stable version of any software.

{| class="nicetable"
|-
! Database
! Minimum version
! Recommended
|-
| [http://www.postgresql.org/ PostgreSQL]
| 9.5 (increased since Moodle 3.8)
| Latest
|-
| [http://www.mysql.com/ MySQL]
| 5.6
| Latest
|-
| [https://mariadb.org/ MariaDB]
| 10.2.29 (increased since Moodle 3.8)
| Latest
|-
| [http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Microsoft SQL Server]
| 2012
| Latest
|-
| [http://www.oracle.com/us/products/database/overview/index.html Oracle Database]
| 11.2
| Latest
|}

==Client requirements==

=== Browser support ===
Moodle is compatible with any standards compliant web browser. We regularly test Moodle with the following browsers:

Desktop:
* Chrome
* Firefox
* Safari
* Edge
* Internet Explorer

Mobile:
* MobileSafari
* Google Chrome

For the best experience and optimum security, we recommend that you keep your browser up to date. https://whatbrowser.org

Note: Legacy browsers with known compatibility issues with Moodle 3.9:
* Internet Explorer 10 and below
* Safari 7 and below

==Major features==

===Activity chooser overhaul===
* MDL-67924 - Move turn editing on button out of the edit menu on boost
* MDL-67264 - Rework/Redesign the activity chooser
* MDL-67584 - Front end implementation of indicating favourites with a star
* MDL-67586 - Update activity chooser to include recommended activities
* MDL-67262 - Add admin page for recommending activities
* MDL-67321 - Support categories/tabs in the activity chooser
* MDL-67263 - Ability to search in the activity chooser
* MDL-67585 - New API for extending the activity chooser and implementation of favouriting
* MDL-68662 - Introduce an Activities and Resources tab
* MDL-67587 - Add searching of the recommended activities admin page

===H5P updates and improvements===
* MDL-67814 - H5P editor integration
* MDL-67734 - Create basic skeleton for a global xAPI library needed for H5P content
* MDL-67337 - Apply Display H5P filter inside <a> tags
* MDL-68636 - Render specific icons for different H5P content types in content bank
* MDL-67701 - New activity icon for H5P
* MDL-67063 - Add a mechanism to support multi H5P core_api versions
* MDL-67707 - Create a new H5P activity
* MDL-67062 - Add Admin UI to delete existing H5P libraries
* MDL-67788 - Add xAPI statement support to mod_h5p
* MDL-67060 - Improve admin UI to manage H5P libraries and give information about H5P tools' status
* MDL-67791 - Create xAPI activity report inside mod_h5p
* MDL-68271 - H5P editor: support content-type translations
* MDL-67810 - Integrate content bank and H5P content creator
* MDL-67713 - Include H5P Activity backup and restore options
* MDL-68227 - H5P editor: integrate translations with Moodle String API
* MDL-68379 - Add support for result, attachments, context to core_xapi library
* MDL-68381 - Add duration, completion and success to H5P activity attempts
* MDL-68241 - Add xAPI result support on mod_h5pactivity
* MDL-68826 - Add link to the content bank in the H5P activity

===Content bank===

* MDL-67786 - Create a new 'contentbank' plugin type and a new H5P plugin in the content bank
* MDL-68314 - Backup and restore options for course level content bank
* MDL-67800 - Implement events for content bank
* MDL-67795 - Add a delete content option to the content bank
* MDL-67812 - Create a new repository for the content bank
* MDL-67813 - Implement search functionality for the repository_contentbank
* MDL-68493 - Create a new view type list in the Content Bank
* MDL-67797 - Implement search API for the content bank
* MDL-68483 - Implement search functionality for the content bank

===MoodleNet integration===
* MDL-68111 - Core setting to toggle MoodleNet features globally (master)
* MDL-68698 - Allow links to be imported by tool_moodlenet (all versions)
* MDL-67884 - Add links to MoodleNet in Moodle (master)

===Improved participants page filtering===
* MDL-67917 - Create a single filter for tables and the AMD structure behind this
* MDL-68348 - Update the participants filter to support filtering with additional logic operators
* MDL-68246 - Update fetching of participants to support multiple values per filter
* MDL-68169 - Add additional participants filter types and the ability to add multiple conditions to a filter set
* MDL-68464 - "Enrol users" should not reload the page
* MDL-68612 - Remove the previous (unified) filter from the participants page and deprecate relevant code

===Course copy===
* MDL-64843 - Course Copy User Interface

===Improved Safe Exam Browser integration===
* MDL-67850 - Add Safe Exam Browser integration to the standard Moodle package (moodle-quizaccess_seb)
* MDL-68041 - New theme settings for secure layout - display lang menu and display logged-in user

===Quiz and questions===

* MDL-58645 - Make drag-and-drop onto image questions responsive and fix the print layout
* MDL-62487 - Quiz manual grading: chosen options should be remembered as user preferences
* MDL-68113 - Improve responsive design of drag-drop into text questions (also fixes layout when printed)
* MDL-68446 - Drag-drop question types: remove the hard-coded maximum size limit on images
* MDL-68382 - Update drag-drop marker questions to be more responsive (and improve print layout)
* MDL-68367 - Question: Multi-choice Option to hide system 'Select ...'
* MDL-68338 - GIFT question import/export format should support tags
* MDL-67934 - Intelligent default idnumber when duplicating a question in the question bank
* MDL-67351 - Create an additional admin "Required" setting flag and apply it to quiz require password setting

===Badges===

* MDL-66992 - Add support for Open Badges 2.1
* MDL-68746 - Hide issuer details when creating badges with Open Badges 2.0 and above
* MDL-68567 - Allow admins to manage available backpacks
* MDL-66357 - Remove support for Mozilla Backpack

===Accessibility audit improvements===
* MDL-68542 - Change the bold plugin to use strong tags instead of b for accessibility
* MDL-68541 - Limit the image description length and improve the alt text string
* MDL-68548 - Change the italics plugin to use em tags instead of i for accessibility
* MDL-68378 - Create an accessible change event
* MDL-68551 - Change the strikethrough plugin to use del tags instead of strike for accessibility
* MDL-67874 - Improve the contrast of browser focus outline
* MDL-68299 - Improve UI accessibility on small view ports

===Usability improvements===
* MDL-66301 - Add ability to summarise all forums in a specific course
* MDL-33671 - Add ability to bulk delete files in "My private files" repository
* MDL-54554 - Improve error handling for unoconv (Universal Office Converter)
* MDL-47750 - Make pasting images into the Atto HTML editor work (as much as browsers will let us)
* MDL-45227 - Add text direction to default ATTO generated markup
* MDL-58413 - Support internationalized domain names (IDN) in URL resources
* MDL-68143 - Workshop: should remember collapsed/expanded sections
* MDL-67613 - Add a new availability completion option - "previous activity with completion"
* MDL-66463 - Add "Go to top" link when scroll down in boost and classic themes
* MDL-68163 - Add ability to duplicate grade items in gradebook setup
* MDL-67165 - Improve the user grade display modal
* MDL-67160 - Show graded status in forum grading UI
* MDL-65948 - Use the checkbox-toggleall component for the gradebook setup page
* MDL-68217 - Reduce the size of titles on the recent activity page
* MDL-68216 - Improve the recent activity block styling
* MDL-68497 - Make fonts appear smooth in Firefox on Mac
* MDL-68248 - My overview block: Add sort by short name
* MDL-66911 - Display more information such as the URL beside licenses drop down menu in help icon
* MDL-41958 - Show steps consistently during import
* MDL-67703 - Make calendar manage subscription form more user friendly
* MDL-68250 - Make book navigation easier to distinguish from activity navigation
* MDL-67244 - Avoid HTML5 player video forced scaling for low resolution videos
* MDL-67467 - Update progress report (Download in Excel-compatible format) dates to a sortable format

==Other highlights==

===Functional changes===

* MDL-60817 - Notify the user when the original file extension has been removed or modified upon file editing in the filepicker
* MDL-64310 - Avoid recycle bin locking the user's session during activity deletion or backup/restore (when it is enabled)
* MDL-58827 - Add core profile fields to user filter
* MDL-65796 - Include site name and link in contact request notifications
* MDL-58866 - Modify the calendar events table to allow any component to create action events
* MDL-46542 - Allow setting a subset of the available units in moodleform duration field
* MDL-68563 - Enable additional content filters by default on new installs
* MDL-67363 - Add a Quality of Service layer to the processing of the ad-hoc task queue
* MDL-66920 - LTI 1.3: Allow tool to use JWKS URI rather than Public Key
* MDL-67846 - Add name of user to fields included in forum exports
* MDL-67547 - Render HTML in PDF dataformat export
* MDL-66732 - Improve detection of non-public sites for registration
* MDL-67072 - Include client_id and lti_deployment_id in OIDC Login Initiation request
* MDL-68320 - Add a campaign feature, with a link to a Moodle page, to support sustainability
* MDL-68409 - Stop using YUI modals in core/notification for alert and confirmation
* MDL-68076 - Create "Feedback" link in Moodle to permanent survey site
* MDL-56389 - Mark all as read in notifications menu should not apply to notifications received after the page was loaded
* MDL-68465 - Subject for messages digest email should include site name
* MDL-68568 - Move indent button to list group by default
* MDL-57635 - User Tours: Restrict tours to account creation date, first login date or last login date
* MDL-67384 - Upgrade jQuery EU Cookie Law popups to latest version
* MDL-65306 - Prevent LTI Advantage external tool add failing due to uniqueness constraint and tag not persisting
* MDL-66972 - Files API: Add Streaming file mime type support

===For administrators===
* MDL-62815 - Add new capabilities to control adding LTI activities from preconfigured tools
* MDL-47271 - Add system status report including tasks with cli status script
* MDL-45184 - Create user interface to add/delete new licenses
* MDL-66332 - Add "show differences only" into tool_capability
* MDL-65812 - Increase default session timeout and allow it to be configured in the GUI
* MDL-64610 - Add support for per-task concurrency limits
* MDL-66213 - It should be possible to view anonymous events in reports
* MDL-66135 - Add support for custom course fields to Upload courses
* MDL-59594 - Allow graceful fast exit of cron.php / adhoc_task.php via SIGTERM or SIGINT
* MDL-65729 - Ad-hoc task processing for automated backups
* MDL-29693 - Add filtering to the config changes admin report
* MDL-66925 - Enable cli/adhoc_task.php to be run as a pseudo daemon with --keep-alive=60
* MDL-67433 - Update admin/tool/task/cli/adhoc_task.php to respect task_adhoc_concurrency_limit
* MDL-59487 - Re-run a scheduled task from the web
* MDL-68261 - CLI changes should be included in the config changes report
* MDL-67456 - Add more options to Maximum number of backups kept
* MDL-65229 - Allow cron cli option to remotely stop all crons
* MDL-68256 - Scheduled tasks admin: usability enhancements
* MDL-67895 - Scheduled tasks admin: show the defaults in the form where you edit the settings for a task
* MDL-66752 - Develop an automatic approval tool for delete/export of personal data with a standard completion reply
* MDL-67990 - Increase the Antivirus default chunk size (ClamAV)

===Mobile===
* MDL-68537 - Update the tool_mobile_disabledfeatures setting with H5P and new blocks supported on the app
* MDL-68294 - Add a new "Mobile app subscription plan" section in the Moodle app settings
* MDL-65547 - Enable logging into the mobile app via QR code in the web user profile
* MDL-67752 - Add new "activeusers" field containing last month active users in registration data
* MDL-67753 - Enable "Mobile Notifications" when a site is registered
* MDL-67907 - Site admins should see a warning asking them to enable the Mobile notifications plugin after registering for an Airnotifier key

===Performance===
* MDL-19711 - Read/Write splitting of DB operations to support primary/replica database configurations
* MDL-39571 - Improve loading performance of filepicker when loading Recent Files
* MDL-67689 - Improve theme designer mode performance
* MDL-67681 - Improve course category tree cache performance by storing against single key instead of multiple
* MDL-67040 - Improve the performance of the Analytics ML layer when using small datasets
* MDL-68524 - Add Template and string prefetching
* MDL-67635 - Speed up file system \core\task\file_trash_cleanup_task
* MDL-66253 - Reduce the number of full table scans on the event table
* MDL-68185 - Convert performance report to Check API
* MDL-67075 - Extra session lock debugging for redis session handler
* MDL-68577 - Tune the redis session handler to reduce blocking wait time

===Security improvements and new features===

* MDL-67309 - Have options to call check_password_policy on every login
* MDL-64075 - Antivirus: Support remote scanning using TCP sockets.
* MDL-67504 - Allow virus checks to be retried if they returned an error state
* MDL-67362 - Add logging for admin setting changes to antivirus to config log
* MDL-67545 - New config option for ClamAV scanning errors to prompt user to try again later
* MDL-63734 - If passwordunmask field is hardcoded in config.php, do not show the value

==For developers==

* MDL-58018 - Reduce session lock contention with opt-in READ_ONLY_SESSION
* MDL-59562 - Allow plugins to declare which major stable versions of moodle are supported
* MDL-38511 - Plugins should be able to define new bulk user actions
* MDL-67052 - Implement a Lock API factory using Mysql / MariaDB
* MDL-67818 - Create a Check API
* MDL-68329 - Improve the cache performance footer info even more
* MDL-67432 - Allow quizaccess plugins to be able to set up external admin pages
* MDL-67548 - Allow plugins to hook into course category deletion form
* MDL-67386 - Upgrade boost to use Bootstrap v4.5.0
* MDL-68386 - Charts API: support for Area Chart fill values from Chart.js
* MDL-68477 - Charts API: support for legend options for Chart.js
* MDL-68233 - Code in renderers should not refer to global $PAGE or global $OUTPUT
* MDL-62757 - Validate boost presets before allowing to pick and use them
* MDL-68177 - Course renderer UI elements split into different methods
* MDL-67373 - Upgrade PHPMailer to latest version
* MDL-67372 - Upgrade HTML Purifier to latest version
* MDL-67385 - Upgrade MongoDB PHP Library to latest version
* MDL-67383 - Upgrade VideoJS to latest version
* MDL-67382 - Upgrade phpCAS to latest version
* MDL-67378 - Upgrade mustache.js to latest version
* MDL-67376 - Upgrade loglevel.js to latest version
* MDL-52846 - Deprecation of legacy cron
* MDL-65835 - Deprecate plagiarism_get_form_elements()
* MDL-63580 - Deprecate dupe cron_run_single_task() function
* MDL-67845 - Deprecate 'enrol_database_admin_setting_category' class
* MDL-67872 - Deprecate and fix plagiarismlib use of config vars
* MDL-68495 - Allow flexible_table to update dynamically

===Component API upgrades===
* [https://git.in.moodle.com/moodle/moodle/blob/master/admin/tool/log/upgrade.txt admin/tool/log/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/admin/tool/upgrade.txt admin/tool/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/auth/shibboleth/upgrade.txt auth/shibboleth/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/auth/upgrade.txt auth/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/badges/upgrade.txt badges/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/blocks/upgrade.txt blocks/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/cache/upgrade.txt cache/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/calendar/upgrade.txt calendar/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/course/format/upgrade.txt course/format/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/course/upgrade.txt course/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/dataformat/upgrade.txt dataformat/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/enrol/upgrade.txt enrol/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/filter/upgrade.txt filter/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/grade/grading/form/upgrade.txt grade/grading/form/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/grade/report/upgrade.txt grade/report/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/grade/upgrade.txt grade/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/lib/upgrade.txt lib/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/media/upgrade.txt media/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/message/upgrade.txt message/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/assign/upgrade.txt mod/assign/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/feedback/upgrade.txt mod/feedback/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/forum/upgrade.txt mod/forum/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/quiz/upgrade.txt mod/quiz/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/scorm/report/basic/upgrade.txt mod/scorm/report/basic/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/scorm/upgrade.txt mod/scorm/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/upgrade.txt mod/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/mod/workshop/upgrade.txt mod/workshop/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/question/format/upgrade.txt question/format/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/report/upgrade.txt report/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/tag/upgrade.txt tag/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/theme/upgrade.txt theme/upgrade.txt]
* [https://git.in.moodle.com/moodle/moodle/blob/master/user/upgrade.txt user/upgrade.txt]

==See also==
*[[Moodle 3.8 release notes]]

[[Category:Release notes]]
[[Category:Moodle 3.9]]

[[fr:Notes de mise à jour de Moodle 3.9]]
[[es:Notas de Moodle 3.9]]

Releases

2019-09-23T23:36:10Z

Pholden: Correct version string for 2.1.10

This page lists all official releases of Moodle, grouped by branch in reverse chronological order.

==Version support==

From Moodle 2.6 onwards, the end of support, both general and security, happens the second Monday of May and November, observing the 12, 18... month periods, no matter if the major release was delayed or not.

The most recent [https://en.wikipedia.org/wiki/Long-term_support long-term support release (LTS)] version is Moodle 3.5.

{| class="wikitable" border="1px solid #dee2e6;"
|-
! style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Version
! style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Release status
! style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Initial release
! style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:rgba(0, 0, 0, 0.05);" | General support ends
! style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Security support ends
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 3.5 (LTS)
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#239cae; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Current security
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 17 May 2018
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 13 May 2019
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 10 May 2021
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | 3.6
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#f98012; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Current stable
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | 3 December 2018
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | 11 November 2019
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | 11 May 2020
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 3.7
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#f98012; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Current stable
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 20 May 2019
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 11 May 2020
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | 9 November 2020
|}

[[Image:releasescurrent.png|alt=Release graph]]

Release graph key:
{| class="wikitable" border="1px solid #dee2e6;"
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#f98012; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Current stables
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Currently supported stable releases.
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#239cae; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Current security
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | Current release of versions still receiving security-only updates.
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#9cbd50; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Future stables
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Future point releases receiving bug fixes, as well as security updates.
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#316d5e; color:white; adding: .3rem 0.5rem 0.3rem 0.5rem;" | Future security
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | Future point releases receiving security-only updates.
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#686566; color:white; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Past stables
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: rgba(0, 0, 0, 0.05);" | Previously released versions containing bug fixes, as well as security updates. Updating to a currently supported version is recommended.
|-
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color:#282828; color:white; padding: .3rem 0.5rem 0.3rem 0.5rem;" | Past security
| style="vertical-align: top; border-top: 1px solid #dee2e6; background-color: #FFFFFF" | Previously released versions containing security updates only. Updating to a currently supported version is recommended.
|}

==General release calendar==

These are the target dates for releases. These dates may vary slightly due to unforeseen circumstances.

{| class="nicetable"
|-
! Release type
! Frequency
! Months
|-
| [[Process#Major_release_cycles|Major]] (eg. 3.x)
| 6 monthly
| Second Monday of May and November
|-
| [[Process#Stable_maintenance_cycles|Minor]] (Point) (eg. 3.x.y)
| 2 monthly
| Second Monday of July, September, November, January, March and May
|}

All releases are preceded by a one week warning. Upcoming release dates can be found in the [https://www.google.com/calendar/ical/moodle.com_p4c2oe7hsb77ltaro5qtihb5d4%40group.calendar.google.com/public/basic.ics Moodle development calendar] (Note, this is an iCAL link that will try to add the dates to your personal calendar. If you just want to browse the dates online, use [https://calendar.google.com/calendar/embed?src=moodle.com_p4c2oe7hsb77ltaro5qtihb5d4@group.calendar.google.com&pli=1 this link].).

==Moodle 3.7==

{| class="nicetable"
|-
! Moodle 3.7
| 20 May 2019
| 2019052000
| [[Moodle 3.7 release notes|Release Notes]]
| [https://docs.moodle.org/37/en/Upgrading Upgrading to 3.7]
|-
! Moodle 3.7.1
| 8th July 2019
| 2019052001
| [[Moodle 3.7.1 release notes|Release Notes]]
|
|-
! Moodle 3.7.2
| 9th September 2019
| 2019052002
| [[Moodle 3.7.2 release notes|Release Notes]]
|
|}

Bug fixes for general core bugs in 3.7.x will end 11 May 2020 (12 months).
Bug fixes for security issues in 3.7.x will end 9 November 2020 (18 months).

==Moodle 3.6==

{| class="nicetable"
|-
! Moodle 3.6
| 3 December 2018
| 2018120300
| [[Moodle 3.6 release notes|Release Notes]]
| [https://docs.moodle.org/36/en/Upgrading Upgrading to 3.6]
|-
! Moodle 3.6.1
| 5 December 2018
| 2018120301
| [[Moodle 3.6.1 release notes|Release Notes]]
|
|-
! Moodle 3.6.2
| 14 January 2019
| 2018120302
| [[Moodle 3.6.2 release notes|Release Notes]]
|
|-
! Moodle 3.6.3
| 11 March 2019
| 2018120303
| [[Moodle 3.6.3 release notes|Release Notes]]
|
|-
! Moodle 3.6.4
| 13 May 2019
| 2018120304
| [[Moodle 3.6.4 release notes|Release Notes]]
|
|-
! Moodle 3.6.5
| 8th July 2019
| 2018120305
| [[Moodle 3.6.5 release notes|Release Notes]]
|
|-
! Moodle 3.6.6
| 9th September 2019
| 2018120306
| [[Moodle 3.6.6 release notes|Release Notes]]
|
|}

Bug fixes for general core bugs in 3.6.x will end 11 November 2019 (12 months).
Bug fixes for security issues in 3.6.x will end 11 May 2020 (18 months).

==Moodle 3.5 (LTS)==

{| class="nicetable"
|-
! Moodle 3.5
| 17 May 2018
| 2018051700
| [[Moodle 3.5 release notes|Release Notes]]
| [https://docs.moodle.org/35/en/Upgrading Upgrading to 3.5]
|-
! Moodle 3.5.1
| 9 July 2018
| 2018051701
| [[Moodle 3.5.1 release notes|Release Notes]]
|
|-
! Moodle 3.5.2
| 10 September 2018
| 2018051702
| [[Moodle 3.5.2 release notes|Release Notes]]
|
|-
! Moodle 3.5.3
| 12 November 2018
| 2018051703
| [[Moodle 3.5.3 release notes|Release Notes]]
|
|-
! Moodle 3.5.4
| 14 January 2019
| 2018051704
| [[Moodle 3.5.4 release notes|Release Notes]]
|
|-
! Moodle 3.5.5
| 11 March 2019
| 2018051705
| [[Moodle 3.5.5 release notes|Release Notes]]
|
|-
! Moodle 3.5.6
| 13 May 2019
| 2018051706
| [[Moodle 3.5.6 release notes|Release Notes]]
|
|-
! Moodle 3.5.7
| 8th July 2019
| 2018051707
| [[Moodle 3.5.7 release notes|Release Notes]]
|
|-
! Moodle 3.5.8
| 9th September 2019
| 2018051708
| [[Moodle 3.5.8 release notes|Release Notes]]
|
|}

Bug fixes for general core bugs in 3.5.x ended May 2019 (12 months).
Bug fixes for security issues in 3.5.x will end 10 May 2021 (36 months).

==Moodle 3.4==

{| class="nicetable"
|-
! Moodle 3.4
| 13 November 2017
| 2017111300
| [[Moodle 3.4 release notes|Release Notes]]
| [https://docs.moodle.org/34/en/Upgrading Upgrading to 3.4]
|-
! Moodle 3.4.1
| 15 January 2018
| 2017111301
| [[Moodle 3.4.1 release notes|Release Notes]]
|
|-
! Moodle 3.4.2
| 19 March 2018
| 2017111302
| [[Moodle 3.4.2 release notes|Release Notes]]
|
|-
! Moodle 3.4.3
| 17 May 2018
| 2017111303
| [[Moodle 3.4.3 release notes|Release Notes]]
|
|-
! Moodle 3.4.4
| 9 July 2018
| 2017111304
| [[Moodle 3.4.4 release notes|Release Notes]]
|
|-
! Moodle 3.4.5
| 10 September 2018
| 2017111305
| [[Moodle 3.4.5 release notes|Release Notes]]
|
|-
! Moodle 3.4.6
| 12 November 2018
| 2017111306
| [[Moodle 3.4.6 release notes|Release Notes]]
|
|-
! Moodle 3.4.7
| 14 January 2019
| 2017111307
| [[Moodle 3.4.7 release notes|Release Notes]]
|
|-
! Moodle 3.4.8
| 11 March 2019
| 2017111308
| [[Moodle 3.4.8 release notes|Release Notes]]
|
|-
! Moodle 3.4.9
| 13 May 2019
| 2017111309
| [[Moodle 3.4.9 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 3.4.x ended 12 November 2018 (12 months).
Bug fixes for security issues in 3.4.x ended 13 May 2019 (18 months).

==Moodle 3.3==

{| class="nicetable"
|-
! Moodle 3.3
| 15 May 2017
| 2017051500
| [[Moodle 3.3 release notes|Release Notes]]
| [https://docs.moodle.org/33/en/Upgrading Upgrading to 3.3]
|-
! Moodle 3.3.1
| 10 July 2017
| 2017051501
| [[Moodle 3.3.1 release notes|Release Notes]]
|
|-
! Moodle 3.3.2
| 11 September 2017
| 2017051502
| [[Moodle 3.3.2 release notes|Release Notes]]
|
|-
! Moodle 3.3.3
| 13 November 2017
| 2017051503
| [[Moodle 3.3.3 release notes|Release Notes]]
|
|-
! Moodle 3.3.4
| 15 January 2018
| 2017051504
| [[Moodle 3.3.4 release notes|Release Notes]]
|
|-
! Moodle 3.3.5
| 19 March 2018
| 2017051505
| [[Moodle 3.3.5 release notes|Release Notes]]
|
|-
! Moodle 3.3.6
| 17 May 2018
| 2017051506
| [[Moodle 3.3.6 release notes|Release Notes]]
|
|-
! Moodle 3.3.7
| 9 July 2018
| 2017051507
| [[Moodle 3.3.7 release notes|Release Notes]]
|
|-
! Moodle 3.3.8
| 10 September 2018
| 2017051508
| [[Moodle 3.3.8 release notes|Release Notes]]
|
|-
! Moodle 3.3.9
| 12 November 2018
| 2017051509
| [[Moodle 3.3.9 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 3.3.x ended 17 May 2018 (12 months).
Bug fixes for security issues in 3.3.x ended 12 November 2018 (18 months).

==Moodle 3.2==

{| class="nicetable"
|-
! Moodle 3.2
| 5 December 2016
| 2016120500
| [[Moodle 3.2 release notes|Release Notes]]
| [https://docs.moodle.org/32/en/Upgrading Upgrading to 3.2]
|-
! Moodle 3.2.1
| 9 January 2017
| 2016120501
| [[Moodle 3.2.1 release notes|Release Notes]]
|
|-
! Moodle 3.2.2
| 13 March 2017
| 2016120502
| [[Moodle 3.2.2 release notes|Release Notes]]
|
|-
! Moodle 3.2.3
| 8 May 2017
| 2016120503
| [[Moodle 3.2.3 release notes|Release Notes]]
|
|-
! Moodle 3.2.4
| 10 July 2017
| 2016120504
| [[Moodle 3.2.4 release notes|Release Notes]]
|
|-
! Moodle 3.2.5
| 11 September 2017
| 2016120505
| [[Moodle 3.2.5 release notes|Release Notes]]
|
|-
! Moodle 3.2.6
| 13 November 2017
| 2016120506
| [[Moodle 3.2.6 release notes|Release Notes]]
|
|-
! Moodle 3.2.7
| 15 January 2018
| 2016120507
| [[Moodle 3.2.7 release notes|Release Notes]]
|
|-
! Moodle 3.2.8
| 19 March 2018
| 2016120508
| [[Moodle 3.2.8 release notes|Release Notes]]
|
|-
! Moodle 3.2.9
| 17 May 2018
| 2016120509
| [[Moodle 3.2.9 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 3.2.x ended 13 November 2017 (12 months).
Bug fixes for security issues in 3.2.x ended 17 May 2018 (18 months).

==Moodle 3.1 (LTS)==

{| class="nicetable"
|-
! Moodle 3.1
| 23 May 2016
| 2016052300
| [[Moodle 3.1 release notes|Release Notes]]
| [https://docs.moodle.org/31/en/Upgrading Upgrading to 3.1]
|-
! Moodle 3.1.1
| 11 July 2016
| 2016052301
| [[Moodle 3.1.1 release notes|Release Notes]]
|
|-
! Moodle 3.1.2
| 12 September 2016
| 2016052302
| [[Moodle 3.1.2 release notes|Release Notes]]
|
|-
! Moodle 3.1.3
| 14 November 2016
| 2016052303
| [[Moodle 3.1.3 release notes|Release Notes]]
|
|-
! Moodle 3.1.4
| 9 January 2017
| 2016052304
| [[Moodle 3.1.4 release notes|Release Notes]]
|
|-
! Moodle 3.1.5
| 13 March 2017
| 2016052305
| [[Moodle 3.1.5 release notes|Release Notes]]
|
|-
! Moodle 3.1.6
| 8 May 2017
| 2016052306
| [[Moodle 3.1.6 release notes|Release Notes]]
|
|-
! Moodle 3.1.7
| 10 July 2017
| 2016052307
| [[Moodle 3.1.7 release notes|Release Notes]]
|
|-
! Moodle 3.1.8
| 11 September 2017
| 2016052308
| [[Moodle 3.1.8 release notes|Release Notes]]
|
|-
! Moodle 3.1.9
| 13 November 2017
| 2016052309
| [[Moodle 3.1.9 release notes|Release Notes]]
|
|-
! Moodle 3.1.10
| 15 January 2018
| 2016052310
| [[Moodle 3.1.10 release notes|Release Notes]]
|
|-
! Moodle 3.1.11
| 19 March 2018
| 2016052311
| [[Moodle 3.1.11 release notes|Release Notes]]
|
|-
! Moodle 3.1.12
| 17 May 2018
| 2016052312
| [[Moodle 3.1.12 release notes|Release Notes]]
|
|-
! Moodle 3.1.13
| 9 July 2018
| 2016052313
| [[Moodle 3.1.13 release notes|Release Notes]]
|
|-
! Moodle 3.1.14
| 10 September 2018
| 2016052314
| [[Moodle 3.1.14 release notes|Release Notes]]
|
|-
! Moodle 3.1.15
| 12 November 2018
| 2016052315
| [[Moodle 3.1.15 release notes|Release Notes]]
|
|-
! Moodle 3.1.16
| 14 January 2019
| 2016052316
| [[Moodle 3.1.16 release notes|Release Notes]]
|
|-
! Moodle 3.1.17
| 11 March 2019
| 2016052317
| [[Moodle 3.1.17 release notes|Release Notes]]
|
|-
! Moodle 3.1.18
| 13 May 2019
| 2016052318
| [[Moodle 3.1.18 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 3.1.x ended 8 May 2017 (12 months).
Bug fixes for security issues in 3.1.x ended 13 May 2019 (36 months).

==Moodle 3.0==

{| class="nicetable"
|-
! Moodle 3.0
| 16 November 2015
| 2015111600
| [[Moodle 3.0 release notes|Release Notes]]
| [https://docs.moodle.org/30/en/Upgrading Upgrading to 3.0]
|-
! Moodle 3.0.1
| 21 December 2015
| 2015111601
| [[Moodle 3.0.1 release notes|Release Notes]]
|
|-
! Moodle 3.0.2
| 11 January 2016
| 2015111602
| [[Moodle 3.0.2 release notes|Release Notes]]
|
|-
! Moodle 3.0.3
| 14 March 2016
| 2015111603
| [[Moodle 3.0.3 release notes|Release Notes]]
|
|-
! Moodle 3.0.4
| 9 May 2016
| 2015111604
| [[Moodle 3.0.4 release notes|Release Notes]]
|
|-
! Moodle 3.0.5
| 11 July 2016
| 2015111605
| [[Moodle 3.0.5 release notes|Release Notes]]
|
|-
! Moodle 3.0.6
| 12 September 2016
| 2015111606
| [[Moodle 3.0.6 release notes|Release Notes]]
|
|-
! Moodle 3.0.7
| 14 November 2016
| 2015111607
| [[Moodle 3.0.7 release notes|Release Notes]]
|
|-
! Moodle 3.0.8
| 9 January 2017
| 2015111608
| [[Moodle 3.0.8 release notes|Release Notes]]
|
|-
! Moodle 3.0.9
| 13 March 2017
| 2015111609
| [[Moodle 3.0.9 release notes|Release Notes]]
|
|-
! Moodle 3.0.10
| 8 May 2017
| 2015111610
| [[Moodle 3.0.10 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 3.0.x ended 14 November 2016 (12 months).
Bug fixes for security issues in 3.0.x ended 8 May 2017 (18 months).

==Moodle 2.9==

{| class="nicetable"
|-
! Moodle 2.9
| 11 May 2015
| 2015051100
| [[Moodle 2.9 release notes|Release Notes]]
| [https://docs.moodle.org/29/en/Upgrading_to_Moodle_2.9 Upgrading to 2.9]
|-
! Moodle 2.9.1
| 6 July 2015
| 2015051101
| [[Moodle 2.9.1 release notes|Release Notes]]
|
|-
! Moodle 2.9.2
| 14 September 2015
| 2015051102
| [[Moodle 2.9.2 release notes|Release Notes]]
|
|-
! Moodle 2.9.3
| 9 November 2015
| 2015051103
| [[Moodle 2.9.3 release notes|Release Notes]]
|
|-
! Moodle 2.9.4
| 11 January 2016
| 2015051104
| [[Moodle 2.9.4 release notes|Release Notes]]
|
|-
! Moodle 2.9.5
| 14 March 2016
| 2015051105
| [[Moodle 2.9.5 release notes|Release Notes]]
|
|-
! Moodle 2.9.6
| 9 May 2016
| 2015051106
| [[Moodle 2.9.6 release notes|Release Notes]]
|
|-
! Moodle 2.9.7
| 11 July 2016
| 2015051107
| [[Moodle 2.9.7 release notes|Release Notes]]
|
|-
! Moodle 2.9.8
| 12 September 2016
| 2015051108
| [[Moodle 2.9.8 release notes|Release Notes]]
|
|-
! Moodle 2.9.9
| 14 November 2016
| 2015051109
| [[Moodle 2.9.9 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.9.x ended 9 May 2016 (12 months).
Bug fixes for security issues in 2.9.x ended 14 November 2016 (18 months).

==Moodle 2.8==

{| class="nicetable"
|-
! Moodle 2.8
| 10 November 2014
| 2014111000
| [[Moodle 2.8 release notes|Release Notes]]
| [https://docs.moodle.org/28/en/Upgrading_to_Moodle_2.8 Upgrading to 2.8]
|-
! Moodle 2.8.1
| 13 November 2014
| 2014111001
| [[Moodle 2.8.1 release notes|Release Notes]]
|
|-
! Moodle 2.8.2
| 12 January 2015
| 2014111002
| [[Moodle 2.8.2 release notes|Release Notes]]
|
|-
! Moodle 2.8.3
| 2 February 2015
| 2014111003
| [[Moodle 2.8.3 release notes|Release Notes]]
|
|-
! Moodle 2.8.4
| 9 March 2015
| 2014111004
| [[Moodle 2.8.4 release notes|Release Notes]]
|
|-
! Moodle 2.8.5
| 10 March 2015
| 2014111005
| [[Moodle 2.8.5 release notes|Release Notes]]
|
|-
! Moodle 2.8.6
| 11 May 2015
| 2014111006
| [[Moodle 2.8.6 release notes|Release Notes]]
|
|-
! Moodle 2.8.7
| 6 July 2015
| 2014111007
| [[Moodle 2.8.7 release notes|Release Notes]]
|
|-
! Moodle 2.8.8
| 14 September 2015
| 2014111008
| [[Moodle 2.8.8 release notes|Release Notes]]
|
|-
! Moodle 2.8.9
| 9 November 2015
| 2014111009
| [[Moodle 2.8.9 release notes|Release Notes]]
|
|-
! Moodle 2.8.10
| 11 January 2016
| 2014111010
| [[Moodle 2.8.10 release notes|Release Notes]]
|
|-
! Moodle 2.8.11
| 14 March 2016
| 2014111011
| [[Moodle 2.8.11 release notes|Release Notes]]
|
|-
! Moodle 2.8.12
| 9 May 2016
| 2014111012
| [[Moodle 2.8.12 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.8.x ended 9 November 2015 (12 months).
Bug fixes for security issues in 2.8.x ended 9 May 2016 (18 months).

==Moodle 2.7 (LTS)==

{| class="nicetable"
|-
! Moodle 2.7
| 12 May 2014
| 2014051200
| [[Moodle 2.7 release notes|Release Notes]]
| [https://docs.moodle.org/27/en/Upgrading_to_Moodle_2.7 Upgrading to 2.7]
|-
! Moodle 2.7.1
| 14 July 2014
| 2014051201
| [[Moodle 2.7.1 release notes|Release Notes]]
|
|-
! Moodle 2.7.2
| 8 September 2014
| 2014051202
| [[Moodle 2.7.2 release notes|Release Notes]]
|
|-
! Moodle 2.7.3
| 10 November 2014
| 2014051203
| [[Moodle 2.7.3 release notes|Release Notes]]
|
|-
! Moodle 2.7.4
| 12 January 2015
| 2014051204
| [[Moodle 2.7.4 release notes|Release Notes]]
|
|-
! Moodle 2.7.5
| 2 February 2015
| 2014051205
| [[Moodle 2.7.5 release notes|Release Notes]]
|
|-
! Moodle 2.7.6
| 9 March 2015
| 2014051206
| [[Moodle 2.7.6 release notes|Release Notes]]
|
|-
! Moodle 2.7.7
| 10 March 2015
| 2014051207
| [[Moodle 2.7.7 release notes|Release Notes]]
|
|-
! Moodle 2.7.8
| 11 May 2015
| 2014051208
| [[Moodle 2.7.8 release notes|Release Notes]]
|
|-
! Moodle 2.7.9
| 6 July 2015
| 2014051209
| [[Moodle 2.7.9 release notes|Release Notes]]
|
|-
! Moodle 2.7.10
| 14 September 2015
| 2014051210
| [[Moodle 2.7.10 release notes|Release Notes]]
|
|-
! Moodle 2.7.11
| 9 November 2015
| 2014051211
| [[Moodle 2.7.11 release notes|Release Notes]]
|
|-
! Moodle 2.7.12
| 11 January 2016
| 2014051212
| [[Moodle 2.7.12 release notes|Release Notes]]
|
|-
! Moodle 2.7.13
| 14 March 2016
| 2014051213
| [[Moodle 2.7.13 release notes|Release Notes]]
|
|-
! Moodle 2.7.14
| 9 May 2016
| 2014051214
| [[Moodle 2.7.14 release notes|Release Notes]]
|
|-
! Moodle 2.7.15
| 11 July 2016
| 2014051215
| [[Moodle 2.7.15 release notes|Release Notes]]
|
|-
! Moodle 2.7.16
| 12 September 2016
| 2014051216
| [[Moodle 2.7.16 release notes|Release Notes]]
|
|-
! Moodle 2.7.17
| 14 November 2016
| 2014051217
| [[Moodle 2.7.17 release notes|Release Notes]]
|
|-
! Moodle 2.7.18
| 9 January 2017
| 2014051218
| [[Moodle 2.7.18 release notes|Release Notes]]
|
|-
! Moodle 2.7.19
| 13 March 2017
| 2014051219
| [[Moodle 2.7.19 release notes|Release Notes]]
|
|-
! Moodle 2.7.20
| 8 May 2017
| 2014051220
| [[Moodle 2.7.20 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.7.x ended 11 May 2015 (12 months).
Bug fixes for security issues in 2.7.x ended 8 May 2017 (36 months).

==Moodle 2.6==

{| class="nicetable"
|-
! Moodle 2.6
| 18 November 2013
| 2013111800
| [[Moodle 2.6 release notes|Release Notes]]
| [https://docs.moodle.org/26/en/Upgrading_to_Moodle_2.6 Upgrading to 2.6]
|-
! Moodle 2.6.1
| 13 January 2014
| 2013111801
| [[Moodle 2.6.1 release notes|Release Notes]]
|
|-
! Moodle 2.6.2
| 10 March 2014
| 2013111802
| [[Moodle 2.6.2 release notes|Release Notes]]
|
|-
! Moodle 2.6.3
| 12 May 2014
| 2013111803
| [[Moodle 2.6.3 release notes|Release Notes]]
|
|-
! Moodle 2.6.4
| 14 July 2014
| 2013111804
| [[Moodle 2.6.4 release notes|Release Notes]]
|
|-
! Moodle 2.6.5
| 8 September 2014
| 2013111805
| [[Moodle 2.6.5 release notes|Release Notes]]
|
|-
! Moodle 2.6.6
| 10 November 2014
| 2013111806
| [[Moodle 2.6.6 release notes|Release Notes]]
|
|-
! Moodle 2.6.7
| 12 January 2015
| 2013111807
| [[Moodle 2.6.7 release notes|Release Notes]]
|
|-
! Moodle 2.6.8
| 2 February 2015
| 2013111808
| [[Moodle 2.6.8 release notes|Release Notes]]
|
|-
! Moodle 2.6.9
| 9 March 2015
| 2013111809
| [[Moodle 2.6.9 release notes|Release Notes]]
|
|-
! Moodle 2.6.10
| 10 March 2015
| 2013111810
| [[Moodle 2.6.10 release notes|Release Notes]]
|
|-
! Moodle 2.6.11
| 11 May 2015
| 2013111811
| [[Moodle 2.6.11 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.6.x ended 10 November 2014 (12 months).
Bug fixes for security issues in 2.6.x ended 11 May 2015 (18 months).

==Moodle 2.5==

{| class="nicetable"
|-
! Moodle 2.5
| 14 May 2013
| 2013051400
| [[Moodle 2.5 release notes|Release Notes]]
| [https://docs.moodle.org/25/en/Upgrading_to_Moodle_2.5 Upgrading to 2.5]
|-
! Moodle 2.5.1
| 8 July 2013
| 2013051401
| [[Moodle 2.5.1 release notes|Release Notes]]
|
|-
! Moodle 2.5.2
| 9 September 2013
| 2013051402
| [[Moodle 2.5.2 release notes|Release Notes]]
|
|-
! Moodle 2.5.3
| 11 November 2013
| 2013051403
| [[Moodle 2.5.3 release notes|Release Notes]]
|
|-
! Moodle 2.5.4
| 13 January 2014
| 2013051404
| [[Moodle 2.5.4 release notes|Release Notes]]
|
|-
! Moodle 2.5.5
| 10 March 2014
| 2013051405
| [[Moodle 2.5.5 release notes|Release Notes]]
|
|-
! Moodle 2.5.6
| 12 May 2014
| 2013051406
| [[Moodle 2.5.6 release notes|Release Notes]]
|
|-
! Moodle 2.5.7
| 14 July 2014
| 2013051407
| [[Moodle 2.5.7 release notes|Release Notes]]
|
|-
! Moodle 2.5.8
| 8 September 2014
| 2013051408
| [[Moodle 2.5.8 release notes|Release Notes]]
|
|-
! Moodle 2.5.9
| 10 November 2014
| 2013051409
| [[Moodle 2.5.9 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.5.x ended May 2014 (12 months).
Bug fixes for security issues in 2.5.x ended 10 November 2014 (18 months).

==Moodle 2.4==

{| class="nicetable"
|-
! Moodle 2.4
| 3 December 2012
| 2012120300
| [[Moodle 2.4 release notes|Release Notes]]
| [https://docs.moodle.org/24/en/Upgrading_to_Moodle_2.4 Upgrading to 2.4]
|-
! Moodle 2.4.1
| 14 January 2013
| 2012120301
| [[Moodle 2.4.1 release notes|Release Notes]]
|
|-
! Moodle 2.4.2
| 11 March 2013
| 2012120302
| [[Moodle 2.4.2 release notes|Release Notes]]
|
|-
! Moodle 2.4.3
| 18 March 2013
| 2012120303
| [[Moodle 2.4.3 release notes|Release Notes]]
|
|-
! Moodle 2.4.4
| 14 May 2013
| 2012120304
| [[Moodle 2.4.4 release notes|Release Notes]]
|
|-
! Moodle 2.4.5
| 8 July 2013
| 2012120305
| [[Moodle 2.4.5 release notes|Release Notes]]
|
|-
! Moodle 2.4.6
| 9 September 2013
| 2012120306
| [[Moodle 2.4.6 release notes|Release Notes]]
|
|-
! Moodle 2.4.7
| 11 November 2013
| 2012120307
| [[Moodle 2.4.7 release notes|Release Notes]]
|
|-
! Moodle 2.4.8
| 13 January 2014
| 2012120308
| [[Moodle 2.4.8 release notes|Release Notes]]
|
|-
! Moodle 2.4.9
| 10 March 2014
| 2012120309
| [[Moodle 2.4.9 release notes|Release Notes]]
|
|-
! Moodle 2.4.10
| 12 May 2014
| 2012120310
| [[Moodle 2.4.10 release notes|Release Notes]]
|
|-
! Moodle 2.4.11
| 14 July 2014
| 2012120311
| [[Moodle 2.4.11 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.4.x ended December 2013 (12 months).
Bug fixes for security issues in 2.4.x ended June 2014 (18 months).

==Moodle 2.3==

{| class="nicetable"
|-
! Moodle 2.3
| 25 June 2012
| 2012062500
| [[Moodle 2.3 release notes|Release Notes]]
| [https://docs.moodle.org/23/en/Upgrading_to_Moodle_2.3 Upgrading to 2.3]
|-
! Moodle 2.3.1
| 9 July 2012
| 2012062501
| [[Moodle 2.3.1 release notes|Release Notes]]
|
|-
! Moodle 2.3.2
| 10 September 2012
| 2012062502
| [[Moodle 2.3.2 release notes|Release Notes]]
|
|-
! Moodle 2.3.3
| 12 November 2012
| 2012062503
| [[Moodle 2.3.3 release notes|Release Notes]]
|
|-
! Moodle 2.3.4
| 14 January 2013
| 2012062504
| [[Moodle 2.3.4 release notes|Release Notes]]
|
|-
! Moodle 2.3.5
| 11 March 2013
| 2012062505
| [[Moodle 2.3.5 release notes|Release Notes]]
|
|-
! Moodle 2.3.6
| 18 March 2013
| 2012062506
| [[Moodle 2.3.6 release notes|Release Notes]]
|
|-
! Moodle 2.3.7
| 14 May 2013
| 2012062507
| [[Moodle 2.3.7 release notes|Release Notes]]
|
|-
! Moodle 2.3.8
| 8 July 2013
| 2012062508
| [[Moodle 2.3.8 release notes|Release Notes]]
|
|-
! Moodle 2.3.9
| 9 September 2013
| 2012062509
| [[Moodle 2.3.9 release notes|Release Notes]]
|
|-
! Moodle 2.3.10
| 11 November 2013
| 2012062510
| [[Moodle 2.3.10 release notes|Release Notes]]
|
|-
! Moodle 2.3.11
| 13 January 2014
| 2012062511
| [[Moodle 2.3.11 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.3.x ended June 2013 (12 months).
Bug fixes for security issues in 2.3.x ended December 2013 (18 months).

==Moodle 2.2==

{| class="nicetable"
|-
! Moodle 2.2
| 5 December 2011
| 2011120500
| [[Moodle 2.2 release notes|Release Notes]]
| [https://docs.moodle.org/22/en/Upgrading_to_Moodle_2.2 Upgrading to 2.2]
|-
! Moodle 2.2.1
| 9 January 2012
| 2011120501
| [[Moodle 2.2.1 release notes|Release Notes]]
|
|-
! Moodle 2.2.2
| 12 March 2012
| 2011120502
| [[Moodle 2.2.2 release notes|Release Notes]]
|
|-
! Moodle 2.2.3
| 14 May 2012
| 2011120503
| [[Moodle 2.2.3 release notes|Release Notes]]
|
|-
! Moodle 2.2.4
| 9 July 2012
| 2011120504
| [[Moodle 2.2.4 release notes|Release Notes]]
|
|-
! Moodle 2.2.5
| 10 September 2012
| 2011120505
| [[Moodle 2.2.5 release notes|Release Notes]]
|
|-
! Moodle 2.2.6
| 12 November 2012
| 2011120506
| [[Moodle 2.2.6 release notes|Release Notes]]
|
|-
! Moodle 2.2.7
| 14 January 2013
| 2011120507
| [[Moodle 2.2.7 release notes|Release Notes]]
|
|-
! Moodle 2.2.8
| 11 March 2013
| 2011120508
| [[Moodle 2.2.8 release notes|Release Notes]]
|
|-
! Moodle 2.2.9
| 18 March 2013
| 2011120509
| [[Moodle 2.2.9 release notes|Release Notes]]
|
|-
! Moodle 2.2.10
| 14 May 2013
| 2011120510
| [[Moodle 2.2.10 release notes|Release Notes]]
|
|-
! Moodle 2.2.11
| 8 July 2013
| 2011120511
| [[Moodle 2.2.11 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.2.x ended December 2012 (12 months).
Bug fixes for security issues in 2.2.x ended June 2013 (18 months).

==Moodle 2.1==

{| class="nicetable"
|-
! Moodle 2.1
| 1 July 2011
| 2011070100
| [[Moodle 2.1 release notes|Release Notes]]
| [https://docs.moodle.org/21/en/Upgrading_to_Moodle_2.1 Upgrading to 2.1]
|-
! Moodle 2.1.1
| 1 August 2011
| 2011070101
| [[Moodle 2.1.1 release notes|Release Notes]]
|
|-
! Moodle 2.1.2
| 10 October 2011
| 2011070102
| [[Moodle 2.1.2 release notes|Release Notes]]
|
|-
! Moodle 2.1.3
| 28 November 2011
| 2011070103
| [[Moodle 2.1.3 release notes|Release Notes]]
|
|-
! Moodle 2.1.4
| 9 January 2012
| 2011070104
| [[Moodle 2.1.4 release notes|Release Notes]]
|
|-
! Moodle 2.1.5
| 12 March 2012
| 2011070105
| [[Moodle 2.1.5 release notes|Release Notes]]
|
|-
! Moodle 2.1.6
| 14 May 2012
| 2011070106
| [[Moodle 2.1.6 release notes|Release Notes]]
|
|-
! Moodle 2.1.7
| 9 July 2012
| 2011070107
| [[Moodle 2.1.7 release notes|Release Notes]]
|
|-
! Moodle 2.1.8
| 10 September 2012
| 2011070108
| [[Moodle 2.1.8 release notes|Release Notes]]
|
|-
! Moodle 2.1.9
| 12 November 2012
| 2011070109
| [[Moodle 2.1.9 release notes|Release Notes]]
|
|-
! Moodle 2.1.10
| 14 January 2013
| 2011070110
| [[Moodle 2.1.10 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.1.x ended June 2012 (12 months).
Bug fixes for security issues in 2.1.x ended December 2012 (18 months).

==Moodle 2.0==
{| class="nicetable"
|-
! Moodle 2.0
| 24 November 2010
| 2010112400
| [[Moodle 2.0 release notes|Release Notes]]
| [https://docs.moodle.org/20/en/Upgrading_to_Moodle_2.0 Upgrading to 2.0]
|-
! Moodle 2.0.1
| 25 December 2010
| 2010122500
| [[Moodle 2.0.1 release notes|Release Notes]]
|
|-
! Moodle 2.0.2
| 21 February 2011
| 2011022100
| [[Moodle 2.0.2 release notes|Release Notes]]
|
|-
! Moodle 2.0.3
| 5 May 2011
| 2011033003
| [[Moodle 2.0.3 release notes|Release Notes]]
|
|-
! Moodle 2.0.4
| 1 August 2011
| 2011033004
| [[Moodle 2.0.4 release notes|Release Notes]]
|
|-
! Moodle 2.0.5
| 10 October 2011
| 2011033005
| [[Moodle 2.0.5 release notes|Release Notes]]
|
|-
! Moodle 2.0.6
| 28 November 2011
| 2011033006
| [[Moodle 2.0.6 release notes|Release Notes]]
|
|-
! Moodle 2.0.7
| 9 January 2012
| 2011033007
| [[Moodle 2.0.7 release notes|Release Notes]]
|
|-
! Moodle 2.0.8
| 12 March 2012
| 2011033008
| [[Moodle 2.0.8 release notes|Release Notes]]
|
|-
! Moodle 2.0.9
| 14 May 2012
| 2011033009
| [[Moodle 2.0.9 release notes|Release Notes]]
|
|-
! Moodle 2.0.10
| 9 July 2012
| 2011033010
| [[Moodle 2.0.10 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 2.0.x ended December 2011 (12 months).
Bug fixes for security issues in 2.0.x ended June 2012 (18 months).

==Moodle 1.9==

{| class="nicetable"
|-
! Moodle 1.9
| 3 March 2008
| 2007101509
| [[Moodle 1.9 release notes|Release Notes]]
| [https://docs.moodle.org/19/en/Upgrading_to_Moodle_1.9 Upgrading to 1.9]
|-
! Moodle 1.9.1
| 15 May 2008
| 2007101512
| [[Moodle 1.9.1 release notes|Release Notes]]
|
|-
! Moodle 1.9.2
| 11 July 2008
| 2007101520
| [[Moodle 1.9.2 release notes|Release Notes]]
|
|-
! Moodle 1.9.3
| 15 October 2008
| 2007101530
| [[Moodle 1.9.3 release notes|Release Notes]]
|
|-
! Moodle 1.9.4
| 28 January 2009
| 2007101540
| [[Moodle 1.9.4 release notes|Release Notes]]
|
|-
! Moodle 1.9.5
| 13 May 2009
| 2007101550
| [[Moodle 1.9.5 release notes|Release Notes]]
|
|-
! Moodle 1.9.6
| 21 October 2009
| 2007101560
| [[Moodle 1.9.6 release notes|Release Notes]]
|
|-
! Moodle 1.9.7
| 25 November 2009
| 2007101570
| [[Moodle 1.9.7 release notes|Release Notes]]
|
|-
! Moodle 1.9.8
| 25 March 2010
| 2007101580.00
| [[Moodle 1.9.8 release notes|Release Notes]]
|
|-
! Moodle 1.9.9
| 8 June 2010
| 2007101590.00
| [[Moodle 1.9.9 release notes|Release Notes]]
|
|-
! Moodle 1.9.10
| 25 October 2010
| 2007101591.00
| [[Moodle 1.9.10 release notes|Release Notes]]
|
|-
! Moodle 1.9.11
| 21 February 2011
| 2007101591.02
| [[Moodle 1.9.11 release notes|Release Notes]]
|
|-
! Moodle 1.9.12
| 10 May 2011
| 2007101591.03
| [[Moodle 1.9.12 release notes|Release Notes]]
|
|-
! Moodle 1.9.13
| 1 August 2011
| 2007101591.04
| [[Moodle 1.9.13 release notes|Release Notes]]
|
|-
! Moodle 1.9.14
| 10 October 2011
| 2007101591.06
| [[Moodle 1.9.14 release notes|Release Notes]]
|
|-
! Moodle 1.9.15
| 28 November 2011
| 2007101591.07
| [[Moodle 1.9.15 release notes|Release Notes]]
|
|-
! Moodle 1.9.16
| 9 January 2012
| 2007101591.10
| [[Moodle 1.9.16 release notes|Release Notes]]
|
|-
! Moodle 1.9.17
| 12 March 2012
| 2007101591.12
| [[Moodle 1.9.17 release notes|Release Notes]]
|
|-
! Moodle 1.9.18
| 14 May 2012
| 2007101591.16
| [[Moodle 1.9.18 release notes|Release Notes]]
|
|-
! Moodle 1.9.19
| 9 July 2012
| 2007101592.00
| [[Moodle 1.9.19 release notes|Release Notes]]
| Support has ended
|}

Bug fixes for general core bugs in 1.9.x has ended June 2011 (3.5 years).
Bug fixes for security issues in 1.9.x by Moodle HQ ended June 2012 (4.5 years).
Bug fixes for security issues in 1.9.19+ branch by [http://catalyst.net.nz Catalyst IT] ended [http://moodle.org/mod/forum/discuss.php?d=199706 Dec 2013] (6 years).

==Moodle 1.8==
*[[Moodle 1.8 release notes|Moodle 1.8]] - 30 March 2007
*[[Moodle 1.8.1 release notes|Moodle 1.8.1]] - 14 June 2007
*[[Moodle 1.8.2 release notes|Moodle 1.8.2]] - 8 July 2007
*[[Moodle 1.8.3 release notes|Moodle 1.8.3]] - 11 October 2007
*[[Moodle 1.8.4 release notes|Moodle 1.8.4]] - 11 January 2008
*[[Moodle 1.8.5 release notes|Moodle 1.8.5]] - 8 April 2008
*[[Moodle 1.8.6 release notes|Moodle 1.8.6]] - 11 July 2008
*[[Moodle 1.8.7 release notes|Moodle 1.8.7]] - 15 October 2008
*[[Moodle 1.8.8 release notes|Moodle 1.8.8]] - 28 January 2009
*[[Moodle 1.8.9 release notes|Moodle 1.8.9]] - 15 May 2009
*[[Moodle 1.8.10 release notes|Moodle 1.8.10]] - 26 October 2009
*[[Moodle 1.8.11 release notes|Moodle 1.8.11]] - 25 November 2009
*[[Moodle 1.8.12 release notes|Moodle 1.8.12]] - 27 March 2010
*[[Moodle 1.8.13 release notes|Moodle 1.8.13]] - 8 June 2010
*[[Moodle 1.8.14 release notes|Moodle 1.8.14]] - 3 December 2010
*Support has ended

==Moodle 1.7==
*[[Moodle 1.7 release notes|Moodle 1.7]] - 7 November 2006
*[[Moodle 1.7.1 release notes|Moodle 1.7.1]] - 17 January 2007
*[[Moodle 1.7.2 release notes|Moodle 1.7.2]] - 30 March 2007
*[[Moodle 1.7.3 release notes|Moodle 1.7.3]] - 11 October 2007
*[[Moodle 1.7.4 release notes|Moodle 1.7.4]] - 11 January 2008
*[[Moodle 1.7.5 release notes|Moodle 1.7.5]] - 11 July 2008
*[[Moodle 1.7.6 release notes|Moodle 1.7.6]] - 15 October 2008
*[[Moodle 1.7.7 release notes|Moodle 1.7.7]] - 28 January 2009
*Support has ended

==Moodle 1.6==
*[[Moodle 1.6 release notes|Moodle 1.6]] - 20 June 2006
*[[Moodle 1.6.1 release notes|Moodle 1.6.1]] - 20 July 2006
*[[Moodle 1.6.2 release notes|Moodle 1.6.2]] - 12 September 2006
*[[Moodle 1.6.3 release notes|Moodle 1.6.3]] - 10 October 2006
*[[Moodle 1.6.4 release notes|Moodle 1.6.4]] - 17 January 2007
*[[Moodle 1.6.5 release notes|Moodle 1.6.5]] - 30 March 2007
*Moodle 1.6.6 - 11 January 2008
*Moodle 1.6.7 - 11 July 2008
*[[Moodle 1.6.8 release notes|Moodle 1.6.8]] - 15 October 2008
*[[Moodle 1.6.9 release notes|Moodle 1.6.9]] - 28 January 2009
* Support has ended

==Moodle 1.5==
*[[Moodle 1.5 release notes|Moodle 1.5]] - 5 June 2005
*[[Moodle 1.5.1 release notes|Moodle 1.5.1]] - 8 July 2005
*[[Moodle 1.5.2 release notes|Moodle 1.5.2]] - 16 July 2005
*[[Moodle 1.5.3 release notes|Moodle 1.5.3]] - 11 November 2005
*[[Moodle 1.5.4 release notes|Moodle 1.5.4]] - 21 May 2006
* Support has ended

==Moodle 1.4==
*Moodle 1.4 - 31 August 2004
*Moodle 1.4.1 - 12 September 2004
*Moodle 1.4.2 - 5 November 2004
*Moodle 1.4.3 - 21 December 2004
*Moodle 1.4.4 - 7 March 2005
*[[Moodle 1.4.5 release notes|Moodle 1.4.5]] - 7 May 2005
* Support has ended

==Moodle 1.3==
*Moodle 1.3 - 25 May 2004
*Moodle 1.3.1 - 4 June 2004
*Moodle 1.3.2 - 9 July 2004
*Moodle 1.3.3 - 16 July 2004
*Moodle 1.3.4 - 11 August 2004
*Moodle 1.3.5 - 9 September 2004
* Support has ended

==Moodle 1.2==
*Moodle 1.2 - 20 March 2004
*Moodle 1.2.1 - 25 March 2004
* Support has ended

==Moodle 1.1==
*Moodle 1.1 - 29 August 2003
*Moodle 1.1.1 - 11 September 2003
* Support has ended

==Moodle 1.0==
*Moodle 1.0 - 20 August 2002
*Moodle 1.0.1 - 26 August 2002
*Moodle 1.0.2 - 2 September 2002
*Moodle 1.0.3 - 5 September 2002
*Moodle 1.0.4 - 10 September 2002
*Moodle 1.0.5 - 27 September 2002
*Moodle 1.0.6 - 26 October 2002
:: 1.0.6.1 - 6 November 2002
:: 1.0.6.2 - 11 November 2002
:: 1.0.6.3 - 14 November 2002
:: 1.0.6.4 - 25 November 2002
*Moodle 1.0.7 - 9 December 2002
*Moodle 1.0.8 - 7 January 2003
*Moodle 1.0.9 - 30 May 2003
* Support has ended

==See also==
*[[Roadmap]] - future versions
*[[Moodle versions]] - an explanation of how our versions work plus version numbers for each release (for $plugin->requires)

[[Category:Release notes]]
[[Category:Core development]]

[[fr:Historique des versions]]
[[es:dev/Historia de las versiones]]
[[de:Versionshistorie]]