aboutsummaryrefslogtreecommitdiff
path: root/lib/MasterWebInterface/Database
diff options
context:
space:
mode:
Diffstat (limited to 'lib/MasterWebInterface/Database')
-rwxr-xr-xlib/MasterWebInterface/Database/Pg/Servers.pm2
-rwxr-xr-xlib/MasterWebInterface/Database/SQLite/Servers.pm2
2 files changed, 4 insertions, 0 deletions
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
);
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
);