summaryrefslogtreecommitdiff
path: root/bin/rtt-tm-unban-tick
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2025-04-28 22:09:29 +0200
committerTor Andersson <tor@ccxvii.net>2025-04-29 01:16:25 +0200
commit48e39e44dbe267f8945e9d597e61fd8aa3dfb376 (patch)
treec75e854fadc20d827cd5b422c5ab0f1a45cdf1d2 /bin/rtt-tm-unban-tick
parent7a93787dfe5cdaba3eed98ed8edd19674186430b (diff)
downloadserver-48e39e44dbe267f8945e9d597e61fd8aa3dfb376.tar.gz
Improved fuzzing.
Diffstat (limited to 'bin/rtt-tm-unban-tick')
-rwxr-xr-xbin/rtt-tm-unban-tick4
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/rtt-tm-unban-tick b/bin/rtt-tm-unban-tick
index 7294e81..d98a8d8 100755
--- a/bin/rtt-tm-unban-tick
+++ b/bin/rtt-tm-unban-tick
@@ -12,7 +12,7 @@ create temporary view tm_lift_ban_view as
select
user_id,
name,
- date(timeout_last),
+ date(timeout_last) as timeout_date,
timeout_total,
games_since_timeout,
(games_since_timeout > timeout_total) and (julianday() > julianday(timeout_last)+14) as lift_ban
@@ -23,7 +23,7 @@ create temporary view tm_lift_ban_view as
order by lift_ban desc, timeout_last asc
;
-select * from tm_lift_ban_view;
+select name, timeout_date, timeout_total, games_since_timeout from tm_lift_ban_view where lift_ban;
delete from tm_banned where user_id in (select user_id from tm_lift_ban_view where lift_ban) returning user_id;