chamilo / chamilo-lms

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

        if ($res !== false) {

            $i = 0;

            while ($resA = Database::fetch_array($res, 'NUM')) {

                $resu[$i][0] = $resA[0];

                $resu[$i][1] = $resA[1];

                $resu[$i][2] = $resA[2];

                $i++;

            }

        }

        return $resu;

                if (!isset($thematic_id) && !isset($description_type)) {

                    // group all data group by thematic id

                    $tmp = array();

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

                        $tmp[] = $row['thematic_id'];

                        if (in_array($row['thematic_id'], $tmp)) {

                            $row['session_id'] = $thematic_plan_complete_list[$row['id']];

                            $data[$row['thematic_id']][$row['description_type']] = $row;

                        }

                    }

                } else {

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

                        $row['session_id'] = $thematic_plan_complete_list[$row['id']];

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

                $number_of_answers = array();

                $data = array();

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

                    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']);

        $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)) {