Does anyone know if there is any documentation as to the structure of the database, the relationships of the tables, etc?
I ask because I am in the process of writing a plugin that will parse the database to get the relevant information that it needs, but am unsure as to where to begin in the database.
IE: I could easily just pull the data from movingpictures.movie_info to get the titles, actors, etc, but where I am running into problems is trying to figure out where in the database the information is stored as to how many parts (files) the movie consists of? For instance, I have the movie "The 40 Year Old Virgn", which is in 2 files, part 1 and part2...but, I am unable to find anything that states Movie ID 1 has 2 parts (granted, i know it would not be worded out like that, heh).
Can anyone offer any assistance on what table I should be looking into?
Jason
I ask because I am in the process of writing a plugin that will parse the database to get the relevant information that it needs, but am unsure as to where to begin in the database.
IE: I could easily just pull the data from movingpictures.movie_info to get the titles, actors, etc, but where I am running into problems is trying to figure out where in the database the information is stored as to how many parts (files) the movie consists of? For instance, I have the movie "The 40 Year Old Virgn", which is in 2 files, part 1 and part2...but, I am unable to find anything that states Movie ID 1 has 2 parts (granted, i know it would not be worded out like that, heh).
Can anyone offer any assistance on what table I should be looking into?
Jason
United States of America