$events = Event::where('external_schedule', 'LIKE', 'sg:%')
->where(function (Builder $query) {
$query->whereNull('end');
- $query->orWhere('end', '<', now());
+ $query->orWhere('end', '>', now());
})
->get();
}
$channel->short_name = $sgChannel['initials'];
$channel->title = $sgChannel['name'];
- $channel->stream_link = 'https://twitch.tv/'.strtolower($sgChannel['name']);
+ $channel->stream_link = 'https://twitch.tv/'.strtolower($sgChannel['slug']);
$channel->languages = [$sgChannel['language']];
$channel->save();
return $channel;
}
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;