aboutsummaryrefslogtreecommitdiff
path: root/lib/MasterWebInterface/Database/Servers.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/MasterWebInterface/Database/Servers.pm')
-rwxr-xr-xlib/MasterWebInterface/Database/Servers.pm6
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/MasterWebInterface/Database/Servers.pm b/lib/MasterWebInterface/Database/Servers.pm
index a305ce8..f9ad636 100755
--- a/lib/MasterWebInterface/Database/Servers.pm
+++ b/lib/MasterWebInterface/Database/Servers.pm
@@ -17,11 +17,13 @@ sub dbServerListGet {
my %where = (
# gamename and char are "all" or value
+ $o{updated} ? ('dt_updated > ?' => (time-$o{updated})) : (),
$o{gamename} !~ /all/ ? ('serverlist.gamename = ?' => $o{gamename}) : (),
$o{nolist} ? ('serverlist.gamename <> ?' => $o{nolist}) : (),
$o{search} ? ('LOWER(hostname) LIKE LOWER(?)' => "%$o{search}%") : (),
- $o{gametype} ? ('LOWER(gametype) LIKE LOWER(?)' => $o{gametype}) : (),
- $o{updated} ? ('dt_updated > ?' => (time-$o{updated})) : (),
+ $o{gametype} ? ('LOWER(gametype) LIKE LOWER(?)' => lc $o{gametype}) : (),
+ $o{popserv} ? ('numplayers > ?' => 0) : (),
+ $o{utdemo} ? ('gamever = ?' => '348') : (),
('hostport > ?' => 0), # sanity check (unresponsive servers or faulty queries tools)
);