X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FModels%2FChannel.php;h=500f2e33e6f9fb3456694d7dc403159dd7205260;hb=999e4fe15dbc31d2d2874381cc8b7c24fbded410;hp=bf3b98bc2b231c384a3079613e551514a7435c02;hpb=7649d12f400f164dd06f6a45486221234052dbb6;p=alttp.git

diff --git a/app/Models/Channel.php b/app/Models/Channel.php
index bf3b98b..500f2e3 100644
--- a/app/Models/Channel.php
+++ b/app/Models/Channel.php
@@ -34,6 +34,7 @@ class Channel extends Model {
 	public function getGuessingLeaderboard() {
 		$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);