Database en
From Ultimate Media Collector (UMC) - Wiki
The UMC-database is located in „path\UMC\database\UMC.db“ and can be opened with e.g. SQLiteSpy (http://sqlitespy.soft-ware.net/download.asp)!
Here you can see the inserted movie information or you can execute SQL statements.
e.g.:
SELECT MA.FILENAME AS Dateiname, ML.MOVIE_NAME_DEUTSCH AS Filmtitel, MA.ONLINE_ID AS OFDB_ID, MA.IMDB_ID AS IMDB_Nr, MT.DEUTSCH AS Typ, MA.ID_MOVIE AS ID FROM MOVIE_ALL MA, MOVIE_LANGUAGE ML, MOVIE_TYPE MT WHERE MA.DELETED IS NULL AND ML.DELETED IS NULL AND MA.ID_MOVIE=ML.ID_MOVIE AND MA.MOVIE_TYPE=MT.MOVIE_TYPE ORDER BY MA.FILENAME;
and use menu "Execute" -> "Execute SQL"!
or
SELECT MA.FILENAME AS Dateiname_Film, ML.MOVIE_NAME_DEUTSCH AS Filmtitel, MT.DEUTSCH AS Film_Typ, MSD.PC_DIR AS Pfad_zur_Bilddatei, MP.PICTURE AS Bilddatei, MPT.DEUTSCH AS Bild_Typ, MA.ID_MOVIE FROM MOVIE_ALL MA LEFT JOIN MOVIE_PICTURE MP, MOVIE_PICTURE_TYPE MPT, MOVIE_SCAN_DIR MSD, MOVIE_LANGUAGE ML, MOVIE_TYPE MT ON MA.ID_MOVIE=MP.ID_MOVIE AND MP.ID_PICTURE_TYPE=MPT.ID_PICTURE_TYPE AND MP.ID_DIR=MSD.ID_DIR AND MA.ID_MOVIE=ML.ID_MOVIE AND MA.MOVIE_TYPE=MT.MOVIE_TYPE AND MA.DELETED IS NULL AND MP.DELETED IS NULL ORDER BY MA.FILENAME;
and use menu "Execute" –> "Execute SQL Line"!
Or you can simply look into the tables to see all your scanned movies.
Increase priority for actor visualization:
Since version 1.3 can increase visualization priority of actors so you will see them on the moviedetail page on top.
Higher value means higher priority!
And so you can use it (in this example we will increase the priority of Samuel L. Jackson):
Lock movies in database!
To lock movies works nearly the same as increase actor-priority.
To lock one movie:
UPDATE "MOVIE_ALL" SET LOCKED=1 WHERE Filename='Filmname.iso'
Lock all movies:
UPDATE "MOVIE_ALL" SET LOCKED=1
