chamilo / chamilo-lms

     * @param    int $session_id Session id (optional)

     * @return    int        count of visited links

     */

    public static function count_student_visited_links($student_id, $courseId, $session_id = 0)

    {

        $student_id  = intval($student_id);

        $courseId = intval($courseId);

        $session_id  = intval($session_id);

        // table definition

        $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_LINKS);

        $sql = 'SELECT 1

                FROM '.$table.'

                WHERE

                    links_user_id= '.$student_id.' AND

                    c_id = "'.$courseId.'" AND

                    links_session_id = '.$session_id.' ';

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

        return Database::num_rows($rs);

    }

    /**

     * Get count student downloaded documents

     * @param    int        Session id (optional)

     * @return    int        Count downloaded documents

     */

    public static function count_student_downloaded_documents($student_id, $courseId, $session_id = 0)

    {

        $student_id  = intval($student_id);

        $courseId = intval($courseId);

        $session_id  = intval($session_id);

        // table definition

        $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

        $sql = 'SELECT 1

                FROM '.$table.'

                WHERE down_user_id = '.$student_id.'

                AND c_id  = "'.$courseId.'"

                AND down_session_id = '.$session_id.' ';

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

        return Database::num_rows($rs);

    }

    /**

     * Get course list inside a session from a student