Created MDL-70918
Joseph Rézeau
Posts made by Joseph Rézeau
Hi Sara,
Thanks for your answer, which works perfectly. It's OK if one only has a handful of contents to upgrade, but a bulk upgrade would be nice to have, of course! I will create an "new feature" issue for this.
Also, when all contents have been upgraded to the most current library version, it would be nice to be able to delete the now obsolete library from the Moodle interface.
Best,
Joseph
My problem is not with updating the H5P content types libraries. My problem is: when a new version of a library is available on a moodle site where H5P instances were created with an older version, the hvp plugin provides a way to upgrade those older instances to use the new library version.
This very useful feature is missing from the Moodle (core) h5pactivity, as clearly shown on my 2 screenshots.
Et voilou la requête à utiliser (on suppose que le préfixe des tables est "mdl" comme recommandé à l'installation de Moodle).
SELECT c.format 'Format', c.fullname
FROM mdl_course AS c
GROUP BY c.format
ce qui donne sur mon petit site de test:

ou plus précisément pour le seul format 'topcoll':
SELECT c.format 'Format', c.fullname
FROM mdl_course AS c
WHERE c.format = 'topcoll'
GROUP BY c.format
CQFD