From 4ebfa4f82679b5edafca70b2da1646d5d1b2decc Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Thu, 16 May 2024 21:58:52 +0500 Subject: upd: send nothing if the channel is opted out --- src/stream.cpp | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) (limited to 'src/stream.cpp') diff --git a/src/stream.cpp b/src/stream.cpp index 4868995..ad7df68 100644 --- a/src/stream.cpp +++ b/src/stream.cpp @@ -87,9 +87,14 @@ namespace bot::stream { " AND target_alias_id = " + std::to_string(stream.user_id)); for (const auto &event : events) { - pqxx::row channel = - work.exec1("SELECT alias_id, alias_name FROM channels WHERE id = " + - std::to_string(event[1].as())); + pqxx::row channel = work.exec1( + "SELECT alias_id, alias_name, opted_out_at FROM channels WHERE id " + "= " + + std::to_string(event[1].as())); + + if (!channel[2].is_null()) { + continue; + } pqxx::result subs = work.exec( "SELECT user_id FROM event_subscriptions WHERE event_id = " + -- cgit v1.2.3