The current query method is this:
$result = query_single_row(' SELECT EXIFOrientation FROM '.prefix('images').' AS i, '.prefix('albums').' AS a WHERE i.albumid = a.id');
which returns all EXIFOrientation entries, then selects the first. Since the unique image ID does not appear to be available to this function, I have passed $imgfile containing the full file path. Then queried based on $imgfile containing the album directory and image filename.
function getImageRotation($imgfile) { $result = query_single_row(' SELECT EXIFOrientation FROM '.prefix('images').' AS i JOIN '.prefix('albums').' as a ON i.albumid = a.id WHERE "'.$imgfile.'" LIKE CONCAT("%",a.folder,"/",i.filename)');
This should return a unique result.
Disclaimer: I'm no pro so some of this may be wrong.
-Luke