chamilo / chamilo-lms

            user_id = ".intval($user_info['user_id']);

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

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

    if ($drh_can_access_all_courses) {

        $courses_in_session[0][] = $row['c_id'];

    } else {

        if (isset($courses[$row['c_id']])) {

            $courses_in_session[0][] = $row['c_id'];

        }

    }

}

// Get the list of sessions where the user is subscribed as student

$sql = 'SELECT session_id, c_id

        $progress = array();

        $viewCount = array();

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

            if (!isset($viewCount[$row['lp_id']])) {

                $progress[$row['lp_id']] = $row['progress'];

            }

            $viewCount[$row['lp_id']] = $row['view_count'];

        }

        // Fill with lp ids

        if (!empty($lpIdList)) {

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

                $number_of_answers = array();

                $data = array();

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

                    if (!isset($number_of_answers[$row['question_id']])) {

                        $number_of_answers[$row['question_id']] = 0;

                    }

                    $number_of_answers[$row['question_id']] += $row['total'];

                    $data[$row['option_id']] = $row;

                }

                foreach ($options as $option) {

                    $optionText = strip_tags($option['option_text']);