Connect to databases (1 Viewer)

[LRFalk01]

As far as i can tell. MP uses some kind of SQL to store the information for Videos, Music, etc. Does anyone know how to connect to this database? I am wanting to make a php script to list this stuff on a web page to be viewable remotely.

 

[mbuzina]

The databases (used with TVEngine 2) are SQLite Database, to which you can not connect, but which can be opened. Have a look in the database folder of your MP installation dir.

I do not know if there is a sqlite client for php, but it could be so. There is also the SQLite Database browser installed (somewhere).

 

[GoldenEye]

in ..\MediaPortal\Docs\ --> SQLite Database Browser.exe

G.

 

[LRFalk01]

This is exactly what i needed to see the table structure. Thanks GoldenEye.