chamilo / chamilo-lms

                            WHERE c_id = $courseId AND question_id = ".$obj->id;

                    $db_result2 = Database::query($sql);

                    if (Database::num_rows($db_result2)) {

                        while ($obj2 = Database::fetch_object($db_result2)) {

                            $question->add_answer(

                                $obj2->id,

                                $obj2->answer,

                                $obj2->correct,

                                $obj2->comment,

                                $obj2->ponderation,

                                $obj2->position,

                                $obj2->hotspot_coordinates,

                                $obj2->hotspot_type

                            );

                        }

                        $orphanQuestionIds[] = $obj->id;

                    }

                    $this->course->add_resource($question);

                );

                $sql = 'SELECT * FROM '.$table_ans.' WHERE question_id = '.$obj->id;

                $db_result2 = Database::query($sql);

                while ($obj2 = Database::fetch_object($db_result2)) {

                    $question->add_answer(

                        $obj2->id,

                        $obj2->answer,

                        $obj2->correct,

                        $obj2->comment,

                        $obj2->ponderation,

                        $obj2->position,

                        $obj2->hotspot_coordinates,

                        $obj2->hotspot_type

                    );

                }

                $this->course->add_resource($question);

            }

        }