Reply to thread

Message

<blockquote data-quote="ltfearme" data-source="post: 1124933" data-attributes="member: 52219">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);[/code]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);[/code]The SQL I use is the following:[CODE]SELECT movieinfo.strTitle, path.strPath, files.strFilename FROM movieInfoLEFT JOIN filesON movieInfo.idMovie=files.idMovieLEFT JOIN pathON files.idPath=path.idPathORDER BY strTitle[/CODE]</blockquote>

[QUOTE="ltfearme, post: 1124933, member: 52219"] 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); [/code] 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); [/code] 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 [/CODE] [/QUOTE]

Verification