chamilo / chamilo-lms

        }

        //change status

        if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'locknotifydisc' && $status_notify_disc == 0) {

            $sql = "INSERT INTO ".$tbl_wiki_mailcue." (c_id, id, user_id, type, group_id, session_id) VALUES

            ($course_id, '".$id."','".api_get_user_id()."','D','".$groupId."','".$session_id."')";

            Database::query($sql);

            $status_notify_disc = 1;

        }

        if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'unlocknotifydisc' && $status_notify_disc == 1) {

            $sql = 'DELETE FROM '.$tbl_wiki_mailcue.'

                    WHERE c_id = '.$course_id.' AND id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="D" AND c_id = '.$course_id;

            Database::query($sql);

            $status_notify_disc = 1;

        }

        if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'unlocknotifydisc' && $status_notify_disc == 1) {

            $sql = 'DELETE FROM '.$tbl_wiki_mailcue.'

                    WHERE c_id = '.$course_id.' AND id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="D" AND c_id = '.$course_id;

            Database::query($sql);

            $status_notify_disc = 0;

        }

        return $status_notify_disc;

    }

        }

        //change status

        if (isset($_GET['actionpage']) && $_GET['actionpage'] == 'locknotifyall' && $status_notify_all == 0) {

            $sql = "INSERT INTO ".$tbl_wiki_mailcue." (c_id, user_id, type, group_id, session_id) VALUES

            ($course_id, '".api_get_user_id()."','F','".$groupId."','".$session_id."')";

            Database::query($sql);

            $status_notify_all = 1;

        }

        if (isset($_GET['actionpage']) &&

            isset($_GET['actionpage']) &&

            $status_notify_all = 1;

        }

        if (isset($_GET['actionpage']) &&

            isset($_GET['actionpage']) &&

            $_GET['actionpage'] == 'unlocknotifyall' &&

            $status_notify_all == 1

        ) {

            $sql = 'DELETE FROM '.$tbl_wiki_mailcue.'

                   WHERE

                    c_id = '.$course_id.' AND

                    user_id="'.api_get_user_id().'" AND

                    type="F" AND

                    group_id="'.$groupId.'" AND

                    session_id="'.$session_id.'" AND

                    c_id = '.$course_id;

            Database::query($sql);

            $status_notify_all = 0;

        }

        //show status

        return $status_notify_all;