sheet.git
3 years agosource: allow external website inclusion of json
Mischa POSLAWSKY [Mon, 17 Aug 2020 16:40:04 +0000 (18:40 +0200)]
source: allow external website inclusion of json

Header to permit data being used in modern browsers.

3 years agosource: keep original file encoding
Mischa POSLAWSKY [Sun, 30 Aug 2020 12:35:52 +0000 (14:35 +0200)]
source: keep original file encoding

Keep original utf8 as binary to prevent reconversion.

3 years agoword: database module to connect to postgres
Mischa POSLAWSKY [Sat, 20 Jun 2020 15:18:46 +0000 (17:18 +0200)]
word: database module to connect to postgres

Single configuration of authorisation details.

3 years agoword: quiz mode omitting titles in random order
Mischa POSLAWSKY [Wed, 17 Jun 2020 22:40:20 +0000 (00:40 +0200)]
word: quiz mode omitting titles in random order

3 years agoword: reduce size of parenthesised form part
Mischa POSLAWSKY [Wed, 17 Jun 2020 22:24:42 +0000 (00:24 +0200)]
word: reduce size of parenthesised form part

Syntax for optional elongation as in "rhino(ceros)" or "chimp(anzee)".

3 years agoword: identify thumbnail image files by id
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:51:35 +0000 (00:51 +0200)]
word: identify thumbnail image files by id

3 years agoword: identify rows by id number
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:34:40 +0000 (00:34 +0200)]
word: identify rows by id number

With the addition of more entries, names are no longer unique:
for example pink (colour and flower) in multiple categories.

3 years agoword edit: separate stylesheet for form styling
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:05:38 +0000 (00:05 +0200)]
word edit: separate stylesheet for form styling

3 years agoword edit: null priority to inherit from parent
Mischa POSLAWSKY [Mon, 15 Jun 2020 21:55:13 +0000 (23:55 +0200)]
word edit: null priority to inherit from parent

3 years agoword edit: image source precede thumbnail convert options
Mischa POSLAWSKY [Mon, 15 Jun 2020 21:18:00 +0000 (23:18 +0200)]
word edit: image source precede thumbnail convert options

Required for combining operations such as -clut; same results otherwise.

3 years agoword: sitewide styling of images gallery
Mischa POSLAWSKY [Sun, 14 Jun 2020 12:05:25 +0000 (14:05 +0200)]
word: sitewide styling of images gallery

Move page styling to base stylesheet with gallery class.

3 years agoword edit: preserve wikipedia links in translation suggestions
Mischa POSLAWSKY [Sat, 13 Jun 2020 17:26:27 +0000 (19:26 +0200)]
word edit: preserve wikipedia links in translation suggestions

3 years agoword edit: present login form on unauthorised request
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:39:46 +0000 (16:39 +0200)]
word edit: present login form on unauthorised request

User-friendly creation of access cookies.

3 years agoword edit: omit empty translation options
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:32:47 +0000 (16:32 +0200)]
word edit: omit empty translation options

3 years agoword edit: user editlang enables language inputs
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:12:09 +0000 (16:12 +0200)]
word edit: user editlang enables language inputs

3 years agoword edit: record entry creator and modification time
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:10:53 +0000 (16:10 +0200)]
word edit: record entry creator and modification time

3 years agoword edit: restrict access by login cookie
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:43:43 +0000 (13:43 +0200)]
word edit: restrict access by login cookie

3 years agoword edit: js appends more multiinput columns
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:32:25 +0000 (16:32 +0200)]
word edit: js appends more multiinput columns

Enter multiple option without requiring intermedia saves.

3 years agoword edit: multiinput styling for configured columns
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:02:38 +0000 (13:02 +0200)]
word edit: multiinput styling for configured columns

3 years agoword edit: convert posted input to unicode
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:00:35 +0000 (13:00 +0200)]
word edit: convert posted input to unicode

3 years agoword: fit column(s) on smaller screen sizes
Mischa POSLAWSKY [Sat, 13 Jun 2020 08:42:41 +0000 (10:42 +0200)]
word: fit column(s) on smaller screen sizes

Minimise page margins to fit common (phone) viewport of 412px,
otherwise no columns to prevent decreased width and padding.

3 years agoword edit: inline style for multiple consecutive inputs
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:41:18 +0000 (09:41 +0200)]
word edit: inline style for multiple consecutive inputs

3 years agoword edit: sql array values in multiple input fields
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:29:03 +0000 (09:29 +0200)]
word edit: sql array values in multiple input fields

3 years agoword edit: -area option crops thumbnails with relative offsets
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:27:21 +0000 (09:27 +0200)]
word edit: -area option crops thumbnails with relative offsets

Preferred viewport configuration replacing unmaintainable combinations of
-crop, -chop, -shave, &al.

3 years agoword edit: hashes for all column definitions
Mischa POSLAWSKY [Sun, 7 Jun 2020 12:18:44 +0000 (14:18 +0200)]
word edit: hashes for all column definitions

Silence warnings during subcolumn handling.

3 years agoword edit: copy translations from wikipedia download
Mischa POSLAWSKY [Sun, 7 Jun 2020 12:17:08 +0000 (14:17 +0200)]
word edit: copy translations from wikipedia download

3 years agocommon: fix double html headers on plp errors
Mischa POSLAWSKY [Sat, 29 Aug 2020 16:29:22 +0000 (18:29 +0200)]
common: fix double html headers on plp errors

The exception added in commit v1.9-254-g560ad76852 (2017-05-29)
[common: html page headers on plp errors] seems unneeded (now?);
maybe for different server/version/environment setup?

3 years agocommon: enable perl stricture and fix resulting errors
Mischa POSLAWSKY [Sat, 6 Jun 2020 02:26:59 +0000 (04:26 +0200)]
common: enable perl stricture and fix resulting errors

3 years agoword edit: delete empty entries if confirmed
Mischa POSLAWSKY [Sun, 31 May 2020 03:37:46 +0000 (05:37 +0200)]
word edit: delete empty entries if confirmed

3 years agoword: two-letter language codes
Mischa POSLAWSKY [Sun, 31 May 2020 03:37:02 +0000 (05:37 +0200)]
word: two-letter language codes

Match Wikipedia subdomains and common browser headers.

3 years agoword: debugging stylesheet to colourise levels
Mischa POSLAWSKY [Fri, 29 May 2020 02:07:26 +0000 (04:07 +0200)]
word: debugging stylesheet to colourise levels

3 years agoword edit: visit button to open linked wikipedia page
Mischa POSLAWSKY [Sat, 30 May 2020 22:22:44 +0000 (00:22 +0200)]
word edit: visit button to open linked wikipedia page

3 years agoword edit: translation entry in referrer form
Mischa POSLAWSKY [Sat, 30 May 2020 22:21:42 +0000 (00:21 +0200)]
word edit: translation entry in referrer form

3 years agoword edit: flags in language selection
Mischa POSLAWSKY [Sat, 30 May 2020 20:30:57 +0000 (22:30 +0200)]
word edit: flags in language selection

3 years agoword edit: columns declare nested suboptions
Mischa POSLAWSKY [Sat, 30 May 2020 18:51:20 +0000 (20:51 +0200)]
word edit: columns declare nested suboptions

3 years agoword edit: named form input options
Mischa POSLAWSKY [Sat, 30 May 2020 16:59:21 +0000 (18:59 +0200)]
word edit: named form input options

Parameters replaced by prefixed -label and -option;
other attributes are appended literally.

3 years agoword edit: common method to determine image paths
Mischa POSLAWSKY [Sat, 30 May 2020 16:45:52 +0000 (18:45 +0200)]
word edit: common method to determine image paths

3 years agoword edit: common function to format form input
Mischa POSLAWSKY [Sat, 30 May 2020 07:02:32 +0000 (09:02 +0200)]
word edit: common function to format form input

3 years agoword edit: enlarge and align columns, thumbnail
Mischa POSLAWSKY [Sat, 30 May 2020 06:30:56 +0000 (08:30 +0200)]
word edit: enlarge and align columns, thumbnail

3 years agoword edit: list and link translation references
Mischa POSLAWSKY [Sat, 30 May 2020 06:29:30 +0000 (08:29 +0200)]
word edit: list and link translation references

3 years agoword: order siblings by grade
Mischa POSLAWSKY [Sat, 30 May 2020 06:27:30 +0000 (08:27 +0200)]
word: order siblings by grade

Optional precedence before alphabetical neutral.

3 years agoword: restrict by priority level
Mischa POSLAWSKY [Fri, 29 May 2020 05:14:37 +0000 (07:14 +0200)]
word: restrict by priority level

Default to commonly known concepts (level 3) unless overridden by ?v.

3 years agoword edit: group reference input with category
Mischa POSLAWSKY [Fri, 29 May 2020 05:12:47 +0000 (07:12 +0200)]
word edit: group reference input with category

3 years agoword edit: hide original image until requested
Mischa POSLAWSKY [Fri, 29 May 2020 05:10:27 +0000 (07:10 +0200)]
word edit: hide original image until requested

3 years agoword edit: separate javascript include
Mischa POSLAWSKY [Fri, 29 May 2020 05:08:12 +0000 (07:08 +0200)]
word edit: separate javascript include

3 years agoword edit: cover option changes thumbnail
Mischa POSLAWSKY [Wed, 27 May 2020 22:51:55 +0000 (00:51 +0200)]
word edit: cover option changes thumbnail

3 years agoword edit: capture image convert error messages
Mischa POSLAWSKY [Wed, 27 May 2020 17:48:12 +0000 (19:48 +0200)]
word edit: capture image convert error messages

3 years agoword: enlarge marked cover images
Mischa POSLAWSKY [Wed, 27 May 2020 16:44:47 +0000 (18:44 +0200)]
word: enlarge marked cover images

3 years agoword: grid layout to strictly align multiple rows
Mischa POSLAWSKY [Tue, 26 May 2020 09:16:51 +0000 (11:16 +0200)]
word: grid layout to strictly align multiple rows

3 years agoword: distinguish include and images by language
Mischa POSLAWSKY [Tue, 26 May 2020 07:27:17 +0000 (09:27 +0200)]
word: distinguish include and images by language

Prepare for translations with different visualisations.

3 years agoword edit: dynamically aligned form styling (emulate table)
Mischa POSLAWSKY [Tue, 26 May 2020 07:24:43 +0000 (09:24 +0200)]
word edit: dynamically aligned form styling (emulate table)

3 years agoword edit: language input as wikipedia domain
Mischa POSLAWSKY [Mon, 25 May 2020 14:03:38 +0000 (16:03 +0200)]
word edit: language input as wikipedia domain

3 years agoword: form synonyms from alt column
Mischa POSLAWSKY [Thu, 28 May 2020 04:51:01 +0000 (06:51 +0200)]
word: form synonyms from alt column

Support any number of alternatives (for now all shown in small font).

3 years agoword: select mkwordlist forms from _cat_words view
Mischa POSLAWSKY [Mon, 25 May 2020 03:24:51 +0000 (05:24 +0200)]
word: select mkwordlist forms from _cat_words view

3 years agoword edit: prio(rity level) column input
Mischa POSLAWSKY [Mon, 25 May 2020 03:23:02 +0000 (05:23 +0200)]
word edit: prio(rity level) column input

3 years agoword edit: recover form after save error
Mischa POSLAWSKY [Mon, 25 May 2020 03:22:47 +0000 (05:22 +0200)]
word edit: recover form after save error

3 years agoword edit: replace altered source images
Mischa POSLAWSKY [Sun, 24 May 2020 20:33:20 +0000 (22:33 +0200)]
word edit: replace altered source images

3 years agoword edit: hierarchy navigation (parent and children)
Mischa POSLAWSKY [Sun, 24 May 2020 19:48:13 +0000 (21:48 +0200)]
word edit: hierarchy navigation (parent and children)

3 years agoword edit: select wikipedia images from overlay
Mischa POSLAWSKY [Sun, 24 May 2020 08:17:43 +0000 (10:17 +0200)]
word edit: select wikipedia images from overlay

3 years agoword edit: wikipedia copy button
Mischa POSLAWSKY [Sun, 24 May 2020 07:22:56 +0000 (09:22 +0200)]
word edit: wikipedia copy button

Automatically find a matching title and return the first image from article
contents.

3 years agoword edit: copycat button to save and start a similar entry
Mischa POSLAWSKY [Sun, 24 May 2020 04:15:57 +0000 (06:15 +0200)]
word edit: copycat button to save and start a similar entry

Option to retain language and category.

3 years agoword edit: download images from url input
Mischa POSLAWSKY [Sun, 24 May 2020 01:54:24 +0000 (03:54 +0200)]
word edit: download images from url input

3 years agoword edit: form stylesheet for aligned input fields
Mischa POSLAWSKY [Sun, 24 May 2020 01:58:41 +0000 (03:58 +0200)]
word edit: form stylesheet for aligned input fields

3 years agoword edit: fix image convert arrays
Mischa POSLAWSKY [Sun, 24 May 2020 04:16:28 +0000 (06:16 +0200)]
word edit: fix image convert arrays

3 years agoword: writer page to edit database entries
Mischa POSLAWSKY [Sun, 24 May 2020 01:49:31 +0000 (03:49 +0200)]
word: writer page to edit database entries

Initial form to maintain a larger amount of words.

3 years agoword: maintain wordlist in postgres database
Mischa POSLAWSKY [Mon, 25 May 2020 03:25:31 +0000 (05:25 +0200)]
word: maintain wordlist in postgres database

A static perl file is insufficient considering future plans.
Start tracking names and image sources for possible collaboration;
the same include syntax is generated from that.

3 years agoword: mkimg-google from duckduckgo
Mischa POSLAWSKY [Sat, 23 May 2020 03:15:24 +0000 (05:15 +0200)]
word: mkimg-google from duckduckgo

Alternate search engine to maybe find better (maybe more free?) images.

3 years agoword: mkimg-google tool to download images
Mischa POSLAWSKY [Sat, 23 May 2020 03:06:00 +0000 (05:06 +0200)]
word: mkimg-google tool to download images

Automatic population with top results searching each term:

perl -E 'sub flat {map { ref ? flat(@$_) : $_ } @_}
say for flat do "./wordlist.inc.pl"'

Good for testing; definitely requires further moderation to release:
avoiding false friends (e.g. mug commonly isn't a midge), finding better
representations, and at least nicely cropping to aspect ratio.

3 years agoword: hover related parents and children
Mischa POSLAWSKY [Sat, 23 May 2020 03:03:01 +0000 (05:03 +0200)]
word: hover related parents and children

3 years agoword: organism gallery (categorised grid layout)
Mischa POSLAWSKY [Sat, 23 May 2020 02:02:42 +0000 (04:02 +0200)]
word: organism gallery (categorised grid layout)

Expansion of dieren page starting a more complete collection of terms.
Populated by most common animals and plants based on DK visual dictionaries.

3 years agodieren: image figures captioned by names v1.12
Mischa POSLAWSKY [Mon, 4 May 2020 21:01:22 +0000 (23:01 +0200)]
dieren: image figures captioned by names

3 years agodieren: various animal improvements and additions
Mischa POSLAWSKY [Mon, 4 May 2020 20:07:47 +0000 (22:07 +0200)]
dieren: various animal improvements and additions

3 years agodieren: reindent table data to align column names
Mischa POSLAWSKY [Mon, 4 May 2020 18:59:09 +0000 (20:59 +0200)]
dieren: reindent table data to align column names

3 years agodieren: subpage names to indicate verbosity
Mischa POSLAWSKY [Sat, 2 May 2020 23:22:00 +0000 (01:22 +0200)]
dieren: subpage names to indicate verbosity

3 years agodieren: additional words, underscore replaced by space
Mischa POSLAWSKY [Sat, 2 May 2020 22:21:50 +0000 (00:21 +0200)]
dieren: additional words, underscore replaced by space

3 years agodieren: mkimgthumb escape to support colons in parameters
Mischa POSLAWSKY [Sat, 2 May 2020 23:22:11 +0000 (01:22 +0200)]
dieren: mkimgthumb escape to support colons in parameters

Backslash to allow the occasional `-define modulate:colorspace=HSB`
as :-define:module\:colorspace=HSB.

3 years agodieren: mkimgthumb number suffix as crop shorthand
Mischa POSLAWSKY [Sat, 2 May 2020 22:22:01 +0000 (00:22 +0200)]
dieren: mkimgthumb number suffix as crop shorthand

Simplifies vleerhond:-crop:70%x0:-chop:20%x30% to vleerhond:12x30x30x0
and many more.

3 years agodieren: mkimgthumb test option to override parameters
Mischa POSLAWSKY [Sat, 2 May 2020 22:19:30 +0000 (00:19 +0200)]
dieren: mkimgthumb test option to override parameters

Find files regardless of given :* suffixes, so commands can be executed
without having to rename.

3 years agodieren: relay errors during image conversion
Mischa POSLAWSKY [Sat, 2 May 2020 16:43:45 +0000 (18:43 +0200)]
dieren: relay errors during image conversion

3 years agodieren: mkimgthumb script to resize images
Mischa POSLAWSKY [Tue, 12 Nov 2019 20:52:19 +0000 (21:52 +0100)]
dieren: mkimgthumb script to resize images

Replaces a previously untracked set of convert rules such as:

waterleeuw => '-shave:5%x12%:-chop:20%x0:-flop:-gamma:.8',

to postprocess various images, storing this metadata in their file names
instead renaming the original waterleeuw.jpg to:

waterleeuw:-shave:5%x12%:-chop:20%x0:-flop:-gamma:.8.jpg

3 years agodieren: page description and links between verbosity
Mischa POSLAWSKY [Thu, 30 Apr 2020 22:14:55 +0000 (00:14 +0200)]
dieren: page description and links between verbosity

3 years agodieren: empty cells to fill missing columns
Mischa POSLAWSKY [Thu, 30 Apr 2020 21:31:39 +0000 (23:31 +0200)]
dieren: empty cells to fill missing columns

3 years agotermcol: compile.png as default comparison image
Mischa POSLAWSKY [Thu, 2 Apr 2020 00:38:05 +0000 (02:38 +0200)]
termcol: compile.png as default comparison image

Made a compilation of various screenshots instead of a specific game.

3 years agotermcol: falcon terminal colour scheme
Mischa POSLAWSKY [Thu, 2 Apr 2020 00:36:18 +0000 (02:36 +0200)]
termcol: falcon terminal colour scheme

3 years agotermcol: legacy palettes jw64 and simplejpc
Mischa POSLAWSKY [Thu, 6 Jun 2019 12:27:17 +0000 (14:27 +0200)]
termcol: legacy palettes jw64 and simplejpc

3 years agodieren: various additional combinations and *mot row
Mischa POSLAWSKY [Thu, 30 Apr 2020 21:14:19 +0000 (23:14 +0200)]
dieren: various additional combinations and *mot row

3 years agodieren: proposed ideas for *pad, *bij
Mischa POSLAWSKY [Sat, 29 Feb 2020 18:44:34 +0000 (19:44 +0100)]
dieren: proposed ideas for *pad, *bij

3 years agodieren: prefer waterspitsmuis, koedoe, zeehoorn
Mischa POSLAWSKY [Fri, 29 Nov 2019 20:00:02 +0000 (21:00 +0100)]
dieren: prefer waterspitsmuis, koedoe, zeehoorn

3 years agodieren: rotate table on ?r parameter
Mischa POSLAWSKY [Sat, 23 Nov 2019 15:28:03 +0000 (16:28 +0100)]
dieren: rotate table on ?r parameter

3 years agodieren: prefix to indicate verbose additions
Mischa POSLAWSKY [Sat, 23 Nov 2019 15:22:58 +0000 (16:22 +0100)]
dieren: prefix to indicate verbose additions

3 years agodieren: proposed additions on ?v parameter
Mischa POSLAWSKY [Sat, 23 Nov 2019 15:11:26 +0000 (16:11 +0100)]
dieren: proposed additions on ?v parameter

3 years agodieren: hidden images as easter eggs
Mischa POSLAWSKY [Sat, 23 Nov 2019 15:06:41 +0000 (16:06 +0100)]
dieren: hidden images as easter eggs

3 years agodieren: full width table, image styling and alt
Mischa POSLAWSKY [Sat, 23 Nov 2019 15:05:32 +0000 (16:05 +0100)]
dieren: full width table, image styling and alt

3 years agodieren: research similar dutch animal nouns
Mischa POSLAWSKY [Sun, 17 Nov 2019 16:14:22 +0000 (17:14 +0100)]
dieren: research similar dutch animal nouns

No comprehensive lists to be found online, so made a table of popular
animals and prefixes, and searched for pictures in similar poses.

4 years agoperl: summarise releases of v5.30 and v5.32
Mischa POSLAWSKY [Wed, 5 Feb 2020 16:35:19 +0000 (17:35 +0100)]
perl: summarise releases of v5.30 and v5.32

4 years agocharset: subpages support alternate stylesheets
Mischa POSLAWSKY [Tue, 11 Jun 2019 15:54:02 +0000 (17:54 +0200)]
charset: subpages support alternate stylesheets

Restriction to light is only needed for character property styling on
overview (and some unlinked requests which can be fixed/optimised later).

4 years agocountries: fix table class for reserved cells
Mischa POSLAWSKY [Fri, 6 Sep 2019 17:26:20 +0000 (19:26 +0200)]
countries: fix table class for reserved cells

Accidental rename in v1.2-87-g0ec1918e9e (2009-10-13) [names by default].

4 years agocli: mkclioptions tool to parse help output of given commands
Mischa POSLAWSKY [Fri, 6 Sep 2019 18:57:42 +0000 (20:57 +0200)]
cli: mkclioptions tool to parse help output of given commands

Initial automation of getting available options from basic GNU programs.

4 years agovi: minor corrections for gx/do/dp properties
Mischa POSLAWSKY [Wed, 3 Jul 2019 12:49:34 +0000 (14:49 +0200)]
vi: minor corrections for gx/do/dp properties

4 years agovi: delete mode (motions and specific commands)
Mischa POSLAWSKY [Mon, 1 Jul 2019 15:22:30 +0000 (17:22 +0200)]
vi: delete mode (motions and specific commands)