From b762a0df6b6b62fc175583028c9dac608b89cc6d Mon Sep 17 00:00:00 2001 From: Banana Date: Mon, 26 Apr 2021 00:00:03 +0200 Subject: [PATCH] improived game collection. Display of text fields. Added game info tool --- CHANGELOG | 2 ++ TODO | 2 ++ documentation/tools.txt | 2 +- upgrade/from-version-1.0.txt | 4 ++++ webclient/view/default/entry/field-text.html | 2 +- webclient/view/default/entry/field-text3.html | 2 +- .../view/default/tool/tool-gameinfo.html | 8 +++++++ webclient/view/default/tool/tool-gameinfo.php | 22 +++++++++++++++++++ 8 files changed, 41 insertions(+), 3 deletions(-) create mode 100644 webclient/view/default/tool/tool-gameinfo.html create mode 100644 webclient/view/default/tool/tool-gameinfo.php diff --git a/CHANGELOG b/CHANGELOG index b6b232e..034cf14 100644 --- a/CHANGELOG +++ b/CHANGELOG @@ -34,6 +34,8 @@ * Indication wich inputs are required * Added a new field: Localized title * After adding an entry the option to view or edit the entry is now available + * Added game info tool. + * Added new fields for a game collection 1.0 - Castle 20210106 * First usable version diff --git a/TODO b/TODO index 3720f2c..b3ff757 100644 --- a/TODO +++ b/TODO @@ -1,3 +1,5 @@ +* input length check and display + * stats overview page. amount of entries. file / cache and db storage. Version info and where to find it. * User and groupmanagement: Check where a user or group is used! * Better error handling and display while adding / update and delete diff --git a/documentation/tools.txt b/documentation/tools.txt index 8513379..2e943f8 100644 --- a/documentation/tools.txt +++ b/documentation/tools.txt @@ -2,7 +2,7 @@ Each collection can have additional tools. The availability is configured in col A tool needs an DB entry in _tool and matching files in view/THEME/tool/. Filenames are tool-ACTION.html|php -A option configuration file config/config-ACTION.php +A optional configuration file config/config-ACTION.php A documentation is a must. As a base the provided imdbweb parse is already included. It makes it possible to search for a movie within diff --git a/upgrade/from-version-1.0.txt b/upgrade/from-version-1.0.txt index b94f1c6..bcf9d0c 100644 --- a/upgrade/from-version-1.0.txt +++ b/upgrade/from-version-1.0.txt @@ -35,6 +35,10 @@ UPDATE `#REPLACEME#_sys_fields` SET `inputValidation` = 'allowSpace' WHERE `bib_ ALTER TABLE `#REPLACEME#_collection` ADD `advancedSearchTableFields` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `defaultSortField`; ALTER TABLE `#REPLACEME#_sys_fields` ADD UNIQUE (`identifier`); INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'localizedTitle', 'localized Title', 'text', 'entryText', '`localizedTitle` varchar(128) NOT NULL, ADD FULLTEXT (`localizedTitle`)', '', NULL, 'string 128', NOW(), '0', '1', '1', 'rw-r--r--'); +INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'gameEngine', 'Game Engine', 'text', 'entryText', '`gameEngine` varchar(128) NOT NULL, ADD FULLTEXT (`gameEngine`)', '', NULL, 'string 128', NOW(), '0', '1', '1', 'rw-r--r--'); +INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'view', 'View', 'selection', 'entrySingleNum', '`view` varchar(32) NULL DEFAULT NULL', '', 'First person,Third person,Top-down', 'First person,Third person,Top-down', NOW(), '0', '1', '1', 'rw-r--r--') +INSERT INTO `#REPLACEME#_sys_fields` (`id`, `identifier`, `displayname`, `type`, `searchtype`, `createstring`, `inputValidation`, `value`, `apiinfo`, `created`, `modificationuser`, `owner`, `group`, `rights`) VALUES (NULL, 'sysReq', 'System Requirements', 'text3', 'entryText', '`sysReq` varchar(255) NULL DEFAULT NULL, ADD FULLTEXT (`sysReq`)', '', NULL, 'string 255', NOW(), '0', '1', '1', 'rw-r--r--'); +INSERT INTO `#REPLACEME#_tool` (`id`, `name`, `description`, `action`, `target`, `owner`, `group`, `rights`) VALUES (NULL, 'Game infos', 'Game infos', 'gameinfo', '_self', '1', '1', 'rw-r--r--'); # 6 Update your collection settings. There are new options which should be set. diff --git a/webclient/view/default/entry/field-text.html b/webclient/view/default/entry/field-text.html index 9f76b0e..9469378 100644 --- a/webclient/view/default/entry/field-text.html +++ b/webclient/view/default/entry/field-text.html @@ -1 +1 @@ -

:

+

:

diff --git a/webclient/view/default/entry/field-text3.html b/webclient/view/default/entry/field-text3.html index c663afb..b8412e7 100644 --- a/webclient/view/default/entry/field-text3.html +++ b/webclient/view/default/entry/field-text3.html @@ -1 +1 @@ -

:

+

:

diff --git a/webclient/view/default/tool/tool-gameinfo.html b/webclient/view/default/tool/tool-gameinfo.html new file mode 100644 index 0000000..fc9e7b2 --- /dev/null +++ b/webclient/view/default/tool/tool-gameinfo.html @@ -0,0 +1,8 @@ +

This is a collection of websites which provide different kind of information about games.

+ diff --git a/webclient/view/default/tool/tool-gameinfo.php b/webclient/view/default/tool/tool-gameinfo.php new file mode 100644 index 0000000..3cf0747 --- /dev/null +++ b/webclient/view/default/tool/tool-gameinfo.php @@ -0,0 +1,22 @@ +