From: Arun Persaud <arun@nubati.net>
Date: Wed, 8 Dec 2010 17:13:25 +0000 (-0800)
Subject: fixed path problem (missing "/")
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=commitdiff_plain;h=refs%2Fheads%2Fmaster;hp=21e5440db59e4ee3ba71c3a8935a123cc48aea46

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 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