I think the db relationships for the pictures are as follows:
* Each media file has an entry in pluto_media.File.
* Each entry has a primary key (identifier), PK_File.
* Each picture has an entry in pluto_media.Picture.
* Each picture has a primary key, PK_Picture.
* Each media file and picture are joined with the pluto_media.Picture_File table. This table consists mainly of two foreign key columns, FK_File and FK_Picture (foreign keys contain the values of primary keys in their respective tables).
* Each media picture resides in /home/mediapics directory.
* Each media picture consists of two images, the "full" and a "thumbnail".
* "full" images are named: {PK_Picture}.jpg (example for PK_Picture of 123, the file would be /home/mediapics/123.jpg)
* "thumbnail" images are named {PK_Picture}_tn.jpg (example for PK_Picture of 123, the file would be /home/mediapics/123_tn.jpg)
* I have not found the image size constraints on the "full" image, sorry.
* The "thumbnail" image size is 256x256.
* It is the "thumbnail" image that is displayed in the orbiter.
OK, background out of the way.
Now what you can do is look up the File record, get the PK_File value. Then look up the PK_Picture id in the Picture_File table. Now with the PK_Picture id, you can check to see if the jpg images (both "full" and "thumbnail") exist in the /home/mediapics directory.
Here's an example where I look up "The Fifth Element" dvd on my system:
linuxmce@dcerouter:~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14214
Server version: 5.0.45-Debian_1ubuntu3 Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use pluto_media;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select PK_File from File where Filename='The Fifth Element.dvd';
+---------+
| PK_File |
+---------+
| 983 |
+---------+
1 row in set (0.00 sec)
mysql> select FK_Picture from Picture_File where FK_File=983;
+------------+
| FK_Picture |
+------------+
| 530 |
+------------+
1 row in set (0.01 sec)
mysql> quit
Bye
linuxmce@dcerouter:~$ ls -l /home/mediapics/530*
-rw-r--r-- 1 root root 70874 2008-05-30 03:23 /home/mediapics/530.jpg
-rw-r--r-- 1 root root 11887 2008-05-30 03:23 /home/mediapics/530_tn.jpg
If the files exist, you can verify their integrity by viewing them with firefox or whatever your favorite image viewer is.
HTH,
Roy
