How I can find the image ID if the image is requested directly?

[TigerClaw]

I'm trying to realize this:

A visitors ask directly an image like:

http://coppergallery/albums/test/image.jpg

Can I understand the pos number related to that image, which is needed by displayimage?

http://coppermine-gallery.net/demo/cpg14x/displayimage.php?pos=-361

1) Is it possible to pass direclty the image file to displayimage?

2) If not, I was thinking about taking the image name from the requested url then pass the variable to a php file with the necessary code to make a db query and find the image pos. The problem is I don't know how to write a similar script 

Anyone can help? 

[Nibbler]

I don't understand. If you redirect the file itself to displayimage.php what stops you going into an infinite loop?

[TigerClaw]

I don't understand. If you redirect the file itself to displayimage.php what stops you going into an infinite loop?

Hi Nibbler,

I forgot to add that via htaccess we can check the HTTP Referrer to avoid the infinite loop if the request is generate from the coppermine website.
The displayimage will be requested only if someone is calling the image directly or from another site.

[Nibbler]

What if the referer is empty?

I don't think there is any easy way to do this. You'd need to create a script that looks up the filename to get the pid and hook that into mod_rewrite.

[TigerClaw]

What if the referer is empty?

I don't think there is any easy way to do this. You'd need to create a script that looks up the filename to get the pid and hook that into mod_rewrite.

Do you know what SQL query I have to use to find the pid giving a file name? I do not know much about MySQL query but I can work on the other issues 

[Nibbler]

Code Select Expand

SELECT pid FROM cpg_pictures WHERE filepath = 'filepathfromtheuri' AND filename = 'filenamefromtheuri' LIMIT 1

[TigerClaw]

Code Select Expand

SELECT pid FROM cpg_pictures WHERE filepath = 'filepathfromtheuri' AND filename = 'filenamefromtheuri' LIMIT 1

Thx! I will work on it and I will see what I can do