X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FConsole%2FCommands%2FChatlibDatabase.php;h=280d4a0c6351e29fd04a2ee0d31c4d0a68fe1712;hb=26d47ca368d8e7c2690cec49f6ae2ad509a0428d;hp=b95bb64a06a6dbec47b333c2c9248493e0c8492d;hpb=64f5be008ef28c812cb7ed87149f4eb86f6021eb;p=alttp.git

diff --git a/app/Console/Commands/ChatlibDatabase.php b/app/Console/Commands/ChatlibDatabase.php
index b95bb64..280d4a0 100644
--- a/app/Console/Commands/ChatlibDatabase.php
+++ b/app/Console/Commands/ChatlibDatabase.php
@@ -35,6 +35,8 @@ class ChatlibDatabase extends Command {
 			->where('banned', '=', false)
 			->whereNotNull('evaluated_at')
 			->where('created_at', '<', now()->sub(7, 'day'))
+			->whereNotIn('classification', ['gg', 'gl', 'number', 'o7'])
+			->whereRaw('LENGTH(`text_content`) > 12')
 			->chunk(5000, function ($msgs) use ($de, $en) {
 				foreach ($msgs as $msg) {
 					if ($msg->detected_language === 'de') {