Griffith - media collection manager
May 21, 2012, 06:26:36 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: New mailing lists,
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: poster url in db?  (Read 718 times)
mroh
Newbie
*
Offline Offline

Posts: 2


View Profile
« on: November 17, 2010, 05:22:56 PM »

Thank you very much for this great and useful prg!

I use griffith with mysql and hacked a little php script to browse/search it via http.
Currently the images/posters are linked in the filesystem from griffith into the webspace, but I dont like this for several reasons...

I looked around in the db schema and the images are also in the posters.data table, so i can write a little blob script...

But for me it would be way better (eg saving bandwith) to link to the orginal image, just where all the /lib/plugins/movie scripts are getting the image from and write the blob.
I looked around in the code of these scripts and they of course know the url, but they dont seem to write the url into the db!?
Is this correct?

The column movies.image is always null, maybe this can be used to write the orginal url?

Ah, I use griffith from the svn trunk...
Logged
mike
Global Moderator
Hero Member
*****
Offline Offline

Posts: 996


View Profile WWW
« Reply #1 on: November 21, 2010, 08:35:46 PM »

Since version 0.10 the posters are stored in db. The poster directory is only a temporary storage for displaying purposes.
You can savily remove the directory and griffith rebuilds it silently with the next start of the app or the next access to an image.

And you are right. The original poster url is never saved in the database. It is only used to load the picture. The binary data is
always saved. The column you found is a deprecated, unused column in the current version. It was used before version 0.10 to
save the local path of the image within the poster directory.

I'm not sure if it would make sense to store the original image url. The url can change anytime.
But if you really want it I can try to provide a patch for you. I don't want to add that functionality to the official trunk.
I don't think that such a function is generally needed.
Logged
mroh
Newbie
*
Offline Offline

Posts: 2


View Profile
« Reply #2 on: November 22, 2010, 08:07:11 PM »

Hi mike,

thank you very much for replying and your help.

I think you are right, that functionality isnt generally needed, but it cant hurt either, esp. if that column isnt used anyway.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!