$events = Event::where('external_schedule', 'LIKE', 'sg:%')
->where(function (Builder $query) {
$query->whereNull('end');
- $query->orWhere('end', '<', now());
+ $query->orWhere('end', '>', now());
})
->get();
$episode->title = $sgEntry['match1']['title'];
$start = Carbon::createFromFormat('Y-m-d\TH:i:sP', $sgEntry['when']);
if ($event->fix_timezone && !$episode->timezone_fix_override) {
- $sg_zone = new \DateTimeZone('America/Chicago');
+ $sg_zone = new \DateTimeZone('America/Detroit');
$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) {
$this->purgeChannels($episode, $sgEntry);
$channelIds = [];
foreach ($sgEntry['channels'] as $sgChannel) {
- if ($sgChannel['initials'] == 'NONE') continue;
+ if ($sgChannel['initials'] == 'NONE' || $sgChannel['name'] == 'Undecided, Not SG') continue;
try {
$channel = $this->syncChannel($episode, $sgChannel);
$channelIds[] = $channel->id;
}
if (!empty($player['discordTag'])) {
$tag = explode('#', $player['discordTag']);
- $user = User::firstWhere([
- ['username', 'LIKE', $tag[0]],
- ['discriminator', '=', $tag[1]],
- ]);
+ $user = count($tag) < 2 || $tag[1] == '0'
+ ? User::firstWhere([
+ ['username', 'LIKE', $tag[0]],
+ ])
+ : User::firstWhere([
+ ['username', 'LIKE', $tag[0]],
+ ['discriminator', '=', $tag[1]],
+ ]);
if ($user) return $user;
}
return null;