Griffith - media collection manager
May 21, 2012, 06:26:36 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: New
mailing lists
,
Home
Help
Search
Login
Register
Griffith - media collection manager
>
English
>
Support
>
poster url in db?
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: poster url in db? (Read 718 times)
mroh
Newbie
Offline
Posts: 2
poster url in db?
«
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
Posts: 996
Re: poster url in db?
«
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
Posts: 2
Re: poster url in db?
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> General Discussion
-----------------------------
English
-----------------------------
=> Support
=> Wish list
-----------------------------
Polish
-----------------------------
=> Wsparcie techniczne
=> Propozycje
-----------------------------
Portugu
-----------------------------
=> Suporte t
=> Sugest
-----------------------------
German
-----------------------------
=> Wunschliste
=> Unterst?tzung
Loading...