chamilo / chamilo-lms

    /**

     * Check if this still links to an exercise

     */

    public function is_valid_link()

    {

        $sql = 'SELECT count(id) 

                FROM '.$this->get_exercise_table().'

                WHERE 

                    c_id = '.$this->course_id.' AND 

                    id = '.(int) $this->get_ref_id().' ';

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

        $number = Database::fetch_row($result);

        return ($number[0] != 0);

    }

    /**

     * Check if this still links to an exercise

     */

    public function is_valid_link()

    {

        $sql = 'SELECT count(id) from '.$this->get_forum_thread_table().'

                WHERE c_id = '.$this->course_id.' AND thread_id = '.$this->get_ref_id().' AND session_id='.api_get_session_id().'';

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

        $number = Database::fetch_row($result);

        return ($number[0] != 0);

    }

    public function get_test_id()

    {

    /**

     * Check if this still links to a learnpath

     */

    public function is_valid_link()

    {

        $sql = 'SELECT count(id) FROM '.$this->get_learnpath_table().'

                WHERE c_id = ' . $this->course_id.' AND id = '.$this->get_ref_id().' ';

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

        $number = Database::fetch_row($result, 'NUM');

        return ($number[0] != 0);

    }

    public function get_type_name()