chamilo / chamilo-lms

        $sql_query = sprintf($sql, $course['real_id']);

        $result = Database::query($sql_query);

        $arrLesson = array(array());

        while ($row = Database::fetch_array($result)) {

            if (empty($arrLesson[$row['session_id']]['lessons_total'])) {

                $arrLesson[$row['session_id']]['lessons_total'] = 1;

            } else {

                $arrLesson[$row['session_id']]['lessons_total'] ++;

            }

        }

        /**

         *  Exercises

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

while ($row = Database :: fetch_array($result, 'ASSOC')) {

    $attribute['path'][] = $row['path'];

    $attribute['visibility'][] = $row['visibility'];

    $attribute['comment'][] = $row['comment'];

}

$nbrActiveTests = 0;

if (isset($attribute['path']) && is_array($attribute['path'])) {

        // Getting the information of the question options

        $result = Database::query($sqlOption);

        while ($row = Database::fetch_array($result, 'ASSOC')) {

            /** @todo this should be renamed to options instead of answers */

            $return['answers'][] = $row['option_text'];

            $return['values'][] = $row['value'];

            /** @todo this can be done more elegantly (used in reporting) */

            $return['answersid'][] = $row['question_option_id'];

        }

        return $return;

    }