]> git.localhorst.tv Git - alttp.git/blobdiff - app/Console/Commands/SyncSpeedGaming.php
twitch bot dummy
[alttp.git] / app / Console / Commands / SyncSpeedGaming.php
index 6d0fa1faa777801f213af2f38abfb8c62ec33047..3f2058f857136a986cd05c717b5356176fdb134b 100644 (file)
@@ -61,7 +61,7 @@ class SyncSpeedGaming extends Command {
        private function syncEvent(Event $event) {
                $sgHandle = substr($event->external_schedule, 3);
                $from = now()->sub(1, 'day');
-               $to = now()->add(6, 'day');
+               $to = now()->add(14, 'day');
                $sgSchedule = HTTP::get('https://speedgaming.org/api/schedule/', [
                        'event' => $sgHandle,
                        'from' => $from->toIso8601String(),
@@ -87,6 +87,8 @@ class SyncSpeedGaming extends Command {
                        ->where('start', '<=', $to)
                        ->whereNotIn('ext_id', $ext_ids);
                foreach ($to_purge->get() as $episode) {
+                       $episode->channels()->detach();
+                       $episode->crew()->delete();
                        $episode->players()->delete();
                }
                $to_purge->delete();
@@ -102,7 +104,7 @@ class SyncSpeedGaming extends Command {
                $episode->event()->associate($event);
                $episode->title = $sgEntry['match1']['title'];
                $start = Carbon::createFromFormat('Y-m-d\TH:i:sP', $sgEntry['when']);
-               if ($start->ne($episode->start)) {
+               if (!$episode->start || $start->ne($episode->start)) {
                        $episode->start = $start;
                }
                $episode->estimate = $sgEntry['length'] * 60;
@@ -281,6 +283,9 @@ class SyncSpeedGaming extends Command {
                if ($channel) {
                        return $channel;
                }
+               return $episode->channels()
+                 ->where('ext_id', 'LIKE', 'sg:%')
+                 ->first();
        }
 
        private function getUserBySGPlayer($player) {