Bubble [main]

Unset the forced omit flags on posts when a Limited user is elevated to Basic

diff --git a/admin.py b/admin.py
index 7d68bf1..0001d17 100644
--- a/admin.py
+++ b/admin.py
@@ -26,6 +26,7 @@ def admin_actions(session):
             if not user:
                 return 51, 'Not found'
             db.update_user(user, role=User.BASIC)
+            db.unset_post_omit_flags(user)
             db.notify_role(user)
             page += f'User "{name}" (ID: {user.id}) has been given a Basic role.\n\n'
             page += f"=> /admin/review-users/ Continue Review\n"
diff --git a/model.py b/model.py
index 256d726..bc043ae 100644
--- a/model.py
+++ b/model.py
@@ -1829,6 +1829,13 @@ class Database:
             return count
         return 0
 
+    def unset_post_omit_flags(self, user: User):
+        # This is used when a Limited user is elevated to a Basic role.
+        # The forced omit flags are cleared.
+        cur = self.conn.cursor()
+        cur.execute("UPDATE posts SET flags=0 WHERE user=?", (user.id,))
+        self.commit()
+
     def update_post(self, post, title=None, flags=None, subspace_id=None):
         set_stm = []
         values = []