History

17.9.2023 3.9.0

Made compatible with PHP 8
PHP 8 needs SQLite, CURL and ZipArchive extensions (not default anymore)
PHP 5.4 does not work any more, you need at least 5.6
Polyfill for missing ZIPArchive

14.3.2023 3.8.9

Relation function textrank()

10.3.2023 3.8.8

Relation database and sql instruction
Relation write can write to connected database
Relation repeat instruction
Fixed access of menus of redirections
Fixed gtn function in expressions
Cosmetic: rewrote relation linehandler run2 assertions
Expression function sqlesacape()

23.12.2022 3.8.7

Pseudo namespace Imagelazy: allows to render images only if they are visible, together with new endpoint imageapi.php rendering resampling of images
Refactored special:images page
New aggregate functions for Relation: gm, hm, gini, hill, prod, shannon
New functions for Relation: tag, template, link
Some functions in Relation can have a variable number of inpurts: min, max
Improved performance of fulltext index(removed expensive formatting of found text and working with entities allows byte string handling)
Improved performance of SQLite DB updates.
Style parser handles better paragraphs and text on same line after end of table
Language pages can be deleted also if the main page is missing
Moved overtime script in own header and footer files
Fixed logical errors with bitmaps of uneven lengths

17.10.2022 3.8.6

filter index allows fast search on fields with exact values
New statistical functions for Relation: BigramStat(), Levenshtein(), TrigramSimilarity(), TrigramWeightedSimilarity(), TrigramCosineSimilarity()
Faster link parser for internal links
Fixed table genration in style parser (multiple lines)
Fixed errors on incomplete bloom and monogram indexes
Optional $swWikiTextPre=false to opt out pre tags in wikitext (line starting with space)

7.10.2022 3.8.5

Query adds the FILTER instruction which emulates the filter instruction of Relation (much faster).

22.9.2022 3.8.4

Fixed score algorithm for full text search (div/0)
Expanded monogram to digram and fixed monogram filter

19.9.2022 3.8.3

Full text search using FTS3 from SQLite.

20.8.2022 3.8.2

fixes incomplete bloom and monogram indexing bugs (missing results)
it is recommended to reindex all with this release

16.8.2022 3.8.1

fixed regex crashes on monogram indexing (503 errrors)

9.8.2022 3.8.0

default values for $swRamdiskPath (‘db’) and $swDbaHandler (‘sqlite3’). Change in your configuration to ‘db4’ or ‘persistance’ if the PHP implementation (MAMP for example) does not support sqlite. If you change the database engine, you must delete completely the content of site/indexes/ and site/queries/
the relation console can now also modify the pages with the relational execute instruction.
the relation instruction “print spacegrid” allows to print a more flexible filtrable table (inline table which can also be 2-dimensional floating)
improved dba engine synchronisation
fixed relationfiler bloom filter bugs and interaction between filter and user rights
removed syntax coloring
rewrote table parsing in style parser
fixed header visibility in table.js
fixed language switch on search

6.4.2022 3.7.9

Fixed delete of language subpages
Fixed interlanguage links
Fixed unwanted display (0 or 1 ontop of page) of swOverWrite status in inc/skins/header.php
Fixed obscure header error on manual installation

30.3.2022 3.7.8

Special:Import revisions accepts zip file in site/upload folder
Correctly displaying image pages with PNG and GIF images
Fixed Upload Images
Fixed missing folder site/cache/
Monogram maintenance (reset with bloom, overtime)
System Message lookup is not lazy any more
Removed shortcuts for menus

16.3.2022 3.7.7.

Maintenance update (external pull request)

6.3.2022 3.7.6

Special:Active Users
Special:Deleted Pages shows timestamp
Special:Tickets allows for upload of screenshots and other files
swPersistanceDba as database for small sites (without Sqlite3 nor dba_handlers)
$swDbaHandler = "persistance" by default
$swOldSearch is now false by default
Refactored upload functions
Fixed localized cookies.

16.2.2022 3.7.5

Fixed wrong order of failaction and indexerror block in index.php
Fixed sublang insertintroduced by change of parser order (new parser sublang)
Added cache and image refresh menus

14.2.2022 3.7.4

_group right inherits right of another user (note this is only one step, no groups of groups)
Fixed notice bugs

13.2.2022 3.7.3

Improved reliability of Upload.js
Fixed extenstion of cookie valididy
Added a Favicon in default skin

12.2.2022 3.7.2

Fixed installer

11.2.2022 3.7.1

New image link Download:name returns file from php instead of Media:name that returns a link. Downside: it also mobilies PHP ressources
New function encryptpassword(name, pass)
Function rnd() in Expression returns now a fraction number between 0 and 1
Worked on upload.js interface und optimization. Tested
Fixed bug on delete.php preventing deleting files
Fixed bug on passwords.php preventing user creation
Action new allows GET parameters (name, content) to populate empty page
swGetValue accepts also curly braces in values.

9.2.2022 3.7.0

Application style admin menus for all skins
Dialog windows for editing tasks
Relation input instruction also uses the dialog windows
Redesigned skin structure skin design and CSS
Default skin handles now mobile screens.
New global $swStatus
Redesigned page-subpage relationship. Protect is global, Rename and Delete are by default global, but configurable.
Redirection always goes to the main page and not a subpage.
Empty subpages are now ignored and do not cover a main page any more.
Edits without change in content do not trigger a new revision any more
Special:Field Search allows to browse the entire site for field values
Experimental Special:Upload Big: resiliant, ineractive upload tested up to 1 GB
Function uploadzone function allows to create custom upload pages for users
Function preventovertimesearchagain prevents
swSystemMessages are by default english, if no localisation is present
Actions in index.php precede now the menu creation
Template parser is now after the fields parsers. This allows more legal characters in fields.
Fixed bug $swOvertime not present when memory limited filter or relationfilter
Image pages do show the content again (unparsed like template pages)
Cookie values are now refreshed as long as the user is active.
Some code moved to their own files

29.1.2022 3.6.3

Cron does not save any statistics any more in logs namespace (too much space).
The new relation logs instruction filters logs lines directly from log files.
New Special:Metrics based on logs instruction.
Refactored and all other pages indexes with grid
Added SofaDoc comments inc/a-f and renamed functions
Refactored expression functions and operators in own file
Fixed space on email parser
Fixed error prevented <== to work in Relation
Fixed log errors
Relation read can access remote files if you provide a swVirtualLinkHook, see Relation external URL
Special:Passwords prefills the password

11.1.2022 3.6.2

Monogram filter
Bitmap further compression
Using correct UTF-8 substring in expression
Starting documentation

2.1.2022 3.6.1

Start implementing documenation with SofaDoc https://www.sofawiki.com/sofadoc.php
Optimized compilation of expressions with caching
Image crop editor (see File upload)
Optimized table parser for big tables (more than 50 000 lines)
Relation function print grid with more link.
Added unused fields and text and select menu as alternative to radio in Editor templates
Fixed bug in inc/special/logs.php

15.12.2021 3.6.0

Refactoring DB indexes
Refactoring relation filter namefiler
Editor templates
Fixed bug that did not index the bloom for the last revision

12.12.2021 3.5.6

dba implemented sqlite3 (filebased)
hint function for expressions, working like filter hint
improved table and new relation instruction "print linegrid" (table, but no borders)
overtime refresh only at the end of the page, no sentence any more
fixed double language link
new relation instruction "filter index col"

2.12.2021 3.5.5.

dba improved file lock and indexing
swDBAerror

1.12.2021 3.5.4

Fixed dba->list() because list is a reserved word in PHP 5
Translate function
Adapted DeepL to Free API
swBitmap has now a default value for out of range getbit requests
Memory limits for expensive loops
relation filter project drop
relation filter walk instruction
dba improved file lock and indexing

28.11.2021 3.5.3

Relation function has alternate input fields _textarea and _select
Native wiki functions can directly be used in expressions without using template
Native DBA-Function if DBA-Support is not installed with PHP (for example MAMP)
Fixed bug overwriting ticket
Improved bloom indexing

21.10.2021 3.5.2

Bugfix index updating on new records (force index to save last revision)
Aggregation in relation function includes Infinite(∞, -∞ ) and undefined values (⦵)
Bugfix namespace handling in swRelationfilter function
Restored Special:Indexes page disappeared with 3.5.1
Fixed 24 hour timestamp in Special:Tickets

13.10.2021 3.5.1

Infinite(∞, -∞ ) and undefined values (⦵) are now valid numbers in expressions.
Fixed crash when a relation instruction does not return a relation on the linehandler stack.
Special:Backup now provides a listing of backed up files for download
Fixed user rights in relationfilter and relation import function

26.9.2021 3.5.0

Fixed error on ticket id generation
Fixed error on db where $lastwrite maybe 0 if there is no revision yet
Fixed exception error display on swRelationFilterOvertimeRetake on invalid queries

22.9.2021 3.4.9

Performance update on indexes and special pages

10.9.2021 3.4.8

Security update: Improved Deny management. You can also block random accesses of login pages. See inc/special/deny.php

8.9.2021 3.4.7

Custom search redesigned search.php
Cache parses adds a cache refresh menu for users with global modify rights
Improved resume function (still not perfect)

5.9.2021 3.4.6

Relation echo has access to global variables
Relationfilter always searches at least 50 records, even if there is overtime.

4.9.2021 3.4.5

Optimized Bloom filter (does not reindex any more because bloombitmap is lost)

23.8.2021 3.4.4

Optimized relationFilter (removed unused revisions from search in namespace filter.

2.8.2021 3.4.3

Added auto and analyze option for Scale Image.

19.7.2021 3.4.2

data in relation can have csv option (no expression handling)
improved performance of fields output of relation
template function in expression allows to embed any template (or function) in an expression
improved template parser
improved nowiki performance in parsing
error handling for writing records with illegal names
fixed refresh of relation filters

2.7.2021 3.4.1

Fixed echo output
Analyze instruction in the relation function
Fixed serialize function in the relation function
Fixed a bug (503 error on long pages) in the templates parser.

21.6.2021 3.4.0

Refactored swGetFields (accepting more keys (all except newline and wiki special characters) and more values (all except )
Charts functions for Relation function but not only
Special:Metrics uses charts

12.6.2021 3.3.2

Fixed problems with last changes not showing in relationfilter.
Tickets can be reopened by anyone
Relation pivot

11.6.2021 3.3.1

Fixed logical bugs in bitmap

3.6.2021 3.3.0

Relation filter uses Berkeley DB as search cache
Bitmap reenabled compression
Semaphore filebased
Bloom filter redesignet
URL database
Improved filter performance.

24.5.2021 3.2.3

All special pages use now swRelation instead of swQuery
New internal function swRelationToTable returns a table
Table headers cells can now have attributes like table cells
RSS function uses relation, not query any more
Improved resume function and nowiki parser
Expressions functions nowiki and resume

20.5.2021 3.2.2

New operator regexi in Expression engine (regex case insensitive)
Relation function has now print grid which allows to explore (filter and sort) big tables.

15.5.2021 3.2.1

Delegate instruction in Relation function hands over the current relation as CSV to a template or a function.

31.3.3021 3.2.0

Relation search as option if you set $swOldSearch = false (see inc/relationfilter.php )
Fixed performance in relation filter. Hint can now have multiple words (separated with spaces) which must appear, but not necessarily in order
Pipe trick internal links uses now display name
Fixed logs. You can now manually consolidate the today log being sure it will be replaced with the last date next day.
Schedule function makes wikitext visible based on time.
NB: Special pages will now be converted from query to relation over the time

17.2.2021 3.1.3

Relation filter now can search for _paragraph (for search better to handle than _content
Fixed HTML table output of Relation
Improved performance of Relation filter with _name hints
Instead of password reset, an email access is possible (link to send, works once without login)

14.10.2020 3.1.2

Relation import
Allow notify with HTML

10.8.2020 3.1.1

Relation function with include and stack instruction, sync to Belle Nuit Relation 1.0.0b7
Improved Special:Tickets
Improved Resume function

28.7.2020 3.1.0

input instruction for Relation function
possibility to use Berkeley DB as RAM disk.
Fixed several bugs in swRelationFilter()
Fixed a bug when the text is too short for Bloom Filter.
Added Berkeley DB to cron.php
Updated Relation expression engine to Belle Nuit Relation
Adaption to intval errors PHP 7.2
Improved Link Parser
Improved CSS styles for Relation function
Improved Mark Relation code
Fixed title bug in special:tickets
Added failaction hook for Login and Logout.

28.5.2020 3.0.3

install.php Script see Download
Styled swSystemMessage parses also templates. Use with caution.

27.5.2020 3.0.2

Relation supports update instruction. Valid names can start with undescore (_)
Lost password sends a reset link instead of a new password.

5.5.2020 3.0.1

Relation supports label instruction.

29.4.2020 3.0.0

New Relation function
Change: Inside templates, line returns inside a parameter are not converted to spaces any more. The parameter is still trimmed.

9.4.2020 2.1.3

Added accented caracters to link parser

7.12.2019 2.1.2

Login: Possibility to disable autofill on login with $swBlockLoginAutocomplete=true un configuration.
Removed color coding code from 1.9.7 in skins and special edit.php (did not really work)

20.11.2019 2.1.1

Fixed query and value function output of tag characters <>

1.8.2019 2.1.0

Added support for DeepL translation
Added support for Charts

2.3.2019 2.0.5

Added $swMaxFileSize (default 8000000) for File Upload form. Note that the max upload size is also limited by the PHP.ini variables upload_max_filesize and post_max_size.

20.2.2019 2.0.4

swVirtualLinkHook has now 3 parameters: $urlname, $fields, $query
Removed a bug that could remove content when new password is used (greedy regex)
Removed user on revisions new password and lost password
Improved field editor
New function fields

3.2.2019 2.0.3

Searchnamespaces and transcludenamespaces always include AllUserRights now
swInternalLinkHook removed from filter and import and replaced by swVirtualLinkHook which has a second parameter fields
Removed Preview

9.12.2018 2.0.2

Search includes now user actions from logs (querygoodresults) and refreshes itself on default skin if overtime.

31.10.2018 2.0.0

VERBOSE in query shows stack in a tree form
swSystemMessage improved
new functions systemmessage and diff

10.10.2018 1.9.9

swSystemMessage does return unchanged key if no message has been found.
Image tag allows now to define crop preference on image resize. Note: alt tag has moved one parameter forward. Scale image

4.1.2018 1.9.8

Moved Colorcode to skins default and wiki only
Fixed base href in skins in inc

19.9.2018 1.9.7

Colorcode textarea for editing
swSystemMessage keys more resilient. They are only fallback URL. (1.9.4)

1.7.2018 1.9.6

Simplified first installation
Fixed parameter count on swInternalLinkHook

25.6.2018 1.9.5

Function htmltabletofields can read external URL into fields
Cache parser #CACHE directive

27.5.2018 1.9.4

Added swLogHook
Bitmap fixed non numeric values for set and get
Configuration: $swLogAnonymizedIPNumber (default true) scrambles the last IP number for log files. The result numbers are still unique valid IPv4 numbers.
Logfiles are consolidated by Cron (or manually from Special:Indexes
Possibility to delete old logfiles from Special:Log
Special:Metrics statistics on consolidated log files
.htaccess files added to snapshot for inc/, site/ (deny from all) and exceptions (allow from all) for inc/skins/, site/cache, site/files/ and site/skins/. Note that the main .htacess file remains manual
Cleaned swSystemMessage keys. They are all URL. You might have to rename overrides.
Improved Special:System Messages page with tabular view
Improved Paragraph rendering.
Pipeprotected text in templates is now style parsed
Reintroduced missing pre tag
Open Div tags are automatically closed at the end of the parsed content
Parameters in templates can be declared optional {}
Query: DATA commmand verbatim fields
Query WHERE clause in SELECT can use a column from the top stack (wigth $ notation)
Query WHERE allows for IN :: Hint Possible
Query CALC can use some functions with FUNCTION- command (set arity >=0 for self-defined functions to get all arguments from stack)
Query OUTPUT LIST, LISTPAGED and HTMLPAGED

13.4.2018 1.9.3

Removed Pre from style to tidy parser
Fixed space on simple links
Deleted page returns 404 now

1.4.2018 1.9.2

Fixed Bloom for sites with many revisions
Resume function does ignore category now
Removed superflous br tag in Category parser

21.3.2018 1.9.1

Introduced P tags instead of double BR. See Paragraph tags
Style pretty format HTML

14.3.2018 1.9.0

Language integrated in URL (optional $swLangURL)
Moved session close to end
Fixed PHPO 7 Syntax in notify.php

14.3.2018 1.8.5.

Added $swNotifyMailBCC and $swNotifyMailCC;
Proper Unicode encoding for notify mail subject
Fixed bug when username remained with wrong password login
Logout refreshes Session

28.12.2017 1.8.4

Fixed bug on bloom filter (db lastrevision+1)
Removed datatable and relaxed mode
Changed swInternalLinkHook to return URL and not link
Enabled swInternalLinkHook for IMPORT and FROM VIRTUAL

22.11.2017 1.8.3

Feature: Special:Tickets
Performance: Bloom indexes in RAM
Performance: Special:Recent Changes does not reset Bitmap any more
Bug: Iniset to prevent PREG_REPLACE to limite to 2700 characters

27.9.2017 1.8.2

Added NOCASE for case sensitive ORDER and GROUP

6.9.2017 1.8.1

Added swGeneratePasswordHook() function for password generation

30.8.2017 1.8.0

Introduction of alt Users
Removed references to old filter, data function, tree, trigram, keyvaluestore, semaphore is now always on.

23.8.2017 1.7.5

Introduction of IP users
Fixed a missing db object reference in swFilter
Prevented record to write a revision 0
Moved update servers to https

16.4.2017 1.7.4

Fixed minor Bug in swBitmap-Redim() (one off let missing revision appear in Recent Changes
Special:Regex bigger input fields and possibility to use literal replace instead of regex
swRecord lookup filters invalid names in URL-representations
swFamilyName function
swQuery order FAMILYNAME and URL

9.4.2017 1.7.3

Fixed bug in swBitmap-Redim() when longer, all bits of the last byte were not set
Optimized site search no filters only in already found revisions for further multiple words
swFilter() has a checkhint paramater to limit search on certain revisions.
Added swLengthSort() in utilities.php

5.4.2017 1.7.2

Function swSimpleSanitize removes greater and lower tag characters on input that shoud not have one (url get parameters query and names, also to be used on public input fields) to prevent XSS.

5.1.2017 1.7.1

Fixed warning on bloom when you filter while there was not yet an index
Added Cancel Button on Edit.
Modify after edit shows no the localized version, not the general. This reflects more the wiki style where the general page is fields and the localized page only text and includes with {{}} syntax.
Fixed superfluous return at the end of output TAB in swQuery.

4.1.2017 1.7.0

Added possibility to save log search directly to page
Introducing bloom filter. Bloom filter replaces Trigram. If you want to continue with Trigram, set configuration $swUseTrigram = true;

14.12.2016 1.6.8

New function swCleanTupleFieldOrder to properly output query results
Removed LIST in query as not working properly
Comment command # in query

12.10.2016 1.6.7

Fixed bug in swZipArchive (warnings on journal not present)
Fixed bug in swQuery TABHEADER output

24.10.2016 1.6.6

Custom swZipArchive class which is lazy to faster update often changed files (keeping a journal)
Update sets now all written files to permission 0750 for files, 0770 for folders.

23.10.2016 1.6.5

Using zip file for Trigram makes indexing much faster. Can be turned of using $swTrigramUseZip = false in configuration.php

5.9.2016 1.6.4

Fixed bug OUTERJOIN was removed in 1.6.3 accidentally.
Sempahore less verbose

17.8.2016 1.6.3

Query Group has a new function CONCAT for strings
Update sets now all written files to permission 0777

16.7.2016 1.6.2

Fixed bug on OUTERJOIN missing right joins and field order

16.5.2016 1.6.1

Optimzation: swFilter does not save any more if no revision has been checked
Optimization: swGetallrevisions reads 20 entries in a chunk.

21.4.2015 1.6.0

:: modifier in templates takes argument verbatim, wthout removing newlines
Semaphores in test mode replace concurrency protection with session variable.

Semaphore is experimental, you can turn it of setting $swUseSemaphore false. See inc-semaphore.php, in that case session protection is left until the end of the execution.

20.4.2015 1.5.9

Fixed BR and HR tags didn't work any more in tidy parser.

29.3.2016 1.5.8

Fixed wrong adressing of first element in an array in swQuery with 0 index instead of reset

23.3.2016 1.5.7

Removed SHOWKEY in swQuery
Fixed bug in OUTPUT TAB in swQuery, last character of each line was cut
UNION, CROSS, LEFTJOIN and OUTERJOIN now return always complete relations (all fields), see also Join and Cross

21.3.2016 1.5.6

Removed <> operator which is a duplicate of !=
all fields in the WHERE clause are tested, even if non existent (evaluate to 0)