C# Class MediaPortal.Video.Database.VideoDatabaseSqlLite

Summary description for Class1.
Inheritance: IVideoDatabase, IDisposable
Mostra file Open project: MediaPortal/MediaPortal-1

Public Properties

Property Type Description
m_db SQLite.NET.SQLiteClient

Public Methods

Method Description
AddActor ( string strActorImdbId, string strActorName ) : int
AddActorInfoMovie ( int idActor, MediaPortal.Video.Database.IMDBActor movie ) : void
AddActorToMovie ( int lMovieId, int lActorId, string role ) : void
AddBookMarkToMovie ( string strFilenameAndPath, float fTime ) : void
AddCollection ( string strCollection1 ) : int
AddCollectionDescription ( string movieCollection, string description ) : void
AddCollectionToMovie ( int lMovieId, int lCollectionId ) : void
AddFile ( int lMovieId, int lPathId, string strFileName ) : int
AddGenre ( string strGenre1 ) : int
AddGenreToMovie ( int lMovieId, int lGenreId ) : void
AddMovie ( string strFilenameAndPath, bool bHassubtitles ) : int
AddMovieFile ( string strFile ) : int
AddPath ( string strPath ) : int
AddUserGroup ( string userGroup ) : int
AddUserGroupDescription ( string userGroup, string description ) : void
AddUserGroupRuleByGroupId ( int groupId, string rule ) : void
AddUserGroupRuleByGroupName ( string groupName, string rule ) : void
AddUserGroupToMovie ( int lMovieId, int lUserGroupId ) : void
CheckActorImdbId ( string id ) : bool
CheckMovieImdbId ( string id ) : bool
ClearBookMarksOfMovie ( string strFilenameAndPath ) : void
DeleteActor ( string actorImdbId ) : void
DeleteActorFromMovie ( int movieId, int actorId ) : void
DeleteCollection ( string collection ) : void
DeleteEmptyCollections ( ) : void
DeleteFile ( int iFileId ) : void
DeleteGenre ( string genre ) : void
DeleteMovie ( string strFilenameAndPath ) : void
DeleteMovieInfo ( string strFileNameAndPath ) : void
DeleteMovieInfoById ( long lMovieId ) : void
DeleteMovieStopTime ( int iFileId ) : void
DeleteUserGroup ( string userGroup ) : void
Dispose ( ) : void
ExecuteRuleSQL ( string strSql, string fieldName, bool &error, string &errorMessage ) : ArrayList
ExecuteSQL ( string strSql, bool &error, string &errorMessage ) : void
FlushTransactionsToDisk ( ) : void
GetActorByName ( string strActorName, ArrayList actors ) : void
GetActorImdbId ( int idActor ) : string
GetActorInfo ( int idActor ) : MediaPortal.Video.Database.IMDBActor
GetActorNameById ( int actorId ) : string
GetActors ( ArrayList actors ) : void
GetActorsByMovieID ( int idMovie, ArrayList &actorsByMovieID ) : void
GetBookMarksForMovie ( string strFilenameAndPath, ArrayList &bookmarks ) : void
GetCollectionById ( int collectionId ) : string
GetCollectionDescriptionById ( int collectionId ) : string
GetCollectionId ( string movieCollection ) : int
GetCollections ( ArrayList collections ) : void
GetCollectionsForMovie ( int lMovieId ) : string
GetDVDLabel ( string strFile ) : string
GetFile ( string strFilenameAndPath, int &lPathId, int &lMovieId, bool bExact ) : int
GetFileId ( string strFilenameAndPath ) : int
GetFilesForMovie ( int lMovieId, ArrayList &files ) : void
GetGenreById ( int genreId ) : string
GetGenres ( ArrayList genres ) : void
GetGenresForMovie ( int lMovieId ) : string
GetIndexByFilter ( string sql, bool filterNonWordChar, ArrayList &movieList ) : void
GetMovieCollectionWatchedStatus ( int collection, int &percent ) : bool
GetMovieCollectionWatchedStatus ( string collection, int &percent ) : bool
GetMovieCollections ( int lMovieId, ArrayList movieCollections ) : void
GetMovieDuration ( int iMovieId ) : int
GetMovieGenres ( int lMovieId, ArrayList movieGenres ) : void
GetMovieId ( string strFilenameAndPath ) : int
GetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : int
GetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
GetMovieStopTime ( int iFileId ) : int
GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData ) : int

Deprecated Method (this one will not use the new Blu-ray Title mode resume)
GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData, int bdtitle ) : int
GetMovieTitlesByActor ( int actorId ) : string
GetMovieTitlesByCollection ( string strCollection ) : string
GetMovieTitlesByDirector ( int directorId ) : string
GetMovieTitlesByGenre ( string strGenre ) : string
GetMovieTitlesByIndex ( string sql ) : string
GetMovieTitlesByUserGroup ( int idGroup ) : string
GetMovieTitlesByYear ( string strYear ) : string
GetMovieUserGroups ( int movieId, ArrayList userGroups ) : void
GetMovieWatchedStatus ( int idMovie, int &percent, int &timesWatched ) : bool
GetMovies ( ArrayList &movies ) : void
GetMoviesByActor ( string strActor1, ArrayList &movies ) : void
GetMoviesByCollection ( string strCollection1, ArrayList &movies ) : void
GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable ) : void

Deprecated Method (use GetMoviesByFilter with Movie Collection)
GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable, bool collectionTable ) : void
GetMoviesByGenre ( string strGenre1, ArrayList &movies ) : void
GetMoviesByPath ( string strPath1, ArrayList &movies ) : void
GetMoviesByUserGroup ( string strUserGroup, ArrayList &movies ) : void
GetMoviesByYear ( string strYear, ArrayList &movies ) : void
GetPath ( string strPath ) : int
GetRandomMoviesByActor ( string strActor1, ArrayList &movies, int limit ) : void
GetRandomMoviesByCollection ( string strCollection1, ArrayList &movies, int limit ) : void
GetRandomMoviesByGenre ( string strGenre1, ArrayList &movies, int limit ) : void
GetRandomMoviesByPath ( string strPath1, ArrayList &movies, int limit ) : void
GetRandomMoviesByUserGroup ( string strUserGroup, ArrayList &movies, int limit ) : void
GetRandomMoviesByYear ( string strYear, ArrayList &movies, int limit ) : void
GetResults ( string sql ) : SQLite.NET.SQLiteResultSet
GetRoleByMovieAndActorId ( int lMovieId, int lActorId ) : string
GetTitleBDId ( int iFileId, byte &resumeData ) : int
GetUserGroupById ( int groupId ) : string
GetUserGroupDescriptionById ( int groupId ) : string
GetUserGroupId ( string userGroup ) : int
GetUserGroupRule ( string group ) : string
GetUserGroupWatchedStatus ( int group, int &percent ) : bool
GetUserGroupWatchedStatus ( string group, int &percent ) : bool
GetUserGroups ( ArrayList userGroups ) : void
GetUserGroupsForMovie ( int lMovieId ) : string
GetUserRatingForMovie ( int lMovieId ) : int
GetUserRatingForMovie ( string lIMDBNumber ) : int
GetVideoDuration ( int iFileId ) : int
GetVideoFiles ( string path, ArrayList &availableFiles ) : void
GetVideoFilesMediaInfo ( string strFilenameAndPath, MediaPortal.Video.Database.VideoFilesMediaInfo &mediaInfo, bool refresh ) : void
GetYears ( ArrayList years ) : void
HasMediaInfo ( string fileName ) : bool
HasMovieInfo ( string strFilenameAndPath ) : bool
HasSubtitle ( string strFilenameAndPath ) : bool
ImportNfo ( string nfoFile, bool skipExisting, bool refreshdbOnly ) : void
ImportNfoUsingVideoFile ( string videoFile, bool skipExisting, bool refreshdbOnly ) : void
IsVideoThumbBlacklisted ( string path ) : bool
MakeNfo ( int movieId ) : bool
MovieWatchedCountIncrease ( int idMovie ) : void

Increase times watched by 1
RemoveActorInfoMovie ( int actorId ) : void
RemoveActorsForMovie ( int lMovieId ) : void
RemoveAllVideoThumbBlacklistEntries ( ) : void
RemoveCollectionFromMovie ( int lMovieId, int lCollectionId ) : void
RemoveCollectionsForMovie ( int lMovieId ) : void
RemoveExpiredVideoThumbBlacklistEntries ( ) : void
RemoveFilesForMovie ( int lMovieId ) : void
RemoveGenresForMovie ( int lMovieId ) : void
RemoveUserGroupFromMovie ( int lMovieId, int lUserGroupId ) : void
RemoveUserGroupRule ( string groupName ) : void
RemoveUserGroupsForMovie ( int lMovieId ) : void
RevertFlushTransactionsToDisk ( ) : void
SetActorInfo ( int idActor, MediaPortal.Video.Database.IMDBActor actor ) : void
SetDVDLabel ( int lMovieId, string strDVDLabel1 ) : void
SetDateWatched ( IMDBMovie details ) : void
SetFanartURL ( int lMovieId, string fanartURL ) : void
SetMovieDuration ( int iMovieId, int duration ) : void
SetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : void
SetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
SetMovieInfoById ( int lMovieId, IMDBMovie &details, bool updateTimeStamp ) : void
SetMovieStopTime ( int iFileId, int stoptime ) : void
SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData ) : void

Deprecated Method (this one will not use the new Blu-ray Title mode resume)
SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData, int bdtitle ) : void
SetMovieWatchedCount ( int movieId, int watchedCount ) : void
SetMovieWatchedStatus ( int idMovie, bool watched, int percent ) : void
SetThumbURL ( int lMovieId, string thumbURL ) : void
SetUserRatingForMovie ( int lMovieId, int lUserRating ) : void
SetVideoDuration ( int iFileId, int duration ) : void
SetWatched ( IMDBMovie details ) : void
UpdateCDLabel ( IMDBMovie movieDetails, string CDlabel ) : void
VideoDatabaseSqlLite ( ) : System
VideoThumbBlacklist ( string path, System.DateTime expiresOn ) : int
VideoThumbRemoveFromBlacklist ( string path ) : bool

Private Methods

Method Description
CheckActorByName ( string strActorName ) : int
CheckMediaInfo ( string file, string fullPathFilename, int pathID, int fileID, bool refresh ) : void
CreateCovers ( string titleExt, string coverImage, IMDBMovie movie ) : void
CreateTables ( ) : void
CreateXmlNode ( XmlNode mainNode, XmlDocument doc, string element, string innerTxt ) : void
DeleteMoviesInFolder ( string strPath ) : void
DeleteSingleMovie ( string strFilenameAndPath ) : void
FromHexString ( string s ) : byte[]
GetFileId ( int movieId ) : int
GetMovie ( string strFilenameAndPath, bool bExact ) : int
GetVideoFilesMediaInfo ( int movieId, MediaPortal.Video.Database.VideoFilesMediaInfo &mediaInfo ) : void
MovieDuration ( ArrayList files ) : int
Open ( ) : void
SetLatestMovieProperties ( ) : void
SetMovieDetails ( IMDBMovie &details, int iRow, SQLite.NET.SQLiteResultSet results ) : void
ToHexString ( byte bytes ) : string
UpgradeDatabase ( ) : void

Method Details

AddActor() public method

public AddActor ( string strActorImdbId, string strActorName ) : int
strActorImdbId string
strActorName string
return int

AddActorInfoMovie() public method

public AddActorInfoMovie ( int idActor, MediaPortal.Video.Database.IMDBActor movie ) : void
idActor int
movie MediaPortal.Video.Database.IMDBActor
return void

AddActorToMovie() public method

public AddActorToMovie ( int lMovieId, int lActorId, string role ) : void
lMovieId int
lActorId int
role string
return void

AddBookMarkToMovie() public method

public AddBookMarkToMovie ( string strFilenameAndPath, float fTime ) : void
strFilenameAndPath string
fTime float
return void

AddCollection() public method

public AddCollection ( string strCollection1 ) : int
strCollection1 string
return int

AddCollectionDescription() public method

public AddCollectionDescription ( string movieCollection, string description ) : void
movieCollection string
description string
return void

AddCollectionToMovie() public method

public AddCollectionToMovie ( int lMovieId, int lCollectionId ) : void
lMovieId int
lCollectionId int
return void

AddFile() public method

public AddFile ( int lMovieId, int lPathId, string strFileName ) : int
lMovieId int
lPathId int
strFileName string
return int

AddGenre() public method

public AddGenre ( string strGenre1 ) : int
strGenre1 string
return int

AddGenreToMovie() public method

public AddGenreToMovie ( int lMovieId, int lGenreId ) : void
lMovieId int
lGenreId int
return void

AddMovie() public method

public AddMovie ( string strFilenameAndPath, bool bHassubtitles ) : int
strFilenameAndPath string
bHassubtitles bool
return int

AddMovieFile() public method

public AddMovieFile ( string strFile ) : int
strFile string
return int

AddPath() public method

public AddPath ( string strPath ) : int
strPath string
return int

AddUserGroup() public method

public AddUserGroup ( string userGroup ) : int
userGroup string
return int

AddUserGroupDescription() public method

public AddUserGroupDescription ( string userGroup, string description ) : void
userGroup string
description string
return void

AddUserGroupRuleByGroupId() public method

public AddUserGroupRuleByGroupId ( int groupId, string rule ) : void
groupId int
rule string
return void

AddUserGroupRuleByGroupName() public method

public AddUserGroupRuleByGroupName ( string groupName, string rule ) : void
groupName string
rule string
return void

AddUserGroupToMovie() public method

public AddUserGroupToMovie ( int lMovieId, int lUserGroupId ) : void
lMovieId int
lUserGroupId int
return void

CheckActorImdbId() public method

public CheckActorImdbId ( string id ) : bool
id string
return bool

CheckMovieImdbId() public method

public CheckMovieImdbId ( string id ) : bool
id string
return bool

ClearBookMarksOfMovie() public method

public ClearBookMarksOfMovie ( string strFilenameAndPath ) : void
strFilenameAndPath string
return void

DeleteActor() public method

public DeleteActor ( string actorImdbId ) : void
actorImdbId string
return void

DeleteActorFromMovie() public method

public DeleteActorFromMovie ( int movieId, int actorId ) : void
movieId int
actorId int
return void

DeleteCollection() public method

public DeleteCollection ( string collection ) : void
collection string
return void

DeleteEmptyCollections() public method

public DeleteEmptyCollections ( ) : void
return void

DeleteFile() public method

public DeleteFile ( int iFileId ) : void
iFileId int
return void

DeleteGenre() public method

public DeleteGenre ( string genre ) : void
genre string
return void

DeleteMovie() public method

public DeleteMovie ( string strFilenameAndPath ) : void
strFilenameAndPath string
return void

DeleteMovieInfo() public method

public DeleteMovieInfo ( string strFileNameAndPath ) : void
strFileNameAndPath string
return void

DeleteMovieInfoById() public method

public DeleteMovieInfoById ( long lMovieId ) : void
lMovieId long
return void

DeleteMovieStopTime() public method

public DeleteMovieStopTime ( int iFileId ) : void
iFileId int
return void

DeleteUserGroup() public method

public DeleteUserGroup ( string userGroup ) : void
userGroup string
return void

Dispose() public method

public Dispose ( ) : void
return void

ExecuteRuleSQL() public method

public ExecuteRuleSQL ( string strSql, string fieldName, bool &error, string &errorMessage ) : ArrayList
strSql string
fieldName string
error bool
errorMessage string
return System.Collections.ArrayList

ExecuteSQL() public method

public ExecuteSQL ( string strSql, bool &error, string &errorMessage ) : void
strSql string
error bool
errorMessage string
return void

FlushTransactionsToDisk() public method

public FlushTransactionsToDisk ( ) : void
return void

GetActorByName() public method

public GetActorByName ( string strActorName, ArrayList actors ) : void
strActorName string
actors System.Collections.ArrayList
return void

GetActorImdbId() public method

public GetActorImdbId ( int idActor ) : string
idActor int
return string

GetActorInfo() public method

public GetActorInfo ( int idActor ) : MediaPortal.Video.Database.IMDBActor
idActor int
return MediaPortal.Video.Database.IMDBActor

GetActorNameById() public method

public GetActorNameById ( int actorId ) : string
actorId int
return string

GetActors() public method

public GetActors ( ArrayList actors ) : void
actors System.Collections.ArrayList
return void

GetActorsByMovieID() public method

public GetActorsByMovieID ( int idMovie, ArrayList &actorsByMovieID ) : void
idMovie int
actorsByMovieID System.Collections.ArrayList
return void

GetBookMarksForMovie() public method

public GetBookMarksForMovie ( string strFilenameAndPath, ArrayList &bookmarks ) : void
strFilenameAndPath string
bookmarks System.Collections.ArrayList
return void

GetCollectionById() public method

public GetCollectionById ( int collectionId ) : string
collectionId int
return string

GetCollectionDescriptionById() public method

public GetCollectionDescriptionById ( int collectionId ) : string
collectionId int
return string

GetCollectionId() public method

public GetCollectionId ( string movieCollection ) : int
movieCollection string
return int

GetCollections() public method

public GetCollections ( ArrayList collections ) : void
collections System.Collections.ArrayList
return void

GetCollectionsForMovie() public method

public GetCollectionsForMovie ( int lMovieId ) : string
lMovieId int
return string

GetDVDLabel() public method

public GetDVDLabel ( string strFile ) : string
strFile string
return string

GetFile() public method

public GetFile ( string strFilenameAndPath, int &lPathId, int &lMovieId, bool bExact ) : int
strFilenameAndPath string
lPathId int
lMovieId int
bExact bool
return int

GetFileId() public method

public GetFileId ( string strFilenameAndPath ) : int
strFilenameAndPath string
return int

GetFilesForMovie() public method

public GetFilesForMovie ( int lMovieId, ArrayList &files ) : void
lMovieId int
files System.Collections.ArrayList
return void

GetGenreById() public method

public GetGenreById ( int genreId ) : string
genreId int
return string

GetGenres() public method

public GetGenres ( ArrayList genres ) : void
genres System.Collections.ArrayList
return void

GetGenresForMovie() public method

public GetGenresForMovie ( int lMovieId ) : string
lMovieId int
return string

GetIndexByFilter() public method

public GetIndexByFilter ( string sql, bool filterNonWordChar, ArrayList &movieList ) : void
sql string
filterNonWordChar bool
movieList System.Collections.ArrayList
return void

GetMovieCollectionWatchedStatus() public method

public GetMovieCollectionWatchedStatus ( int collection, int &percent ) : bool
collection int
percent int
return bool

GetMovieCollectionWatchedStatus() public method

public GetMovieCollectionWatchedStatus ( string collection, int &percent ) : bool
collection string
percent int
return bool

GetMovieCollections() public method

public GetMovieCollections ( int lMovieId, ArrayList movieCollections ) : void
lMovieId int
movieCollections System.Collections.ArrayList
return void

GetMovieDuration() public method

public GetMovieDuration ( int iMovieId ) : int
iMovieId int
return int

GetMovieGenres() public method

public GetMovieGenres ( int lMovieId, ArrayList movieGenres ) : void
lMovieId int
movieGenres System.Collections.ArrayList
return void

GetMovieId() public method

public GetMovieId ( string strFilenameAndPath ) : int
strFilenameAndPath string
return int

GetMovieInfo() public method

public GetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : int
strFilenameAndPath string
details IMDBMovie
return int

GetMovieInfoById() public method

public GetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
lMovieId int
details IMDBMovie
return void

GetMovieStopTime() public method

public GetMovieStopTime ( int iFileId ) : int
iFileId int
return int

GetMovieStopTimeAndResumeData() public method

Deprecated Method (this one will not use the new Blu-ray Title mode resume)
public GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData ) : int
iFileId int
resumeData byte
return int

GetMovieStopTimeAndResumeData() public method

public GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData, int bdtitle ) : int
iFileId int
resumeData byte
bdtitle int
return int

GetMovieTitlesByActor() public method

public GetMovieTitlesByActor ( int actorId ) : string
actorId int
return string

GetMovieTitlesByCollection() public method

public GetMovieTitlesByCollection ( string strCollection ) : string
strCollection string
return string

GetMovieTitlesByDirector() public method

public GetMovieTitlesByDirector ( int directorId ) : string
directorId int
return string

GetMovieTitlesByGenre() public method

public GetMovieTitlesByGenre ( string strGenre ) : string
strGenre string
return string

GetMovieTitlesByIndex() public method

public GetMovieTitlesByIndex ( string sql ) : string
sql string
return string

GetMovieTitlesByUserGroup() public method

public GetMovieTitlesByUserGroup ( int idGroup ) : string
idGroup int
return string

GetMovieTitlesByYear() public method

public GetMovieTitlesByYear ( string strYear ) : string
strYear string
return string

GetMovieUserGroups() public method

public GetMovieUserGroups ( int movieId, ArrayList userGroups ) : void
movieId int
userGroups System.Collections.ArrayList
return void

GetMovieWatchedStatus() public method

public GetMovieWatchedStatus ( int idMovie, int &percent, int &timesWatched ) : bool
idMovie int
percent int
timesWatched int
return bool

GetMovies() public method

public GetMovies ( ArrayList &movies ) : void
movies System.Collections.ArrayList
return void

GetMoviesByActor() public method

public GetMoviesByActor ( string strActor1, ArrayList &movies ) : void
strActor1 string
movies System.Collections.ArrayList
return void

GetMoviesByCollection() public method

public GetMoviesByCollection ( string strCollection1, ArrayList &movies ) : void
strCollection1 string
movies System.Collections.ArrayList
return void

GetMoviesByFilter() public method

Deprecated Method (use GetMoviesByFilter with Movie Collection)
public GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable ) : void
sql string
movies System.Collections.ArrayList
actorTable bool
movieinfoTable bool
genreTable bool
usergroupTable bool
return void

GetMoviesByFilter() public method

public GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable, bool collectionTable ) : void
sql string
movies System.Collections.ArrayList
actorTable bool
movieinfoTable bool
genreTable bool
usergroupTable bool
collectionTable bool
return void

GetMoviesByGenre() public method

public GetMoviesByGenre ( string strGenre1, ArrayList &movies ) : void
strGenre1 string
movies System.Collections.ArrayList
return void

GetMoviesByPath() public method

public GetMoviesByPath ( string strPath1, ArrayList &movies ) : void
strPath1 string
movies System.Collections.ArrayList
return void

GetMoviesByUserGroup() public method

public GetMoviesByUserGroup ( string strUserGroup, ArrayList &movies ) : void
strUserGroup string
movies System.Collections.ArrayList
return void

GetMoviesByYear() public method

public GetMoviesByYear ( string strYear, ArrayList &movies ) : void
strYear string
movies System.Collections.ArrayList
return void

GetPath() public method

public GetPath ( string strPath ) : int
strPath string
return int

GetRandomMoviesByActor() public method

public GetRandomMoviesByActor ( string strActor1, ArrayList &movies, int limit ) : void
strActor1 string
movies System.Collections.ArrayList
limit int
return void

GetRandomMoviesByCollection() public method

public GetRandomMoviesByCollection ( string strCollection1, ArrayList &movies, int limit ) : void
strCollection1 string
movies System.Collections.ArrayList
limit int
return void

GetRandomMoviesByGenre() public method

public GetRandomMoviesByGenre ( string strGenre1, ArrayList &movies, int limit ) : void
strGenre1 string
movies System.Collections.ArrayList
limit int
return void

GetRandomMoviesByPath() public method

public GetRandomMoviesByPath ( string strPath1, ArrayList &movies, int limit ) : void
strPath1 string
movies System.Collections.ArrayList
limit int
return void

GetRandomMoviesByUserGroup() public method

public GetRandomMoviesByUserGroup ( string strUserGroup, ArrayList &movies, int limit ) : void
strUserGroup string
movies System.Collections.ArrayList
limit int
return void

GetRandomMoviesByYear() public method

public GetRandomMoviesByYear ( string strYear, ArrayList &movies, int limit ) : void
strYear string
movies System.Collections.ArrayList
limit int
return void

GetResults() public method

public GetResults ( string sql ) : SQLite.NET.SQLiteResultSet
sql string
return SQLite.NET.SQLiteResultSet

GetRoleByMovieAndActorId() public method

public GetRoleByMovieAndActorId ( int lMovieId, int lActorId ) : string
lMovieId int
lActorId int
return string

GetTitleBDId() public method

public GetTitleBDId ( int iFileId, byte &resumeData ) : int
iFileId int
resumeData byte
return int

GetUserGroupById() public method

public GetUserGroupById ( int groupId ) : string
groupId int
return string

GetUserGroupDescriptionById() public method

public GetUserGroupDescriptionById ( int groupId ) : string
groupId int
return string

GetUserGroupId() public method

public GetUserGroupId ( string userGroup ) : int
userGroup string
return int

GetUserGroupRule() public method

public GetUserGroupRule ( string group ) : string
group string
return string

GetUserGroupWatchedStatus() public method

public GetUserGroupWatchedStatus ( int group, int &percent ) : bool
group int
percent int
return bool

GetUserGroupWatchedStatus() public method

public GetUserGroupWatchedStatus ( string group, int &percent ) : bool
group string
percent int
return bool

GetUserGroups() public method

public GetUserGroups ( ArrayList userGroups ) : void
userGroups System.Collections.ArrayList
return void

GetUserGroupsForMovie() public method

public GetUserGroupsForMovie ( int lMovieId ) : string
lMovieId int
return string

GetUserRatingForMovie() public method

public GetUserRatingForMovie ( int lMovieId ) : int
lMovieId int
return int

GetUserRatingForMovie() public method

public GetUserRatingForMovie ( string lIMDBNumber ) : int
lIMDBNumber string
return int

GetVideoDuration() public method

public GetVideoDuration ( int iFileId ) : int
iFileId int
return int

GetVideoFiles() public method

public GetVideoFiles ( string path, ArrayList &availableFiles ) : void
path string
availableFiles System.Collections.ArrayList
return void

GetVideoFilesMediaInfo() public method

public GetVideoFilesMediaInfo ( string strFilenameAndPath, MediaPortal.Video.Database.VideoFilesMediaInfo &mediaInfo, bool refresh ) : void
strFilenameAndPath string
mediaInfo MediaPortal.Video.Database.VideoFilesMediaInfo
refresh bool
return void

GetYears() public method

public GetYears ( ArrayList years ) : void
years System.Collections.ArrayList
return void

HasMediaInfo() public method

public HasMediaInfo ( string fileName ) : bool
fileName string
return bool

HasMovieInfo() public method

public HasMovieInfo ( string strFilenameAndPath ) : bool
strFilenameAndPath string
return bool

HasSubtitle() public method

public HasSubtitle ( string strFilenameAndPath ) : bool
strFilenameAndPath string
return bool

ImportNfo() public method

public ImportNfo ( string nfoFile, bool skipExisting, bool refreshdbOnly ) : void
nfoFile string
skipExisting bool
refreshdbOnly bool
return void

ImportNfoUsingVideoFile() public method

public ImportNfoUsingVideoFile ( string videoFile, bool skipExisting, bool refreshdbOnly ) : void
videoFile string
skipExisting bool
refreshdbOnly bool
return void

IsVideoThumbBlacklisted() public method

public IsVideoThumbBlacklisted ( string path ) : bool
path string
return bool

MakeNfo() public method

public MakeNfo ( int movieId ) : bool
movieId int
return bool

MovieWatchedCountIncrease() public method

Increase times watched by 1
public MovieWatchedCountIncrease ( int idMovie ) : void
idMovie int
return void

RemoveActorInfoMovie() public method

public RemoveActorInfoMovie ( int actorId ) : void
actorId int
return void

RemoveActorsForMovie() public method

public RemoveActorsForMovie ( int lMovieId ) : void
lMovieId int
return void

RemoveAllVideoThumbBlacklistEntries() public method

public RemoveAllVideoThumbBlacklistEntries ( ) : void
return void

RemoveCollectionFromMovie() public method

public RemoveCollectionFromMovie ( int lMovieId, int lCollectionId ) : void
lMovieId int
lCollectionId int
return void

RemoveCollectionsForMovie() public method

public RemoveCollectionsForMovie ( int lMovieId ) : void
lMovieId int
return void

RemoveExpiredVideoThumbBlacklistEntries() public method

public RemoveExpiredVideoThumbBlacklistEntries ( ) : void
return void

RemoveFilesForMovie() public method

public RemoveFilesForMovie ( int lMovieId ) : void
lMovieId int
return void

RemoveGenresForMovie() public method

public RemoveGenresForMovie ( int lMovieId ) : void
lMovieId int
return void

RemoveUserGroupFromMovie() public method

public RemoveUserGroupFromMovie ( int lMovieId, int lUserGroupId ) : void
lMovieId int
lUserGroupId int
return void

RemoveUserGroupRule() public method

public RemoveUserGroupRule ( string groupName ) : void
groupName string
return void

RemoveUserGroupsForMovie() public method

public RemoveUserGroupsForMovie ( int lMovieId ) : void
lMovieId int
return void

RevertFlushTransactionsToDisk() public method

public RevertFlushTransactionsToDisk ( ) : void
return void

SetActorInfo() public method

public SetActorInfo ( int idActor, MediaPortal.Video.Database.IMDBActor actor ) : void
idActor int
actor MediaPortal.Video.Database.IMDBActor
return void

SetDVDLabel() public method

public SetDVDLabel ( int lMovieId, string strDVDLabel1 ) : void
lMovieId int
strDVDLabel1 string
return void

SetDateWatched() public method

public SetDateWatched ( IMDBMovie details ) : void
details IMDBMovie
return void

SetFanartURL() public method

public SetFanartURL ( int lMovieId, string fanartURL ) : void
lMovieId int
fanartURL string
return void

SetMovieDuration() public method

public SetMovieDuration ( int iMovieId, int duration ) : void
iMovieId int
duration int
return void

SetMovieInfo() public method

public SetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : void
strFilenameAndPath string
details IMDBMovie
return void

SetMovieInfoById() public method

public SetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
lMovieId int
details IMDBMovie
return void

SetMovieInfoById() public method

public SetMovieInfoById ( int lMovieId, IMDBMovie &details, bool updateTimeStamp ) : void
lMovieId int
details IMDBMovie
updateTimeStamp bool
return void

SetMovieStopTime() public method

public SetMovieStopTime ( int iFileId, int stoptime ) : void
iFileId int
stoptime int
return void

SetMovieStopTimeAndResumeData() public method

Deprecated Method (this one will not use the new Blu-ray Title mode resume)
public SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData ) : void
iFileId int
stoptime int
resumeData byte
return void

SetMovieStopTimeAndResumeData() public method

public SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData, int bdtitle ) : void
iFileId int
stoptime int
resumeData byte
bdtitle int
return void

SetMovieWatchedCount() public method

public SetMovieWatchedCount ( int movieId, int watchedCount ) : void
movieId int
watchedCount int
return void

SetMovieWatchedStatus() public method

public SetMovieWatchedStatus ( int idMovie, bool watched, int percent ) : void
idMovie int
watched bool
percent int
return void

SetThumbURL() public method

public SetThumbURL ( int lMovieId, string thumbURL ) : void
lMovieId int
thumbURL string
return void

SetUserRatingForMovie() public method

public SetUserRatingForMovie ( int lMovieId, int lUserRating ) : void
lMovieId int
lUserRating int
return void

SetVideoDuration() public method

public SetVideoDuration ( int iFileId, int duration ) : void
iFileId int
duration int
return void

SetWatched() public method

public SetWatched ( IMDBMovie details ) : void
details IMDBMovie
return void

UpdateCDLabel() public method

public UpdateCDLabel ( IMDBMovie movieDetails, string CDlabel ) : void
movieDetails IMDBMovie
CDlabel string
return void

VideoDatabaseSqlLite() public method

public VideoDatabaseSqlLite ( ) : System
return System

VideoThumbBlacklist() public method

public VideoThumbBlacklist ( string path, System.DateTime expiresOn ) : int
path string
expiresOn System.DateTime
return int

VideoThumbRemoveFromBlacklist() public method

public VideoThumbRemoveFromBlacklist ( string path ) : bool
path string
return bool

Property Details

m_db public_oe property

public SQLiteClient,SQLite.NET m_db
return SQLite.NET.SQLiteClient