An automatic group of group owners

功能
1

Is there a way to have an automatic group which contains all group owners, in much the same way as @staff works?

I’d like to make all my group owners TL2, and to keep track of them as my site (hopefully) grows quickly. Also I want to change their powers as a group as time goes on, as well as communicate with them and have a category for them. I don’t want to make them all mods as they aren’t ready for that.

In the meantime, I can do this manually; however as our tightly managed Forum grows an automatic group would become more and more helpful.

Alternatively, how hard would this be to do as a plugin?

7 个赞
2

我刚刚实现了一个 Creating triggered custom badge queries 来识别当前群组所有者。

SQL 如下（也可在 Data Explorer 中使用）：

SELECT DISTINCT user_id, owner, CURRENT_TIMESTAMP granted_at
FROM group_users
WHERE group_users.owner = true

它使用了 CURRENT_TIMESTAMP，因为我没有在数据库中找到方便的群组所有权时间戳。也没有方便的触发器，所以 :backfill 可以省略。

我建议进行以下配置：

  1. 每天运行撤销查询
  2. 触发器：每日更新
  3. 我不确定“可以多次授予”
    该查询只为每个用户触发一次，所以不会多次授予。但是，一旦被撤销，可能需要再次授予徽章——不确定！
4 个赞