chamilo / chamilo-lms

     * @return bool  False if title is already taken

     * @author Patrick Cool <[email protected]>, Ghent University

     **/

    public function checktitle($link)

    {

        $tbl_wiki = $this->tbl_wiki;

        $condition_session = $this->condition_session;

        $course_id = $this->course_id;

        $groupfilter = $this->groupfilter;

        $sql = 'SELECT * FROM '.$tbl_wiki.'

                WHERE

                    c_id = '.$course_id.' AND

                    reflink="'.Database::escape_string($link).'" AND

                    '.$groupfilter.$condition_session.'';

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

        $numberofresults = Database::num_rows($result);

        // the value has not been found and is this available

        if ($numberofresults == 0) {

            return true;

        } else {

            // the value has been found

            return false;

        }

    }

    /**

     * check wikilinks that has a page

    /**

     * This function checks if wiki title exist

     */

    public function wiki_exist($title)

    {

        $tbl_wiki = $this->tbl_wiki;

        $groupfilter = $this->groupfilter;

        $condition_session = $this->condition_session;

        $course_id = api_get_course_int_id();

        $sql = 'SELECT id FROM '.$tbl_wiki.'

              WHERE

                c_id = '.$course_id.' AND

                title="'.Database::escape_string($title).'" AND

                '.$groupfilter.$condition_session.'

              ORDER BY id ASC';

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

        $cant = Database::num_rows($result);

        if ($cant > 0) {

            return true;

        } else {

            return false;

        }

    }

    /**

     * Checks if this navigation tab has to be set to active

     * @author Patrick Cool <[email protected]>, Ghent University