namespace App\Models;
+use Illuminate\Broadcasting\Channel as PublicChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Database\Eloquent\BroadcastsEvents;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
+use Illuminate\Support\Arr;
-class Channel extends Model
-{
+class Channel extends Model {
+
+ use BroadcastsEvents;
use HasFactory;
+ public function broadcastOn($event) {
+ $channels = [
+ new PrivateChannel('Channel.'.$this->id),
+ ];
+ if (!empty($this->access_key)) {
+ $channels[] = new PublicChannel('ChannelKey.'.$this->access_key);
+ }
+ return $channels;
+ }
+
public function getCurrentEpisode() {
return $this->episodes()
->where('start', '<', now()->subMinutes(10))
->first();
}
+ public function randomOfClass($class) {
+ return $this->queryChatlog()
+ ->where('classification', '=', $class)
+ ->first();
+ }
+
+ public function queryChatlog() {
+ return ChatLog::where('type', '=', 'chat')
+ ->where('banned', '=', false)
+ ->where('created_at', '<', now()->sub(1, 'day'))
+ ->where(function ($query) {
+ $query->whereNull('detected_language');
+ $query->orWhereIn('detected_language', $this->getPreferredLanguages());
+ })
+ ->inRandomOrder();
+ }
+
+ public function getPreferredLanguages() {
+ $setting = $this->getChatSetting('language');
+ if ($setting) {
+ return [$setting];
+ }
+ if (!empty($this->languages)) {
+ return $this->languages;
+ }
+ return ['de'];
+ }
+
+ public function getChatSetting($name, $default = null) {
+ if (array_key_exists($name, $this->chat_settings)) {
+ return $this->chat_settings[$name];
+ }
+ return $default;
+ }
+
public function getGuessingLeaderboard() {
- return $this->winners()->selectRaw('(select t2.uname from guessing_winners t2 where t2.uid = guessing_winners.uid order by created_at desc limit 1) as name, sum(score) as score')->groupBy('uid')->orderBy('score', 'desc')->limit(10)->get();
+ $query = $this->winners()
+ ->selectRaw('(select t2.uname from guessing_winners t2 where t2.uid = guessing_winners.uid order by created_at desc limit 1) as name, sum(score) as score')
+ ->where('score', '!=', 0)
+ ->groupBy('uid')
+ ->orderBy('score', 'desc')
+ ->limit(10);
+ $type = $this->getGuessingSetting('leaderboard_type', 'all');
+ if ($type == 'month') {
+ $query->where('created_at', '>=', now()->startOfMonth());
+ } else if ($type == 'year') {
+ $query->where('created_at', '>=', now()->startOfYear());
+ } else if (is_numeric($type)) {
+ $query->where('created_at', '>=', now()->sub($type, 'days'));
+ }
+ return $query->get();
}
public function hasActiveGuessing() {
$distance = abs(intval($guess->guess) - intval($solution));
if (is_null($min_distance) || $distance == $min_distance) {
$candidates[] = $guess;
+ if (is_null($min_distance)) {
+ $min_distance = $distance;
+ }
} else if ($distance < $min_distance) {
$candidates = [$guess];
$min_distance = $distance;
$this->save();
}
+ public function transformGuess($original) {
+ $transformed = trim($original);
+ if ($this->guessing_type == 'gtbk') {
+ $transformed = str_replace(['roodyo1Gtbigkey'], ['2'], $transformed);
+ $transformed = str_ireplace(['vier 4Head'], ['4'], $transformed);
+ }
+ return $transformed;
+ }
+
public function registerGuess($uid, $uname, $guess) {
$model = new GuessingGuess();
$model->channel()->associate($this);
$model->uid = $uid;
$model->uname = $uname;
- $model->guess = $guess;
+ $model->guess = $this->transformGuess($guess);
$model->save();
}
public function scoreGuessing($solution, $guess, $first) {
- if ($guess == $solution) {
+ $transformed = $this->transformGuess($guess);
+ if ($transformed == $solution) {
if ($first) {
return $this->getGuessingSetting('points_exact_first', 1);
}
return $this->getGuessingSetting('points_exact_other', 1);
}
- $distance = abs(intval($guess) - intval($solution));
+ $distance = abs(intval($transformed) - intval($solution));
if ($distance <= $this->getGuessingSetting('points_close_max', 3)) {
if ($first) {
return $this->getGuessingSetting('points_close_first', 1);
}
public function isValidGuess($solution) {
+ $transformed = $this->transformGuess($solution);
if ($this->guessing_type == 'gtbk') {
- $int_solution = intval($solution);
- return $int_solution > 0 && $int_solution < 23;
+ $int_solution = intval($transformed);
+ return is_numeric($transformed) && $int_solution > 0 && $int_solution < 23;
}
return false;
}
+ public function listGuessingWinners($winners) {
+ $names = [];
+ $distance = 0;
+ foreach ($winners as $winner) {
+ if ($winner->score > 0) {
+ $names[] = $winner->uname;
+ $distance = abs(intval($winner->guess) - intval($winner->solution));
+ }
+ }
+ $msg = '';
+ if (empty($names)) {
+ $msg = $this->getGuessingSetting('no_winners_message');
+ } else {
+ $msg = $this->getGuessingSetting($distance ? 'close_winners_message' : 'winners_message', $this->getGuessingSetting('winners_message'));
+ $msg = str_replace(['{distance}', '{names}'], [$distance, $this->listAnd($names)], $msg);
+ }
+ return $msg;
+ }
+
+ public function listAnd($entries) {
+ $lang = empty($this->languages) ? 'en' : $this->languages[0];
+ if ($lang == 'de') {
+ return Arr::join($entries, ', ', ' und ');
+ }
+ return Arr::join($entries, ', ', ' and ');
+ }
+
public function crews() {
return $this->hasMany(ChannelCrew::class);
}
'chat' => 'boolean',
'chat_commands' => 'array',
'chat_settings' => 'array',
+ 'guessing_end' => 'datetime',
'guessing_settings' => 'array',
'guessing_start' => 'datetime',
- 'guessing_end' => 'datetime',
'languages' => 'array',
'join' => 'boolean',
];
protected $hidden = [
+ 'access_key',
+ 'chat',
+ 'chat_commands',
+ 'chat_settings',
'created_at',
'ext_id',
+ 'guessing_settings',
+ 'join',
+ 'twitch_chat',
'updated_at',
];
projects / alttp.git / blobdiff