Conditions | 2 |
Paths | 1 |
Total Lines | 20 |
Code Lines | 12 |
Lines | 0 |
Ratio | 0 % |
Changes | 0 |
1 | <?php |
||
18 | public function load(array $incomingData) |
||
19 | { |
||
20 | $tblQuizQuestion = \Database::get_course_table(TABLE_QUIZ_QUESTION); |
||
21 | $tblQuizRelQuestion = \Database::get_course_table(TABLE_QUIZ_TEST_QUESTION); |
||
22 | $tblLpItem = \Database::get_course_table(TABLE_LP_ITEM); |
||
23 | |||
24 | $sql = "SELECT SUM(ponderation) |
||
25 | FROM $tblQuizQuestion as quiz_question |
||
26 | INNER JOIN $tblQuizRelQuestion as quiz_rel_question |
||
27 | ON quiz_question.iid = quiz_rel_question.question_id |
||
28 | WHERE |
||
29 | quiz_rel_question.exercice_id = {$incomingData['quiz_id']} |
||
30 | AND quiz_rel_question.c_id = {$incomingData['c_id']}"; |
||
31 | |||
32 | $rsQuiz = \Database::query($sql); |
||
33 | $maxScore = \Database::result($rsQuiz, 0, 0) ?: 0; |
||
34 | |||
35 | \Database::query("UPDATE $tblLpItem SET max_score = $maxScore WHERE iid = {$incomingData['item_id']}"); |
||
36 | |||
37 | return $incomingData['item_id']; |
||
38 | } |
||
40 |