diff options
author | Tor Andersson <tor@ccxvii.net> | 2025-04-28 22:09:29 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2025-04-29 01:16:25 +0200 |
commit | 48e39e44dbe267f8945e9d597e61fd8aa3dfb376 (patch) | |
tree | c75e854fadc20d827cd5b422c5ab0f1a45cdf1d2 /bin/rtt-tm-unban-tick | |
parent | 7a93787dfe5cdaba3eed98ed8edd19674186430b (diff) | |
download | server-48e39e44dbe267f8945e9d597e61fd8aa3dfb376.tar.gz |
Improved fuzzing.
Diffstat (limited to 'bin/rtt-tm-unban-tick')
-rwxr-xr-x | bin/rtt-tm-unban-tick | 4 |
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; |