chamilo / chamilo-lms

     * @author Juan Carlos Raña <[email protected]>

     * @return int current database status of discuss visibility and change it if get action page

     */

    public function check_visibility_discuss()

    {

        $tbl_wiki = $this->tbl_wiki;

        $page = $this->page;

        $condition_session = $this->condition_session;

        $groupfilter = $this->groupfilter;

        $course_id = api_get_course_int_id();

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

                WHERE

                    c_id = '.$course_id.' AND

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

                    '.$groupfilter.$condition_session.'

                ORDER BY id ASC';

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

        $row = Database::fetch_array($result);

        $status_visibility_disc = $row['visibility_disc'];

        //change status

        if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) {

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'showdisc' && $status_visibility_disc == 0) {

                $status_visibility_disc = 1;

            }

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'hidedisc' && $status_visibility_disc == 1) {

                $status_visibility_disc = 0;

            }

            $sql = 'UPDATE '.$tbl_wiki.' SET visibility_disc="'.Database::escape_string($status_visibility_disc).'"

                    WHERE

                        c_id = '.$course_id.' AND

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

                        '.$groupfilter.$condition_session;

            Database::query($sql);

            // Although the value now is assigned to all (not only the first),

            // these three lines remain necessary.

            // They do that by changing the page state is made when you press

            // the button and not have to wait to change his page

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

                    WHERE

                        c_id = '.$course_id.' AND

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

                        '.$groupfilter.$condition_session.'

                    ORDER BY id ASC';

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

            $row = Database::fetch_array($result);

        }

        return $row['visibility_disc'];

    }

    /**

     * Lock add discussion

     * @author Juan Carlos Raña <[email protected]>

     * @return int current database status of lock dicuss and change if get action

     */

    public function check_addlock_discuss()

    {

        $tbl_wiki = $this->tbl_wiki;

        $page = $this->page;

        $condition_session = $this->condition_session;

        $groupfilter = $this->groupfilter;

        $course_id = api_get_course_int_id();

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

                WHERE

                    c_id = '.$course_id.' AND

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

                    '.$groupfilter.$condition_session.'

                ORDER BY id ASC';

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

        $row = Database::fetch_array($result);

        $status_addlock_disc = $row['addlock_disc'];

        //change status

        if (api_is_allowed_to_edit() || api_is_platform_admin()) {

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'lockdisc' && $status_addlock_disc == 0) {

                $status_addlock_disc = 1;

            }

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'unlockdisc' && $status_addlock_disc == 1) {

                $status_addlock_disc = 0;

            }

            $sql = 'UPDATE '.$tbl_wiki.' SET

                    addlock_disc="'.Database::escape_string($status_addlock_disc).'"

                    WHERE

                        c_id = '.$course_id.' AND

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

                         '.$groupfilter.$condition_session;

            Database::query($sql);

            // Although the value now is assigned to all (not only the first),

            // these three lines remain necessary.

            // They do that by changing the page state is made when you press

            // the button and not have to wait to change his page

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

                    WHERE

                        c_id = '.$course_id.' AND

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

                        '.$groupfilter.$condition_session.'

                    ORDER BY id ASC';

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

            $row = Database::fetch_array($result);

        }

        return $row['addlock_disc'];

    }

    /**

     * Lock rating discussion

     * @author Juan Carlos Raña <[email protected]>

     * @return  int  current database status of rating discuss and change it if get action

     */

    public function check_ratinglock_discuss()

    {

        $tbl_wiki = $this->tbl_wiki;

        $page = $this->page;

        $condition_session = $this->condition_session;

        $groupfilter = $this->groupfilter;

        $course_id = api_get_course_int_id();

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

                WHERE

                    c_id = '.$course_id.' AND

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

                    '.$groupfilter.$condition_session.'

                ORDER BY id ASC';

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

        $row = Database::fetch_array($result);

        $status_ratinglock_disc = $row['ratinglock_disc'];

        //change status

        if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) {

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'lockrating' && $status_ratinglock_disc == 0) {

                $status_ratinglock_disc = 1;

            }

            if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'unlockrating' && $status_ratinglock_disc == 1) {

                $status_ratinglock_disc = 0;

            }

            $sql = 'UPDATE '.$tbl_wiki.'

                    SET ratinglock_disc="'.Database::escape_string($status_ratinglock_disc).'"

                    WHERE

                        c_id = '.$course_id.' AND

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

                        '.$groupfilter.$condition_session;

            //Visibility. Value to all,not only for the first

            Database::query($sql);

            // Although the value now is assigned to all (not only the first),

            // these three lines remain necessary. They do that by changing the

            // page state is made when you press the button and not have to wait

            // to change his page

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

                  WHERE

                    c_id = '.$course_id.' AND

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

                    '.$groupfilter.$condition_session.'

                  ORDER BY id ASC';

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

            $row = Database::fetch_array($result);

        }

        return $row['ratinglock_disc'];

    }

    /**

     * Notify page changes