From 6bd235f3e62251d8763a552ab0042d59584de842 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sat, 8 Mar 2025 15:56:30 +0100 Subject: 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. --- lib/MasterWebInterface/Database/Games.pm | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'lib/MasterWebInterface/Database/Games.pm') diff --git a/lib/MasterWebInterface/Database/Games.pm b/lib/MasterWebInterface/Database/Games.pm index 02b6ad9..c9dab95 100755 --- a/lib/MasterWebInterface/Database/Games.pm +++ b/lib/MasterWebInterface/Database/Games.pm @@ -18,6 +18,12 @@ sub dbGameListGet # search criteria my %where = ( $o{search} ? ('lower(label) LIKE lower(?)' => "%$o{search}%") : (), + $o{search} ? ('lower(label) LIKE lower(?) OR lower(gamename) LIKE lower(?)' => ["%$o{search}%","%$o{search}%"]) : (), + + + #$o{search} ? ('LOWER(hostname) LIKE LOWER(?) OR LOWER(maptitle) LIKE LOWER(?) OR LOWER(mapname) LIKE LOWER(?)' => ["%$o{search}%", "%$o{search}%", "%$o{search}%"]) : (), + + !$o{all} ? ( 'num_total > ?' => 0) : (), ); @@ -55,7 +61,7 @@ sub dbGameListGet sub dbGetGameDesc { my ($self, $gn) = @_; - return $self->dbAll("SELECT label FROM gameinfo WHERE gamename = ?", $gn)->[0]{label}; + return $self->dbAll("SELECT label FROM gameinfo WHERE gamename = ? LIMIT 1", $gn)->[0]{label}; } 1; -- cgit v1.2.3