X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=blobdiff_plain;f=phpfspot.class.php;h=f611391ae044ed2a234ef942ab622bd009c287b9;hp=111b03ef0e641129353ae4b5d3ff562d92d1f713;hb=HEAD;hpb=21e5440db59e4ee3ba71c3a8935a123cc48aea46 diff --git a/phpfspot.class.php b/phpfspot.class.php index 111b03e..f611391 100644 --- a/phpfspot.class.php +++ b/phpfspot.class.php @@ -523,7 +523,7 @@ class PHPFSPOT { $query_str = " SELECT p.id as id, - p.base_uri || p.filename as uri, + p.base_uri ||'/'|| p.filename as uri, p.time as time, p.description as description, p.rating as rating @@ -596,7 +596,7 @@ class PHPFSPOT { SELECT version_id, name, - base_uri || filename as uri + base_uri || '/'||filename as uri FROM photo_versions WHERE