From 690e8f4e4522b69b5963689bc96e9ac9507a0100 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sun, 17 Oct 2021 19:22:40 +0200 Subject: additional Json API support --- lib/MasterWebInterface/Database/Servers.pm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'lib/MasterWebInterface/Database') 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) ); -- cgit v1.2.3