This update adds additional metadata for rips, introduction of wiki generation features and various bug fixes and general improvements to the database and site.
RipDB Updates
Added
- Added Composers table
- This table stores unique composers/artists who created the original tracks a rip is made from.
- Composers are linked on a per-rip basis, meaning multiple rips can be associated to one composer record.
- Added Platforms table
- This table stores game platforms games are from.
- This table shouldn't contain joke platforms (e.g. Wii 2, Xbox 720, anything of that nature), unless the rip is of a game that does not exist and its platform also does not exist.
- Platforms are associated directly to a Game record and not a rip itself.
- Added Mix Names to rips
- Mix names for rips now have their own column in the rips table.
- Added Wiki URL column to rips
- Wiki Page Generation
- Channel records that have a wiki URL defined for them now have the option to generate wiki page source code when viewing a rip.
- Wiki page source generation should be compatible across all common wiki sites such as Fandom and MediaWiki-based wikis.
- Added special timestamp inputs
- Timestamp inputs now have buttons to increment/decrement the timestamp by one second. Holding down these buttons will rapidly increase/decrease the timestamp value.
Changed
- Rip-to-Genre associations
- Genres are no longer associated directly to a rip. The RipGenres table has been dropped.
- Genres are now associated to a RipJoke record, allowing for specific jokes in a rip to have a specific genre.
- Improved layout for the Rip page.
Fixed
- Fixed search on Rips page
- The record count is now accurate based on the filters applied.
- Searching correctly includes the name of the rip, its game and mix name.
- Fixed some modal forms that did not correctly return the inputted data upon submission.
- Fixed display of rip links when viewing a rip.
- Fixed various SQL errors that can occur while using the site.
- Improved data validation when outputting user-inputted data.
RipGuessr Updates
There were no changes made to the RipGuessr game in this release.