diff options
| author | Darkelarious <github@333networks.com> | 2025-03-08 15:56:30 +0100 |
|---|---|---|
| committer | Darkelarious <github@333networks.com> | 2025-03-08 15:56:30 +0100 |
| commit | 6bd235f3e62251d8763a552ab0042d59584de842 (patch) | |
| tree | 2ff943b6ddb8aa8980a3ed1fb4a1f869fc787d1c /lib/MasterWebInterface/Database/Servers.pm | |
| parent | 318a5a20a930192df788dbac54b1f9c60e1b98b8 (diff) | |
| download | WebInterface-Perl-6bd235f3e62251d8763a552ab0042d59584de842.tar.gz WebInterface-Perl-6bd235f3e62251d8763a552ab0042d59584de842.zip | |
Metadata and update to hotfix 4.
Display thumbnails / snippets in 3rd party apps (like discord) and add map thumbnails + icons for multiple games. Minor fixes/optimisations.
Diffstat (limited to 'lib/MasterWebInterface/Database/Servers.pm')
| -rwxr-xr-x | lib/MasterWebInterface/Database/Servers.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/lib/MasterWebInterface/Database/Servers.pm b/lib/MasterWebInterface/Database/Servers.pm index 99b4f1e..f8a4b66 100755 --- a/lib/MasterWebInterface/Database/Servers.pm +++ b/lib/MasterWebInterface/Database/Servers.pm @@ -16,8 +16,9 @@ sub dbServerListGet { my %where = ( # gamename and char are "all" or value + $o{gamename} !~ /all/ ? ('serverlist.gamename = ?' => $o{gamename}) : (), $o{updated} ? ('dt_updated > ?' => (time-$o{updated})) : (), - $o{gamename} ? ('serverlist.gamename = ?' => $o{gamename}) : (), + #$o{gamename} ? ('serverlist.gamename = ?' => $o{gamename}) : (), $o{nolist} ? ('serverlist.gamename <> ?' => $o{nolist}) : (), $o{search} ? ('LOWER(hostname) LIKE LOWER(?)' => "%$o{search}%") : (), $o{popserv} ? ('numplayers > ?' => 0) : (), @@ -25,7 +26,7 @@ sub dbServerListGet { #advanced search $o{hostname} ? ('LOWER(hostname) LIKE LOWER(?)' => "%$o{hostname}%") : (), - $o{gametype} ? ('LOWER(gametype) LIKE LOWER(?)' => $o{gametype}) : (), + $o{gametype} ? ('LOWER(gametype) LIKE LOWER(?)' => "%$o{gametype}%") : (), $o{mapname} ? ('(LOWER(mapname) LIKE LOWER(?) OR LOWER(maptitle) LIKE LOWER(?))' => ["%$o{mapname}%", "%$o{mapname}%"]) : (), $o{country} ? ('country LIKE UPPER(?)' => $o{country}) : (), |