hi
Yes basically all i did was replace the like '%.jpg' with like '%.gif' , but no matter wot i added into the equation with and like '%.jpg' and or like '%.jpg' i couldnt get it to work with both jpg and gif in the equation. But then again im no coder or programmer and my php is basic at the best of times But im sure itll be no match for you In your own time will be fine as ive said my gallery will only be at the mo .gifs but l8r on i will be using jpg aswell. So any time you have to try to sort it would be appreciated. I was thinking is it possible to have a drop down of choice for the extension in the config screen, a couple of choices ie jpg or gif or jpg/gif or all the extensions available in coppermine itself ? I will leave that in your capable hands
thanx
Dessy
I had noticed before that the Image Scroller didn't display .gifs, but never bothered to figure out why, I just assumed it was a licensing thing. Anyhow, with your pointers above, I've chagned the query to include both .gif & .jpg, but the image scroller doesn't seem to be able to apply transparency to transparent gifs.
use this:
$result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE (filename LIKE '%.jpg' or filename LIKE '%.gif') AND filename not like 'youtube_%' $FORBIDDEN_SET $this_meta LIMIT $i_count");
if you wanted .png as well, use the following, but I've not tested this yet.
$result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE (filename LIKE '%.jpg' OR filename LIKE '%.gif' OR filename LIKE '%.png') AND filename not like 'youtube_%' $FORBIDDEN_SET $this_meta LIMIT $i_count");
You can see what happens with transparent gif's at
http://pics.nhgc.asn.au/.
Dawson