X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FConsole%2FCommands%2FSyncSpeedGaming.php;h=95304c318453a81502c1df45705d32736a141079;hb=94268534de35c414d4c76ccdf7d46ed7a5308693;hp=ce8b10c4a7e4faf5fbacd86f58ca9b3d5016c9c2;hpb=7d018a20dfb545cefb1f28627841d9995052c1f6;p=alttp.git

diff --git a/app/Console/Commands/SyncSpeedGaming.php b/app/Console/Commands/SyncSpeedGaming.php
index ce8b10c..95304c3 100644
--- a/app/Console/Commands/SyncSpeedGaming.php
+++ b/app/Console/Commands/SyncSpeedGaming.php
@@ -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(),
@@ -104,7 +104,17 @@ 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 ($event->fix_timezone && !$episode->timezone_fix_override) {
+			$sg_zone = new \DateTimeZone('America/Chicago');
+			$event_zone = new \DateTimeZone($event->fix_timezone);
+			// if speedgaming is in DST, it fucks up the timestamp
+			if (Carbon::createFromTimestamp($start->timestamp, $sg_zone)->dst && !Carbon::createFromTimestamp($start->timestamp, $event_zone)->dst) {
+				$start->add(1, 'hour');
+			} else if (!Carbon::createFromTimestamp($start->timestamp, $sg_zone)->dst && Carbon::createFromTimestamp($start->timestamp, $event_zone)->dst) {
+				$start->sub(1, 'hour');
+			}
+		}
+		if (!$episode->start || $start->ne($episode->start)) {
 			$episode->start = $start;
 		}
 		$episode->estimate = $sgEntry['length'] * 60;
@@ -283,6 +293,9 @@ class SyncSpeedGaming extends Command {
 		if ($channel) {
 			return $channel;
 		}
+		return $episode->channels()
+		  ->where('ext_id', 'LIKE', 'sg:%')
+		  ->first();
 	}
 
 	private function getUserBySGPlayer($player) {