Mischa POSLAWSKY [Fri, 15 Oct 2021 10:46:11 +0000 (12:46 +0200)]
htaccess: prevent directory indexes in case of mod_autoindex
Disabled on the current server, but probably installed by default.
Mischa POSLAWSKY [Fri, 15 Oct 2021 10:42:28 +0000 (12:42 +0200)]
word/edit: replace hardcoded urls to the current page
Mischa POSLAWSKY [Thu, 14 Oct 2021 16:45:19 +0000 (18:45 +0200)]
word: workaround unicode breakage in edit subpage
Prevent some perl/PLP quirkiness with encoded scalars.
Mischa POSLAWSKY [Fri, 15 Oct 2021 10:37:55 +0000 (12:37 +0200)]
word: move subpages and includes to word/ directory
Mischa POSLAWSKY [Thu, 14 Oct 2021 16:50:15 +0000 (18:50 +0200)]
word: prefer reference image id in exportform rows
Mischa POSLAWSKY [Fri, 20 Aug 2021 13:50:19 +0000 (15:50 +0200)]
countries: ?v script to compare unicode flags
Mischa POSLAWSKY [Wed, 21 Feb 2018 08:56:40 +0000 (09:56 +0100)]
keys: experiment to omit keyless rows
Mischa POSLAWSKY [Wed, 8 Sep 2021 12:37:29 +0000 (14:37 +0200)]
keys: wide padded key style on windows >1440x996 px
Same size at 90% zoom but less cramped.
Mischa POSLAWSKY [Tue, 24 Aug 2021 15:10:11 +0000 (17:10 +0200)]
word/edit: ignore failed binomial match
Mischa POSLAWSKY [Tue, 31 Aug 2021 23:20:48 +0000 (01:20 +0200)]
word/edit: image metadata in combined json column
Convert existing columns to a freely extensible postgres object:
UPDATE word SET image = json_strip_nulls(json_build_object(
'source', source, 'convert', thumb, 'aspect', 1.5
)) WHERE source IS NOT NULL;
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:11:28 +0000 (04:11 +0200)]
word: mkwordthumb script to recreate images
Mischa POSLAWSKY [Wed, 25 Aug 2021 21:22:13 +0000 (23:22 +0200)]
word: kind table to link optional categories
Allow for some kind of 20 Questions and other tagging.
The hard part will be filling and utilising it properly.
Mischa POSLAWSKY [Wed, 25 Aug 2021 00:46:51 +0000 (02:46 +0200)]
word: more (long term) ideas
Mischa POSLAWSKY [Wed, 25 Aug 2021 04:57:01 +0000 (06:57 +0200)]
latin: hardcoded tetromino block cascades
Attempt to move combinations together if possible,
applying expected gravity to tetris pieces.
Mischa POSLAWSKY [Wed, 25 Aug 2021 04:55:35 +0000 (06:55 +0200)]
latin: chromacons sample on white background
Distinguish spaces in dark style, similar to cmymap.
Mischa POSLAWSKY [Wed, 25 Aug 2021 04:54:54 +0000 (06:54 +0200)]
latin: omit span container on sample svg
Mischa POSLAWSKY [Wed, 25 Aug 2021 04:52:37 +0000 (06:52 +0200)]
latin: assign polyomino shapes (tetris pieces)
System to encode messages in tetris drops, mapping 19 fixed tetrominoes
<https://en.wikipedia.org/wiki/Tetromino?oldid=
1032015917> to corresponding
letters for unrotated shapes I O T L S Z, rotating to match similar
appearances for A F N P.
To distinguish all 26 letters, include fixed polyominoes with fewer cells
<https://en.wikipedia.org/wiki/Polyomino?oldid=
1037069367> for 28 variants:
trominoes to optionally distinguish longer approximates K>Q, F>V, U>W, H>X,
and shorter I cuts for J and Y (substitutable by full line).
Mischa POSLAWSKY [Wed, 25 Aug 2021 03:54:37 +0000 (05:54 +0200)]
latin: domino tile formatting and encoding
Another efficient set containing (7*8/2=) 28 distinct options as listed on
<https://en.wikipedia.org/wiki/Dominoes?oldid=
1037160475#Tiles_and_suits>,
applied alphabetically in increasing weight.
Could also be used to display existing tap codes in single glyphs, but
probably shouldn't.
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:39:18 +0000 (04:39 +0200)]
word/edit: prefer binomial name as latin translation
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:38:21 +0000 (04:38 +0200)]
word/edit: hide unset story or keep existing
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:33:06 +0000 (04:33 +0200)]
word: ideas for additional game modes
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:32:42 +0000 (04:32 +0200)]
word/edit: experimental thumb crop calculations
Determine dimensions before imagemagick to try out different formulas.
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:31:33 +0000 (04:31 +0200)]
word/edit: precalculate image width and height
Code cleanup.
Mischa POSLAWSKY [Sun, 15 Aug 2021 02:20:44 +0000 (04:20 +0200)]
word/edit: fix thumbnail generation warnings
Mischa POSLAWSKY [Fri, 6 Aug 2021 12:42:33 +0000 (14:42 +0200)]
perl: prevent word wrap in code snippets
Mischa POSLAWSKY [Fri, 6 Aug 2021 13:22:24 +0000 (15:22 +0200)]
perl: summarise v5.34 release
Mischa POSLAWSKY [Sun, 1 Aug 2021 17:35:48 +0000 (19:35 +0200)]
writing: italic U+1032F southern tse derived from s
Mischa POSLAWSKY [Sun, 1 Aug 2021 17:27:03 +0000 (19:27 +0200)]
writing: include rune U+16B9 wynn under column p
Etymologically unrelated but looks close enough.
Mischa POSLAWSKY [Sun, 1 Aug 2021 17:26:05 +0000 (19:26 +0200)]
writing: sogdian and mongolian
Mischa POSLAWSKY [Sun, 1 Aug 2021 16:08:06 +0000 (18:08 +0200)]
writing: egyptian hieroglyphs
Track Phoenician letters back to likely Egyptian prototypes (Unicode v5.2),
copied from <http://kaese.name/Typography/Alphabet_evolution.html>.
Mischa POSLAWSKY [Thu, 22 Jul 2021 16:31:49 +0000 (18:31 +0200)]
word/edit: move code to download and convert images
Generalise into ImagePrep class to allow external (re)setup.
Mischa POSLAWSKY [Thu, 22 Jul 2021 15:56:49 +0000 (17:56 +0200)]
word/edit: move FormRow class into separate file
Mischa POSLAWSKY [Thu, 22 Jul 2021 15:52:52 +0000 (17:52 +0200)]
word/edit: generic column attribute to determine image paths
Replaces overly specific imagepath() method.
Mischa POSLAWSKY [Fri, 9 Jul 2021 22:13:35 +0000 (00:13 +0200)]
word/quiz: poc js asks random images with 4 translations
Mischa POSLAWSKY [Sun, 11 Jul 2021 03:32:51 +0000 (05:32 +0200)]
word/edit: chinese language (and pinyin transliteration)
Propose <pronunciation> syntax to append alternate scripts in multiple
columns.
Mischa POSLAWSKY [Sun, 4 Jul 2021 03:00:33 +0000 (05:00 +0200)]
word/edit: thumbnail image coordinates selector
Enlarge and return the clicked position to help -area entry.
Mischa POSLAWSKY [Tue, 27 Apr 2021 23:12:24 +0000 (01:12 +0200)]
word: allow browser access to json data
Mischa POSLAWSKY [Sat, 3 Jul 2021 00:06:20 +0000 (02:06 +0200)]
font: ignore data sources for coverage rebuild
Assume changes in data/font will refresh the directory mtime, so will
trigger without requiring individual includes which are optional and may not
be able to build (due to broken symlinks or parse errors) which cannot be
resolved. Manual reinitialisation can also be forced by make data/font/all.
Mischa POSLAWSKY [Sat, 3 Jul 2021 00:05:29 +0000 (02:05 +0200)]
tools: limit download make rules to once every 2 hours
Mischa POSLAWSKY [Fri, 2 Jul 2021 19:26:48 +0000 (21:26 +0200)]
word: database update triggers re-make
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:54:43 +0000 (18:54 +0200)]
word/edit: story column to store text descriptions
Copy Wikipedia intros as basic summary, for additional details/flavour
after guessing in future quizzes?
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:54:30 +0000 (18:54 +0200)]
word/edit: subpage alias to writer functionality
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:03:55 +0000 (18:03 +0200)]
word: reorder table columns
Mischa POSLAWSKY [Fri, 2 Jul 2021 15:56:16 +0000 (17:56 +0200)]
word: translations from _word_ref view coalescing parent values
Mischa POSLAWSKY [Tue, 20 Oct 2020 20:45:09 +0000 (22:45 +0200)]
word: option ?lang selects alternate wordlist includes
Mischa POSLAWSKY [Mon, 26 Oct 2020 03:44:28 +0000 (04:44 +0100)]
word: generate wordlist includes of different languages
Mischa POSLAWSKY [Thu, 3 Jun 2021 01:04:19 +0000 (03:04 +0200)]
word: document some ideas for future contents
Start tracking random notes publicly.
Mischa POSLAWSKY [Tue, 16 Mar 2021 03:48:05 +0000 (04:48 +0100)]
perl: v5.32 release and additional features
Mischa POSLAWSKY [Tue, 29 Sep 2020 15:33:54 +0000 (17:33 +0200)]
browser: ignore metadata columns in usage data
Fix inflated total or even code errors due to missing values.
Mischa POSLAWSKY [Tue, 29 Sep 2020 16:04:27 +0000 (18:04 +0200)]
browser: fix regexp for case insensitive search
Ignored when applied to match function, even following a RegExp.
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:24:42 +0000 (00:24 +0200)]
word: validate source values as http urls
Mischa POSLAWSKY [Tue, 20 Oct 2020 20:36:23 +0000 (22:36 +0200)]
word: apply subselection before shuffle
Mischa POSLAWSKY [Fri, 16 Oct 2020 22:33:40 +0000 (00:33 +0200)]
word: make rule to generate perl include
Move to data/ for derived data.
Mischa POSLAWSKY [Fri, 16 Oct 2020 22:25:18 +0000 (00:25 +0200)]
word edit: latin language option for scientific names
Exact identification of life forms by binomial nomenclature, most similar to
latin and represented by a pin.
Mischa POSLAWSKY [Fri, 16 Oct 2020 06:08:18 +0000 (08:08 +0200)]
word edit: translation shorthand slash for alternate names
Mischa POSLAWSKY [Fri, 16 Oct 2020 02:42:24 +0000 (04:42 +0200)]
word edit: apply image gravity for empty conversion array
Centered only for NULL values, not defined ARRAY[].
Mischa POSLAWSKY [Sat, 20 Jun 2020 15:18:53 +0000 (17:18 +0200)]
word edit: unadvertised search option ?q
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.
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.
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.
Mischa POSLAWSKY [Wed, 17 Jun 2020 22:40:20 +0000 (00:40 +0200)]
word: quiz mode omitting titles in random order
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)".
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:51:35 +0000 (00:51 +0200)]
word: identify thumbnail image files by id
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.
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:05:38 +0000 (00:05 +0200)]
word edit: separate stylesheet for form styling
Mischa POSLAWSKY [Mon, 15 Jun 2020 21:55:13 +0000 (23:55 +0200)]
word edit: null priority to inherit from parent
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.
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.
Mischa POSLAWSKY [Sat, 13 Jun 2020 17:26:27 +0000 (19:26 +0200)]
word edit: preserve wikipedia links in translation suggestions
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.
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:32:47 +0000 (16:32 +0200)]
word edit: omit empty translation options
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:12:09 +0000 (16:12 +0200)]
word edit: user editlang enables language inputs
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:10:53 +0000 (16:10 +0200)]
word edit: record entry creator and modification time
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:43:43 +0000 (13:43 +0200)]
word edit: restrict access by login cookie
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.
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:02:38 +0000 (13:02 +0200)]
word edit: multiinput styling for configured columns
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:00:35 +0000 (13:00 +0200)]
word edit: convert posted input to unicode
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.
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:41:18 +0000 (09:41 +0200)]
word edit: inline style for multiple consecutive inputs
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:29:03 +0000 (09:29 +0200)]
word edit: sql array values in multiple input fields
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.
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.
Mischa POSLAWSKY [Sun, 7 Jun 2020 12:17:08 +0000 (14:17 +0200)]
word edit: copy translations from wikipedia download
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?
Mischa POSLAWSKY [Sat, 6 Jun 2020 02:26:59 +0000 (04:26 +0200)]
common: enable perl stricture and fix resulting errors
Mischa POSLAWSKY [Sun, 31 May 2020 03:37:46 +0000 (05:37 +0200)]
word edit: delete empty entries if confirmed
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.
Mischa POSLAWSKY [Fri, 29 May 2020 02:07:26 +0000 (04:07 +0200)]
word: debugging stylesheet to colourise levels
Mischa POSLAWSKY [Sat, 30 May 2020 22:22:44 +0000 (00:22 +0200)]
word edit: visit button to open linked wikipedia page
Mischa POSLAWSKY [Sat, 30 May 2020 22:21:42 +0000 (00:21 +0200)]
word edit: translation entry in referrer form
Mischa POSLAWSKY [Sat, 30 May 2020 20:30:57 +0000 (22:30 +0200)]
word edit: flags in language selection
Mischa POSLAWSKY [Sat, 30 May 2020 18:51:20 +0000 (20:51 +0200)]
word edit: columns declare nested suboptions
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.
Mischa POSLAWSKY [Sat, 30 May 2020 16:45:52 +0000 (18:45 +0200)]
word edit: common method to determine image paths
Mischa POSLAWSKY [Sat, 30 May 2020 07:02:32 +0000 (09:02 +0200)]
word edit: common function to format form input
Mischa POSLAWSKY [Sat, 30 May 2020 06:30:56 +0000 (08:30 +0200)]
word edit: enlarge and align columns, thumbnail
Mischa POSLAWSKY [Sat, 30 May 2020 06:29:30 +0000 (08:29 +0200)]
word edit: list and link translation references
Mischa POSLAWSKY [Sat, 30 May 2020 06:27:30 +0000 (08:27 +0200)]
word: order siblings by grade
Optional precedence before alphabetical neutral.
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.
Mischa POSLAWSKY [Fri, 29 May 2020 05:12:47 +0000 (07:12 +0200)]
word edit: group reference input with category