fixed path problem (missing "/")

the latest version in the database seems to save a path without the trailing slash

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 111b03ef0e641129353ae4b5d3ff562d92d1f713..f611391ae044ed2a234ef942ab622bd009c287b9 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -523,7 +523,7 @@ class PHPFSPOT {
             $query_str = "
                SELECT
                   p.id as id,
             $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
                   p.time as time,
                   p.description as description,
                   p.rating as rating


@@ -596,7 +596,7 @@ class PHPFSPOT {
                SELECT
                   version_id,
                   name,
                SELECT
                   version_id,
                   name,

-                  base_uri || filename as uri
+                  base_uri || '/'||filename as uri

                FROM
                   photo_versions
                WHERE
                FROM
                   photo_versions
                WHERE