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

[regeszter]

Nope, FH is accessing dbs directly with SQl as I see not with API.

                  videoDatabaseMovies = new ArrayList();
                  VideoDatabase.GetMovies(ref videoDatabaseMovies);

It will work.

https://github.com/MediaPortal/Medi...Databases/Video/Ado/VideoDatabaseADO.cs#L3596

 

[Edalex]

Hmm, strange. i saw plenty of sql and db handling code in FH sources...

 

[ajs]

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.

 

[regeszter]

Hmm, strange. i saw plenty of sql and db handling code in FH sources...

Bad news but I can make API for each queries if needs. I had to do the same in My Video plugin because there were some direct sql in the plugin too.

 

[Edalex]

Nope, mptvseries and movpics handling is right - DBSeries.GetAll() and DBMovies smth...

 

[ajs]

Hmm, strange. i saw plenty of sql and db handling code in FH sources...

If need be, I altered it. He has more or less stable. And it works in 95% of cases correctly and effectively.

 

[ltfearme]

Trakt uses the following API calls with no SQL as parameters:

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.

public static SQLiteResultSet GetResults(string sql);

The SQL I use is the following:

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]

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]

Erorrs in log file
MySQL server 192.168.0.100
Password for root - MediaPortal

 

[regeszter]

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.