Content Ratings 2.8.5

• Fix received like ratings count is displayed as 0 (affecting 1.3.x)
  • Note if you did a received rating count rebuild and had the option "Allow rebuild operations to reduce a user's rating counts" enabled (it is disabled by default) then the received Like ratings count has been set to zero. Simply run the rebuild operation again.
• Fix like icon's not showing on rated posts (affecting 1.3.x)
• Fix rebuilding received likes counts (affecting 1.3.x)
• Update installer to better match XF2.1 schema
• Fix importers not setting given like counts

• More fixes to allow the web-installer upgrade to function correctly for 1.2.x => 1.3.x
  • CLI installer works fine, and new installs should not have an issue.

• Fix an error where using the web-installer would not trigger post-upgrade in time to clear invalid cached rating/reaction configuration causing the install process to break.
  • Uploading files, and then touching the website should be enough to force the incorrect caches to be cleared. Then the 1.3.2 upgrade can be done.

• Fix installer for new installs

• This update changes the schema of this add-on to allow a near zero-data-conversion upgrade from Content Rating schema to XF2.1 schema.
  • Warning; upgrading may take time as xf_liked_content data requires updating to allow a smooth upgrade to the XF2.1 schema. For big boards it is strongly recommend to use the CLI upgrader.
• In due course, a "Reactions Essentials" will be released which will be a Content Ratings for XF2.0

• Fix SQL importer incorrectly populating the post rating cache table

• In content rating criteria, the "Given" ratings and uncategorized rating types should now work.

• Importing Smilies no longer requires a category.
• Changes for importing Smilies and adding Default Rating Types;
  • Can skip duplicates (identified by title)
  • Is atomic, any error aborts adding the batch.
• For large tables, when use instant add column support if possible rather than giving up.

Feature update

• Emoji support! (requires utf8mb4 support)
  • Supports text/unicode, and converts emoji short codes (with auto complete) into unicode representations.
  • Spoiler: emoji picker

    
  • Spoiler: emoji config

    
  • Emoji are text, so you may need to adjust the relative size depending on themes. Default images are ~22px, and the emoji font-size of 1.5em gets a single character on the standard theme & font to near that size.
• New SQL-based importer
  • Off-line only, the forum can't be modified while the migration occurs.
  • CLI only, as it runs blocking SQL which takes nearly hour at a time.
  • Vastly faster for large datasets.
    Test forum with ~11.1 million posts, ~14.8 million Post Ratings, ~18.4 million Likes; it took 3.6 hours compared to an abandoned +16 hour import test run with the standard importer.
• Update standard importer to reduce long running memory usage
• Update installer code

• Ensure HTML attributes using phrases are escaped properly