From 30da109c053fa54b3a2f80dfb6777e3ad7da1b4c Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Wed, 27 Sep 2017 16:45:16 +0200 Subject: filter blacklisted servers + color tags --- lib/MasterWebInterface/Database/SQLite/Servers.pm | 2 ++ 1 file changed, 2 insertions(+) (limited to 'lib/MasterWebInterface/Database/SQLite/Servers.pm') diff --git a/lib/MasterWebInterface/Database/SQLite/Servers.pm b/lib/MasterWebInterface/Database/SQLite/Servers.pm index 041c4d9..538eadf 100755 --- a/lib/MasterWebInterface/Database/SQLite/Servers.pm +++ b/lib/MasterWebInterface/Database/SQLite/Servers.pm @@ -43,6 +43,8 @@ sub dbServerListGet { ? ('lower(hostname) LIKE lower(?)' => "%$o{search}%") : (), $o{updated} ? ('serverlist.updated > datetime(?, \'unixepoch\')' => (time-$o{updated})) : (), + $o{filter} + ? ('blacklisted = ?' => 0) : (), # ('length(hostname) > ?' => 1), # don't show empty hostnames ('hostport > ?' => 0), # or games with empty hostport ); -- cgit v1.2.3