Converting Movie # to Movie Title

Discussion in 'Tips and Tricks' started by Hr. Kvist, September 10, 2005.

  1. Hr. Kvist

    Hr. Kvist Portal Member

    Joined:
    September 10, 2005
    Messages:
    16
    Likes Received:
    0
    Ratings:
    +0 / 0
    If you're like me, and you would rather have MP to ask for the movie title instead of a number when you select a movie, heres a fix :

    1. Start docs/SQLite Database Browser.exe
    2. Open database/VideoDatabaseV5.db3
    3. Execute the following sql statement : update movie set discid = (select strtitle from movieinfo where movie.idmovie = movieinfo.idmovie);

    Hr. Kvist


     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!