Preserve expired bans in database

Issue #27 new
Alan Beam created an issue

Expected behavior When a ban expires, the ban is marked as no longer valid, but still exists in the database for historical/reporting purposes.

Actual behavior When a ban expires, the ban is removed from the database.

Additional notes This may possibly remove the need for the ban topic. It could also provide the infrastructure needed for a ban history page (for the room, mod, and/or user).

Comments (1)

  1. Alan Beam reporter

    I envision adding an "active" field to the ban table, defaulting to 1 and updating to 0 when the ban expires (instead of deleting it). All ban queries would need to be updated to add "WHERE active = 1".

  2. Log in to comment