#229
  • Created on
    2010-08-03 04:28
  • Reported by
    Pernod
  • Status
    Fixed
  • Priority
    Low (4)
  • Assigned to
    Pernod
  • Milestone
    2.00
  • Plan Level
    -
  • Due Date
    -

Attachments

Related Tickets

Add new subtask or bug

Video hash in database

The hash code that is used by OpenSubtitles.org to uniquely identify videos should be calculated and stored in the database during a media search.

Other sites such as themoviedb.org can now use these hash codes to match movie details with actual video files.
User picture
  on 2011-04-01 01:56 *
By Pernod
Priority changed from Normal (3) to Low (4)
User picture
  on 2011-04-01 22:20 *
By Pernod
Component changed from None to Media Search
Updating tickets (#248, #83, #85, #97, #98, #100, #6, #92, #106, #146, #150, #151, #165, #174, #182, #191, #217, #228, #9, #77, #78, #209, #213, #219, #229)
User picture
  on 2011-04-02 23:03 *
By Pernod
Milestone set to 2.00
User picture
  on 2011-08-28 04:45 *
By Pernod
Assigned to set to Pernod
Status changed from New to Fixed
(In revision:1596) Added mood and lyrics columns to the mp3s table.
- Column mood will be populated from the ID3v2.4 Mood tag. Refs #225

Added OpenSubtitles hash, and other reference id's to the movies and tv tables.
- Column os_hash is calculated and stored during media search. Fixed #229
- Column imdb_id is parsed from filename during media search. This id is not yet used by the parsers.

Recreated the clients table to include a client_id.
User picture
  on 2011-08-28 05:11 *
By Pernod
(In revision:1599) Updated the Subtitles download feature to use the os_hash from the database, if it exists. If it doesn't exist then it will be calculated and stored in the database for future reference.

Refs #229