From 30da109c053fa54b3a2f80dfb6777e3ad7da1b4c Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
Date: Wed, 27 Sep 2017 16:45:16 +0200
Subject: filter blacklisted servers + color tags

---
 lib/MasterWebInterface/Database/Pg/Servers.pm | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'lib/MasterWebInterface/Database/Pg/Servers.pm')

diff --git a/lib/MasterWebInterface/Database/Pg/Servers.pm b/lib/MasterWebInterface/Database/Pg/Servers.pm
index 0ed47b1..28b9b7a 100755
--- a/lib/MasterWebInterface/Database/Pg/Servers.pm
+++ b/lib/MasterWebInterface/Database/Pg/Servers.pm
@@ -45,6 +45,8 @@ sub dbServerListGet {
       ? ('hostname ILIKE ?' => "%$o{search}%") : (),
     $o{updated} 
       ? ('serverlist.updated > to_timestamp(?)' => (time-$o{updated}) ) : (),
+    $o{filter}
+      ? ('blacklisted = CAST(? AS BOOLEAN)' => 0) : (),
     ('length(hostname) > ?' => 1),  # don't allow empty hostnames
     ('hostport > ?' => 0),          # or games with empty hostport
   );
-- 
cgit v1.2.3