From fc3501382c2aa3ef5b692f4f55c2616f9cade3f5 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Fri, 25 Apr 2025 12:18:00 +0200
Subject: Move toolbox scripts to a "bin" directory.

Add a super "rtt" command to run the scripts.
---
 tools/lift-bans.sh | 30 ------------------------------
 1 file changed, 30 deletions(-)
 delete mode 100644 tools/lift-bans.sh

(limited to 'tools/lift-bans.sh')

diff --git a/tools/lift-bans.sh b/tools/lift-bans.sh
deleted file mode 100644
index e76f621..0000000
--- a/tools/lift-bans.sh
+++ /dev/null
@@ -1,30 +0,0 @@
-#!/bin/bash
-
-sqlite3 db <<EOF
-
-begin immediate;
-
-.mode column
-
-create temporary view tm_lift_ban_view as
-	select
-		user_id,
-		name,
-		date(timeout_last),
-		timeout_total,
-		games_since_timeout,
-		(games_since_timeout > timeout_total) and (julianday() > julianday(timeout_last)+14) as lift_ban
-	from
-		user_profile_view
-	where
-		user_id in (select user_id from tm_banned)
-	order by lift_ban desc, timeout_last asc
-;
-
-select * from tm_lift_ban_view;
-
-delete from tm_banned where user_id in (select user_id from tm_lift_ban_view where lift_ban) returning user_id;
-
-commit;
-
-EOF
-- 
cgit v1.2.3