chamilo / chamilo-lms

        $courseId = api_get_course_int_id($courseCode);

        $userId = intval($userId);

        $line = null;

        if (substr($view, 3, 1) == '1') {

            $new_view = substr_replace($view, '0', 3, 1);

            $title[1] = get_lang('LinksDetails');

            $sql = "SELECT cl.title, cl.url

                        FROM $TABLETRACK_LINKS AS sl, $TABLECOURSE_LINKS AS cl

                        WHERE sl.links_link_id = cl.id

                            AND sl.c_id = $courseId

                            AND sl.links_user_id = $userId

                        GROUP BY cl.title, cl.url";

            $results = StatsUtils::getManyResults2Col($sql);

            $title_line = get_lang('LinksTitleLinkColumn')."\n";

            if (is_array($results)) {

                for ($j = 0; $j < count($results); $j++) {

                    $line .= $results[$j][0]."\n";

                }

            } else {

                $line = get_lang('NoResult');

            }

        } else {

            $new_view = substr_replace($view, '1', 3, 1);

        }

        return array($title_line, $line);

    }

        $downloads_table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

        if (substr($view, 4, 1) == '1') {

            $new_view = substr_replace($view, '0', 4, 1);

            $title[1] = get_lang('DocumentsDetails');

            $sql = "SELECT down_doc_path

                        FROM $downloads_table

                        WHERE c_id = $courseId

                            AND down_user_id = $user_id

                            AND down_session_id = $session_id

                        GROUP BY down_doc_path";

            $results = StatsUtils::getManyResults1Col($sql);

            $title_line = get_lang('DocumentsTitleDocumentColumn')."\n";

            $line = null;

            if (is_array($results)) {

                for ($j = 0; $j < count($results); $j++) {

                    $line .= $results[$j]."\n";

                }

            } else {

                $line = get_lang('NoResult');

            }

        } else {

            $new_view = substr_replace($view, '1', 4, 1);

        }

        return array($title_line, $line);

    }