From 4103fb8869e1b907c6fea72e5d8d1396b33ece74 Mon Sep 17 00:00:00 2001 From: Banana Date: Fri, 9 Jul 2021 11:16:33 +0200 Subject: [PATCH] some fixes --- TODO | 1 + documentation/tool-imdbweb.txt | 1 + documentation/tool-musicbrainz.txt | 8 +++++--- upgrade/from-version-1.1.txt | 12 ++++++++++-- webclient/config/config-musicbrainz.php.default | 2 ++ 5 files changed, 19 insertions(+), 5 deletions(-) diff --git a/TODO b/TODO index 24044d6..c62d857 100644 --- a/TODO +++ b/TODO @@ -1,5 +1,6 @@ * User friendly setup * stats overview page. amount of entries. file / cache and db storage. Version info and where to find it. +* Definition of fields in "card view" * User and groupmanagement: Check where a user or group is used! * Better error handling and display while adding / update and delete * Export of an entry, collection or everything. Stored on disk. diff --git a/documentation/tool-imdbweb.txt b/documentation/tool-imdbweb.txt index 9ca69ae..c33acdf 100644 --- a/documentation/tool-imdbweb.txt +++ b/documentation/tool-imdbweb.txt @@ -18,3 +18,4 @@ in the config file. # Setup Rename the config-imdbweb.php.default to config-imdbweb.php in the config folder. Follow the comments to update the settings. +Add the tool to your music collection diff --git a/documentation/tool-musicbrainz.txt b/documentation/tool-musicbrainz.txt index d858513..d993fd0 100644 --- a/documentation/tool-musicbrainz.txt +++ b/documentation/tool-musicbrainz.txt @@ -1,6 +1,4 @@ -Musicbrainz release information grabber - -Creating a new entry with the selected fields or updating an existing one. +Musicbrainz music release information grabber Based on https://musicbrainz.org/doc/Development @@ -9,9 +7,13 @@ https://musicbrainz.org/doc/MusicBrainz_API/Search https://musicbrainz.org/doc/MusicBrainz_API the grabber provides a simple search for artist and release (album). +# Usage +Creating a new entry with the selected fields or updating an existing one. + An option to make the target fields automatically selected by default to given values is also available in the config file. # Setup Rename the config-musicbrainz.php.default to config-musicbrainz.php in the config folder. Follow the comments to update the settings. +Add the tool to your music collection diff --git a/upgrade/from-version-1.1.txt b/upgrade/from-version-1.1.txt index baa84bf..b7dd946 100644 --- a/upgrade/from-version-1.1.txt +++ b/upgrade/from-version-1.1.txt @@ -1,5 +1,13 @@ # DB changes. Run each line against your bibliotheca DB. # Replace #REPLACEME# with your table prefix. Default is bib INSERT INTO `#REPLACEME#_tool` (`id`, `name`, `description`, `action`, `target`, `owner`, `group`, `rights`) VALUES (NULL, 'Musicbrainz', 'Album infos', 'musicbrainz', '_self', '1', '1', 'rw-r--r--'); -INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modified`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'artist', 'Artist', 'text', 'entrySingleText', '`artists` varchar(128) NULL DEFAULT NULL', '', NULL, 'string 128', NOW(), NOW(), NULL, '1', '1', 'rw-r--r--'); -UPDATE `#REPLACEME#_sys_fields` SET `type` = 'year' WHERE `bib_sys_fields`.`id` = 14; +INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modified`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'artist', 'Artist', 'text', 'entrySingleText', '`artist` varchar(128) NULL DEFAULT NULL', '', NULL, 'string 128', NOW(), NOW(), NULL, '1', '1', 'rw-r--r--'); +UPDATE `#REPLACEME#_sys_fields` SET `type` = 'year' WHERE `identifier` = 'year'; +UPDATE `#REPLACEME#_sys_fields` SET `createstring` = '`localizedTitle` varchar(128) NULL DEFAULT NULL, ADD FULLTEXT (`localizedTitle`)' WHERE `identifier` = 'localizedTitle'; + +# if you have the field "localizedTitle" already in use and get an error about it, run the following statement. +# Replace to match the correct collection +ALTER TABLE `#REPLACEME#_collection_entry_1` CHANGE `localizedTitle` `localizedTitle` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; + +# New tool for grabbing information from Musicbrainz available +To use it, read tool-musicbrainz.txt in the documentation folder. diff --git a/webclient/config/config-musicbrainz.php.default b/webclient/config/config-musicbrainz.php.default index 6b39797..eea23be 100644 --- a/webclient/config/config-musicbrainz.php.default +++ b/webclient/config/config-musicbrainz.php.default @@ -36,9 +36,11 @@ define('TOOL_BRAINZ_BROWSER_ACCEPT_LANG','en-US,en;q=0.5'); define('TOOL_BRAINZ_RESULT_LIMIT',10); +/* define('TOOL_BRAINZ_FIELDS_TO', array( 'album' => 'title','date' => 'year', 'artist' => 'artist', 'image' => 'coverimage', 'tracks' => 'content', 'runtime' => 'runtime' ) ); +*/ -- 2.39.5