Hi, can someone help? I have Moodle v1.8.3 and I need an SQL query to pull grades from the database. My ultimate goal is to basically export grade data into another (asp.net) web page.
I've seen queries that work on later versions of Moodle but nothing for 1.8.3
Looks like the table structure is different in later versions.
Any help would be REALLY appreciated.
Thanks...
Sy
Hi Sy,
Which grade data are you wanting to export? Just course totals? Or do you have category totals and/or specific task grades?
I didn't really take note of the table structure back in 1.8.3, but I know the 1.9.x structure pretty well. You never know - let me know what you need and they might work.
Cheers,
Michael
There were several reasons why the gradebook had to be completely rewritten in Moodle 1.9, and that fact that what you are asking to do was essentially impossible was one of them.
In Moodle <=1.8.x there was no central storage of grades. Grades were only stored by individual activities.
