6.2 Change Log

6.2

Features

• add SQLite support

Configuration

secondary config

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

constants

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

conf files

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

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

Classes

• added
  • DbSqlite

Methods

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

Folders

• file/data – .htaccess protected folder for SQLite database file (see DATA_DIR in constants.php).

Database

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

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.

Formatters

• change markup for subscript to ,,subscript,,
• allows now [px|%|em|rem] with wrapper_width
• extend table markup^[link11] 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).

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

Handlers

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

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]

Admin panel

• add backup & restore for SQLite

Translations

• add new message sets regarding SQLite support

Packages

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