My version of moodle is: 1.8.1
I have been working with different Lesson's and I'm accessing their respective DB tables since I need to use this information else where and I have two problems:
1- In table: mdl_lesson_grades, I could see the values of the lessons as below:
mysql> select * from mdl_lesson_grades (table 1);
+----+----------+--------+-------+------+------------+
| id | lessonid | userid | grade | late | completed |
+----+----------+--------+-------+------+------------+
| 8 | 6 | 6 | 100 | 0 | 1203527695 |
| 7 | 5 | 4 | 100 | 0 | 1203095407 |
| 6 | 5 | 4 | 100 | 0 | 1203080555 |
| 5 | 6 | 4 | 100 | 0 | 1203078561 |
| 9 | 5 | 6 | 100 | 0 | 1203708409 |
| 10 | 8 | 4 | 50 | 0 | 1204308605 |
while in the table: mdl_lesson_answers, the values of the grades are 0 (for a given lesson and all other lessons) while three possible values are presented for the score:
mysql> select * from mdl_lesson_answers where lessonid="8";
+----+----------+--------+--------+-------+-------+-------+-------------+--------------+--------------+----------+
| id | lessonid | pageid | jumpto | grade | score | flags | timecreated | timemodified |
+----+----------+--------+--------+-------+-------+-------+-------------+--------------+--------------+----------+
| 24 | 8 | 21 | 0 | 0 | 100 | 0 | 1204308193 | 1204308538 |
| 25 | 8 | 21 | -1 | 0 | 50 | 0 | 1204308193 | 1204308538 |
| 26 | 8 | 21 | -9 | 0 | 10 | 0 | 1204308193 | 1204308538 |
+----+----------+--------+--------+-------+-------+-------+-------------+--------------+--------------+----------+
so why is that?2- In the Lesson's settings I have chosen Custom scoring and have given a max of 9. I had three pages with 3 Qs and for each correct answer, a student earns 3 points => at the end of the lesson grade = 9.
Now why do I get a grade (in table 1) as 100 for the user who has completed the lesson correctly instead of 9? I need those specific (customized) figures.
Plus another Qs:
3- Although I have made a new customized SCALE, when I'm working with Lesson's or Quizes, I'm not given the option to make use of it. Why is that?
Thanks a lot for your help.
Maram