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.

1 files changed, 7 insertions, 1 deletions

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;