jgrim

Is anyone using this community? If not, I'm going to disable the bot and close it.

Hello!

I’m going to implement a variant of this.

-jgrim

cross-posted from: https://lemmy.ca/post/40761824

Sorry everyone I know how much you love the attention she gives you, but I've implemented some quick and dirty filtering for private messaging.

We now have the ability to automatically mark PM's as deleted or read, depending on content inside of them. If we accidentally filter something you legitimately wanted (ie, not Nicole) please let me know.

If any other instances would like to implement this, here's the code. Note that you'll need to set your hostname at the top here for some reason I haven't exactly identified.

SET lemmy.protocol_and_hostname = 'https://lemmy.ca/';

CREATE TABLE private_message_filters (
    id SERIAL PRIMARY KEY,
    phrase TEXT NOT NULL,
    behavior VARCHAR(10) NOT NULL CHECK (behavior IN ('delete', 'mark_read'))
);

CREATE OR REPLACE FUNCTION filter_private_messages()
RETURNS trigger AS $$
DECLARE
    banned_phrase_record private_message_filters%ROWTYPE;
BEGIN
    FOR banned_phrase_record IN 
        SELECT * FROM private_message_filters
    LOOP
        IF LOWER(TRIM(NEW.content)) ILIKE '%' || LOWER(TRIM(banned_phrase_record.phrase)) || '%' THEN
            IF banned_phrase_record.behavior = 'delete' THEN
                NEW.deleted := true;
                RETURN NEW;
            ELSIF banned_phrase_record.behavior = 'mark_read' THEN
                NEW.read := true;
                RETURN NEW;
            END IF;
        END IF;
    END LOOP;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER trg_filter_private_messages
AFTER INSERT ON private_message
FOR EACH ROW
EXECUTE FUNCTION filter_private_messages();

To add filter words:

insert into private_message_filters (behavior, phrase) values ('delete', 'spamtestdelete');
insert into private_message_filters (behavior, phrase) values ('mark_read', 'spamtestread');

If you want to quickly disable / enable filtering while testing:

ALTER TABLE private_message DISABLE TRIGGER trg_filter_private_messages;
ALTER TABLE private_message ENABLE TRIGGER trg_filter_private_messages;

I'll leave it up to you to figure out what phrases to filter on. MAKE SURE YOU TEST. If there's an error, private messaging could break completely. You should not get an error message from the UI while sending a message with a banned word.

Howdy,

I wanted to share with instance users that I've been mucking around with services to improve stability and security.

I used to announce before I did it but I haven't been recently. I'll get better at it again.

Let me know if you have any issues or questions!

Other services we run are social.photo and utter.online.

Edit: I should also mention we have status pages for all services:

• status.discuss.online
• status.matrix.discuss.online
• status.social.photo (coming soon: I just realized I forgot to add it)
• status.utter.online

Thanks, jgrim

Hello!

You may have noticed some instability and performance issues with the web client of Discuss.online. I have made some infrastructure changes to hopefully improve stability. In the process, I also updated to the latest version of Lemmy.

Let me know if you have issues or comments!

We have a target api now!

Hello!

Please welcome our newest admin, @[email protected]!

They joined to help increase community engagement, moderation, & perhaps some help raising funding. We're looking forward to their help and experience in improving our instance and the fediverse as a whole.

Here is a quick introduction from m_f.

I started getting involved in Lemmy mod duties over at [email protected] when the only mod went AWOL. That gave me the confidence to create a few communities for comics that didn't have any Lemmy communities yet, and then a community for posting loops. When [email protected] needed a moderator, I volunteered to help out there, and now I'm helping out on admin duties for the instance. Moral of the story is, stepping up to help out is a great low-effort way to help Lemmy grow

• jgrim

cross-posted from: https://lemmy.world/post/16252553

Apple will update iPhones for at least 5 years in rare public commitment