Unusual Problem with MySQL Field
Since we no longer update our LM repository we have switched to using it as a read-only pool of files. The moodle module holds an external URL which would redirect to the stored file repository/file.php?f=4000. I needed to change this to e.g. /repository/a4000/4000.xlsx The file extension is thankfully held in the repository module table so I thought it would be quite easy to manipulate the URL to point straight to the file. The only difficulty I encountered was extracting the…