[WiP] Centralised database in My Video, My Pictures and folder settings (1 Viewer)

regeszter

Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    If i'm right it needs to rewrite FH to use plugin APIs.
    Directly to the database, it refers only to the database, mvCentral and serials. And works directly with FH database.
     

    Edalex

    Community Plugin Dev
  • Premium Supporter
  • January 3, 2008
    2,922
    1,228
    Saratov
    Russian Federation Russian Federation
    Country flag
    Nope, mptvseries and movpics handling is right - DBSeries.GetAll() and DBMovies smth...
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,702
    7,084
    Sydney
    Australia Australia
    Country flag
    Trakt uses the following API calls with no SQL as parameters:
    Code:
    public static void SetMovieInfoById(int lMovieId, ref IMDBMovie details);
    public static void SetMovieWatchedStatus(int iMovieId, bool watched, int percent);
    public static int GetFile(string strFilenameAndPath, out int lPathId, out int lMovieId, bool bExact);
    public static bool GetmovieWatchedStatus(int iMovieId, out int percent, out int timesWatched);
    public static void SetMovieWatchedCount(int movieId, int watchedCount);
    public static void SetMovieWatchedStatus(int iMovieId, bool watched, int percent);
    public static int GetMovieInfo(string strFilenameAndPath, ref IMDBMovie details);
    public static int GetMovieId(string strFilenameAndPath);
    public static int GetMovieStopTime(int iFileId);
    public static void SetMovieStopTime(int iFileId, int stoptime);
    public static void GetMovies(ref ArrayList movies);
    There is one public method I use which does take SQL, its only used in the configuration dialog so people can select which movies to restrict by Title or Path. It wouldn't be a big deal if I had to change this as it wont affect the everyday use of the plugin and im sure I can find another way to do what I want.
    Code:
    public static SQLiteResultSet GetResults(string sql);
    The SQL I use is the following:
    Code:
    SELECT movieinfo.strTitle, path.strPath, files.strFilename 
    FROM movieInfo
    LEFT JOIN files
    ON movieInfo.idMovie=files.idMovie
    LEFT JOIN path
    ON files.idPath=path.idPath
    ORDER BY strTitle
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Trakt uses the following API calls with no SQL as parameters:
    All should work if I did not make any mistake. ;)

    There is one public method I use which does take SQL, its only used in the configuration dialog so people can select which movies to restrict by Title or Path. It wouldn't be a big deal if I had to change this as it wont affect the everyday use of the plugin and im sure I can find another way to do what I want.
    :)
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    Erorrs in log file :mad:
    MySQL server 192.168.0.100
    Password for root - MediaPortal
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    MediaPortal.Video.Database.SqlServer.VideoDatabaseADO.CreateDb() MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'root'@'192.168.0.1' (using password: YES)

    Password or mysql rights error.

    You may install a stand alone TvServer to the host which will be installed with right setup. You can uninstall it later.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    N [not reproducible] Online videos not working at all Submit: Bug Reports 1
    R Bug: Video Folders disappear General Support 11
    Stephen O'Kane [SOLVED] TV Stream stuttering - both Video and Audio Watch / Listen Media 14
    B some music videos stutter Watch / Listen Media 0
    Similar threads

























    Top Bottom