6.2 Change Log

6.2

1. Features

• add SQLite support

2. Configuration

2.1. secondary config

1. new 
   • reserved_namespaces
   • tools_page
   • whatsnew_page
2. removed
   • disable_npjlinks
   • session_prefix

2.2. constants

1. new 
   • DATA_DIR
2. renamed
   • UPLOAD_BACKUP_DIR -> BACKUP_DIR

2.3. conf files

1. changed
   1. autoload.conf^[link5]
   2. csp_custom.conf^[link6]
   3. csp.conf^[link7]
   4. permissions_policy.conf^[link8]
   5. router.conf^[link9]

3. Core

• make sess->date_pattern dependent on $this->user_lang
• rewrote SQL queries to work with MySQL as well as SQLite
• register custom regexp function to use REGEXP with SQLite
• fix missing route case for CSS files in RECOVERY_MODE

3.1. Classes

• added
  • DbSqlite

3.2. Methods

• utc_dt()
• date_sub(int $value, string $interval)
• binary()
• collate()
• limit()

3.3. Folders

• file/data – .htaccess protected folder for SQLite database file (see DATA_DIR in constants.php).
• vendor/ – is managed by Composer^[link10] and is only part of the distribution package

4. Database

• setup/database/sqlite.php^[link11]

5. Installer

• add SQLite table creation script
• add _t() function for $lang[] array, uses now English as fallback for missing message sets
• add system page with the whatsnew action and set it as default bookmark
• add private system page with with the admincache and admin_recovery action and set it as bookmark for the admin
• the installer sets now bookmarks for the admin account, therefore it no longer shows the default bookmarks for the admin in the menu by default
• add mandatory installer password protection
  • It is imperative to set the password for the installer in the config/lock_setup file.
  • The password must be set, it won't accept an empty password.
  • This requires the user to add a password before he can proceed with the installation or upgrade.
  • The password in the file is in plain text and should not be the same as the recovery password.

6. Formatters

• change markup for subscript to ,,subscript,,
• allows now [px|%|em|rem] with wrapper_width
• extend table markup^[link13] allowing table caption, cell spans, width and cell attributes (WIP, experimental)
  • ?| table caption |?
  • !| col | col |!
  • ^| header | cell ||
  • || cell ^ header ||
  • ||(attr=value) cell | cell ||
  • attributes:
    • align = [center|left|right|justify]
    • bgcolor = [blue|red|green|x11colors]
    • class = "alternate sticky defaultcenter col1left col4right"
    • colspan = number
    • id = id_name
    • rowspan = number
    • scope = [row|col|rowgroup|colgroup]
    • side = [top|bottom]
    • span = number
    • type = table_style
    • valign = [top|middle|bottom]
    • width = number[px|%|em|rem]
  • CSS selectors
    • alternate alternating row shading
    • sticky for sticky header
    • default[left|center|right|top|middle|bottom]
    • colN[left|center|right|top|middle|bottom] N stands for the column number (1–25)
    • col-N[left|center|right|top|middle|bottom] Align the cells in column N counting from the right (1–9).

7. Actions

• menu: fix not showing 'Set a bookmark' form in menu action
• whatsnew:
  • add filter for pages, comments and files
  • show also edited comments in list
• no longer use link table for mostcommented and mostpopular action

8. Handlers

• show: Displays the number of comments in the article header and provides a link to the comments section.

9. Themes

• x11colors.css
  • replace .mark-[blue|green|red] with [xblue|xgreen|xred] to not overwrite default definitions in wacko.css
• wacko.css: add CSS classes to align text in table cell
  • .text-[center|left|right|justify]
  • .vertical-[top|middle|bottom]

10. Admin panel

• add backup & restore for SQLite

11. Translations

• add new message sets regarding SQLite support

12. Packages

• Bad Behaviour^[link14] 2.2.26
• freeCap^[link15] 1.4.7
• Hashids^[link16] 5.0.2 (Changelog^[link17])
• php-diff^[link18] 2.5.0 (Changelog^[link19])
• PHPMailer^[link20] 7.0.2 (Changelog^[link21])
• PHP Thumb Library^[link22] 2.3.3
• SafeHTML^[link23] 1.3.13
• SimplePie^[link24] 1.9.0 (Changelog^[link25])
• svg-sanitizer^[link26] 0.22
• WikiEdit^[link27] 3.26