I have written many Moodle queries over the years. Usually with the use of PHPMyAdmin I can establish which joins should be made between tables. However, every now and then I come up against the odd dead-end.
I have tried:
- Referring to the Moodle ERD on moodle.org
- Creating my own ERD in workbench
- Dumping sql to a file, making a change, dumping again and running the diff shell command
- Googling similar queries
- Using Moodle Debugging
- Setting MySQL triggers
I am aware the Moodle DB is not normalised.
My question is, given a front end parameter such as, within quiz settings:
- Require Grade
- Require Passing Grade
Thanks in advance for your help