- Update to 4.2.2
  DATABASE CHANGES You can now force a default collation and charset on your database.
  If you choose to use utf8mb4; Ampache will convert your table engine to InnoDB to handle the extra bytes.
  
  * Added
    - Numeric 'Played/Skipped ratio' added to search. (Set using (stream/skip)*100.)
      - > 0 & < 100: Skipped more than played
      - 100: Equal plays and skips
      - > 100: Played more than skipped
    - Add 'Original Year', 'Release Type' to Album searches
    - Allow setting custom database collation and charset without overwriting your changes
    - Video search added to random.php
    - 'samesite=strict' on JS cookies
    - Translation updates (August 2020)
    - Put 'Labels' into search, browse headers and sidebar when enabled
    - NEW config options (config_version 45)
      - database_charset: Set a default charset for your database
      - database_collation: Set a default collation for your database
      - simple_user_mode: Don't allow users to edit their account values (used for demo sites that allow login)
    - NEW files
      - bin/update_file.inc: Update your catalog when individual files are changed using inotifywait.sh
      - bin/update_db.inc: Update your database collation, charset and table engine from the cli
      - docs/examples/inotifywait.sh: script to use inotifywait and update_file.inc to update as file changes happen
      - docs/examples/inotifywait.service: systemd example service for inotifywait.sh
  * Changed
    - stats.php: Show total 'Item Count' on Statistics page instead of trying to shoehorn songs/videos/etc into different columns
    - ampache.sql updated after about 4 years... no more updates on install!
    - Searching by "Rating (average)" now ignores private/public and always returns the average.
    - Hide searches for '# Skipped' and 'Played/Skipped ratio' when 'Show # skipped' is Off
    - Search items rearranged to try to match each other
    - Sort 'Playlist' and 'Smart Playlist' browse pages by name
    - Display the blankuser avatar in now playing if missing
    - Swap 'Random' and 'Playlists' in the sidebar (CSS order numbers)
    - Don't hide artist art when you disable lastfm_api_key in the config
    - Hide 'Metadata' search when 'enable_custom_metadata' is disabled
  * Deprecated
    - Drop version number from the release string in develop. ('4.3.0-develop' => 'develop')
      - This should stop a bit of confusion when removing / adding requirements
    - The '-release' suffix in version number will be dropped for Ampache 5.0.0
  * Removed
    - Remove stat recording from channels
    - Don't reset the database charset and collation after each db update
  * Fixed
    - Fixed a few issues on the Statistics page
      - Report 'Catalog Size' correctly for podcasts
      - Report 'Item Count' correctly for podcasts and video catalogs
    - Searching albums for artist name
    - Mashup 'Newest' would incorrectly apply an offset missing the newest items
    - Search by 'Smart Playlist' rules fixed when added with other rules
    - Use LEFT JOIN instead of HAVING for search rules to allow more complicated lists
    - Logic searching 'My Rating' includes unrated (0 Stars) in a better way
    - Captcha was not generated for registration
    - Enforce lowercase codec for live streams
    - Parsing integer search rules was overwriting index values
    - Handle empty XML on similar artist requests to last.fm
  * Security
    - Fix CVE-2020-15153 - Unauthenticated SQL injection in Ampache
  * API 4.2.2
    - Minor bugfixes
  * Added
    - Api::advanced_search added parameter 'random' (0|1) to shuffle your searches
  * Changed
    - Remove spaces from advanced_search rule names. (Backwards compatible with old names)
      - 'has image' => 'has_image'
      - 'image height' => 'image_height'
      - 'image width' => 'image_width'
      - 'filename' => 'file' (Video search)
  * Deprecated
    - Search rules 'has image','image height', 'image width', 'filename'. (Removed in Ampache 5.0.0)
  * Fixed
    - Api::stream, Api::download Api::playlist_generate 'format' parameter was overwritten with 'xml' or 'json'
    - Produce valid XML for playlist_generate using the 'id' format in XML

• Files Changed
• Browse Source