From 6977dce178bc418e365b4a013d5798ac8e9e1595 Mon Sep 17 00:00:00 2001
From: Daniel Karbach <daniel.karbach@localhorst.tv>
Date: Thu, 28 Mar 2024 11:03:41 +0100
Subject: [PATCH] clean up forgotten guessing games

---
 app/Console/Commands/GuessingClean.php | 47 ++++++++++++++++++++++++++
 app/Console/Kernel.php                 |  1 +
 2 files changed, 48 insertions(+)
 create mode 100644 app/Console/Commands/GuessingClean.php

diff --git a/app/Console/Commands/GuessingClean.php b/app/Console/Commands/GuessingClean.php
new file mode 100644
index 0000000..d26b3e9
--- /dev/null
+++ b/app/Console/Commands/GuessingClean.php
@@ -0,0 +1,47 @@
+<?php
+
+namespace App\Console\Commands;
+
+use App\Models\Channel;
+use Illuminate\Console\Command;
+use Illuminate\Http\Client\RequestException;
+use Illuminate\Support\Facades\Http;
+
+class GuessingClean extends Command {
+
+	/**
+	 * The name and signature of the console command.
+	 *
+	 * @var string
+	 */
+	protected $signature = 'guessing:clean';
+
+	/**
+	 * The console command description.
+	 *
+	 * @var string
+	 */
+	protected $description = 'Cancel orphaned guessing games';
+
+	/**
+	 * Execute the console command.
+	 *
+	 * @return int
+	 */
+	public function handle()
+	{
+		$channels = Channel
+			::whereNotNull('guessing_start')
+			->where('guessing_start', '<', now()
+			->sub(4, 'hour'))
+			->get();
+		foreach ($channels as $channel) {
+			$this->line($channel->title);
+			$channel->guessing_start = null;
+			$channel->guessing_end = null;
+			$channel->save();
+		}
+		return Command::SUCCESS;
+	}
+
+}
diff --git a/app/Console/Kernel.php b/app/Console/Kernel.php
index bbb747d..32e5c8a 100644
--- a/app/Console/Kernel.php
+++ b/app/Console/Kernel.php
@@ -22,6 +22,7 @@ class Kernel extends ConsoleKernel
 		$schedule->command('sync:avatars')->everyFiveMinutes();
 		$schedule->command('sync:racetime')->everyFiveMinutes();
 		$schedule->command('chat:evaluate 100')->everyMinute();
+		$schedule->command('guessing:clean')->everyFifteenMinutes();
     }
 
     /**
-- 
2.39.2